Archdale-Trinity Middle School
Lesson Plan
| |
Date: 04-21-2016
|
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)
| |
Spreadsheets can take numerical data and turn it into picture data like graphs/charts.
| |
Bell-Ringer/Connecting Strategy
| |
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Students will finish the chart component worksheet. @ Miss W will explain the difference between embedded charts (appears on the same sheet as the spreadsheet), separate charts (does not appear on the same sheet as spreadsheet will update if both files are open.) and linked charts (will change to reflect changes made to spreadsheet even if both are not opened.) Copy paste Excel chart into PowerPoint: Embedding vs Linking Chart @ 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.
| |
Higher Order Thinking Questions
| |
How do you create a spreadsheet?
| |
Student Technology/Differentiation
| |
Students will use Excel to create spreadsheets.
| |
Closure Strategy
| |
Exit Activity #10:
Work with partners.
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
| |
No comments:
Post a Comment