9th Grade Computer Science & Technology Excel Spreadsheets

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

Give middle school students a chance to learn more about careers and business as they work with a team to create their own teen business!

This unit focuses on students exploring many of the aspects of creating their own business and introduces some of the day-to-day requirements of that business. Students choose a business with their team, prepare a business plan, advertising materials and a budget and finally reflect on their learning utilizing a variety of MS Office products or Google Products, and a choice of a variety of free Web 2.0 tools such as Audacity, Paint, Canva, Adobe Express and others specified in each section of the lesson. Students can choose from available software options, or the teacher can specify which software they should use for each project.

Files Included with this Lesson (all fully editable)

· Teacher & Student Resources

· Overview of the Unit for Teachers & Students

· Project Planning and Grading Sheet – Teacher

· Project Planning Sheet – Students

· Team Sign Up Sheet

· Student Expectations and Grading Rubrics for:

o Business Plan

o Logo

o Business card/letterhead

o Tri-fold Brochure

o Budget

o Sales Presentation

o Advertising (print and audio/video)

o Reflection Essay

· Sample Budget project (MS Excel)

· Quick Start Guide - Audacity

· Quick Start Guide - Canva

I've used this with 7th and 8th graders and they love having a chance to think about turning one of their passions into an actual money-making business.

Related Products
⭐ Famous Entrepreneurs and Their Impact on Society - Research & PowerPoint Project
⭐ Exploring Careers: Business, Management & Administration
⭐ Real World Math - How Math is Used in Business, Management & Admin. Careers

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

Real Estate Career Simulation: Flip a House Project lets middle schoolers see how real estate investors purchase, improve, and resell homes for a profit. Utilizing Microsoft Word and Excel, students “purchase” a home of choice from a list and then determine the improvements they want to make to it, all while staying within their budget. Then, they design the home, using Web 2.0 tools (www.floorplanner.com or www.homestyler.com ) or Sketchup (a free download available at: http://www.sketchup.com/download ). Finally, students use Microsoft Word to prepare a one-page sale flyer for their renovated home. Note: This lesson is intended for beginning Excel users and was created using Microsoft Excel 2016. It is easily adaptable for different versions.

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

• Home Purchase & Improvement Choices Lesson Instructions, Expectations and Grading Rubric

• Choices Worksheet (editable Microsoft Word version and .pdf)

• Excel Budget Creation Lesson Instructions, Expectations and Grading Rubric

• Excel Budget Sample (editable Microsoft Excel file and .pdf)

• Floor Plan Creation and House Design Project Instructions, Expectations and Grading Rubric

• Floor Plan and Design Samples

• Selling Brochure Project Instructions, Expectations and Grading Rubric

• Sample Brochure

Related Products
⭐ Exploring Careers: Architecture & Construction
⭐ Exploring Careers: Landscape Architect - Career Simulation
⭐ 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

Follow us on Pinterest

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