Import Financial Literacy Results using Quick Import and Data Import Manager

PowerSchool supports importing Financial Literacy Graduation Requirement results from an external system using Quick Import or the Data Import Manager.

The import creates or updates the student's Financial Literacy result, including completion status, score, and test date.

The Financial Literacy test uses the following result values:

Value	Description
1	Successfully Completed
2	Not Successfully Completed Yet
N/A	Not Applicable or exempt

Quick Import

Use Quick Import to import Financial Literacy results into the Financial Literacy test.

Choose Special Functions from the main menu.
Click Importing & Exporting.
Click Quick Import.
Choose the appropriate test-related table.
Select the file delimiter and character set that match the import file.
Browse to and select the Financial Literacy import file.
Verify that Suggest Field Map is selected.
Map the import fields as described below.
Select Check to exclude first row if the file contains column headings.
Click Import and review the results.

The Quick Import template must support, at minimum, the following fields:

Field	Description
Student identifier	Identifies the student associated with the imported result.
Alpha score	The Financial Literacy result. Valid values are `1` for Successfully Completed, `2` for Not Successfully Completed Yet, and `N/A` for Not Applicable or exempt.
Percent	The Financial Literacy mark, when provided by the external system.

Data Import Manager

Use the Data Import Manager to import Financial Literacy results when the source file contains the complete student, school, term, grade, test, score, and date information.

The Data Import Manager template must support, at minimum, the following fields:

Import Field	Description
STUDENT_NUMBER	The student's PowerSchool student number.
SCHOOL_NUMBER	The school number associated with the result.
TERM_CODE	The term associated with the result.
GRADE_LEVEL	The student's grade level.
TEST_NAME	The name of the test. Use the Financial Literacy test name configured for the district.
TEST_DATE	The date on which the result was achieved.
SCORE_NAME	The name of the score.
ALPHA_SCORE	The Financial Literacy result: `1`, `2`, or `N/A`.

To import the file:

Navigate to the Data Import Manager page.
Select the source file.
Choose the applicable test-related import destination.
Map the source columns to the PowerSchool fields listed above.
Review the mapped fields and import options.
Click Import.
Review the import results and correct any failed records before reimporting them.