We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,991 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

i am making a Student Grading Sytem in 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..

6
Contributors
10
Replies
5 Days
Discussion Span
5 Months Ago
Last Updated
12
Views
pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

You'll have to provide more information and a clearer description of what you are doing.

Reverend Jim
Carpe per diem
Moderator
3,595 posts since Aug 2010
Reputation Points: 561
Solved Threads: 446
Skill Endorsements: 32

Just a thought if the grade calculations were done in the database then it would just be a matter of pulling the relevant fields and poutting them in a report.

tinstaafl
Nearly a Posting Virtuoso
1,318 posts since Jun 2010
Reputation Points: 355
Solved Threads: 227
Skill Endorsements: 14

i think that by the time you insert the marks into the database, the computation of the grades and everything should have already been done on your interface and about retrieving the results, i believe every student should have an id so you have to enter different marks for the different students using that same id so that when you are to retrieve the marks, you have got to use a select*from db where id='somevalue'.

mukiibi
Newbie Poster
3 posts since Nov 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

i have a Marks_Tablein which
Gr_No (int)
Name (varchar)
Class (int)
Division (varchar)
Semester(varchar)
Exam (varchar)
Subject (varchar)
Maximum_Marks (int)
Minimum_Marks (int)
Obtained_Marks (int)
are the columns of my table in the database.
i wanted when user selects or (filter) a particular class ,Division,Exam,Gr_No from the form, it should retrieve all the Subjects and the obtained_marks he got in each subjects on to a form and on that Obtained_marks base i have to calculate the overall grades and give it to the user but i am not getting the logic for it ,how will i get that the exact output. i have tried the crystal report but i didnt got the correct output so now i want to retrieve it on form instead of report. please give some guidance on it

pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

Maybe I'm not understanding your requirements, but if your Gr_No is already an int value; just add up all the int values and divide by the total number of values - that will give you the average value - then just display that value (and/or update your Obtained_Marks field).

john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25
Solved Threads: 22
Skill Endorsements: 3

If you have marks with you can use If else condition

 Dim marks As Integer = 51
        Dim grade As String


        If marks > 50 Then
            grade = "A"
        Else
            grade = "B"
        End If
Dili1234
Junior Poster
118 posts since Aug 2012
Reputation Points: 11
Solved Threads: 4
Skill Endorsements: 2

i can put the if else condition but first i have to retrieve the students marks in each subject from the database and then put then i will put them in if else condition but i dont know how i should retrieve from database

pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0
 myConnection = New SqlConnection(connectionstring)
        myConnection.Open()
dim Marks as Integer
        myCommand = New SqlCommand(" Select columnname FROM tablename Where P_Id='" & ComboBox2.Text & "'", myConnection)
        Dim dr As SqlDataReader = myCommand.ExecuteReader
        While dr.Read()

        marks = Val(dr(0))

            'currentbalance = Double.Parse(dr(2).ToString)

        End While
        dr.Close()
        myConnection.Close()
Dili1234
Junior Poster
118 posts since Aug 2012
Reputation Points: 11
Solved Threads: 4
Skill Endorsements: 2

ya i got but but this will retrieve only the marks of the subjects but i want to retrieve all the subject of the student and its marks on a textbox then i will calculate the grade upon the marks how should i retrieve all subject and their marks

pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

Can you put a picture of how your interface look like

Dili1234
Junior Poster
118 posts since Aug 2012
Reputation Points: 11
Solved Threads: 4
Skill Endorsements: 2

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page rendered in 0.0848 seconds using 2.68MB