Archdale-Trinity Middle School
Lesson Plan
| |
Date: 12-14-2017
|
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)
| |
 https://cdn.ablebits.com/_img-blog/chart-titles/remove-chart-title.png | |
Bell-Ringer/Connecting Strategy
| |
1. Go to wclassroom.blogspot.com
2. Go to Applications, Microsoft Office then Excel. Open a new spreadsheet. Save it as population. | |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ 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 11: Spreadsheet Review
https://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1
Hints: do NOT include these in your spreadsheet numbers--- commas and dollar signs copy formulas and automatically adjusts to correct cell range- relative cell referencing not Paul Bunyan, but a guide- legend * - / + --- mathematical operators selected group--- cell range another place that displays the active cell's info.--- entry bar active cell in a spreadsheet has this around it---border allows you to quickly fill in days of week---autofill turn sideways!--- landscape |
No comments:
Post a Comment