Hi,
I need to reformat some data I received before I can put it into my statistical software. This programming stuff is all pretty new to me, so any input broken down as simply as possible would be greatly appreciated.
I have data on every student that was enrolled at my school for each semester- which is great, but I want to form cohorts. Like group all the fall 05 freshmen together, all the fall 06 freshmen together, etc. so i have an cohort for each year.
So in each dataset, I can filter it so that I only have incoming freshmen, say fall 05 cohort, and get every fall 05 freshman's ID # and other variables of interest in their first year. The problem occurs when I try to track them. When I go into the fall 06 dataset it gives me EVERY student who was enrolled at the time. Again, I can pull out the fall 06 cohort, but also want to find all the fall 05 students who are still enrolled and add their 2nd year statistics as columns in a totally separate freshman 05 cohort. So from each dataset year (starting in fall 05) I want to find that year's cohort and create a new dataset with that (which is easy) but I also want the data matching every ID # from a previous cohorts detected and added into the correct datasheet.
That way I can see each student- when they make dean's list, when they withdraw, when they take a leave of absence, etc.
Recap: have datasets of every student enrolled at each year; want to pull out freshmen and create workbook with just that cohort (done) then find the information for each ID # in every dataset after that so that I can track each student after their 1st year.
Is this possible? I have asked my boss to put Access on my computer, so if this would be done easier with that, that's possible too. Even just pointing my in the right direction would be awesome.
Thanks so much.
I need to reformat some data I received before I can put it into my statistical software. This programming stuff is all pretty new to me, so any input broken down as simply as possible would be greatly appreciated.
I have data on every student that was enrolled at my school for each semester- which is great, but I want to form cohorts. Like group all the fall 05 freshmen together, all the fall 06 freshmen together, etc. so i have an cohort for each year.
So in each dataset, I can filter it so that I only have incoming freshmen, say fall 05 cohort, and get every fall 05 freshman's ID # and other variables of interest in their first year. The problem occurs when I try to track them. When I go into the fall 06 dataset it gives me EVERY student who was enrolled at the time. Again, I can pull out the fall 06 cohort, but also want to find all the fall 05 students who are still enrolled and add their 2nd year statistics as columns in a totally separate freshman 05 cohort. So from each dataset year (starting in fall 05) I want to find that year's cohort and create a new dataset with that (which is easy) but I also want the data matching every ID # from a previous cohorts detected and added into the correct datasheet.
That way I can see each student- when they make dean's list, when they withdraw, when they take a leave of absence, etc.
Recap: have datasets of every student enrolled at each year; want to pull out freshmen and create workbook with just that cohort (done) then find the information for each ID # in every dataset after that so that I can track each student after their 1st year.
Is this possible? I have asked my boss to put Access on my computer, so if this would be done easier with that, that's possible too. Even just pointing my in the right direction would be awesome.
Thanks so much.
