Search Results (20)

View
Selected filters:
  • Spreadsheet
ACC Basketball
Conditions of Use:
Remix and Share
Rating

The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season which takes approximately 15 weeks from the middle of November to the middle of March. Teachers must have Clarisworks to open the sample spreadsheet in the lesson, but may recreate it in another spreadsheet program.

Subject:
Statistics and Probability
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Susan Dougherty
Date Added:
07/14/2000
Camp Earth Bound: Problem Solving and Finding for Fun
Conditions of Use:
Remix and Share
Rating

Students will work together in small groups of four to six students to solve the following word problems. Their solutions will require them to practice interview techniques and create a database and/or spreadsheet of their results. This information will be the basis of the answers to the following eight word problems. Skills such as area, cost, calorie count, ratio, percentage and scale, as well as persuasive writing will be applied.

Subject:
Mathematics
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Jamie Hulse
Date Added:
03/19/2001
Computer Skills for Success: A Step by Step guide
Conditions of Use:
Remix and Share
Rating

This introductory class of computer skills is comprised of units that focus on basic computer hardware and the following applications: Word 2010, Excel 2010, PowerPoint 2010, Photo Gallery, and Audacity. Most units begin with YouTube overviews or 'how to' presentations followed by step by step guides to using aspects of the application and then have assessment exercises and conclude with a final project for evaluation.

Material Type:
Assessment
Full Course
Lecture
Author:
Keith Martin
Date Added:
01/28/2016
Creating a Spreadsheet
Conditions of Use:
Remix and Share
Rating

Students create a spreadsheet to quantify, analyze and determine the experiences and views towards technology of the Computer Commuter users.

Students create the layout of the spreadsheet that best suits the data in the survey. Questions are in different formats: multiple choice and short answer. The student must determine how to set up the spreadsheet to make the data easy and efficiently understandable.

Subject:
Career and Technical Education
Material Type:
Activity/Lab
Data Set
Lesson
Lesson Plan
Author:
Mary Quick
Date Added:
05/02/2018
Dear Tootsie Roll Company
Conditions of Use:
Remix and Share
Rating

The students will measure the surface area and wrapper area of five pieces of candy. They will use appropriate formulas and measuring techniques to complete information needed for a spreadsheet and database. They will write a letter to the company with the most wasted paper to explain how the waste affects them as consumers and a suggestion for correcting the problem.

Subject:
Arts and Humanities
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Tonya Thompson
Date Added:
06/30/2000
Energy Perspectives
Conditions of Use:
Read the Fine Print
Rating

Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students pick (or the teacher assigns) one of the data tables from which students create plots and interpret the information provided. Student groups share with the class their interpretations and new perspectives on energy resources and use.

Subject:
Engineering
Environmental Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Jan DeWaters
Susan Powers
Date Added:
09/18/2014
Energy Usage Spreadsheet CATE Lesson Plan
Conditions of Use:
Remix and Share
Rating

Students will be using real-life energy use data to learn how to use spreadsheets and create graphs to better organize and view data. Discussions can then follow to analyze the data and explain the usage. Real rates are then provided, and students can use the electricity consumed data to create a utility bill for the consumer and compare the standard Residential Service charges to if the member were instead billed by the “Time of Use” rate.

Subject:
Measurement and Data
Numbers and Operations
Material Type:
Activity/Lab
Data Set
Lesson Plan
Primary Source
Date Added:
08/15/2017
Engineering Economy Module, Fall 2009
Conditions of Use:
Remix and Share
Rating

" This intensive micro-subject provides the necessary skills in Microsoftĺ¨ Excel spreadsheet modeling for ESD.71 Engineering Systems Analysis for Design. Its purpose is to bring entering students up to speed on some of the advanced techniques that we routinely use in analysis. It is motivated by our experience that many students only have an introductory knowledge of Excel, and thus waste a lot of time thrashing about unproductively. Many people think they know Excel, but overlook many efficient tools, such as Data Table and Goal Seek. It is also useful for a variety of other subjects."

Subject:
Engineering
Material Type:
Full Course
Provider:
MIT
Provider Set:
MIT OpenCourseWare
Author:
Cardin, Michel-Alexandre
de Neufville, Richard
Date Added:
01/01/2009
Epidemic
Conditions of Use:
Remix and Share
Rating

This paper presents real-world data, a problem statement, and discussion of a common approach to modeling that data, including student responses. In particular, we provide time-series data on the number of boys bedridden due to an outbreak of influenza at an English boarding school and ask students to build a mathematical model, either discrete or continuous, of this epidemic, and to estimate the parameters in their model and validate it against the data. Students will need access to a computer or computer lab with spreadsheet software, a computer algebra system, or a sufficient statistical analysis system such as R.

Subject:
Applied Science
Life Science
Material Type:
Module
Date Added:
04/01/2017
Flood Analysis
Conditions of Use:
Read the Fine Print
Rating

Students learn how to use and graph real-world stream gage data to create event and annual hydrographs and calculate flood frequency statistics. Using an Excel spreadsheet of real-world event, annual and peak streamflow data, they manipulate the data (converting units, sorting, ranking, plotting), solve problems using equations, and calculate return periods and probabilities. Prompted by worksheet questions, they analyze the runoff data as engineers would. Students learn how hydrographs help engineers make decisions and recommendations to community stakeholders concerning water resources and flooding.

Subject:
Engineering
Hydrology
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Emily Gill
Malinda Schaefer Zarske
Date Added:
09/18/2014
Holiday Shopper
Conditions of Use:
Remix and Share
Rating

This activity uses a prepared spreadsheet and the grocery sales paper from the newspaper to figure the cost of a holiday meal for a certain number of people.

Subject:
Education
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Stephanie Hurley
Date Added:
11/24/1999
Integrated Unit on South America
Conditions of Use:
Remix and Share
Rating

This lesson includes information concerning database operations, word processing, desktop publishing, and spreadsheet formatting. Students will solve math problems.

Subject:
Physical Geography
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
DPI Integration Strategies
Date Added:
12/26/2000
Interdisciplinary Integrated Unit on Dna/Genetics Part B: Math
Conditions of Use:
Remix and Share
Rating

This lesson is part of an interdisciplinary integrated unit on DNA and genetics. The idea is for students to complete a week's worth of activities in science, math, and language arts. This lesson is Part B: Math. Students will complete a math survey interviewing people on whether they believe humans should or should not be cloned. They will take the data they gather and create computer generated spreadsheets, charts/graphs. Using the charts/graphs, students will answer mathematical percent and ratio questions and write a final journal entry on the information they collected and discovered.

Subject:
Arts and Humanities
Genetics
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Jane Lentz
Jimmy White
Marlene Smith
Tori Goldrick
Date Added:
01/23/2003
Microsoft Excel
Conditions of Use:
Remix and Share
Rating

The aim of this unit is that upon completion, teachers will be able to use ICT to support class administration through the keeping of a digital class record system using a spreadsheet package.

Subject:
Educational Technology
Material Type:
Unit of Study
Author:
Ministry of Primary and Secondary Education Zimbabwe
Date Added:
12/07/2017
Popcorn Math
Conditions of Use:
Remix and Share
Rating

In this lesson students will use a consumable manipulative to understand percent, fraction and decimal conversions. They will also collect data on a teacher produced spreadsheet while using a computer generated spreadsheet to make conversions.

Subject:
Mathematics
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Henrietta Shepherd
Date Added:
06/26/2001
Savor the Rainbow
Conditions of Use:
Remix and Share
Rating

Use skittles to help the students practice the concepts of sorting data, recording data, writing the data collected in fraction form (part/whole), changing the fractions into decimals and percents, and taking the data collected and making a spreadsheet, bar graph, and circle graph of the data.

Subject:
Mathematics
Material Type:
Lesson Plan
Provider:
University of North Carolina at Chapel Hill School of Education
Provider Set:
LEARN NC Lesson Plans
Author:
Beverly Revis
Date Added:
06/21/2000
Searching for Bigfoot and Others Like Him
Conditions of Use:
Read the Fine Print
Rating

Cryptids, creatures of questionable existence, are used as a source of data to guide students into the creation of their own GIS data layer in Google Earth. The activity serves the purpose of a tutorial to teach students how to make data layers with a simple subject. Then they use that skill on other topics such as plastics in their neighborhood.

Subject:
Engineering
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Andrey Koptelov
Nathan Howell
Date Added:
09/18/2014
Testing for Hardy-Weinberg Equilibrium
Conditions of Use:
Read the Fine Print
Rating

This Excel module provides a worksheet data and spreadsheet for investigating the Hardy Weinberg Equilibrium. Students do a Chi Square analysis.

Subject:
Biology
Material Type:
Activity/Lab
Data Set
Simulation
Provider:
BioQUEST Curriculum Consortium
Provider Set:
Numbers Count!
Author:
Claudia Neuhauser
Date Added:
11/18/2008