In this lesson, students will learn how to enter data and formulas into an Excel spreadsheet. They'll also learn how to use the data to create and format graphs and charts.
After completing this activity, students should be able to . . .
Workplace Readiness Skill:
| Social Skills | x | Communication |
| Teamwork | x | Critical Thinking |
| Attitude and Initiative | x | Planning and Organization |
| x | Professionalism | Media Etiquette |
Wisconsin Standards for Business and Information Technology
Business Calculations
BCA3.a: Create and analyze spreadsheet
BCA3.a.5.h: Construct formulas and equations.
BCA3.b: Illustrate and evaluate graphical data
BCA3.b.5.h: Examine and interpret tables, charts and graphs to make comparisons, predictions and inferences.
Students will need access to Microsoft Excel.
Use this webpage for Excel instructions:
Use the data found on the following document:
Part 1: Start with the formula section.
Use the web page listed above to start this section.
First, have your students open Microsoft Excel. Open the web page for the formula section. Have them download the practice workbook found on the web page. Have the students follow along on the practice workbook as you walk through each step on the web page.
Then play the video so they can have a review of what they just did.
Once that is complete, have the students complete the “challenge” at the end of the web page. They will use the practice workbook they have already downloaded.
Part 2: Next, you will work through the charts and graphs section.
Use the web page listed above to start this section.
Make sure your students have Microsoft Excel opened. Open the web page for the Excel charts section. Have the students download the practice workbook found on the web page. Have the students follow along on the practice workbook as you walk through each step on the web page.
Then play the video so they can have a review of what they just did.
Once that is complete, have the students complete the “challenge” at the end of the web page. They will use the practice workbook they have already downloaded.
Part 3: Students create spreadsheet with three charts.
Students create a workbook using the data provided below. The data must be entered, and formulas must be used in the totals and net area. The formula for the total sections should be a “sum”. The formula for the net section should be the sales total minus the expenses total.
Once the data and formulas are entered, three (3) charts need to be included. They should be put on the same page as the data.
One chart should be a 3-D column chart, and the two remaining chart types can be determined by the student. The students need to also include enhancements to the charts. The charts should include proper titles. Each chart should include proper chart elements – a title, a legend, data labels and any other elements that properly enhance the chart.
[the data needed for the spreadsheet is also included as an attachment above]
Marinette Hose and Coupling Mfg.
Sales and Expenses for 2019