A range of advanced level spreadsheet projects covering the below topics in depth:

Topics covered and tested:

Counta() function
Count() function
CountIF() function
Countblank() function
SumIF() function
Lookup() function
Vlookup() function
Concatenate() function
AND() function
OR() function
Combining IF() function
Nesting Vlookup() function
Sorts
Filters
Conditional Statements/IF Statements
Absolute Cell Referencing
Goal Seek
Importing Text Files
Print Settings
Autofill
Sum() function
Importing Text files
Creating Pie and Line Charts
Moving chart locations
Creating charts with 2 data axis
Chart Customization:
Chart Style
Chart and Axis Titles
Series
Legend
Horizontal Axis
Vertical Axis
Right Vertical Axis
Gridlines and Ticks
Students are also taught how to name a range of cells in Google Sheets.

Students and teachers are expected to look and read through the slides in each of the presentations provided and then complete the advanced level projects (which are based on a scenarios).

Not only are students expected to use their spreadsheet skills to complete these projects, but they must use their skills to read through and understand the scenario based worded problems before the attempt the given tasks.

These projects are perfect to use to form part of main lessons or even as an assessment at the end of a unit. This bundle contains at least 4 weeks of teaching and learning material (or even longer depending on the ability of the students)

All answer keys have been provided.