# CATE Excel Charts Lesson Plan

ACP Lesson Plan

Overview / Description: To learn how to enter data and formulas into an Excel spreadsheet. Learn how to use the data to create and format graphs and charts.

Learning goals/objectives:

After completing this activity, students should be able to . . .

• Enter data into a spreadsheet.
• Use formulas to create totals and net profit.
• Create three different types of charts using the spreadsheet data.
• Add formatting attributes to the charts and graphs.

Content Standards:

BCA3.a: Create and analyze spreadsheets

BCA3.a.5.h: Construct formulas and equations.

BCA3.b: Illustrate and evaluate graphical data.

BCA3.b.5.h: Examine and interprettables, charts and graphs to make comparisons, predictions and inferences.

Materials:

Students will need access to Microsoft Excel.

Use this webpage for Excel instructions:

For MS Excel formulas:

https://edu.gcfglobal.org/en/excel/intro-to-formulas/1/

For creating MS Excel charts and graphs:

https://edu.gcfglobal.org/en/excel/charts/1/

Use the data found on the following document:

Assessment:

Students will be completing an Excel spreadsheet with three charts included. They need to include proper formulas and chart information that is appropriate for each chart.

Wrap-Up:

This exercise will help students to learn the basics of formulas and charts in Excel. When the assignment is completed, students will have the data properly entered and three appropriate charts.

Extension Activity (for intervention or enrichment):

ATTACHMENTS

Example Solution - student responses will vary.