Best way to Enter and Calculate Student Scores in a Gradebook Form

[Racqetsports]

Hi there,

In a gradebook database, student grades must be computed from 2
scores: a Daily grade, and then scores from Assignments. Knowing about
nested forms, I am requesting direction on how to set up this
particular case of form and subforms. Currently, there are 5 tables:

STUDENTS
StudentID
StudentLName
StudentFname
etc.

ASSIGNMENTS
AssignmentID
AssignmentName
AssignmentStart Date
AssignmentPoint sPossible
etc.

COURSES
CoursesID
StaffID
ClassTimeID
QuarterID
etc.

JTBLDAILYGRADES
DailyGradeID
StudentID
Date
Behavior (0 to 4 points/day)
Performance (0 to 4 points/day)
Attendance (0 to 4 points/day)
etc.

JTBLASSIGNMENTG RADES
AssignmentGrade sID
AssignmentID
StudentID
AssignmentPoint sEarned
etc.

What would be preferable is if a form could be set up like this:

Course and staff teacher (in the heading)

Students listbox or continuous subform
(all students in a class should be shown in a list on the left for
ease of use)

DailyGrades subform
(data entered every day)
(if a student has an unexcused absence, his/her Attendence = 0,
Behavior = 0, and Performance = 0; if a student is perfect in a day,
then Attendence = 4, Behavior = 4, Performance = 4)

Assignments subform
(data not entered every day)
(all students could be given the same assignment, and a student could
be given an assignment separate from the other studens)

Cumulative % and letter grade subform or control
(this would update as DailyGrades and Assignment scores are entered)
(it would be preferable to show this on the same form instead of in a
report or query).

The percent total from the Assignments could be 30 or 40% of the total
grade, and the percent total from the DailyGrades could be weighted 60
or 70%. I plan to build in a mechanism for changing the weights.

I would prefer not to use a tab control to toggle between Assignment
and DailyGrade data.

Is such a data entry form possible?

Thanks for any and all assistance.

Tracy