OCR Nationals in ICT 2010 Unit 06 Design

  • Slides: 19
Download presentation
OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 –

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet OCR Nationals in ICT Unit 06: Design a Spreadsheet AO 2 – Format a spreadsheet to make it user friendly Pupil Name

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Screen print Worksheet One, annotate to show the formatting you have used, borders, colours, fonts and shading etc Page 2

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Use screen prints to show where you have adjusted a row height or column width Page 3

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Use screen prints to show where you have changed the direction of text in a cell. Page 4

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Screen print worksheet showing the comments for the user Page 5

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints show to change the page orientation and the number of pages printed. Include a print preview screen. Page 6

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Screen print Worksheet Two, annotate to show the formatting you have used. Cell colours must distinguish between different cell types Page 7

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints show to hide and show rows or columns Page 8

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints show where you have merged cells Page 9

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints show where you have wrapped cell text Page 10

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Give an example of using user validation, include the input message and an example of the validation error message Page 11

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Using screen prints

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets Using screen prints give an example of conditional formatting. AO 2 – Format a spreadsheet Making the output visually clearer. Page 12

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints show to add header and footers to your spreadsheet, include a print preview screen Page 13

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Using screen prints to show to add another print layout feature Page 14

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Screen print an example of using a drop down box Page 15

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Show to set up cell protection to limit the user from adding / edit data. Page 16

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Screen print an example of using cell protection Page 17

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Formatting and validation checklist. Examples of different text, font and sizes, background colour and border Text, background colour and border to distinguish different cell types Example of adjusting cell height or width Example of merged cells. Example of hiding and showing rows or columns Change the direction of text Shown some wrapped text in a cell Included a cell comments Included a cell validation Included a useful cell validation conditional formatting. Change the direction of text Included a cell comments Drop down list worksheet protection Page 18

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

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 2 – Format a spreadsheet Hand in your spreadsheet to the teacher. . . . Page 19