Gradebook known issues
as at 21st October 2011.
Rounding between Gradebook and the spreadsheet
Gradebook only accepts marks to 1 decimal place. You can enter a mark with more than 1 decimal place in the spreadsheet but this may not validate on the import.
Importing a scaled calculated grade does not update audit log
When you import a spreadsheet, you import the scaled cumulative mark and scaled calculated grade. The audit log in Gradebook is updated to reflect a change to the scaled cumulative mark but not when the scaled calculated grade is updated.
Non-teaching staff assigned to a subject site are receiving many annoying announcement emails
When an announcement is added to a site, it is sent via email to all ‘active’ site members regardless of their role. Gradebook relies on various non-teaching staff in different roles to perform specific Gradebook functions, for example, Grade sign-off, marking.
An MS Outlook rule has been created to send these emails to your Deleted items folder.
Add email rule Instructions:
- Right Click: "Save As" this link: Microsoft Annoucement Rule, and save to your desktop
(or somewhere handy for you)
- In Outlook go to ‘Tools > Rules and Alerts’.
- Click the ‘Options’ button then click ‘Import Rule’.
- Navigate to the ‘announcement_rule.rwz’ you downloaded/received previously and click ok.
- The rule is now added.
The rule will delete all emails from Interact Announcement tools. The rule currently contains one exception (emails from the ICT Integration site) but more can be added by following the below instructions:
- While in ‘Rules and Alerts’ single click to highlight ‘Announcement Notification Filter’.
- In the ‘Rule Description’ below you will see and exception ‘ABOUT ICT Integration’, click this.
You will now be able to add in additional names of sites you DO still want email notifications from.
Exporting to Excel
If you have Excel already open and perform an ‘export to excel’ from Gradebook, sometimes the Gradebook spreadsheet is opened minimized (ie does not open maximized on your screen). This is intermittent and is controlled by Excel, Windows and Internet Explorer and hence cannot be fixed.
Exported CSV file does not have the same headings/data as Excel file
When exporting the CSV file, it does not have all the same data as when you export the Excel file.
The information after the marks/grades (grade comment) is not the same .
Excel has CRN, Subject Code, Campus, Mode, Course, Site Code, FAC / Teaching School
CSV has Subject, Campus, Mode, CRN
Gradebook slow to import/ export spreadsheets
Importing and exporting the Gradebook spreadsheet can be slow particularly if there is:
- a large number of students, and/or
- a large number of assessment items, and
- you are waiting for the system to do it in front of you
If this is the case, make sure the “Import in background” is selected like the screen below.
This will allow the user to continue working while the spreadsheet is being imported. Once the process is complete, the user will receive an email reporting on the success or failure of the import process.
Managing large cohorts
Gradebook (and hence Interact) is an enterprise wide system and data is stored centrally. All enterprise wide systems have time-outs for periods of computer in-activity. For this reason you need to ensure you save your data regularly to avoid losing data when your session times-out.
Importing large cohorts from a spreadsheet can be slow and can time-out if you are waiting for the system to import in front of you. The import function now has the ability for the user to submit their import request in the background, allowing the user to continue working while the spreadsheet is being imported. Once the process is complete, the user will receive an email reporting on the success or failure of the import process.