Thursday, November 13, 2014

Friday, Nov. 14th- 7th Grade- Spreadsheets- Creating a chart

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-14-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)

Exporting an item means to send it out of the country.
The "Triangular Trade".
http://en.wikipedia.org/wiki/Tobacco_in_the_American_Colonies

Bell-Ringer/Connecting Strategy

On page 87, type lines 7 and 8.
We are using our LEFT PINKY finger for the 1  key.

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 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.
A tobacco plantation in Pinar

If time:
@ Students will answer questions about on the spreadsheet crossword puzzle.



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

 






No comments:

Post a Comment