76 results
High school math lessons for Microsoft Excel
Introduction to Excel Formulae Lesson Plan
This fantastic lesson allows children to make link between Maths and Excel Spreadsheets. It also introduces the very basics of Excel Spreadsheets by introducing the following key terms in a very child friendly manner: • Cell • Row• Active Cell• Column • Worksheet • Cell ReferenceAlongside the above, children are introduced to very basic calculations in Excel Spreadsheets. This resource includes the following: • Editable and animated PowerPoint presentation • PDF version of the powerpoint• Lesson
Grades:
1st - 11th, Adult Education, Staff
Excel Lessons - Creating Charts
No Prep! These lessons are great as a first Excel Chart lesson or for students already a little familiar with creating charts. Students love the data for these charts because the data is centered around things they love – their cell phones! In Lesson 1, students will create 5 different charts from step-by-step directions which include Chart Titles, Chart Styles, Axis Titles, Data Labels, and Moving Chart to its own Sheet.In Lesson 2, students will create 5 charts from provided data as well as ch
Grades:
5th - 12th
Types:
Excel Spreadsheets Million Dollars Activity
This resource allows students to understand the following: How graphs change when spreadsheet data is alteredUse of SUM() functionsHow graphs are madeComponents of a graphAdvantages of spreadsheets over pen and paper methodsStudents use this resource to understand how altering data in spreadsheets allow graphs to change. They understand such concepts by trying to spend a Million Dollars in a minute. Students are then expected to complete the associated worksheet which accompanies the spreadsheet
Grades:
5th - 12th, Adult Education
Types:
Olympic Medal Count Computer Project in Excel
Welcome to my Excel project keeping track of all the medals won in the 2022 Beijing Winter Olympics. This an extremely fun project for me and my students. The only homework they have is to . . . watch the Olympics!! What could be more fun that that??? In this project, students will build 2 spreadsheets, one to keep track of the overall medal count by country, see one of the thumbnails to see the part of the finished product, and the other just keeps track of the medals the USA Olympic team wins.
Grades:
3rd - 12th
Types:
Statistics Unit 9 Bundle - Hypothesis Testing (one sample) (18 days)
This is a unit plan bundle for a Statistics class. The plans include common core math standards, time frame, activities, enduring understandings, essential questions, and resources used. It is designed to last 18 days, depending on pacing. The plans include: 56-slide presentation, with annotated guide for reference5 Worksheets1 "Read & Respond" Article Worksheet2 Quizzes"Do Now" Entrance problemsSpreadsheet Activity - Hypothesis TestingReview slides (for peer presentations)Unit ReviewUnit Te
Subjects:
Grades:
10th - 12th, Higher Education
Types:
CCSS:
Teaching Statistics with Spreadsheets (Self Grading)
You can see a video that describes the basics of this course at the following link: https://www.youtube.com/watch?v=uZFpltXWyw8This package is an entire statistics course designed for content to be delivered, taught, practiced, and assessed through spreadsheets. Students learn basic statistics and spreadsheet skills. This course is intended to allow for student collaboration and group work throughout the learning process. Each spreadsheet is automatically graded so students can see their progres
Grades:
9th - 12th
Types:
Statistics Unit 8 Bundle - Confidence Intervals (19 days)
This is a unit plan bundle for a Statistics class. The plans include common core math standards, time frame, activities, enduring understandings, essential questions, and resources used. It is designed to last 19 days, depending on pacing. The plans include: 52-slide presentation, with annotated guide for reference5 Worksheets3 Quizzes"Do Now" Entrance problemsSpreadsheet Activity - T-DistributionReview slides (for review response system)Unit test (with review packet)Unit Project - Gather Data,
Subjects:
Grades:
10th - 12th, Higher Education
Types:
CCSS:
Introduction to Formulae in Excel Lesson Plan
This fantastic lesson teaches children about the basics of Excel formulae in a child friendly manner. It teaches them about cell references first before incorporating cell references into formulae.
This resource includes the following:
• Editable and animated PowerPoint presentation
• PDF version of the powerpoint
• Lesson plan indicating how the lesson can be delivered
• 2 worksheets (included in the presentation) which can be printed out for students.
A good teacher demonstration resour
Grades:
3rd - 12th, Higher Education, Staff
Creating real working credit card numbers using Luhn's algorithm
Great easy to follow worksheet that will keep any student engaged!Using Luhn’s algorithm you can visually see how to apply this to check the validity of credit card numbers. I set up the table so that students can input a 16 digit number and follow the simple process to check if their number works.I start with a worked example and then I have two sides of blanks for students to use. This is a great lesson for Xmas, Easter or Summer break last lesson if you are looking for a lesson that will make
Subjects:
Grades:
8th - 11th
Explore Simple Interest v Compound Interest - Real World Math Exponential Growth
This activity will help students explore the power of exponential growth as they compare simple interest vs. compound interest.
This activity has three components.
The first component will have students calculate interest earned and new balance using simple interest over the course of four years. It then has students calculate the new balance, year by year, if using compound interest.
The second component introduces the compound interest formula (students will love not having to calculat
Subjects:
Grades:
6th - 9th
Types:
Google Sheets - Creating Charts with live Weather data! FUN Technology Lesson!
A fun, ready-to-go EDITABLE lesson!Students collect online weather data, bring it into a spreadsheet and then CREATE CHARTS and interpret the data!Including:A Lesson PlanA presentationSpreadsheet template Completed example spreadsheetVIDEO SCREENCAST - Showing how to complete the activity!Check out the preview and video preview!My students have enjoyed this class and yours will too. It's all here ready for you!===============================Please leave feedback and respect copyright, purchase a
Grades:
4th - 12th, Adult Education
Types:
Excel 2010 Tutorial - Intro to Excel, data entry and formatting
This is definitely a beginner, novice level, newbie assignment! Students learn basic data entry as well as how to use the AutoFormat feature to make tables look nice and colorful! This is literally the first exercise I give my students in an Excel unit. Being a Canadian, I am affirming the stereotype about us loving hockey by making this an NHL (fictional) standings data table :)! Obviously, students could choose NFL, NBA, MLB or other nonsports related information to include in their table.
Grades:
7th - 12th
Types:
Also included in: Excel 2010 Beginner Lesson Bundle
Create Line Graphs in Excel
This instruction guide walks students (and us teachers) through the process of entering data into an Excel spreadsheet and turning it into a line graph. This 10-page guide contains numerous screen shots to help explain each step.
The guide can be used along with laboratory investigations and projects common to physics, chemistry, and biology, as well as courses in mathematics, economics, meteorology, sociology, etc. If your students need to learn how to graph the data they collect, this guide w
Subjects:
Grades:
8th - 12th
Types:
MDM4U - Unit 2, Chapter 7 Assignment Key
MDM4U - Unit 2, Chapter 7 Assignment Key
Subjects:
Grades:
12th
Types:
Also included in: MDM4U - Unit 2, Chapter 7 Assignment and Key
Financial Literacy - 100 years of Gas Prices
This original enrichment lesson (60-70 minutes) walks students through a deep dive of gas prices and transportation costs from the 1920s to the 2020s. It asks students to size down large data sets into decade-sized chunks using approximation skills and use basic equations in a Google Sheet to compare the cost numbers across three layers of depth: inflation, fuel efficiency, and driving habits.The folder contains1. Google Doc student worksheet (4 pg) with links to data and inflation calculators.2
Subjects:
Grades:
9th - 12th
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
In this engaging beginner level activity, we will use the world of sports to illustrate how to use the AVERAGE function in Excel. Specifically, students build a spreadsheet that calculates averages based on a fictional 10 game cross sample of NBA players scoring stats. Formatting skills are reviewed here as the exercise requires the creation of headings, the formatting of shapes, the use of borders, as well as different font sizes and colors.
This lesson can be used in other versions of Exce
Grades:
7th - 12th
Types:
Also included in: Excel 2010 Beginner Lesson Bundle
Six Subject Horizontal Lesson Planner, Plan Book, Binder Pages Weekly
I have always found horizontal weekly planners easier to use but couldn't find any pre made so I created my own. I've been using it for several years and love it. Hope you find it as useful as I have : ) Feel free to edit it to suit your color and font preferences and don't forget to print two sided so you can view a whole week at a time!
Subjects:
Grades:
PreK - 12th
![Preview of Trigonometry Calculator Practice - Infinite Versions [sin cos tan]](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/Trigonometry-Calculator-Practice-Infinite-Versions-sin-cos-tan--4412332-1681913396/750f-4412332-1.jpg)
Trigonometry Calculator Practice - Infinite Versions [sin cos tan]
This excel file is setup to print on one page with 30 practice problems, helping students become familiar with calculator -sin, cos, tan- functions.Page 2 produces the answers automatically for easy grading.Clicking the calculate button in the formulas tab will generate a completely new worksheet. This makes it easy to create multiple versions of the same type of worksheet.
Subjects:
Grades:
8th - 10th
Types:
XLOOKUP for EXCEL
This activity will introduce students to the function of the command, XLOOKUP. XLOOKUP functions similar to VLOOKUP offering more variety. The function is found in newer versions of Excel ( 2021, 365). Everything is given in this activity except the exact way to set up the data which is provided. It is assumed that since this is a more advanced skill the students should already know the basic functions of setting up and using Excel.
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Coteaching Schedule/ Planner for Daily Small Groups
This is a planner on Microsoft Excel that can be used to organize students into groups. There is space on here that can be used to organize groups in three ways:1. One teacher can use this to organize their groups for the day.2. Coteachers can have both of their groups organized in one Excel sheet to make it easy to see who is pulling whom at each time.3. Lastly, a teacher can use this to organize small groups for two class sections (for example, they might organize their first and second ELA c
Subjects:
Grades:
K - 12th
Lesson PlanTemplate and Objective Generator
This file and an at home planning meeting. The TEMPLATE will guide you through a series of questions. As you type in the answers, the lesson objective and lesson plan will auto-generate. When you have completed all the questions your lesson plans will be done.
Sometimes we don't remember how to think through the planning, but we have all the ideas. This document takes you through the thinking steps and places your ideas in the correct part of the lesson plan.
Subjects:
Grades:
PreK - 12th, Staff
Types:
Numbers Spreadsheets and Graphs
The skills needed to create spreadsheets and graphs will stand students in good stead from junior high school through college and into their professional lives as adults. Start in 7th grade to teach your students how to create these data and math skills with Apple’s program called Numbers. And although, the assignments provided in this unit are written to take advantage of the tools available in Numbers, if you’re a Microsoft user, the ideas can be easily converted to Excel spreadsheets and g
Subjects:
Grades:
7th - 9th
Types:
Four Subject Lesson Planner Plan Book Binder Pages
I have always found horizontal weekly planners easier to use but couldn't find any pre made so I created my own. I've been using it for several years and love it. Hope you find it as useful as I have : ) Feel free to edit it to suit your color and font preferences and don't forget to print two sided so you can view a whole week at a time.
Grades:
PreK - 12th
Math Lesson Plan Template on Excel
A lesson plan template for any math level is here. It has a drop list of options for Common Core Math Practices, AVID Learning Strategies, evaluations, accommodations and other fields. Of course, Marzano Practices could be effective in the template. A follow-up area is available for the teacher to have an idea of his/her future goals or reinforcement plans.
Similar lesson plan that are editable with Common Core, AVID and Marzano's Domain in drop-lists:
7th Grade Math Lesson Template
Lesson
Subjects:
Grades:
1st - 12th, Higher Education, Adult Education, Staff
Showing 1-24 of 76 results
Find Math resources | TPT
Importance of learning math skills
It's no secret that mathematics is one of the foundational subjects that students need to learn. Math forms the basis for so many other subjects — like science, engineering, and technology — and because of that, it's essential that students develop strong math skills starting from a very young age.
Benefits of learning math
Learning math has many benefits. It helps students:
- Begin to develop problem-solving, logical reasoning, and critical-thinking skills
- Grow their understanding of numbers and basic operations
- Understand how math is used in real-life situations
By ensuring that students have a solid foundation, teachers can help set them up for future success.
Discover printable and digital math resources
Math resources are an integral part of effective math education. On TPT, math resources come in various forms: from worksheets and full-year curricula to manipulatives and educational games. They can be used to enhance learning, assess student’s mastery of math concepts, and engage students in meaningful learning. By incorporating math resources from TPT into your teaching toolbox, you can create a rich learning experience that strengthens students’ understanding of math concepts and encourages a positive attitude toward math.
If you’re a teacher or parent looking for printable and digital math worksheets, TPT has an extensive collection of math resources across topics and grade levels. No matter what math topic your students are working on — whether you’re teaching numbers to kindergarteners or algebra to 9th graders — TPT has resources designed to help with any math learning need.
With a little encouragement and plenty of resources, TPT resources can make teaching and learning math so much easier. Plus, you can expand students’ knowledge even further by exploring TPT science resources, which are frequently paired with math lessons.
Frequently asked questions about math resources
What types of math lessons are available on TPT?
There are many different types of math resources sold by Sellers on TPT. Some popular math lessons include geometry, mental math, algebra, fractions, place value, measurement, and decimals.
How do I find math lessons on TPT?
Educators can save time preparing math lessons with resources created by experienced teachers. Simply start a search for math resources on the TPT marketplace, and filter by grade level, price, and/or resource type to find materials that've been proven to work in classrooms like yours. No matter what you’re teaching, there are plenty of math lessons and activities sold by Sellers on TPT that are tailored to meet your students' skill levels.
How do I support students struggling with math?
If your student or child is struggling with a specific math concept, you can provide extra support and resources such as math worksheets. Sometimes, visual aids like charts, graphs, and manipulatives can help children understand abstract concepts better.
How can I make math fun?
Students learn best when they're engaged! Sprinkle a little fun into your math lessons by using educational games, videos, puzzles, and real-life scenarios. If your class seems to find math boring or uninteresting, you can also try connecting lessons to their interests or hobbies. Encourage them to ask questions and explore mathematical concepts in different ways.
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands