MB Secondary Report Card - Legacy

Run Report For*

List of students to generate report cards for.

Choose whether you wish to run the report for the current selection of students or have the report search for students based on school, entry date and exit date (All Students). When the current selection is selected, the Grade Level is still considered for inclusion in the report run.

Note: This parameter is required.

Sort By*

What to sort the report cards by

Select the method of sorting for the report cards.

Options are:

• Student Name
• Student Name by Homeroom
• Student Name by Grade

Note: This parameter is required.

Date Issued*

The date to generate the report card for

Enter the date to be printed in the Date Issued field of the report card header. Defaults to today.

Note: This parameter is required.

Generate PDF Report Cards

PDF file output indicator.

Check if a PDF version of the report card is to be created. User can select either PDF or XML, but not both.

Generate XML Report Cards

XML file output indicator.

Check if an XML version of the report card is to be created. User can select either PDF or XML, but not both.

Exclude Classes With No Final Marks

Exclude classes that have no final marks.

Controls whether classes without final marks are included in the XML Report Cards. Select the checkbox to exclude classes that do not have final marks.

Include Excluded Courses

Include courses that are excluded from student marks

Controls whether courses with the [Courses] MB_ExcludeFromStuMarks field set to ‘Y’ are included on the report. Select the checkbox to include these courses.

Include Audit Classes

Include classes for which the student has been flagged as auditing

If selected, if "Student Is Auditing This Class" flag is turned on for the student for the class, the class is included. If the option is not selected and the audit flag is on for the class for the student, the class is not included. Default value is unchecked.

Include Principal's Name on Signature Line

Include the principal name on the report card

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:

• Don’t Include
• Print Name
• Use Signature Image

Timeframe Name

The name of the timeframe to print

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 9 to 12 Report Card” and above the School Name.

Include “Course” Before Course Names

Print word “course” before course names

Controls whether the word “Course:” is printed before each course name on the report. Select the checkbox to include this.

Include Semester Names on Mixed Report Cards

Print semester names above teacher names

Controls whether semester names are printed for classes on mixed semester reports. Select the checkbox to include the semester names above the teacher names.

Print Cumulative Report Card

Print cumulative report card

Controls whether a cumulative report will be generated containing all teacher comments suitable for archival purposes. Select the checkbox to include all teacher comments on the report.

Print Comment Term

Print term headers in comment box for cumulative report cards

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*

Type of teacher name to display

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

Options are:

• Use Teacher First and Last Name
• Use Teacher Preferred Name and Last Name
• Use Teacher First Initial and Last Name

Note: This parameter is required.

Include Co-Teachers

Select teachers to print

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.

Read Standards From

This option is removed as of version 2.6. The report now uses only Gradebook (PSM) tables.

n/a

Grades printed on the Report Card are read from Gradebook (PSM 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.

Print Report Cards In

(Orientation)*

Report Card page orientation

Controls the orientation of the subject pages of the Report Card. Options are Portrait and Landscape.

Notes:

• The first and last page of each student report card will always be portrait.
• This parameter is required.

Print Double Sided Report Card

Specify whether report will be printed single or double sided.

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 course detail pages are double sided - the backs of the first page and the last page are printed blank.

Print For Transferred Out Students Only

Specify to print report cards for students who are no longer enrolled in this school

If checked, the report will only print report cards for students who are not currently enrolled in the school in the school term specified at the top of the PowerSchool page.

The report will only check the students included the Run Report For selection.

Report Card Type*

Type of report card to generate

Select one of the following:

• Non-Semester
• Semester
• Mixed

The selected report card type affects how the store code selection list boxes described below are displayed.

Refer also to Report Type selection criteria above.

Note: This parameter is required.

Included Terms*

Terms used to identify the classes to include.

Select one or more terms. Only classes whose scheduling term matches a selected term are included in the report.

Note: This parameter is required.

Term 1 Store Code(s)

Store code used to identify the grades to report on the “First” term of the Report Card.

Displayed regardless of selected Report Card Type.

You can select more than one store code 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 class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Term 2 Store Code(s)

Store code used to identify the grades to report on the “Second” term of the Report Card.

Displayed regardless of selected Report Card Type.

You can select more than one store code 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 class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Term 3 Store Code

Store code used to identify the grades to report on the “Third” term of the Report Card.

Displayed only for Non-Semester and Mixed Report Card Types.

You can select more than one store code 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 class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Term 4 Store Code

Store code used to identify the grades to report on the “Fourth” term of the Report Card.

Displayed only for Mixed Report Card Type.

You can select more than one store code 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 class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

First Exam Store Code

Store code used to identify the grades to report on the “First” exam of the Report Card.

Displayed only for Non-Semester and Mixed Report Card Type.

You can select more than one store code 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 first exam marks for a class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Second Exam Store Code

Store code used to identify the grades to report on the “Second” exam of the Report Card.

Displayed only for Non-Semester and Mixed Report Card Type.

You can select more than one store code 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 second exam marks for a class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Exam Store Code

Store code used to identify the grades to report on the “Final” exam of the Report Card.

Displayed only for Semester Report Card Type.

You can select more than one store code 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 exam marks for a class exist for only one of the store codes in this list, otherwise unpredictable results may occur.

Final Grade Store Code

Store code used to identify the grades to report on the “Final” grade of the Report Card.

Displayed regardless of Report Card Type.

You can select more than one store code 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 final grade marks for a class exist for only of the store codes in this list, otherwise unpredictable results may occur.

Get marks from Stored Grades

The source of student Stored Grade marks; grade or percent.

Select one of the follow options:

• Grade: The report uses the [StoredGrades]Grade value.
• Percent: The report uses the [StoredGrades]Percent value.
  (unless [StoredGrades]Percent is empty, null, or 0 AND [StoredGrades]Grade contains one of: CO’, ‘IN’, ‘NE’, ‘NM’, in which case the report uses the value of [StoredGrades]Grade)

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.

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’

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

Date Issued

The date that the report card will be issued on

Date entered at runtime

Learning Behaviors – Local Option 1 Title

The name of Local Option 1 entered on the Schools page.

 [S_MB_SCH_X]SRC_First_LB_Name

Learning Behaviors – Local Option 1 Description

The description of Local Option 1 entered on the Schools page.

 [S_MB_SCH_X]SRC_First_LB_Description

Learning Behaviors – Local Option 2 Title

The name of Local Option 2 entered on the Schools page.

 [S_MB_SCH_X]SRC_Second_LB_Name

Learning Behaviors – Local Option 2 Description

The description of Local Option 2 entered on the Schools page.

 [S_MB_SCH_X]SRC_Second_LB_Description

Information for each class

Semester

The name of the semester that the class is being offered in.

[Terms]Name

Teacher

The name of the teacher that is teaching the class.

If the Include Co-Teachers option is "Yes" all teachers associated with the 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

Credit Value

The number of credits that the class is worth.

[Courses]Credit_Hours

Credits Earned

The number of credits that the student has earned for the class.

[StoredGrades]EarnedCrHrs

(Course Name)

The name of the course that is being taught in the class.

[Courses]Course_Name

IEP (behaviours)

Indicates whether the student has an Individual Education Plan.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12.[Courses]Courses_Number.IEP’

Lates (Total)

The total number of times the student has been late to the class as of the end of the term.

[Attendance]Attendance_CodeId

Absences (Total)

The total number of times the student has been absent from class as of the end of the term.

[Attendance]Attendance_CodeId

Grade

The grade the student has received in the class for the term.

[StoredGrades]Grade

Exam Mark/Final Exam

The grade the student has received on the exam in the class. If [Sections]MB_ExamMarkIncl is defined and has the value is "Y", or, if undefined for the class, [Courses]MB_ExamMarkIncl is "Y", an "*" is printed beside the mark.

[StoredGrades]Grade

Final Grade

The final grade the student has received in the class.

[StoredGrades]Grade

Personal Management Skills

The grade student has received in the class for personal management skills for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.PM’

Active Participation in Learning

The grade student has received in the class for active participation in learning for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.AP’

Social Responsibility

The grade student has received in the class for social responsibility for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.SR’

Engagement In Learning French

(French Immersion Only)

The grade student has received in the class for engagement in learning French for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.EIUF’

Local Option 1

The grade student has received in the class for local option 1 for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.L1’

Local Option 2

The grade student has received in the class for local option 2 for the term.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.L2’

(Teacher) Comments

The comments that the teacher has made regarding the student for the term. If more than one Term has been selected for the report, only the comment for the latest Term is printed unless the Print Cumulative Report Card option has been checked.

If [Sections]MB_ExamMarkIncl is defined and has the value is "Y", or, if undefined for the class, [Courses]MB_ExamMarkIncl is "Y", the text "* Provincial Test" is printed in the comment 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.).

[StoredGrades]Comment_Value for the storecode selected in the latest Term selected.

If [CC]DateLeft is before [Terms]LastDay then the value “Withdrawn” is also prepended.

Completion of Credit Requirements for Graduation

This section includes credits from classes taken at all schools, not just the school running the report card.

• Information is taken from the assigned student graduation plan. If a student does not have an assigned plan, the section is not printed.
• A student is considered to be in a technology education program if any of the top-level Subject Groups contain the word "Technology" or "Technologique".
• The last top-level Subject Group is considered to be for "Optional" credits.
• If the student is in a technology education program, the second last top-level Subject Group is considered to be for "Technology Education" credits.
• All other top-level Subject Groups are considered to be compulsory credits.
• The first Diploma Requirement is a calculated compulsory credits row.
  • On English and French Immersion report cards, the name is "Compulsory Credits"
  • On Français report cards, the name is "Crédits obligators"
  • The Credits Required for Graduation is the sum of all Credits Required from the top level Subject Groups that are compulsory
  • The last Diploma Requirement is a calculated total credits row.
    • On English and French Immersion report cards, the name is "Total"
    • On Français report cards, the name is "Totaux"
    • The Credits Required for Graduation is the sum of all Credits Required from the top level Subject Groups
    • All other Diploma Requirements match the top-level Subject Groups.
      • The name of the Diploma Requirement is the Subject Group name
      • The Credits Required for Graduation is the value of the Credits Required
      • For compulsory credits, if the Credits Required = 4, then 1 credit per grade is assumed and noted after the Diploma Requirement name
      • For compulsory credits, if the Credits Required = 3, then 1 credit per grades 9, 10, & 11 is assumed and noted after the Diploma Requirement name
      • For compulsory credits, if the Credits Required = 2, then 1 credit per grades 9 & 10 is assumed and noted after the Diploma Requirement name
      • For optional credits that are not in a technology education program, then 1 required credit from each of grades 11 & 12 is assumed and noted after the Diploma Requirement name

Diploma Requirement

The name of the diploma credit category.

[GPNode]Name

Credits Required for Graduation

The number of credits that are required to achieve graduation in each category.

n/a

Credits – Enrolled This Year

The number of credits that the student has enrolled in this year in each category. This year is determined from the current term displayed in the Terms dropdown in PowerSchool when the report is run. The credits are based on potential credits for all classes that the student has enrolled in for the year, which includes failed and withdrawn classes. If the student has withdrawn from a class and is repeating it in the same year, then the potential credit is only counted once.

Note: an audited class does not count towards any credit

[StoredGrades]PotentialCrHrs where [Terms]YearId is the current year

Credits Earned This Report

The number of credits that the student has earned in this report term in each category. This report term is determined from the current term displayed from the Terms dropdown in PowerSchool when the report is run. If the current term is the year long term, classes for all terms in the year are evaluated.

[StoredGrades]EarnedCrHrs where [StoredGrades]TermId is current

Total Credits Earned To Date

The total number of credits that the student has earned to date towards graduation in each category.

[StoredGrades]EarnedCrHrs

Total Credits Earned to Date From Courses Taught in French

(French Immersion Only)

The total number of credits that the student has earned to date towards graduation for classes that have been taught in French in each category.

[StoredGrades]EarnedCrHrs where [Sections]MB_LanguageOfInst or [Courses]MB_LanguageOfInst is ‘02’

Compulsory Credits

The number of compulsory credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to everything other than “Technology Education” or “Optional Credits” on the student’s graduation plan.

English

The number of English credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “English Language Arts” on the student’s graduation plan.

Francais

(French Immersion Only)

The number of French credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “French” on the student’s graduation plan.

Mathematics

Mathématiques

The number of Mathematics credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Mathematics” on the student’s graduation plan.

Physical Education/Health Education

Éducation physique et Éducation à la santé

The number of Physical Education/Health Education credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Physical Education / Health Education” on the student’s graduation plan.

Social Studies

Sciences humaines

The number of Social Studies credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Social Studies” on the student’s graduation plan.

Science

Sciences de la nature

The number of Science credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Science” on the student’s graduation plan.

Approved Cluster of Compulsory Technology Education Credits

The number of Technology Education credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Technology Education” on the student’s graduation plan.

Optional Credits

The number of Optional credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Credit_Type results in the class being assigned to “Optional Credits” on the student’s graduation plan.

Totals

The total number of credits required, enrolled, and earned.

[StoredGrades]EarnedCrHrs

Last Section

Principal’s Comments

Principal Comments for this student and school.

[Students]MB_PrincipalComments concatenated with [Schools]MB_PrincipalComments_912

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

/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 the student is enrolled in a Technology Education diploma, then if any of the [Students]MB_StudentProgram1 through [Students]MB_StudentProgram4 fields contain the value 110,111,or 112 then this will be 5, otherwise 4.

If the student is not enrolled in a Technology Education diploma, then 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.

/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

lbIEP

Indicates whether the overall behaviour of this student has been based on IEP.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12.[Courses]Courses_Number.IEP’

finalMark

Final mark for the student. Valid values are 0-100, CO or IN.

[StoredGrades]Grade

credit

Credit earned for course. Valid values are 0, 0.5 or 1.

[StoredGrades]EarnedCrHrs

/reportCards/school/student/enrolment/course/attendance

period

The reporting period for this element. Valid values can be 1 to 4.

N/A. Calculated.

daysAbsent

The number of days the student was absent from school/ class.  Must be a number between 0 and 200, inclusive.

[Attendance]Attendance_CodeId

/reportCards/school/student/enrolment/course/learningBehaviours/lb

period

The reporting period for the behaviour assessment.

Valid values can be 1 to 4.

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.

[StandardGradeSectionStandardGradeSection]ActualGradeEntered where [PSM_Standard]Identifier is ‘S9-12. [Courses]Courses_Number.<behaviour>’