Basic Function Tables
21+ results
Filters
Grade
Subject
Format
Resource type
Audience
Supports
Google Sheets Beginner Lesson
This activity will give students an understanding of basic Google Sheets functions such as, adding data to cells and inserting a chart based on the data. Great for beginners!
3rd - 5th
Computer Science - Technology, Graphing
Using Spreadsheets to Investigate Candy Color and Size Distribution
Hi Teachers! In this project, students practice with entering and formatting candy size and color data, making basic spreadsheet formulas, and using the SUM, AVERAGE, and COUNTIF functions. Students may also practice making 2D or 3D pie charts based on the %s of sizes of candies, and the %s of colors of the candies. Material expenses include a bulk bag of small Wonka Nerds boxes, small Ziploc-style baggies, and Sharpies. This could be modified to involve only color data of other candies, such as
4th - 7th
Computer Science - Technology, Graphing, Science
Spreadsheet - Basics Introduction & Graphing
**Please Read before purchasing**The instructions and tutorials are in Microsoft PowerPoint, which is required to access them, but the activities can be completed in either Excel or Google Slides. This lesson guides students through animation and a tutorial video before completing the assignments. It is completely paperless with no prep, and activities are done on either Microsoft Excel or Google Sheets. The instruction slideshow is only accessible in Microsoft PowerPoint. Students learn to ent
1st - 8th
Computer Science - Technology, Graphing
Creating Data Tables and Graphs in Google Sheets
This is an activity that walks students through the process of organizing and entering data into a data table and then using that data to generate line, bar, and pie charts. Once the graphs are generated, the process of formatting and editing the different parts of each graph is explained.
4th - 12th, Adult Education, Higher Education
Graphing, Math, Science
Spreadsheet Basics 3 - Graphing
Help your students increase their ability to access and analyze information by learning to create graphs from computer spreadsheets with Spreadsheet Basics - Graphing. This resource is no prep, with narration and instructional videos that will help you foster critical thinking and problem solving skills. The only thing your students will need is the link to the resource to begin learning important new skills. Please look at the Preview and Video to take a closer look!This online activity is br
4th - 7th
Computer Science - Technology, Graphing, Instructional Technology
Also included in: Custom Bundle for Danielle A.
Basics of Excel: Working With Charts and Data on Macs
Step by Step lesson on creating charts, sorting and manipulating data in Excel Mac Version. This is a lesson for teachers trying to use assessment or other data to report or as a student lesson on using Excel.
4th - 12th, Adult Education, Higher Education
Computer Science - Technology, Graphing
Bar Graph for Beginners (editable!)
This is a simple bar graph that will display basic data. It is editable so you can change the title & choices to suit your lesson. You can also adjust the width of the columns in order to add more choices for voting. If you fill in the data, it can even be used as an assessment. It is an excel document, so be mindful of the print area.
1st - 2nd
Elections - Voting, Graphing, Math
Functionator 5000 A graphing calculator/equation editor decay & growth
I built this Excel document to show what happens to lines and tables when you change variables and constants within an equations. There are three sheets:
y = mx+b
ax^2 + bx +c =0
c = p(1-r)^t
For instance, on the linear equation sheet, you can change m & b separately to see changes in the table and the graph. You can trace all equations. Much fun can be had.
5th - 12th, Adult Education, Higher Education
Algebra, Algebra 2, Graphing
Halloween Pixel Art Excel/Google Sheets
Microsoft Excel activity to use upper elementary or middle school students? This great lesson incorporates art as students learn the basics of Microsoft Excel.These are also fun lessons to use if you just need something for a one day lesson.
This download includes:
1. Teacher & Student Resources
2. Excel Template for Pixel Art
3. Legends and Sample Pictures for 3 Halloween Pictures
When completed let students make their own pictures, they will love it!
I've used this with 6th and 7th graders
5th - 9th
Graphic Arts, Graphing
Excel Graph Paper Miscellaneous
This excel file includes graph paper other than coordinate grids. Number lines, 3 space graphing, 100 boards (good for percentage shading) and coordinate graphing with x-y tables are included in this spreadsheet.
5th - 12th
Algebra, Graphing
Simple Excel Spreadsheets - Fruit Shop Data
A series of simple spreadsheets for students to use to collect and tabulate data in the theme of a fruit shop or stall. Graphs are created as data is entered into the prepared tables, which include a range of formulae. Students can look at examples of spreadsheets and graphs to discuss data and then create their own. Tried and tested with students of fourth and fifth grade age. Created by PowellsTeach.
4th - 6th
Computer Science - Technology, Graphing
Weather Watcher's Monthly Bar Graph
After collecting data for the month on the Weather Watcher's Coloring Calendar, use this blank chart for analyzing the amount of each type of weather experienced in that month. This chart features colorful, easy to identify symbols for basic types of weather and clear instructions. All 12 months included in this package.
K - 3rd
Basic Principles, Earth Sciences, Graphing
Microsoft Excel Spring Math & Vocabulary Activities
These activities are for students with no prior experience using Microsoft Excel. Spring themed lessons to introduce younger students to using Microsoft Excel. Aligned with Common Core, students will count, graph, answer more or less questions, and either add the numbers manually or by using the AutoSum Function in Microsoft Excel. It is your choice! There are separate directions to teach students how to use the AutoSum Function in Microsoft Excel if you choose. Each spreadsheet has different da
K - 2nd
Graphing, Vocabulary
Excel Spreadsheets Million Dollars Activity
Students use this spreadsheet activity 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. 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
5th - 12th, Adult Education
Computer Science - Technology, Graphing, Instructional Technology
Candy Math Quiz for Grades 3-8
This quiz is a fun way to assess your students in their chart making skills in Excel along with their problem solving skills.
Part 1 of the quiz students are to pretend they have been given a bag of candy. They are to create a table then a chart with their data.
Part 2 of the quiz you give your students candy and this time they have to record the actual amount and make a table and a chart.
Part 3 of the quiz test basic formula writing.
Common Core - 3.MD.3. Draw a scaled picture graph and
3rd - 9th
Applied Math, Graphing
Report writing for students
You can view the images and hear my narration at YouTube URL
https://youtu.be/7HeXCH_rDMY
Copyright (C) Peter Rony 2015 All rights reserved.
I am a chemical engineering educator by profession. This PDF is an important STEM activity that is targeted for teachers starting at level 3 and continuing to level 12. It is not sufficient to have just a laboratory course. As much as possible, students should obtain quantitative “data” as a result of their experiments -- and not just qualitativ
3rd - 12th
Engineering, Graphing, Writing
How To Graph Using Google Spreadsheets
This is a step-by-step guide on how to use Google Spreadsheets for students in grades 5-12. Use this as a resource when guiding students through the process. Included with the directions is sample data for students to use when practicing graphing. Perfect for science experiments and science fair!
5th - 12th
Basic Principles, Engineering, Graphing
Adding Integers - Model on a Number Line
This activity provides 3 examples for the teacher to go through with the class, along with 3 extra examples for students to try individually and/or with a partner. It also includes 20 practice problems to ensure each student can not only solve an adding integers problem correctly, but they can also model it on a number line.
This file is saved in Excel, so when you print make sure you select print entire workbook. Also, since it is in Excel, feel free to change the problems as you see fit!
5th - 7th
Basic Operations, Graphing, Numbers
Addition Facts - Chart of Progress for Student *Editable!
This is a great little graph your students can use to chart their progress with their math facts. I have left this as an excel spreadsheet so that you can edit it as needed. The graph includes a place for the date, type of math fact (+1, +2, etc), number of facts completed, and room for your student to color in how many facts they completed for the day. Students really love seeing the progress they make! Great to use at conferences or to turn in as artifacts for your professional development
K - 3rd
Basic Operations, Graphing, Math
Subtraction Facts - Chart of Progress for Students *Editable!
This is a great little graph your students can use to chart their progress with their math facts. I have left this as an excel spreadsheet so that you can edit it as needed. The graph includes a place for the date, type of math fact (-1, -2, etc), number of facts completed, and room for your student to color in how many facts they completed for the day. Students really love seeing the progress they make! Great to use at conferences or to turn in as artifacts for your professional development por
K - 3rd
Basic Operations, Graphing, Math
Math Fact Self Graphing Worksheet
This worksheet allows student to graph their Math scores out of 25 problems.
1st - 8th
Basic Operations, Graphing
Showing 1-21 of 21+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands