DATA CONVERSION???

C

ChrisBruell

Hi all!! I work at a university and am in the middle of creating a db with
reports. I'm wondering if there is a way to enter grades as letters and then
attach numerical values to them so as to calculate a GPA on a report.
Thanks!!
 
D

Douglas J Steele

Easiest way is to create a table that lists all of the possible letter
grades and the numeric equivalent. Create a query that joins that table to
the table that contains the marks, and you'll have both available for each
student.
 
C

ChrisBruell

Thanks for your quick response Doug. One follow up question, however...

so I have my table : PhD status with SSN, course taken, course professor,
and course letter grade for about 10 courses. and then I have my separate
table Grade Values that has two columns - 1 letter grades the next the grade
value. how do I join the two tables? do I join each "course grade" to the
letter grade? and then how do I get a specific value for each course. make
any sense? probably not, especially on a friday afternoon
 
D

Douglas J Steele

Oops. Sounds like your table isn't normalized if you have 10 course grades
in a row.

You should have 3 tables: one for the students, one for the courses they've
taken and the separate grade value table. The courses table would have 1 row
for each course, rather than 1 column in the previous table.

Once you've got that kind of set up, it's pretty simple to join the tables.
 
Top