Question: Need help with coding in visual basic You are to write a program to process student grades. Each student takes four courses: Math, CS ,

Need help with coding in visual basic
You are to write a program to process student grades. Each student takes four courses: Math, CS, English, Business. The data are stored in a file (exam.txt), where the first line contains the subject of four courses, followed by each line consisting of the name of student (First Name, Last Name), student ID, which is 9 digit string, and the scores of four courses that each student is taking.
The input file contains the following data:
Math, CS, English, Business
Jon, Benson,123456789,90,80,70,80
Brian, Gause,100000001,88,77,66,99
Ron, Heath,204568762,77,66,88,93
June, King,332549873,80,91,77,75
Luke, Savon,100045423,68,87,81,91
Tom, McClure,286453218,77,88,60,90
Matt, Liskov,438763298,43,68,70,63
Matthew, Moses,550550005,69,59,88,81
Justin, York,432876489,93,86,73,55
Show the whole data in a tabular format like this in a list box.
\table[[First,Last,ID,Math,CS,English],[Business,,,,,,],[Jon,Benson,123456789,90,80,70,80],[Brian,Gause,100000001,88,77,66,99],[Ron,Heath,204568762,77,66,88,93],[June,King,332549873,80,91,77,75],[Luke,Savon,100045423,68,87,81,91],[Tom,McClure,286453218,77,88,60,90],[Matt,Liskov,438763298,43,68,70,63],[Matthew,Moses,550550005,69,59,88,81],[Justin,York,432876489,93,86,73,55]]
Show the course average for each course. There should be one decimal digit.
\table[[Course average,],[Math:,76.1],[CS:,78.0],[English:,74.8],[Business:,80.8]]
Show the number of students failed in each course (the scores less than 70).
Number of failed students in each course
Math: 3
CS: 3
English: 2
Business: 2
Show the name and score of the highest score for each course. If there are the same highest scores, show them all.
Highest score
Math: Justin York (93)
CS: June King (91)
English: Ron Heath, Mattew Moses
(88)
scores less than 70).
Number of failed students in each course
Math: 3
CS: 3
English: 2
Business: 2
4. Show the name and score of the highest score for each course. If there are the same highest scores, show them all.
Highest score
Math: Justin York (93)
CS: June King (91)
English: Ron Heath, Mattew Moses (88)
Business: Brian Gause (99)
5. Show the data sorted by student's last name:
[[First,Last,ID,Math,CS,English,Business]
,[Jon,Benson,123456789,90,80,70,80]
[Brian,Gause,100000001,88,77,66,99],
[Ron,Heath,204568762,77,66,88,93],
[June,King,332549873,80,91,77,75]
[Matt,Liskov,438763298,43,68,70,63],
[Tom,McClure,286453218,77,88,60,90],
[Matthew,Moses,550550005,69,59,88,81],
[Luke,Savon,100045423,68,87,81,91],
[Justin,York,432876489,93,86,73,55]]
Search for student's last name and show the student name, ID, each score and its grade, and the overall grade.
90100 is for A,8089 is for B,7079 is for C,6069 is for D , and 059 is for F . For example, it the search was done for King, the output should look like this:The overall grade can be obtained with the following formula for June King: (3+4+2+2)//4=11//4=2.75. Show two decimal digits after the decimal digit for the grade.7.
(Bonus: 10 pts ) Use the following input data to show the output for the same tasks as in #1 #6.History, Biology, English, Business, CS Ron, Heath, 204568762,77,66,88,93,75June, King,332549873,80,91,77,75,55Jon, Benson,123456789,90,80,70,80,80Tom, McClure,286453218,77,88,60,90,66Matt, Liskov,438763298,43,68,70,63,49Matthew, Moses,550550005,69,59,88,81,88Justin, York,432876489,93,86,73,55,81
Need help with coding in visual basic You are to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!