Introduction

All first year Georgian College students are enrolled in the Academic Integrity Module (AIM). The AIM report is generated to identify the course completion status of students enrolled in the module. The AIM report records the outcome of the students' participation and might be referenced in the future when investigating a possibility of an act of alleged academic misconduct.

The AIM Course Report template is updated every Monday before 12PM (or the next day following a statutory holiday). If you require an updated report before the spreadsheet is refreshed (as referenced in the schedule above) please send an email to FacultyBBSupport@GeorgianCollege.ca.

NOTE: You must access the online AIM Course Report Template each time you want to review the Course Completion Status. If you have a previously downloaded copy saved to your device it will not contain the most current student data.

The AIM report available in Tools ~ My Reports in base navigation in Blackboard was built to function with Blackboard Original courses and is not compatible with Ultra courses resulting in the requirement to complete the process below when retrieving student status results for Ultra courses.

🗺️ Text Instructions

Downloading your course Gradebook:

1. Log into Blackboard and open your Ultra course
2. Click on Gradebook in the top menu navigation
3. Click on the Download Gradebook icon from the right menu, located under Student Preview
4. Under Download Options ~ Grade Records select Full Gradebook
5. Under Download Options ~ Record Details select Select All Items
6. Click Download. The file has now been added to your Downloads folder in your File Explorer folder
7. In the Downloads pop up box click on the Open file link.
8. A pop-up box will appear stating “The file format and extension of ”[name of your course]" don't match. The file could be corrupted or unsafe. Unless you trust its source don't open it. Do you want to open it anyway?" Click Yes
9. Save your student list on your device for future reference when accessing the AIM course again.

Accessing the worksheet:

1. Click on the link below to open the AIM Course Report Template:
   1.  AIM Course Report Template.xlsx
2. The template is in read-only mode, you must download a copy of the template to your device to edit and save the report. To do this:
   1. Click on File
   2. Click on Save As
   3. Click on Download a Copy. The file has now been added to your Downloads folder in your File Explorer folder
   4. In the Downloads pop up box click on the Open file link.

Generating the report:

1. Click on the “Add Student Data Here” tab in the AIM Course Report Template.
2. From the downloaded Gradebook spreadsheet copy the data in the Last Name column (beginning with cell A2) and First Name column (beginning with cell B2).
3. Paste the data from the Last Name and First Name columns from the downloaded Gradebook spreadsheet into the AIM Course Report worksheet beginning in cells A2 and B2.
4. From the downloaded Gradebook spreadsheet copy the data in the Username column (the Student ID column will be blank) beginning with cell C2.
5. Paste the data from the Username column from the downloaded Gradebook into the Username column in the AIM Course Report worksheet beginning in cell C2.
6. The results will appear in the columns as follows:
   1. Last Name and First Name of the student (Columns A and B) 
   2. Username (student ID) (Column C)
   3. Last Access (Column D):
      1. If a date appears this is the last time the student accessed the module
      2. If #N/A appears, the student has not accessed the module 
   4. Course Completion Status (Column E):
      1. Complete (highlighted in green) - student completed and passed the module
      2. In Progress (highlighted in yellow) - student has started but not yet completed the module
      3. In Progress (Incomplete) (highlighted in yellow) - student has started but not yet completed the module.
      4. In Progress (Complete) (highlighted in blue) - student has previously completed the module and started it again
      5. Empty cell (highlighted in pink) - student has not accessed the module

Reading the report:

As the AIM Course Report Template can be accessed by all faculty personal information such as first and last name and email address has been removed from the available student data. To identify the student's completion status, please cross-reference the student ID in the Username column with the student ID in your gradebook.

🖥️ Video Tutorial