Excel Project Answer Sheet

.pdf

School

John Tyler Community College *

*We aren’t endorsed by this school

Course

154

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by bobpalmer04

[Part 1: Weighted Average| OfL+ 10-§6+ 10 B+ ————— Excel Project Answer Sheet a. SHOW ALL WORK. Remember that this is weighted average. b. Round your answer to nearest hundredth. - . 1. Compute BY HAND the final course grade for a student with the given scores below. o TN BB LL TS WLe-92=8310.09/ | 9o =83 4004 / [/ o/ /} Quiz Ave fa ge { \ / Excel Project {\ . (/8 Homework Average 82 86 85 Finance Project 77 Tests 88, 75,92 . Nicholas Hall is a student in MTH 154 who earned the following grades during the semester (listed below). What is the lowest grade he could earn on Test 3 and still earn a C (70) for the course? **Reminder that the lowest homework and lowest quiz grade are dropped in this course. 205\ 20680 U XBH*@% 79+%-5 'lj\°2§ “X=T70006 a, GOIR. L6 Category Grades s U0 | Homework 373{2&33,{0:«39,*190,*4_5;\5;,41;"8,*5;:5525 / Q= 5@ I\ 20| Quiz \ 0| Excel Project 82)86472,'53, 0, 68, 43, 100, 66, 42 74 ! i ) \S| Finance Project 78 5/ Wi Tests ne 79,57 él2/Cl 2 é% a. Algebraically calculate the grade needed for test 3 in order to earn a C (70), showing ALL wark below. Round your final answer to the nearest tenth. 60\\2.%% (P .,,@_35_)( =T1000 e

/ 3. Use your Excel file to verify the grades listed above, and show that Nicholas earns a C (70) overall grade with the test 3 score you calculated. /a. (NOTE: Do NOT replace your weighted average work from step 2 and 3, create a new table with the new data). b. Copy and paste the original table to a new area on the sheet, and put in the new data. 4. Is i7possible for Nicholas to improve his score? a. Using your test #3 score from #2, is it possible for Nicholas to pull his grade up from a C (70) to a B ( (80) just by improving his homework score? (Use your excel table to adjust the scores and see if tl'zis igpozs\i/ble.) U%\(\b 3(\,\& A«ﬂ)ﬂ)\ Eyf,\' g(w’\ [E=2 a’w‘\f}\ e ’\{c‘::)r ?’) Scove O‘P @ BNl eVeR (T, W00%, O all of Wi Yome il Nitholas wWeuld net Be alle Yo (ase nis (adl Yo o @%\ b. Using the scores from your Excel ta%e, hand calculatev&ic olas’ final grade and see if it is possible | for him to earn a B. Explain why it is or is not possible. | %gifigo \XY ifi\’\DX' @bfifi\k\fi o N{C\'\0\°~5 to (e 1074 s «C‘iv&m\f (&5\@ To Of C’\\OG\/& o %(fo) {%;71:3( N NP Ypepue of bhe vest of {\.“55-51 hio low Scores Such as Wi quirses Hm’%L\ 1 PXnY Ny 3555%&;‘} ;

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help