Gr. Level Lesson Plans Poem Generators iPad Lesson Plans Excel Word PowerPoint MultiMedia Internet Research iWork Keynote iWork Pages iWork Numbers Mac Multimedia Tech Coordinator Tutorials Video Reversal Video Tutorials Resources
Search This Site
Custom Search

Excel Lesson Plan- Make Your First Chart

This Excel Lesson Plan Teaches Beginning Excel Users to Enter Data and Create a Simple Chart.

The instructions are for Microsoft Excel 2007 version, but the data and chart can be recreated using any of the various Excel versions or even non Microsoft variants. I have used this successfully with 2nd and 3rd graders, but your mileage may vary. When printing the excel chart, be sure to have the students use print preview to check the proper positioning of the chart and data on a single page before printing.

 

 

Excel Tutorial:

Use this mini excel tutorial to guide your students in entering the data and creating the chart.

Excel Vocabulary Words: Spreadsheets, Cells, Rows, Columns, Labels, Values.

Instructions:

  1. Type your title "Caleb's Party Food Chart" in Cell B1, then Enter.

  2. Add the party food data in Column A cells.

  3. Add the quantities in Column B cells.

  4. Select (highlight) the food labels and number values in columns A and B.

  5. On the Insert menu tab select bar chart, choose 2 D bar.

  6. Double click the chart and then choose "chart layouts" on the ribbon. Choose a chart layout.

  7. Click the office button and choose Print > Print preview. 

  8. Adjust the chart position if necessary and then Print.

 

 

Finished Excel Chart:

Excel Lesson - First  Chart

 

Related Content:

Excel Bar Chart

Excel M & M Chart

Excel Expense Chart

Excel Shopping Budget

Excel Lemonade Stand

Excel Line Chart

Excel Valentine's Day Chart