Tuesday, April 19, 2016

Wednesday, April 20th- 7th Grade- Finish Spreadsheet Chart Components

Archdale-Trinity Middle School
Lesson Plan
 
Date: 04-20-2016



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Beginning Chart Components

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments

I can identify different chart components.
Test Next Week.
Students can identify different chart components



Literacy/Vocabulary Strategies (Word Wall)
The Chart Title is “Pre-Civil War Voter Turnout
The Y-axis title is “Percent of voter turnout
The Y-axis labels are 0, 20, 40, 60, 80, 100
The X-axis title is “Year
The X-axis labels are 1824, 1828, 1832, etc.  
Other resolutions: 223 × 240 pixels

http://commons.wikimedia.org/wiki/File:Graph_from_Spreadsheet_US_turnout_19c.JPG
Bell-Ringer/Connecting Strategy
  1. Go to wclassroom.blogspot.com
  2. Go to My computer- student docs- Witkowski folder Spreadsheet folder- Open up 4.02 Chart Components
  3. Get out your 4.02 Worksheet
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
@ Test next Thursday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.

Miss W will review the chart tools tab       
http://www.youtube.com/watch?v=igmsvkkUWqw
     and how to use the Layout Tab to add a picture and shapes to your chart,

     and how to use the Format Tab to add a border and shape fill to your chart. 
@ Students will open the Chart Components PowerPoint
@ Students will start taking notes

Independent Exercise:
@Students will complete the first page of the  CHART COMPONENTS NOTES   

If time: Students will start the Colonial Population spreadsheet

Higher Order Thinking Questions
What are the different chart components?
Student Technology/Differentiation
Students will use Excel to understand chart components
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