SPREADSHEETS        

Aims

Teacher Guidelines

Examples of Spreadsheets

  Aims -

  (1) To familiarise students with the basics of spreadsheets and spreadsheet software
 
  (2) To stimulate interest and enjoyment in the use of computers.

  Learning Outcomes -
  The student will be able to:

  1. identify applications suitable for spreadsheets
  2. define the terms spreadsheet, row, column, cell, label, value, formula
  3. access a spreadsheet package
  4. load an existing spreadsheet
  5. enter numeric and character data in a spreadsheet
  6. enter formulae to generate results i.e. add, subtract, multiply and divide
  7. erase data from cells
  8. edit cell contents
  9. format column entries for currency (including Euro)
  10. generate a chart
  11. adjust column widths
  12. save the spreadsheet
  13. print the spreadsheet
  14. exit from the spreadsheet using proper procedures.

  Key Assignments
  Unit 2: Introduction to Spreadsheets - as indicated in the LCA ICT module descriptor

(1) I have entered data into a spreadsheet and I have used formulae to add, subtract, multiply and divide numbers
(2) I have entered data into a spreadsheet and I have changed the width of columns and formatted columns for currency.

Excel Tutorials

Teacher Guidelines

Examples of Spreadsheets