DIGITAL RESOURCE ONLY

Student worksheets - 95 Pages

Printable

Files for students

See sample here

Learning Outcomes:

1 Outline typical spreadsheet functions including document creation

2 State the primary functions and processes involved in creating a spreadsheet document

3 Use the language associated with spreadsheet applications

4 Use with confidence a spreadsheet application to enter and edit text, numbers and dates, and insert and delete columns and rows

5 Use arithmetic operators to add, subtract, multiply and divide

6 Use formulae and functions within a spreadsheet including sum, average, max, min and count

7 Use a range of formatting commands including font size, font colour, background colours, bold, alignments, borders, numbers, decimals and dates

8 Modify a spreadsheet document by adding repeating column or row titles, page numbers, date or text to headers and footers, and adjusting to fit on to one page

9 Produce a range of basic charts and graphs including pie, column, bar and line with titles and labels.