browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

Lesson plans

#81: Problem Solving Board

Have students teach each other the 25 most common techie problems. They learn how to solve the problem and teach the class as a presentation, then answer questions. They will feel accomplished and tech savvy.

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

(more…)

Categories: Critical thinking, Freebies/Discounts, Lesson plans, Problem solving | Leave a comment

#101: Don’t Print Homework–Email it!

By third grade, students can email their homework to you rather than turn in all those pesky hard copies. No more lost work, no more dog-ate-their-homework, no more blaming their mom. They can use their own account or a parents. Once they learn how, it is automatic–and they love doing it this way.Here’s the lesson:

If the lesson plan is blurry, click for a full size alternative.

(more…)

Categories: Lesson plans | 5 Comments

#79: Excel Turns Data Into Information

Sometimes, it takes a picture to really show what you’re trying to say. It doesn’t have to be drawn with pencils or paint brushes. Sometimes, it’s a graph or a chart, formatted to clarify important points.

That’s called Excel. Words and numbers are always black and white and the same size. Excel never is. There are twenty-two Excel skills I teach grades 3-5 that turn Excel into a useful tool in their classroom. This covers the first fourteen.

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

(more…)

Categories: Excel, Freebies/Discounts, Lesson plans, Math | Leave a comment

#98: Email Basx

Teach students using whichever email program is installed at school, but warn students that theirs will be different. Also warn parents they will have to guide students to the correct spots on their particular version. This will avoid confusion when students go home and try to email homework. Teach To:, From:, cc:, bcc:, subject:, attachments, and basic rules of emailing (I’ll share a list that I’ve created from working with students and parents. It should keep you out of the trouble I got into in my early years).

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

[gallery columns="2" ids="44554,44555,44553,44552"]

–from 55 Technology Projects for the Classroom

(more…)

Categories: Freebies/Discounts, Lesson plans | Leave a comment

#74: Mastering Excel (for Beginners)

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…)

Categories: Excel, Freebies/Discounts, Lesson plans | Leave a comment

11 Ways to Wrap Up the School Year

end of school yearIt’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 askatechteacher@gmail.com.

(more…)

Categories: Classroom management, Lesson plans | Tags: | Leave a comment

Summer Tech Camp–Everything You Need

summer tech camp

by AATT banner

Summer Tech Camp Survival Kit

From Ask a Tech Teacher

Are you teaching a Summer Tech Camp to Kids? We have the solution:

Build Your Own Adventure

$230 value for $179

(more…)

Categories: Classroom management, Freebies/Discounts, Lesson plans, Subscriber special, Teacher resources | Tags: | Leave a comment

#73: How to Graph in Excel

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…)

Categories: Excel, Freebies/Discounts, Lesson plans | Tags: | Leave a comment

What is the 21st Century Lesson Plan?

lesson plansTechnology 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…)

Categories: Critical thinking, Education reform, Lesson plans | Tags: | 1 Comment

#55: Keyboarding in the Classroom

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…)

Categories: Freebies/Discounts, Keyboarding, Lesson plans | Leave a comment