1 / 23

How to Budget a Trip Using Google Spreadsheets

Home. How to Budget a Trip Using Google Spreadsheets. Cinader 2013. Student Goals. Home. Student Goals : . As the student, you will use the PowerPoint to help you learn to budget your trip

goldy
Download Presentation

How to Budget a Trip Using Google Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Home How to Budget a TripUsing Google Spreadsheets Cinader 2013 Student Goals

  2. Home Student Goals : • As the student, you will use the PowerPoint to help you learn to budget your trip • You will need to make a Google Spreadsheet where you will keep your information. This needs to be shared with Madame (nbildson@bloomfield.org) and with your partner. • Within the spreadsheet, you will learn to use tabs, to use equations

  3. Student Goals Home Page Home Don’t need the basics? Click here to decide how you want to organize your spreadsheet: Option 1 or 2? • Option 2 Summary • Day 1 Basic HOW TO for Google Spreadsheets Budget Option 2 Budget Option 1 • Day 2 • Day 3 • Option 1 Summary • Itinerary Outline • Access Drive • Name Spreadsheet • Food • Transportation • Share a Document • Day 4 • Total Budget • Create/Rename Sheet • Functions Intro • Lodging • Tourist Costs • SUM function video • TRANSPOSE video • Total Budget • Format #/currency

  4. Home BasicsAccess Google Drive • Log in to your Google account • Click on Google Drive or just“Drive” at the top, black bar • Open a Google Spreadsheetby selecting the “CREATE”button on the top left of your screen; then select “Spreadsheet” Want help directly from Google to start a Spreadsheet? Click here.

  5. Home BasicsGoogle Spreadsheet Introduction Click here to rename your spread to the name of your region, plus your last name (and your partner’s) Example title:“Bretagne.Cinader.Bildson” Want help directly from Google to start a Spreadsheet? Click here.

  6. Home Want Google’s explanation instead? Click here. BasicsHow to Share a Google Document • On the top RIGHT corner, click the blue “Share” button • A screen will pop up labeled “Sharing settings” • Go to the bottom and “add people” by typing in their email addresses. Please ensure that you give them the proper ability to either EDIT or VIEW using the dropdown menu on the right • You may notify people via email and include a message. To notify me, ensure the box next to notify is selected, and please include the name of your region & your name(s) in the message area • Don’t forget to select “Share & save” and then the blue button “done” to finalize the process

  7. Home BasicsCreating & Renaming Sheets • To rename a sheet, click on the down arrow next to the tab, and select “Rename…” from the dropdown box. • To create a sheet, simply move your mouse down to the very bottom LEFT of your window and click on the + button. An additional sheet will instantly show up next to the default “Sheet1” as seen here.

  8. Home BasicsUsing Spreadsheet Functions Google Spreadsheets complete Function List • Using Functions is easy! You select the spread you want to use a function in, and you start with the equal sign, plus whatever code word you need to do the trick you want done! Sounds confusing, but it isn’t. • Example: =SUM(21+24) By typing this in, the spreadsheet does the work for you and calculates the total of the two numbers in your cell. • How should you use functions? • To total each Sheet on your document • To find a total number on your Final Budget Sheet SUM TRANSPOSE

  9. Home BasicsFormatting Number/Currency • On the main tab section of your spreadsheet document,select the Format tab • Then click on Number • And Choose “More Currencies” • You will have the option of EUROS, please use this for all cells that include monetary numbers, since your assignment is to use euros and not the dollar.

  10. Home Decision Time! • You will need to decide how you are going to organize your budget. This is where your Google Spreadsheet comes into play. • Below there are two options. I highly suggest exploring and attempting both of the options.. You may end up using both of them, if you and your partner work differently; this is OK! You can then use the two as a system of “checks” to keep your budget balanced. Note! Your overall budget is very important for this assignment. Don’t forget to be responsible with your money! You are not un-limited! 1 2

  11. Home Budget Option #1 • You want to ensure that you know exactly how you are spending your budget by separating out the categories. Your brain doesn’t like to mix up the budget with the itinerary. • If this is you, click the arrow button to go through each slide which separates out the budget into four categories. You will make six “pages” on your Google Spreadsheet. • Overall Itinerary • Food • Transportation • Lodging • Tourist Expenses • Total Cost 1 If this does not sound like you, you should explore Budget Option #2. Click the box below. 2

  12. Trans Lodg Tour Total Home Food BUDGET 1 - Itinerary • On your Google Spreadsheet, this replaces “Sheet1”. You should rename it “Itinerary” • Label the columns as I have done so. • This is the place where you will keep your itinerary organized, which will also keep your budget organized. • The events should be organized in chronological order.

  13. Trans Lodg Tour Total Home Itiner BUDGET 1 - Food How do I use a spreadsheet function to make this box keep a running total? How do I format this cell for EUROS?

  14. Food Lodg Tour Total Home Itiner BUDGET 1 - Transportation SUM function? format for EUROS?

  15. Food Trans Tour Total Home Itiner BUDGET 1 - Lodging SUM function? format for EUROS?

  16. Food Trans Lodg Total Home Itiner BUDGET 1 - Tourist Note! You may not have anything in this spreadsheet. SUM function? format for EUROS?

  17. Food Trans Lodg Tour Home Itiner BUDGET 1 – Total Budget How do I use the TRANSPOSE function to copy the totals from these sheets? SUM function? format for EUROS?

  18. Home Budget Option #2 • Do you need to keep all of the events in order? Do you want to organize this trip day-by-day? Do you not care how you spend your money, so long as you stay within budget and get to do everything you want? Then option #2 is right for you! It is separated out by day (4 pages, one for each day). Each day is then totaled on the final page so you can determine how much you are spending each day, not by category. D3 D1 D2 #1 If this does not sound like you, you should go back to Budget Option #1. Click the arrow. D4 $$

  19. Home BUDGET 2 – Day 1 2 3 4 $ How do I use a spreadsheet function to make this box keep a running total? How do I format this cell for EUROS?

  20. Home BUDGET 2 – Day 2 1 4 3 $ SUM function? format for EUROS?

  21. Home BUDGET 2 – Day 3 1 2 4 $ SUM function? format for EUROS?

  22. Home BUDGET 2 – Day 4 1 2 3 $ SUM function? format for EUROS?

  23. Home BUDGET 2 – Total Budget 1 2 3 4 How do I use the TRANSPOSE function to copy the totals from these sheets? SUM function? format for EUROS?

More Related