S
PREADSHEETS COURSE OUTLINE
Class 1 and 2 cells , rows, columns, data types, formula, autofill,
Class 3 formulas, absolute and relative cell referencing, printing options
Class 4 functions, named ranges, sorting spreadsheet data, filtering
Class 5 Charts (types, creating, formatting, displaying, adding additional data, column charts based on multiple ranges)
Class 6 If statements (simple, conditional formatting)
Class 7 If statements (compound, AND, OR function and nested)
Class 8 Lookups (vertical, horizontal)
Class 9 lookups (continued, Lookup errors, editing lookup table)
Class 10 Examination practice
Class 11 QQI 5 Examination
Course material required : Step by Step Spreadsheets Gill Education (ISBN
9780717160440)
Assessment method:
50% Project
50% Examinatio