 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-03-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Test, Finish Project, Typing contest
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain different features of Excel.
TEST TODAY |
Students make a good grade on today’s test.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Intersection- where an horizontal and vertical line meet.
In a spreadsheet when a horizontal row and vertical column meet.
The rectangle that they meet in is called a cell.
A cell is the smallest part of a spreadsheet.
 |
Bell-Ringer/Connecting Strategy
|
On page 32, type lines 09 and 10.
Remember to use your thumb for the space bar.
We are using our left INDEX finger for the U key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Test directions.
Independent Exercise:
Open the Spreadsheet Vocabulary file
Slides 31 through 34 (formatting and formulas)
@ Open up the Spreadsheet Vocabulary PowerPoint file
slides 37 and 38 Understanding Functions (Shortcuts)
@ Function as a shortcut example
@ What are functions? http://www.gcflearnfree.org/excel2010/10.2
@ Miss W will review the Function handout
@ Autosum button http://www.gcflearnfree.org/excel2010/10.4
@Depending on time several functions examples will be completed.
***Students will open the payroll file and by using functions
find the following information:
the maximum hourly rate
the minimum hourly rate
the sum of the hourly rates
the average of the hourly rates
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.
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 are the different definitions involved with spreadsheets?
|
Student Technology/Differentiation
|
Students will use Excel to understand cell references.
|
Closure Strategy
|
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
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