Entering a grading system

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TSG - 27 Feb 2005 16:57 GMT

I am working on a database to help teachers manage the classroom better
I am now at the point where I want to install a grading system allowin
the teacher to use a form to enter the grade for a test, worksheet, etc
Also on the form will be a combo box to select the student, and a comb
box to select the class(subject) where the grade will count i.e
Reading, Math, etc. The teacher is going to be able view/print
report that will show all grades by subject for a particular studen
and the avg. at that time. Anyway, I am having trouble on exactly ho
I should structure the table where this information will be stored.
know I will have to link it to the student table that has all of th
students' name and address informaiton. Can someone help me with this

--
TSG

Reply to this Message

Duane Hookom - 28 Feb 2005 03:13 GMT

There are a couple "student" related data models on this page
http://www.databaseanswers.org/data_models/index.htm. While the structures
are good, they are only samples. I prefer to always create tables with a
single field primary key. Some sample tables use several field PKs.

Signature

Duane Hookom
MS Access MVP

> I am working on a database to help teachers manage the classroom better.
> I am now at the point where I want to install a grading system allowing
[quoted text clipped - 7 lines]
> know I will have to link it to the student table that has all of the
> students' name and address informaiton. Can someone help me with this?

Reply to this Message

PC Datasheet - 28 Feb 2005 04:18 GMT

Just to let you know that I am available to help you -----

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> I am working on a database to help teachers manage the classroom better.
> I am now at the point where I want to install a grading system allowing
[quoted text clipped - 10 lines]
> --
> TSG

Reply to this Message

Duane Hookom - 28 Feb 2005 04:56 GMT

I think there are lots of us here available to help TSG.
Some of use provide on-line assistance for free. Others like to go fishing
for consulting clients in public news groups.

Signature

Duane Hookom
MS Access MVP

> Just to let you know that I am available to help you -----
>
[quoted text clipped - 18 lines]
>> --
>> TSG

Reply to this Message

Larry Daugherty - 02 Mar 2005 07:31 GMT

Hi,

It would be helpful to have the rest of your schema so that we don't have to
assume and then make suggestions based on those assumptions, etc. Have you
ever parsed a s s u m e ? :-)

With the above risk in mind:

call the new entities (test, worksheet, etc.) Assignments and record them
in tblAssignment.

Would you post back and tell us what all you're tracking in your
application"

Teachers, Students, Subjects Classes/sections <- could get rosters from
that, Assignments ??

HTH

Signature

-Larry-
--

Reply to this Message