MB Elementary Report Card (1-6)

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: The selection criteria described above is still applied,  regardless of whether a selection of students or all students are chosen.

Sort By

Select the method of sorting for the report cards.

• Student Name

• Student Name by Homeroom  ([Sections]room)

• Student Name by Grade

Student Name

Choose one of the following to determine whether the student's legal or preferred name should appear on the report:

• Legal Name

• Preferred Name

Note: The default selection is Legal Name.

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

Select this checkbox to generate a PDF version of the report card. If both PDF and XML versions are generated, a zip folder containing both files is created, otherwise only a PDF file is created.

Generate XML Report Cards

Select this checkbox to generate an XML version of the report card. If both PDF and XML versions are generated, 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 whether the principal’s signature at the end of the report is left blank for a hand signature or printed.

Options are:

• Don’t Include

• Print Name - Prints the value stored in the [Schools]Principal field

• Use Signature Image - Prints 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).

Note: When required, the principal's signature is scaled to fit the report card.

Print Cumulative Report Card

Controls whether a cumulative report is generated containing all teacher comments suitable for archival purposes. If selected, 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. The default is not selected.

Print Comment Term

If selected, the report prints a term header in the comment box for each term for which comments are printed. The default is not selected. Only enabled if Print Cumulative Report Card is selected.

Include Provincial Student Number on all pages of the report 

Select to include the Provincial Student Number on all pages of the report. This field is not selected by default.

Teacher Name

Controls the format of the Teacher Names on the report card.

• Use Teacher First and Last Name

• Use Teacher Preferred Name and Last Name

• Use Teacher First Initial and Last Name

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 person who teaches the class with [S_MB_CRS_Courses_X/S_MB_SEC_X]ReportCardCrsType = ‘HMRM’

• Don’t Include

• Include teacher Signature Line Only

• Include Homeroom Teacher’s Name on Line

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, grades for the summer reporting period are not 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.

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 is always portrait.

Print Double Sided Report Card

If selected, 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 not selected.

If selected, and the orientation is landscape, only the subject detail pages are double sided - the backs of the first page and the last page are printed blank.

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 [S_MB_STU_X]StudentProgram1 through [S_MB_STU_X]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 [S_MB_SCH_X]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 Legal Name or Full Name. Format: Last, First Middle

[Students]Last_Name

[Students]First_Name

[Students]Middle_Name

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

[StudentCoreFields]PSCore_Legal_Middle_Name

[StudentCoreFields]PSCore_Legal_Suffix

Provincial Student #

Manitoba Provincial Student Number

[Students]State_StudentNumber if blank then ‘Pending’ is printed.

Homeroom Teacher

Name of this 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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]PreferredName associated with Course that student is enrolled in that has [S_MB_CRS_Courses_X]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 is 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 selected 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 selected 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 selected 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 selected 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 selected 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 selected 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 selected 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 selected 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 [S_MB_CRS_Courses_X]ReportCardCrsTyp = ELA or [S_MB_SEC_X]ReportCardCrsTyp = ELA

Marks, comments and indicators are pulled from the Standards Identifiers described below.

Notes:

• If only IEP is indicated, then the following comment appears first in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears first in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L boxes are selected, the following comment appears first in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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 [S_MB_CRS_Courses_X]ReportCardCrsTyp = MAT or [S_MB_SEC_X]ReportCardCrsTyp = MAT

Marks, comments and indicators are pulled from the Standards Identifiers described below.

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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 [S_MB_CRS_Courses_X]ReportCardCrsTyp = SCI or [S_MB_SEC_X]ReportCardCrsTyp = SCI

Marks, comments and indicators are pulled from the Standards Identifiers described below

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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 [S_MB_CRS_Courses_X]ReportCardCrsTyp = SOC or [S_MB_SEC_X]ReportCardCrsTyp = SOC

Marks, comments and indicators are pulled from the Standards Identifiers described below.

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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 [S_MB_CRS_Courses_X]ReportCardCrsTyp = PHE or [S_MB_SEC_X]ReportCardCrsTyp = PHE

Marks, comments and indicators are pulled from the Standards Identifiers described below.

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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:

1. have the Student Program set to 110, 111, or 112 for French Immersion; and

2. be enrolled in a class with [S_MB_CRS_Courses_X]ReportCardCrsTyp = FRAN or [S_MB_SEC_X]ReportCardCrsTyp = FRAN; and

3. The course must be using standards associated to the E1-6.FRAN Standard Identifiers as described below

To have the French grading box on the student’s report card, the student must:

1. not have a Student Program set to 110, 111, or 112 for French Immersion; and

2. be enrolled in a class with [S_MB_CRS_Courses_X]ReportCardCrsTyp = FRE or [S_MB_SEC_X]ReportCardCrsTyp = FRE, and

3. The course must be using standards associated to the E1-6.FRE Standard Identifiers as 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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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:

• The associated MB Report Card Subject Code is set to one of the Arts subjects.

[S_MB_CRS_Courses_X]ReportCardCrsTyp or [S_MB_CRS_Courses_X]ReportCardCrsTyp = ARVA, ARDA, ARDR, ARMU, ARBA, ARCH, ARGU or AROR

• The associated MB Report Card Subject Code is not one of the schools Art Subject that is to be reported separately for that student’s grade level, as indicated on the Schools/School Info Page:

[S_MB_SCH_X]ArtByCat_A_[grade_level] or

[S_MB_SCH_X]ArtByCat_B_[grade_level] or

[S_MB_SCH_X]ArtByCat_C_[grade_level] or

[S_MB_SCH_X]ArtByCat_D_[grade_level]

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

EAL

Marked if this 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.[ReportCardCrsType].FLG

IEP

Marked if this 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.[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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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.[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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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.[ReportCardCrsType].CMT

Arts Subject or Discipline artistique (Arts Discipline)

Up to four 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.

The following can be set up to be ARVA, ARDA, ARDR, ARMU, ARBA, ARCH, ARGU or AROR:

[S_MB_SCH_X]ArtByCat_A_[grade_level]

[S_MB_SCH_X]ArtByCat_B_[grade_level]

[S_MB_SCH_X]ArtByCat_C_[grade_level]

[S_MB_SCH_X]ArtByCat_D_[grade_level]

The student must be currently enrolled in a class with:

[S_MB_CRS_Courses_X/S_MB_SEC_X]ReportCardCrsType =

[S_MB_SCH_X]ArtByCat_A_[grade_level] or

[S_MB_SCH_X]ArtByCat_B_[grade_level] or 

[S_MB_SCH_X]ArtByCat_C_[grade_level] or

[S_MB_SCH_X]ArtByCat_D_[grade_level] for Arts Subject Grading boxes to be printed in the student’s Report Card. Art subjects are order by alphabetically by [S_MB_CRS_Courses_X/S_MB_SEC_X]ReportCardCrsType.

Marks, comments and indicators are pulled from the Standards Identifiers described below.

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this student has been designated EAL in this art subject.

Set to X if Term Grade = E or EANDI and associated Standards Identifier = E1-6.[ReportCardCrsType].FLG

IEP

Marked if this student has been designated IEP in this art subject.

Set to X if Term Grade = I or EANDI and associated Standards Identifier = E1-6.[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.[ReportCardCrsType].C1

Category 1 grade for Term 1,2,Final

Mark attained by student.

Outputs Term Grade where associated Standards Identifier = E1-6.[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.[ReportCardCrsType].C2

Category 2 grade for Term 1,2,Final

Mark attained by student.

Outputs Term Grade where associated Standards Identifier = E1-6.[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.[ReportCardCrsType].C3

Category 3 grade for Term 1,2,Final

Mark attained by student.

Outputs Term Grade where associated Standards Identifier = E1-6.[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.[ReportCardCrsType].C4

Category 4 grade for Term 1,2,Final

Mark attained by student.

Outputs Term Grade where associated Standards Identifier = E1-6.[ReportCardCrsType].C4

Comments

Teacher Comments for latest Term included on the report card.

If Print Cumulative Report Card is selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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.[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”. [S_MB_CRS_Courses_X/S_MB_SEC_X]ReportCardCrsType = OPT

The Standards Identifier, parent code must be set up as E1-6.OPT.[Course_Number].

Marks, comments and indicators are pulled from the Standards Identifiers described below

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

[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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 this 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 this 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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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”. [S_MB_CRS_Courses_X/S_MB_SEC_X]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].

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

Multi Subject Grading Box Title

The title of the Multi Subject Grading Box entered on the Schools Info page.

If [S_MB_SCH_X]Multi-Subject_Title is not empty, the [S_MB_SCH_X]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 this 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 this 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: The format depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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

Notes: Valid values for Learning Behaviors are C, U, S or R. The code '9' represents "Non-assessed" and outputs in the XML version of the report, but outputs as blank in the PDF version.

IEP

Marked if this 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 [S_MB_SCH_X]ERC_LB1_Name

Local Option 1 – Description

Description of Local Option 1.

Outputs [S_MB_SCH_X]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 [S_MB_SCH_X]ERC_LB2_Name

Local Option 2 – Description

Description of Local Option 2.

Outputs [S_MB_SCH_X]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 selected, then teacher comments for all Terms selected for this report are printed. If Print Comment Term is selected, 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.

[S_MB_STU_X]PrincipalComments concatenated with [S_MB_SCH_X]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: The format of the homeroom teacher's name depends on the setting of the Teacher Name parameter at runtime. See the Report Input section above.

[Users]Last_Name [Users]First_Name [Users]PreferredName associated with Course that student is enrolled in that has [S_MB_CRS_Courses_X]ReportCardCrsType = HMRM

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

[StudentCoreFields]PSCore_Legal_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

[StudentCoreFields]PSCore_Legal_First_Name

[StudentCoreFields]PSCore_Legal_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 [S_MB_STU_X]StudentProgram1 through [S_MB_STU_X]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

Notes:

• If only IEP is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of learning goals in the student’s learning plan that are significantly different than grade-level learning expectations."

• If only EAL or L is indicated, then the following comment appears in the comment area:

  • "The achievement grade is based on achievement of some subject area learning goals at grade level, with a focus on language learning."

• If both the IEP and either EAL or L checkboxes are selected, the following comment appears in the comment area:

  • "The achievement grade is based on subject-area learning goals that are significantly different than grade-level learning expectations, along with a focus on additional language learning."

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>