jpg, 328.07 KB
jpg, 328.07 KB
jpg, 335.96 KB
jpg, 335.96 KB
xlsm, 395.31 KB
xlsm, 395.31 KB
docx, 346.45 KB
docx, 346.45 KB
jpg, 114.39 KB
jpg, 114.39 KB
jpg, 132.93 KB
jpg, 132.93 KB
jpg, 267.57 KB
jpg, 267.57 KB
Excel (Office 2007 - macro enabled) workbook that provides a visual track of pupil progress. This is designed for a Year 7 Science class of 25 students. Once baseline data is entered (either Y6 SAT or Sept. baseline test results or both) then a class average is plotted (red) together with a 3 sub level increase target for the class (Outstanding). NC expectations are also shown.

Individual students can be added or removed from the graphic at will.

As it is based on NC Y7 Science, which I teach two units at a time, data points that are plotted are an average of two levelled tasks every six weeks or so. Could easily be adapted for any KS3 subject.

I've removed the protection on this version so that it can be adapted to individual needs. I'd be happy to entertain any suggestions for improvements or adaptations.

I have added sufficient sheets for 4 classes of 25 students in each of Years 7,8 and 9. Adding more sheets by copying existing ones can be done but every student needs to be checked in the sheet you are copying before you make the copy. If this is not done then the copied chart remains linked to the original data in the sheet it was copied from.

I am really conflicted about charging for this, but at the end of the day, adapting it and making it "generic" has taken quite some time. I generally use a free CC license but since there are several commercial products that offer similar functionality I feel entitled to profit from my meagre efforts.

Reviews

5

Something went wrong, please try again later.

joseph_c2

7 years ago
5

Hi Gavin, It's a great bit of kit. I'm struggling changing the years from '15 to '17. It seems to ruin the formatting of the graph. If possible, what cells/ formulae can I change to rectify this ( if possible)? Thanks in advance, Joe

Miss_Jo_Parker

9 years ago
5

Hi, This is really great.<br /> I am enjoying adapting this for the school. Do you have a KS4 one that is similar or can you offer any advice.. for a non excel expert on how to adapt to make it suitable.<br /> Really worth the £3- thanks so much

nclina

9 years ago
5

Hello Gavinmatchell, thank you for the resource. Unfortunately I can't check the box next to the students names. It says macro is disabled. I need help on this. Please advice me.<br /> <br /> Thanks a lot

barclayfox

9 years ago
5

Hello &quot;gavinmatchell&quot;, please don't be conflicted about selling this, Instead please accept my thanks for creating and sharing something so useful (I've just been playing with my new purchase). I would not have been able to create this for myself without spending a huge number of hours doing so, so for £3 I consider it a bargain - thank you again !

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.