DATA CONVERSION???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
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
 
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.
 
Back
Top