Category: Lesson plans

#52: Indigenous Cultures Magazine in Publisher

Here’s a great lesson plan that’s adaptable to history, science, or any number of other topics:

This project introduces the basics of magazine creation in MS Publisher while students engage in inquiry-based learning that incorporates discovery and fosters curiosity. The project includes a cover, table of contents, border, map, banner title, five fast facts and pictures. This is an easy project that always comes out nicely for learners.

If you don’t use MS Publisher, adapt this project to your favorite class magazine publisher, like Canva:
(more…)

How to Use Excel to Teach Math Arrays

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

How to Use Excel to Teach Math Arrays

Grade Level: 5th (or whichever grade you are teaching arrays)

Background: None. This is an intro to MS Excel

Vocabulary: Excel, cell, rows, columns, paint bucket, borders, arrays, resize, formulas

Time: About 30 minutes

Steps:

(more…)

100th Day of School

 

The 100th day of school is varied depending upon when you start. For a lot of schools, it’s the first week of February. Here are resources (if these sound familiar, we updated last year’s list):

Geography

As a class, come up with two locations in each state, to total 100. One will be oriented around geography and one around history. Include a brief description and a picture and then share the collection with parents and schoolmates in the class newsletter or another vehicle.

History

Research what happened the hundredth year of your home country’s existence.  What was the country like? What caused it to change? Who was the leader? What has been invented since then? Divide the class into groups so the project can be completed in one class period. Then, have everyone copy their information to a digital magazine and share it with everyone. (more…)

#WorldReadAloudDay February 4th

World Read Aloud Day is celebrated every year on the first Wednesday of February. It celebrates the pure joy of oral reading with kids of all ages. Created by LitWorld, past years have found over 1 million people in 100 countries joining together to enjoy the power and wonder of reading aloud in groups or individually, at school or home, and discovering what it means to listen to a story told through the voice of another. For many, this is a rare opportunity to hear the passion of a well-told story and fall in love with tales where hearing them reaches listeners on a level nothing else can. Think back to your experiences. You probably sat with an adult, in their lap or curled up in bed. The way they mimicked the voices in the story, built drama, and enthused with you over the story and characters made you want to read more stories like that on your own. This is a favorite activity not just for pre-readers, but accomplished readers because it’s not about reading the book; it’s about experiencing it through the eyes of a storyteller.

Somehow, as lives for both the adults and children have gotten busier, as digital devices have taken over, as parents turned to TVs or iPads to babysit kids while they do something else, we’ve gotten away from this most companionable of activities. World Read Aloud Day is an opportunity to get back to it.

Importance of reading aloud

There is no more powerful way to develop a love of reading than being read to. Hearing pronunciations, decoding words in context, experiencing the development and completion of a well-plotted story as though you were there are reason enough to read aloud but there’s more. Reading in general and reading aloud specifically is positively correlated to literacy and success in school. It builds foundational learning skills, introduces and reinforces vocabulary, and provides a joyful activity that’s mostly free, cooperative, and often collaborative. Did you know reading aloud:

(more…)

Groundhog Day

Here are some activities for Groundhog Day–February 2nd (click here for updates to list):

  1. Fun Facts About Groundhogs–video
  2. Groundhog Day Digital Activities–grades 3-5
  3. Groundhog Day for Kids–a video
  4. Groundhog Day Games
  5. Groundhog Day Teaching Resources
  6. History of Groundhog Day–from History.com
  7. Punxsutawney Groundhog Club Website
  8. Why Groundhogs Supposedly Predict the Weather–video

–image credit Deposit Photo

 

Copyright ©2026 askatechteacher.com – All rights reserved.

Here’s the sign-up link if the image above doesn’t work:

https://forms.aweber.com/form/07/1910174607.htm

“The content presented in this blog are the result of creative imagination and not intended for use, reproduction, or incorporation into any artificial intelligence training or machine learning systems without prior written consent from the author.”


Jacqui Murray has been teaching K-18 technology for 30 years. She is the editor/author of over a hundred tech ed resources including a K-12 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, Master Teacher, freelance journalist on tech ed topics, and author of the tech thrillers, To Hunt a Sub and Twenty-four Days. You can find her resources at Structured Learning.

Free MLK Lesson Plans

In honor of Martin Luther King:

MLK Day in the US is the third Monday of January, this year, January 19, 2026

Ask a Tech Teacher’s 19-page two-lesson plan bundle to support your teaching of Martin Luther King (click for more information) is

66% off through Jan. 19, 2026

Lesson plans include:

        • an Event Chain of Dr. King’s impact on American history (adaptable to other historical events)
        • interpreting his words with a visual organizer

(more…)

Three Projects to Kick Off the Holidays

Click to enlarge lesson plans

A Holiday Calendar

Kids love making this calendar. They get to talk about their upcoming vacations and hear what their friends are doing. It’s simple enough for third grade with advanced tools that satisfy a fifth graders growing intellect.


A Holiday Newsletter

Have students collaborate on a newsletter for a classroom unit of inquiry or a theme (colonies, animals, etc). Pick a template. Add text and pictures. Pay attention to layout details. Allow several class periods to complete

(more…)