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
AssignmentStartDate
AssignmentPointsPossible
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.
JTBLASSIGNMENTGRADES
AssignmentGradesID
AssignmentID
StudentID
AssignmentPointsEarned
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