Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
i am making a Student Grading System in Vb.net which will store student and teacher information into database, as well as it will store student marks of particular semester and exam. i have done with my storing information part and designing part and now i am doing the grade calculation but i am not getting the logic of how should retrieve all the Subjects and Their marks and on a form of a student and on that base i want to calculate its result i.e o Grade. please reply as soon as possible my project submission date is day after tomorrow..
Posted 18-Nov-12 9:03am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You would get all the marks for that student, and you'd need to know the maximum possible marks. Dividing these gets you a percentage which is generally how a grade is calculated.
 
If your work is due in 2 days, it's a bit late for you to be trying to understand the requirements. We're happy to help, but we don't help faster based on your demands, we're not being paid, so please don't ask us to reply 'as soon as possible', we will, by definition, reply 'when we feel like it'.
  Permalink  
Comments
Pratik65 at 18-Nov-12 15:10pm
   
sorry my mistake...
i am want to say is that i have a marks table in that i save save the students rollno,semester,exam,maximum_marks,minimum_marks,obtained marks..so i want to retrieve all subject of that student and its marks for particular semester and exam and on that basis i want to calculate the grades....is there any guidance i can get with this ?
Christian Graus at 18-Nov-12 15:14pm
   
yes. You have the data, so write the SQL. You know the semester, so ou can filter on it. You know the exam, so you can filter on it. Where is your issue ? If you want us to write the code because you can't even START, then surely you can see that all I can give is vague advice without more info on the DB structure ( not that I am saying I'd do your assignment for you ). You have the data you need, why don't you see how to write the SQL to filter on it ? Do you not know how to write SQL at all ? You can use group by to get a maximum, minimum, average or aggregate mark for each exam, in one SQL call, if you need it.
Pratik65 at 18-Nov-12 15:21pm
   
yes i have filtered the semester and exams but i an not getting the logic of ,how i should retrieve all the subjects and their Obtained_marks From the marks table of particular student from the semester and exam selected into a form ....dont do my homework but can u please help me explain in a easy way please..
Christian Graus at 18-Nov-12 15:40pm
   
If you want all the marks a student got, filter on the student and the subject, but not the exam. Change what you filter out, and the rest will give a return of all results.
ridoy at 18-Nov-12 15:44pm
   
+5
Pratik65 at 19-Nov-12 8:25am
   
but without filtering the exams ,we will not get of which exams this marks is.
So i have to filter the subject ,exams and marks in that subject in that exam
can u give me some link or idea from which i can solve this part

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 _Amy 310
1 OriginalGriff 294
2 Nirav Prabtani 268
3 Sergey Alexandrovich Kryukov 211
4 CHill60 150
0 OriginalGriff 7,889
1 Sergey Alexandrovich Kryukov 7,006
2 Maciej Los 4,014
3 Peter Leow 3,708
4 CHill60 2,762


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 18 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100