Wednesday, September 27, 2017

Thursday, September 28th- 7th Grade- Spreadsheet Ribbon

Archdale-Trinity Middle School
Lesson Plan
 
Date: 09-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 Presentation Procedures Revised

2. Open a NEW Word document



3. complete Exit Activity #1  
Purpose of Presentation
A continuous loop is like our tv messages.
It is a broadcast.


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



@ Students will make corrections by typing out the questions they missed and typing out the complete correct answer. Do not type a, b, c or d.

@ We are in the Spreadsheet folder now.
Open the 1 Spreadsheet Vocabulary PowerPoint

@ Spreadsheet Ribbon Group Activity

Last year:
@  93,694 jobs require knowing how to use spreadsheets.
      2,628 jobs are in North Carolina that require spreadsheet skills
.

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


Independent Exercise:


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