Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Curated OER
Basic Excel
Young scholars explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Young scholars title the columns on the spreadsheet and format the cells. Students...
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,...
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Curated OER
Using Computers to Produce Spreadsheets and Bar Graphs
Pupils review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Curated OER
Temperature High and Lows
Young scholars gather high and low temperature readings through email. In this temperature graphing activity, students use a spreadsheet to input data for a graph. young scholars interpret the graphs to compare and contrast the data from...
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Curated OER
Electronic Spreadsheets & Iditarod 2000
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Curated OER
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Curated OER
Holiday Cards using Publisher
Students create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Students organize, design, and edit their card.
Curated OER
Using Computer for Statistical Analysis
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
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
Embracing Diversity
Students explore and use different computer programs for collecting data. For this technology based lesson, students set up a survey and use the Excel and Lotus software to collect data.
Curated OER
Hot, Wet, and Cold
Students research climate data for a city in each of the 5 major geographic sections of Texas. They use data to describe the climate and what influence the geography of that section has on the weather.
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
Curated OER
Computer Technology- Spreadsheets
Students will be learning about how to create a budget. Give them the worksheet and have the students come up with how many items they will need for their Thanksgiving party and how much they think the items are worth. When they have...
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Curated OER
The Hot Dog Stand
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Curated OER
Spreadsheet Graphs
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Curated OER
Computer Science: Pendulum
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
Curated OER
Keypals and You
Students collect and compare data received from keypals. They use electronic mail to exchange information with keypals and rrite a paper comparing similarities and differences between themselves and their keypals. In addition, use a...