Trying to figure out how to accurately measure retention of students from Term-to-Term, Fall-to-Fall and Year-by-Year and am failing. The issue around applying consistant filters. Goal:Measure retention as described above AND be able to consistently apply the same cohort filter(s) to subsequent term/year enrollment data. I'd like to add additional filters such as Declared Major, etc. in the future. Example:Cohort=2017 Academic Year, Term=2, Enrollment Status=Full-Time Results:Cohort is accurate but subsequent term data are not. Subsequent term data may be a mix of Full-Time, Part-Time and Non-Credit. Currently I'm using two tables (cohort and subsequent enrollment data) but would like to use a single table containing all enrollment data over a 5-year period. Thanks everyone!

Sure. Here is a simplified example of enrollment data. This would be an example of all enrollment history. I would like to define the starting cohort by filters (Academic Year, Academic Term, Enrollment Status, etc.) and apply the same or different filters on the resulting retention side. Obviously the retention academic period (YearTerm) must be greater than the cohort YearTerm. Hope that make sense. Thanks! Academic YearAcademic TermYearTermidEnrollment StatusCredit_Hours20174201741000Full-Time1220164201641000Full-Time1220173201731000Part-Time420172201721001Full-Time1220173201731001Full-Time1220174201741001Part-Time920184201841001Part-Time920182201821001Part-Time920164201641001Part-Time420163201631001Part-Time420162201621001Part-Time420183201831001Part-Time920174201741002Full-Time1320162201621002Full-Time1520163201631002Full-Time1720164201641002Full-Time1820172201721002Full-Time1720173201731002Full-Time1720194201941003Non-Credit020193201931003Non-Credit020164201641004Non-Credit020163201631005Non-Credit020163201631006Part-Time820172201721006Part-Time420194201941007Part-Time420192201921007Part-Time420193201931007Part-Time4

FYI ID = Unique student identifier for joining to demographic data.

Hi, Please show the exact result you are expecting on this sample data.

Here is a quick example (not final look). On left is the starting cohort where I can apply filers to Enrollment Status, YearTerm, etc.. The graph shows retention by subsequent term, but it shows all retention, regardless of Enrollment Status in the joined table. For example, If I wanted to know how many non-credit students were enrolled for Fall (yearterm 20192) who subsequently enrolled part-time, I would select the Part-Time filter on the right (enrollment table). Unfortunately I get wonky results (second picture). As you can see, Term 2 completely disappears and I end up with completely inaccurate results. In this example, I only show one year but the goal is to show year-to-year in another graph with similar filters (YearTerm to YearTerm). For example, Fall 2017-18 to Fall 2018-19 and break that out by starting Enrollment Status and ending Enrollment Status over the entire timeline. So 1,000 students start out as full-time, we want to track not only their retention but also their enrollment status term by term, year by year. Make sense? Thanks again! Photo 1: Retention by Term for Non-Credit Students Photo 2: Retention by Term for Non-Credit to Full-Time

Student Retention: Term-by-Term, Fall-to-Fall, Year-by-Year

22 Replies

Anonymous

Not applicable

7 years ago

Hi Anonymous ,

Can you please share some sample data with expect result to help us clarify your requirement?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

7 years ago

Sure. Here is a simplified example of enrollment data. This would be an example of all enrollment history. I would like to define the starting cohort by filters (Academic Year, Academic Term, Enrollment Status, etc.) and apply the same or different filters on the resulting retention side. Obviously the retention academic period (YearTerm) must be greater than the cohort YearTerm. Hope that make sense. Thanks!

Academic Year	Academic Term	YearTerm	id	Enrollment Status	Credit_Hours
2017	4	20174	1000	Full-Time	12
2016	4	20164	1000	Full-Time	12
2017	3	20173	1000	Part-Time	4
2017	2	20172	1001	Full-Time	12
2017	3	20173	1001	Full-Time	12
2017	4	20174	1001	Part-Time	9
2018	4	20184	1001	Part-Time	9
2018	2	20182	1001	Part-Time	9
2016	4	20164	1001	Part-Time	4
2016	3	20163	1001	Part-Time	4
2016	2	20162	1001	Part-Time	4
2018	3	20183	1001	Part-Time	9
2017	4	20174	1002	Full-Time	13
2016	2	20162	1002	Full-Time	15
2016	3	20163	1002	Full-Time	17
2016	4	20164	1002	Full-Time	18
2017	2	20172	1002	Full-Time	17
2017	3	20173	1002	Full-Time	17
2019	4	20194	1003	Non-Credit	0
2019	3	20193	1003	Non-Credit	0
2016	4	20164	1004	Non-Credit	0
2016	3	20163	1005	Non-Credit	0
2016	3	20163	1006	Part-Time	8
2017	2	20172	1006	Part-Time	4
2019	4	20194	1007	Part-Time	4
2019	2	20192	1007	Part-Time	4
2019	3	20193	1007	Part-Time	4

Anonymous
Not applicable
7 years ago
FYI

ID = Unique student identifier for joining to demographic data.

Forum Discussion

Student Retention: Term-by-Term, Fall-to-Fall, Year-by-Year

22 Replies

Related content

Multiple measures in matrix by year

Calculate formula by term

Year Over Year Increase% by week

Year-over-Year Measure by Month

How to rank by date within year and term