I need to develop an Instructor Critique database. Any Ideas?

[mission control]

I am creating an Access database of student comments about each instructor in
a two week course/seminar. I would like to create an overall report for each
instructor so that they can improve their performance during the next course.

 

[John W. Vinson]

On Sat, 15 Mar 2008 08:52:00 -0700, mission control <mission

I am creating an Access database of student comments about each instructor in
a two week course/seminar. I would like to create an overall report for each
instructor so that they can improve their performance during the next course.

ok... what can we do to help? What do you have so far?

 

[Duane Hookom]

That's a pretty good idea. Are you looking for any specific assistance from
us? If so, can you tell us anything about your tables or how you want your
data to display in the report?

 

[DM]

as John said, where you at.

I recommend starting with the following:

-having a table for courses to include fields for, date range attended,
comments (memo format), recommendations (memo format) optional contact info
-table for instructors for dropdown menu in the courses
-table(s) for general ratings for dropdown menu in the courses
(knowledgeable, preparedness, speech)
-table for overall rating for dropdown menu in the courses (outstanding,
good, marginal, unsatisfactory) set these with number identifiers to graph
at a later need
-table for date range grouping if you want for dropdown menu in the courses
(could be in the format of like "term 1" or "08-01")

-set queries to filter reports by instructor
-queries can average the overall ratings as well as trend the general
ratings
-you can also trend between classes to see if the instructors are improving
or regressing

-set the reports based on the queries and lay them out accordingly