Free Timetabling Software

FET is open source free software for automatically scheduling the timetable of a school, high-school or university. It uses a fast and efficient timetabling algorithm. It is licensed under GNU GPL.

Usually, FET is able to solve a complicated timetable in maximum 5-20 minutes. For simpler timetables, it may take a shorter time, under 5 minutes (in some cases, a matter of seconds). For extremely difficult timetables, it may take a longer time, a matter of hours.

Electronic Markbook / Pupil tracking system

This spreadsheet functions as an electronic mark book. It automatically tracks the progress of each student against the class average and displays a graph allowing you to see which pupils are beginning to under-perform. It also makes report writing much easier as you can see at a glance how the student has performed over the term.

It automatically calculates the averages for each piece of work completed and can include data columns - for instance mid-term grades and final report grades if required (but the maximum mark box must be EMPTY).

The spreadsheet is automatically weighted and assumes that the importance is related to the maximum number of marks for an assignment - a 55 mark test is 5x as important as a 11 mark prep. This can be changed by entering a value in the weighting column - if you require the 11 mark prep to have equal weighting with the 55 mark test either change the weighting of the test to 11 or the prep to 55 depending on the other marks in the spreadsheet. if you would like all the pieces of work to have equal weighting, then put the same number (any number) along the weighting row.

e.g. 1 1 1 1 1, or 20 20 20 20 20, etc...

 PTS Markbook v0.41
 PTS Markbook v0.45

New Version 0.45 - Works in (the free) open office. Download from http://download.openoffice.org/






























The red pupil's attainment has consistently slipped relative to the class average, whereas the blue pupil has improved and the green pupil went through a bad patch in the middle of the assessment period. PTS Markbook v0.45

Magic UMS (OpenOffice spreadsheet)

MagicUMS is a straightforward UMS calculating spreadsheet. Requires the FREE OpenOffice suite. ( http://download.openoffice.org ) - alternative to Microsoft Office.

It allows you to easily combine the raw marks for up to 3 papers and instantly converts to UMS marks complete with grade achieved. The results can be copied and pasted into word or another spreadsheet.

The tab can be copied and renamed so you can keep the results for different classes on different tabs in a single excel file.

Simply input the maximum mark for each paper, the weighting of the paper, adjust the grade boundaries if necessary and then input the names and marks of each student and the UMS marks and the grade magically appear.

If necessary the names of the grades and the UMS marks awarded for each grade can be changed.

Only the areas in green need to be filled in, the areas in grey can be adjusted if absolutely necessary. If there are less than 3 papers set then the weighting should be set at zero for the unused one. The weighting can be in any ratio 1:4:3 works out exactly the same as 20:80:60.

There is a possibility that the G/U grades are not automatically completed for this version, but hopefully you won't need them!

MagicUMS v0.75(3) ODS

Report writing made easy...

There is a wonderful free program which allows you to create  reports tailored to individual students by combining single statements from banks of customisable comments.

http://www.rayslearning.com/report.htm

Currently only for Windows.