 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 03-30-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- What are functions?
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain why a function is a shortcut.
|
Students understand concept of functions.
|
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 62, type lines 06 and 07.
Remember to use your thumb for the space bar
| ||||||
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| ||||||
Guided Lesson:
Miss W will explain instructions for Sub assignment
- Choose 6 careers from the Science, Technology, Engineering and Math page.
- Fill in your worksheet for the following categories:
You only need to write the first sentence in the job description blank.
- Choose one of the 6 careers and create a PowerPoint.
# The first slide should have your name and occupation and a picture with a citation.
# Look at the ENTIRE job description. Have one or more slide for each sentence.
You may copy and paste job description sentences.
# You need at least 5 slides not counting the title page.
# Find interesting pictures about that occupation and have one picture per slide with
the proper citations.
# Save to your lunch number.
.
Miss W will explain why functions are called shortcuts.
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:
We will type out a formula =F2+F3+F4+F5 and then we type out a function to see how functions are shortcuts. =Sum(F2:F5) @ 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