Using Microsoft Excel for a Course Grades Report
Jessie 1
Project2InformationSheet1.pdf
1
Project #2
Using Microsoft Excel for a Course Grades Report
Purpose of the Project:
This project has a two-fold purpose:
1. To help you have a better understanding of Microsoft Excel. 2. To provide you with an opportinuty to use Microsoft Excel on a project in the real world.
Requirements of the Project:
The Excel file labeled “IST101-00 GRADES”, available in the folder of Project 2 in Content,
contains the grades for a hypothetical class IST101-00: Introduction to IST. Perform the following
tasks using this file.
1. Add the following two students to the grade sheet:
Name : Thomas, John McCullum, Alicia
Exam #1: 82 65
Exam #2: 75 79
Exam #3: 81 84
Paper: 87 92
Participation: 94 65
2. Calculate the final average for each student. For the final average, the three exams should
each count 25%, the paper should count for 15%, and participation should count for the 10%.
3. Calculate the class average for each exam, paper and participation.
4. Create a chart that shows the grade distribution for the final average. (A=90-100; B=80- 89; C=70-79; D=60-69; F=below 60)
5. Sort the file alphabetically.
6. Save the sorted file with all the work listed above.
Please save your file using the format: IST101-71 S-2019 P-2 Your Last Name, First Name.
This project 2 accounts 4% of your final grade.
Due Date:
Please submit your report in the Report 2 folder in Content on Blackboard on/before 11:59 PM on:
Saturday May 25, 2019*
2
A B C D E F
1 IST101-00: Introduction to IST
2 Spring 2019 Grades
3
4 NAME Exam 1 Exam 2 Exam 3 Paper Participation
5
6 Stevens, Tony 64 70 73 85 75
7 Rivers, Tina 70 77 88 95 90
8 Beal, Jenny 77 83 79 88 80
9 Calhoun, Richard 69 43 81 78 75
10 Nixon, Rachel 91 90 86 95 88
11 Freeman, Ralph 44 26 54 78 80
12 Copely, Roy 61 67 70 85 80
13 Kimmett, Roger 77 85 86 85 85
14 Allen, Renae 83 86 92 85 88
15 Victor, Isaac 97 80 82 85 88
16 Albright, Alan 69 69 50 85 75
17 Bredder, Richard 96 92 92 98 85
18 Gaby, Brad 95 89 89 95 85
19 Hendrix, James 91 84 92 95 85
20 Fonzerelli, Arthure 87 79 84 85 80
21 Cunningham, Richard 76 73 80 82 80
22 Van Dyke, Robert 84 75 78 88 80
23 Thompson, June 82 84 78 88 85
24 Ashe, David 70 41 57 73 70
25 Pepper, Claude 79 84 77 82 80
26 Lemeiux, Felix 84 67 78 88 80
27 Regan, Rhonda 97 93 92 92 85
28 Walton, Christine 87 73 82 90 88
29 Census, James 65 38 84 85 85
30 Richardson, Natasha 79 75 85 75 75
31 Montana, Joseph 71 80 78 88 90
32 Hindes, Martina 96 80 96 98 95
33 Levert, Christine 98 95 96 98 95
34 Tucker, Peter 87 78 86 82 80
35 Blackwood, Rita 59 42 54 75 75
36 Mahler, Blake 84 92 93 90 90
37 Black, Susan 51 67 76 78 80
