MTH 154: Quantitative Reasoning Project ff 1- Yearly Budget Due Date: Thursday, July 22 Obiectives: Students in MTH 154 are required to: Use mathematical methods of analysis to understand the requirements of a problem, create an equation or program that allows prediction and interpretation of quantitative elements of the problem and solution (including limitations of each), and critique the resulting mathematical model for accuracy and validity. Assemble measurements and data gathered into tables, displays, charts, and simple graphs. Starting with a verbally described requirement, generate an appropriate mathematical approach to creating a useful mathematical model for analysis. Proiect Directions: This project will have more meaning to you the more it reflects your real life. However, I am not asking to provide me with your personal information. 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. 0 Construct a budget sheet that assists you in analyzing your financial status, set goals, make changes, whatever the case may be. 0 Your sheet should address both regular and unexpected monthly expenses, necessities and luxuries, and any debts/savings plans. 0 Your first sheet should create a baseline budget of your \"current/future\" expenses (list what you spend/think you will spend each month for each category without regard to if you balance) and then make adjustments to your allotments to create a balanced monthly and yearly budget or one that is more comfortable. 0 Your second sheet should be a monthly tracking sheet for each category that tracks your expenses for one year and com pares your actual expenses to your planned budget by category and month. In sheet two enter your first few months you have tracked and continue to track for the next few months. 0 Sheet 3 will be your reflection as described below. 0 Provide visually appealing formatting to allow for quick differentiation among the categories and for quick location of individual budget items. 0 Provide visually appealing and correct formatting to allow for ease of data entry without disrupting the form or function of the budget. (What if electrical is $150 not $125 a month?) 0 Accurately calculate your totals in each category in dollars and percentage of total. (So how much spent on groceries in year?) o Accurately calculate your final expenses and savings as new credits/debits are added to the table. 0 Create one or two charts (graphs) on each sheet that show the budget trends such as expenses and deposits or categories and months. Reflection: Paragraph I What did you learn from this process of creating a sheet to model something in your world? Talk about successes and struggles while doing the project. Paragraph II In what other ways in your life might you create another sheet to help you make decisions? Paragraph Ill Analyze your situation. What do your graphs and tables tell you about your financial habits? Where do you see the need for change? What barriers were there to balancing your budget? Grading: Budget Sheet Annual balanced budget - 40 pts Budget Sheet Tracking monthly expenses - 40 pts Reection Paper -20 pts Rubric: Excel File Formatting and Labeling: Differentiation among the categories and quick location of a specific assignment Layout, Borders, Background color, Font, Font size, and Font style all work to differentiate between each category and the final score calculations. Assignments are separated according to category by formatting. The use of, Borders, Background color, Font, Font size, and Font style are mostly effective to differentiate between each category and the final grade calculation, but there is some visual confusion about the layout. The use of, Borders, Background color, Font, Font size, and Font style are somewhat effective to differentiate between each category and the final grade calculation, but there is a noticeable visual The use of, Borders, Background color, Font, Font size, and Font style are barely effective to differentiate between each category and the nal grade calculation, and there is a great deal of visual The use of, Borders, Background color, Font, Font size, and Font style are not effective to differentiate between each category and the final grade calculation, and the layout is disorganized and hard to use. The Assignments are hard to Spreadsheet layout makes any and all assignment location easy. Some hunting is required to locate a specific Assignment, or the labeling ofthe Assignment is vague or inaccurate. confusion about the layout. Some hunting is required to locate several specific Assignments, or the labeling of the Assignments are vague or inaccurate. confusion about the layout. Most Assignments are mislabeled or vaguely labeled and a great deal of hunting is required to located most assignments impossible to differentiate from each other. Formatting: Ease of Data Entry Accuracy of assignment and category totals Accuracy of the Final Budget Values Entry of data is easy, cell has correct formatting, and does not cause disruption in the form or function of the workbook. Each individual entry properly displayed and the Category Total accurately reflects the updates to additional and modified entries. The Final Budget Values are computed correctly and reflect the updates to additional and modified Data is easy to enter, but some cells do not have proper formatting for the data. The form or function of the workbook is not disrupted. The Category Total is missing or inaccurate for one or two categories. There are no conditions under which the accuracy of the final total ever deviates more The form or function of the workbook is disrupted when some data is entered and some cells do not have the proper formatting. The category totals are missing or inaccurate for 3 categories. There are conditions under which the accuracy of the final total It is very challenging to enter data due to inappropriate formatting or shifts in the form. At least three categories are accurate in value and display. There are conditions under which the accuracy of the nal total The sheet does not function properly, making data entry almost impossible. This can be due to formatting issues or issues with the layout. Less than three categories are accurate in value and display. There are conditions under which the final total is in error greater than 10% of the individual than 3% from deviates deviates true total. entries. the between 3%% between 6% true value. and 6% from and 10% from the true value. the true value/ Make one or The charts are The chart(s) The chart(s) The chart(s) The chart(s) two charts completely is(are is(are) missing is(are) missing is(are) missing labeled, missing a two or more two or more three or more including legend or labels or abels or a labels. axes, title and one of the axis legend. legend legend. They has and the chart accurately not been does not reflect labeled. accurately the data in the reflect two indicated the data in the categories. two indicated categories. Reflection 6 4 2 Paragraph I Reflection is Reflection is Reflection is No reflection well written with written with submitted Paragraph II written in poor poor No reflection organization organization or organization submitted Paragraph III and lacking and No reflection Overall grammatical grammatical lacking submitted impression: structure structure. grammatical 2 pts - solid Demonstrate Demonstrate structure. effort evident bot some Demonstrate 0 pts - no deep thought thought and little thought reflection and comprehensive and comprehensive overview of no overview overview of the of the project. the project. project