# Microsoft Excel: Formulas & Conditional Formatting BUNDLE

Resource Type
Product Rating
File Type

Zip

(120 MB)
2 Products in this Bundle
2 products
1. Students are given step-by-step directions (54 slides) on how to use formulas to make calculations using football statistics. They:learn basic formatting skills such as word wrapping text in a cell and drawing boxes around cells. learn how to sort data.write formulas to determine net receiving yards
2. Students are given step-by-step directions (33 slides) on how to use conditional formatting on a sales report in Microsoft Excel. They:Program 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. Work wi
Also included in:
1. This is a bundle of 6 lessons from my Computer Applications class. They each include step-by-step directions for students and an assessment to evaluate their learning. Screenshots are from Microsoft 2016 (Office 365)
\$59.50
\$50.00
Save \$9.50
Bundle Description

Lesson 1:

Students are given step-by-step directions (54 slides) on how to use formulas to make calculations using football statistics. They write 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. They are then shown the formula builder to quickly calculate the sum totals and the overall averages for this data. Next they use the forumula builder to calculate the standard deviation for their averages. The lesson also covers some basic formatting skills such as word wrapping text in a cell and drawing boxes around cells. A test with rubric is included.

Lesson 2:

Students are given step-by-step directions (33 slides) on how to use conditional formatting in Microsoft Excel. First, they program 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. Then they work with a sales report sheet and format it to color code their best sellers, worst sellers, lowest inventory, and revenue. They also use data validation to create an "Updated By" drop-down menu in their first column. Additionally, there is some work with writing simple formulas to calculate their ending inventory and their monthly revenue. A test with rubric is included.

All screenshots are from Microsoft Excel 2016 (Office 365).

More Computer Applications Lessons (Word, Excel, PowerPoint, Video Editing)

Computer Coding Lessons

Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere

Elements and Principles of Design Lessons

Literary Elements Lessons

English Grammar Lessons

Novel Study

Total Pages
N/A
N/A
Teaching Duration
N/A
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.
\$17.50
Bundle
List Price:
\$22.00
You Save:
\$4.50
Report this resource to TpT
More products from Miss B's Shop

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