Wednesday, April 26, 2017

Thursday, April 27th - 7th Grade- Begin Spreadsheet Unit

Archdale-Trinity Middle School
Lesson Plan
 
Date: 04-27-2017



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- What are Spreadsheets? Careers?

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can explain what a Spreadsheet is.
I can list examples of Spreadsheets.
Students understand what a Spreadsheet is and can list different examples.


Literacy/Vocabulary Strategies (Word Wall)
Spreadsheet, Budget, Grades, Loans,
Inventory- items a business owns, that they sell to make money

photo
https://www.flickr.com/photos/microsoftsweden/5395284268/
Bell-Ringer/Connecting Strategy
1. Open PowerPoint 4
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Practices, Researched Based Strategies)
Guided Lesson:

@ Spreadsheet Ribbon Group Activity


@  93,694 jobs require knowing how to use spreadsheets.
      2,628 jobs are in North Carolina that require spreadsheet skills.
and look at your monitor number.
Go to that number's page and find one job that needs spreadsheets.
You will need to give the name of the job and a sentence that DESCRIBES the job.


“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of spreadsheets (slides 1-8)

Independent Exercise:

Students will take the open PowerPoint Presentation Test

In pairs, list the different buttons (icons) for the Spreadsheet ribbon.


Charades- each group of three will have 3 minutes to come up with a
way to act out one of the people below using spreadsheets.
They can say anything but the name of the person.
For example: They can not say "Look at me, I'm an accountant."
Accountants, Teachers,
Engineers, Sales people,
Scientists, Supermarkets,
Market Researchers.

Higher Order Thinking Questions
What type of activities benefit from using a spreadsheet?  
Student Technology/Differentiation
Students will use http://www.simplyhired.com/a/jobs/list/q-spreadsheet to review careers that require spreadsheet knowledge.
Closure Strategy

Exit Activity 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


We have not covered some questions yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars






No comments:

Post a Comment