This is an individual assignment, and you should create this spreadsheet on your own. Keep in mind that the tutorial is a learning tool and completion of the tutorial is not the assignment. You should
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
This is an individual assignment, and you should create this spreadsheet on your own. Keep in mind that the tutorial is a learning tool and completion of the tutorial is not the assignment. You should start with a blank spreadsheet and build the assignment from scratch. Create a spreadsheet that your instructor could use to calculate final averages and letter grades for a fictitious class. Each individual grade will be recorded as points earned out of 100 total possible. You should watch the tutorials for Excel assignment 2 before beginning this assignment. The spreadsheet should use a similar design and features of the spreadsheet created in your Excel tutorial for assignment two. More specifically, the following requirements must be met: 1. Create a two-column table starting in cell A2 using the point values below for pop quizzes, regular exams, mid-term exam, final exam, and case studies. Pop quizzes (5) 10% (drop lowest grade) Regular exams (6) 30% (drop lowest grade) Mid-Term 20% Final 20% Case Studies (2) 20% 100% 2. Create a two-column table starting in row 2 just to the right of the table created in #1 above. This table will include cutoffs for each grade level which are listed below. A 90 B 80 C 70 D 60 F