A Report to show learning gains from students test scores

[Guest]

I really don't know where to start. I have a table that contains our
students test scores for reading and math. The table is very simple. It
contains fields such as Student name, Reading level, Math level, grade, test
year. The table contains 4 years of information for most students. It
depends on the grade of the student that determines how many test scores they
will have. For instance, 3rd grade may only have one years worth of data. I
would like to design two reports one that will list students that had a
learning gain from one year to the next. And then a report show if they did
not have a learning gain. I hope that I have give you enough information to
get me started. I would greatly appreciate some guidance on where to start on
this report.

Thanks

 

[Duane Hookom]

You might start with one or more crosstab queries. For instance, create a
crosstab where the Student Name is the Row Heading, Grade is the Column
Heading, and First of Reading Level is the Value. Enter all possible values
of Grade into the Column Headings property of the crosstab.

You may need to create another crosstab for Math since your original table
is not normalized.