CAS Community   >   Resources   >  

OCR J277 GCSE Tracking Sheet

A spreadsheet that helps pupils to track their progress through the GCSE course.

James King

Created by James King
last edited Jul 01 2020 by James King

Resource description

This resource is a spreadsheet that can be distributed to pupils to allow pupils to track their own progress through the OCR GCSE Computer Science course. Giving pupils ownership of their progress and results rather than them being perceived by pupils as something that is controlled by and as the responsibility of the teacher can aid students to become self-directed learners.

How to use the spreadsheet

Rather than typing written instructions there is a 5 minute video displaying how to use the different elements of the spreadsheet.

Password protection

Most of the first sheet (My Progress) and a part of the second sheet (Work Record) are locked to prevent pupils from accidentally (or purposely) editing the formulas.

The password to unlock the sheets is: csteacher


This spreadsheet is an adaptation of the AQA 8525 GCSE Tracking sheet posted by Mick Flaherty.


On the ‘My Progress’ sheet:

  1. Unit 3 - Computer networks, connections and protocols is referred to as Computer Networks.

  2. Unit 1.6 - Ethical, legal, cultural and environmental impacts of digital technology is referred to as Impacts of digital technology.

This is simply because the unit names are too long to fit into the space available on the ‘My Progress’ sheet. On other sheets the units are referred to by their full names.

Downloaded 199 times.


This resource has attached files: to access these files, please tick the box below to assent to the license terms
License: The resources on CAS website are under Creative Commons Attribution-Share Alike 3.0 licence unless otherwise specified by the resource creators.

You must confirm that you have read and agree the licence's ToS before you can download the attachments of this resource.

I have read the licence agreement of this resource and agree to abide by its terms and conditions.

Feedback and Comments

Available when logged in (join via the front page, for free):
  • View 6 comments on this resource.
  • View resource history, links to related resources.
  • Leave feedback for the author(s), or help by editing the resource.