Level 4 Spreadsheet Methods

This is a collection of practice worksheets using Spreadsheet Methods, for teenagers and adults with additional educational needs. It is a full course and includes student worksheets, files for students and a sample exam.

The resource is intended to give students practice with spreadsheets, including:

• Spreadsheet functions
• Using a spreadsheet application
• Producing basic charts and graphs

Topics include:

• Creating and modifying spreadsheets
• Spreadsheet vocabulary
• Using formulae and functions
• Using formatting commands
• Practising all concepts

**These worksheets are designed to cover the following 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.

Can this resource be used online?
Yes, it is a digital resource. If you have purchased this resource and would like to use it for online teaching, you have permission to do so. These worksheets can be printed, and teachers can use them for whole-class teaching using a projector or interactive whiteboard. This resource is not fillable online, and it is recommended that worksheets are printed. Alternatively, students can split their screens to read the instructions and carry out the activities at the same time.

What is included?
All components are available in the zipped folder, i.e. student worksheets, files for students and a sample examination.
Student Worksheets: 96 Pages