OCR J277 GCSE Tracking Sheet

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.

https://flashbackconnect.com/Movie.aspx?id=LAuX2f0I3AOx9bM5AwDPqA2

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

Credits

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

Notes

On the ‘My Progress’ sheet:

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

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.