Basic Function Tables

5+ results

Creating Frequency Tables and Histograms in MS Excel 2007

Created by

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)

Created by

Mountainworks Education

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

Entry Level Spreadsheet Assignment

Created by

Mr B's Bustling Educational Resource Store

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

Created by

The Tropical Science Teacher

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

Created by

Data Analytics Curriculum

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