Monthly budget spreadsheet
Formulas/complex formulas of monthly budget
Tuesday, May 19, 2015
Tuesday, May 5, 2015
investigation task
how did you get the project idea?
i got the project idea by going over what could be a good data table and i thought of a monthly budget giving me the data of what is paid ever month. i got the project idea by thinking what could be a good use of making a spreadsheet and i thought if i could make a spreadsheet knowing how much we spend each month that would be very useful, and i could get the information of how much was saved or wasted, that would be a goo spreadsheet idea, so that is how i got the idea of a monthly budget spreadsheet.
how will you gather the data?
since the data is about what our monthly budget is to gather the data and i will do that by asking my parents for what we pay for every month and note it down. To gather the data i would need to first come up with the categories that can go with a monthly budget and to find those topics i would search up the main uses monthly that we use to be able to put it in my spreadsheet. the topics i found that were the main uses each month and are the ones i will be using in my spreadsheet are:
and for each of them i will be asking my parent around how much is spent on each one of the categories each month, with that data i will be putting it in my spreadsheet and with the data i will calculate the total, the average and much more complex formulas.
what knowledge do you have on analyzing data and more do you need to learn to complete the project?
the knowledge i have on analyzing data is not that much but it is enough to achieve the analysis i need for the monthly budget data, the knowledge i have on analyzing data are the basics which are adding and multiplying data etc. and i don't think i would need anymore knowledge to complete my project. to get a higher level in my task i would need to learn more complex formulas and to get those formulas i would need to do some researching on different and complex formulas, and i could go on YouTube to learn the complex formulas and to learn how to do them on my spreadsheet.
how will the project be useful to me and to others?
the project will be useful for me to know what i could use less of to save money for more useful things, this can also be useful to my parents so they can now what their expenses are to see if they are short or fine. the project would be very useful as i could see how much was saved or how much was wasted in each month. also i could e able to find the total of the month and with the total i will be able to get the average. finally using the spreadsheet i can calculate the projected cost and the actual cost and then see the difference.
global context:
- personal and cultural expression
- orientation in time and space
i got the project idea by going over what could be a good data table and i thought of a monthly budget giving me the data of what is paid ever month. i got the project idea by thinking what could be a good use of making a spreadsheet and i thought if i could make a spreadsheet knowing how much we spend each month that would be very useful, and i could get the information of how much was saved or wasted, that would be a goo spreadsheet idea, so that is how i got the idea of a monthly budget spreadsheet.
how will you gather the data?
since the data is about what our monthly budget is to gather the data and i will do that by asking my parents for what we pay for every month and note it down. To gather the data i would need to first come up with the categories that can go with a monthly budget and to find those topics i would search up the main uses monthly that we use to be able to put it in my spreadsheet. the topics i found that were the main uses each month and are the ones i will be using in my spreadsheet are:
| rent |
| entertainmnet |
| food |
| gas |
| school |
| misc |
| savings |
| phone |
| housing |
what knowledge do you have on analyzing data and more do you need to learn to complete the project?
the knowledge i have on analyzing data is not that much but it is enough to achieve the analysis i need for the monthly budget data, the knowledge i have on analyzing data are the basics which are adding and multiplying data etc. and i don't think i would need anymore knowledge to complete my project. to get a higher level in my task i would need to learn more complex formulas and to get those formulas i would need to do some researching on different and complex formulas, and i could go on YouTube to learn the complex formulas and to learn how to do them on my spreadsheet.
how will the project be useful to me and to others?
the project will be useful for me to know what i could use less of to save money for more useful things, this can also be useful to my parents so they can now what their expenses are to see if they are short or fine. the project would be very useful as i could see how much was saved or how much was wasted in each month. also i could e able to find the total of the month and with the total i will be able to get the average. finally using the spreadsheet i can calculate the projected cost and the actual cost and then see the difference.
global context:
- personal and cultural expression
- orientation in time and space
Subscribe to:
Posts (Atom)