(Solved) : 3 Create Program Solves Following Problem Professor Z Keeps Track Students Excel Spreadshe Q37177222 . . .
PLEASE HELP FAST AND RIGHT IN JAVA. THANK YOU
We were unable to transcribe this image3) Create a program that solves the following problem: Professor Z keeps track of his students in an excel spreadsheet (see file called Students.csv). It contains the student name, class number, class name and final grade in that class. He wants to create a program that allows him to do the following: i. Type in a student’s name and print out all information associated with that student (class number, class name and final grade) to screen. ii. Type in a class name and output a file with the names of all students that took the class. iii. Type in a class name or class number and get back the overall average grade of all students that took that class (printed to screen) iv. Exit the program. Feel free to create any additional methods or classes to help you code. You must use the FileHandle class created to deal with files. Don’t forget to put the file Students.csv in the project folder when testing your program-DO NOT HARDCODE any information from the file as we will be usingmultple fles to test your code. No sample run. You may find it helpful to look at past class code to get an idea of how to lay out this program Table 1 1310 Java 1325 Advanced Java 90 1310 Java 1320 C 1325 Advanced Java 70 1325 Advanced Java 83 Jon Ravi Jane Sarah Bob Julia Fredrick 1325 Advanced Java 90 Jean Luc 1325 Advanced Java 100 Sarah-Lee 1320 C Motaz Krystal 1320 C Ayman Salem 80 1320 C 73 71 65 82 1310 Java 1310 Java Show transcribed image text
3) Create a program that solves the following problem: Professor Z keeps track of his students in an excel spreadsheet (see file called Students.csv). It contains the student name, class number, class name and final grade in that class. He wants to create a program that allows him to do the following: i. Type in a student’s name and print out all information associated with that student (class number, class name and final grade) to screen. ii. Type in a class name and output a file with the names of all students that took the class. iii. Type in a class name or class number and get back the overall average grade of all students that took that class (printed to screen) iv. Exit the program. Feel free to create any additional methods or classes to help you code. You must use the FileHandle class created to deal with files. Don’t forget to put the file Students.csv in the project folder when testing your program-DO NOT HARDCODE any information from the file as we will be usingmultple fles to test your code. No sample run. You may find it helpful to look at past class code to get an idea of how to lay out this program
Table 1 1310 Java 1325 Advanced Java 90 1310 Java 1320 C 1325 Advanced Java 70 1325 Advanced Java 83 Jon Ravi Jane Sarah Bob Julia Fredrick 1325 Advanced Java 90 Jean Luc 1325 Advanced Java 100 Sarah-Lee 1320 C Motaz Krystal 1320 C Ayman Salem 80 1320 C 73 71 65 82 1310 Java 1310 Java
Expert Answer
Answer to 3) Create a program that solves the following problem: Professor Z keeps track of his students in an excel spreadsheet (…
OR