AVCE – Unit 3 – Spreadsheet Design

I have found an excellent website which should provide some good materials and support for you in your work on Unit 3 of AVCE

http://www.pbwg.freeserve.co.uk/y12/index.html

The table below has only been slightly changed for you to work through. It is based on the material on the above website.

I have sent e-mail to the school that has posted the site – checking that they are happy for us to use it. In exchange I have offered them full access to our website with all our materials.

Recommended sequence of work: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

About this Unit	Reference Links	Skills Development	Assignments
Background information that you may find useful. Please note the message about Acrobat Reader files (.pdf) – they will only open if you already have Adobe Acrobat Reader running. It can be started from C:\Program files\Adobe BEFORE you try to open the .pdf file.	You will find some of these links – especially the Excel tutorials – very useful for this unit. The Osborne Books website includes some useful example documents that you may find helpful when doing the final assessment.	Use these links whenever you find the Help system unsuitable for the assignment you are working on. Some very useful ideas and techniques are shown here.	These assignments are to help you to use some of the more advanced features of Excel. Try to work through them – allowing yourself at least one lesson per assignment – and where necessary use the Help system built into Excel to assist you with the tasks.
What you need to learn about The concepts and skills listed in the unit specification Assessment Evidence The evidence needed to achieve Grades E, C and A in the final assessment Full OCR Specification for Unit 3 (.pdf file) Before you open any .pdf Adobe Acrobat file you should start the latest version of Adobe Acrobat Reader	Data Protection & Copyright Standard business forms from the Osborne Books web site (.pdf file) Excel tutorials on the WWW: Excel 97 (Tutorial 1) – covers the basics and a bit more! This “Quick and dirty guide to Excel” is brilliant. It covers everything you will need. More advanced tutorial – this covers filtering, sorting and sub-totalling data, macros, protecting and naming cells, and pivot tables. Tutorial workbook – this is a .pdf file and can therefore be downloaded and printed (if you have lots of paper and money!)	Excel Charts Creating charts (graphs) in Excel Discount Methods Using a variety of formulae and functions to set rates of discount Spreadsheet Revision 1 A review of some of the key concepts IF statements and Logical Operators Revision of IF statements and introduction to AND & OR statements. WHAT IF Queries Setting up spreadsheets to solve problems Linking Worksheets Introducing some advanced features and links between sheets	Assignment 1 Staff bonus payments Assignment 2 Phone cost calculator Assignment 3 Creating an invoice form (for guidance on the design of the invoice look at the business documents on the Osborne Books web site) Assignment 4 Improving on a current invoice form. This link will open a window with details of an Excel workbook. Assignment 5 Adding charts to an Excel worksheet Assignment 6 Applying methods of calculating discount Assignment 7 Using named ranges of cells
FINAL ASSESSMENT For AVCE Unit 3 Spreadsheet Design Click here when you feel you are ready to start the spreadsheet assignment for Unit 3 AVCE.