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:
- Space Delimited Text file,
- MS Excel 97-2003 (xls)* or
- 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