
1. Re: How to measure student progression
Christine Alexander Oct 2, 2019 7:23 AM (in response to cindy baker)1 of 1 people found this helpfulHi Cindy,
I've attempted to measure this by creating calculations based upon the students' entry terms and the terms at which we expect
them to reach sophomore status, junior status, etc. We're a Banner school and have our term codes set up as 6 digit strings (fall 2018 is 201810, fall 19 is 201910).
For instance, the entry term for the cohort entering last fall is 201810. We'd expect them to reach sophomore status by 201810+100=201910; junior status should be
201810+200=202010, etc. Using those term calculations as milestones, I can then check for registration and/or GPA activity for those terms to flag them as here/not here.
I do a similar thing to calculate graduation rate.
Chris

2. Re: How to measure student progression
Virginia Moench Oct 3, 2019 1:17 AM (in response to cindy baker)2 of 2 people found this helpfulI have done this in the past using a few calculations.
1) I identified the number of hours a student has at the end of each term using a LOD calculation (let's name it Hours EOT 201810):
{FIXED [Student]: IF [Term] = "201810" THEN MAX ([Earned Hours])}
2) Next, I used another calculation to group them (let's name it Calculated Level 201810):
IF [Hours EOT 201810] < 30 THEN "Freshmen"
ELSEIF [Hours EOT 201810] >= 30 AND [Hours EOT 201810] < 60 THEN "Sophomore"
etc...
3) Once I have 2+ terms of data I can write a calculation that compares levels from term to term.
IF [Calculated Level 201810] = "Freshman" AND [Calculated Level 201910] = "Sophomore"
OR [Calculated Level 201810] = "Sophomore" AND [Calculated Level 201910] = "Junior"
OR [Calculated Level 201810] = "Junior" AND [Calculated Level 201910] = "Senior" THEN "Progressed"
ELSEIF [Calculated Level 201810] = [Calculated Level 201910] THEN "Did Not Progress"
END
Of course, you have to write an "OR" line for every possible combination...like a student who progressed from a freshman to a junior. There is probably an easier way to do it, but I have not explored other approaches.
If you wanted to look at dropouts and/or graduates then you'd have to work in some additional fields/calculations.