Category: Lesson plans

Thanksgiving Activities That Keep You in Charge of Learning

Teaching the days before big holidays is challenging. Students and teachers alike are ready for a break. Both struggle to pay attention regardless of how innovative and engaging are the lesson plans.

I’ve been there often. As a result, I’ve come up with fun ways to support learning while students power through the last few days of school. Here are seven I use during the pre-Thanksgiving season:

  • ASCII Art
  • Comics
  • Holiday Widget
  • Team Challenge
  • Thanksgiving Poll
  • Thinking Games
  • Themed

ASCII Art

Time required: Less than one class

ASCII Art is the graphic design technique of creating images by typing the letters, numbers, and symbols defined by ASCII Standards. Holiday examples include this Thanksgiving pumpkin and these holiday bells. Here’s how you do it:

  1. Open your word processing program (MS Word, Google Docs, or another).
  2. Add a watermark of a picture you’d like to use, preferably a single image rather than one that includes a background. Silhouettes are perfect for this sort of project.
  3. Type over the image with the letters, symbols, and numbers that best fit the outline. It’s fine to use one letter throughout (like an X).
  4. Add color by highlighting the letters, numbers, and symbols typed over the parts you’d like colored (such as the stem of a pumpkin or the bow on Christmas bells in the linked samples above).
  5. When you’ve covered the image with characters, delete the watermark. That leaves just your typing.
  6. Save, print, share, publish as is customary in your classes.

Tie-ins: Use this not only for holidays but any academic class by creating an artistic image of the topic being discussed. This is also a fun and authentic way for students to practice keyboarding.

(more…)

Create a Timecard in a Spreadsheet for Grade Two+

One of the most popular applications of math is through spreadsheets (like Excel) that make those numbers relevant to everyday life. We’re going to provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

  1. #74: Mastering Excel (for Beginners)
  2. #71: Beginning Graphs in MS Excel
  3. #70: Create a Timecard in Excel for Grade Two and Up
  4. #73: How to Graph in Excel
  5. #12: Create Simple Shapes in Excel
  6. #75: Tessellations in Excel
  7. #72: How to Check Your Math in Excel
  8. How to Use Excel to Teach Math Arrays
  9. #62: Email from Word (Or PowerPoint or Excel)
  10. #79: Excel Turns Data Into Information

Today

 

Create a Timecard in Excel for Grade Two and Up

If you don’t use Excel in your classroom, adapt these steps to whichever spreadsheet program you use (more…)

#73: How to Graph in Excel

One of the most popular applications of math is through spreadsheets (like Excel) that make those numbers relevant to everyday life. We’re going to provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

  1. #74: Mastering Excel (for Beginners)
  2. #71: Beginning Graphs in MS Excel
  3. #70: Create a Timecard in Excel for Grade Two and Up
  4. #73: How to Graph in Excel
  5. #12: Create Simple Shapes in Excel
  6. #75: Tessellations in Excel
  7. #72: How to Check Your Math in Excel
  8. How to Use Excel to Teach Math Arrays
  9. #62: Email from Word (Or PowerPoint or Excel)
  10. #79: Excel Turns Data Into Information

–from 55 Technology Projects for the Digital Classroom

–5 bundled Excel lesson plans (for a fee)

Today

#73: How to Graph in Excel

Adapt this for your spreadsheet program if you don’t use Excel

(more…)

Subscriber Special: November Holiday Project Book

Every month, subscribers to our newsletter get a free/discounted resource to help their tech teaching.

K-8 Holiday Projects

Regular price: $7.99

On Sale until December 25, 2025: $4.99

16 student-tested holiday projects, K-8, using word processing, spreadsheets, DTP, art, online webtools, and more. They’re from the Ask a Tech Teacher technology team, designed to be fun and festive, while teaching important tech skills. Use them for any holiday. They’ll fill your year with pictures, calendars, wallpaper, cards, that kids will love making and want to give to family as gifts.

(more…)

Halloween Projects, Websites, Apps, Books, and a Costume

Three holidays are fast-approaching–Halloween, Thanksgiving, and Christmas. If you’re a teacher, that means lots of tie-ins to make school festive and relevant to students.

Here are ideas for Halloween projects, lesson plans, websites, and apps (check here for updated links):

Websites and Apps

  1. 30-day Halloween fitness challenge
  2. Build a Jack-o-lantern (in Google Slides)
  3. Carve-a-Pumpkin from Parents magazine – Resolute Digital, LLC (app)
  4. Enchanted Learning
  5. Halloween games, puzzles–clean, easy to understand website and few ads!
  6. Halloween Kahoot Games (video for teachers)
  7. Halloween Science
  8. Halloween Voice Transformer (app)
  9. Make A Zombie – Skunk Brothers GmbH (app)
  10. Meddybemps Spooky
  11. Pumpkin Patch Games
  12. WordSearch Halloween – AFKSoft (app)

Projects

  1. ASCII Art–Computer Art for Everyone (a pumpkin–see inset)
  2. Lesson Plan: Halloween letter for grades 2-5
  3. Make a Holiday Card
  4. A Holiday Card
  5. A Holiday flier

(more…)

Excel Series: #74: Mastering Excel (for Beginners)

One of the most popular applications of math is through spreadsheets (like Excel) that make those numbers relevant to everyday life. We’re going to provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

  1. #74: Mastering Excel (for Beginners)
  2. #71: Beginning Graphs in MS Excel
  3. #70: Create a Timecard in Excel for Grade Two and Up
  4. #73: How to Graph in Excel
  5. #12: Create Simple Shapes in Excel
  6. #75: Tessellations in Excel
  7. #72: How to Check Your Math in Excel
  8. How to Use Excel to Teach Math Arrays
  9. #62: Email from Word (Or PowerPoint or Excel)
  10. #79: Excel Turns Data Into Information

Today:

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

8 Projects to Teach Digital Citizenship–by Grade

Education has changed. No longer is it contained within four classroom walls or the physical site of a school building. Students aren’t confined by the eight hours between school bells or the struggling budget of an underfunded program. Now, education can be found anywhere — teaming up with students in Kenya, Skyping with an author in Sweden, or chatting with an astrophysicist on the International Space Station. Students can use Google Earth to take a virtual tour of a zoo or a blog to collaborate on class research.

Learning has no temporal or geographic borders and is available wherever students and teachers find an Internet connection. This vast landscape of resources is offered digitally, often free, but to take that cerebral trek through the online world, children must know how to do it safely, securely, and responsibly. This used to mean limiting access to the Internet, blocking websites, and layering rules upon rules hoping (vainly) to discourage students from using an infinite and fascinating resource. It didn’t work.

Best practices now suggest that instead of cocooning students, we teach them to be good digital citizens, confident and competent. Here are projects to teach kids authentically, blended with your regular lessons, the often complicated topic of becoming good digital citizens, knowledgeable about their responsibilities in an Internet world.

(more…)

Excel (or Spreadsheets) — the series

One of the most popular applications of math is through spreadsheets (like Excel) that make numbers relevant to everyday life. Many think this is too complicated, too cerebral, someone can do it but not them–they’d be wrong. I start my students in 1st grade with spreadsheets (though they don’t call it that) like this art exercise:

and build on their skills until they have the basics by fifth grade.

[gallery type="columns" columns="2" size="medium" ids="67800,67801"]

Then, we spend middle school applying those skills to lessons.

Over the next few months, we’ll provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

  1. #74: Mastering Excel (for Beginners)
  2. #71: Beginning Graphs in MS Excel
  3. #70: Create a Timecard in Excel for Grade Two and Up
  4. #73: How to Graph in Excel
  5. #12: Create Simple Shapes in Excel
  6. #75: Tessellations in Excel
  7. #72: How to Check Your Math in Excel
  8. How to Use Excel to Teach Math Arrays
  9. #62: Email from Word (Or PowerPoint or Excel)
  10. #79: Excel Turns Data Into Information

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

8: Fifth Grade Cloning in Photoshop

Adobe Photoshop is kind of KidPix for grown-ups, as well as the default photo-editing program for anyone serious about graphics. This series of projects (available in the first volume of the book, 55 Technology Projects for the Digital Classroom) introduces students to a traditionally-challenging program in an easy to understand way, each project scaffolding to the next, thus avoiding the frustration and confusion inherent in most Photoshop training.

Here are the skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links. The bolded ones are published, unbolded coming soon:

Today: Cloning

The clone tool duplicates a hard to crop-and-copy image (like the flowers below) or deletes part of a background—a sign or a post in a nature scene—you don’t want there. You can clone within a picture (as with the flowers), (more…)