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

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

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.
Author:
Publish date:
Image placeholder title

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."

Featured

Related

Florida School Saves Administrators Time by Implementing Twine promo image

Florida School Saves Administrators Time by Implementing Twine

Pensacola, Fla. (Nov. 29, 2016) — In a growing school system, educators must find innovative solutions to streamline everyday instructional and administrative tasks. To simplify their report card process and other school communications, Lighthouse Private Christian Academy recently rolled out Twine, an integrated LMS designed specifically for K-12 private schools.  Lighthouse Private Christian Academy is located in Florida and caters to an expanding student population. Prior to adopting Twine, Pam Miller, principal of the College Prep campus, spent on average 18 hours per quarter creating report cards by hand. 

System Failure

It's much better to allow teachers to focus on the big picture than to make them follow a rigid plan that allows for no flexibility and no professional judgement.