Uncategorized – Page 12 – Mr Ali's ICT Blog

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.

Validation Pupil Tasks

Spreadsheets – Conditional formating

Starter

Cond Formatting Teacher Demos

Main

Conditional Formatting Pupil Tasks

Protected: Year 7 – Spreadsheet exercises

Blended Learning

Upload your presentation here

Presentation upload

Example Presentation

This is an embedded <a target='_blank' href='https://office.com'>Microsoft Office</a> presentation, powered by <a target='_blank' href='https://office.com/webapps'>Office Online</a>.

Protected: Resources 4 Btec ICT

Unit 43 – Multimedia

ECDL – Spreadsheets Test

Lesson Aim

Prepare for the ECDL Spreadsheets test

Main

Download the Test below and complete it using the files under resources:

Unit 4 Sample Test

Resource Files