Category: Lesson plans

#12: Create Simple Shapes in Excel

What’s the first thing you think of when I say, Excel? Numbers, right–turning data into information. That is Excel’s ‘killer app’, but the ingenious human brain has come up with another striking use for Excel: Drawing. I spent a long time trying to find a lesson that taught drawing in Excel, finally gave up and created my own” (more…)

Graphing–9 Lesson Plans + 6 Online Resources

Graphing is an important skill for students whether they go to college after High School or start a career. It teaches:

  1. Visualization and Understanding: Graphing helps students visually represent data, functions, and relationships. This visual representation often aids in understanding complex concepts that may be difficult to grasp through purely symbolic or verbal explanations.
  2. Problem Solving: Graphs provide a way to solve problems and make predictions. Whether it’s analyzing trends in data, finding optimal solutions in optimization problems, or understanding the behavior of functions, graphing is a valuable tool for problem-solving.
  3. Communication of Ideas: Graphs provide a universal language for communicating ideas across different fields. Whether in mathematics, science, economics, or engineering, graphs are commonly used to convey information in a concise and understandable manner.
  4. Critical Thinking: Interpreting graphs requires critical thinking skills. Students learn to analyze and interpret data, identify patterns and trends, and make inferences based on the information presented in the graph.
  5. Preparation for Higher Education and Careers: Graphing skills are fundamental in many higher education disciplines and careers. Whether students pursue studies in STEM fields (science, technology, engineering, and mathematics), social sciences, or business, they will likely encounter situations where graphing skills are essential.
  6. Technology Proficiency: With the prevalence of graphing software and tools, teaching graphing also involves teaching students how to effectively use technology to create and analyze graphs. This proficiency in using graphing software is beneficial in both academic and professional settings.
  7. Promoting Creativity: Graphing can be a creative process, particularly when students are tasked with representing data or functions in innovative ways. Encouraging creativity in graphing assignments can make the learning process more engaging and enjoyable for students.

I start students in 2nd grade with a spreadsheet program. Here are some of the lessons I teach (available for free on Ask a Tech Teacher): (more…)

#72: How to Check Your Math in a Spreadsheet

This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Before you start this one, you might want to complete Project 70 and 71.

[gallery columns="2" type="square" ids="45219,45218"]

–from 55 Technology Projects for the Digital Classroom

–image credit Deposit Photos

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

Copyright ©2024 – All rights reserved.

“The content presented in this blog is the result of my 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, webmaster for four blogs, CSTA presentation reviewer, freelance journalist on tech ed topics, contributor to NEA Today, 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 15, 2024.

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

66% off January 12, 2024 through Jan. 15, 2024.

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


Using ChatGPT to Revolutionize PE Teaching: 5 Expert Strategies!

Chat GPT is popular among teachers for lots of reasons. For example: to explain concepts, demonstrate ideas, answer specific questions, and assess knowledge. When we asked the Ask a Tech Teacher team to apply it specifically to teaching physical education–not something we usually think of with tech tools–they came up with these great ideas:

Using ChatGPT to Revolutionize PE Teaching: 5 Expert Strategies!

Education is no exception to how artificial intelligence (AI) has been making waves in various industries. AI is used in education to improve learning in multiple areas, including science, math, and languages. It is also having an impact on physical education and health. AI integration can make health and physical education more effective, entertaining, and personalized for teachers and students.

The integration of cutting-edge tools like ChatGPT marks an unprecedented milestone, heralding a new era of pedagogical evolution within PE. (more…)