JavaProgram: SpreadsheetWriter

SpreadsheetWriter Let's write a program that will produce a file that can be opened by Excel or LibreOffice Calc. Go to Getting Started and look up the grading weights used for this course. As an example, we'll use the following table, but you should use the values you find in Getting Started Activity Labs Weighting % 20 Reading Quizzes 10 Group Work Midterm Project Final Instructor Discretion 5 10 20 15 20 Write a class SSRow. Objects of this class should keep track of String name, int score, int weight, String calc. SSRow also has a toString method that retums this data in order, separated by commas name+"."+score.+weight+calc Further design of the SSRow class is left to you. Add what you need, but dont get carried away Write a class SSWriter that has a main method. For each of the grading categories (Lab, Reading Quizzes, Group Work, Midterm, Project, Final, Instructor Discretion). query the user for a score, and create the following SSRow objects "Lab", , 20, "-B1*C1/100 Reading Quizzes", , 10, " B2 C2/100" "Group Work", , 10, " B3'C3/100" "Midterm", , 20, "-B4 C4/100" "Project, , 15, "-B5 C5/100 "Final, , 20, "-B6 C6/100 Instructor Discretion", user input>, 5, "-B7 C7/100 Open a file for output with a file type of csv (say MyGrades.csv, for example) Write the toString value for each SSRow to the file Finally, write a row average,-(D1+D2+D3+D4+D5+D6+D7) Open MyGrades.csv with Excel or LibreOffice Calc