Teachers Pay Teachers

Excel Formulas Bundle

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.
1.62 MB   |   16 pages

PRODUCT DESCRIPTION

Three for the price of two!
Summary: Students use formulas, functions, and sorting to analyze and answer questions about given tables of data.

Effective Tech Lessons 5.7, 5.8, and 5.9
These lessons are 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:
Three sets of Teacher Instructions (pdf)
Three sets of Student Instructions (pdf)
Three Student Files (Excel)
Three Answer Keys (pdf)

For the first lesson, students work in-step from teacher-directed instructions or at their own pace from extremely detailed written instructions. For the following two lessons, students work at their own pace from written instructions.
Duration: six to eight 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
16
Answer Key
Included
Teaching Duration
1 Week

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
2 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$25.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (111 Followers)
$25.00
Digital Download
ADD ONE TO CART
Excel Formulas Bundle
Excel Formulas Bundle
Excel Formulas Bundle
Excel Formulas Bundle