Monday, March 2, 2015

Tuesday, March 3rd- 7th Grade- Beginning Spreadsheets

Archdale-Trinity Middle School
Lesson Plan
 
Date: 03-03-2015


Teacher:
Witkowski

Lesson/Unit Topic:
Presentation 10 Steps Test and
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
Bell-Ringer/Connecting Strategy
On page 20, type lines 5 and 6.
Remember to use your thumb for the space bar.
We are using our left INDEX finger for the V key.
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Practices, Researched Based Strategies)
Guided Lesson:
@ Directions for test and after test pre-spreadsheet 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.

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:
@ Students take Presentation 10 steps test and complete pre-spreadsheet activity

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