Excel Assignment 2 Overview
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 <60
3. A minimum of 15 fictitious student records with grades (you make up the names and grades)
entered for each student. Each student record should be on one row and each grade item or calculated
value should be in one column similar to the tutorial. Begin with student name in column A, two rows
below the tables created in 1 & 2 above.
4. Columns for each individual grade item and total points earned in each category of grades (Pop
Quizzes, Regular Exams, Mid-Term Exam, Final Exam and Case Studies). Columns for Final Average and
Letter Grade. For column headings use abbreviations or word wrap so that columns are just wide
enough to accommodate the grades in each column. Center all column headings.
5. Use absolute cell referencing and the percentages from the table created in #1 above to calculate
total points earned for each grade category. Your formula should drop the lowest grade for pop quizzes
and regular exams. Do not use the actual percentages in the formula. Instead use the cell address
where the percent is stored. This design should be done in a way that percentage changes in the table
would automatically be reflected in affected calculations.
6. Calculate a final average for each student.
7. Calculate a final letter grade for each student. Use an IF statement and absolute cell referencing for
grade cutoff’s from the table created in #2 above (similar to what was done in assignment 2 tutorials).
Reference the grade level cut-off levels from the table so the cut-off levels for each letter grade can be
changed in the table and reflected in each individual letter grade.
8. A class averag
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.