Advanced Spreadsheet Skills Project for Google Sheets - Computer Applications

This Advanced Spreadsheet Skills and Project for Google Sheets covers all the below topics to an advanced level. Students and teachers are expected to look and read through the slides in the presentation provided and then complete the advanced level project (which is scenario based).

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

This project is perfect to use for an end of unit assessment or to form part of a main lesson. This project will take at least 1 week/5 hours to complete depending on the ability of your students.

Topics covered and tested:

• Formulae
• Functions
• Sorts
• Filters
• Conditional Statements/IF Statements
• Absolute Cell Referencing
• Goal Seek
• Importing Text Files
• Print Settings
• All answer keys have been provided.

What's Included:

• Teacher Presentation (Editable and PDF)
• Student Project
• Text File with data
• Spreadsheet (Solutions)
• Sharable Link to Google Drive files