Personal Finance Assessment Spring Assessment (Missouri) [.2223 and previous]

Classic View: MO State Reporting > MOSIS Extracts > Pre-Code File > Extract Type: PRSFNC Spring

Search Terms: MOSIS Extracts

Students who take the Personal Finance Assessment for Spring:

  • Students who are taking a course in which the Personal Finance competencies are embedded are required to take the assessment.
  • Students who are attempting to “test out” are required to take the assessment.
  • For students who are enrolled in a stand-alone Personal Finance course, the assessment is optional.

MOSIS Pre-Code Extract - Personal Finance Spring Assessment

Report Logic

A record for a student/course/section is returned when:

  • The student is assigned to the state-mapped grade level selected on the Extract editor.
  • The student is enrolled in the calendar selected in the extract editor.
  • The student is scheduled into a course section where the value selected in the Assessment Type dropdown list on the Section editor is the selection (Spring, Fall, Summer) in the testing window field on the extract editor.

A record is not be included when the student, course, calendar and/or grade level is marked as state exclude.

Report Editor

Field

Description

Extract Type

Indicates the type of MOSIS Extract being generated. Choose Pre-code File.

Report Protected IdentitiesWhen marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
Report State Excluded Student
When marked, students who meet the report population requirements but their enrollment record is marked as State Exclude report along with all other records.

When not marked, students marked as State Exclude on their enrollment record are excluded from the report.
Date Range

Entered date is used to return students actively enrolled as of that date.

Ad hoc Filter

Selection of a filter limits the set of students to only those included in the filter.

Assessment Type

Determines the pre-code file that generates. Choose PRSFNCSPR: PRSFNC Spring.

Select GradesIndicates which grade levels are included in the extract. All grade levels can be selected, but the Personal Finance Spring extract only reports data for students in grades 9-12.

Format

Determines the program used to display the report. State Format is in CSV - use this option when submitting data to the state. Use the other options or data review and testing - Tab Delimited, HTML, or XML.

Calendar Selection

Indicates from which enrollments are included in the extract. At least one calendar must be selected to generate the report. Calendars can be selected by active year, school name or year.

Report Generation

The report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information.

Generate the Personal Finance Spring Pre-Code Extract

  1. Select the Pre-code File option from the Extract Type dropdown list.
  2. Mark the Report Protected Identities checkbox, if desired.
  3. Mark the Report State Excluded Students checkbox, if desired.
  4. Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date, if applicable.
  5. Select an Ad hoc Filter, if applicable.
  6. Select the Assessment Type as PRSFNCSPR: PRSFNC Spring from the dropdown list.
  7. Select which Grades to include in the report.
  8. Select the desired Format of the extract. For submission to MOSIS, select the State Format (CSV). Select any of the other formats for data review prior to submission.
  9. Select which Calendar(s) to include report within the extract. Selecting multiple calendars may impact extract generation times and overall Campus performance.
  10. Click the Generate Extract button or the Submit to Batch button. The extract will appear in a separate window in the designated format.

Personal Finance Spring - CSV Format

Personal Finance Sprint - Tab Delimited Format

Personal Finance Spring - HTML Format

Report Layout for Personal Finance Spring Assessment

Element Name

Description

Location

Testing Window
Required

Returns the test window and school year.


The spring testing window of the 2018-19 school year returns SPRING20182019.


Alphanumeric, 12 characters

Scheduling > Courses > Course > Section > Section Editor > Assessment Type


Student.startYear
Student.endYear
CustomSection.
assessmentType

County District Code
Required

DESE-assigned 6-digit county district code for the district reporting.


Numeric, 6 digits

System Administration > Resources > District Information > State District Name


District.number

School Code
Required

DESE-assigned school code from where the student is being reported.


Numeric, 7 digits

System Administration > Resources > School > State School Number


School.number

MOSIS ID
Required

State-assigned student identifier.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

Last Name
Required

Legal last name as it appears on the student's birth certificate.


When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Last Name


Identity.lastName


Census > People > Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

First Name
Required

Legal first name as it appears on the student's birth certificate.


When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated.


Alphanumeric, 30 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName


Census > People > Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Suffix
Optional

Generational indication (Jr., III, etc.) part of the name, if any.


When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Suffix field if populated.


Alphanumeric, 10 characters

Census > People > Demographics > Person Information > Suffix


Identity.suffix


Census > People > Identities > Protected Identity Information > Legal Suffix


Identity.legalSuffix

Date of Birth
Required

Student's birth date as it appears on the birth certificate.


Date field, 10 characters

Census > People > Demographics > Person Information > Birth Date


Identity.birthdate

Student Grade Level
Required

Grade level of enrollment at the time data is being submitted, unless otherwise specified.


Alphanumeric, 2 characters

Student Information > General > Enrollments > General  Enrollment Information > Grade


GradeLevel.stateGrade
Enrollment.grade

Gender
Required

Student's gender.


When the Report Protected Identities checkbox is marked on the report editor, the student's gender reports from the Legal First Name field if populated.


Alphabetic, 1 character (M or F)

Census > People > Demographics > Person Information > Gender


Identity.gender


Census > People > Identities > Protected Identity Information > Legal Gender


Identity.legalGender

Race/Ethnicity
Required

The student's defined race/ethnicity.


Alphanumeric, 2 characters

Census > People > Demographics > Person Information > Race/Ethnicity


Identity.raceEthnicity

Course Name
Required

Name of the course for which the student is receiving personal finance credit.


Alphanumeric, 12 characters

Scheduling > Courses > Course > Course Information > Name


Course.Name

Instructor Name
Required

First name of the educator who will be administering the assessment. 


Alphanumeric, 60 characters

Scheduling > Courses > Course > Section > Staff History > Primary Teacher


StaffHistory.teacher

Class Period
Required

Period in which the instruction took place.


Alphanumeric, 2 characters

Scheduling > Courses > Course > Section > Section Editor > Schedule Placement


Period.Name

Test Type
Required

Indicates if the course was embedded, stand alone or test out option, as defined on the Assessment Subject Field.


Alphanumeric, 16 characters

Scheduling > Courses > Course > Assessment Subject


Course.Assessment