The results of this data is displayed in a Tableau chart. The data for each year needs to be download every year. As years go by, the data is updated for each year to pickup the 24, 36 months, etc.
1. MI School Data à Postsecndary Outcomes by High School à 24 College Credits.
2. All Schools and All Categories.
3. Download/Print
4. Request School Data File (Non-cell suppressed) file will be emailed to you.
The CSV file contains lengthy column names and need to be importrd into a MySQL temp table before loading. The following SQL statements are stored in Academic Achievemenr à MI SE Colege Credits in 24 Utilities
1. TRUNCATE TABLE aa_mi_se_24credits;
2. Import the CSV file that was emailed into aa_mi_se_24credits.
3. Updated the Term ID: UPDATE aa_mi_se_24credits SET ImpNtmID = ##;
4. Now do the State: UPDATE aa_mi_se_24credits SET ImpMunID = 4165 WHERE ImpMunID IS NULL AND `ISD OfficialName` = 'Statewide' AND `ISD Code` = '0';
5. UPDATE aa_mi_se_24credits SET ImpMunID = 72233 WHERE ImpMunID IS NULL AND DistrictCode = '84060';
6. Update District ID: UPDATE aa_mi_se_24credits JOIN m_municipalities ON MunDOECode = DistrictCode SET ImpMunID = MunID WHERE MunModID = 2 AND MunState = 'MI' AND MunType <> 'ISD';
7. Now do the ISD MunID's: UPDATE aa_mi_se_24credits JOIN m_municipalities ON `ISD Code` = MunDOECode SET ImpMunID = MunID WHERE MunModID = 2 AND MunState = 'MI' AND MunType = 'ISD' AND ImpMunID IS NULL;
8. Check for missing MunID's:SELECT DISTINCT `ISD OfficialName`, `ISD Code`, DistrictCode FROM aa_mi_se_24credits WHERE ImpMunID IS NULL;
9. Insert the records into MySQL production table: INSERT INTO s_twentyfourcredits (StcMunID, StcNtmID, StcBuildingName, StcType, StcSubGroup, StcRaceEthnicity, StcTotalGraduates, StcNumberCredits12, StcNumberCredits16, StcNumberCredits24, StcNumberCredits36, StcNumberCredits48) SELECT ImpMunID AS StcMunID, ImpNtmID AS StcNtmID, BuildingOfficialName AS StcBuildingName, `IHE Type` AS StcType, SubGroup AS StcSubGroup, `Race/Ethnicity by Gender Subgroup`AS StcRaceEthnicity, `Total Graduates (All Students)` AS StcTotalGraduates, `Total Accumulating 24 Credits within 0-12 months` AS StcNumberCredits12, `Total Accumulating 24 Credits within 0-16 months` AS StcNumberCredits16, `Total Accumulating 24 Credits within 0-24 months` AS StcNumberCredits24, `Total Accumulating 24 Credits within 0-36 months` AS StcNumberCredits36, `Total Accumulating 24 Credits within 0-48 months` AS StcNumberCredits48 FROM aa_mi_se_24credits WHERE ImpMunID IS NOT NULL;
10. Refresh Tableau chart: se_achievement_24credits_dev