Below is an Excel spreadsheet for marking Graphic Products 2011 coursework and mock exam marks. The cells will automatically change as data is inputted. It can be converted easily for many other subjects.

Click on image to Download.

 

Below is a 4 page resource for marking
Graphic Products 2011 coursework.
It was kindly donated by Duncan Scott,
Head of Dept at Rhyddings Business
& Enterprise School, Accrington, Lancashire.

Click on image to view larger picture,
or click here to download Publisher version.

 

Below is an Excel spreadsheet for marking Graphic Products 2011 coursework. It is based on the Confectionary Project. Copy and paste grades as work is completed. Pupils like the visual and will naturally ask how they can improve their marks.

 

KEYSTAGE 3:

The KS3 Mark sheet below can be adapted, but if columns are deleted or inserted the formula in the aggregate and NC Level columns will need to be adjusted. The NC Level formula needs to be manually manipulated to get a reasonably close result.