Smart Calendar

[Guest]

I am new to this but have learned quite a bit from this forum.
About he database:
1. Records Students Demerits and generates reports of their behavior.
2. Have two tables: Student Table and Demerit Table that are joined one to
many.
3. Have a form that displays information one student at the time with a
sub-form for Demerit entry.
4. Each day has to be entered for each student at leas once. There may be
many demerit entries in one day. But if student is absent , or received zero
demerits, the date has to be entered in order to calculate needed data.
5. Database needs to be set-up every year to reflect school’s calendar year.

About Calendar:

1. Set new calendar each year to reflect school year
Start Date:
End Date:
Schools Days off
2. Calendar needs to have disabled Saturdays, Sundays and school’s Days off
displayed in Yellow
3. The week needs to begin Wednesday and end on Tuesday
4. The calendar should be placed on a Student form but operate dates on
Demerit entry sub form.
5. Calendar should check if date of the week was entered, and display it in
Green (on a calendar) in Red if date was not entered yet. Since all dates
have to be entered no less than once, seeing the Red Dates on a calendar
will prompt the user to make entry for these dates at the end of the week,
before making weekly report on each student.
6. The date box on the sub form, when record is active, should be able to be
populated by pointing to the date, on a calendar, and by mouse-down-action or
click. I am doing my best explain this in English. Enyone…..?
Thanks,
JPol

 

[Guest]

You don't really need a calendar for the full year. You need a table that
contains Non school days that are not Saturdays or Sundays.
Here is a function that will tell you whether the date passed is a school
day using the above calendar.

Public Function IsWorkDay(dtmSomeDay As Date) As Boolean
IsWorkDay = Weekday(dtmSomeDay, vbMonday) < 6
IsWorkDay = IsNull(DLookup("[Holdate]", "Holidays", _
"[Holdate] = #" & dtmSomeDay & "#"))
End Function

Now, one other thing that bothers me. Why is it necessary to enter a record
for a student who had no demerits for a day? If no record exists for that
student for that day, it would be an assumed 0.

 

[Guest]

Reasons are following:

1. Student may be absent value must be null.
2. Student may be absent unexcused value will be max=50
3. To calculate AVE % days present and days unexcused have to be counted.
4. All dates of the week have to be reflected on the weekly report to the
parent, and to the PO, court and judge, including demerit description,
demerit number and percentages.
6. There is also level of compliance calculated according to the weekly
percentage, however this level also depends on attendance. If student only
attends less than specified minimum amount of days in a particular week,
he/she may not advance to the higher level of compliance even if the
percentages were in higher ranges.

I thought that having the “smart calendar†would immediately RED Flagged the
missing days, which are necessary for the whole program to come up with the
correct numbers. In addition I also would look really smart, and had
something to brag about in front of my compadres. Hey, just kidding!
JPol

You don't really need a calendar for the full year. You need a table that
contains Non school days that are not Saturdays or Sundays.
Here is a function that will tell you whether the date passed is a school
day using the above calendar.

Public Function IsWorkDay(dtmSomeDay As Date) As Boolean
IsWorkDay = Weekday(dtmSomeDay, vbMonday) < 6
IsWorkDay = IsNull(DLookup("[Holdate]", "Holidays", _
"[Holdate] = #" & dtmSomeDay & "#"))
End Function

Now, one other thing that bothers me. Why is it necessary to enter a record
for a student who had no demerits for a day? If no record exists for that
student for that day, it would be an assumed 0.

I am new to this but have learned quite a bit from this forum.
About he database:
1. Records Students Demerits and generates reports of their behavior.
2. Have two tables: Student Table and Demerit Table that are joined one to
many.
3. Have a form that displays information one student at the time with a
sub-form for Demerit entry.
4. Each day has to be entered for each student at leas once. There may be
many demerit entries in one day. But if student is absent , or received zero
demerits, the date has to be entered in order to calculate needed data.
5. Database needs to be set-up every year to reflect school’s calendar year.

About Calendar:

1. Set new calendar each year to reflect school year
Start Date:
End Date:
Schools Days off
2. Calendar needs to have disabled Saturdays, Sundays and school’s Days off
displayed in Yellow
3. The week needs to begin Wednesday and end on Tuesday
4. The calendar should be placed on a Student form but operate dates on
Demerit entry sub form.
5. Calendar should check if date of the week was entered, and display it in
Green (on a calendar) in Red if date was not entered yet. Since all dates
have to be entered no less than once, seeing the Red Dates on a calendar
will prompt the user to make entry for these dates at the end of the week,
before making weekly report on each student.
6. The date box on the sub form, when record is active, should be able to be
populated by pointing to the date, on a calendar, and by mouse-down-action or
click. I am doing my best explain this in English. Enyone…..?
Thanks,
JPol

 

[Guest]

All of the reasons you list would, in deed, constitue the need for a record;
however, if a student is present and has no demerits, I still see not need
for a record. If you need to do averaging, you could do your averaging over
a range of dates rather than a number of records.

And, if you minimize the amount of data (disk space) and do some really cool
calculations, your compadres will be in awe

Reasons are following:

1. Student may be absent value must be null.
2. Student may be absent unexcused value will be max=50
3. To calculate AVE % days present and days unexcused have to be counted.
4. All dates of the week have to be reflected on the weekly report to the
parent, and to the PO, court and judge, including demerit description,
demerit number and percentages.
6. There is also level of compliance calculated according to the weekly
percentage, however this level also depends on attendance. If student only
attends less than specified minimum amount of days in a particular week,
he/she may not advance to the higher level of compliance even if the
percentages were in higher ranges.

I thought that having the “smart calendar†would immediately RED Flagged the
missing days, which are necessary for the whole program to come up with the
correct numbers. In addition I also would look really smart, and had
something to brag about in front of my compadres. Hey, just kidding!
JPol

You don't really need a calendar for the full year. You need a table that
contains Non school days that are not Saturdays or Sundays.
Here is a function that will tell you whether the date passed is a school
day using the above calendar.

Public Function IsWorkDay(dtmSomeDay As Date) As Boolean
IsWorkDay = Weekday(dtmSomeDay, vbMonday) < 6
IsWorkDay = IsNull(DLookup("[Holdate]", "Holidays", _
"[Holdate] = #" & dtmSomeDay & "#"))
End Function

Now, one other thing that bothers me. Why is it necessary to enter a record
for a student who had no demerits for a day? If no record exists for that
student for that day, it would be an assumed 0.

I am new to this but have learned quite a bit from this forum.
About he database:
1. Records Students Demerits and generates reports of their behavior.
2. Have two tables: Student Table and Demerit Table that are joined one to
many.
3. Have a form that displays information one student at the time with a
sub-form for Demerit entry.
4. Each day has to be entered for each student at leas once. There may be
many demerit entries in one day. But if student is absent , or received zero
demerits, the date has to be entered in order to calculate needed data.
5. Database needs to be set-up every year to reflect school’s calendar year.

About Calendar:

1. Set new calendar each year to reflect school year
Start Date:
End Date:
Schools Days off
2. Calendar needs to have disabled Saturdays, Sundays and school’s Days off
displayed in Yellow
3. The week needs to begin Wednesday and end on Tuesday
4. The calendar should be placed on a Student form but operate dates on
Demerit entry sub form.
5. Calendar should check if date of the week was entered, and display it in
Green (on a calendar) in Red if date was not entered yet. Since all dates
have to be entered no less than once, seeing the Red Dates on a calendar
will prompt the user to make entry for these dates at the end of the week,
before making weekly report on each student.
6. The date box on the sub form, when record is active, should be able to be
populated by pointing to the date, on a calendar, and by mouse-down-action or
click. I am doing my best explain this in English. Enyone…..?
Thanks,
JPol