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

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

(more…)

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

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

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

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.

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

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:

• Photoshop artwork–live
• Photoshop actions–live
• Photoshop basics #5 live
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction — live quick fixes that make a photo look cleaner #6
• Photoshop crop tool–Live
• Photoshop clone tool– live
• Photoshop–change the background–live
• Photoshop tools–add custom shapes–live
• Photoshop–start with Word –live (a little dated but still useful)

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

One of the best ways to get students interested in technology is allow them to personalize their work area. That starts with placing wallpaper of their choice on their desktop. (more…)

Here are the basic skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links but they aren’t live until publication:

• Photoshop artwork–live
• Photoshop actions–live
• Photoshop basics #5 live
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction — live quick fixes that make a photo look cleaner #6
• Photoshop crop tool–Live
• Photoshop clone tool– within a picture and to another picture #8
• Photoshop–change the background–live
• Photoshop tools–add custom shapes–live
• Photoshop–start with Word –live (a little dated but still useful)

Before trying this lesson, start here. Don’t worry. It’s not hard–just the basics.

Getting Started

Ready? Let’s start with what Adobe Photoshop is–a grown-up KidPix, and the default photo-editing program for anyone serious about graphics. This series of projects (available in 55 Technology Projects for the Digital Classroom Volume I) introduces students to a traditionally-challenging program in an easy to understand way, each scaffolding to the next, thus avoiding the frustration and confusion inherent in most Photoshop training.

There are three ways to crop in Photoshop:

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m taking a few days this summer to review them with you. Some are from members of the Ask a Tech Teacher crew. Others, from tech teachers who work with the same publisher I do. All of them, I’ve found well-suited to the task of scaling and differentiating tech skills for age groups, scaffolding learning year-to-year, taking into account the perspectives and norms of all stakeholders, with appropriate metrics to know learning is organic and granular.

Today: Lesson Plans

There are lots of bundles of lesson plans available–by theme, by software, by topic, by standard. Let me review a few:

• STEM Lesson Plans
• Coding Lesson Plans
• By Grade Level
• 30 K-5 Common Core-aligned lessons
• 110 lesson plans–integrate tech into different grades, subjects, by difficulty level, and call out higher-order thinking skills.
• singles–for as low as $.99 each. Genius Hour, Google Apps, Khan Academy, Robotics, STEM, Coding, and more.
• Holiday projects–16 lesson plans themed to holidays and keep students in the spirit while learning new tools.

Who needs this

These are for the teacher who knows what they want to teach, but need ideas on how to integrate tech. They are well-suited to classroom teachers as well as tech specialists.

(more…)