How to track monthly enrollment

  • Thread starter Thread starter Alison
  • Start date Start date
A

Alison

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
 
Alison said:
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
Click to expand...

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.
 
Back
Top