Example assignment for Spreadsheet Unit
Category: Spreadsheets
Level 1 Spreadsheets
Spreadsheets – Conditional Formatting & Protection
Lesson Aims
Be able to conditional format a spreadsheet
Be able to protect a worksheet
Be able to validate data on a spreadsheet
Task 1
Download the spreadsheets below and practice Conditionally formatting the spreadsheet and protecting cells within the spreadsheet
Spreadsheets Vlookup Formulas
Lesson Aim
- Create Vlookup formulas
- Create Nested IF formulas
- Sort Data tables
Task
Download the worksheets below and complete the tasks
Example completed task
Help on formulas
Spreadsheets – IF formulas
Lesson Aim
- Re-inforce creation of formulas
- Create IF Formulas
- Created Nested IF Formulas
Task
Download the worksheets below and complete the tasks
Extension
Spreadsheet – Self Marking Test
Task
Go to the following folder to get your self marking spreadsheet:
Students –> IT and Computing –> Year 7 –> Self-Marking-spreadsheet
Plenary
Introduction to Spreadsheets (BUH)
Lesson Aim
-
Learn spreadsheet vocabulary
-
Create simple formulas
Starter
test_your_skills
Main Task
Download and complete the spreadsheet below:
Week 3 tuckshop – worksheet 17
Week 3 tuckshop with worksheet 17
Plenary
Spreadsheets plenary
Plenary
Spreadsheet Validation
Lesson Aim
- To validate data in excel spreadsheets
Starter
Teacher demonstrates how to validate using the spreadsheet below
Validation Teacher Demos NEW 2017
Main
Your task is to download the spreadsheet below and complete all the tasks including the validation.