I work for a school district that is getting state testing results that need to be brought into our Student Information System. The state reports results using a state student ID and our system requires the local student number to import data. I can put all of the data into one spreadsheet, but need to align the state results with the local student number.

Attached is a sample spreadsheet that shows the basic data. The rows with the School District information (A, B, C, D) comes from the state and needs to have the Local Student Number (L) added to the row in order to import into our system. The file from the state will be about 1000 records and all may or may not be in our system when the file is received.

Any thoughts on the most efficient and accurate way to accomplish would be greatly appreciated as we will do this multiple times a year. Thanks!

Keystone Passed test file.xls

Jacque Kakareka