1 Reply Latest reply on Oct 4, 2009 5:50 AM by comment_1

    Database set up to calculate student attendance, by minutes, by week



      Database set up to calculate student attendance, by minutes, by week


      Running Filemaker Pro 9. Snow Leopard. 

      Have used Filemaker Pro for 5 years. Many relational databases. Simple Calculations.


      Now I have put together a database for a teacher to track the minutes she sees each student, certain periods, each week. As listed in subject, I have the following fields:


      Student ID, Last, First, Grade, Monday (which represents number of minutes in attendance that day), Mon A (which represents number of minutes absent that day) and it goes through Friday, then the Period, Total Minutes (sums up Monday - Friday attending minutes), total Absent (sums up Monday - Friday absent minutes), Week Days (Sept 24-28, which is the first week of school), Week, Term and Grand Total Minutes.


      I have the total minutes and total absent minutes totaling correctly. What I want to do is have it total the minutes of the first student for week 1, week 2, week 3, week 4 and so on through week 38. I want it to start over for the next student and only tally that student's week.


      Here is what I have in the Grand Total Minutes Calculation, but it only repeats what my Total Minutes are. How can I get it to take the Total minutes of Week 1 and add the total minutes of week 2 in the week 2 field across from the student?


      If (student.stateID="Week 1"; (Monday+Tuesday+Wednesday+Thursday+Friday) ; (Total Minutes)) 


      I have tried various other ones, trying to get it to add week 2, but that just takes and adds week 1 twice. The math calculation escapes me here! I would want it to incorporate every week, beginning in week 1 through week 38. If a student were to attend 51 minutes a day for the entire year and never miss they would have 8772 minutes showing in their week 38. 


      This file will also tie into a Gradebook page that I've set up as a template, for the parent. So, the file has relational data, too, but I'm stuck on the Calculation.


      Hope I have explained it enough. If you need more information, I can send a picture of the fields or database.


      We are getting close to parent-teacher conferences and I'm hoping to have this done.  


      Thanks for any information you can give me.


      Nancy S.