Mrs. Niehus’s Lesson Plans for December 1-December 5, 2014



MONDAY(Orange)Advisor: Read AR book (10 minutes), Top 20 Lesson; CNN Student News (10 minutes): Homework Check and Complete (10 minutes)6th Computer: Do Now – (5 minutes) “Excel is a program to type information in categories. Have you had to put things into categories before for school? What was it? Describe how you did it and what you did.”/Lesson – Introduce Excel Lesson 1 – Multiple choice quiz – we will read through them and discuss them with partners before the whole class comes together. Introduce Activity for Excel Lesson 1 – do together while I model on the board. /Shared Practice – Students will share what they feel the answers are to their multiple choice quiz./Independent Practice) –Students will create an Excel Worksheet with the teacher./Closure – (Last 5 minutes of class) Share one thing you learned today with your partner.Objectives – Describe the Excel worksheet; Enter text and numbers; Use the Sum button to sum a range of cells; Enter a simple function; Copy the contents of a cell to a range of cells using the fill handle; Apply cell styles; Format cells in a worksheet; Create a 3-D pie chart; Change a worksheet name and worksheet tab color; Change document properties; Preview and print a worksheet; Use the AutoCalculate are to display statistics; Correct errors on a worksheet.TUESDAY(Black)Advisor: Read AR book (10 minutes), Top 20 Lesson; CNN Student News (10 minutes): Homework Check and Complete (10 minutes)8th Computer: Do Now – (5 minutes) “List the skills you remember doing last year. Explain in detail how to do it skill.”/Lesson – Introduction of Excel Lesson 2 – Formulas, Functions, and Formatting: multiple choice questions – find answers in Lesson 2 Excel with page number and then work on activities – we will do the activity together as I model on the board/Shared – Share your journal list /(Independent Practice) – Students will work on Lesson 2 of Excel – multiple choice questions and activities/Closure – (Last 5 minutes of class) What questions do you have about formulas, functions, and formatting in Excel? (Do this as a whole class)Objectives – Enter formulas using the keyboard; Enter formulas using Point mode; Apply the MAX, MIN, and AVERAGE functions; Verify a formula using Range Finder; Apply a theme to a workbook; Apply a date format to a cell or range; Add conditional formatting to cells; Change column width and row height; Check the spelling on a worksheet; Change margins and headers in Page Layout view; Preview and print versions and sections of a worksheetWEDNESDAY(Orange)Advisor: Read AR book (10 minutes), Top 20 Lesson; CNN Student News (10 minutes): Homework Check and Complete (10 minutes)6th Computer: Do Now – “Type to Learn for 10-15 minutes”/Lesson – Review Excel Lesson 1 – Multiple choice quiz. Review and Continue Activity for Excel Lesson 1 – do together while I model on the board. /Shared Practice – Students will share what they learned today as we go along with the lesson./Independent Practice) –Students will continue to create an Excel Worksheet with the teacher./Closure – (Last 5 minutes of class) Share one thing you learned today with your partner.Objectives – Describe the Excel worksheet; Enter text and numbers; Use the Sum button to sum a range of cells; Enter a simple function; Copy the contents of a cell to a range of cells using the fill handle; Apply cell styles; Format cells in a worksheet; Create a 3-D pie chart; Change a worksheet name and worksheet tab color; Change document properties; Preview and print a worksheet; Use the AutoCalculate are to display statistics; Correct errors on a worksheet.THURSDAY(Black)Advisor: Read AR book (10 minutes), Top 20 Lesson; CNN Student News (10 minutes): Homework Check and Complete (10 minutes)8th Computer: Do Now – (5 minutes) “How do you input formulas or functions into an Excel Worksheet?”/Lesson – Review of Excel Lesson 2 – Formulas, Functions, and Formatting: continue with lesson by going onto Apply Your Knowledge and Extend Your Knowledge Activities/Shared – Share with your seat partner your journal; Work together to complete the 2 activities in class (each does their own) /(Independent Practice) – Students will work on Lesson 2 of Excel (Due Today)/ Closure – (Last 5 minutes of class) What is one thing you feel you still need assistance with in these Excel skills? (Do this as a whole class)Objectives – Enter formulas using the keyboard; Enter formulas using Point mode; Apply the MAX, MIN, and AVERAGE functions; Verify a formula using Range Finder; Apply a theme to a workbook; Apply a date format to a cell or range; Add conditional formatting to cells; Change column width and row height; Check the spelling on a worksheet; Change margins and headers in Page Layout view; Preview and print versions and sections of a worksheetFRIDAY(Orange)Advisor: Read AR book (10 minutes), Top 20 Lesson; CNN Student News (10 minutes): Homework Check and Complete (10 minutes)6th Computer: Do Now – “Type to Learn for 10-15 minutes”/Lesson – Review Excel Lesson 1 – Multiple choice quiz. Review and Continue Activity for Excel Lesson 1 – do together while I model on the board. /Shared Practice – Students will share what they learned today as we go along with the lesson./Independent Practice) –Students will continue to create an Excel Worksheet with the teacher./Closure – (Last 5 minutes of class) Share one thing you learned today with your partner.Objectives – Describe the Excel worksheet; Enter text and numbers; Use the Sum button to sum a range of cells; Enter a simple function; Copy the contents of a cell to a range of cells using the fill handle; Apply cell styles; Format cells in a worksheet; Create a 3-D pie chart; Change a worksheet name and worksheet tab color; Change document properties; Preview and print a worksheet; Use the AutoCalculate are to display statistics; Correct errors on a worksheet. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download