ExcelExamples - GPA computation This speadsheet contains...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
GPA computation This speadsheet contains calculations of semester GPAs of three students taking the same 5 courses. Inputs, including course credit hours, students' letter grades and conversion table of letter grades to numeric o The bottom part constains formulas for converting each student's letter grades into numeric ones, and using t INPUTS: Class name IOE 201 IOE 202 Math 214 Phil 180 Physics 240 Total credits Class credit hours 2 2 4 3 4 15 Students and grades Student X A B C D A Student Y B A C A D Student Z C A B D A CALCULATIONS: Students and numeric grades GPA Student X 4 3 2 1 4 2.73 Student Y 3 4 2 4 1 2.53 Student Z 2 4 3 1 4 2.87
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ones are provided in the top part. the latter to compute GPAs. Grade conversions A 4 B 3 C 2 D 1
Background image of page 2
Inputs This spreadsheet computes and plots cost per unit of time as a functi a 1200 in an EOQ inventory model. Input data correspond to the CubicleMin K 35 T(Q) calculations and the resulting graph are computed as a function c 100 on the left. Change the inputs to see how the curve in the graph chan h 10 (Hint: you may need to change the range of Q-values used and the a
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

ExcelExamples - GPA computation This speadsheet contains...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online