
Originally posted by BrandonT
ThinkDB can do a lot, but it can't perform calculations on a group of records, IE: Grade1*weightingA + grade2*weightingA + grade3*weightingB / RecordNumber = OverAllGrade. It also can't list assignments all in one place while also porting assignements to Datebook, or ToDo.
Hmmm. What version of ThinkDB have you tried? I've got version 2.0.0, build 002. The Gradebook tinybyte I created keeps each student as a record. Each record has a field for each assignment, and for the weighting of each assignment. Although the length of a math equation is limited, using intermediate sums lets you make equations as long as you like. For my exercise 1 which has 5 parts, an equation field looks like this: 1a+1b+1c+1d+1e/5*w1. This adds all exercise scores a thru e, finds the average, then multiples by the weighting value. The class has 4 exercises. My final grade equation looks at the results from each exercise, and calculates the final numeric score. All is kept tidy in seperate views and forms. Basically I can look at each student's grades, or all students' grades, any exercise, or any other filtered group I choose.
Now I'll admit my application is for holding a class worth of grades, and not a single student's. I doubt this would be a challenge, though. Memo and Text fields are available. Date and Time too. Math and Logic equations can be used. There are certainly limits, but nothing a little creativity and compromise can't work around.
ThinkDB could be better. Version 2.0.0 is darned capable already, though. And it's free!
Dave


