Skip to main content

How to create a grade-prediction system in Excel, and save yourself loads of time

How to create a grade-prediction system in Excel, and save yourself loads of time

Help is at hand...

Imagine this. You have to mark and assign grades to the two classes of students you teach. That's 60 students. Your colleagues each have to do the same. You, as the head honcho, are responsible for the whole shebang: making sure the marks are in, grades awarded, and reports to parents out. All in the next week or two.

And, you do get time off timetable to do it all, right?

Yes, that’s what I thought….

A few years ago, finding myself in exactly this position, I devised a simple but effective grade predictor in Excel (although you could use any spreadsheet that has a lookup function), for use with mock exams.

What the grade predictor is not

Read more.

cross-posted at www.ictineducation.org

Terry Freedman is an independent educational ICT consultant with over 35 years of experience in education. He publishes the ICT in Education website and the newsletter “Digital Education."