Thursday, September 28, 2017

Friday, September 29th- 7th Grade- Test Correction and Spreadsheet Careers

Archdale-Trinity Middle School
Lesson Plan
 
Date: 09-29-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 list Spreadsheet careers. .



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 a NEW Word document

Go to Applications then MS Office then Word


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



Last year:
@  50,211 jobs require knowing how to use spreadsheets.
      1,249 jobs are in North Carolina that require spreadsheet skills
.

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


Independent Exercise:



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