+
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

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this lesson.
+
Lesson Plan
Curated OER

Technology Resources for the Social Studies Classroom

For Teachers Higher Ed
Looking for ways to increase engagement by bringing technology into your elementary social studies class? Teachers are introduced to the technology resources available for social studies and then they show their students specific...
+
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
+
Lesson Plan
Curated OER

Excel, Word, and Basketball

For Teachers 5th
Wow, this lesson packs a punch. Pupils interview basketball players, write about a game, and use Excel to organize statistics related to the players and the points scored. Afterward, they create posters, presentations, and much more.
+
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 instructional activity, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed...
+
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
+
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells.  Students complete...
+
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 plan also includes a brief overview of the information technology theory.
+
Lesson Plan
West Contra Costa Unified School District

Correlation and Line of Best Fit

For Teachers 8th - 10th Standards
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation coefficients and...
+
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 instructional activity uses technology and shows learners how to cross...
+
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

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics instructional activity, 4th graders formulate questions and collect data. Students represent their results by using Excel.
+
Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, learners 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

Excel Turns Data Into Information

For Teachers 3rd - 8th
Learners use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
+
Lesson Plan
1
1
Curated OER

From Ada to Grace to Sandy - Women Have IT

For Teachers 11th - 12th
Explore the significant contributions women have made in the field of information technology with an instructive lesson plan. Through class discussion and research, students discover how women have aided in the growth of the field of...
+
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
+
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 Excel to...
+
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...