Lesson Aim
-
Learn spreadsheet vocabulary
-
Create simple formulas
Work for Mr Ali's Classes
Week 3 tuckshop – worksheet 17
Week 3 tuckshop with worksheet 17
Teacher demonstrates how to validate using the spreadsheet below
Validation Teacher Demos NEW 2017
Your task is to download the spreadsheet below and complete all the tasks including the validation.
Your Task
In preparation for AO5 you will carry out a practice task. Follow the instructions on the worksheet to create a spreadsheet to work out the costs for a student trip. Ensure you complete the evidence sheet as well. If you get stuck use the links to the tutorials.
Download and save the files to your folder:
If you complete the task then go onto Nexus and start to create a spreadsheet for AO5. Click on the link below
You will need to work on the worksheets in Spreadsheet below to revise all the spreadsheet techniques you learnt last year.
Extension
Complete the spreadsheet below
Complete the Paris costs spreadsheet , if you have not already started the evidence sheet click on the link below to download it:
If you have finished the Paris costs evidence ensure all files for unit 1 are in the correct folder.
You may then create a Xmas card in Publisher or word
For example your spreadsheet could include:
Your spreadsheet must include column headings, row labels, a title, text and numeric data.
It maybe a good idea to draw the spreadsheet on paper first with headings to give you an idea of what you will try to produce.
For example:
You must use at least two different calculations in your spreadsheet.
TIP
For Merit level you must use several different formulas including at least one function and one arithmetic operator.
For Distinction level you must use several different formulas including at least two different functions and two different arithmetic operators.
You might, for example, format:
TIP
For the higher levels you will need to preview before printing and make sure you have chosen the options that will fit your sheet most effectively onto the paper. (you should printscreen using print preview)
For Distinction level you should also set appropriate headers and footers and other appropriate print options (eg margins, gridlines, row and column headings, setting a print area).
Change some numeric data to model the expected outcome for at least two different scenarios, for example you might increase and/or decrease the transport cost to investigate what happens to the final cost or you could investigate what would happen to the total cost of the trip if the entry fees to the attractions were increased and/or decreased.
Print the results of each change and annotate the changed outcomes as a result of the changes you carried out.
(Higher levels only)
The efficiency of your spreadsheet, including the formulas you have used, as well as the appropriateness of the formatting options you have applied, will be a significant factor in determining the grade you are awarded for this Assessment Objective.
(Evidence could be printouts of the original and changed spreadsheet and for the higher levels formula printouts. At Pass level you might evidence your formulas through the electronic file of your spreadsheet or through screen prints. Changes to data and setting of print options should be
annotated.)