[DistrictEmisCoordinators] ACT Scores

[Karen Wilson]

Afternoon all!
The ACT scores are back,

I wanted to update you on how to load your ACT spreadsheet.  Thanks Tammy for working with me on this!!!

DASL put out that you need to update columns CR and CS to Change Strnk to StRnk
Update column AA to say 10,11,or 12 not 10th , 11th  or 12th

What they failed to mention is that once you open the file, some of the formatting changes.

The file not only contains your State ACTs from February, but all other ACT scores taken this school year.  If you have not loaded or hand entered previous scores that is fine.
If you  have you need to delete the test scores with those dates out of the file or it will load them as duplicates.

Now to format the file:

The test date column AO needs to be mmyyyy.  22024 will not load.  You will have to highlight the column with the test score, right click, format cells and click on custom and put 000000 in the field.  That will update that column to report any date for the months of January through September to have a leading 0.

The column for Birthdate, column P, needs to be mmddyyyy just highlight the row and format cells as custom with 00000000 and it will add all the 0s in.


Save the file as a .csv and do not open it again prior to loading.


This should allow you to load the file.  From what I have seen you will still have some unmatched records but the majority of them will load.

Let me know if  you have any questions.

K



Karen Wilson MCEP
EMIS Support Specialist
Miami Valley Educational Computer Association
888 Dayton Street, Suite 102
Yellow Springs, OH 45387
937-767-1468 ext 3115
Fax 937-767-1793

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.mveca.org/pipermail/districtemiscoordinators/attachments/20240319/51557581/attachment.htm>