Embedded Files
Modelling with spreadsheets
Entering data
Sorting and filtering data
Presenting data
Creating charts and graphs
Using formulae and functions
The Using Spreadsheet Software unit develops the key skills needed to use a spreadsheet to perform calculations, interrogate and present data and create graphs.
The unit is split into six topics:
This web page should be used together with the Using Spreadsheet Software objectives booklet. The links below provide the information that you need to complete the learning objectives in the booklet as well as tasks to help you develop your understanding of the unit.
The unit will be assessed through a 90 minute written and practical test comprised of recent examination questions and tasks associated with Using Spreadsheet Software.
Topics
Topics
These are the six topics of the Using Spreadsheet Software unit.
Information
Information
The links below will provide you with the information that you need to complete the learning objectives from the objectives booklet.
Textbook, pages 224-226
www.igcseict.info: Modelling Things
Teach-ICT: Modelling and simulation
Teach-ICT games and quizzes: Modelling and simulation
Textbook, page 235
Tasks
Tasks
These are downloadable tasks that will help you to show evidence that you are able to complete the objectives from the objectives booklet.
When you complete each task, email the spreadsheet files or printouts (as pdf files) to computing@gardenrayong.com
Modelling with spreadsheets
Entering data
Presenting data
Textbook, pages 233, 236 and 243
GCFLearnFree: Modifying Columns, Rows, and Cells
GCFLearnFree: Formatting Cells
GCFLearnFree: Printing Workbooks
Youtube: Fitting to one printed page
Youtube: Exporting data to a word processor
GCSEPod: Spreadsheet Formatting
Textbook, pages 245-249
Youtube: Adding, editing and removing chart legends
Youtube: Extracting a pie chart segment (2:30-3:00)
Youtube - Adding a second axis to a bar chart
MS Office Help: Add or remove a secondary axis in a chart
Textbook, page 232
GCFLearnFree: Complex Formulas
GCFLearnFree: Relative and Absolute Cell References
Textbook, page 239
Youtube: Using an INT function
(00:55-01:20)
Creating charts and graphs
Using formulae and functions
Textbook, pages 237-238 and 242-243
Youtube: Using a HLOOKUP function
Textbook, pages 238 and 241-242
Youtube: Using a nested IF function
Textbook, pages 245 and 253-254
Youtube: Using a COUNTIF function
Youtube: Using a SUMIF function
(start - 1:20)
Textbook Activities
Textbook Activities
Once you have completed all the main tasks above, you should work through the activities in your textbook to further develop your skills in Using Spreadsheet Software.
Once you have completed all the main tasks above, you should work through the activities in your textbook to further develop your skills in Using Spreadsheet Software.
Session 5.8 (pages 232-236)
Session 5.9 (pages 237-240)
Session 5.10 (pages 241-246)
Session 5.11 (pages 247-251)
Session 5.12 (pages 252-256)
Practical Review (pages 258-259)
Extension tasks
Extension tasks
Once you have completed all the main tasks and textbook activities above, you should work through the tasks below to further develop your skills in Using Spreadsheet Software.
Recent exam tasks and questions
Recent exam tasks and questions
The links below will provide you with access to past exam tasks and questions related to the Using Spreadsheet Software unit.
These will help you to gain an understanding of the way in which you will be assessed for the unit.
PAPER 3 (This is where your ability to use spreadsheets will be tested)
PAPER 2 (This is usually a 'Creating charts and graphs' task)
PAPER 1 (This is where your knowledge and understanding of spreadsheets will be tested)
Page updated
Report abuse