#71: Beginning Graphs in MS Excel
Excel makes graphs simple and easy for beginners. Even my parent helpers are amazed at how much students can do with a simple F11 shortkey and a right click. This lesson plan works just as well with Google Sheets though you may have to adapt a few of the instructions.
If the lesson plans are blurry, click on them for a full size alternative. (more…)
Math+Tech–a Good Partnership
Technology has been part of math education for decades, mostly as rote drills and a replacement for worksheets, often to assist in memorizing tables. But it’s grown up since those early days. Check out this article from one of our Ask a Tech Teacher contributors addressing why tech+math are good partners and where that will go in the future:
The Future of Math Education: Integrating Technology in the Classroom
In today’s digital age, it is increasingly necessary to integrate technology into the classroom. This inevitable change is particularly true for math education, as interactive math lessons for kids are becoming more commonplace online. Therefore, traditional schools should change their mindsets, adopt tech and adapt it for the classroom or risk getting left behind in the race to enhance students’ math learning experience. But to encourage school administration boards to make this integration, they must first know the advantages of tech in math education.
Celebrate Pi Day and Maths Day
Two math celebrations are coming up on March 14th: Pi Day and World Maths Day
Pi Day is an annual celebration commemorating the mathematical constant π (pi). Pi Day is observed on March 14 since 3, 1, and 4 are the three most significant digits of π in the decimal form.
Daniel Tammet, a high-functioning autistic savant, holds the European record for reciting pi from memory to 22,514 digits in five hours and nine minutes.
#72: Check Your Math in Excel
This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Click the images below to enlarge them for viewing.[gallery columns="2" ids="45219,45218"]
–from 55 Technology Projects for the Digital Classroom
Copyright ©2023 usna.wordpress.com – All rights reserved.
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, an Amazon Vine Voice, CSTA presentation reviewer, 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.
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 or spreadsheets
Vocabulary: Excel, cell, rows, columns, paint bucket, borders, arrays, resize, formulas
Time: About 30 minutes
5 Tech Tools for Math Class
I’ve updated Ask a Tech Teacher’s list of ten math tools we posted in 2016 to be shorter and with a new option. The new one is larger and in the #1 position. I think this will better reflect what’s going on today in our classrooms:
It can be difficult to teach math, but with the proper tools, it can often be made easier. This article will discuss some of the best tools for tutoring math online, and the way they can help teachers to improve their student’s skills. The 5 best tools for tutoring maths online are:
1. ByteLearn.com – Digital math teaching assistant for teachers
ByteLearn is a platform that helps teachers spend less time preparing materials and still gives each student individualised training. Using ByteLearn, teachers can track students’ development, keep tabs on their performance, and adjust the curriculum to suit each student’s needs. With just one click, teachers may produce 7th Grade Math worksheets like Combining Like Terms, Grade 7 Math quizzes like Distributive Property , Seventh Grade Math unit tests, and 7 Grade Math Practice Questions on Distributive Property etc.
Give ByteLearn a try in your classroom today!
Pricing: Free for teachers and students
100s of Websites on STEM-STEAM
After you’ve checked out our favorite STEAM resources, here are some of those that teachers use to teach STEM and STEAM:
National STEM/STEAM Day Nov. 8th
National STEM Day is November 8, 2022, the unofficial holiday that celebrates science, technology, engineering and mathematics (STEM) education throughout the United States. Many add ‘art’ to the celebration for the acronym, STEAM. Here are some great ideas that remind your students of the excitement that is these core subjects:
Ten Ways to Celebrate National STEM Day with NASA
National STEM Day focuses on helping students advance in STEM fields, a priority of NASA as we continue to push the boundaries of exploration and soar into the future. In celebration of National STEM Day, we challenge you to engage and inspire the Artemis generation as we go forward to the Moon by 2024 and continue to innovate in the areas of Earth science and aeronautics. To help you join in on the festivities, here are 10 ways you can celebrate National STEM Day with us.
49 STEM Activities for Students
On November 8th, we will celebrate National STEM Day to get kids excited about Science, Technology, Engineering, and Math (STEM). Together the STEM subjects represent some of the fastest-growing and most in-demand fields in the United States.
While STEM topics seem a natural fit in high schools and post-secondary curriculum, education experts are promoting a focus on STEM subjects for younger and younger children.
12 Projects for your STEAM program
Twelve favorite STEAM projects where artistic thinking becomes the engine for unpacking solutions.
Activities from Engineering for Kids
National STEM/STEAM Day is dedicated to all things science, technology, engineering, art, and math. STEM (and STEAM) represents some of the fastest-growing and in-demand fields in the world today and Engineering For Kids is passionate about inspiring the next generation of engineers, artists, and innovators.
Bring Weather into Your Lesson Plan with Earth Networks and WeatherSTEM
One of the hottest topics in schools and an area of greatest need is STEM resources. Earth Networks has developed creative and compelling STEM curricula on a variety of weather topics. Any school with a weather unit or an onsite weather station will appreciate this site. I asked them to drop in and explain their education programs to the AATT community:
5 Ways to Celebrate National STEM/STEAM Day
National STEM/STEAM Day is an opportunity to focus on helping kids advance in the fields of science, technology, engineering, art, and math. Creating understanding around STEM and STEAM is a big topic of conversation today. Statistics show few American students pursue expertise in STEM fields—and we have an inadequate pipeline of teachers skilled in those subjects. On the flipside of that the need for STEM oriented job skills are skyrocketing.
This STEM bundle includes four lesson plans: Engineering and Design, The Human Body, Keyboarding and the Scientific Method, and Robotics. All incorporate technology into authentic class activities such as bridge building, note-taking, and math. Each lesson plan includes an Essential Question and Big Idea, average time required to complete, suggested appropriate grade level, suggested teacher preparation, step-by-step directions (see preview for an example), assessment strategies, pedagogic background, samples, and images (where relevant).
How to Teach Venn Diagrams to Elementary School Students
Venn Diagrams are one of the most visual approaches to showing students the logical relationships between sets and connectivity of data. It uses overlapping circles to show the wholeness of data and then where they overlap other data sets. It’s easy to find templates for them–in MS Office, Google Apps, Canva, and more.
One of our Ask a Tech Teacher crew has organized the basics on how to teach Venn Diagrams to elementary-age students:
- What is a Venn Diagram
- How to make it digitally
- How to make it clear to elementary students (get crafty)
- How to use it to design games
How to Teach Venn Diagrams to Elementary School Students
Teaching children Venn diagrams is the beginning of teaching them how to sort and manage data, a skill that is becoming ever more useful in this technological era. However, finding a way to teach them that sticks is important – generic worksheets just won’t do! We’ve come up with a few ways you can teach elementary school students Venn diagrams that will make your lessons dynamic and fun.
What is a Venn Diagram?
It’s important to make sure you first understand what a Venn diagram is. A Venn diagram is a plot of overlapping circles that can display items via specific categories, as well as relationships. For example, you can have a Venn diagram representing blue eyes with one circle, and brown hair with another circle. Those with blue eyes but not brown hair will end up in only the segment for blue eyes; those with brown hair but not blue eyes will be placed only in the segment for brown hair. Those with blue eyes and brown hair will be placed in the segment created by the overlap of the two circles.
This is a fun concept to teach to children because it’s a visual method, so it isn’t difficult to find something both visual and interactive to make sure it’s memorable. Now for the methods!
Make it Digital
With technology becoming the main focus of life, especially for the younger generation, one of the best ways to connect and share ideas is through technology. This means using digital tools and accessing an online venn diagram can be incredibly helpful for many reasons. Firstly, it allows you to project what you’re describing on your smartboard or interactive whiteboard, allowing you to demonstrate to the class what you mean. It makes a good start!
Teaching Early Geometry Concepts
I spend a lot of time every week reading about current thinking in education. An article over at The Tech Edvocate caught my eye on early math. Math is a fundamental process in learning, not just adding and subtracting but to develops skill in problem solving and critical thinking. Scientists think that the sophistication of stone toolmaking almost a million years ago showed the symbolic and spatial thinking ability already present in our ancestors–a million years ago! To tap into that native ability with our youngest learners is not only important, but will make their education journey more enjoyable.
Here’s The Tech Edvocate’s article:
Teaching Early Geometry Concepts
Develop her visual memory of shapes by drawing a triangle, display it to her for about two seconds to three seconds, then ask her to describe it …
Check out these articles on Ask a Tech Teacher about teaching math: