Newbies kcdot Posted January 13, 2003 Newbies Posted January 13, 2003 I have a db with different classes different assignments listed, including the weight of the grade for each assignment. I have another db for specific students with a portal wherein, upon selection of the class title, the assignments related to the class fill in, as well as the related grade weight. NOW, I need to enter scores for each assignment in this student database and then calculate the appropriate grade based on the weight. I am lining fields up by the appropriate portal row, but I cannot seem to access lines or rows or fields in this portal to perform my calculations. Is there a way to do this? or am I going about this all wrong? Thanks for any suggestions! K.C murphy
Ugo DI LUCA Posted January 13, 2003 Posted January 13, 2003 I am lining fields up by the appropriate portal row, but I cannot seem to access lines or rows or fields in this portal to perform my calculations. Can you tell me more. I don't understand. Can you go into the portal or not ?
jasonwood Posted January 13, 2003 Posted January 13, 2003 I don't really understand the question, but I can explain how I would set this up... 3 databases: Students, Assignments, Marks Students database contains fields for StudentName, StudentID, etc. Assignments database contains AssignmentID, TotalAssignmentMarks and AssignmentWeight, etc. Marks database displays as a portal in both Students and Assignments (so you can enter/view data by student or by assignment), and contains fields like... studentID - (so you know what student the mark is for), assignmentID - (so you know what assignment the mark is for), studentMark - (how many marks they got), totalAssignmentMarks - (total marks for assignment - lookup from Assignments db), assignmentWeight - (what it's worth - lookup), assignmentWeightedGrade - (= studentMark/totalAssignmentMarks * assignmentWeight) ...this last field calculates what the grade is worth in the grand scheme of things, and will only work properly if you have set the "assignmentWeight" field so that all assignments will add up to 1. If this is not the case, you'd need yet another field which calculates the REALAssignmentWeight by taking the assignmentWeight and dividing it by the sum of the weight of all assignments (so you end up with the weight as a percentage). To calculate a mark for a student: In the students database, have a calculation field and set it up like this: Sum (Marks::assignmentWeight) Hope I didn't confuse you more!
Newbies kcdot Posted January 15, 2003 Author Newbies Posted January 15, 2003 Thank you so much for your in-depth reply! Here's the thing. What you have outlined is what most databases do that I have found for storing grades. The problem is, I have a college with a 14 month program where a group of students starts in "Modeling 1" and then moves on the "Modeling 2", etc. The students are in 2 classes per month - one that meets T/TH and one that meets MWF. Each class has pretty much the same assignments every time it repeats (with a new group of students every other month). So I need a link between the assignments and the class title. And, really, I don't need to store student info in this database - that's kept elsewhere in the College. So really, I just need a list of students I can assign to a class for a month, have the relevant assignments fill in on thier "page" when i select the appropriate class title, and fill in scores for them. i have a portal in the "students" database wherein the assignment and the grade weight for each assignment fills in (relative to the class title selected), but I need to then ENTER the grades in the "Student" database. So how do I get at the info that has filled into the portal row to calculate the grade using the score (entered in the Student database) plus the weight (brought into the portal from the Assignmetns databse)? Any ideas? I don't need to select it, and that seems to be the only tools I can find "getPortalRow" and the like. I am lost! k.C.
Ugo DI LUCA Posted January 15, 2003 Posted January 15, 2003 I'm sorry but what are exactly the files you already have. It seems to me if the info are filled in a portal from student.db, linked to Assignment.db, you surely use a "line item file" that have both student name and Assignment in it to create the relationship. As I am not so familiar with your School Program (grades,...), I do not understand all of your post, but it seems to me one file is missing (may be Grades or something) in which you could enter the records. Please forgive me if I did not understand your question...
Recommended Posts
This topic is 7985 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