Question: NOTE: You need to submit a working Java Program. You need to work as a group ( 3 - 4 members ) on this project.

NOTE: You need to submit a working Java Program. You need to work as a group (3-4 members) on this project. The instructor will ask you to explain your code to ascertain plagiarism.
Q: You have been provided with a CSV file CCES_Schedule.csv. The file contains all course sections offered in CCES in this semester along with their enrollment and instructor details.
You need to write a Java program that would summarize and print on the screen:
- For each course:
o How many sections are offered?
o Number of students in largest section
o Number of students in smallest section
o Avg. section size
o The names of all the instructors teaching the course
- For each instructor:
o Total number of assigned sections
o Total number of students in all assigned sections
o No of different courses taught by the instructor
You need to use only Java arrays or ArrayList data structures for this assignment. The following code can be used to read the given file line by line and get each comma separated term.
File inputFile = new File(filename);
Scanner scan = new Scanner(inputFile);
while (scan.hasNextLine())
{
String line = scan.nextLine();
String[] words = line.split(",");
for (String word: words){
// You will get each comma separated term here
}
}

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 Databases Questions!