Michigan College Board Portal

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