Category: Spreadsheets

#12: Create Simple Shapes 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 (all links aren’t live yet):

  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

#12: Create Simple Shapes in Excel

–from 55 Technology Projects for the Digital Classroom

–5 bundled Excel lesson plans (for a fee)

Copyright ©2025 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.

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

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

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

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

Today:

–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:

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




Copyright ©2024 worddreams.wordpress.com – 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.