After student data is uploaded to DataManager, you can modify the data as needed by submitting a new data file containing the data you want to change. For example, you can change the student name, grade, or code of any student.
Note: You can also change some data values directly in the DataManager interface. See Editing Student Records.
1. Open the Student File Template in Microsoft Excel®.
2. Type or copy student data into the columns. Note the following:
– Do not delete columns from the template or change the header text.
– Enter only permitted values in the fields. See descriptions of columns and valid values for definitions, length limits, and special characters. Commas are not permitted.
– The District, School/Building and Class fields must be identical in all three data files (Location, Staff/User, and Student).
3. When you have finished adding data to the template, click File, and then click Save As. The Save As dialog box appears.
4. In the Save in list, browse, as needed, and select the directory where you plan to retrieve the file when uploading.
5. In the Filename box, type a name for the file. The file naming convention for the data file to update student information is as follows:
upd_myrpcftpname_testfamily_student_mmddyy.csv
where:
– myrpcftpname is the username for the SFTP site on RPCFTP. Enter the username that was provided to the Account Holder in the Welcome Information email.
– testfamily is the test family name. Enter "default" if you plan to use this data file for more than one test family.
– mmddyy is the date you want associated with the data file, usually today’s date.
See File Naming Conventions for Data Files for more information about naming new data files.
6. In the Save as type list, save the file with a comma-separated values extension (.csv).
7. Click Save, and close the file. The file is ready to upload.
See Also: