Level 4 Spreadsheet Methods
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.
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.
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.