Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

For Teachers 8th
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Lesson Plan
Curated OER

Computer Technology Bingo

For Teachers 9th - 10th
Students review new vocabulary from their computer technology class. In groups, they participate in a bingo game in which they define terms from a worksheet. They are assessed based on an attached rubric and discuss any terms they are...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  For this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Coding History

For Teachers 10th - Higher Ed
Students study the topic of codes in Computer Science. They research it history, divisions in the field and its applications. The lesson also includes a brief overview of the information technology theory.
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson plan uses technology and shows learners how to cross skills into the...
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Activity
Curated OER

Tech Integration Project Lesson Accelerator: Project Overview

For Teachers 7th - 8th
Prepare middle schoolers for life in the tech world with a lesson on entering, storing, sorting, and creating database collections. They use a database tool, such as excel, to record the contents of their CD collections. They then...
Lesson Plan
Curated OER

Tessellations in Excel

For Teachers 2nd - 9th
Students complete an Excel project on tessellations. In this technology and math lesson, students discuss tessellations and their occurrences in nature. Students use the Excel computer program to create tessellations.
Lesson Plan
Curated OER

How to keep a timecard in Excel

For Teachers 3rd - 6th
Students fill out a timecard of family activities in Microsoft Excel. In this Excel lesson plan, students use the program to fill in times they do various activities with their families.
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Activity
Teach Engineering

Applying Statistics to Nano-Circuit Dimensions in Fabrication

For Students 11th - 12th Standards
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Activity
1
1
Teach Engineering

Understanding the Air through Data Analysis

For Teachers 9th - 12th Standards
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Lesson Plan
Curated OER

USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION

For Teachers 6th - 12th
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Lesson Planet Article
Curated OER

How to Celebrate Digital Learning Day

For Teachers 2nd - 6th
Leverage technology to boost student engagement and achievement.
Lesson Plan
Curated OER

Technology that Makes Phonics Fun

For Teachers K - 3rd
Students discover the Internet by participating in on-line educational activities.  For this educational technology lesson, students utilize interactive story books, podcasts, and games to help expand an understanding of phonics....
Lesson Plan
Curated OER

Computer Olympics

For Teachers 2nd - 6th
Students compete to achieve excellence in math facts, writing terms, problem solving, and writing skills on the computer. In this Computer Olympics lesson plan, students practice the skill of drill and practice in order to succeed and...
Lesson Plan
Curated OER

Have I Been Hacked?

For Teachers 6th - 12th
Students investigate how effective SNEAK strategies are in detecting hackers. In this technology instructional activity, students explain the ethical issues about hacking. They graph and analyze their experimental results.
Lesson Plan
Curated OER

A Holiday Calendar in MS Publisher for Elementary School

For Teachers 4th - 7th
Students create a holiday calendar using ms word. In this technology lesson, students create their own calendar while learning basic Publisher skills. Students use clipart, explore how to change fonts, and how to use templates.
Lesson Plan
Curated OER

Technology: Computer Basics

For Teachers 1st - 6th
Students access a variety of resources on the Internet related to basic computer operations and parts. They examine the parts of a computer and the history of computers, view timelines, play games, and read tips on Internet safety.
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Spreadsheet formulas

For Teachers 6th - 8th
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...