Spreadsheets III Exercise: Marking Scheme

Topic Criteria Marks
File management and identification
  • file named excel3.xls
  • Charting Practice, your name and date appears on the Overview tab
 1
Chart criteria

 

Charts:
  1. correct type of chart and sub-chart
  2. correct data series plotted
  3. correct title and axis labels; legend shown or hidden as directed
  4. chart well positioned within data table or correctly named separate sheet
  5. calculations and extra chart formatting performed as directed
 24
(4 each)
  1. Energy 
  • pie chart, in same sheet
 4
  1. Income 
  • XY scatter chart, in same sheet
 4
  1. Waste 
  • bar chart, population
 4
  1. Birth-Death 
  • column chart, percent growth rate
 4
  1. Enrollment 
  • stacked column, total
 4
  1. Forex 
  • 3-D column, % differences from average
 4
Total 25