eLearning

MCQ Direct Upload to Gradebook (Ultra)

  1. Home
  2. Staff Guides (Ultra)
  3. Gradebook (Ultra)

Introduction

The email forwarded to course coordinators after paper based MCQ tests have been marked includes a spreadsheet for uploading the results to Gradebook. This spreadsheet will have the word “blackboard” in the file name to help identify it from the other files received in the email.

Tip: When submitting your MCQ response sheets to ITS make sure you complete the special instructions section if your MCQ answers are worth more than 1 mark, this will save you time when uploading results.

MCQ Marks can be uploaded to Gradebook by following these steps:

  1. Create column in Gradebook.
  2. Backup Gradebook.
  3. Identify correct spreadsheet from MCQ Exam Marking Email.
  4. Review data in spreadsheet.
  5. Upload to Gradebook.
  1. Create column in Gradebook
  2. Back up Gradebook
  3. Identify correct spreadsheet from MCQ Exam Marking Email
  1. Review data in spreadsheet
  2. Upload to Grade Centre

4. Review data in spreadsheet

  1. Open spreadsheet titled blackboard-ABCD1234-20-05-2016 in Microsoft Excel.
  2. In Row 1 you will see the following headings:
    • Username (this will be the student’s username that they use to log into blackboard eg. s1234567).
      Warning: Username has been generated from the provided student numbers on the MCQ response sheets.
    • MCQdate-time eg. MCQ20052016-163351 (This column is the Total marks column and is given a unique identifier according to the date and time the MCQ sheets were marked).
    • Surname (Student’s surname as recorded on MCQ mark sheet).
    • Inits (This is the student’s initials as recorded on the MCQ mark sheet).
    • Student Number (This column contains the student’s student number as recorded on the MCQ mark sheet eg. 12345678). 
      • UNMATCHED – (number student provided): Is given to a student that has entered their student number incorrectly on the MCQ response sheet. 
      • ‘NO ID’: Is given to student who fails to record a student number on their MCQ response sheet.
  3. You can sort your spreadsheet to identify those students that have the username’s ‘UNMATCHED’ or ‘NO ID’.
  4. To sort spreadsheet by ‘Username’ select Cell A1.
    Username circled
  5. Click the Sort & Filter button in the Home ribbon of Excel.
    Sort & filter circled in home ribbon
  6. Click on Sort A to Z under Sort & Filter.
    Sort A - Z circled
  7. This will help you identify the results that will not upload to Grade Centre.
    e.g. UNMATCHED – (number student provided) and ‘NO ID’
    Circled results that won't upload
  8. Before uploading select column Labelled MCQ located in cell B1.
  9. Right click on column and paste heading into B1.
    Tip: Paste the column heading from the downloaded Gradebook spreadsheet completed in the Back up Gradebook section above.
    Paste circled in the drop-dwon menu
  10. Your column will now have the heading of your Gradebook column.
    New column heading circled
  11. Save spreadsheet to desktop.