Material Detail

How to Budget for a Trip using Google Spreadsheets

How to Budget for a Trip using Google Spreadsheets

This interactive presentation will guide your students in learning how to use Google Spreadsheets to create and organize a budget for a trip (real or fake). The HOW TO includes creating a Google Spreadsheet, naming it, sharing it, creating a new sheet & renaming it, using the SUM function, and using the TRANSPOSE function. It also includes how to stay organized when budgeting for a trip by giving two options for the students to keep the...

Show More


  • User Rating
  • Comments  (4) Comments
  • Learning Exercises
  • Bookmark Collections
  • Course ePortfolios
  • Accessibility Info

More about this material


Log in to participate in the discussions or sign up if you are not already a MERLOT member.
Sarah Horan
Sarah Horan (Teacher (K-12))
9 years ago

I really liked your presentation.  It was nice that the students had choice in their option- not all students think and organize information the same so that was a nice added feature.  The video tutorials you created within the Option 1 and Option 2 instructions were great.  A nice feature to add would be to have some similar instruction videos in the introduction section where students are learning how to use Google Drive and Spreadsheets.  It was nice to have the option to learn directly from Google as well, though.  

I really liked to overall look of the project as well.  It creates a user friendly feel and I think kids would take to it easily.  A suggestion I have is to add something at the end that finishes the project.  I wasn't sure when the project was done; I had to check the slide I was on to see if I was finished or not.  

Technical Remarks:

Very easy to use.  Each of the tutorials are linked back to the home screen which is helpful. 

Time spent reviewing site: 20 minutes
Marcy Hyde
Marcy Hyde (Teacher (K-12))
9 years ago

This resource provides the student with so much detail in working with Google Drive and creating a spreadsheet. A student could easily work through this lesson on their own. While this resource is geared towards a specific type of budget, the skills learned are easily transferrable to other types of budgets and the real world.

Technical Remarks:

Easy to navigate

Time spent reviewing site: 15 minutes
Kareem Jabbar Downer-Shojgreen
9 years ago

The information provided is very precise and technical, and the detail used in this presentation is phenomenal, I truly enjoyed going back and forth using this wonderful tool. I just wish I had a place to go. I liked the fact that I was learning multiple aspects of a spreadsheet I like the pictures provided with the information. Also, traveling back and fourth using the links was easy.  

I know that student would not be able to use this resource without previous experience as comfortably as an adult, so, it would be nice it they had a tutorial video or lesson. 


Technical Remarks:

No problems

Time spent reviewing site: 20
Andrea Colville
Andrea Colville (Student)
9 years ago

This is a very neat idea for students to learn Google Spreadsheets. The powerpoint contains links that work and gives great examples for each step. The information is very detailed with pictures.

It is very technical and there is a lot going on, on the slides. It would be nice if the students had an opportunity or links to watch a video explaining it as an added resource. It also does not include feedback or an explanation of how the students will be evaluated on their task.

Technical Remarks:

Students will need a computer that has Microsoft Powerpoint.

Time spent reviewing site: 10 Minutes