# OCR Nationals in ICT 2010 Unit 06 Design

• Slides: 7

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet OCR Nationals in ICT Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Pupil Name

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Describe the aim and purpose of your spreadsheet What information needs to be on worksheet 1 Who will use your spreadsheet (audience) What information needs to be on worksheet 2 Page 2

Spread sheet planning sheet Name: Worksheet: Page: Plan your spreadsheet

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Screen print Worksheet One, showing and explaining the formulae you have used q Copied and used extra pages Page 4

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Screen print Worksheet Two, showing and explaining the formulae you have used q Copied and used extra pages Page 5

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Formula and Content checklist. One sheet Two linked sheets at least two of +, -, * and / including +, -, *, / , and brackets Functions from two categories Functions from three categories • Arithmetic functions: SUM, MAX, MIN, AVERAGE, MEDIAN, COUNT, COUNTIF • Arithmetic functions: SUM, MAX, MIN, AVERAGE, MEDIAN, COUNTIF • Trigonometric functions : SIN, COS, TAN, LOG, POWER, RND • Rounding functions: INTEGER, ROUNDUP and ROUNDDOWN, TRUNC • Lookup functions: VLOOKUP, HLOOKUP, MATCH • Reference functions: ROW, COLUMN • Text functions: LEFT, MID, RIGHT, LEN, VALUE, TEXT, CONCATENATE, FIND • Date and time functions: TODAY, NOW, YEAR, MONTH, DAY • logical functions: IF, AND, OR and NOT, nested IF statements IF Statement Relative cell referencing Relative or absolute cell referencing Relative and absolute cell referencing Page 6

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 1 – Develop a spreadsheet Hand in your spreadsheet to the teacher. . . . Page 7