Secondary Lesson Plans for Technology Integration
[ Please send us your experiences and feedback! ]
Mozilla Web Literacy Lessons

Mozilla has put together an Education Kit which provides an overview of their free, remixable, and easy-to-use resources for immediate use to teach the web. Plus, you can also visit teach.mozilla.org for more activities, tools, and to sign up to receive updates about upcoming trainings, events and more. They've got an awesome collection of resources for teachers looking to incorporate web literacy skills.
Statistics in Schools

The US Census Bureau has put together a program entitled Statistics in Schools which is designed to help teachers integrate US census data into classroom activities. They've got a great collection of both history and math activities ready to be implemented. You can also use their Data Access Tools to find great collections of data to practice analyzing and graphing in your classroom as well.
The Basics of Citations (MLA, Includes Social Media)

This Assignment teaches students about the basics of MLA citations. It covers books, online articles, blogs, YouTube videos, emails, Facebook posts, and even tweets. The students are provided with examples and then asked to create their own. I also recommend using EasyBib in the assignment, a great site for generating citations.
[ Lesson Download Link ]
[ Lesson Download Link ]
Aurasma Student Guide

This Guide will help students get started with Aurasma in the classroom. If you're not familiar with Aurasma, it is a mobile app that can be used to create an augmented reality pop-up. Basically, you scan a picture with a device, and a student-made video pops up. You can get a better idea of the application by checking out this Prezi.
[ Lesson Download Link ]
[ Lesson Download Link ]
Office and Google Drive Tutorials from In Pictures

If you're looking for simple, easy to follow, picture-based tutorials for Microsoft's Office Suite, or Google Drive Apps (Docs, Sheets, and Slides), I definitely recommend checking out In Pictures. They have a great collection of guides which also includes older versions of Office as well. This is a great resource for teachers and students alike, especially if you're not a computer science teacher but want your students to have some help with any of these resources.
Analyzing a LeBron Dunk Using Decomposition & Motion Graphs

Eli Sheldon is a Computational Thinking Program Manager for a charter school outside of Seattle and he was kind enough to share his lesson on Analyzing a LeBron dunk using decomposition and motion graphs. For those looking for a real world application of data analysis and visualization, this is a great activity! You can find out more on his site, including the download links for an associated presentation and worksheet.
Excel Tutorials from Excel Easy

If you're looking for free, high quality Excel tutorials that cover everything from the basics to some pretty advanced topics, including over 300 examples, I'd recommend checking out Excel Easy. They have a great collection of resources over an incredibly large variety of topics, including Visual Basic for Applications and tons of relevant, easy to follow examples.
Olympics in Excel Report

This Assignment asks student to do a little data collecting, graphing, and minor analysis. It's great for students beginning in Excel. Students choose 10 countries and look at their medal counts from the recent Sochi Olympics. Then, the students graph that information and create a short report in Microsoft Word or PowerPoint using the information they found. It is designed to take two or three 40-minute classes.
[ Lesson Download Link ]
[ Lesson Download Link ]
Creating an Invitation to an Historical Event with Smore

This Assignment asks students to create an invitation/flyer to an historical event using the free web-app, Smore. Students will need to write a summary of the event as well as create short bibliographies about the major "characters" from the event. They will also include links to more information, videos, and images. For 6th-8th grade.
[ Lesson Download Link ]
[ Lesson Download Link ]
Animating a Novel in Go! Animate or Domo Animate

This assignment is a week-long animation project using Go! Animate or Domo Animate (both are free). Students (working alone or in partners) will create an animation based on a novel they have previously read. Their animation will include paraphrasing, favorite quotations, and personal reactions. Great for a middle or high school language arts class. For a similar activity in History, see "Domo on Historical Figures" below.
[ Lesson Download Link ]
[ Lesson Download Link ]
Creating a School Newspaper with Publisher and Issuu

This assignment is a 1-2 week project for computers, language arts, and/or journalism class where students create a school newspaper in publisher and then upload their magazine to Issuu to create an online version. For the newspaper, the students will conduct an interview, create a survey, and write several articles. It is best for 7th and 8th grade students, particularly those that have some familiarity with Publisher.
[ Lesson Download Link ]
[ Lesson Download Link ]
PBL Lesson on Digital Citizenship and Online Safety

This assignment is a 3-4 week long PBL lesson that asks students to research digital citizenship and online safety in their own school and in schools around the world. Students create blogs, design surveys, and analyze results. For their culminating project, student groups develop a school-wide improvement plan to help students become better digital citizens. Designed for a computer technology class.
[ PBL Lesson Link ]
You can also view a remixed version of this lesson created by Media & Technology teacher, Kathleen Weil. She made some excellent improvements to this lesson in order to have it be more suited to her students' needs.
[ PBL Lesson Link ]
You can also view a remixed version of this lesson created by Media & Technology teacher, Kathleen Weil. She made some excellent improvements to this lesson in order to have it be more suited to her students' needs.
Prezi Book Report

This Assignment uses Prezi.com to create an online presentation. Probably best for the middle school level, this assignment asks students to discuss the plot, settings, characters, and their personal reaction to a novel. If you've never used prezi before, you can find a series of videos on their website explaining the program.
[ Lesson Download Link ]
[ Lesson Download Link ]
TimeGlider Timeline

This assignment uses Timeglider.com to create an interactive timeline. If you've never used Timeglider, here's a tutorial, it's a little outdated, but everything still works similarly. This program can be used to create timelines with embedded links, images, audio, and video. In this assignment the students create a timeline over the history of technology, but it could be easily modified for use with another subject.
[ Lesson Download Link ]
[ Lesson Download Link ]
Country Webpage Report in Wix

This assignment uses Wix.com to help students create a webpage report about a country. This project is designed for a history or social studies class, but could be easily modified to fit an English, Science or Math curriculum. Wix's drag-and-drop interface is incredibly easy to use and students generally have very little trouble learning to use the program.
[ Lesson Download Link ]
[ Lesson Download Link ]
Domo Animate on Historical Figures

This Assignment uses Domo Animate to help students create an animation about an historical figure. If you've never used Domo before, here's a tutorial. Domo Animate is incredibly user/kid friendly and most students have little trouble figuring it out. One feature I really like is that when students try to write profanity or innapropriate language, Domo just blocks it out ($#!% style). Plus, you're not allowed to upload your own audio or images, so you never have to worry about inappropriate content. [ Lesson Download Link ]
Online Magazine with Publisher and Issuu

This assignment guides students through the process of creating their own magazine in Microsoft Publisher and then publishing it online through Issuu. The topic of the magazine is up to the students in this lesson, but could be modified to fit the curriculum of an English or Social Studies class pretty easily.
[ Lesson Download Link ]
[ Online Publishing Guide ]
[ Lesson Download Link ]
[ Online Publishing Guide ]
Creating a Blog with Weebly

This assignment guides students through the creation of their own blog on Weebly.com In this introductory assignment students create a short blog about their interests and hobbies, but it could be modified to cover any range of subjects. Weebly is a great site for designing blogs and has an easy to understand interface.
[ Lesson Download Link ]
[ Lesson Download Link ]
Excel Basics

This assignment introduces upper-elementary students the basics of Microsoft Excel. It's a 4 part series which teaches students the basic vocabulary and functions that are available within the program. Each section takes 30-40 minutes for students to complete.
- Part 1 - Part 2
- Part 3 - Part 4
- Part 1 - Part 2
- Part 3 - Part 4
Figuring Foods Excel Assignment

This assignment in Excel is designed to give junior high students a closer look at what's in their favorite foods, perfect for a science or health class. Students create a table comparing 7 different foods. Then, they graph their data and write a report about their findings. In total, this project takes students 60-80 minutes to complete.
[ Lesson Download Link ]
[ Lesson Download Link ]
Timeline Creation in Excel

This assignment in Excel shows students how to create a timeline using the program. In this project, they create a timeline about their daily schedule, but it could easily be modified for any subject: A history timeline, a series of lab steps, a timeline for a novel, and so on. The sample timeline takes about 40 minutes to make and would be appropriate for junior high or high school students.
[ Lesson Download Link ]
[ Lesson Download Link ]