uploaded instructions. Two spreadsheets are required can be one spread sheet with two sheets/tabs If you could write the reflection separate. doesn’t need to follow any format. thank you! MTH 154: Project part I Calculating Your Grade Project Directions: In this project you will create a spreadsheet which keeps track of your grade in this Math 154 class. In addition to simply recording all of your grades for the course, it will provide you with a running tally of how you are doing in the course at any point in time during the semester. 1. What does running tally mean? To help you understand this, compute the grade of a student with an 82 MyMathLab Homework average, 84 Activities average, 73 Quiz average, a 92 on Project 1 and a 93 on Test 1 (label the cell sample student average). Use the syllabus to determine the appropriate weights for each category and enter a formula in a spreadsheet to compute their grade. Re-compute their grade assuming they get a 95 on Project part 2. Insert a textbox into the spreadsheet and record both grades in the textbox. Are you surprised by their grades? Explain what weights dominate at this point in the semester. 2. Create a new sheet (tab) in the spreadsheet from part 1 which will allow you to enter all of your grades for this Math 154 course. Enter all your current grades for MyMathLab Homework, Activities, Quizzes, and Tests you already have. Enter a grade of 90% for Project 1. There should be nicely labeled spaces for all of the following work: Assume there will be 31 MyMathLab Homework assignments. Assume there will be 6 Activities. Assume there will be 6 Quizzes. There will be 2 Projects. There will be 3 Tests. 4. Create cells which will count the number of MyMathLab Homework grades entered so far, count the number of Activities grades, and count the number of Quiz grades. Name these cells appropriately. 5. Create cells which will compute the max and min grades for each of the 5 categories: MyMathLab Homework, Activities, Quiz, Project, and Test. 6. Create a C MTH 154: Project Part II- Yearly Budget Project Directions: Construct a budget sheet that assists you in analyzing your financial status, set goals, make changes, whatever the case may be. This project will have more meaning to you the more it reflects your real life. You can use this to create a budget for your future life based on your plans of a future job, future housing, expenses, etc. I assure you that, should you choose to include personal values, I will be assessing your work only on if it was accurately represented and interpreted. Please work to be realistic so you can gain from the experience. There will never be any judgement made on my part nor any information shared out. Your sheet should address both regular and unexpected monthly expenses, necessities and luxuries, and any debts/savings plans. Your first sheet should create a baseline budget of your expenses (list what you spend/think you will spend each month for each category without regard to if you balance) and then create monthly and yearly budget as well as totals by category. You should have a minimum of 10 to 15 categories with amounts for each month as well as monthly and yearly totals. Your second sheet should be a tracking sheet for each category that tracks your expenses for each month of one year. In sheet two enter your data for three months and leave space for entering data for the rest of the year (these can be left blank). You should have space to enter the date and each expense under the category and month. You should have totals by category (both month and year) as well as monthly totals and a year to date total. Totals will currently only reflect your three months you entered but should update automatically if you add data for the remaining months. These totals should then be compared to your planned budget in sheet one by category and month. Sheet three will be your reflection as described below. Provide visually appealing formatting to allow for quick differentiation among the categories and months and for quick location of individual items. Provide visually appealing and correct formatting to allow for ease of data entry without disrupting the form or function of sheet one and two. (What if electrical budget is changed from $150 to $125 a month? What if you have to add another gas receipt for January?) Accurately calculate your totals in each category in dollars for each month on sheet two. Accurately calculate your totals in each category in dollars and percentage of total for the year on both sheet one and sheet two. Accurately calculate your expenses and savings as new items are added to sheet two. Create two charts on sheet one that compare expenses by month and by category. Create a chart sheet two that compares actual expenses to budget amounts. Reflection: The reflection must be completed in Canvas. Module 3: Project 2 Reflection Requires Respondus LockDown Browser + Webcam.
