7th Grade Instructional Technology Excel Spreadsheets

Redesign a Bedroom using Microsoft Excel gives students an opportunity to research items to totally redesign their bedroom and then, working with a given budget, to create a Microsoft Excel spreadsheet budget of those items. This is a great project to do with students who have a beginning knowledge of Microsoft Excel to reinforce those skills. It can also be used successfully with students who have no knowledge of Microsoft Excel if it is preceded by some basic tutorials (links included below). This project was designed to also build skills in Internet research, reading, writing and critical thinking.

The project was created for grades 7-8 but could easily be adapted for younger or older students.

This lesson is great for distance learning/remote learning. You can upload it to your school's learning management system (Google Classroom, Edmodo, Canvas, etc.) or share with students via Google Drive.

Files Included with this Lesson

• Teacher Notes and Resources

• Student Expectations & Rubric - Research & Excel Budget Project

• Re-Design a Bedroom Planning Research Worksheet

• Sample Bedroom Redesign Budget Project in Excel

• Sample Excel Spreadsheet with Formulas

Related Products
⭐ Excelling with Excel - Beginner Activities
⭐ Excelling with Excel - Intermediate Tutorial & Activities

Remember to leave feedback for credits on future purchases!

**************************************************************************

Connect with us for free technology tips, resources and curriculum:

Follow our blog

Follow us on Facebook

Here are 75 EXCEL Shortcuts presented in 18x24 poster format. Each shortcut is it's own poster! Print them full size for hanging around your classroom OR print them as 8.5x11 to use for a bulletin board.

65 Shortcuts using the "CTRL" Key!

6 Shortcuts using the "ALT" Key!

4 Shortcuts using the "SHIFT" Key!

Teach the basics of computer hardware and software while letting students explore what's inside the computer! This unit helps students explore and understand the basic components inside the computer. This is perfect for any technology class in upper elementary or middle school. All files provided are fully editable, allowing teachers to make modifications for differentiation or personalization if they choose.

A Microsoft PowerPoint presentation (fully editable) is included to introduce the topic to the class and can be used as a whole class presentation or provided to students to explore on their own. The first part of the assignment involves students identifying and defining the parts of the computer, using either MS PowerPoint or Google Slides to create a presentation. Next, students research specific computer hardware components and “build” two different computers, using either MS Excel or Google Sheets, and remaining within a given budget. A template in Excel that can also be opened in Sheets is provided. Teacher and student resources are included with instructions, sites for research and lesson extension ideas. A basic grading rubric for each project, is also included.

The projects can be completed individually, or students can work in pairs. These projects were created for grades 7-8 but could also be used with upper elementary students.

Materials Required

· Access to computers for each student (or small group)

· Internet access

· Microsoft PowerPoint and Excel OR Google Slides and Sheets

Project Duration (approximate, per topic)

· PowerPoint presentation: .5-1 (50 minute) class period

· Definitions – Student Presentation project: 1-2 (50 minute) class periods

· Research and “Build” Computers project: 2 (50 minute) class periods

Files Included with this Lesson

· Teacher & Student Notes and Resources

· Computer Components PowerPoint Presentation (editable)

· Student Definitions Presentation Project Expectations & Grading Rubric (editable)

· “Build a Computer” Project Student Expectations & Grading Rubric (editable)

· MS Excel Template for project – can be opened in Google Sheets (editable)

My 7th and 8th graders loved this project - particularly when they got to take apart and reassemble old computers that were donated to us at the end of the unit! I hope your students enjoy it as well.

This lesson is great for distance learning/remote learning. You can upload it to your school's learning management system (Google Classroom, Edmodo, Canvas, etc.) or share with students via Google Drive.

Related Products
⭐ Exploring Careers: Information Technology
⭐ History of Computers - Group Research & Presentation Project
⭐ Webquest Scavenger Hunt - History of Computers

Remember to leave feedback for credits on future purchases!

**************************************************************************

Connect with us for free technology tips, resources and curriculum:

Follow our blog

Follow us on Facebook

Who doesn't love to travel? Engage students as they plan a vacation to their dream destination.

The “Plan a Vacation” project utilizes either MS Office (Word and Excel) or Google Apps/Workspace (Docs, Sheets) to allow students to build skills in those programs along with skills in Internet research, reading, writing and critical thinking. In these projects, students research a vacation destination of their choice and complete a research sheet using MS Word or Google Docs. They utilize either MS Excel or Google Sheets to create a budget for their trip, and finally create a tri-fold Travel Brochure using a choice of MS Word, Google Docs, or Canva (www.canva.com) to share information about their chosen destination. Full instructions and grading rubrics are provided for each portion of the project, along with a sample budget spreadsheet (and answer key), and a sample brochure. Links to tutorials for all programs are provided in the student resources section, and a Quick Start Guide for Canva is also included.

The project was created for grades 7-8 but could easily be adapted for younger or older students.

Materials Required

· Access to computers for each student (or pair of students) with Internet and either MS Office (Word, Excel) or Google Apps/Workspace (Docs, Sheets).

· Sample travel brochures (optional) for ideas on layout

Project Duration (approximate)

· Research: 2 (50 minute) class periods

· Spreadsheet creation: 2 (50 minute) class periods

· Travel brochure: 2-3 (50 minute) class periods

Files Included with this Lesson

· Teacher Notes and Resources

· Student Expectations & Rubric - Research & Budget Project

· Student Expectations & Rubric – Creating a Travel Brochure

· Vacation Planning Research Worksheet

· Sample Vacation Budget Project (with formula key)

· Travel Brochure Sample

· Canva Quick Start Guide

This lesson is great for distance learning/remote learning. You can upload it to your school's learning management system (Google Classroom, Edmodo, Canvas, etc.) or share with students via Google Drive.

I hope your students love it as much as mine did!

Related Products
⭐ Exploring Careers: Hospitality & Tourism
⭐ Excelling with Excel - Beginner Activities
⭐ Learning to Use Microsoft Word - Beginner Lessons

Remember to leave feedback for credits on future purchases!

**************************************************************************

Connect with us for free technology tips, resources and curriculum:

Follow our blog

Follow us on Facebook