469,273 Members | 1,794 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,273 developers. It's quick & easy.

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

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

Jun 19 '07 #1
0 1881

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sallyk07 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.