M Robinson All Saints College Instructions this slide

©M Robinson (All Saints College) Instructions (this slide should be deleted before final hand-in) • This is an OCR National Unit 1 evidence book. • The yellow slides contain information on what you will need to do to achieve a pass. They are all compulsory (have to do) elements. • The blue slide contain information on how to achieve merit and distinction grades. These slides are not compulsory (discuss these with your teacher). • The information within the slides is for instruction only and can not be used as evidence, it must be deleted and replaced with your own work. • The only thing that will remain the same on the slides is the title which contains important assessment references. Replace this with your full name OCR Unit 1 ICT Skills for Business 1

©M Robinson (All Saints College) Assessment Information (this slide should be deleted before final hand-in) • • Blue slides must be attempted independently, teachers can clarify what has to be done but should not give instructions on how to do it. If you are not sure try using the help information on the main toolbar of most applications. Teachers can give demonstrations of some application features to the class. (So pay attention!). The difference between Merit and Distinction is often quality of explanation do not be afraid to add more slides if you want to put in more evidence to achieve these grades. Assessment Objective A reference to References Number statements on the Explained unit grading grid contained in the units OCR Specification Pass, Merit or Distinction Criteria A 01 Da Replace this with your full name OCR Unit 1 ICT Skills for Business 2

For Teachers Use Only Assessors Initials ©M Robinson (All Saints College) Internal Verifiers Initials Final Assessment Objective Grade AO 5 Create and use a simple business spreadsheet. View Header and Footer Replace this with your full name OCR Unit 1 ICT Skills for Business 3

©M Robinson (All Saints College) A 05 Pa Candidates will create a very simple business spreadsheet using a limited number of calculations. • Use the Data supplied and input it into a spreadsheet. Your teacher should show you how to do Cell References and Copying to make it easier to do the formulas. • Show a full page screenshot of your spreadsheet here. • To do this, delete this text and then go to Format / Slide Layout and choose this content layer. Replace this with your full name OCR Unit 1 ICT Skills for Business 4

©M Robinson (All Saints College) A 05 Pb The functions/formulas may not be efficient, but will work. • When you have entered the data. Add formulas to total up the main data columns. =SUM(A 2: A 3) • Add a formula to find the average of a column. =AVERAGE(A 1: A 6) • Show your formulas by going to Tools/Options and then the View tab should have a check box for Formulas. • Produce a full page screenshot here (See this slide for reference) • Uncheck the Formulas box in the View tab. Replace this with your full name OCR Unit 1 ICT Skills for Business 5

©M Robinson (All Saints College) A 05 Pc There will be sufficient row/column headings to make the spreadsheet reasonably easy to understand. • Put in Headings for all your Columns and Rows. • Put in a label for the total. • Produce a full page screenshot here (See this slide for reference) Replace this with your full name OCR Unit 1 ICT Skills for Business 6

©M Robinson (All Saints College) A 05 Pd Some formatting features, eg font style and size and paragraph justification will have been used • Select what you need to format and go to the Format menu/ Cells. All the formatting features can be done from here, see below. • Use shading for your Headers and labels. • Change the font size and Style • Put borders around the main data. • Centre your headings. • Produce a full page screenshot here (See this slide for reference) Replace this with your full name OCR Unit 1 ICT Skills for Business 7

©M Robinson (All Saints College) A 05 Pe There will be evidence that some of the data has been changed to obtain different results. Answer the first two questions in the case study and show the before and after screenshots here. • Use the Drawing menu Autoshapes Call outs to show your answers. Replace this with your full name OCR Unit 1 ICT Skills for Business 8

©M Robinson (All Saints College) A 05 Pf Candidates will print out their spreadsheet although the format of these printouts might not be suitable. • You should print out your spreadsheet so that it fits on one page. Show you do this with a screenshot and brief explanation. Replace this with your full name OCR Unit 1 ICT Skills for Business 9

©M Robinson (All Saints College) A 05 Mac Da Candidates will create an effective business spreadsheet displaying accurate figures. It will contain a title and appropriate row/column headings. • Your teacher should show you how to do Cell References, Copying and Naming to make the additional tasks easier with the formulas. • Show a full screen print of your wages spreadsheet finished. Make sure you include a title. Replace this with your full name OCR Unit 1 ICT Skills for Business 10

©M Robinson (All Saints College) A 05 Md Dd. There will be some evidence of a range of formatting options. • • Show screenshots of formatting your wages spreadsheet include the formatting box. You should have used every tab in some way. Describe at least three formatting options that you used. Delete me! Replace this with your full name OCR Unit 1 ICT Skills for Business 11

©M Robinson (All Saints College) A 05 MDb Several different formulas will be used effectively and more than one function will have been used. • • Produce a print screen of the formulas in the wages spreadsheet. List the different functions used here. Replace this with your full name OCR Unit 1 ICT Skills for Business 12

©M Robinson (All Saints College) A 05 MDe There will be evidence that some of the data has been changed to obtain different results Answer questions 4 and 5 in the case study and show the before and after screenshots here. • Use the Drawing menu Autoshapes Call outs to show your answers. • N. B. These things! Replace this with your full name OCR Unit 1 ICT Skills for Business 13

©M Robinson (All Saints College) A 05 MDg Candidates will edit the spreadsheet by inserting/deleting rows. • • Fred has put his hours in all wrong. Delete the line and replace it with the following data: Fred worked the following hours in a week. Monday 7 hrs Tuesday 6 hrs Wednesday 7 hrs Thursday 7 hrs Friday 4 hrs Saturday 3 hrs Screenshot the after and try and show the delete option in your screenshot as shown. • Screenshot this while doing Question 6 in the case study, • Explain these operations here. Replace this with your full name OCR Unit 1 ICT Skills for Business Example 14

©M Robinson (All Saints College) A 05 MDfh Candidates will preview and print out their spreadsheet using appropriate page orientation and number of pages. Formula printouts will be included • • • Show you selected page orientation and how you selected the number of pages your sheet would fit too. On your second screenshot show the sheet in print preview. You will be told by your teacher how they want you to proceed with actual printing. Replace this with your full name OCR Unit 1 ICT Skills for Business 15

©M Robinson (All Saints College) A 05 Dc They will use appropriate headers and footers and will set other print layout features appropriately. • • Show you have used Headers and Footers. In the second screenshot show the use of the Set Print Area option. Replace this with your full name OCR Unit 1 ICT Skills for Business 16