Students get to research, plan, and design their own “Dream Bedroom” while learning basic budgeting and spreadsheet skills. This lesson will help them build smart consumer skills as well as learn how to budget money wisely.
Begin by engaging students in a whole-class discussion on bedroom “needs” vs “wants”. Agree as a class on the necessary purchases that must be made before “wants” can be considered. Students then visit websites to collect images of items for a dream bedroom space. Give them a budget and have them track how much each item costs using a Google Drive spreadsheet. Show them how to search online for the best price on bedroom items. Finally, help students make decisions about what they can afford. An optional extension is to have students collect the images of their Dream Bedroom items and showcase them in a multimedia project. Google Presentation, Google Drawing, LucidPress, and Canva are all good options for creating visual displays.
The Google Drive spreadsheet can be developed by the teacher and distributed via Google Classroom, or students can be asked to build it on their own. Advanced students can be challenged to use simple spreadsheet functions (=sum) to automatically calculate prices in each column.
• Google spreadsheet configured with necessary columns
• A list of bedroom “needs” (can develop this list as a class)
• A list of home furnishing websites for students to use (can develop as a class)
Lesson submitted by Mary Hankins, K-5 Technology Teacher, Owosso Public Schools, Michigan.
Download a free chapter of my book, The Chromebook Classroom!