How to present this in a chart, form or report?

[Applebaum]

Hello,

I've got a group of data that I think would be best presented in a chart
format, but I can't figure out how to do this. I'm tracking average
responses to class evaluation questions. We've had 100 classes, stretching
back five years. Each class finishes by having the students fill out a
class evaluation form, in which they reply to ten questions on a scale from
one to five. The students' responses to each question are averaged for each
class. So, for every class, I have an average response for each of ten
questions.

We want to be able to compare responses to questions between classes (and
teachers), and compare responses over time.

I have:

tblClasses
ClassID

(for example: CL01, CL02, CL03)

tblEvalQuestions
QuestionID

tblClassEvalAverages
ResponseID
CourseID
QuestionID
AverageScore


I'm imagining something like this:

Question1 Question2 Question3 etc
Class1 4.2 4.1 3.9 etc
Class2 5.0 4.5 4.2 etc
Class3 4.6 3.8 4.5 etc
etc

The chart wizards and help files in either Access or Excel are not helping;
I would love to be able to do this in either application. Are my tables set
up correctly?

Thanks very much in advance!

Matthew

 

[Duane Hookom]

There is a graph report based on a questionaire in "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.