Category: Lesson plans

There are 22 common Excel skills easy enough for fourth and fifth graders. When they’re done, they–and their parents (and you, by the way)–will feel that they’ve accomplished much more.

If the lesson plans are blurry, click on them for a full size alternative.

(more…)

It’s the end of school. Everyone’s tired, including you. What you want for these last few weeks are activities that keep the learning going, but in a different way. You want to shake things up so students are excited and motivated and feel interested again.

Change your approach to teaching. Provide some games, simulations, student presentations–whatever you don’t normally do in your classroom. If you’re doing PowerPoints, use the last few weeks for presentations.  Make them special–invite teachers. Invite parents. If you never serve food in your lab, do it for these presentations.

Here are five of my favorite year-end Change-up activities:

6 Webtools in 6 Weeks

Give students a list of 10-15 webtools that are age-appropriate. I include Prezi, Google MapMaker, Scratch, Voice Thread, Glogster, and Tagxedo, These will be tools they don’t know how to use (and maybe you don’t either). They work in groups to learn the tool (using help files, how-to videos, and resources on the site), create a project using the tool (one that ties into something being discussed in class), and then teach classmates. Challenge students to notice similarities between their chosen tools and others that they know how to use. This takes about three weeks to prepare and another three weeks to present (each presentation takes 20-30 minutes). Students will be buzzing with all the new material and eager to use it for summer school or the next year.

Designed for grades 3-12. Need ideas on web tools? Contact me at [email protected].

(more…)

Excel graphs are easy enough for third graders. So try it. Collect your data, enter it into an excel worksheet and push F11. If you have more time, show students how to format the graph. This is a favorite with my third graders.

If the lesson plans are blurry, click on them for a full size alternative.

(more…)

Technology and the connected world put a fork in the old model of teaching–instructor in front of the class, sage on the stage, students madly taking notes, textbooks opened to the chapter being reviewed, homework as worksheets based on the text, tests regurgitating important facts.

Did I miss anything?

This model is outdated not because it didn’t work (many statistics show students ranked higher on global testing years ago than they do now), but because the environment changed. Our classrooms are more diverse. Students are digital natives, already in the habit of learning via technology. The ‘college and career’ students are preparing for is different so the education model must be different.

Preparing for this new environment requires radical changes in teacher lesson plans. Here are seventeen concepts you’ll want to include in your preparation:

(more…)

Mix a variety of keyboarding tools so students get the most out of keyboarding time in the classroom. I include software (TTL4), online keyboarding websites (Dancemat typing) and fun tests (TypingTest.com). The goal is to get students to age-appropriate national standards for typing speed with practice three times per week, fifteen minutes each time. Click the image below to enlarge:

(more…)

As a tech educator, it’s difficult to find a substitute teacher who is comfortable delivering my tech-infused lesson plans to students. Even if the sub is knowledgeable in the subject matter, s/he doesn’t have intimate knowledge of what this particular student group knows about software, websites, problem solving, and more, which can be scaffolded for the current lesson. Nor does she know my organic expectations of students such as the level of independence and self-direction I expect during class. When I started teaching tech, my generic sub lesson plan looked like this:

• practice keyboarding for fifteen minutes
• visit inquiry-themed websites

That was fine–don’t get me wrong; it promotes student learning while avoiding a meltdown by the teacher–but I now have better options that keep momentum going while I am away for PD or recovering from an unexpected illness. This collection of six stand-alone lesson plans are designed to complete important techie learning tasks, assess existing knowledge, or integrate technology rigor into class inquiry. They require little domain-specific knowledge on the part of the sub, asking primarily that s/he supervise activities and encourage critical thinking, problem solving, and transfer of knowledge on the part of students. Next time you need an emergency lesson plan, try one of these:

(more…)

Six edutainment websites to be visited in spare time in the classroom (as with all sponges). Each deals with history and can be enjoyed with only a few minutes of time

–from 55 Technology Projects for the Digital Classroom. (more…)

Create a magazine on any topic you’re covering in class using text, pictures, diagrams, charts. Add a cover and a table of contents.

Click on each page of lesson plan.

(more…)

Millions of third graders study California missions. Here’s a great project that brings it to life with some writing, lots of pictures and a dash of creativity that will excite every student.

If the lesson plans are blurry, click on them for a full size alternative.

(more…)

Students find their country of origin on Google Earth and grab a screen shot of it. Save to their computer. Import it into a drawing program like KidPix and add the country flag and student name. Students learn about importing data from one program to another with this project.

(more…)