Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
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
M&M Graphing
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
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...
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,...
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
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
Using a Spreadsheet
Students create a spreadsheet to analyze data. In this technology activity, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Curated OER
Weather
Students create a spreadsheet and chart using data collected. In this weather lesson, students select five cities from their state, including the city they live in. Students take daily temperature readings from all five cities. ...
Curated OER
Spreadsheet Project: Planning a Party
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
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
Writing Fables
Students write their own fables. In this writing fables lesson, students use handheld computers to write a fable. The class designs a spreadsheet to organize common elements of fables. Students also edit each others' work.
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,...
Texas Education Agency (TEA)
Advanced Technical Skills in Business
Scholars put their technical skills to the test as they practice writing a business letter, creating charts and spreadsheets, and designing a flyer. Additionally, pupils create a PowerPoint presentation about a professional topic of...
Curated OER
Party Math
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Curated OER
Graph Frenzy!!
Young scholars brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Curated OER
PowerPoint Project for Creating a New Business
Pupils create a mock new business for which they design a PowerPoint presentation. They include company information, financial statements, graphs, advertising and management promotion pages in the final presentation.
Curated OER
Creating a Nutrition Table in MicroSoftExcel
Middle schoolers access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Curated OER
Endangered Species
In this geography learning exercise, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
Correlation of Variables by Graphing
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Curated OER
Sorting
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.