MB Elementary Report Card (1-6) - Legacy
This report creates Student Report Cards for elementary students in grades 1 through 6.
At the user's option, a PDF file and/or an XML file is created.
Attendance Setup is required for the school
- Attendance Category of Tardy needs to be setup.
- Late Attendance Codes should have attendance category ‘Tardy’ selected
- Absent Attendance Codes should have a status of Absent.
- Absent Attendance Codes should have ‘This attendance code earns ADA credit’ checked.
- Attendance Conversions are required setup for the school
- Full-Time Equivalency should be entered for each student
Attendance is derived from the nightly process. If attendance changes during the day, the data is not current until after the nightly process runs. To manually refresh the data, go to: Special Functions > Attendance Functions > Refresh Premier Attendance Views Data.
Selection Criteria
- Students selected will be based on All Students or Currently Selected students, in grades 1 to 6 and not excluded from state reporting
- Students selected are enrolled at the current school as indicated at the top of the page.
- Students selected are enrolled in courses during the school year as indicated at the top of the page and within Term attendance dates for the Report Card Term. (Note report cards can be printed for previous years if the term at the top of the page is changed to a previous year and the Term Attendance end dates are also changed to match the previous year’s attendance dates.)
- If the student was transferred from another school, the previous term standards are extracted but the current teacher in the new school is reported.
- Courses displayed will be based on the student enrolled in courses for the school year with associated gradebook marks and/or comments.
- At this time, the Report Card can only be run from a current school.
- Classes having no marks or comments are excluded.
- When printing a non-cumulative report card, marks for selected term 1 or term 2 store codes for classes in which a student enrols after the attendance end date associated with the term are not printed. For example, if a student enrols in a term 1 class after the specified term 1 attendance end date, marks associated with the term 1 store codes are not printed.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description | ||||||||||||||
Current Selection Students | Choose whether you wish to run the report for the current selection of students or have the report run for all students in the school (All Students). Note that the selection criteria described above will still be applied regardless of whether a selection of students or all students are chosen. | ||||||||||||||
Sort By | Select the method of sorting for the report cards. Options are:
| ||||||||||||||
Date Issued | Enter the date to be printed in the Date Issued field of the report card header. Defaults to today. | ||||||||||||||
Generate PDF Report Cards | Check if a PDF version of the report card is to be created. If both PDF and XML versions are created, a zip folder containing both files is created, otherwise only a PDF file is created. | ||||||||||||||
Generate XML Report Cards | Check if an XML version of the report card is to be created. If both PDF and XML versions are created, a zip folder containing both files is created; otherwise, only an XML file is created. | ||||||||||||||
Exclude Classes With No Final Marks | Controls whether subjects without a category or subject marks are included in the XML Report Cards. Select the checkbox to exclude subjects that do not have a category or subject marks. | ||||||||||||||
Include Attendance | Controls whether student attendance information is printed in the Report Card header. Select the checkbox to include attendance counts in the report header. | ||||||||||||||
Term 1 Attendance End Date | Enter the attendance cut-off date for attendance counting for Term 1. If including attendance, Enter the attendance cut-off date for attendance counting for Term 1. This field defaults to the date selected in the Elementary Report Card Term 1 Attendance End Date field on the Schools/School Info page at the District Level. This setting cannot be saved. | ||||||||||||||
Term 2 Attendance End Date | Enter the attendance cut-off date for attendance counting for Term 2. If including attendance, Enter the attendance cut-off date for attendance counting for Term 2. This field defaults to the date selected in the Elementary Report Card Term 2 Attendance End Date field on the Schools/School Info page at the District Level. This setting cannot be saved. | ||||||||||||||
Include Principals Name on Signature Line | Controls how the Principal’s name is printed on the Principal Signature line at the end of the report or if it is to be left blank ready for a hand signature. Choose “Print Name” to print the value stored in the [Schools]Principal field. Choose “Use Signature Image” to use the uploaded signature at the location stored in [S_MB_SCH_X]PrincipalSignatureRCPath. The signature must be in JPEG format and 2.8 x 0.5 inches at 300 DPI (840x150 pixels). Options are:
| ||||||||||||||
Print Cumulative Report Card | Controls whether a cumulative report will be generated containing all teacher comments suitable for archival purposes. If checked, the report includes, for each subject and learning behaviour, the teacher comments for all reporting terms up to and including the latest included reporting term. Default value is unchecked. | ||||||||||||||
Print Comment Term | If selected, the report prints a term header in the comment box for each term for which comments are printed. Default value is unchecked. Only enabled if Print Cumulative Report Card is selected. | ||||||||||||||
Teacher Name | Controls the format of the Teacher Names on the report card. Options are:
| ||||||||||||||
Teacher’s Signature Line | Controls the inclusion of a line on the last page of the report card for the teacher’s signature. The Homeroom teacher is the one that teaches the class with [Courses/Sections]MB_ReportCardCrsType = ‘HMRM’ Options are:
| ||||||||||||||
Include Co-Teachers | Controls whether all teachers associated with a class are printed or just the lead teacher. If set to "Yes' all teachers are printed, otherwise only the lead teacher for the class is printed. This applies to both homeroom teachers and subject teachers. | ||||||||||||||
Store Codes for Term 1 (multi-selectable) | Select the Store Codes to use for the fall reporting period. You can select more than one Term by dragging in the list with the mouse, or by pressing the shift, command or control keys while clicking in the list with the mouse. Note: When selecting multiple store codes, ensure that term marks for a subject exist for only one of the store codes in this list, otherwise unpredictable results may occur. | ||||||||||||||
Store Codes for Term 2 (multi-selectable, may be left blank) | Select the Store Codes to use for the winter reporting period. If this parameter is left blank then grades for the winter reporting period will not be included on the report card. You can select more than one Term by dragging in the list with the mouse, or by pressing the shift, command or control keys while clicking in the list with the mouse. Note: When selecting multiple store codes, ensure that term marks for a subject exist for only one of the store codes in this list, otherwise unpredictable results may occur. | ||||||||||||||
Store Codes for Final Term (multi-selectable, may be left blank) | Select the Store Codes to use for the summer reporting period. If this parameter is left blank then grades for the summer reporting period will not be included on the report card. You can select more than one Term by dragging in the list with the mouse, or by pressing the shift, command or control keys while clicking in the list with the mouse. Note: When selecting multiple store codes, ensure that term marks for a subject exist for only one of the store codes in this list, otherwise unpredictable results may occur. | ||||||||||||||
Use Grades From This option is removed as of version 2.14. The report now uses only Gradebook tables. | Grades printed on the Report Card are read from Gradebook tables. The table below shows which tables and fields are used to check and report each piece of data. The Value column describes the type of data referenced or reported and is used in the Report Output table in the following section.
| ||||||||||||||
Time Frame | Optionally enter a time frame for this report card run. E.g.: “Semester 1 – Mid-Term” The time frame will appear in the report card header below the “Grades 1 to 6 Report Card” and above the School Name. | ||||||||||||||
Orientation | Controls the orientation of the subject pages of the Report Card. Options are Portrait and Landscape. Note: The first and last page of each student report card will always be portrait. | ||||||||||||||
Print Double Sided Report Card | If checked, the report inserts, if necessary, a blank page at the end of a student's report card to ensure that the report card for the next student starts on an odd page. Default is unchecked. If checked, and the selected orientation is landscape, only the subject detail pages are double sided - the backs of the first page and the last page are printed blank. |
Running the Report
For help with navigation and running the report, see How to Find and Generate a Report.
Report Output - PDF
The report output will contain one Report Card per student depending on the selection criteria described above.
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.
If the IEP flag is checked in a grading box, the following standard comment appears in the Comment section for that grading box before any posted comment: "The grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."
If the EAL flag is checked in a grading box, the following standard comment appears in the Comment section for that grading box before any posted comment: "The grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."
The standard identifier values referenced in the table are case insensitive.
When printing cumulative report cards, if a cumulative comment length exceeds 4000 characters, only the first 4000 characters are printed.
Data Element | Description | [Table]FieldName |
Page 1 – Header | ||
School Division | Name of district. | [Prefs]Value where [Prefs].Name = ‘DistrictName’ |
Time Frame | The Time Frame for the report, e.g. “Semester 1 – Mid Term”. | Timeframe entered at runtime |
School Name | Name of School | [Schools]Name |
School Address | School’s Address | [Schools]Address [Schools]SchoolCity [Schools]SchoolState [Schools]SchoolZip |
School Phone | School’s Phone Number | [Schools]SchoolPhone |
[Student Language Program] French Immersion | French Immersion Indicator | If any of the [Students]MB_StudentProgram1 through [Students]MB_StudentProgram4 fields contain the value 110,111,or 112 then the student is enrolled in a French Immersion Program, and the heading “French Immersion Program” is output on the Report Card Header. Also, Subject Names will also appear bi-lingual. |
School Logo | If using School and District Logo then logos must be 0.8 x 0.8 in at 300 DPI (240 x 240 pixels) If just using School Logo (no District Logo) then logo must be 1.7 x 1.7 inches at 300 DPI (510 x 510 pixels) | Filename including path is stored in [Schools]MB_SchoolLogoPath |
District Logo | If using School and District Logo then logos must be 0.8 x 0.8 in at 300 DPI (240 x 240 pixels) If just using District Logo (no School Logo) then logo must be 1.7 x 1.7 inches at 300 DPI (510 x 510 pixels) | Filename including path is stored in [Prefs]value where [Prefs]name = ‘MB_DistrictLogoPath’ |
Provincial Logo | Must be 1.7 x 1.7 inches at 300 DPI (510 x 510 pixels) | Filename including path is stored in [Prefs]value where [Prefs]name = ‘MB_ProvincialLogoPath’ |
Grade | Student’s Grade Level | [Students/ReEnrollments]Grade_Level |
Student | Student’s Full Name. Format: Last, First Middle | [Students]Last_Name [Students]First_Name [Students]Middle_Name |
Provincial Student # | Manitoba Provincial Student Number | [Students]State_StudentNumber if blank then ‘Pending’ is printed. |
Homeroom Teacher | Name of Student’s homeroom teacher. If the Include Co-Teachers option is "Yes" all teachers associated with the homeroom class are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Course that student is enrolled in that has [Courses]MB_ReportCardCrsType = HMRM Note: If a student is enrolled in multiple homeroom classes, the teacher selected will be from the latest class that the student is enrolled in. If [CC]DateEnrolled is the same for multiple homeroom classes, then the report will select the one which has the latest [CC]DateLeft. If both are the same, the first created CC will be chosen. |
Date Issued | This is the date the Report Card was printed. | Entered at Report Runtime in Print Date field. Format = MM/DD/YYYY |
Days Absent – Term 1 | Days absent from start of school year thru to Term 1 Attendance End Date. Printed to one decimal place. Output is included when Include Attendance is checked in the report at runtime. | Uses the PS_ADA_ADM_DEFAULTS_ALL Table. Attendance setup is required. |
Days Absent –Term 2 | Number of Days Absent From Term 1 Attendance End Date to Term 2 Attendance End Date. Term 2 Store code(s) must be entered to indicate this is a Winter Report Card and the Term 1 and 2 Attendance End Dates must be specified to indicate the date range for the Term 2 attendance calculations Output is included when Include Attendance is checked in the report at runtime and Term 2 Store code(s) have been selected. | Uses the PS_ADA_ADM_DEFAULTS_ALL Table. Attendance setup is required. |
Days Absent – Term 3 | Number of Days Absent From Term 1 Attendance End Date to End of School Year. Final Term Store code(s) must be entered to indicate this is a Final Report Card and the Term 2 Attendance End Date must be specified to indicate the date range for the Term 2 to end of school year attendance calculations. Output is included when Include Attendance is checked in the report at runtime and Final Term Store code(s) have been selected. | Uses the PS_ADA_ADM_DEFAULTS_ALL Table. Attendance setup is required. |
Days Absent – Total | Number of Days Absent From Start of Year to End of School Year. Output is included when Include Attendance is checked in the report at runtime. | Uses the PS_ADA_ADM_DEFAULTS_ALL Table. Attendance setup is required. |
Times Late – Term 1 | Times late from start of school year thru to Term 1 Attendance End Date. Whole numbers only. Output is included when Include Attendance is checked in the report at runtime. | Can be late more than once a day. Uses the Attendance Table. Attendance setup is required. |
Times Late – Term 2 | Times late from Term 1 Attendance End Date thru to Term 2 Attendance End Date. Whole numbers only. Output is included when Include Attendance is checked in the report at runtime and Term 2 Store code(s) have been selected. | Can be late more than once a day. Uses the Attendance Table. Attendance setup is required. |
Times Late – Term 3 | Times late from Term 2 Attendance End Date thru to the end of the school year. Whole numbers only. Output is included when Include Attendance is checked in the report at runtime and Final Term Store code(s) have been selected. | Can be late more than once a day. Uses the Attendance Table. Attendance setup is required. |
Times Late – Total | Times late from start of school year thru to the end of the school year. Whole numbers only. Output is included when Include Attendance is checked in the report at runtime | Can be late more than once a day. Uses the Attendance Table. Attendance setup is required. |
Data output in the Subject Boxes | ||
The Term 1 values are from Term Grade with Store Code(s) Indicator matching what was selected for Term 1 in the Report Settings. The Term 2 values are from Term Grade with Store Code(s) Indicator matching what was selected for Term 2 in the Report Settings. The Final Term values are from Term Grade with Store Code(s) Indicator matching what was selected for Final Term in the Report Settings. The Term Comments are read from the Grades Source with the Store Code(s) Indicator entered for the latest Term requested. This applies to EAL and IEP flags as well. | ||
English Language Arts | ||
Student must be enrolled in a class with [Courses]MB_ReportCardCrsTyp = ELA or [Section] MB_ReportCardCrsTyp = ELA Marks, comments and indicators will be pulled from the Standards Identifiers that are described below. | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with a %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another ELA class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.ELA.FLG |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.ELA.FLG |
Comprehension/Reading – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.ELA.R |
Comprehension/Listening and viewing – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.ELA.L |
Communication/Writing– Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.ELA.W |
Communication/Speaking – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.ELA.S |
Critical thinking – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.ELA.C |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.ELA.CMT |
Mathematics [Mathématiques] | ||
Student must be enrolled in a class with [Courses]MB_ReportCardCrsTyp = MAT or [Section] MB_ReportCardCrsTyp = MAT Marks, comments and indicators will be pulled from the Standards Identifiers that are described below. | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another MAT class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.MAT.FLG |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.MAT.FLG |
Knowledge and understanding – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.MAT.K |
Mental math and estimation – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.MAT.M |
Problem solving– Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.MAT.P |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.MAT.CMT |
Science [Sciences de la nature] | ||
Student must be enrolled in a class with [Courses]MB_ReportCardCrsTyp = SCI or [Section] MB_ReportCardCrsTyp = SCI Marks, comments and indicators will be pulled from the Standards Identifiers that are described below | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0 are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another SCI class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.SCI.FLG |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.SCI.FLG |
Knowledge and understanding – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SCI.K |
Scientific inquiry process – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SCI.I |
Design process and problem solving– Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SCI.P |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.SCI.CMT |
Social Studies [Sciences humaines] | ||
Student must be enrolled in a class with [Courses]MB_ReportCardCrsTyp = SOC or [Section] MB_ReportCardCrsTyp = SOC Marks, comments and indicators will be pulled from the Standards Identifiers that are described below. | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another SOC class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.SOC.FLG |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.SOC.FLG |
Knowledge and understanding – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SOC.K |
Research and communication – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SOC.R |
Critical thinking and citizenship– Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.SOC.C |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.SOC.CMT |
Physical and Health Education [Éducation physique et Éducation à la santé] | ||
Student must be enrolled in a class with [Courses]MB_ReportCardCrsTyp = PHE or [Section] MB_ReportCardCrsTyp = PHE Marks, comments and indicators will be pulled from the Standards Identifiers that are described below. | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another PHE class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.PHE.FLG |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.PHE.FLG |
Physical Education/Movement – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.PHE.M |
Physical Education/Fitness management – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.PHE.F |
Health Education/Healthy lifestyles– Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.PHE.H |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.PHE.CMT |
French [Français] | ||
To have the Francais grading box on the student’s report card, the student must have
To have the French grading box on the student’s report card, the student must
| ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0 are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another FRE/FRAN class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
IEP | Marked if Student has been designated IEP in this subject. | Will set an X if Term Grade = I and associated Standards Identifier = E1-6.FRE.FLG or E1-6.FRAN.FLG |
Oral communication – Term 1,2,Final | Mark attained by student. Only output for Students not participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRE.O |
Reading – Term 1,2,Final | Mark attained by student. Only output for Students not participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRE.R |
Writing – Term 1,2,Final | Mark attained by student. Only output for Students not participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRE.W |
Comprehension – Reading – Term 1,2,Final | Mark attained by student. Only output for Students participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRAN.R |
Comprehension – Listening and viewing – Term 1,2,Final | Mark attained by student. Only output for Students participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRAN.L |
Communication – Writing – Term 1,2,Final | Mark attained by student. Only output for Students participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRAN.W |
Communication – Speaking and representing – Term 1,2,Final | Mark attained by student. Only output for Students participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRAN.S |
Critical thinking – Term 1,2,Final | Mark attained by student. Only output for Students participating in the French Immersion Program | Outputs Term Grade where associated Standards Identifier = E1-6.FRAN.C |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.FRE.CMT or E1-6.FRAN.CMT |
Arts Education – Subjects Marks | ||
Up to six art subjects can be displayed when the student is enrolled in Art classes where:
[Courses]MB_ReportCardCrsTyp or [Sections[MB_ReportCardCrsTyp = ARVA, ARDA, ARDR, ARMU, ARBA, ARCH, ARGU or AROR
[Schools]MB_ArtByCat_A_[grade_level] or [Schools]MB_ArtByCat_B_[grade_level] | ||
EAL | Marked if Student has been designated EAL in any or the art subjects. | Will set an X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.[MB_ReportCardCrsType].FLG |
IEP | Marked if Student has been designated IEP in any or the art subjects. | Will set an X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.[MB_ReportCardCrsType].FLG |
Display up to six art class Teachers and Subjects with the associated grades for each term | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with course that student is enrolled in. Note: In the case of a student who has transferred to another ART class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
Subject | The name of the Art Subject for one of these Arts courses: Visual Arts, Dance, Drama, Music, Band, Choral, Guitar or Strings/Orchestra | [courses]course_name associated with course that student is enrolled in |
Art Subject grade for Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].SM |
Comments | Displays teacher comments associated with the latest term, for all the Arts courses that in the Art Education grading box. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].CMT |
Arts Subject or Discipline artistique (Arts Discipline) | ||
Up to 2 Arts Subjects per grade can be reported using subject grading boxes with additional category detail. The Arts subjects to be reported separately are set up on the Schools/School Info Page. [Schools]MB_ArtByCat_A_[grade_level] and [Schools]MB_ArtByCat_B_[grade_level], each of which can be set up to be ARVA, ARDA, ARDR, ARMU, ARBA, ARCH, ARGU or AROR. The student must be currently enrolled in a class with [Courses/Sections]MB_ReportCardCrsType = [Schools]MB_ArtByCat_A_[grade_level] or [Schools]MB_ArtByCat_B_[grade_level] for Arts Subject Grading boxes to be printed in the Student’s Report Card. Art subjects are order by alphabetically by [Courses/Sections]MB_ReportCardCrsType. Marks, comments and indicators will be pulled from the Standards Identifiers that are described below. | ||
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with course that student is enrolled in. Note: In the case of a student who has transferred to another ART class, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this art subject. | Set to X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].FLG |
IEP | Marked if Student has been designated IEP in this art subject. | Set to X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].FLG |
Category 1 | Ensure that the Standards Name is set up according to the MB Provincial Report Card Business Requirements When Subject is Visual Arts, Category Name should be “Language and Tools” otherwise Category Name will be “Language and performance skills” | Standards[Name] where Standard Identifier = E1-6.[MB_ReportCardCrsType].C1
|
Category 1 grade for Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].C1 |
Category 2 | Ensure that the Standards Name is set up according to the MB Provincial Report Card Business Requirements Category Name should be “Creative expression” | Standards[Name] where Standard Identifier = E1-6.[MB_ReportCardCrsType].C2 |
Category 2 grade for Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].C2 |
Category 3 | Ensure that the Standards Name is set up according to the MB Provincial Report Card Business Requirements Category Name should be “Knowledge and understanding of Visual Arts (or Drama or Music) in culture and society” | Standards[Name] where Standard Identifier = E1-6.[MB_ReportCardCrsType].C3 |
Category 3 grade for Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].C3 |
Category 4 | Ensure that the Standards Name is set up according to the MB Provincial Report Card Business Requirements Category Name should be “Analysis and communication” | Standards[Name] where Standard Identifier = E1-6.[MB_ReportCardCrsType].C4 |
Category 4 grade for Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].C4 |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.[ MB_ReportCardCrsType].CMT |
Local Option Course – With Category Marks | ||
There can be up to 6 local option courses for a student listed in separate “Local Subject Option Boxes”. The associated section or course MB Report Card Subject Code must be set to “Local Option Course – With Category Marks”. [Courses/Sections]MB_ReportCardCrsType = OPT The Standards Identifier, parent code must be set up as E1-6.OPT.[Course_Number]. Marks, comments and indicators will be pulled from the Standards Identifiers that are described below | ||
[Local Option Course] - Name | Name of course. | [Courses]Name |
Teacher | Name of teacher that teaches this subject. If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another class of the same course, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
EAL | Marked if Student has been designated EAL in this subject. | set to X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.OPT.[Course_Number].FLG |
IEP | Marked if Student has been designated IEP in this subject. | set to X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.OPT.[Course_Number]FLG |
Category [1-5] Title | Title of Category | Standards[Name] where associated Standards Identifier = E1-6.OPT.[Course_Number].C1,C2,C3,C4,C5 Note: If the Standards[Name] has ‘(Course_Number)’ as part of the title, this will be stripped away before being printed. |
Category [1-5] – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.OPT.[Course_Number].C1,C2,C3,C4,C5 |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.OPT.[Course_Number].CMT |
Local Option Courses – Subject Marks Only (Multi-Subject Grading Box) | ||
Only one Multi-Subject Grading Box (not including the Art Education multi-subject grading box) can be included in a Student’s Report Card. Up to 6 local option courses for a student can be included in a “Multi-Subject Grading Box”. The associated section or course MB Report Card Subject Code for the course must be set to “Local Option Course – Subject Marks Only”. [Courses/Sections]MB_ReportCardCrsType = OPTS The title of the Multi-Subject Grading Box can be set up on the Schools/School Info Page. If this is not set, the title will default to ‘Additional Courses’. The Standards Identifier, parent code must be set up as E1-6.OPTS.[Course_Number]. | ||
Multi Subject Grading Box Title | The title of the Multi Subject Grading Box entered on the Schools Info page. | If [Schools]MB_Multi-Subject_Title is not empty, the [Schools]MB_Multi-Subject_Title is printed, Otherwise “Additional Courses” is printed. |
Teacher | The words “See Below” are hardcoded in this field. | “See Below” |
EAL | Marked if Student has been designated EAL for any of the subjects listed. | set to X if the latest Term Grade = E or EANDI for any associated Standards Identifier = E1-6.OPTS.[Course_Number].FLG |
IEP | Marked if Student has been designated IEP for any of the subjects listed. | set to X if the latest Term Grade = I or EANDI for any associated Standards Identifier = E1-6.OPTS.[Course_Number].FLG |
Display up to six optional Teachers and Subjects with the associated grades for each term | ||
Teacher / Subject [1-6] – Term 1,2,Final | Teacher Name and Subject Name of Additional Course If the Include Co-Teachers option is "Yes" all teachers associated with the subject class with %Allocation > 0, are printed, otherwise just the lead teacher is printed. The SectionTeacher table is used to determine the teachers associated with the class. Note: format of Teacher Name depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Section that student is enrolled in. Note: In the case of a student who has transferred to another class of the same course, and during a single reporting term the student was enrolled in both classes, the teacher selected will be from the latest class based on enrolment date [CC]DateEnrolled. |
Subject Mark [1-6] – Term 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.OPTS.[Course_Number].SM |
Comments | Displays teacher comments associated with the latest term, for all the local options courses that in the multi-subject grading box. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs latest Term Comments where associated Standards Identifier = E1-6.OPTS.[Course_Number].CMT |
Last Page – Learning Behaviors | ||
IEP | Marked if Student has been designated IEP for learning behaviors. | Will set an X if Term Grade = E and associated Standards Identifier = E1-6.LB.FLG |
Personal management skills – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.LB.PM |
Active participation in learning – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.LB.AP |
Social Responsibility – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.LB.SR |
Engagement in using French – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.LB.FR |
Local Option 1 – Name | Name of Local Option 1. | Outputs [Schools]MB_ERC_LB1_Name |
Local Option 1 – Description | Description of Local Option 1. | Outputs [Schools]MB_ERC_LB1_Description |
Local Option 1 – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where associated Standards Identifier = E1-6.LB.L1 |
Local Option 2 – Name | Name of Local Option 2. | Outputs [Schools]MB_ERC_LB2_Name |
Local Option 2 – Description | Description of Local Option 2. | Outputs [Schools]MB_ERC_LB2_Description |
Local Option 2 – Terms 1,2,Final | Mark attained by student. | Outputs Term Grade where Standards Identifier = E1-6.LB.L2 |
Comments | Teacher Comments for latest Term included on the report card. If Print Cumulative Report Card is checked, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is checked, the comment for each term is preceded with a line identifying the term (e.g. "Term 1", "Term 2", etc.). | Outputs Term Comment where associated Standards Identifier = E1-6.LB.CMT |
Principals Comments | Principal Comments for this student and school. | [Students]MB_PrincipalComments concatenated with [Schools]MB_PrincipalComments_16 |
Grade In September | Grade student has attained for next school year. (Only output when Term 3 is included) | [Students]Sched_NextYearGrade |
Principals Name on Signature Line | The principals name, or an uploaded signature, can optionally be printed on the signature line of the last page | If “Include Principals Name on Signature Line” is “Print Name” then [Schools]Principal If “Include Principals Name on Signature Line” is “Use Signature Image” then filename of uploaded signature, including path, is stored in [S_MB_SCH_X]PrincipalSignatureRCPath |
Homeroom Teacher’s Signature Line | An additional signature line, optionally with the Homeroom lead teacher’s name, can optionally be included on the last page of each report card. Note: Format of the homeroom teacher’s name depends on setting of Teacher Name parameter at runtime. | [Teachers]Last_Name [Teachers]First_Name [Teachers]PreferredName associated with Course that student is enrolled in that has [Courses]MB_ReportCardCrsType = HMRM |
Report Output - XML
The report output contains a single <reportCards> root element and a single child <school> element for the current school.
The report output contains one <student> element (and its child elements) per student depending on the selection criteria described above.
Each of the elements and tags in the output file are described below and conform to the content and format described in the ministry Report Card Data Collection - XML Schema document.
Data Element | Description | [Table]FieldName |
/reportCards | ||
div | The division code as assigned by the department. It is a 4-digit number. | [Prefs]Value where [Prefs].Name = ‘DistrictNumber’ |
year | The academic year this export file is for. It is a 4-digit number. | N/A. Calculated. |
generated | The date and time the file was generated, using the following format: yyyy-MM-ddTHH:mm:ss-zh.zm. yyyy is the year, MM the month (01-12), dd the day of the month, HH the hour of day (24-hour format), mm the minutes, ss the seconds. The -zh.zm is the GMT offset. Note the letter T must be between the date and the time. | N/A. Calculated. |
/reportCards/school | ||
nbr | A 4-digit school number assigned by the department. | [Schools]Alt_School_Number if not 0, otherwise [Schools]School_Number |
/reportCards/school/student | ||
metNumber | The MET number assigned to a student, a 9-digit number. | [Students]State_StudentNumber |
surname | The student’s legal surname; maximum number of characters is 35. The name can contain any letter, including accented letters, spaces, hyphens, apostrophes and periods. | [Students]Last_Name |
givenName | The student’s legal given names; maximum number of characters is 35. The name can contain any letter, including accented letters, spaces, hyphens, apostrophes and periods. | [Students]First_Name [Students]Middle_Name |
/reportCards/school/student/enrolment | ||
xsi:type | Used to validate the data within the enrolment attribute, it must be “gradeX” where X is replaced with the grade of the student. | [Students/ReEnrollments]Grade_Level |
reportCardType | The report card type code. | If any of the [Students]MB_StudentProgram1 through [Students]MB_StudentProgram4 fields contain the value 110,111,or 112 then this will be 2, otherwise 1. |
lbIEP | Indicates whether the overall behaviour of this student has been based on an IEP. | Will be set to T if Term Grade = E and associated Standards Identifier = E1-6.LB.FLG, otherwise to F. |
/reportCards/school/student/enrolment/attendance | ||
period | The reporting period for this element. Valid values can be 1 to 3. | N/A. Calculated. |
daysAbsent | The number of days the student was absent from school/ class. Must be a number between 0 and 200, inclusive. | Uses the PS_ADA_ADM_DEFAULTS_ALL Table. Attendance setup is required. |
/reportCards/school/student/enrolment/learningBehaviours/lb | ||
period | The reporting period for the behaviour assessment. Valid values can be 1 to 3. | N/A. Calculated. |
code | The code for the behaviour that has been evaluated. | N/A. Calculated. |
value | The assessment the student received for the behaviour. | Outputs code for Term Grade where associated Standards Identifier = E1-6.LB.<behaviour> |
/reportCards/school/student/enrolment/course | ||
semester | The semester the course is being reported in. | [Terms]Portion |
code | The code for the course. | [Courses]Alt_Course_Number if not 0 otherwise, [Courses]Course_Number |
level | The grade / level of the course. | [Courses]Code |
IEP | Indicates whether this student’s evaluation has been based on an IEP. | Will be set to T if Term Grade = E or EANDI and associated Standards Identifier = E1-6.<course>.FLG, otherwise to F. |
EAL | Indicates whether this student’s evaluation has been based using EAL criteria. | Will be set to T if Term Grade = I or EANDI and associated Standards Identifier = E1-6.<course>.FLG, otherwise to F. |
L | Indicates whether this student’s evaluation has been based using L criteria. | Always set to F. |
/reportCards/school/student/enrolment/course/academicAchievements/aa | ||
cat | The achievement category code. Must be a valid category for the course the achievement is within. | N/A. Calculated. |
value | The assessed value the student received. | Outputs the appropriate Term Grade where associated Standards Identifier = E1-6.<course>.<achievement> |