Test Scores Mass Update

Select Registration > Utilities > Tools > Mass Update by Test Score
Use this utility to mass update student records for students who meet the test score criteria you identify. The Passed Score option lets you select a test score and define a passing test score value. The utility will then limit mass update processing to include only students who meet the test score value requirement you define. For the selected students, the utility then updates student information for the page and field value you indicate.

The ELA/CST Proficiency option lets you select a test score and define a passing test score to update student records. If students meet the ELA/CST Proficiency test score values for three times, then you can update such students as ELA CST Proficiency or Advanced and RFEP (Reclassified Fluent English Proficient). You can enter the recent date of the test score as the status date and start date for the Program. Based on this criteria, you can also update student information in other district-defined Pages. For more information on ELA/Proficiency, refer to CA Demographics and CA120 – English Proficiency sections.

To mass update students record based on a test score:

On the Mass Update by Test Scores page, enter the desired search criteria and click Load Records.
Verify that the correct students were selected on the Records To Be Updated panel.
To remove students from the list, check the Remove box, and select Remove.
On the Test Score Information panel, select the test, sub-test, and score to use as the basis for processing. Then define the Score Value to assess the test score you identified.
Select the option based on the type of district-defined page you need to update for students.
On the Prompts panel, select the Area, the Field Name, and enter the New Value that you want to mass update for student records. If you selected a field that is program tracked, the Program Tracking Information column will display an Edit link and a red flag icon. You can also mass update the program tracked field. Click the Edit link to define the way the utility should handle closing existing program vectors and opening new ones.
Click Run to mass update the student records with the values you entered.
Check the Test Score Information Mass Update Information Statistics log.

Field/Section	Description
Test – Level - Form	A combination of Test, Level, Form , Subtest, and Scores must be entered as follows: Enter the test code. The other text boxes in that row will be accessible. Enter the test Level and Form for the test code you entered or select the Level and the Form code from the table list. Select the Subtest code for the test code you entered. Select the Subtest scores code for the test code you entered.
Score Value	Acceptable Score Pass Value is a test value range that you can set to determine the students to mass update. The utility uses the value range you set here to assess which students meet the score pass criteria for the test score you selected. In the Acceptable Score Pass Value field, you can: Select the range for the Acceptable Score Pass Value you set. For example, = (equals) 70, 80,90, or > 90 Enter the Acceptable Score Pass Value you want to use to determine the student to update their records.
Data to Update	Regular District Defined: Use this option to update a student district-defined page where one record displays on-page at a time. For example, when you access the CA Demographics page, you are viewing and updating a single database record for the student. List Type District Defined: Use this option to update a student district-defined page where multiple records display on-page at a time. For example, when you access the CA Access page, you can view and update multiple database records for the student. When you select this option, an Additional Filter section is displayed in the Prompts panel. Base Table: Use this option to update values for base pages such as Demographic, Contacts, Academic, Emergency, and Personal.
Update Values	Area: Select the area for which you want to update the values. Field Name: Select the field name for which you want to update the value. New Value: Enter the value that you want to update for the field. Program Tracking Information: If you selected a field that is program tracked, the Program Tracking Information column is displayed with an Edit link and a red icon. Click the Edit link. In the Program Tracking Field Update window, define how the utility should close existing program vectors and open new ones for the program-tracked field you selected. After you update the Program Tracking information, the red flag icon changes to green. When you move the mouse pointer over the green icon, a tooltip displays the information you entered in the Program Tracking Field Update pop-up window. Remove: Check the Remove box and click the Remove Value button to remove the value from the list. Update Existing Records: Checked if you want to update the existing records with new values. If this box is unchecked, the values will not get updated. Click the New Value button to add more rows to update values.
Additional Filter Section for List Type District Defined	This section is displayed only when you select the Multiple Row Page option. Use this section to filter the district-defined records you update based on fields within the record. Area: Select the area for which you want to update the value. Field Name: Select the field name for which you want to update the value. Existing Value: Enter the existing value of the field. Remove: Check the Remove box and click the Remove Value button to remove the row from the list. To add a new row of filter criteria, click the New Value button.
Run	Now: Select this option to mass update the students records now. The system mass updates the student's records for students who meet the acceptable pass score value criteria that you set. Once: Select this option to schedule mass update of students records at a later time and date. You must enter: Time: Enter the time you want to schedule the mass update. Date: Enter the date you want to schedule the mass update. The system mass updates the student's records for students who meet the acceptable pass score value criteria that you set.
Records To Be Updated	The list of students retrieved by your initial search. The utility will apply the test score, mass update and filter criteria to these students. You can review this list and remove students from it before processing it if needed. To remove students from the list, check the Remove box for the appropriate students, then click Remove. Note: This section displays only 5000 records at a time for updating.