Assignment

Using the java language

Create a program that can read, parse, and analyze student grade data.

Your program shall prompt the user for the name of a file to read, e.g. grades.csv.

Your program shall check if the file exists and is available to read.

If not, it should handle that gracefully and prompt the user for a different file.

The format of the file is - file distributed with this description.

Process the input file (details below).

Create an output file of the report, thus persisting the execution of the program.

Filtering data

If a score exists in the file that is not between 0 and 100, discard all data for that student.

If a student is excluded by the above rule, they should not be part of the summary data for the class.

Your program shall prompt the user to enter in the level of granularity of the output. Thus, if the user enters "10", the final histogram should be grouped into 10 bins (0<= SCORE < 10, 10 <= SCORE < 20, ..., 90 <= SCORE <= 100).

Output

The output consists of three main parts and shall be stored in a file whose name specified by the user:

Student rows in the input that contain invalid data (score not between 0 and 100) shall print a notice stating "Invalid score of -12 for Dave Thomas", where "-12" is the offending datum and "Dave Thomas" is the student's name.

You can assume that the data will be integers. No handling of type errors is required.

Students with valid data should call a toString() function which outputs their name, average for the course, and whether or not they passed. If they would have passed if not for scholarship requirements, state that as well.

A histogram (Links to an external site.)Links to an external site. of the student data partitioned into the number of bins defined by the user.

Sample input

The first line in the input file is a header row. All subsequent lines contain student data and scores.

Project_4.csv

Student,Scholarship requirement,,,,,,,,,,,

Caron Devers,75,89,91,99,94,89,88,96,95,92,91,91

Kylie Whitham,,74,78,81,76,70,76,74,68,81,72,70

Tami Davenport,90,84,82,88,83,80,95,90,81,89,83,80

In Desilets,,77,66,54,51,110,69,53,69,54,71,65

Roma Skelton,,68,69,76,65,67,65,77,71,75,66,66

Diana Barletta,,96,92,97,94,96,98,98,92,100,99,90

Debroah Darrell,,53,57,51,41,51,46,46,40,55,54,45

Marcelina Mccain,,97,91,91,93,98,88,99,91,95,92,95

Shirely Gisi,70,72,85,80,83,84,81,72,84,73,76,80

Monique Montesdeoca,90,81,84,92,79,81,76,85,81,83,86,83

Shana Harrill,,77,76,-3,80,75,77,79,62,55,75,63

Luigi Botello,,63,70,70,68,74,76,70,63,64,64,64

Heidy Filippi,80,87,91,88,99,98,89,93,93,91,93,94

Nadine Broadnax,,43,42,42,56,39,4,18,50,20,10,24

Olen Brand,85,95,93,97,86,88,84,85,87,84,100,95

Nancee Farnsworth,,71,69,75,70,68,83,78,74,70,84,72

Valentine Lamontagne,,87,89,86,86,86,86,85,91,94,85,85

Sherley Slinkard,,76,76,77,78,80,69,79,77,78,76,73

Lovie Peppler,,68,65,58,57,62,67,58,75,64,71,72

Carlota Peltz,70,81,78,75,86,72,66,77,79,83,83,76

Professor Fancy-Pants,100,100,100,100,100,100,100,100,100,100,100,100

Sample output

Assuming the user entered output.txt when prompted for an output file, here is what the results should be when run against the given:

output.txt

Caron Devers has a course average of 92 - PASS Kylie Whitham has a course average of 74 - PASS Tami Davenport has a course average of 85 - FAIL due to not meeting scholarship minimum of 90 Invalid score of 110 for In Desilets Roma Skelton has a course average of 69 - PASS Diana Barletta has a course average of 95 - PASS Debroah Darrell has a course average of 49 - FAIL Marcelina Mccain has a course average of 93 - PASS Shirely Gisi has a course average of 79 - PASS Monique Montesdeoca has a course average of 82 - FAIL due to not meeting scholarship minimum of 90 Invalid score of -3 for Shana Harrill Luigi Botello has a course average of 67 - PASS Heidy Filippi has a course average of 92 - PASS Nadine Broadnax has a course average of 31 - FAIL Olen Brand has a course average of 90 - PASS Nancee Farnsworth has a course average of 74 - PASS Valentine Lamontagne has a course average of 87 - PASS Sherley Slinkard has a course average of 76 - PASS Lovie Peppler has a course average of 65 - PASS Carlota Peltz has a course average of 77 - PASS Professor Fancy-Pants has a course average of 100 - PASS * * * * * * * * * * * * * * * * * * * 0 10 20 30 40 50 60 70 80 90 100