Feature Function Class
60+ results
Filters
Grade
Subject
Format
Resource type
Standard
Language
Programs & methods
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
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
Statistics Unit 9 Spreadsheet Activity - Hypothesis Testing, VLOOKUP, T-Test
This is a 2 day spreadsheet activity for a Statistics class. It uses spreadsheets as a walkthrough to allow students to organize data, form a hypothesis, find the T-statistic and p-value and use the decision criterion. The activity uses VLOOKUP, RANDBETWEEN, AVERAGE, STDEV.S, ABS, SQRT, and TDIST built-in spreadsheet functions. The product includes: Unit 9 Spreadsheet Activity (in xlsx format) Teacher instructions Answer Key included. *The topics covered are Hypothesis Testing, One Sample T-
10th - 12th, Higher Education
Applied Math, Statistics
Statistics Unit 8.2 Spreadsheet Activity - Confidence Intervals, T-distribution
This is a 1 day spreadsheet activity for a Statistics class. It uses spreadsheets as a walkthrough to allow students to explore the T-distribution, and form a 95% confidence interval from a data set. The product includes: 8.2 Spreadsheet Activity (in xlsx format) Teacher instructions Answer Key included. *The topics covered are Confidence Intervals (σ unknown), T-distribution, "AVERAGE", "STDEV.S", and "T.INV.2T" functions. The documents are Excel based, pdfs included, and completely editab
10th - 12th, Higher Education
Applied Math, 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
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
Stock Tracking Spreadsheet Template
This spreadsheet will allow students to track the value of individual stocks as well as a portfolio over any time range you please.This is an excel spreadsheet and will work seamlessly if you upload it to Google Drive to be used with Google Classroom, Canvas, Schoology, or any other LMS. Features:Allows students to track up to 8 stocks over 18 time periods (of any duration you choose).Automatic color-changing visualization of stock and portfolio gain or loss.Automatic line graph of portfolio val
7th - 12th
Applied Math, Economics , Statistics
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
Class Economy ENGLISH Tracker (Excel Spreadsheet)
This Excel sheet makes managing the classes expenses a breeze! It should also be editable for those who want to make changes
2nd - 12th
Applied Math, Math
Also included in:Â ENGLISH Class Economy BUNDLE
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
FRENCH - Class Economy Tracker (Excel Spreadsheet)
This Excel sheet makes managing the classes expenses a breeze! It should also be editable for those who want to make changes.
2nd - 12th
Applied Math, Math
Also included in:Â FRENCH Class Economy BUNDLE
BUNDLE - 4 Bingo Games to Review- Inequalities, Rational #'s, Angles, Circ.
This bundle features 4 bingo games to review with your students 4 different units. They cover rational numbers, angles, circumference, area, and inequalities. I used them all right before my students take a test and they love them as a fun way to review. They are each sold separately and add up to over $10 but I'm putting it in a bundle for a cheaper deal. I have a total of 16 bingo cards in each excel spreadsheet. There are two per page that you need to cut along the middle. Each pair of studen
7th
Applied Math, Decimals, Geometry
50-30-20 Budget Rule - Personal Finance - Personal Budget - Google Sheets
A great resource to introduce your personal finance class, or life skills class, to the 50-30-20 Budgeting Rule. I have used this in addition to having my students research the annual payment for a career they are interested in and then fill in all their wants and needs. I also use this for myself and my own budgeting! Each category is auto-totaled. Just put in your monthly pay, which will auto-calculate how much money you should spend in each category. Then, add your expenses, which will auto
9th - 12th
Applied Math, Business
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 reference 5 Worksheets 3 Quizzes "Do Now" Entrance problems Spreadsheet Activity - T-Distribution Review slides (for review response system) Unit test (with review packet) Unit Project - Gath
10th - 12th, Higher Education
Applied Math
CCSS
HSS-IC.A.1
, HSS-IC.B.4
, HSS-IC.B.6
 +2
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 reference 5 Worksheets 1 "Read & Respond" Article Worksheet 2 Quizzes "Do Now" Entrance problems Spreadsheet Activity - Hypothesis Testing Review slides (for peer presentations) Unit Review
10th - 12th, Higher Education
Applied Math
CCSS
HSS-ID.A.4
, HSS-ID.B.6a
, HSS-IC.A.1
 +3
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
Spreadsheet trig activity: modeling tides
Two spreadsheet activities for use in a computer lab or outside of class, creating and critiquing a trigonometric model for ocean level at Point Reyes, California. Apply trigonometry knowledge and then use numerical methods for rate of change. Real data is used, and students are prompted to think critically about their models.
11th - 12th, Higher Education
Applied Math, Calculus, Other (Math)
CCSS
HSF-TF.B.5
Online Bank
Add to your Google Drive! This Online Banking System is perfect for any class! Pair it with the Checkbook System, Part 1 (Part 2 isn't needed with this resource). This online banking system will allow you to input student names and easily see each student's bank balance. If students are interested to see their transactions (or if you want to quickly check their checkbook register), you can see all of their transactions (withdrawals, as well as deposits), all in one place by simply selecting the
4th - 12th, Adult Education, Higher Education
Applied Math, Math
Correlation Graph Generator
Have you ever wanted to generate randomized scatter plots for images to use in class notes, assignments, or tests? Look no further! This spreadsheet generates high resolution scatter plots with each of the following relationships: - Strong Positive Correlation - Weak Positive Correlation - Strong Negative Correlation - Weak Negative Correlation - No Correlation Each scatter plot is formatted in two ways: - With graph title and line of best fit (for instruction) - With no title or line of best
9th - 12th
Applied Math, Graphing, Math
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
Stock Market Challenge Simulation Spread Sheet
Here's a simple but elegant way of running a Stock Market Challenge in your Business / Economics classes. This spreadsheet allows for students to buy just two stocks and track them for whatever time period you choose. The spreadsheet is set up to track the Dow 30 stocks, but you as the Instructor can set whatever parameters you choose for this. I prefer to narrow the trading choices for my students for several reasons. One, the Dow 30 Index is used throughout the world with companies that are h
5th - 12th, Adult Education, Higher Education
Applied Math, Business, Economics
CCSS
MP1
, MP2
, MP4
Budget Bundle: High School Financial Literacy & Budgeting 9th 10th 11th 12th
Are you looking for new budgeting activities for your high school financial literacy, consumer math, or applied math class? Do you want your students in 9th, 10th, 11th, or 12th grade to practice balancing budgets, comparing budgets, and creating their own household budget? Here's a new budget bundle for you! What's Included: 2 PDFs, 1 Editable PowerPoint & 1 Excel Spreadsheet with over 25 Pages! Budget Dilemmas: In these worksheets, students are given three different household budgets that
9th - 12th
Applied Math, Family Consumer Sciences, Financial Literacy
CCSS
6.NS.B.2
, 6.NS.B.3
, 6.NS.C.5
 +6
Showing 1-24 of 60+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands