Tuesday, October 27, 2015

Wednesday, October 28th- Spreadsheet Primary and Secondary Sorting



Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 10-28-2015



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets-
Formatting Spreadsheets

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format spreadsheets.
 


Literacy/Vocabulary Strategies (Word Wall)

The Entry bar or formula bar shows the active cell’s information.
It is sometimes called the formula bar because you can see the formula when you click on the active cell
Look at the black border around the active cell D8.
The #####  in cell reference C3 means the cell is too small to show the number, widen the cell.
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
Adding Formulas in Excel.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm

Bell-Ringer/Connecting Strategy

  1. Go to wclassroom.blogspot.com
  2. Get out a pen or pencil
  3. Go to Student Docs- Witkowski folder-Spreadsheet folder-
    Open 1 Spreadsheet Vocabulary file

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)



Guided Practice:
@ Miss W will explain the difference between primary and secondary sort.
@ Miss W will review questions 13 through 19 on worksheet.
 
Independent Exercise:
@ Students will finish questions 13 through 23 on worksheet.

@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.
  An example of a bad review:  I liked it.
  An example of a good review:  The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created.
@ Students will work in pairs to complete the Spreadsheet Review Worksheet.
@ Students will complete a 2nd PowerPoint Critique.



Closure Strategy

Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  

Lesson Reflections


No comments:

Post a Comment