 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-04-2015
|
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)
| |
Exporting an item means to send it out of the country.
http://en.wikipedia.org/wiki/Tobacco_in_the_American_Colonies
| |
Bell-Ringer/Connecting Strategy
| |
On page 92, type lines 18 and 19.
The Caret symbol is used in computer programming, math and foreign languages.
We are using our RIGHT INDEX finger for the ^ CARET key.
We are using our LEFT PINKY finger for the SHIFT key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
Guided Lesson:
@ We are NOT using the typing book for several days.
We are learning the numeric keypad.
The numeric keypad is to the right of the keyboard.
http://en.wikipedia.org/wiki/Touch_typing
Your thumb goes on the 0 at the bottom
Your index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
The daily bellringers will now be practicing the number pad
Choose exercise 1 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.
@ Students will finish the Colonial Population exercise.
@ Students will follow instructions and complete the Colonial Tobacco Export exercise.
Independent Exercise:
@ Students will create a spreadsheet, format the data, create a chart and find the functions for the Colonial Tobacco Export exercise.
 | |
Higher Order Thinking Questions
| |
How can a spreadsheet help you?
| |
Student Technology/Differentiation
| |
Students will use Excel to create and format spreadsheets and chart data.
| |
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
Exit Activity 12: Colonial Trade Game
http://www.nobelprize.org/educational/economic-sciences/trade/ | |
No comments:
Post a Comment