Shortcuts (works from anywhere until you quit):
- Ctrl + [ - Copy for CW/Exam Marks Entry pages
- Ctrl + ] - Copy for CW Marks Sub Component Entry page
- Ctrl + \ - Copy for OBE Exam Marks Entry (w/Breakup) page
- Ctrl + ; - Compare Student ID in Excel and CLiC
- Alt + q - Quit the program (interrupts it in case of any errors.)
This program copies a vertical column of marks from Excel into the coursework marks entry page in CLiC.
How to use:
- Open the Excel file containing your marks and place the Excel cell cursor at the top of the column of marks (on the first student's mark) you wish to copy. For Exam Marks Entry (w/Breakup), when there are more than 2 components, select the first row of student marks instead (remember to exclude the last column which auto calculates in CLiC). Ensure there is nothing in the cell below the last mark. Students with no marks should be given a zero in Excel. For Exam Marks Entry and OBE Exam Mark Entry(w/Breakup), copy the special grades (W, R, U, I) from CLiC marks entry page into the cell for the student's mark.
- Open Chrome, log into CLiC and navigate to the relevant marks entry page for your subject. Click on the component required, and place your cursor inside the box for the first student's mark.
- Press the shortcut key or the buttons in the GUI for the desired function depending on the marks entry page. Do not touch the keyboard while the script runs.
Repeat this with as many columns of marks as you need, selecting the correct start of columns in Excel and CLiC respectively. If you experience errors, you can try again without refreshing the page. This program does not click the save or submit buttons. You should be safe from errors, but remember to check and save your work.
This program can also check between Excel and CLiC if the order of Student IDs or the Total Coursework Marks entered matches between the two programs:
- Open the Excel file with your marks and place the Excel cell cursor at the top of the column of Student IDs/Total Marks (on the first student's ID/Total Marks).
- Open Chrome, log into CLiC and navigate to the relevant marks entry page for your subject. Make sure the cursor is not in the input box. (If you just opened the page, you don't have to do anything. Or you can click randomly somewhere on the text in the page.)
- Press the shortcut key or the buttons in the GUI for the desired function. Do not touch the keyboard while the script runs.
Note - you have to save marks entered before you can see Totals in the Coursework Marks Entry page. You don't have to submit yet so you can still make corrections.
While this script is running, a white & blue 'S' icon will be in your system tray. This program was built by Willie Poh at Hackerspace MMU's Hackathon No. 23. Version 1.5