SPD Layout.

The Student Profile Data (Regular) File

All students who have completed the survey in the Summer or Fall as well as those who will be surveyed in the Winter must be included in this file.

The Student Profile Data Apprenticeship (Appr) File

Complete a student profile data record for each in-class apprenticeship training program that is funded by MTCU through the Seat Purchase Program for the period June 2018 to July 2019. For more specific dates please consult the KPI Student Satisfaction Guidelines document.

Upload your Student Profile Data file in any of the following formats:

  1. Space Delimited Text file,
  2. MS Excel 97-2003 (xls)* or
  3. MS Excel 2007+ (xlsx)*.
Content Optional? Length Position
Regular
Total Width
Regular
Position
Appr
Total Width
Appr
College Code (e.g., Humb) No 4 1–4 4 1–4 4
THREE-DIGIT CODE assigned by the consultant or the college No 3 5–7 7 5–7 7
College program name (e.g., Law & Security) No 45 8–52 52 8–52 52
College program name (long version for some reports) No 75 53-127 127 53-127 127
College program code (i.e., short form or abbreviation of name, e.g., LAW&SEC) No 12 128-139 139 128-139 139
MTCU code No 5 140-144 144 N/A N/A
Approved program sequence (APS) number No 5 145-149 149 N/A N/A
Trade (alpha-numeric – 4 or 5 characters) No 5 N/A N/A 140-144 144
Full-time/Part-time (F/P) No 1 N/A N/A 145 145
Level (1, 2 , 3 or 4) No 1 N/A N/A 146 146
Campus or location (e.g., Newnham) No 30 150-179 179 147-176 176
Campus code (i.e., short form or abbreviation of campus or location, e.g., NM) No 8 180-187 187 177-184 184
Program TOTAL enrolment number ** No 3 188-190 190 185-187 187
Program full-time enrolment number ** No 3 191-193 193 188-190 190
Program part-time enrolment number ** No 3 194-196 196 191-193 193
Number of males in target group No 3 197-199 199 194-196 196
Number of females in target group No 3 200-202 202 197-199 199
Number with English as a first language in target group No 3 203-205 205 200-202 202
Number with French as a first language in target group No 3 206-208 208 203-205 205
Number with Other as a first language in target group No 3 209-211 211 206-208 208
Number ages less than 21 in target group No 3 212-214 214 209-211 211
Number ages 21–25 in target group No 3 215-217 217 212-214 214
Number ages 26–30 in target group No 3 218-220 220 215-217 217
Number ages 31–35 in target group No 3 221-223 223 218-220 220
Number ages more than 35 in target group No 3 224-226 226 221-223 223
Campus location postal code (6 characters) No 6 227-232 232 224-229 229

* MS is a trademark of Microsoft Corporation.

** For the Regular SPD file please factor out students NOT in their first semester. Students are to be enrolled full-time, postsecondary program approved for MTCU funding through GPOG identified