An Approach to Integrating Computers into Learning Activities and Demonstrations

Level LBS 5

Lab 6: Constructing Bar and Column Graphs



graphic - Microsoft Excel icon




View PDF version (349k)




Microsoft Logos and all screens captured by permission of Microsoft

Goal:

To construct bar and column graphs by using Chart Wizard in Microsoft Excel

Learning Outcomes:

After completing this section, the student should be able to

  • enter data in an Excel worksheet
  • use Chart Wizard to construct bar and column graphs
  • save the worksheet and the chart (graph)
  • print the worksheet and chart (graph)

Prior Learning

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

  • completed Spreadsheet Mathematics Lab 1: Entering, Formatting and Saving data in an Excel Spreadsheet

Topics covered:

  • enter data in an Excel Spreadsheet and create a bar or column graph using Chart Wizard
  • save and print worksheets and graphs
  • complete a practice assignment
  • complete a hand-in assignment
  • discuss with teacher any questions or concerns related to assignments

Lab 6 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