CTE Levels

2014 process

The process requires 2 steps

Export the CC table and filter to grades 11,12 Courses with Tech Credits

TCH, STE, HCS, VOC

Pivot table Student with Number of Courses Currently Enrolled

Second Step Export Historical Grades

Y1 With earned Credit

Then Merge the Table Manually