 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-13-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Social Studies and Spreadsheets
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can create a spreadsheet, use functions and format my data.
|
Students can create a spreadsheet, use functions and format their data.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
Space one time before the parenthesis, do not space after it.
 Example: "And remember that life's A Great Balancing Act. And will you succeed?Yes! You will, indeed! (98 and ¾ percent guaranteed) KID, YOU'LL MOVE MOUNTAINS!" (Dr. Seuss, Oh, The Places You'll Go! 1990) http://commons.wikimedia.org/wiki/File:Parenthesis1.jpg | |
Bell-Ringer/Connecting Strategy
| |
On page 80, type lines 18 and 20.
We are using our RIGHT RING finger for the ( LEFT PARENTHESIS key.
We are using our LEFT PINKY for the Shift Key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Examples of Relative and Absolute References http://www.youtube.com/watch?v=PFOe0TKnAuE
@ Students will follow instructions and complete the Colonial Population exercise.
Independent Exercise:
@ Students will create a spreadsheet, format the data, create a chart and find the functions for the Colonial Population exercise.
@ Students will answer questions about on the spreadsheet crossword puzzle.
| |
Higher Order Thinking Questions
| |
How do you create a spreadsheet?
| |
Student Technology/Differentiation
| |
Students will use Excel to create spreadsheets.
| |
Closure Strategy
| |
Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data
| |
No comments:
Post a Comment