How to track monthly enrollment

Four teacher's aides and I provide Basic Skills Instruction in Reading,
Language and Math to over 100 K to 6 children in the BSI program. The BSI
program is funded by government grants and as such is burden by monthly
reporting of how many children are in the proram each month. At any time
during the school year, a child may be added to the program in one or more
areas, dropped from one or more areas and agained added to one or more
areas. I need advice on how to set up database tables to know each month who
the students are in each of the instructional programs. I have the Students
table with StudentID, Teacher table with TeacherID and InstructionalProgram
table with InstructionalProgramID. Is this the way to record students in
each program on a monthly basis:
TblStudentEnrolledInBSI
SchoolYear
SchoolMonth
InstructionalProgramID
StudentID
and at the beginning of each month, enter a new record for each student who
is still enrolled?

Thanks!

Alison

Hi, Alison,

Because you are dealing with a many to many relationship
for many students with many instructional programs, you
will need another table. Let's call
it "tblActualEnrollment". All you need in this table is
the StudentID field, the InstructionalProgramID and if
desired two date fields, one that is the EnrolledDate
field and the other is the DroppedDate field.

You can then just add a record to this table for each
Instructional Program in which the student is enrolled.
when the student is dropped, you simply update the record
for that Instructional Program for the specific student.

You could do this through the use of a couple of multi-
select list boxes showing the list of Instructional
Programs. Then after the user has selected Instructonal
programs to be added or droped for a student, you simply
process all selected items from the list, adding or
dropping records as needed.

HTH

Byron
-----Original Message-----
Four teacher's aides and I provide Basic Skills
Instruction in Reading,
Language and Math to over 100 K to 6 children in the BSI
program. The BSI
program is funded by government grants and as such is
burden by monthly
reporting of how many children are in the proram each
month. At any time
during the school year, a child may be added to the
program in one or more
areas, dropped from one or more areas and agained added
to one or more
areas. I need advice on how to set up database tables to
know each month who
the students are in each of the instructional programs.
I have the Students
table with StudentID, Teacher table with TeacherID and
InstructionalProgram
table with InstructionalProgramID. Is this the way to
record students in
each program on a monthly basis:
TblStudentEnrolledInBSI
SchoolYear
SchoolMonth
InstructionalProgramID
StudentID
and at the beginning of each month, enter a new record
for each student who
is still enrolled?

Thanks!

Alison



.

"Alison" wrote in message link.net...
Four teacher's aides and I provide Basic Skills Instruction in Reading,
Language and Math to over 100 K to 6 children in the BSI program. The BSI
program is funded by government grants and as such is burden by monthly
reporting of how many children are in the proram each month. At any time
during the school year, a child may be added to the program in one or more
areas, dropped from one or more areas and agained added to one or more
areas. I need advice on how to set up database tables to know each month who
the students are in each of the instructional programs. I have the Students
table with StudentID, Teacher table with TeacherID and InstructionalProgram
table with InstructionalProgramID. Is this the way to record students in
each program on a monthly basis:
TblStudentEnrolledInBSI
SchoolYear
SchoolMonth
InstructionalProgramID
StudentID
and at the beginning of each month, enter a new record for each student who
is still enrolled?

Thanks!

Alison

Since each student can be added to multiple programs multiple times per year...

StudentID
EntryDate
ExitDate
ProgramID

Then you can do math on the dates to find out who is enrolled when.