# engr13100_hw04_f10 excel spreadsheet - 27 Familo-car 27...

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

Name: Type Name Here Lab Section: Type Section Here Date: Type Date Here Problem Description: HW4 Problem 5 - Cell Addressing I Input Section: Calculation Section: Output Section: See grades input for Homework Participation (team) Exams MEA Projects/MEA Suzie Student Q1. Grade (Original) in the table to the right Score Possible Score Possible Score Possible Score Possible Score Possible Score Possible 1 40 40 3 5 4 5 68 100 22 25 8 10 Q2. Grade (w/o EX3) From ENGR131 Syllabus: 2 55 60 78 100 20 25 7 10 Homework 20 % 3 88 100 85 100 38 50 6 10 Q2. Grade (w/ Part.) Team Participation 5 % 4 90 120 8 10 Class Participation 5 % 5 60 120 28 35 Q3. Highest grade? Exam Average* 40 % 6 80 100 20 25 MEA 15 % 7 75 80 Project 15 % 8 82 100 9 20 60 10 0 40 11 57 60 12 73 80 13 70 80 Avg. Weighted Avg. Semester Grade 0 Assignment Number Participation (class)

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

View Full Document
Name: Type Name Here Lab Section: Type Section Here Date: Type Date Here HW4 Problem 6 - Cell Addressing II Input Section: Calculation Section: Output model mpg km/gal km/L L/km L/100km Q1 Econo-car 36 Econo-car 36 Q2 Econo-car 36 Familo-car 27 Q3 Familo-car 27 Familo-car 27 Q4 Familo-car

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

View Full Document

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.

Unformatted text preview: 27 Familo-car 27 Luxuro-car 22 Luxuro-car 22 Sporto-car 19 Average US Std: Problem Description: The standard is not met (a higher value in L/100km for the fleet means MORE fuel is used for the same distance, so the efficiency is lower than the standard. t Section: Units Mean (Avg) : Does it meet US standard? Mean (Avg) : Canadian Standard Does it meet Canadian standard? Name: Type Name Here Section#: Type Section Here Team #: Type Team No. Here Date: Type Date Here HW#: 4 Problem 5: Output Section Output Section: Q1. Grade (Original) 0 0.00% Q2. Grade (w/o EX3) 0 0.00% Q3. Grade (w/ Part.) 0 0.00% Q4. Highest grade? 0 0.00% Problem 6: Output Section Q1. Mean (Avg) : 0.00 Q2. Does it meet US standard? Q3. Mean (Avg) : 0.00 Q4. Canadian Standard 0.00 Does it meet Canadian standard?...
View Full Document

{[ snackBarMessage ]}

### Page1 / 6

engr13100_hw04_f10 excel spreadsheet - 27 Familo-car 27...

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

View Full Document
Ask a homework question - tutors are online