Excel Assignment

Excel Assignment 2

Create a spreadsheet that your instructor could use to calculate final averages and letter grades for this

class (INFS 3100). Use the point values from the syllabus for discussion questions, Excel assignments

and quizzes. The spreadsheet should use the design and all features of the spreadsheet created in your

Excel tutorial for assignment 2. More specifically, the following requirements must met:

1. Each student record should be on one row and each grade item or calculated value should be in one

column similar to the tutorial

2. A table that includes cutoff’s for each grade level, i.e. 90 for A, 80 for B, etc.

3. Column Headings

4. A minimum of 5 fictitious student records with grades entered for each student.

5. Columns for total points in each category of grades (discussion, Excel and quiz).

6. A calculated final average.

7. A final letter grade. Use an IF statement and absolute cell referencing for grade cutoff’s from the

table created in 1.a. above (similar to what was done in assignment 2 tutorials).

8. A class average for each individual grade item, combined grade categories (discussion, Excel, and

quiz), and final average.

9. The highest (max) grade for each individual grade item, combined grade categories, and final

average.

10. The lowest (min) grade for each individual grade item, combined grade categories, and final

average.

11. Center all column headings

12. Bold columns for total discussion points, total Excel assignment points, total quiz points, final

average, and letter grade.

13. Format all calculated values (not individual scores) as number with one decimal point.

14. Put your name at the top of the spreadsheet.

15. Upload your completed assignment to the Dropbox for assignment 2 in D2L by the due date. Verify

that you assignment is uploaded correctly. This can be accomplished by opening the uploaded file to

verify the file opens properly.

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.