Saturday, September 20, 2014

Monday, Sept. 22nd- 7th Grade- Spreadsheets- What are spreadsheets? Which careers require you know how to use spreadsheets?

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 09-22-2014



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
On page 18, type lines 9 and 10.
Remember to use your thumb for the space bar.
We are using our right INDEX finger for the N key.
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Practices, Researched Based Strategies)
Guided Lesson:
@  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.

For example: If you are sitting at monitor 20, go to page 20 and pick one job from that page.

“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.
Homework:
Students need to decide for which ACADEMIC topic
(Typing Posture/Technique, Language Arts, Science,
Social Studies, or Math) they will create a
PowerPoint presentation soon. We will be using the
PowerPoint you create to learn different old and new
features of PowerPoint 2010.
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
@ Students will complete online flashcards for the test items they missed.
Students will create online flashcards at http://quizlet.com/

Exit Activity #4:
Practice on the beginner level (#1 home row keys) at http://www.freetypinggame.net/play11.asp
Choose beginner if you are in the beginner category
Choose intermediate if you are in the average category
Click to turn off the sound.

Exit Activity #5:  Ribbon Vocabulary words
review words and definitions here http://quizlet.com/3089570/flashcards
then play activity here http://quizlet.com/3089570/scatter

Exit Activity #6:
Choose home row and easy. Turn off sound.

Exit Activity #7:
We are practicing for accuracy not speed.
If you get less than 95% accuracy; retake practice.

Exit Activity #8:

 



No comments:

Post a Comment