I've just finished the first version of the Exam File Split program.
The program was born out of necessity: SIMS does not support multiple exam centre numbers, and Capita refuse to provide support. At the same time, exam boards do not want split site schools to use a single centre number, as this means transferring exam papers between sites: if a paper gets mis-laid/lost/stolen, that exam has to be canceled for the entire country. Understandable really!
So I have created a simple program which will take the exam entry or amendments file that your MIS produces and split it for you based on a set of configuration files you provide it.
There are instructions in the readme as well as example configuration files, but if you need any help setting it up let me know.
Oh, and a disclaimer:
Currently there is only myself using it and I'm waiting to hear back from one other person how they get on with it, so your feedback is welcome.Use this software at your own risk, I accept no responsibility for any missed entries, incorrect file formats or exploding PC's that may occur from your use of this software! That being said, if you need any help feel free to contact me.
If anybody would like to look at the source code (it's nothing special but some people prefer to know exactly what a piece of software is doing) then let me know and I'll make it available.
Exam File Split
good work sir
UPDATE: I've now added in more validation routines, so you will now get warnings if the total number of students in your original submission file doesn't match the total number split out with reasons why this could happen (still the same link as above)
Nice work. Not come across the problem before but sounds like a simple solution to a real big problem for schools.
Don't know if anybody has ever actually used this, but just in case:
I've just made a small update to the program, and the new version can be downloaded from the same link provided in the opening post.
- Error messages slightly rewritten for clarity
- Student ID's are now zero padded to make them the required 4 digits long, this was to solve an issue with Excel stripping preceding zeroes from ID numbers prior to saving as CSV
Would you be willing to share the source code?
Of course if EduGeek were to start an "umbrella" project I'd contribute it
If you wish to contribute it as an edugeek project it can then have it's own section under the projects section but you may not want to do that.
Alternatively google code is good for hosting your code.
For simplicity's sake (and the fact it doesn't appear to be all that popular!) for now I'm just going to provide the zipped C#.net project, but if it does pick up interest a bit (which it might do with a seemingly growing number of schools merging), then I'll look at starting an EduGeek project here to give people a good base for help.
The source can be downloaded from here: Exam File Split (Source)
From now on, if I make any changes, I'll replace that ZIP with the updated source.
This looks interesting. We have multiple centre numbers (one for each board, it seems). We're not a split site, though, I think it's just the way it was originally set up and the exam boards don't want to merge the numbers!
Does this program support more than two centre numbers? If so I might have a word with our Exams Officer. It'd save him the job of changing the centre number in Exams Organiser to produce the entries. We'll try tackling the exam boards again, but this may be an alternative if that fails.
Thanks for this!
@northernsands - i believe that's exactly the kind of situation this program was designed for.
Give it a try.
@VikPaw. Thanks (and for the invites). I will have a look. When I have time. Inshallah! It might have to wait until the next exams season.
There are currently 1 users browsing this thread. (0 members and 1 guests)