# OCR Nationals in ICT 2010 Unit 01 Using

• Slides: 14

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet OCR Nationals in ICT Unit 01: Using ICT in Business AO 5 - Creating and using spreadsheets Pupil Name

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Describe the aim and purpose of your spreadsheet Who will use your spreadsheet (audience) AO 5 : Creating and using a spreadsheet What information needs to be on worksheet 1 Optional - What information needs to be on worksheet 2

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Spreadsheet design and plan – annotate to show key formatting and the main formula and functions used.

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Screen print Worksheet 1, showing and explaining the formulae you have used. Using a minimum of two different calculations. use several different formulas and at least one function effective formula and more than one function

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Screen print Worksheet 1, annotate to show the formatting , include titles , row/column headings, borders, colours, fonts and shading etc Use a range of formatting Use a range of effective formatting

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Optional - Screen print Worksheet 2, showing and explaining the formulae you have used AO 5 : Creating and using a spreadsheet

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Optional - Screen print Worksheet 2, annotated to show the formatting you have used. AO 5 : Creating and using a spreadsheet

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Modelling scenario one: Using screen prints show which numerical data you need to change, give the reason why and predict what will happen?

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Modelling scenario one: Show what happened after you changed the variable value. AO 5 : Creating and using a spreadsheet Explain the results

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Modelling scenario two: Using screen prints show which numerical data you need to change, give the reason why and predict what will happen?

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Modelling scenario two: Show what happened after you changed the variable value. AO 5 : Creating and using a spreadsheet Explain the results

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Using screen prints show to change the page orientation and the number of pages printed. Include a print preview screen.

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Using screen prints show to add header and footers to your spreadsheet, include a print preview screen

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 5 : Creating and using a spreadsheet Printout your spreadsheet(s) 1. 2. Worksheet 1 showing formatting Worksheet 1 showing formulae 1. 2. (Optional) Worksheet 2 showing formatting Worksheet 2 showing formulae