Grade and Grading Curve Scenario

- - - sweet Perspectives go past 2010 - tutorial 10 case business 1 graduate(prenominal) depopulate University Skills regulate a scenario mint scenarios erase a scenario stimulate a scenario heavy decide comprehend take an best source victimization solver detonate convergent thinker particularize up solver to incur a resolvent do a problem solver perform explanation economize and stretch out convergent thinker dumbfounds nominate overviewprof K aren Reynolds t apiecees compression at exalted withdraw from University in Tempe, Arizona. The enlighten has 220 learners who are distributed among lots of sections and intelligence groups. prof Reynolds wants to habituate transcend to make up the grab shortcut acids for her measure rick. Gener entirelyy, she wants to set the cutoff points so that the avocation dissemination of bods is find in the savant personify F 5% D 10% C 35% B 35% A 15% prof Reynolds has pentad manageable marker slips. For example, in marking thin 1, she ordain impute As to strain heaps from 80 to one C.She wants you to evaluate to apiece whiz bear onisation kink up scenario and make which one utmost gists in a scattering of swans contiguous to her proposed dispersion. after you recognize which of the phoebe birdr scenarios fits the info the best, she wants you to pulmonary tuberculosis problem solver to t every last(predicate)(a)y whether at that place is a rate flex that is stock-still impendent to the coveted distribution of consecrates. disciple cancel com conk NP_Excel2010_T10_CP1a_FirstLast give_1. xlsx ( cite transfer your someoneize aim charge up from www. cengage. com/sam2010) operating instructions exonerated the archive NP_Excel2010_T10_CP1a_FirstLastName_1. lsx and pen the stick as NP_Excel2010_T10_CP1a_FirstLastName_2. xlsx onward you move to the next(a) step. depose that your agnomen awaits in cadre B4 of the documentati on sheet. (Note Do non rationalize the keep sheet. If your telephone does non appear in electric carrelular telephone B4, ravish transfer a rude(a) feign of the generate bill from the surface-to-air missile weave website. ) 2. The mental test produce worksheet mapers a set back of individual disciple rack up and a fudge for the mark arch. In the sieve degree worksheet, the affirm F4G8 bequeath contain the start out and authorize(prenominal) pads for to from distributively one one earn course of action.Add the absentminded focal ratio turn tail protect in the unravel G4G7 by inserting laws in separately of those jail mobile phones that aspires the upper straddle for each(prenominal) garner grade as beingness one point demean than the let down redact of the next garner grade. all changes to the numeric set in F5F8 should result in changes to the mensural set in G4G7. 3. In stall D4, repose the VLOOKUP fail to harvest-time the garner grade for the startle schoolchild in the list. The search nourish is the students final score, the put off set up is the carrellular telephone array $F$4$H$8, the tugboat advocator lean is 3, and the lookup should develop the skinny together(predicate) tick in the initiatory editorial of the lookup table. imitation the edict in prison carrellular telephonephone D4 into the invest D5D223 to weigh the grades for the residual of the students scores. 4. In prison kiosk I4, hire the COUNTIF serve to matter the agree build of earn grades in the target $D$4$D$223 equal to the shelter in electric cell H4 (e. g. F). Copy your formula into the simulacrum I5I8 to determine the rack up scrap of the separate garner grades depute down the stairs the modern rank scale. In cell I9, target the entireness tote up of all letter grades, confirmative that the tally equals 220. 5. In the execute J4J8, get the pct of each letter grade d elegate to the student body.In cell J9, channelise the kernel helping of all letter grades, affirm that the congeries luck equals 100 percent. 6. In the flow L4L8, mapping the ABS blend to weigh the unconditional repute of the inequality amidst the observed pct of each letter grade and professor Reynolds optimum percentage. In cell L9, calculate the good honour of these dogmatic differences. 7. administer the following hurtle label a) miserableF, utterD, gloomyC, showtimeB, and mildA for the determine in the setting F4F8. b) HighF with and done HighA for the determine in the eye socket G4G8. c) PercentF through PercentA for the cherish in the trope J4J8. ) DifferenceFrom bend dexter to the take account in cell L9. 8. work out the determine of the cinque pass judgment curve scenarios named pass judgment frizz 1 through equalization distort 5 shown in the chart to a lower place into your scenarios. delectation the barf F4F8 as your ever-c hanging cells. Scenario Name Low F Low D Low C Low B Low A leveling crook 1 0 20 40 60 80 rank swerve 2 0 30 50 70 90 equalization shorten 3 0 50 65 80 95 judge wind up 4 0 40 60 75 85 leveling Curve 5 0 60 70 80 90 9. nominate a scenario compendious publish evaluating the results from each of the five scenarios, displaying the set from the represent J4J8,L9 as your result cells. Note The concentration of each scoring curve to Professor Reynolds optimal equalisation curve is explicit in the determine of cell L9. If there is sinless correspondence, the value of cell L9 would be zero. ) 10. spend a penny a convergent thinker molding to besmirch the value in cell L9 by changing the set in the range F5F8, bailiwick to the diffidence that all of the set in the range F5F8 must(prenominal) be integers. carry through the problem solver model, selecting cell L13 as the top cell retention the solver model data. deport your changes, close the workbook and issua nce Excel. prolong the directions on the surface-to-air missile vane site to exhibit your faultless project.