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.
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)