Microsoft Teams and Teacher Connect Gradebook Integration

SIS: Microsoft Teams Assignment and Grade Passback

Integrate with Microsoft Teams Gradebook

Teacher Connect Gradebook

Once the connection between eSchoolData and Microsoft Teams is established by your system administrator, a new option is available from within the gradebook Import icon to pull assignments and grades from Microsoft Teams into your eSD Gradebook.
Info
Teacher Connect Gradebook Import > From Microsoft Teams
  1. Click the Import button on the TC Gradebook toolbar
  2. Select From Microsoft Teams
  3. Microsoft Teams Grade passback is based on Assignment Names (gradebook categories are not considered)
  1. Assignment with a matching name  - Grades are pulled from Teams to the appropriate assignment into the Teacher Connect Gradebook.
  2. Assignment name is not found - A generic gradbook category called Microsoft Sync will be created in the Teacher Connect Gradebook, and all Teams assignments and grades will imported into the Microsoft Sync category.
    1. To change the category for a assignment, edit the assignment and select the correct category, then save the change.

Setup

Establish the connection between eSD and Microsoft Teams
InfoInteroperability > Partners > Microsoft

To enable the connection between eSD and Microsoft Teams, you will need to enter

  1. Tenant ID
  2. Client ID
  3. Client Secret

To attain the required tokens from Microsoft Team, you will need to register the CSIU eSD application within the Azure portal.

1.     Registration to Attain Tenant and Client ID:
  1.  Go to the Azure > Home > App Registrations
    1. Click New Registration and enter CSIU eSD as the name of the application.
    2. Select the Accounts in this organizational directory (Any Azure AD directory - Single Tenant) option.


    1. Set the redirect URI (where Azure AD will send tokens) to https://sis.csiu-technology.org

    1. Copy the Applicaiton (client) ID for entery into eSD
    2. Copy the Directory (tenant) ID for entery into eSD


Info
Note: The screen shot purposfully omitted some of the numbers in the ID fields.

     2.     Attain Client Secret
    1. Navigate to App Registrations> CSIU eSD > Overview
    2.  Click Add a Certificate or Secret
      1. Description - CSIU eSD
      2. Expires - Client choice

    1. Copy the Client Secret for entery into eSD.
    3.     Define Permissions:
    1. On the Select an API Screen select Microsoft API's.
    2. Click Add a permission.
    3. Select Microsoft Graph.
    4. Select Application permissions,
    5. Enter EDU in the search box
    6. Select the all options under EduAssignments - Read.All, ReadBasic.All, ReadWrite.All, ReadWriteBasic.All).


    The screenshot illustrates permissions that are successfully assigned within MS Teams