Thursday, April 14, 2016

Friday, April 15th- 7th Grade- Spreadsheet Review

Archdale-Trinity Middle School
Lesson Plan
 
Date: 04-15-2016


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Review

Standards:
SSB-1 Know the components of spreadsheets
SSB-3 Know spreadsheet operations



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can find and use different features of Excel.



Literacy/Vocabulary Strategies (Word Wall)
What if we had 30 years of data and we wanted to find the
highest or MAXIMUM number in the data? We could look at
thousands of numbers or we could use the MAX function.

 

http://en.wikipedia.org/wiki/Solar_maximum
Bell-Ringer/Connecting Strategy
  1. Go to wclassroom.blogspot.com
  2. Go to My computer- student docs- Witkowski folder-
    Spreadsheet folder-
    Open up 1 Spreadsheet vocabulary

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
@ Students will make test corrections on quizlet

@ Review 1 Spreadsheet vocabulary



@ Complete Exit Activity 10

If time review Functions:
=F2+F3+F4+F5
=Sum(F2:F5)

Finish the payroll file

It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses).
Open the Understanding Functions Word document

Open up the "Functions goes with youtube" file.
Excel 2010 Tutorial- Functions
1 min to 3 min Functions
3 mins to 4:30 mins Range
4:30 mins to 8:30 mins Practice
Stop at Count function at 8:30 mins


Higher Order Thinking Questions
When and how should you use a function?
Student Technology/Differentiation
Students will use Excel to understand functions.
Closure Strategy
Exit Activity #10:
Work with partners.
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars


Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.

No comments:

Post a Comment