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 following business day if the Monday is 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.

🗺️ 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 your downloaded 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 in cells A2 and B2.
4. In the downloaded Gradebook spreadsheet expand the Username column so the full student ID is populated. If you copy the data as is (2.01E+08) the results will not be displayed. There is duplicate data in the Student ID column, please ignore this.
5. From the downloaded Gradebook spreadsheet copy the data in the Username column (beginning with cell C2) into the Username column in the AIM Course Report worksheet 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 the cell is pink, the student has not accessed the module 
   4. Course Completion Status (Column E):
      1. Completed (highlighted in green) - student completed and passed the module
      2. Empty cell (highlighted in pink)
         1. student has accessed but not completed the module if there is a date in Column D
         2. student has not accessed or completed the module if there is not a date in Column D
      3. Unsuccessful (not highlighted) - student completed but did not pass the module

🖥️ Video Tutorial