PLEASE USE JAVA
Write a program that processes a data file that contains student information. The fields of data stored in the file include last name, first name, student ID, scores from five subjects (Math, Sci, Social Studies, Language arts and Computer science), the total score as a percentage and a letter grade. For allocating the appropriate letter grade refer to the CS211 syllabus page. Creating a data file in the CSV format is recommended. Your records must look like this: ex. Bell Alexander 954221234 90 87 89 95 87 89.6 A (Be nice and round the percentage to the next higher whole number!!!) Your program should be able to sort the data by any of these different columns. Use Comparator interface and implement the various compare methods to achieve this. Hint: You don't really write 10 different comparators here corresponding to the 10 columns. Think of a comparator for each type of data. Files to create: 1. CSV file containing all the data. Create at least 10 students in your database. 2. Comparator classes for implementing different ways of comparing the records and sorting them. 3. Client code that reads from the CSV file, sorts the records based on last name, first name, Student ID, Scores in Math/Sci/LA/SS/CS, percentage grade and also letter grade. 4. The result of all the different sorts must be written out in to a txt file and submitted under the name SortedOutput.txt. Your team must submit all the above files and one person from the team can come present the project during class. Details of teams will be discussed and decided during class. Write a program that processes a data file that contains student information. The fields of data stored in the file include last name, first name, student ID, scores from five subjects (Math, Sci, Social Studies, Language arts and Computer science), the total score as a percentage and a letter grade. For allocating the appropriate letter grade refer to the CS211 syllabus page. Creating a data file in the CSV format is recommended. Your records must look like this: ex. Bell Alexander 954221234 90 87 89 95 87 89.6 A (Be nice and round the percentage to the next higher whole number!!!) Your program should be able to sort the data by any of these different columns. Use Comparator interface and implement the various compare methods to achieve this. Hint: You don't really write 10 different comparators here corresponding to the 10 columns. Think of a comparator for each type of data. Files to create: 1. CSV file containing all the data. Create at least 10 students in your database. 2. Comparator classes for implementing different ways of comparing the records and sorting them. 3. Client code that reads from the CSV file, sorts the records based on last name, first name, Student ID, Scores in Math/Sci/LA/SS/CS, percentage grade and also letter grade. 4. The result of all the different sorts must be written out in to a txt file and submitted under the name SortedOutput.txt. Your team must submit all the above files and one person from the team can come present the project during class. Details of teams will be discussed and decided during class
