Wednesday, January 3, 2018

Tuesday, January 9th- 7th Grade- Creating a Pictograph

Archdale-Trinity Middle School
Lesson Plan
 
Date: 1-09-2018



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 pictograph 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. If you don't have all 7 clip arts saved go to 
     http://www.hasslefreeclipart.com/
     You need images of:
 egg and/or bacon, cereal, pancakes,
football, soccer, dog and cat



Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)



Guided Practice:
@ Students absent on Tuesday will follow instructions and open 0 6th period survey file or the 0 7th period survey file

@ Miss W will explain how to save clipart from 














http://www.hasslefreeclipart.com/clipart_animals/images/lion.gif

Independent Exercise:
@ Students will gather data, create a spreadsheet, use functions to find sums, format the data, create a chart, and create pictographs

https://www.addictivetips.com/microsoft-office/excel-2010-pictograph-graph-with-pictures/

@ When you are selecting the columns do NOT double click.
You are going to single click two to three times depending on what you want to do.




























http://slevitt11.wikis.birmingham.k12.mi.us/file/view/Pictogaph.png/311900688/Pictogaph.png



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

No comments:

Post a Comment