status change count query

[geraldjr30b]

i hope this makes sense, but i want to write a query which tracks the movement of student status for a 4 month period. the status would be 4 possibilities/buckets. passing, very good, needs improvement and failing, with a range of scores to be used to determine each. i want to get the count of students and the names in the starting category for month 1, and then track the number in each category for each month, like as the students change status/categories. Please help. so the end result will be in a pivot table with category along the left side and category along the top. i guess the months can be filtered at the top?

 

[johnherman]

Would these be college students or high school students? Will there also be buckets for homework, quizzes, tests, and FINAL?

==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than agile innovative cognitive big data clouds)

 

[TamarGranor]

What does the data you're starting with look like?

Tamar

 

[geraldjr30b]

buckets will be 50-59, 60-79, 80-99 and 100+. For example purposes, lets say that there will be a list of students. and each student will have one record per month. for JAN, the bucket may be 60-79 and for 2 months later in MAR it might be 100+. I hope this helps. I just want to be able to track each student over time using crosstab. like how many moved from one category to another each month.

Thanks

 

[geraldjr30b]

is anyone able to help with this question? thanks

 

[gmmastros]

You are more likely to get help with this if you post some sample data and expected results.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom