Session 6 Processing numerical data (using Microsoft Excel) Part 2


In this session, you will cover the following content:

  1. Use formulae to perform calculations
  2. Use basic functions to solve simple problems
  3. Identify problems based on error indicators
  4. Troubleshoot basic errors in formulae and functions
  5. Work with sheets in a workbook
  6. Perform calculations using Functions
  7. Create graphs/charts from given data and choose appropriate graph types
  8. Edit graphs
  9. Troubleshoot basic problems in graphs
  10. Useful formulae for teachers

Documents created: Mark sheet, graphs/charts

Required prior knowledge: Content in Sessions 1, 2 and 5 of this course; content in Sessions 3 and 4 would be useful.

Required existing laptop skills: Entry level – Basic