MATH123-1BH-H1-202020-VI

https://drive.google.com/file/d/1yyb9YtjmI0g6eKcEDpXHXUQwbQjqbB4t/view?usp=sharing

https://drive.google.com/file/d/1xaOadxrrG2Gh22wqOpT5grN7ZeIJ0L8Z/view?usp=sharing

Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . Ivy Learn MATH123-1BH-H1-202020-VI > Quizzes > Project 1 102020-202020 Fall 2020 Project 1 A+ Questions Account Home Started: Oct 10 at 3:59pm Question 1 Announcements Question 2 Dashboard Quiz Instructions Question 3 Syllabus Question 4 Modules Understanding how weighted averages work will be a very important topic for you in this course, since Question 5 Courses your grades are determined in this way. In this project, you will create an Excel spreadsheet that can Question 6 Grades calculate a student's final grade in a course. You will then submit a WORD document answering several Time Elapsed: Hide Calendar Zoom questions regarding your project. WORD and Excel documents ONLY. Attempt due: Oct 11 at 11:59pm Tutor.com 24/7 In this project you are required to do the following: 0 Minutes, 17 Seconds Inbox Online Tutoring Create an Excel spreadsheet that will be capable of calculating a student's final grade in a given course. Cengage Unlimited Keep in mind that weighting is involved in determining the final grade. You should NOT be using a template for this project. You will be required to CREATE the gradebook from a blank worksheet. Your Excel spreadsheet Search Dashboard should contain the following: ? . Your name, course name and project name. Resources . A data table labeled by Category using the category headings and scores on the next page for a MATH 123 class (DO NOT use any your own scores). . A table to calculate the overall grade with headings Categories, Category Weights, Category Average and Category Percentage Points. . Category Weights used to determine the final weighted grade for a MATH 123 . A Final course grade, Labeled cell, at the bottom of your grade book calculation table that uses a K- formula to calculate the weighted OVERALL COURSE percentage. If a value is changed in your spreadsheet, your final calculation should recalculate. Please limit your use of Excel functions to those531] Quiz: ProJectl X + 7 X e e C ii ivylearn.ivytech.edu/coursesf'l023730fquizzesf3038032ftake r -:- G 9 .216 O E! G a . E - .w. \"muc, com... um... mm pug.\" \"an... - A data table labeled by Category using the category headings and scores on the next page for a MATH 123 class (DO NOT use any your own scores). - A table to calculate the overall grade with headings Categories, Category Weights, Category Average and Category Percentage Points. - Category Weights used to determine the nal weighted grade for a MATH 123 Account - A Final course grade, Labeled cell, at the bottom of your grade book calculation table that uses a 5:) formula to calculate the weighted OVERALL COURSE percentage if a value is changed in your spreadsheet. your nal calculation should recalculate. Please limit your use of Excel functions to those used in the course-packet [for a list see the 'Excel Reference sheet' in Ivy Learn's 'Excel Help' Module.) nghlght the nal curse percentage cell. Dashboard Your written portion of the project will consist of answering the short answer questions given below. Each short answer response should be a minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use you spreadsheet to answer the \"what if" questions with specic values and provide support for your statements. Questions are not cumulative 7 return to your original spreadsheet to answer the next question. 1. Explain how you setup your excel worksheet. Make sure to address any formula used by showing an example but avoid using cell references (BS, A3, C112, etc.) What final course percentage (rounded to Resources a whole number) did you calculate? What letter grade in the course did this student earn? 2. What is the lowest grade on Exam '1 that the student could get and still earn the same letter grade in this class? How many points fewer is this grade from the 76 points they originally had? 3. If the student didn't do any of the online reviews, would this have affected their overall class grade? 4. If the student could redo any assignment for a better score that is not an exam, what is the best grade possible in the course? If they improved all the assignments, could this reach the next letter grade? 5. Your instructor has decided to give the student a chance at extra credit. Pick one homework assignment. How many points of extra credit are needed to raise the student's overall letter grade? ls 531] Quiz: Prolectl X + 7 x e 9 C it ivylearn.ivytech.edu/coursesf'l023730fquizzesf3038032ftake -:- fr 9 6 O I]! G a . E Your written portion of the project will consist of answering the short answer questions given below. Each short answer response should be a mi 'mum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use you spreadsheet to answer the "what if" Account questions with specic values and provide support for your statements. Questions are not cumulative {1) return to your original spreadsheet to answerthe next question. Ll; Dashboard 1. Explain how you setup your excel worksheet. Mal-(e sure to address any formula used by showing an example but avoid using cell references (BS. A3, (312, etc.] What final course percentage (rounded to a whole number) did you calculate? What letter grade in the course did this student earn? Courses 2. What is the lowest grade on Exam 1 that the student could get and still earn the same letter grade in this class? How many points feweris this grade from the 76 points they originally had? 3. If the student didn't do any of the online reviews, would this have affected their overall Class grade? 4. If the student could redo any assignment for a better score that is not an exam, what is the best grade possible in the course? If they improved all the assignments. could this reach the next letter grade? 5. Your instructor has decided to give the student a chance at extra credit. Pick one homework assignment. How many points of extra credit are needed to raise the student's overall letter grade? Is this a reasonable request for the student to ask for? Resources Use the following parameters and scores in your Excel spreadsheet: Methods of Evaluation: There will be an Exam 1' Exam 2, and Exam 3 in this class. Atotal of 20 homework scores (2 rows in the table] are given and 10 total quizzes are assigned. The course has 2 projects and 3 online test reviews. Grading Scale: 90 - 100 A Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take 4 ORGA . . . Ivy Learn Use the following parameters and scores in your Excel spreadsheet: Methods of Evaluation: There will be an Exam 1, Exam 2, and Exam 3 in this class. A total of 20 homework scores (2 rows in the table) are given and 10 total quizzes are assigned. The course has 2 Account projects and 3 online test reviews. Grading Scale: Dashboard 90 - 100 A 80 - 89 B Courses 70 - 79 C Calendar 60 - 69 D 0 - 59 F Inbox A student has the following grades and weights in each category: Search Weight ? 20% Exam 1 76 Resources 20% Exam 2 80 25% Exam 3 92 5% Online Review 30 55 95 K-Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . 0 - 59 F Ivy Learn A student has the following grades and weights in each category: Weight Account 20% Exam 1 76 Dashboard 20% Exam 2 80 Courses 25% Exam 3 92 5% Online Review 30 55 95 Calendar 10% Project 82 90 Inbox 10% Quiz 80 65 84 100 100 97 68 90 0 67 Search 0 100 100 72 86 91 100 90 95 68 ? 10% Homework Resources 100 98 98 0 92 65 90 80 70 0 If you would like a paper copy of the directions, you can access the file below: Project 1, Gradebook.docx K- If you need help with Excel, check out the student guide below!Quiz: Project 1 X + X -> C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . Ivy Learn If you would like a paper copy of the directions, you can access the file below: Project 1, Gradebook.docx If you need help with Excel, check out the student guide below! Account Project 1, Gradebook Student Guide.docx # Dashboard D Question 1 14 pts Courses Explain how you setup your excel worksheet. Make sure to address any formula used by showing an example but avoid using cell references (B5, A3, G12, etc.) What final Calendar course percentage (rounded to a whole number) did you calculate? What letter grade in the course did this student earn? Inbox (Spelling/Grammar appropriate for a college level course accounts for 2 points of this score.) Search Edit Insert Format Tools Table ? 12pt w Paragraph " B J U Av QV Try |: Resources K-5353 Quiz: ProJectl X + 7 x e 9 C ii ivylearmivy'techedu/cnursesf'l023730iquizzesf3038032ftake -:- a" ? :6 O I] G a . E 3 Question 2 14 P15 Account 5:) What is the lowest grade on Exam '1 that the student could get and still earn the same Dashboard letter grade in this class? How many points fewer is this grade from the 76 points they originally had? Courses (Spelling/Grammar appropriate {or a college level course accounts for 2 points of thls scoreJ Edit Insert Format Tools Table 12m v Paragraph v B I 9 v g v T2 v Resources Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . Ivy Learn D Question 3 14 pts If the student didn't do any of the online reviews, would this have affected their Account overall class grade? (Spelling/Grammar appropriate for a college level course accounts for 2 points of this score.) Dashboard Edit Insert Format Tools Table Courses 12pt w Paragraph " B I U Av QV Try : Calendar Inbox Search ? Resources p 0 words K-Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . Ivy Learn D Question 4 14 pts Account If the student could redo any assignment for a better score that is not an exam, what is the best grade possible in the course? If they improved all the assignments, could Dashboard this reach the next letter grade? (Spelling/Grammar appropriate for a college level course accounts for 2 points of this score.) Courses Edit Insert Format Tools Table Calendar 12pt w Paragraph ~ B I U A & TV : Inbox Search ? Resources K- P 0words > #Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! 4 ORGA . . . Ivy Learn D Question 5 14 pts Your instructor has decided to give the student a chance at extra credit. Pick one Account homework assignment. How many points of extra credit are needed to raise the student's overall letter grade? Is this a reasonable request for the student to ask for? Dashboard (Spelling/Grammar appropriate for a college level course accounts for 2 points of this score.) Courses Edit Insert Format Tools Table 12pt w Paragraph B J U A QV Try : Calendar Inbox Search ? Resources K- p 0 words >Quiz: Project 1 X + X > C A ivylearn.ivytech.edu/courses/1023730/quizzes/3038032/take S! ORGA . . . Ivy Learn p 0 words > Account Dashboard D Question 6 30 pts Courses For this question, you will need to upload your Excel worksheet used to answer the questions above. The Excel sheet is worth 30 points and graded from the following rubric: Calendar Inbox Labels on categories and values for each column or row (5 points) Category averages calculated using an Excel formula (10 points) Search Percentages/Weights shown in Excel (5 points) ? Final Course grade calculated or series of calculations shown to get answer using excel Resources formulas (10 points) Upload Choose a File K