-
Grading Scores
Hallo all,
I wish to request for help regarding how to analyse student marks to generate grades from the database. i have the following records that hav captured from the school.
[IMG]\\10.10.10.1\Fine-Xtreme\Member Passports\photos stll\class datasheet.jpg[/IMG]
from the image attached, a student will apear several times cox there three exams per semester. e.g. if peter is in class 4 term 2, then he will have results for exam 1, exam 2 and final exam for this semester. how can i analyse this data so as i have all the three exam results added to give me one score for the term for a specific subject.
please help.
-
1 Attachment(s)
Re: Grading Scores
Hallo all,
I wish to request for help regarding how to analyse student marks to generate grades from the database. i have the following records that hav captured from the school.
sorry, didnt attach the picture, this reply has it.
from the image attached, a student will apear several times cox there three exams per semester. e.g. if peter is in class 4 term 2, then he will have results for exam 1, exam 2 and final exam for this semester. how can i analyse this data so as i have all the three exam results added to give me one score for the term for a specific subject.
please help.
depash is offline Reply With Quote
-
Re: Grading Scores
I think this question should likely be in the " Database Development Section". As far as your question is concerned, i recommend you to go through " Normalization". ( If you are trying to develop a database )
Or else you need to do the analysis manually for the given set of data.
-
Re: Grading Scores
Here is an article from the Database Development FAQ which, explains what database normalization is.
-
Re: Grading Scores
Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums) (thanks for reporting it to us Nightwalker83 :thumb: )
Normalization would be a good idea, but I don't think it is actually necessary to get what you want.
It would also be a good idea to rename your fields to remove spaces, as they cause various problems, and those problems cannot always be solved in a reasonable way.
To get summary data use a Group By, which in this case would be something like:
Code:
SELECT [Student Name], Subject, Term, Sum(Score)
FROM TableName
GROUP BY [Student Name], Subject, Term
-
Re: Grading Scores
I would add Sch Year to the select list and Group by list that SI showed you also.
-
Re: Grading Scores
@depash
I worried about whether you are using a programming language(like vb6) or directly trying to manipulate the database or you just need an idea for "how to analyse student marks to generate grades".