Question: In a course where the final passing mark is 60%, a student has achieved 55% in the coursework which is worth 35% of the final

In a course where the final passing mark is 60%, a student has achieved 55% in the coursework which is worth 35% of the final mark (the remaining 65% weighting has been assigned to the Exam). To find out the minimum percentage that he needs to achieve in the exam in order to pass the course (cell C3), the following spreadsheet has been constructed: B 1 Assessments Weightings Marks 2 Coursework 35 55.00% 3 Exam 65 4 Total 100 19.25 To do this, the Goal Seek function in Excel is used. (Assume that all calculations are formulated with proper cell references so that any impacts from changes will be automatically calculated in the spreadsheet) Goal Seek Sgt celt: To yalue By shanging cell: OK Cancel What value should be entered into the To value box? (Assume that "Set cell" has been set to C4) 60 0.6 60% 100% O Max

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please attemp the question I have attached and I have guideline for the answers.For question 3,difference between tax evasion and avoiddance can be found in seminar 2 slides.Tax avoidance mean the...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

hi can you help me in my assignment? some details can get in MAA Group Berhad. 2014 financial position, highlights, income statement. Olympia College Assignment Diploma in Business Management DIPLOMA...

MNG3702/101/3/2016 Tutorial Letter 101/3/2016 Strategy Implementation and Control MNG3702 Semesters 1 and 2 Department of Business Management PLEASE NOTE: This tutorial letter contains important...

Part B: Class Statistics For Part B you are to modify the worksheets in Excel that helps you keep track of the marks of a fictitious class. Part B will consist of three sheets: 1. a marks worksheet...

The product of your research and collaborative effort is a report that is to be submitted to the senior management group of ABC Equities Ltd (ABC), a very large client firm who is currently...

Do you agree with the changes Johnson is making to the pricing scheme that are set to take effect August 1st? Are they enough to turn things around? ELIE OFEK JILL AVERY For the exclusive use of T....

Comcasts customer service department asks its customers to rate their over the phone service on a scale of 120 immediately after their service has been completed. The company then matches each...

The design parameters shown below are given for a 5 story hospital building. Calculate the horizontal earthquake forces and eccentricity moments to be applied on each story for x and y direction...

Employee stock ownership plans are tax exempt under: 4 9 7 5 ( e ) 4 0 2 5 2 4 0 1 ( a ) 4 0 7 4 4

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...