Hello, Guest!

Lesson Plan

Creating Circle Graphs with Microsoft Excel by St. Lawrence-Lewis BOCES


Subject

Math, Science & Technology

Grade Levels

Intermediate, 7th Grade


Assessment

A completed circle graph in two forms:

  1. paper and pencil
  2. computer generated

Description

After students have learned how to construct circle graphs using paper and pencil, they will learn how to construct circle graphs using Microsoft Excel.

Resource/Materials

Sample of excel graph for entire bag of M&M

Essential Question

How can technology enhance what we already know how to do?

Materials

  • Paper
  • Pencil
  • Password
  • Filled in data table (frequency table) - we used small M&M data (colors)

    • Procedure

    Students will use the data they collected and converted in their tables.

    • Step 1 : Open Microsoft Excel
    • Step 2 : Open a new document
    • Step 3 : Create table with the following headings; Color of M&M, Number of each color in bag, Ratio, Decimal, Percent, Degree.
    • Step 4 : Fill in each column with the recorded data
    • Step 5 : Click on the column for degrees (F2 - F7), then hold down the ctrl key and click on the M&M color column (A2 - A7) and highlight the colors. Now both columns should be blue.
    • Step 6: On the top of the page, you will see a button that looks like a bar graph. Click on it; this is the chart wizard. Students will follow the directions in the chart wizard:
    Step 1 of Chart Wizard- Pick "pie chart," then click "Next."
    Step 2 of Chart Wizard - Just click "Next."
    Step 3 of Chart Wizard - Type in title of graph "My M&M Colors", then click on the tab that says "Data Labels" click on "show percent" then click next.
    Step 4 of Chart Wizard - Click "as a object in Sheet 1", then click "Finish."
    • Step 7 : Print your workbook. Make sure your name & class period are on your graph.

    Duration

  • 1 - 2 (42-minute) class periods in the classroom with paper and pencil method
  • 2 - 3 (42-minute) class periods in the computer lab

    • Reflection and Feedback

    I really enjoy teaching graphing statistics, so I enjoyed this lesson. The students always enjoy learning "easier" ways to do things. Many students used this graphing lesson for other classrooms projects, such as in Social Studies, Science and English presentations. It is truly a lifelong skill.


    Data is Loading...
    .
    .