50.1K

Verified Solution

Link Copied!

The goal of this extra credit assignment is to create a professionally formatted interactive excel dashboard to answer the question, what do need to score on the remaining 2nd half of our class assignments including the final exam to earn the final grade I am hoping to receive in this class. You will be using the following data from our syllabus combined with your actual results for the first half of our class. Note the following does not have extra credit assignments. Assume that 4% additional can be earned with extra credit assignments. For full credit, your grade model must include worst case, most likely, and best case scenarios. Grade Components Points Percent* Participation 15 3.6% Homework Assignments (My Acct Lab) 90 21.4% Chapter Exams 90 21.4% Midterm Exam 90 21.4% Other Homework and in class assignments 40 9.5% Final Exam - in class 95 22.6% Total Points 420 100.0% Grade Scale for Accounting Classes A = 95-100% C+ = 77-79% A- = 90-94% C = 70-76% B+ = 87-89% C- = 67-69% B = 83-86% D = 60-66% B- = 80-82% F = Below 60% Hand in your professionally forecasted interactive (allows for the user to input what if scenarios - you should populate this initially with your realistic goals) Excel model. 1) You should have at least two sheet tabs in your workbook. First one should be your dashboard, 2nd one your actual data results. You can have more tabs if you think it adds to your model. 2) Dashboard should show the detail on how to get to the end of class final grade goal. Extra Credit - Excel sales and Cost Forecast N/A 0.00 / 0.00 Assignments N/A 0.00 / 0.00 End of term group project N/A 0.00 / 0.00 Other Homework and In Class Assignments 100% 26.00 / 26.00 Midterm Exam 34% 34.00 / 100.00 My Accounting Lab Homework 100% 45.00 / 45.00 Chapter Exams/Quizzes 90.22% 40.60 / 45.00 Final Exam N/A 0.00 / 0.00 Participation 100% 17.00 / 17.00 Extra Credit - moving company N/A 0.00 / 0.00 Extra Credit - Eppley Airline Part 2 N/A 0.00 / 0.00 0.00 / Extra Credit - Student Grade Budget Forecast Excel Model N/A 0.00 Total 65.37% The goal of this extra credit assignment is to create a professionally formatted interactive excel dashboard to answer the question, what do need to score on the remaining 2nd half of our class assignments including the final exam to earn the final grade I am hoping to receive in this class. You will be using the following data from our syllabus combined with your actual results for the first half of our class. Note the following does not have extra credit assignments. Assume that 4% additional can be earned with extra credit assignments. For full credit, your grade model must include worst case, most likely, and best case scenarios. Grade Components Points Percent* Participation 15 3.6% Homework Assignments (My Acct Lab) 90 21.4% Chapter Exams 90 21.4% Midterm Exam 90 21.4% Other Homework and in class assignments 40 9.5% Final Exam - in class 95 22.6% Total Points 420 100.0% Grade Scale for Accounting Classes A = 95-100% C+ = 77-79% A- = 90-94% C = 70-76% B+ = 87-89% C- = 67-69% B = 83-86% D = 60-66% B- = 80-82% F = Below 60% Hand in your professionally forecasted interactive (allows for the user to input what if scenarios - you should populate this initially with your realistic goals) Excel model. 1) You should have at least two sheet tabs in your workbook. First one should be your dashboard, 2nd one your actual data results. You can have more tabs if you think it adds to your model. 2) Dashboard should show the detail on how to get to the end of class final grade goal. Extra Credit - Excel sales and Cost Forecast N/A 0.00 / 0.00 Assignments N/A 0.00 / 0.00 End of term group project N/A 0.00 / 0.00 Other Homework and In Class Assignments 100% 26.00 / 26.00 Midterm Exam 34% 34.00 / 100.00 My Accounting Lab Homework 100% 45.00 / 45.00 Chapter Exams/Quizzes 90.22% 40.60 / 45.00 Final Exam N/A 0.00 / 0.00 Participation 100% 17.00 / 17.00 Extra Credit - moving company N/A 0.00 / 0.00 Extra Credit - Eppley Airline Part 2 N/A 0.00 / 0.00 0.00 / Extra Credit - Student Grade Budget Forecast Excel Model N/A 0.00 Total 65.37%

Answer & Explanation Solved by verified expert

See Answer