Basic Function Tables
12+ results
Filters
Grade
Subject
Format
Resource type
Standard
Audience
MICROSOFT EXCEL: Skills Lesson - Beginner Level 4 - Functions & Tables
Turn Microsoft Excel Basics into Real, Transferable Skills🍔📊This ready-to-use Microsoft Excel skills lesson teaches spreadsheet fundamentals using a high-interest topic— fast food prices. Students stay engaged while learning how to format data, sort tables, and use essential formulas they’ll use in real life and future careers 💻✨. Why teachers love this lesson ❤️ No prep required—download, assign, and go ⏱️ Real-world data keeps students focused and motivated 🧠 Clear, step-by-step direction
5th - 12th
Business, Computer Science - Technology, Instructional Technology
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint AND Video)
Pay just $2 more to get my PowerPoint lesson and my instructional video version of this lesson. Now you will have both options...teaching the lesson yourself, or assigning the video to your students. *Please note that the only difference between the two downloads is that one is a PowerPoint lesson and one is a video lesson. The instructional content is the same; only the format of the lesson is different.*Step-by-step directions on how to how to make calculations using real estate data. The le
8th - 11th
Computer Science - Technology, Instructional Technology
Microsoft Excel Lesson 3: Functions & Pivot Tables (PowerPoint)
Step-by-step directions (78 slides) on how to how to make calculations using real estate data. The lesson includes: Basic formulas such as calculating how much houses are selling per square foot, IF Functions to determine if realtors earned a bonus, SUMIF Functions to determine how much each realtor sold,Creating Pivot Tables to analyze data, such as how many homes are selling in certain neighborhoods.TEST where students are given a new set of data and directions for what sort of calculations
8th - 11th
Computer Science - Technology, Instructional Technology
Also included in: Microsoft Excel Lessons PowerPoint BUNDLE
Creating Frequency Tables and Histograms in MS Excel 2007
This activity looks at a realistic data set and walks the student through constructing a frequency table and histogram using Microsoft Excel. It should be noted that Excel is not the best software package for creating histograms, but because it one of, it not the most widely used software package for data storage and presentation in business, it is important to know how to create professional-looking and statistically accurate graphics using this tool.
There are two different ways to constru
11th - 12th, Higher Education
Graphing, Statistics
Geometry Unit 2.3 Activity - Spreadsheets Truth Tables (1 day)
This is an activity that serves as a basic introduction to spreadsheets, using the AND, OR, and IF formulas built into Excel/Google Sheets. Students will input formulas into a spreadsheet, interpret logic statements like "A 60 degree angle is acute", and build a truth table into the spreadsheet. It is a nice introductory activity that allows students to follow instructions and discover functional notation, Boolean Operators (TRUE and FALSE), creating functions in spreadsheets, and using techn
8th - 11th
Geometry, Math
CCSS
HSF-BF.A.1
, HSF-BF.A.1c
, HSG-MG.A.3
Times Tables (Multiplication) speed sheets
A mix of 100 questions for timestables quizzes using excel for all times tables. It uses a random number generator for each test paper. There are 100 questions per sheet. This resource is great as it will generate a new worksheet every time due to the random function
1st - 8th
Basic Operations, Math, Mental Math
Input Output Tables Worksheet
Input Output Tables Worksheet: This set of Function Tables contains 30 printable practice pages, complete with an answer key. The worksheets aim to enhance students' understanding of addition and subtraction in the context of function tables. Within this set, there are 9 pages where the function rule is provided, allowing students to practice completing the tables accordingly. Additionally, there are 6 pages that challenge students to determine the rule themselves. All worksheets are designed i
K - 2nd
Basic Operations, Math, Numbers
Entry Level Spreadsheet Assignment
This Excel Basics Assignment is designed as an excellent entry-level project for students who are new to spreadsheets and want to develop fundamental skills in data organization, analysis, and visualization using Microsoft Excel. The assignment focuses on three key areas: Formatting, Formulas, and Graphing. Students will gain hands-on experience in utilizing essential features and functions of Excel while working with sample data sets. By completing this assignment, students will not only learn
9th - 12th, Adult Education
Business, Computer Science - Technology, Math
Google Sheets Quick Reference Guide
Do you need to teach your students the very basics of using tables and formulas in Google Sheets? I have create a simple quick reference guide that students can use as they are learning how to use Google Sheets. I found my students had never created formulas or used functions in Sheets before so I needed to create a cheat sheet that laid out the steps for them to use in the future. This guide includes examples and video tutorials of the major steps.
4th - 12th
General Science, Math, Science
Excel 365 Online for Intro Statistics - Assignment 1 Frequencies
Are you looking for a ready-to-use, engaging, and easy-to-follow assignment that teaches students how to create frequency tables and histograms in Excel Online (Office 365)? This resource is perfect for introducing data analysis, visualization, and statistical thinking in a way that’s interactive and practical. This resource is a supplement activity for introductory statistics and can be used in secondary or college courses or for independent and professional learning. Assignment 1 covers · B
7th - 12th, Adult Education, Higher Education
Business, Computer Science - Technology, Statistics
Excel Practice Bundle #1
Help your students ACE Microsoft Excel with a bundle of 10 short practice activities. In my classroom, I use these as bell ringers. They each take about 10-15 minutes to complete. They come complete with start file downloads, video tutorials, and completed keys so students can check their work. These can be used as reviews for the MOS exams, bell ringer activities, or as stand-alone learning activities. Each activity covers different skills/tools in Excel. Here is a list of skills/tools cov
8th - 12th, Adult Education, Higher Education
Business, Computer Science - Technology
Spreadsheets: Excel Lessons and Worksheets (6 Lessons)
Spreadsheet Superpowers: a 6 lesson unit that makes data skills clickTransform your spreadsheet lessons with this practical 6 lesson unit for Computing and Digital Literacy classes. Spreadsheet Superpowers is designed to build real confidence with Excel and spreadsheets using relatable scenarios and step by step modelling so every learner can succeed. Every lesson is fully planned and ready to teach, so non-specialists and busy teachers can deliver with confidence. Students do not just type numb
9th - 10th
Computer Science - Technology
CCSS
RST.9-10.3
, RST.9-10.4
, MP1
+2
Showing 1-12 of 12+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands