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
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
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.
Highlights
Digital downloads
Grades
5th - 12th
Subjects
Tags
Pages
16
Answer Key
Included
Teaching Duration
1 Week
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
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
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.
Reviews
All verified TPT purchases
great!
Thanks, saved me time
This is wonderful! I've been looking for something like this and I cannot thank you enough! Very thorough and accurate! Can easily be adapted for Word 2013.
Hi Jennifer,
Excel is such a great product and I think it is a blast to teach it! So glad you like the Formulas Bundle. Thanks for the feedback!
Paula
Questions & Answers
Loading
Loading




