MB Provincial Test Student Registration Report

Creates an XML file to register students for the provincial exam. This is a school-level report. The output zip file contains an XML file and a spreadsheet for verification.

Prerequisites

Code Sets

MBProvTestNum - A list of Provincial Test Numbers for Semester 1 and Semester 2. The report uses the Reported Value field in the code set. It is the user’s responsibility to populate this field with the Test Numbers when changed.
MBPTAdaptationCodes - A predefined list of ministry-approved adaptation codes for accurate application to student tests.
MBPTExemptionCodes - A predefined list of ministry-approved exemption codes for Provincial tests, eliminating manual entry.
Navigation: District, System Management, Data, and then Code Sets.

Courses and Course Sections:

Set up Exam codes at both Courses and Course Sections:

Courses: Set the Provincial test code for semester 1 and semester 2 in the MB Provincial Information on Courses page.
Navigation: Courses & programs, Course, New/Edit
Course Sections: Set Provincial test code for semester 1 and semester 2 in the Provincial Test Student Registration section in the MB Provincial Information on Courses-Sections page. This is only required if it differs from the course level Value.
Navigation: Courses & programs, Course Sections, New/Edit

Adaption or Exemption

Adaption or Exemption must be set up under the Provincial Test Settings section in the student's Course Registration page. A student can have either an exemption or an adaptation, but not both.

Adaptation: Add Adaptation code, Category, and Reason. The student can have more than one Adaptation.
Exemption: Add Exemption code and Reason
Navigation: Select student, Courses and Programs, Course Registration

Selection Criteria

The current [Students]SchoolId must be selected.
Student must not be Excluded From Provincial Reporting.
Students must be enrolled in the classes selected.
Cross Enrolled students are included. The report includes students enrolled in the classes at the school even if this school is not the student's primary enrolment.
Courses for which the "Exclude Course From EIS Reporting" flag on the Courses page is on are excluded from the report.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Current Selection Students*	Indicate which students to include in the report by selecting one of the following options: The selected students only – Run the report for students in the current selection. All students – Run the report for all students in the current school that meet the selection criteria. This is selected by default.
Run Report for *	Choose Semester 1 or Semester 2 for which the report will run.
Include Term(s):*	Choose one or more terms from the list of terms. Only classes whose scheduling term matches a selected term are included in the report.
Course Section(s):*	Choose the applicable courses, use Ctrl+Click or Shift+Click to select a single section or set of sections. Only sections for English Language Arts and Mathematics where Course_Level has 40S or Course CIP = 40S and Exclude Course From EIS Reporting is not selected. Only students enrolled in the selected sections are included in the report.
Enrolled as of:*	Select the student enrollment date in the class. Defaults to system date. Only students enrolled in the class on the selected date are included in the report.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

XML file

Data Element	Description	[Table]FieldName	Field Length
<school>	This is the outer tag
<school>/<schoolNbr>	The student’s four-digit school number.	[Schools]Alt_School_number if value is not equal to 0. Otherwise, [Students]/[ReEnrollments]SchoolId	4
<school>/<student>	Student segment outer tag.
<school>/<student>/<studentNbr>	Student’s MET number.	[Students]State_StudentNumber	9
<school>/<student>/<lastname>	Student’s last name.	[StudentCoreFields]PSCore_Legal__NaLastme if defined, otherwise, [Students]Last_Name	100
<school>/<student>/<firstname>	Student’s first name.	[StudentCoreFields]PSCore_Legal_First_Name if defined, otherwise, [Students]First_Name	100
<school>/<student>/<birthdate>	Student’s date of birth.	[Students]DoB Format: YYYY/MM/DD
<school>/<student>/<gender>	Student’s gender. Valid values: Male - M Female - F If this field is blank ( when gender is not M or F), an error is displayed while uploading the file.	[Students.StudentCoreFields]PSCore_Legal_Gender, if defined and either M or F Otherwise, [Students]Gender if - M or F, otherwise blank.	1
<school>/<student>/<grade>	Student’s grade level	[Students]/[ReEnrollments]Grade_Level	3
<school>/<student>/<exam>	The Outer tag for a student exam
<school>/<student>/<exam>/<examNb>	The provincial test exam number	Based on the input parameter, if semester 1 is selected then [S_MB_SEC_X ]PTNumSem1 if defined or [S_MB_CRS_Courses_X ]PTNumSem1 Otherwise, [S_MB_SEC_X ]PTNumSem2 if defined or [S_MB_CRS_Courses_X ]PTNumSem2	4
<school>/<student>/<exam>/<classNbr>	This is the class number	This is the[S_MB_SEC_X]classNbr if defined. Otherwise, [sections]Section_number	2
<school>/<student>/<exam>/<adaptation >	This is the outer tag for adaptation	An exam can either have adaptations or an exemption. This tag and subtags will be excluded if <Exemption> tag is included
<school>/<student>/<exam>/<adaptation >/< code>	The Adaptation code.	[MBTestAdaptationCodes]code	3
<school>/<student>/<exam>/<adaptation >/<category>	The Adaptation category: Valid values: Regular - 0 Additional - 1 Defaults to 0	[MBTestAdaptationCodes]Category	1
<school>/<student>/<exam>/<adaptation >/<reason>	The Adaptation reason.	[MBTestAdaptationCodes]Reason	350
<school>/<student>/<exam>/<exemption>	This is the Outer tag for Exemption	An exam can either have adaptations or an exemption. This tag and subtags will be excluded if <Adaptation> tag is included
<school>/<student>/<exam>/<exemption>/<code>	The provincial test exemption code.	[MBTestExemptionCodes]code	2
<school>/<student>/<exam>/<exemption>/<reason>	The reason for the provincial test exemption.	[MBTestExemptionCodes]Reason	350

Verification report - spreadsheet file

Column header
Student Number
Last Name
First Name
Birthdate
Gender
Grade
Exam Nbr
Adaptation (Y/N)
Exemption (Y/N)