Budget

= Budget = Objective : Students will understand how a carefully planned, financial decision-making process leads to making sound personal economic decisions. Prior to assignment:  Students will read and understand **Section 1.1 Financial Decisions and Goals**, p.6-18.//Business and Personal Finance.//  Students will understand Lessons 1 through 4 of //Microsoft Office, Excel 2003.//   Teachers will assign each student a Username, Password and Team #.  Students will review the Rubric for the assignment. Assignment:  You are a college student living in an apartment with a roommate (your partner in this assignment). You and your partner will plan a monthly budget.  Individually you will report on the importance of making sound personal economic decisions and planning your spendig. Process:
 * 1) Collaborate with your partner using the **Discussion** tab.
 * 2)  Research and discuss expenses specific to the personal spending habits of you and your partner.
 * 3) Assume that you both have jobs and are sharing an apartment.
 * 4) Research an image that represents one of your monthly expenses. Post in the Monthly Budget Table.
 * 5) Using Excel, prepare a Monthly Budget including Monthly Income, Payroll Deductions, Take-home Pay, Fixed Monthly Expenses, Variable Monthly Expenses, Discretionary Monthly Expenses, Total Expenses, Income Less Expenses.
 * See the Monthly Budget Worksheet on p. 12, Document Detective, //Business and Personal Finance.//
 * Post the Excel Monthly Budget spreadsheet in the Monthly Budget Table (see Excel directions below).
 * 1) **Individually**, prepare a one-page report, print and turn in your report to your teacher. Include the following:
 *  Discuss your Monthly Budget, the importance of making sound personal economic decisions and planning your spending.
 *  Include a paragraph with comments about using the BizTeam Wiki and collaborating with a student from another school.

Discussion Directions: Your teacher will assign you a Team #. Click on the **Discussion** tab above and locate your Team #. Use this Discussion forum to introduce yourself to your partner and discuss the project.

Image Directions:
 * Using flickrCC, find an image that represents one of your monthly expenses such as food. Before leaving the flickrCC site, right click and copy the URL (under Attribution).
 * In flickrCC, right click, Save Picture As, My Documents, My Pictures.
 * Click on **Edit** (top right). Click on **File** (above between Link and Widget), click on **Upload Files** (navigate to where you saved the image),
 * When uploaded, click on the image and a box will appear. Under **Caption**, paste the URL you copied for the image. The image will appear on the wiki. You may need to cut and paste it in the **Image** column in the Monthly Budget Table.
 * Save

Excel Directions: Note: The following is a sample only of the format. Click on your Team # below to go to the page for your Monthly Budget Table. Click on your Team # below to go to the page for your Monthly Budget Table. @Team 1
 * Format and organize the Excel spreadsheet in an attractive manner. Use formulas for calculations.
 * Save your file as Monthly BudgetYOURFIRSTNAME in My Documents.
 * Note: One partner may start the assignment and the other partner may finish it. Show both versions (see below).
 * Click on **Edit** (top right). Click on **File** (above between Link and Widget), click on **Upload Files** (navigate to where you saved the image),
 * When uploaded, click on the File. The image will appear on the wiki. You may need to cut and paste it in the **Excel Spreadsheet** column in the Monthly Budget Table.
 * Save
 * ~ Sample MONTHLY BUDGET TABLE ||~  ||
 * **Team #** || **Excel Spreadsheet Student #1 Excel Spreadsheet Student #2** || **Image** ||
 * Team # || [[file:Monthly BudgetBILL.xls]][[file:Monthly BudgetJOHN.xls]] || [[image:food.jpg caption="www.flickr.com/photos/53611153@N00/3575485015"]] ||

@Team 2

@Team 3

@Team 4

@Team 5

Team 6

@Team 7

@Team 8

@Team 9

Team 10

@Team 11

@Team 12

@Team 13

@Team 14

@Team 15

@Team 16

@Team 17

@Team 18

@Team 19

@Team 20

@Team 21

@Team 22

@Team 23

@Team 24