Using Microsoft Excel for a Course Grades Report

Using Microsoft Excel for a Course Grades Report

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

  1. 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%.

  1. Calculate the class average for each exam, paper and participation.
  2. 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)
  3. Sort the file alphabetically.
  4. 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

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees


We value our customers, and so ensure that our papers are 100 percent original. Our Team of professionals does not miss the mark; they ensure that step by step each paper is written uniquely. We never duplicate or work as we compare papers rest assured. We deliver our work a day before time to ensure that you don’t miss your deadlines. It is not only doing the work but delivering it at the right time. We capture the consequences of late remittances. .

Money-back guarantee

We value customer satisfaction here at popularessaywriters.com and make sure that you get the best value for your Money. It happens that sometimes you can pay twice for your order or may want to cancel it, or you feel that it doesn’t meet your requirements; our money back guarantee will give you the opportunity to get back your money. We will also refund 100% of money paid double. In case your paper does not satisfy your requirements , we request that you notify us via writing within 2 days otherwise on the third day we will assume that you have been satisfied. Do all your correspondences through our email address popularessaywriters@gmail.com.

Read more

Zero-plagiarism guarantee

At popularessaywriters.com, our professional writers know the consequence plagiarism does for our clients. We have updated software’s such as article checker and copyscape to check for originality of the custom papers before submission of the final paper to the you. Our guarantee to the customer is that we will write 100% original papers for them that are quality, timely and of low cost. We have experienced professional and competent PhD writers who will write quality custom papers for you..

Read more

Free-revision policy

. At popularessaywriters.com, we are proud to provide top-quality Essay writing service to our esteemed customers. We are ready to take up that challenging academic assignment that is giving you sleepless nights and simplify it for you according to your desired requirements. We are willing to revise your paper if it does not meet your requirements. At popularessaywriters.com, we do not compromise with quality; thus, we offer unlimited free revisions until the customer is satisfied with their custom paper. Our unlimited free revision services are provided under the following terms:.. .

Read more

Privacy policy

Popularessawriters.com knows that client’s information is an essential tool for our company. It means that whatever the client requests from our service is kept strictly confidential. It means that whoever writes for this company understands the terms and conditions hence you should not be worried because you will never see your work somewhere else...

Read more

Fair-cooperation guarantee

Rest assured that we will always be attentive to your needs and requirements. We belief in the phrase treat your neighbour as you would want them to treat you. We leave nothing to chance and always look forward to a good interaction with each other.. .

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency