|
OCR GCSE Project 1b Resources
 This page has some resources which may be useful for completing OCR GCSE Project 1b Modelling or Spreadsheet.
Here is a link to the project tasklist. This list specifies all the items you need to complete to get a C grade. In order to get higher grade you must then move on and create your own model, and you must document each aspect of the sheet.
Tasklist
The following demonstrations outline what is involved for the task. It is up to you to document your investigation.
Step 1
Step 2
Step 3
Step 4
Step 5
Step 6
Step 7
Step 8
Step 9
Step 10 - this is a discussion section.
Creating your own sheet
Getting started
Some simple techniques and formulae
Adding some validation to a sheet
Using a COUNTIF statement to count values in a range
Using a VLOOKUP to lookup results in a named lookup table
Using the MIN, MAX, and Average functions
Conditional formatting - no sheet should be complete without this.
Original spreadsheet
|
