Joseph is a business student at a local university. He is looking over his transcripts to determine how his performance looks so far. He pulled the following report from his profile on the University's Student Information section: At this University, A = 4, B = 3, C = 2, D = 1, and F = 0. How many of each of the possible letter grades did Joseph receive?
A) A: 6; B: 7; C: 5; D: 1; F: 1
B) A: 7; B: 6; C: 4; D: 2; F: 0
C) A: 7; B: 7; C: 4; D: 2; F: 0
D) A: 7; B: 7; C: 5; D: 2; F: 0

Question

Joseph is a business student at a local university. He is looking over his transcripts to determine how his performance looks so far. He pulled the following report from his profile on the University's Student Information section:  At this University, A = 4, B = 3, C = 2, D = 1, and F = 0. How many of each of the possible letter grades did Joseph receive?
A) A: 6; B: 7; C: 5; D: 1; F: 1 
B) A: 7; B: 6; C: 4; D: 2; F: 0 
C) A: 7; B: 7; C: 4; D: 2; F: 0 
D) A: 7; B: 7; C: 5; D: 2; F: 0

Quizplus · Accepted Answer

This question requires familiarity using Excel to do some simple data manipulation. This question requires the use of the Excel COUNTIF function. First, create a column with a list of all the letter grades. To the right of each letter, use the COUNTIF function to count the number of times that value occurs in the grades list. This will appear as follows: for a grade of A, use "=COUNTIF(C2:C21,4)" that should return the count of 7. Repeat this for each letter, and Excel should return the following counts: B = 7, C = 4, D = 2, and F = 0 (Choice C).

Joseph Is a Business Student at a Local University