Video Guide

 

Introduction

The email forwarded to course coordinators after paper based MCQ tests have been marked includes a spreadsheet for uploading the results to Grade Centre. 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 Grade Centre by following these steps:

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

Create column in Grade Centre

  1. From the Control Panel select Grade Centre > Full Grade Centre.

click on full grade centre

  1. Click on create a column.

  1. Enter Column Name.

enter column name

  1. Set Primary display as Score.
  2. Set Points Possible to value of your exam.

set possible points

  1. Select the required Include this Column in Grade Centre Calculations radio button:
    • Yes: Makes the column available to for inclusion in calculations.
    • No: The column is not available for inclusion in calculations.
  2. Select the required Show this column to students radio button:
    • Yes: Students can view their own mark entered in this column using My Grades.
    • No: Students cannot view their own mark entered in this column using My Grades. i.e. Select this option to hide the column from the students until all marks are finalised. (Refer Hiding marks from Students guide)
  3. Select the required Show Statistics radio button:
    • Yes: Students can view the average and median mark for this column using My Grades.
    • No: Students cannot view the average and median mark for this column using My Grades.

specify options

  1. Click on Submit button.

Back up Grade Centre

Warning: Before uploading MCQ data, download a backup copy of Grade Centre.

  1. From the Control Panel select Grade Centre > Full Grade Centre.

click on full grade centre

  1. Hover your mouse on the Work Offline button.
  2. Select Download from the drop down list.

click on the download button

  1. Select your Data option for download.
    • Select Full Grade Centre.

select full grade centre

  1. Choose Comma Delimiter Type to open directly into an Excel spreadsheet.
  2. Information in hidden columns in your Grade centre can be included by selecting Yes, if not needed, select No.

select option

  1. Click on the Submit button.
  2. Click the Download button.

click on download

  1. Save to your computer, Save as type: Microsoft Excel Comma Separated Values File (.CSV).

save file on your computer

  1. Open spreadsheet
  2. Click on the heading of the column you created.
  3. Right click and select Copy.

click copy

Identify correct spreadsheet from MCQ Exam Marking Email

  • The email you receive from MCQ Exam Marking will contain a number of files.
  • The file you will require for direct upload to Grade Centre contains the following: blackboard-course code-date (eg. blackboard-ABCD1234-20-05-2016).

excel icon

Review data in spreadsheet

  1. Open spreadsheet titled blackboard-ABCD1234-20-05-2016 in Microsoft Excel.
  • 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).
    • 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).

Warning: Username has been generated from the provided student numbers on the MCQ response sheets.

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.

  1. You can sort your spreadsheet to identify those students that have the username’s ‘UNMATCHED’ or ‘NO ID’.
  2. To sort spreadsheet by ‘Username’ select Cell A1.

click on the username cell

  1. Click the Sort & Filter button in the Home ribbon of Excel.

click on the home ribbon

  1. Click on Sort A to Z under Sort & Filter.

click on sort and filter

  1. This will help you identify the results that will not upload to Grade Centre.

look at the NO ID field and UNMATCHED

  1. Before uploading select column Labelled MCQ located in cell B1.
  2. Right click on column and paste heading into B1.

right click on column B1

  1. Your column will now have the heading of your Grade Centre column.

view the new mcq column

  1. Save spreadsheet to desktop.

Upload to Grade Centre​

  1. From the Control Panel select Grade Centre > Full Grade Centre.

click on full grade centre

  1. Click on Work Offline button.
  2. Click on Upload from the drop down box.

click uplaod

  1. Click on the Browse My Computer button and locate the spreadsheet file (eg. Blackboard-ABCD1234-20-05-2016.csv).
  2. Click on the Open button.

open the required file

Warning: The spreadsheet file must be a Microsoft Excel Comma Separated Values File (.CSV).

  1. Check you have selected the correct file.

click on correct file

  1. Click the Submit button.

click submit

  1. The Upload Grades Confirmation page will appear.
  2. In the Upload column place a tick next to the row that contains the MCQ Final Exam. Uncheck all other boxes.

upload grades confirmation

  1. Click the Submit button.

Warning: A red error box at the top of screen will appear advising those Usernames that do not match up with those in Grade Centre. You will need to enter these results manually. (The below image is an exaggerated example).

click submit

  1. If you had a red error box display, a warning box will appear click the OK button to continue.

  1. The MCQ Final Exam column will now be populated with the results.

mcq final column will be populated