Run the SQL script titled: “SE AA College Boards MI”.
MySQL staging table: “aa_ach_collegeboards_mi”.
Prepare the MI Portal SAT file.
Save the CSV file as an XLSX file.
Rename Column A from MMETestPeriod to TestPeriod
Rename Column AH from SATRegistrationNumber to RegistrationNumber
Rename Column AK from SATTotalScore to TotalScore
Rename Column AL from EvidenceBasedReadingWritingSectionScore to Evidence-BasedReadingandWritingSectionScore