ExcelExamples

# ExcelExamples - GPA computation This speadsheet contains...

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

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

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

View Full Document
ones are provided in the top part. the latter to compute GPAs. Grade conversions A 4 B 3 C 2 D 1
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/17/2010 for the course IOE 202 taught by Professor Marinaepelman during the Fall '09 term at University of Michigan-Dearborn.

### 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
Ask a homework question - tutors are online