creating GPA for each student in a report.

G

Guest

I am trying to create a report that shows each student with their grade from each class (A,B+, etc) and their GPA. I am at a small school, (100 students, each taking the same 7 classes). I have a) student info table - name and ID number, b) a table that show each grade- based on student ID, but including year, semster, 6 weeks, subject, and c) a grade point table to convert the letter into a number
I have a crosstab query that shows each student with their grade from each class for a grading period. I would like my report to also include the GPA for that grading period. I have done some computer programming, but do not want to mess with macros, etc.
Do I need to create a query that shows each grade and then link the grade point table to also show the numeric grade equivalent. And then create a second crosstab query, this time using the numeric values and include average for total
My report would then use the first crosstab query, and add on the last field from my second crosstab

I thought about using my first crosstab query to create a simple query and then 'link' each grade to the numeric equivalent, and then creating a textbox in the report to average the invisible number grades. BUT I didn't think I could link my letter grades in my 3rd table to several fields in simple query
Any help/advice would be greatly appreciated
 
J

Jennifer H

You can actually create that GPA average as a RowHeading
in the first crosstab query. Use the Average as the total
function, but select RowHeading for it instead of Value.
j.
-----Original Message-----
I am trying to create a report that shows each student
with their grade from each class (A,B+, etc) and their
GPA. I am at a small school, (100 students, each taking
the same 7 classes). I have a) student info table - name
and ID number, b) a table that show each grade- based on
student ID, but including year, semster, 6 weeks,
subject, and c) a grade point table to convert the letter
into a number.
I have a crosstab query that shows each student with
their grade from each class for a grading period. I
would like my report to also include the GPA for that
grading period. I have done some computer programming,
but do not want to mess with macros, etc.
Do I need to create a query that shows each grade and
then link the grade point table to also show the numeric
grade equivalent. And then create a second crosstab
query, this time using the numeric values and include
average for total.
My report would then use the first crosstab query, and
add on the last field from my second crosstab.
I thought about using my first crosstab query to create
a simple query and then 'link' each grade to the numeric
equivalent, and then creating a textbox in the report to
average the invisible number grades. BUT I didn't think
I could link my letter grades in my 3rd table to several
fields in simple query.
 

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

Top