Hello there, I have a homework question. If someone could help me, I will be really grateful. Thank you.

- Program specification:
Design and implement a program for a school marks examination system.


- Details:
You can download a file containing the following:
• Student’s ID number
• Subject name
• Mark for that subject

Assume the following:
• The student ID can begin with a zero, and should therefore be read in as a string.
• The test data will contain 20 students but the program should be able to deal with up to 100 students.
• Assume there are no more than 4 different subjects.


Your program should read in the file and print out the following. No other user input is required.
(a) A table containing 1 row per student, containing the student ID number and all of the student’s marks
(b) Another table, containing 1 row per student, containing the student ID number and the average mark obtained by that student
(c) The average mark for each subject.

You cut and pasted your assignment... but forgot to cut and paste your answers, as are required by the rules of this site. We have people who will help you, but you are required to show your work and/or answers first BEFORE anyone will.

Gosh, that would be easy if you do a little research. We teach problem solving like this in elementary school. Please take the time to do your own work. Post your answer and someone will check it.

Use Excel to set-up a spreadsheet for this type of problem.

Ok. Thank you for your feedbacks. Its just that I just got this homework and I needed some highlights how to work it, like a brainstorming. But thanks anyway.