By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

How to track monthly enrollment

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Alison" <an****@earthlink.net> wrote in message news:<UR*****************@newsread2.news.atl.earth 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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.