When submitting this lab, submit a java file called Student TestScores, and create the following structure in Eclipse: Package Name: week 10 Class Name: Student TestScores Some problems require data from a file be loaded into memory but processed later. To simulate this scenario, write a program that uses the Scanner to open a file and read each line, storing the data into a multi-dimensional array. In this assignment, you will read in all the data from the Student Test Grades.csv file and store it in a multi-dimensional array. Then you will display the data to the console in the form of letter grades as shown in the example run. • Create an ArrayList of String arrays: ArrayList class Roster = new ArrayList(); • Read each row of the "Student Test Grades.csv" file into your program as Strings using while(file.hasNext()) • Convert each read-in String to a String[] array using the String.split(".") method Add the String[] array to the classRoster ArrayList . . When you have finished loading all the data into the ArrayList, close the file. Now it's time to loop through the classRoster ArrayList and display the data while converting the numeric scores into letter grades. • Loop through all the elements of the classRoster ArrayList To help with readability, temporarily store each element in the classRoster ArrayList in a variable you can easily access. .

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%
Please may you assist me with this question in Java language
When submitting this lab, submit a java file called Student TestScores, and create the following structure in
Eclipse:
Some problems require data from a file be loaded into memory but processed later. To simulate this
scenario, write a program that uses the Scanner to open a file and read each line, storing the data into a
multi-dimensional array. In this assignment, you will read in all the data from the Student Test Grades.csv
file and store it in a multi-dimensional array. Then you will display the data to the console in the form of
letter grades as shown in the example run.
Package Name: week 10
o Class Name: Student TestScores
• Create an ArrayList of String arrays:
ArrayList<String[]> class Roster = new ArrayList<String[]>();
• Read each row of the "Student Test Grades.csv" file into your program as Strings
.
using while(file.hasNext())
Convert each read-in String to a String[] array using the String.split(",") method
•
• Add the String[] array to the classRoster ArrayList
•
When you have finished loading all the data into the ArrayList, close the file.
Now it's time to loop through the classRoster ArrayList and display the data while converting the numeric
scores into letter grades.
•
•
.
Loop through all the elements of the class Roster ArrayList
To help with readability, temporarily store each element in the classRoster ArrayList in a
variable you can easily access.
Example:
for(int i = 0; i < classRoster.size(); i++)
String[] student = classRoster.get(i)
Remember: The first element in the classRoster ArrayList is not a student. It is the header for
the table and should be displayed differently as shown in the example run.
Loop through each element of the student String[] array and convert the numeric value into a
letter grade as shown in the table below.
Remember: The first element in the student String[] array is the student's name and should be
printed before you start the for loop to process the grades.
The following table breaks down test score percentages to letter grades:
Transcribed Image Text:When submitting this lab, submit a java file called Student TestScores, and create the following structure in Eclipse: Some problems require data from a file be loaded into memory but processed later. To simulate this scenario, write a program that uses the Scanner to open a file and read each line, storing the data into a multi-dimensional array. In this assignment, you will read in all the data from the Student Test Grades.csv file and store it in a multi-dimensional array. Then you will display the data to the console in the form of letter grades as shown in the example run. Package Name: week 10 o Class Name: Student TestScores • Create an ArrayList of String arrays: ArrayList<String[]> class Roster = new ArrayList<String[]>(); • Read each row of the "Student Test Grades.csv" file into your program as Strings . using while(file.hasNext()) Convert each read-in String to a String[] array using the String.split(",") method • • Add the String[] array to the classRoster ArrayList • When you have finished loading all the data into the ArrayList, close the file. Now it's time to loop through the classRoster ArrayList and display the data while converting the numeric scores into letter grades. • • . Loop through all the elements of the class Roster ArrayList To help with readability, temporarily store each element in the classRoster ArrayList in a variable you can easily access. Example: for(int i = 0; i < classRoster.size(); i++) String[] student = classRoster.get(i) Remember: The first element in the classRoster ArrayList is not a student. It is the header for the table and should be displayed differently as shown in the example run. Loop through each element of the student String[] array and convert the numeric value into a letter grade as shown in the table below. Remember: The first element in the student String[] array is the student's name and should be printed before you start the for loop to process the grades. The following table breaks down test score percentages to letter grades:
Percentage
> 94%
>90%
> 87%
> 84%
Letter
Grade
A
A-
B+
B
B-
C+
C
C-
D+
D
D-
Other
E
For this lab you will need to download the file Student Test Grades.csv Download Student Test Grades.csv.
This file contains a list of students and the scores they received for 3 tests. Place this file in your PROJECT
directory. Assume that your folder structure is similar to below.
eclipse-workspace -> CS105 -> src-> week 10 ->StudentTestScores
Then you would place the "Student Test Grades.csv" file in your CS105 directory
eclipse-workspace -> CS105
The format of the file looks like this:
Student, Test 1, Test 2, Test 3
Walter Koenig, 67, 88, 78
William.....
> 80%
> 77%
> 74%
> 70%
> 67%
>64%
> 60%
Example Run
Student
Walter Koenig
William Shatner
Patrick Stewart
Test 1 Test 2 Test 3
B+
D
C+
A
C+
B-
B-
A- A
Transcribed Image Text:Percentage > 94% >90% > 87% > 84% Letter Grade A A- B+ B B- C+ C C- D+ D D- Other E For this lab you will need to download the file Student Test Grades.csv Download Student Test Grades.csv. This file contains a list of students and the scores they received for 3 tests. Place this file in your PROJECT directory. Assume that your folder structure is similar to below. eclipse-workspace -> CS105 -> src-> week 10 ->StudentTestScores Then you would place the "Student Test Grades.csv" file in your CS105 directory eclipse-workspace -> CS105 The format of the file looks like this: Student, Test 1, Test 2, Test 3 Walter Koenig, 67, 88, 78 William..... > 80% > 77% > 74% > 70% > 67% >64% > 60% Example Run Student Walter Koenig William Shatner Patrick Stewart Test 1 Test 2 Test 3 B+ D C+ A C+ B- B- A- A
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Passing Array as Argument
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education