7th Grade Instructional Technology Excel Spreadsheets

The “Excelling with Excel” Beginner Lessons start students with no previous knowledge of Microsoft Excel on a path of learning the most important and frequently used commands to give them a quick start. Each lesson has a short, step-by-step tutorial that includes screenshots to walk students through the new tools they will use in the lesson. Then, they are given a creative task to solve, using those skills to create a spreadsheet. There are five lessons, each taking no more than two class periods.

Files Included with this Lesson

• Teacher Notes and Resources

• 5 Mini Lessons with Tutorial and Creative Project including rubrics

Versions of the lesson are included for MS Excel 2013/2016, and Office 365 (MS Excel 2019).

This lesson was created for middle school students (grades 6-8) but could also be used for upper elementary or high school 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.

Related Products
⭐ Excelling with Excel - Intermediate Tutorial & Activities
⭐ Pixel Art in Microsoft Excel
⭐ What Will My Car Cost? - A Project in Microsoft Excel
⭐ Stock Portfolio in Microsoft Excel
⭐ ReDesign Your Bedroom using Microsoft Excel

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!

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

The “What Will My Car Cost?” project allows students to build skills in Internet research and critical thinking as they research costs for a car and then compute and compare payment options using Microsoft Excel. First, students research the cost for two car options (one used and one new) and then compare financing and payment options for these using formulas in Microsoft Excel. The step-by-step directions were created for Microsoft Excel 2016, but could easily be used with earlier versions of the software. Editable templates and samples are provided for both Microsoft Excel 2016 and earlier versions (2007-2013).

The project was created for grades 7-8 but could easily be adapted for high school 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 Project Overview, Expectations & Rubric - Research & Excel Project

• Student Step-by-Step Guide - Excel Project

• MS Excel Template “What Will My Car Cost” Project for use in differentiation (Two Editable Microsoft Excel files with formulas – one for version 2016; one for earlier versions 2007-2013)

• Sample “What Will My Car Cost?” Project (Two Editable Microsoft Excel files with formulas – one for version 2016; one for earlier versions 2007-2013)

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

Follow us on Pinterest

Learning Google Sheets - Beginner Lessons start students with no previous knowledge of Google Sheets on a path of learning the most important and frequently used commands to give them a quick start. Each lesson has a short, step-by-step tutorial that includes screenshots to walk students through the new tools they will use in the lesson. Then, they are given a creative task to solve, using those skills to create a spreadsheet. There are five lessons, each taking no more than two class periods.

This lesson has been revised to be compatible with the latest version of Google Sheets (2-2020) and also includes the older instructions and resources that were included with the original lesson for previous purchasers who are re-downloading the lesson. The older lessons are included in their own folder within the .zip file.

This lesson was created for middle school (grades 6-8) but could also be used with upper elementary or high school 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

• 5 Mini Lessons with Tutorial and Creative Project including rubrics

Related Products
⭐ Learning Google Docs - Beginner Lessons
⭐ Learning Google Slides - 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

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

The “Excelling with Excel” Intermediate Activities let students continue their learning with Microsoft Excel to include more intermediate commands. This lesson assumes student already have beginner skills with Microsoft Excel including knowing these basic commands: entering and editing information, basic cell and text formatting, changing column width, creating a basic formula (SUM, AVERAGE, basic math), adding a row or column, changing page settings, printing, and creating a basic chart/graph. If students have not yet mastered these skills, you may want to start with Excelling with Excel – Beginner Activities, available at: https://www.TeachShare.com/Product/Excelling-with-Excel-Beginner-Activities-1939780

Each lesson has a short, step-by-step tutorial that includes screenshots to walk students through the new tools they will use in the lesson. Then, they are given a creative task to solve, using those skills to create a spreadsheet. There are four lessons, each taking no more than two class periods.

Versions of the lesson are included for MS Excel 2013/2016, and Office 365 (MS Excel 2019).

This lesson was created for middle school students (grades 6-8) but could also be used for upper elementary or high school students.

These lessons were created for middle school students (grades 6-8) but could also be used with upper elementary and high school 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

• 4 Mini Lessons with Tutorial and Creative Project including grading rubrics

• Fully Editable Sample Microsoft Excel Worksheet for each lesson

Related Products
⭐ Excelling with Excel - Beginner 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

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