 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-26-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Values versus Labels and Cell References
| |
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.
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Range, Cell Reference, Sorting, Ascending, Descending
 |
Bell-Ringer/Connecting Strategy
|
On page 21, type lines 13 and 14.
Remember to use your thumb for the space bar.
We are using our right RING finger for the . (PERIOD) key.
Make sure you use the shift keys to capitalize the words!
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
SIGNED INTERIMS NEED TO BE BACK BY TUESDAY
FOR a 100, then 5 points will be subtracted each day. Guided Lesson:
1. Open the Spreadsheet Vocabulary file
Slides 18 through 24 (Range, Cell Reference, Sorting)
In the Witkowski folder then the Spreadsheet folder
@Practice ascending and descending order
2. Open the 2 GP-Formatting file
Practice Labels and Values
@ What if you make a mistake choosing the chart?
3.Open up the SS Flash Cards folder
Open up 9 Chart Types and Styles
--click on the chart
--On the Design tab, click on the Change Chart button --Select a column chart
--On the Design tab, click on the Chart Styles arrow and find the orange/black choice.
@ Open 19 Hide Worksheet
- right click on tab and choose hide
- right click on tabs before and after the hidden tab and choose unhide.
@ Open 16 Hide and Show Rows
-right click on row number and choose unhide.
- highlight row before and row after the hidden row
and then right click and choose unhide.
4*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder
and save to your lunch number
5. Cell Reference and Range Activity
Follow instructions to make a picture.
Make cell C5 to C8 yellow
Make D5 to D8 yellow
Make cell F5 to F8 yellow
Make cell G5 to G8 yellow
Now click on C6 make it black
Then F6 and make it black
Cell E11 green
Cell B12 B13 red
Cell I11 I12 red
Cell C14 red
Cell D15 red
Cell E16 red
Cell F15 red
Cell G14 red
Cell H13 red
SS Flash cards file
Open 7 Format Table (format as table button)
SS Flash cards file (conditional formatting button)
Open 13 Data Bars
SS Flash cards file (border button and percent button)
Open 31 Formatting Cells
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
|
How do cell references help navigate a spreadsheet?
|
Student Technology/Differentiation
|
Students will Excel to understand cell references.
|
Closure Strategy
|
Exit Activity #6:
Exit Activity #7:
Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html
Exit Activity #8:
Choose home row and easy. Turn off sound.
Exit Activity #9: Ribbon Vocabulary words
|
No comments:
Post a Comment