Lesson 3: Budget and planning
The Learning Objective for this Lesson will be:
1. I can create identify what basic needs must be met to travel to a foreign country through the creation of a basic budget.
For this Part of the Project, you will be using Google Docs, Microsoft Word, or your Note cards to plan what you will need as far as basic needs for the trip. You will also be learning how to use Microsoft Excel, which is a Spreadsheet program, to help you plot out your budget.
A budget, for the purposes of this project, shall be defined as a sum of money set aside or allowed for a particular purpose. In this case, the purpose is to take a trip to a European country.
1. I can create identify what basic needs must be met to travel to a foreign country through the creation of a basic budget.
For this Part of the Project, you will be using Google Docs, Microsoft Word, or your Note cards to plan what you will need as far as basic needs for the trip. You will also be learning how to use Microsoft Excel, which is a Spreadsheet program, to help you plot out your budget.
A budget, for the purposes of this project, shall be defined as a sum of money set aside or allowed for a particular purpose. In this case, the purpose is to take a trip to a European country.
The Project
Planning what you want to do when you get there is great, but nothing in this world, they say, is FREE. So, you will need to come up with a budget plan to show the Principal what you would do with the money the Principal is giving you and how it is being spent.
Every business uses budgets. Even our Government uses a budget! It shows everyone how money is being spent and ensures that, by reporting it, everyone who contributes money to that organization is aware of what their money is used for. People like you and me use budgets to make sure that they are able to pay the bills and not get into trouble should expenses that cannot be foreseen (such as car repairs, or unexpected medical bills) can be paid for. Many people use budgets. Here is an example of what a basic budget looks like:
Every business uses budgets. Even our Government uses a budget! It shows everyone how money is being spent and ensures that, by reporting it, everyone who contributes money to that organization is aware of what their money is used for. People like you and me use budgets to make sure that they are able to pay the bills and not get into trouble should expenses that cannot be foreseen (such as car repairs, or unexpected medical bills) can be paid for. Many people use budgets. Here is an example of what a basic budget looks like:
Your group's Chief Logistical Officer has the job to create your group's budget plan in a similar fashion. You will be allowed to look up as much information as you may need, even utilizing popular travel websites like Travelocity, Orbitz, or Expedia to find travel expenses such as airfare and hotels. You will have to operate under an overall budget of $6,000 per group of four.
You will also need to plan any unique items you will need to bring to your European country. What kinds of things do you need in order to travel to another country? Here's a website to help you get started: Click Here.
You will also need to plan any unique items you will need to bring to your European country. What kinds of things do you need in order to travel to another country? Here's a website to help you get started: Click Here.
Introduction to Microsoft Excel
Watch this introductory video on Microsoft Excel to refresh your memory from our class tutorial:
REMEMBER: This tutorial is a useful tool to show you the tips and tricks we will use for Excel. It does have some features that we will not use for this project. If this causes any confusion, please email me or speak to me at school!
The Assignment
For today's assessment, each group member will create an Excel Spreadsheet and use the features described in class. You will then submit your project to the dropbox below.
The budgetary numbers:
Here's the information you will need to include for your assignment. Remember, numbers go in one column and the headings go in the other (see the picture above for proper set up).
Title: Omaha Fun Day
Food
Lunch for group: $26.94
Snacks for group: $12.53
Dinner for group: $44.98
Entertainment:
Zoo Admission for group: $50.00
Skyfari Tickets: $8.00
Video Games for Group members: $365.72
CoCo Keys: $179.00
Transportation:
Zoo Trip: $25.00
All other Transportation: $71.79
When finished, follow the following directions to save and submit your assignment. You will be able to view this process in the screencast below:
Step 1: When finished, click "Save As" and name your file as "YourLastNameXL.xlsx" ex: "LevittXL.xlsx"
Step 2: Make sure the "Desktop" is selected, not "Documents." This will ensure you will be able to find it easier when you submit it.
Step 3: Click "Save" in the bottom right corner.
Step 4: Exit out of Excel
Step 5: Open to this course page.
Step 6: Fill out the form below the screencast
Step 7: Click the "Browse" Button
Step 8: Select your file and click "OK"
Step 9: Click "Submit" on the Weebly page.
Remember: The screencast below will walk you through the process step by step!
Good Luck!
The budgetary numbers:
Here's the information you will need to include for your assignment. Remember, numbers go in one column and the headings go in the other (see the picture above for proper set up).
Title: Omaha Fun Day
Food
Lunch for group: $26.94
Snacks for group: $12.53
Dinner for group: $44.98
Entertainment:
Zoo Admission for group: $50.00
Skyfari Tickets: $8.00
Video Games for Group members: $365.72
CoCo Keys: $179.00
Transportation:
Zoo Trip: $25.00
All other Transportation: $71.79
When finished, follow the following directions to save and submit your assignment. You will be able to view this process in the screencast below:
Step 1: When finished, click "Save As" and name your file as "YourLastNameXL.xlsx" ex: "LevittXL.xlsx"
Step 2: Make sure the "Desktop" is selected, not "Documents." This will ensure you will be able to find it easier when you submit it.
Step 3: Click "Save" in the bottom right corner.
Step 4: Exit out of Excel
Step 5: Open to this course page.
Step 6: Fill out the form below the screencast
Step 7: Click the "Browse" Button
Step 8: Select your file and click "OK"
Step 9: Click "Submit" on the Weebly page.
Remember: The screencast below will walk you through the process step by step!
Good Luck!