Archdale-Trinity Middle School
Lesson Plan
| |
Date: 02-25-2016
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Cell References and Sorting
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can find and use different features of Excel. TEST ON Wednesday
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Range, Cell Reference, Sorting, Ascending- to go up, Descending
 |
Bell-Ringer/Connecting Strategy
|
1. Open 1 Spreadsheet Vocabulary file.
2. Go to wclassroom.blogspot.com
3. Turn in interim reports by Monday
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
SS Flash cards file (border button and percent button)
Open 31 Formatting Cells
@ Open 19 Hide Worksheet
- right click on tab and choose hide
- right click on tabs before and after the hidden tab and choose unhide.
@ Open 16 Hide and Show Rows
-right click on row number and choose unhide.
- highlight row before and row after the hidden row
and then right click and choose unhide.
Independent Exercise:
Open the Spreadsheet Vocabulary file
Slides 25 through 30 (PEMDAS)
Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula)
|
Higher Order Thinking Questions
|
How do cell references help navigate a spreadsheet?
|
Student Technology/Differentiation
|
Students will use Excel to understand cell references.
|
Closure Strategy
|
We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
|
Lesson Reflections
|
No comments:
Post a Comment