Create Classes Each Quarter and Calculate the GPA

M

MRMKJason

Joined
Oct 11, 2006
Messages
3
Reaction score
0
I have two things I am trying to do: First, I want to create a database of each class a student took, with their grade and units. Secondly, I want to be able to calculate their GPA for all quarters they took.

How many tables do I need to create?
 
I created a table with ID, Student ID, Class, Quarter, Class Units, and Grade Points. There will be similiar student ID's, but the ID will be different with each entry. Therefore, how do I calculate the GPA of all of the classes of a single student?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking GPA 6
Calculating GPA from our grade scale 2
calculating cumulative GPA 1
averaging a column of letter grades into a numeric GPA 3
Changing GPA to Ltr Grade 8
Importing and modifying exisiting primary key data 3
Multiple Query Calculatiions 0
Calculating GPAs in Access 8

Back
Top