Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-04-2017
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Cell References and Sorting
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can find and use different features of Excel. TEST NEXT TUESDAY
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Range, Cell Reference, Sorting, Ascending- to go up, Descending
 |
Bell-Ringer/Connecting Strategy
|
1. Go to Computer- then your LUNCH number- then open Copy of Car Lot
3. Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder-
open 1 Spreadsheet Vocabulary file.
4. Go to wclassroom.blogspot.com
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Skill 1 ascending order (Home tab)
Skill 16- Hide and Show Columns (Right click)
Skill 21- hide gridlines (Page layout tab)
Independent Exercise:
Open your "car lot" file and complete up to car 10
Open the Spreadsheet Vocabulary file
1. Miss W will review functions
2. Open a new Excel spreadsheet
In F2 type 20
In F3 type 30
In F4 type 40
In F5 type 50
In F6 type 60
We will type out a formula =F2+F3+F4+F5+F6 and then we type out function to see how functions are shortcuts. =Sum(F2:F6)
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 "3 Function practice independent activity” .
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
Slides 34 (functions- built in calculations) through 40
Answer questions 20 through 23
If time: Skill 4- sparklines(insert), Skill 20- icon sets (under conditional formatting) |
Higher Order Thinking Questions
|
How do cell references help navigate a spreadsheet?
|
Student Technology/Differentiation
|
Students will use Excel to understand cell references.
|
Closure Strategy
|
We have not covered one question 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