ICT Unit Plan

Topic:  Pie graphing
Year 2001

Year: 1  2  3  4  5  6  7  8 

Level:     1   2   3   4
Curriculum Focus: English  Maths  Health & P.E  Technology  Social Studies  The Arts  Science
Essential Skills

Communication          
Numeracy
Information                
Problem-solving 
Self management and Competitive
Social and Co-operative
Physical
Work and Study

ICT Skills
Word Processing - inserting a table, changing information into a pie graph, formatting tables Database Spreadsheet/Tables make a table, insert appropriate information, convert tables to graphs, manipulate data  Multimedia Accessing 
Resources: NCM  Level 3 Book 2, Chapter 29:Collecting and displaying data.
Software: Word or Claris/Appleworks tables
http://deal.unl.edu/presentations/piegraphs.html (Tips on how to make a graph look good)  
http://www1.saxonpub.com/tech/internet_excursions/middle/algebra_one-half/pie_bar_graphs.html online lesson on using pie graphs
Learning Sequence:

Session One
- click on the table icon and drag the number of cells required  (in this example 6x3)
- enter information as below

Friday Monday
mince pies 29 10
pizza 2 1
Hawaiian pizza 21 11
meat savoury 12 6
sausage roll 13 5

- Highlight the cells you want to turn into a Pie graph

  Friday Monday
mince pies 29 10
pizza 2 1
Hawaiian pizza 21 11
meat savoury 12 6
sausage roll 13 5

- Click on the graph button (it is known as Chart) 
If you do not have the graph button on your toolbar, you can get it by going to View -Toolbars-Customise. Click on Commands Tab, click on Insert and scroll down until you see Chart, click and drag that icon onto your toolbar. Click Close.
- a new window with different toolbars will open

Session Two
- repeat above steps
- change the bar graph to a pie graph. Click on Chart type and select Pie graph
- select by column
- go to Chart and select Chart Options
This is where you can make all sorts of changes to your graph
- Type in Chart Title
- Click on Legend Tab, Change placement of legend (optional)
- Click on Data Labels tab, make a selection of Data label (try the show label and percentage)
- Click OK

Session Three
- Find your saved graph file, double click on the graph, if the Datasheet is in the way, close it
- Make the whole graph bigger by clicking and dragging on the corner handle
- make the pie graph picture bigger by clicking on the outside of the circle
- explode the graph by dragging the circle even further
- change graph colours by clicking on each individual piece and selecting a colour from the Fill Colour button on the top tool bar (go even further and go into Fill effects and add patterns, mixed colours or even graphics)

Session Four
-  Find your saved graph file, double click on the graph, if the Datasheet is in the way, close it
- Click on Legend and change Size, Font and Style.
- Add a background colour to the legend (or go into Fill effects)
- if you have chosen the option Show Label and Percent, you can move them around by clicking and dragging them from the middle. Font, size and style can be changed by selecting the box
- Go to File - Exit and return to your original document
- Put a border around the Pie Graph, click once on the Pie Graph to select it, right mouse click, choose Borders and Shading, choose colour, thickness and type of border

Session Five
- Change the order of the columns so that you can make a Pie Graph of Monday's results. Highlight Monday's Column, click just before the word Monday and drag until your mouse cursor is just before the word Friday, let go of mouse click, the 2 columns should have swapped
- start the instructions all over again to make a new pie graph

Assessment Task:
Your brief is to itemise how you spend your time on a school day as compared to a day in the weekend. You will need to

- categorise the different events that happen in your day
- keep the number of events to a limit of 6
- create a table with the information clearly displayed
- turn that information into pie graphs
- analyse that information
- suggest if any changes need to be made to how you spend your day

Assessment  
A. make sensible statements about an assertion on the basis of the evidence of a statistical investigation. Statistics Level 3 M.I.N.Z.C

© Jacqui Sharp 2001

ICT Units and Ideas

Back to Home Page