swpowe Posted October 7, 2006 Posted October 7, 2006 I'm trying to use FMP to track class/student attendance. I've got my classes and students setup and what I'd like to do is be able to enter in who attendend what class and then run a report saying average attendance is...I'd also like to run a simiilar report sayind "john smith attendended an average of ..." make sense? Anyone know how to do this? I'm trying to use a check box for a simple check meaning "yes" and unchecked for "no" on attendance. Thanks for all the help!
Lee Smith Posted October 7, 2006 Posted October 7, 2006 'm not sure where to even post this...I'm looking for some type of templete to track student attence and then run reports based on class and students. Any ideas? Thanks. I couldn't merge your topics, so I'm quoting the one that I deleted as being a Duplicate Post. There have been discussions about this topic in the past, and I believe there are a couple of sample or help files posted. Do a search of the Forum using [color:blue]+Attendence +Record or [color:blue] +Absence +Record as keywords, and you should get a few hits. To access the Search, click on the Search [color:blue]Button in the Menu Bar, and then Click on the [color:blue]Advance Search. There is a [color:red]? located by Mode that gives you some helpful information on do in Searches. HTH Lee
Fenton Posted October 7, 2006 Posted October 7, 2006 If you want a checkbox for "yes" or "no", that implies a record for every student, for every one of their classes, for every day. So it becomes a matter of writing a script to create all those records at the appropriate time. And probably a script and button for the teacher to say "yes to all" for a day (then uncheck absent students). Unless you want them to check off each. Then your reports are fairly straightforward, though there are a lot of records. It's a matter of Summary fields and Subsummary parts An alternative method is to assume all students attend all their classes, and only create records for absentees. Far fewer records. But a bit more work to do reports. Personally I'd go for the 1st method, with archiving of older records, to keep the size down. But others may prefer the latter method, with fewer records. In reality I've not done a school solution myself, so my opinion is just my opinion.
Recommended Posts
This topic is 6683 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now