Archdale-Trinity Middle School
Lesson Plan
| |
Date: 10-12-2017
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets-
Test Review | |
Standards:
|
SSB-1 Know the components of spreadsheets
SSB-3 Know spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain different vocabulary words.
TEST ON FRIDAY |
.
|
Literacy/Vocabulary Strategies (Word Wall)
|
What if we had 30 years of data and we wanted to find the
highest or MAXIMUM number in the data? We could look at
thousands of numbers or we could use the MAX function.
http://en.wikipedia.org/wiki/Solar_maximum
|
Bell-Ringer/Connecting Strategy
|
Go to wclassroom.blogspot.com
Open up 1Spreadsheet vocabulary
Complete Exit Activity# 10 on your own
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Review for Spreadsheet Vocabulary test
@ Complete Car Lot Exercise (research and type)
Cell Reference and Range Activity
Follow instructions to make a picture.
Make cell C5 to C8 yellow
Make D5 to D8 yellow
Make cell F5 to F8 yellow
Make cell G5 to G8 yellow
Now click on C6 make it black
Then click on F6 and make it black
Cell E11 green
Cell B12 to B13 red
Cell I11 to I12 red
Cell C14 red
Cell D15 red
Cell E16 red
Cell F15 red
Cell G14 red
Cell H13 red
|
Higher Order Thinking Questions
|
When and how should you use a function?
|
Student Technology/Differentiation
|
Students will use Excel to understand functions.
|
Closure Strategy
|
Exit Activity #10:
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
|
No comments:
Post a Comment