The SPS Analytics team saves all sensitive student data to the H drive.

The following MS Excel files are in each Non-Degree Programs folder:  

1. Registration Summary report - Student's registration-related information (Data refreshed daily)
2. Course Data - Student's course history and the grade by term  (Data refreshed daily)

Please follow the steps below to access the reports: 

1. Make sure that you have permission to access the reports in the SPS Analytics folder. 

If you don't have access to the SPS Analytics folder, please send an email to spsanalytics@columbia.edu with your supervisor’s approval.

2. See the Non-Degree Programs report folders in the following screenshot: 

Directory Path: (Navigate to the following directory and select a program folder) 

H:\SCE\Systems and Data Analysis\SPS Analytics\nondegree Programs

3. Data in the individual program folder :

Registration and Course data location:

SPS Analytics Folders and the Data Types