The link below will allow you to download or run a set of Excel macros designed to process raw coursework marks to conform them to the University template for 2012/2013 Semester 2. The conformation process includes separating out marks for students not registered in the template and for a few other common problems.

https://dl.dropboxusercontent.com/u/23984607/SJUTresults/SJUTresults.xls

This software is in active development, so please download the latest copy immediately before processing results. For example, this version requires manual corrections to the problem data in the source file while a version due out in a few days will walk the user through some of the simpler corrections. This version will merge multiple sets of results, contained in either multiple files, on multiple sheets in one file or multiple sections on a single sheet.

Note: While this software has subjected to testing and is considered reliable, the user should scan through the final results file to check that things like the course code, faculty , etc. are correct. A most important check is that the marks are OUT OF 100. The software defaults to “out of 100” so be sure to select the “out of 50” option before processing, if necessary.

Please direct any comments, questions or suggestions to either Mr. Salaman or Dr. Ham. An easy way to do that is by replying to this post on this website.

https://dl.dropboxusercontent.com/u/23984607/SJUTresults/SJUTresults.xls

Changes in this version:

  • Processes multiple sources into one results file
  • Lists faculty found in template for students whose faculty is not included in the list of those who should be in the course
  • Closes itself after completing the processing.

Known problems

  • Not properly handling duplicate results
  • Cannot edit individual items in the multiple source list, but must delete and re-enter.

Changes planned

  • Automate assistance in cleaning up various “Bad CW” problems such a 0 coursework, registration numbers missing leading 0’s or havine O’s instead of 0’s.
  • Minor UI improvements to make it more “self-explanatory” and to reduce the chances of common mistakes such as leaving the CW out of selection unchanged or not setting the course code.
  • More graceful handling of common errors such as trying to process without making selections for all the boxes.
  • Editing the individual records in the multiple source dialog.