Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis instructional activity students use an Excel spreadsheet to map their data.
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create the graph are...
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Spreadsheet Budget Project
Eighth graders record all the food they eat for one week, compute the costs for all of this food, and display the different categories on a spreadsheet and then convert to a chart.
Curated OER
Tasty Tech Activity With Excel
Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
Curated OER
Using a Spreadsheet to Understand Density
Learners use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Curated OER
Lesson Plan Outline for Rainbow Science
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz instructional activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced...
Curated OER
Virtual Field Trip
Are we there yet? Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
Texas Instruments
Exploring Basic Equations
Learners explore equations with constants, variables and with exponents. They identify and define variables, constants, exponents, expressions, and equations, as well as give an example of each. Your class will also draw their...
Curated OER
Second Star To the Left and Straight On 'Till Morning" - Spreadsheet Driven Exploration of Pacific Asian Geography
Students explore the geography of Pacific Asia. The class is divided into two groups to participate in a role-play activity where they act as European explorers. Students utilize mathematics, spreadsheet and internet technology to make...
Curated OER
Checkbook
Develop life skills through the use of an AppleWorks Banking kit, a spreadsheet program, and a role play activity. This life skills lesson utilizes technology plus busines and social studies principles. Note: All materials suggested can...
Curated OER
Don't Settle for a Byte... Get the Megabyte on Technology
Young scholars use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and...
Curated OER
Monitoring Math with a Statistical Spreadsheet
Learners use a spreadsheet to compute landmark statistics of a math
quiz. This instructional activity can be ongoing throughout the school year and it integrates mathematics curriculum and technology in a simple format for student use.
Curated OER
Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Curated OER
Using a spreadsheet and the Internet to learn about stock market performance
Students record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson plan throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data...