Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Middle schoolers 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...
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

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.
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
Students use excel to analyze data. In this technology activity, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Lesson Plan
Curated OER

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Lesson Plan
Curated OER

Chart Challenge: Behavior Management

For Teachers 3rd - 4th
Students develop a behavior management plan using Excel. They use the computer to develop a behavior chart. Students record their behavior on a daily basis using the chart they developed using Excel.
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

How to Teach Dolch Words with Kid Pix

For Teachers 1st - 3rd
Learners use KidPix computer program to learn Dolch sight words. In this technology and language lesson, students type their Dolch sight words into KidPix to create a quasi-sentence.
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
Lesson Plan
Curated OER

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Lesson Plan
Curated OER

Get My Point!

For Teachers 3rd - 7th
Here is one of the better lessons I've come across on how to teach fractions and decimals. This lesson does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent websites, printable...
Lesson Plan
Curated OER

ABC, Easy as 123

For Teachers K
Kindergartners practice identifying the sight and sounds of vowels and consonants. They identify beginning consonants in single-syllable words and print the letters of the alphabet. This outstanding resource has many excellent...
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Students explore spreadsheet software.  In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer.  Students represent hotel, food, transportation, and entertainment costs...
Lesson Plan
Curated OER

Divisibility Rules

For Teachers 8th
Eighth graders explore Excel and discover rules of divisibility for the numbers 2, 3, 4, 5, 6, 9, and 10; students examine multiples of 2 using pencil/ paper, then create a chart in Excel that will allow them to more easily see patterns...
Unit Plan
Curated OER

Deciphering Word Problems in Order to Write Equations

For Teachers 5th - 8th Standards
Help young mathematicians crack the code of word problems with this three-lesson series on problem solving. Walking students step-by-step through the process of identifying key information, creating algebraic equations, and finally...
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet lesson plan, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day....
Lesson Plan
Curated OER

Math/Technology: Height Measurement

For Teachers 3rd
Third graders, using technology tools, determine the total height of their classmates in both inches and centimeters. Once the measurements are taken, they enter the results in the Excel file. Once students have prepared a KidPix number...