 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-26-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.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm
| |
Bell-Ringer/Connecting Strategy
| |
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
Just like in Math, Spreadsheet formulas follow the PEMDAS rule. The letters in PEMDAS stand for the following: P-Parenthesis E-Exponents MD-Multiplication and Division AS-Addition and Subtraction An accounting border has a single line on top and a double line on bottom
Independent Exercise:
| |
@ 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. @ 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