An Approach to Integrating Computers into Learning Activities and Demonstrations

Level LBS 5

Lab 4: Constructing Pie Charts and Circle Graphs



graphic Microsoft Excel icon




View PDF version (219k)


 

Microsoft Logos and all screens captured by permission of Microsoft

Goal:

To construct pie charts (circle graphs) by hand and by using Chart Wizard in Microsoft Excel

Learning Outcomes:

After completing this section, the student should be able to

  • construct pie charts (circle graphs) using protractor and compass
  • enter data in an Excel worksheet
  • use Chart Wizard to construct pie charts (circle graphs)
  • save the worksheet and the chart (graph)
  • print the worksheet and chart (graph)
  • compare hand constructed graphs with computer generated graphs
  • complete several practice assignments

Prior Learning

Before attempting this lab, it is expected that the student has

  • completed Spreadsheet Mathematics: Statistics and Graphing Lab 1: Entering, Formatting and Saving Data in an Excel Spreadsheet

Topics covered:

  • construct a pie chart (circle graph) using a compass and a protractor
  • enter data in an Excel Spreadsheet and create a pie chart using Chart Wizard
  • complete two practice assignments
  • complete a hand-in assignment
  • discuss questions or concerns about assignments with your teacher

Lab 4 Answer Key
graphic link to Get Acrobat Reader The free Adobe® Acrobat® Reader allows you to view, navigate, and print PDF files across all major computing platforms. To download Acrobat® Reader click on the button.
Mathematics Table of Contents Next Page