Description
Three video lessons with Excel sheets, Tests, Rubrics, and Answer Keys.
Lesson 1: (Football Statistics)
- Basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,
- How to sort data,
- writing formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards that each player contributed to the season.
- Using the formula builder to quickly calculate the sum totals and the overall averages for this data. They also calculate the standard deviation for their averages.
- Practicing writing formulas with a new sheet of data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make (directions and grading rubric included).
Lesson 2: (Sales Data)
- Programming a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
Lesson 3: (Real Estate Data)
- Programming a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
All screenshots are from Microsoft 365.
Click here for editable, PowerPoint version of lessons or pay $6 more to get both versions.
Microsoft Lessons (Word, Excel, PowerPoint)
Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects
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
8th - 11th
Save even more with bundles
This is a bundle of 7 lessons from my Computer Applications class. They each include step-by-step directions for students and an assessment to evaluate their learning. Please note that many of the lessons have a version that is an instructional video and also a version that is the PowerPoints. There
Price $70.00Original Price $105.50Save $35.50
11
Pay just $6 more to get my PowerPoint lessons and my instructional video versions of each lesson. Now you will have both options...teaching the lesson yourself, or assigning the video to your students.All lessons come with Excel sheets, Tests, Rubrics, and Answer Keys.Lesson 1: (Football Statistics)
Price $38.00Original Price $64.00Save $26.00
6
Description
Three video lessons with Excel sheets, Tests, Rubrics, and Answer Keys.
Lesson 1: (Football Statistics)
- Basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,
- How to sort data,
- writing formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards that each player contributed to the season.
- Using the formula builder to quickly calculate the sum totals and the overall averages for this data. They also calculate the standard deviation for their averages.
- Practicing writing formulas with a new sheet of data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make (directions and grading rubric included).
Lesson 2: (Sales Data)
- Programming a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
Lesson 3: (Real Estate Data)
- Programming a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
All screenshots are from Microsoft 365.
Click here for editable, PowerPoint version of lessons or pay $6 more to get both versions.
Microsoft Lessons (Word, Excel, PowerPoint)
Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects
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
This product has not yet been rated.
Questions & Answers
Loading
Loading
