Excel 2010: Charts and Graphs
The ticks indicate the suitability of resources for each Key Stage.
Resource | 
      KS3 | 
      KS4 | 
      KS5 | 
      Click Here | 
    
World Cup: Create a bar chart and sort dataStudents are given a set of data. They are asked to create a bar chart and undertake some basic formatting. They are then asked to sort the data and create a second chart (subscription only) 
  | 
      ||||
Disney Students: Create and format a line chartStudents are given a set of data. They are asked to create a line chart and undertake some basic formatting. (subscription only)  | 
      ||||
Create a comparative column chartStudents are given a set of data. They are asked to create a comparative column chart. (subscription only)  | 
      ||||
World Cup: Create a pictograph barchartStudents are given a set of data and step-by-step instructions to create a pictograph barchart (subscription only)  | 
      ||||
Mobile phone features chartsStudents collect data about different mobile phone features and present their findings as different charts. (subscription only)  | 
      ||||
My weight in spaceDuring this task, students will use a spreadsheet to calculate what their weight would be on different planets in the solar system. Skills covered: 
 (subscription only)  | 
      ||||
Budget: Create and format a pie chartStudents are given a set of data. They are asked to create a pie chart and undertake some basic formatting. (subscription only)  | 
      ||||
Your Weekend: Create and format a pie chartStudents are asked to think about how they spend their time during an average weekend. They then use this information to create a pie chart to show the different proportions of time spent doing things. (subscription only)  | 
      
         task  | 
    
Copyright © www.teach-ict.com

		

