Excel Formulas A Technology Lesson Plan & Materials

Grade Levels
Product Rating
4.0
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
0.71 MB   |   7 pages

PRODUCT DESCRIPTION

Summary: Students use formulas, functions, and sorting to analyze and answer questions about a given table of data.
Effective Tech Lesson 5.7
This lesson is in my Level 5 Curriculum Progression.
Recommended for Fifth through Twelfth Grade
Uses Microsoft Excel, but can be adapted for other spreadsheet programs.

Files Included:
Teacher Instructions (pdf)
Student Instructions (pdf)
Student File (Excel)
Answer Key (pdf)

Students work in-step from teacher-directed instructions or at their own pace from written instructions.
Opportunity for student choice: none
Duration: Two 60-minute class sessions
Skills introduced:
Constructing a formula
Copying formulas to other columns/rows
Using the AutoFill command
Using functions in formulas
Sorting data
Total Pages
7
Answer Key
Included
Teaching Duration
2 hours

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
3 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$15.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (115 Followers)
$15.00
Digital Download
ADD ONE TO CART
Excel Formulas A Technology Lesson Plan & Materials
Excel Formulas A Technology Lesson Plan & Materials
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up