Home
Up

CMS
Discussion Board
Photo Gallery
Guestbook

 

THE STORY OF YOUR GRADE

I want to tell you the story of your grade in IT152, the course you took under me this 2nd Semester, AY 2009-2010. Column A below shows your actual raw score in percent, which represents the sum of five components. Passing score in any component, as you already know, is 60%. Converting your raw score to grade using the Excel function VLOOKUP (using the lookup table below) gives the tentative grades under Column B.  Examining the tentative grades made me realize that the best performing student in the course will receive only a grade of 2.0, and six will receive a grade of 4.0 while seven will receive a grade of 5.0.  When plotted on the Gaussian distribution curve, the tentative grades will result in a skewed graph whose mean will fall to the left zero standard deviation. I wanted the graph to approximate the normal distribution, which I achieved by lowering the passing percentage to 50%.  Converting the resulting raw scores using the function VLOOKUP and the lookup table below gives the tentative grades under Column C. However, what I uploaded to the CRS, your final grades, are shown under Column D. Take note that I upgraded two 4.0 grades to 3.0. This was to allow one overstaying graduating student to finally graduate.  To be fair, the other 4.0 grade has to follow suit, of course.  Two 5.0 grades were converted to “INC”, and two others were changed to “DRP” as the students actually dropped the course.

I regret to say that the “INC” cannot be removed, they have to be re-enrolled. Please do not ask when or how you can remove your “INC”. You have to take the course again. I only spared you from getting a red mark on your Transcript of Records. Despite a lowered passing percentage of 50%, your initial grade of 5.0 remained a 5.0.  That is all the concession I can give.

May I say in parting that I enjoyed having you in my class, interacting with you, and observing your study and work habits? Actual life performance, however, has low correlation with college performance.  The low performers should not despair. Strive to graduate and make your mark in the workplace as an employee or as your own boss running your own business. Whatever your work, uphold always the UP values of honesty, integrity and fear of God. You'll get far if you do.

God bless and God speed!

A

B

C

D

LOOKUP TABLE

80.75117

2

1

1

0

5

78.79793

2.25

1.25

1.25

10

5

77.31221

2.25

1.25

1.25

20

5

77.30927

2.25

1.25

1.25

30

5

74.18329

2.5

1.5

1.5

40

5

73.87128

2.5

1.5

1.5

50

4

73.25215

2.5

1.5

1.5

60

3

71.83588

2.5

1.75

2.5

65

2.75

71.68036

2.5

1.75

2.5

70

2.5

71.52778

2.5

1.75

1.75

75

2.25

71.37128

2.5

1.75

1.75

80

2

71.29108

2.5

1.75

1.75

85

1.75

70.90376

2.5

1.75

1.75

90

1.5

70.75215

2.5

1.75

1.75

95

1.25

69.96088

2.75

1.75

1.75

100

1

68.62676

2.75

1.75

1.75

 

65.66315

2.75

2

2

 

64.10113

3

2

2

 

62.143

3

2.25

2.25

 

60.89984

3

2.25

2.25

 

59.57062

4

2.5

2.5

 

59.38165

4

2.5

2.5

 

58.94464

4

2.5

2.5

 

58.09077

4

2.5

2.5

 

54.52093

4

2.75

2.75

 

53.06573

4

2.75

2.75

 

49.35309

5

3

3

 

46.10113

5

4

3

 

41.69464

5

4

3

 

39.18682

5

5

INC

 

24.87676

5

5

INC

 

24.39554

5

5

DRP

 

10.94484

5

5

DRP

 

 

New Posts

Most Costly Power
Electric Power
ERC Procedures
ERC Case Filing
Self-Treat Cancer!
Milk & Cancer
Prevent Cancer!
Electronic Books
Audio Bible

Ads


Freelance award-winning Filipino 3D animator and graphics artist

 


Copyright © 2004 by Pablo B. Española
All rights reserved. Last updated February 01, 2012
For inquiries please contact the Webmaster.
Hit Stats