OCR Nationals in ICT 2010 Unit 06 Design

  • Slides: 7
Download presentation
OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 3(b) –

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 3(b) – Sort and filter data (filters) OCR Nationals in ICT Unit 06: Design a Spreadsheets AO 3(b) – Sort and filter data (filtering data) Pupil Name

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 3(b) –

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 3(b) – Sort and filter data (filters) An example of a filter applied a single field of your spreadsheet. BEFORE What is the purpose of your filter? Screen print your work sheet before you filter the data, explain which field you will be filtering and why? Page 2

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your work sheet after you filter the data AO 3(b) – Sort and filter data (filters) AFTER Page 3

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets An example of

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets An example of a filter applied to two fields in your spreadsheet. AO 3(b) – Sort and filter data (filters) BEFORE What is the purpose of your filter? Screen print your work sheet before you filter the data using at least two fields. Page 4

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your work sheet after you filter the data using at least two fields. AO 3(b) – Sort and filter data (filters) AFTER Page 5

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets An example of

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets An example of a custom filter applied to your spreadsheet. AO 3(b) – Sort and filter data (filters) BEFORE What is the purpose of your custom filter? Screen print your work sheet before you carry out a custom filter. Page 6

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Screen print your work sheet after you carry out a custom filter. AO 3(b) – Sort and filter data (filters) AFTER Page 7