Basic Function Tables
49+ results
Filters
Grade
Subject
Format
Resource type
Standard
Language
Programs & methods
Supports
Google Sheets and Microsoft Excel: Basic Formulas and Functions Lesson
What You’re Getting:This self-paced lesson introduces students to using formulas and functions in spreadsheet software like Google Sheets or Excel. Students will use this guided exploration to introduce students to arithmetic operators (+,−,∗,/) and several basic functions. Covered topics include: Excel/Google Sheets FormulasSUM() functionAVERAGE() functionMAX() functionMIN() functionCOUNTIF() functionCOUNTA() functionThis All-in-One Package can serve as the warmup, the notes and an exit ticket
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
Google Sheets and Microsoft Excel: Spreadsheet Basics Lesson
What You’re Getting:This self-paced lesson introduces students to the fundamental interface of spreadsheet software like Google Sheets or Microsoft Excel, covering navigation within cells, rows, and columns. Students will use this guided exploration in Google Sheets to practice formatting options, including adjusting fonts, adding borders, and managing text alignment. This lesson establishes the groundwork for four subsequent spreadsheet lessons, ensuring students are comfortable with the enviro
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
Reading Between the Lines - A Graphing Activity
This graphing activity is a fun way to combine Reading and Math. Using excerpts from school novels, students can create frequency tables and a variety of graphs either by hand or on the computer. This 1-2 class activity can be adapted for any grade level and can be done in small groups or individually. It can also be worked on over a period of time. Give it a try!
6th - 7th
Applied Math, Arithmetic, Basic Operations
Evaluating Linear Functions Self-Checking (Excel Sheet)!
This Excel Sheet features problems in which students must evaluate a linear function for a given value input or output. Students will be asked to evaluate linear functions from equations, tables, and graphs! As a challenge, students will be asked to find the sum of certain evaluations. As review, students will have to explain whether the relations represent functions and to explain why! This one Excel document has 4 sheets with a total of 6 extensive problems! As students answer the prob
8th - 9th
Algebra, Applied Math, Math
CCSS
HSF-IF.A.1
, HSF-IF.A.2
Excel PMT (payment) Function spreadsheet
This Excel spreadsheet demonstrates how to apply the Excel PMT (payment) function to calculate a monthly car payment, a mortgage payment, and a monthly investment in order to reach a future investment goal. This spreadsheet is to be used in conjunction with the Excel PMT reference guide.
7th - 12th, Adult Education
Applied Math
Also included in: Excel's PMT (Payment) Function for Loan and Investment Payments
Modeling with Sinudoidal Functions - Foxes and Rabbits
Sinusoidal functions are a staple of Algebra 2 and Pre-Calculus but the modeling problems in the textbooks are always so dry. I can't stand any more weights on a spring or riders on a ferris wheel! I wanted to make a problem that would be more interesting than the classic textbook tropes and I also wanted students to experience data that could be modeled this way. Of course, data is never perfect so the data provided here can be modeled with sine or cosine but no model will completely exact.
10th - 12th
Applied Math, Math, Other (Math)
CCSS
HSF-TF.B.5
Graphing and Analyzing Functions on a Spreadsheet
This math activity allows students to investigate the behavior of functions (Quadratic, Cubic, Hyperbolic and Exponential) by adjusting the domain over which the functions are viewed. Students are guided with step by step instructions on how to program a blank spreadsheet to graph functions of their choosing over intervals that they specify. Graphs are manipulated and students are guided to look at growth rates of functions and how they behave as they approach larger and smaller values. Real
10th - 12th
Algebra 2, Applied Math, Graphing
Piecewise Function Project
Somtimes a simple regression function is not the best fit and creating a piecewise function is the better way to write an equation to fit data or a situation. Here is a project to help assess whether they understand how to create a piecewise funciton to model a scenario about a parachute jump or insurance rates.
Included: a project with two scenarios and a rubric for each.
10th - 12th
Applied Math, Math, PreCalculus
Data Tables and Key
Tables of Random Data for use with statistics. EAch table has 7 piece of data. Also the commands are in the excel file so that numbers can be changed. The key is included that is set up to display the equivalent angles in a pie chart, gives Q!, 2, 3, and max and min. Used for beginning STATs
7th - 11th
Applied Math, Math, Statistics
Basic Excel spreadsheet lesson plan. Suitable for grades 5-9.
Using this spreadsheet sesson, students will create a record of earning form their part time job. They will compute gross pay, make deductions, and compute net pay for a five week period. They will learn to format cells to accept numbers, decimals, and text. In the complete file, there are directions and samples.
5th - 9th
Applied Math, Basic Operations
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 progre
9th - 12th
Applied Math, Computer Science - Technology, Statistics
Cars and Colleges Excel Mini Project
This product is a great exercise to assess basic Excel skills while also delving into the costs of buying cars and college costs.
Excel skills that are assessed include:
-Typing into cells
-Formatting cells to bold
-Basic Excel operators (Add/Subtract/Multiply/Divide)
-Creating bar graphs and pie charts
A suggested daily schedule is included, as well as suggested grading standards.
Check out my other personal finance products:
Critiquing BudgetsDeceptive Advertising ProjectIdentity Theft P
9th - 12th
Applied Math, Other (Math)
Data Collection and Analysis Project
This project was designed to help students understand how data functions in their daily lives. The goal of this project is for students to: Collect Data Analyze DataMeanMedianModeStandard DeviationZ-ScoreNormal DistributionPercentagesWrite a few sentences to solidify their understanding of how the mathematical concepts they used pertain to the data they collected.This project is in 3 parts. Part 1 - Data Collection - EXCEL AND WALKTHROUGH DOCStudents must download an Excel document (doing it on
9th - 12th
Applied Math, Math, Statistics
Multiplication Meme Practice Puzzle (0-9)
Students will complete 20 problems from the 0-9 multiplication tables. For every correct answer, a puzzle piece will appear. There are incorrect fractions embedded in the formula in case students try to look up the answer. The correct answers are hidden on a separate sheet - that is also hidden - and codded in the formula bar so students cannot easily "hack" the right answers.
2nd - 8th
Applied Math, Math, Mental Math
Google Sheets and Microsoft Excel: Advanced Formulas & Logic Lesson
What You’re Getting:This self-paced lesson introduces students to several advanced and logic spreadsheet functions. Covered skills include: IF() functionAND() functionOR() functionVLOOKUP() functionThis All-in-One Package can serve as the warmup, the notes and an exit ticket or short homework assignment. Self-Paced Lesson:This student-driven lesson is designed to introduce students to several advanced logic spreadsheet functions for Microsoft Excel and Google Sheets through three major component
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
MATH: Digitizing Books Linear Equation Task, 30 versions
A task where students model the time it will take to digitize a book as function of the number of pages using a linear equation. They then solve various problems with that equation. No algebraic solving is required. There are 30 different versions of the task so that students can work together without giving the answers away to each other. A pdf is provided including an answer key. If you want to modify the activity there is also an editable docx file which uses a mail merge from an excel fil
8th - 10th
Algebra, Applied Math, Graphing
1st-2nd Grade Fractions with Word Problems (w/ pictures)
This is a packet of (8) word problems on two sheets, involving both fractions, and connecting fractions to basic addition and subtraction. I used this with my entire first grade class, but this sheet is the REMEDIAL sheet for students who are less proficient. It includes pictures in most of the boxes (instead of requiring them to draw), and also includes the "solve-for" statements next to the answer boxes. I have another sheet almost identical for more advanced students that does NOT include t
1st
Applied Math, Arithmetic, Fractions
Interactive Budgeting
This program can be used for personal budgeting, to teach budgeting to students or adults, or to teach excel spreadsheet functions. There is a main menu that allows you navigate easily between components. This is a very comprehensive budgeting program that lets you set your income, expenses in the actuals necessities page. Filling this in will actually fill in each monthly tab totals. In this program you can set spending goals in the goals necessities and extras pages which will flow over to
PreK - 12th, Adult Education, Higher Education
Applied Math
Calculate Your Future Paycheck/Paystub– With W4, Fed & State Taxes & Retirement
EDITABLE. Students use their future salary as the basis for this 2+ day activity that has them completing a W-4, looking at tax tables, learning about FICA and 401K matching…all while calculating their net pay! This resource teaches students how income tax withholding, FICA, insurance deductions, and retirement contributions impact their paystub – turning gross pay into actual take-home pay. Students will research real salary data, reference authentic tax forms, learn about union dues and decid
9th - 12th, Higher Education
Applied Math, Business, Financial Literacy
Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
What You’re Getting:These five self-paced lessons introduce students to the interface of spreadsheet software like Google Sheets or Microsoft Excel, covering navigation within cells, formatting, formulas, functions, cell references, and charts. Covered skills include: Freezing rows/columnsMaking text bold (Ctrl+B), italics (Ctrl+I), strikethrough, underline (Ctrl+U)Adding bordersAdjusting column/row widthsChanging horizontal alignmentChanging the fill color of a cellApplying conditional formatti
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Budget Sheet Assignment
This sheet is a mock example of a person's expenses over the course of three months. It asks students to use technology like excel or google sheets to create tables of expenses. Then compare those tables with an average monthly spending budget sheet. This is mainly to be used to have students practice entering data into the spreadsheet and use the "sum" and "average" equations in the spreadsheet. Afterwards, the students can compare the expenses with the income to see if the budget is over or un
9th - 12th
Applied Math, Statistics
Statistics Spreadsheet Activity - Normal Distribution (1 day)
This is a 1 day spreadsheet activity for a Statistics class. It uses spreadsheets as a walkthrough to allow students to explore the Normal Distribution, as well as use the RAND function to simulate IQ scores to generate Normal data. The product includes: 7.4 Spreadsheet Activity (in xlsx format) Teacher instructions Answer Key included. *The topics covered are Normal distribution, RAND, NORMDIST, & INVNORM functions, as well as the absolute reference "$". The documents are Excel based, pdf
9th - 12th
Applied Math, Math, Statistics
CCSS
HSS-ID.A.4
The Quadratic Formula and Finding Roots Using Goal Seek on a Spreadsheet
Students will be guided to produce a spreadsheet from a blank Excel workbook that uses the quadratic formula to find the roots of a quadratic equation. They will then be guided to graph the functions and see the intersection points of the graph with the X axis.
Then other nonlinear functions will be solved using Goal Seek. Goal Seek is a trial and error that allows students to solve equations that cannot be solved algebraically. Students will bring all terms of the equation to one side and
8th - 12th
Algebra, Algebra 2, Applied Math
Financial Future Project: Research salary, calculate paycheck & college expenses
EDITABLE. After researching their state-specific, median salary and calculating the educational costs for that career, students use their future salary as the basis for their paystub activity. They will complete a W-4, look at tax tables, learn about FICA and 401K matching…all while calculating their net pay! This resource teaches students how income tax withholding, FICA, insurance deductions, and retirement contributions impact their paycheck – turning gross pay into actual take-home pay. Stu
9th - 12th
Applied Math, Business, Financial Literacy
Showing 1-24 of 49+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands