SPREADSHEETS

This module allows students to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

This module allows students to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs. On completion of this module the student will be able to work with spreadsheets and save them in different file formats, enter data into cells, use good practice in creating lists, select, sort and copy, move and delete data, edit rows and columns in a worksheet, create mathematical and logical formulas using standard spreadsheet functions, use good practice in formula creation, choose, create, and format charts to communicate information meaningfully. The candidate will be able to:

  • Understand the concept of Spreadsheets and their application in the organisation and analysis of data. Create, edit and format Spreadsheets and their content
  • Insert formula and other mathematical functions of Spreadsheets
  • Understand and work with Web-based Spreadsheets and online Spreadsheets
  • Audit the spreadsheet content for formula errors
  • Create multiple interactive sheets displaying data as text and numbers
  • Create Spreadsheets that improve productivity by presenting mathematical data in a format that assists decision making