Download or export class roster/list

Owned by CIT Webmaster
Last updated: 19 Aug 2024 by KP
2 min read

NUS Tools (People) displays your class roster/list. The enrolled students' information can be exported to a spreadsheet or PDF.

The information includes:

  • Photo

  • Login ID (NUS-ID)

  • SIS ID (same as Login ID for NUS students)

  • Section(s)

  • Role

  • Student Number (Matriculation number)

  • Email (actual NUS-ID email, not friendly-mail alias)

  • Academic Programme

  • Faculty

  • Admit Term

These columns are not displayed in NUS Tools (People), but the information can be exported:

  • Display Name

  • Academic Career

Friendly-mail aliases and subjects taken are not available in Canvas.

Group information can be downloaded via this method.

You can also access some of the information items above via these alternatives.

To export the class roster, click Grades on the left-hand navigation menu of your course.

Click Export on the top right, then Export Current Gradebook View or Export Entire Gradebook.

This produces a csv file which includes:

  1. any graded assignments which you have added to the course,

  2. matriculation numbers (under Integration ID column), and

  3. roster information (under Section column). This includes information on sections and tutorial groups.

  4. csv file sample below.

Student

ID

SIS User ID

SIS Login ID

Integration ID

Section

Student

ID

SIS User ID

SIS Login ID

Integration ID

Section

    Points Possible

 

 

 

 

 

ABC

80000

e0123456

e0123456

A0654321

CDT1101_S1

DEF

90000

e0111222

e0111222

A0120121

CDT1101_S1

GHK

30000

e0199999

e0199999

A0198198

CDT1101_S2

The first time you click into New Analytics, you will have to wait about 48 hours (or more) before the analytics are generated and you can perform the download described below.

To download class roster from New Analytics, follow these instructions:

  1. Click the New Analytics button in the home page Sidebar. Depending on the size of your screen or browser, the Sidebar can appear on the right or bottom of the page.

  2. Click the Reports tab.

  3. Click the Run Report button next to Class Roster.

  4. A pop-up will appear. Click Run Report.

  5. A csv file with student information will be downloaded.

 

 

 

 

 

 

 

 

 

 

Student name

Student ID

Student SIS ID

Email

Section name

ABC

abcdec

e0123456

e0123456@u.nus.edu

Section 3 (CNV1101)

DEF

defghi

e0111222

e0111222@u.nus.edu

Section 2 (CNV1101)

GHI

ghijkl

e0199999

e0199999@u.nus.edu

Section 1 (CNV1101)