Demonstrate to students how to turn on the Text and Number filter in order to answer the query: Which subjects did I study during March?
Ask students to use the Filter in Excel to answer the query: Which subjects have I spent 2 hours or more studying on Saturdays?
Spreadsheets are used in this lesson to analyse data and to produce information using advanced filtering techniques. You may wish to discuss the analytical mindset which would be of use to learners in this learning sequence.
Introduces more complex ‘OR’ filtering: