From a database design point of view, using a set of related records for your scores all linked by studentID to a student record would make more sense and then you have the option of using summary fields and aggregate functions to get your average.
Thanks. I'm new at this, so I think I need some more specific guidance. It sounds like you're recommending two tables: in table 1, the two Number fields Student ID and Student Name; and in table 2, the fields Student ID (a lookup of some kind?) and then maybe something like the table below? But I'm not sure what to do next.
Student ID Test 1 Score Test 2 Score Test 3 Score Test 1 Weight Test 2 Weight Test 3 Weight Weighted Avg.
1 76 83 87 30 100 100 ???
2 89 93 90 30 100 100 ???
That's not it.
Your additional table would have just 4 fields:
Weighted Average Summary Field (there's an option for a summary field that computes weighted averages)
A portal to this new table can be placed on your student layout to list these scores vertically. To list them horizontally is also possible by setting up a series of one row portals, each with a different initial row specified--producing a so called "horizontal portal".