Grade management: the alternative to the Excel list

Keeping grades in an Excel sheet works – until the formula shifts because someone inserted a row, three file versions are in circulation and nobody can say which list counts. SchuleVernetzt is the Excel alternative for grade management: one way of calculating for everyone, one set of data instead of file copies, and access tied to a role instead of to a mail attachment. Excel is a strong tool – for grade data it is the wrong one.

Notify me See all modules

Coming soon

  • GDPR-compliant
  • Hosted in Germany
  • Free for teachers

A product of SavePaper.work

Benefits

Where the grade list in Excel reaches its limits

One calculation instead of many formulas

Weightings live in the system per class and subject, not in a cell. The average is worked out the same way everywhere – even when someone inserts a row or copies a sheet for the new class.

One set of data instead of file versions

No copy on the USB stick, no second version in the mail inbox. Everyone works on the same state of things, and every change is traceable with person and time.

Access by role, not by file

Whoever has the file sees everything in it. In the system each teacher sees their own classes and subjects, the school management its own area – separated from each other and logged.

From the entry to the report card

The report-card grade comes out of the grades that were logged, not out of a retyped summary. The intermediate step in which a transposed digit creeps in simply disappears.

How it works

How the switch from the Excel list works

Switching needs no project plan and no training: create the classes, set subjects and weightings, transfer the existing list – from then on averages and report-card grades work themselves out.

1 2 3 4
  1. 1

    Create the classes

    Create a class and upload the student list as CSV – the format every spreadsheet exports anyway: first name, last name, class. A preview shows duplicates and faulty lines before anything is saved.

  2. 2

    Set subjects and weightings

    Per class and subject you define the grade types: an exam counting double, a quiz once, oral participation once. The weighting is settled once and applies to every grade that is added later.

  3. 3

    Transfer the existing list

    You enter the grades of the current period directly, one field per pupil, with the weighting already stored. For periods that are over, the previous standing as a single weighted grade is enough.

  4. 4

    Averages and report-card grades

    From here the system calculates: weighted average per subject, class average, grade notation with plus and minus and a proposal for the report-card grade that the teacher confirms or overrides.

In comparison

SchuleVernetzt and the grade list in Excel

SchuleVernetzt
Way of calculatingWeighting per class and subject, stored centrally
State of the dataOne version, up to date everywhere
Access and evidenceRoles, a log of access and changes
Path to the report cardReport-card grade proposed from the logged grades
Grade list in Excel
Way of calculatingFormulas per sheet that shift when copied
State of the dataCopies on a stick, a laptop and in the inbox
Access and evidenceWhoever has the file sees everything in it
Path to the report cardValues copied into the report form by hand
In detail

Grade data, data protection and life with spreadsheets

Why grades deserve strong protection

Grades are personal data, and they weigh heavily: they describe a child's performance over years and have an effect on transitions and qualifications. Responsibility lies not with the individual teacher but with the school. If the grade list sits as a file on a private laptop, in a private cloud folder or as an attachment in a mail inbox, the school can no longer show where the data is and who has seen it. That is the difference to processing in the system: the school signs a data processing agreement, the data sits on servers in Germany, access is tied to a role rather than to owning a file, and a continuous log of access and changes builds up. What is required in detail, each federal state regulates differently.

Where a grade list in Excel breaks

The breaking points are rarely spectacular, they are quiet. An inserted row moves the range the average formula points at: the value still looks plausible but is wrong. A sheet copied for the new class brings the old references with it. The grading scale is rebuilt in every staff room, with slightly different point thresholds. On report day the file on the school computer, the weekend version from home and the copy in the mail attachment all exist, and none says which one counts. Overwrite a file by accident and, without a version history, there is nothing to go back to. None of this is a fault of Excel. It is the limit of a tool built for calculation sheets, not for personal data kept jointly.

Retaining, deleting, staying able to answer

Grade data does not disappear at the end of the school year, it is subject to retention periods – and those differ greatly by type of data and federal state: attendance is kept far more briefly than report-card data. In a collection of spreadsheets the two can hardly be separated; usually nothing is deleted at all, because nobody knows any more what is in which file. In the system each type of data hangs on its own period, which the school sets for its federal state, and classes are archived at the turn of the school year instead of being deleted or copied. If a family asks what is stored, everything about one pupil exports as a machine-readable file and as a table, with nobody searching through folders.

Switching is not a project

Class and student lists come over as CSV – exactly the format every spreadsheet exports. Grade types and weightings are set in a few minutes, after that you only log marks. The old file may stay where it is: as an archive, not as a working copy.

See all modules
FAQ

Frequently asked questions about the Excel alternative

No, a spreadsheet program is not forbidden. But the school has to be able to show who accesses grade data, where it is stored and when it is deleted – and a file does not do that on its own. Depending on the federal state, separate rules apply; the school's data protection officer knows them.

No. One teacher can start with their own classes while the rest of the staff stays with the current solution. If the school later adopts SchuleVernetzt together, the classes and grades already logged move into the shared set of data.

The weighted average is the sum of grade times weighting, divided by the sum of the weightings – the same calculation as in the spreadsheet. One difference remains: anyone without a grade yet gets no average rather than a zero.

Class and student lists yes: SchuleVernetzt reads them as CSV with first name, last name and class, and a preview shows duplicates and faulty lines before saving. For the grades themselves there is no import, because every grade sheet is built differently. The usual route is to start at mid-year and carry the previous standing over as a single weighted grade.

It is at least an open question. Responsibility for the data stays with the school, but on a private device it can neither limit access nor show what has happened to the file. What is permitted here, the federal states regulate differently. Working in the system sidesteps the question: the file never comes into existence at all.

The class is archived rather than deleted: grades, report cards and histories stay traceable but no longer show up in the active set. How long each type of data is retained is set by the school for its federal state – report-card data far longer than attendance. After that, deletion follows the period, not a hunch.
Discover more

More modules in this category

View all modules
Digital Notice Board for Schools
School Management Software
School software and the GDPR
Introducing school software
IServ alternative
Schulmanager Online alternative
Grade Calculator Tool
Coming soon

Be there when SchuleVernetzt launches

We're building SchuleVernetzt at full speed. Leave your email and we'll notify you the moment your school can get started – free and with no obligation.

We use your address only to notify you at launch, and you can unsubscribe at any time.