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
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Curated OER
Spreadsheets and Database in Social Studies
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Curated OER
Moving Day!
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Curated OER
Super Spreadsheets
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Curated OER
Creating a Spreadsheet
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Curated OER
Using Computers to Produce Spreadsheets and Bar Graphs
Students 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
Graphs! Graphs! Graphs!
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson plan.
Curated OER
Pedestrian Safety for Students
Young scholars create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Curated OER
Finding Mean, Mode and Median in the Computer Lab
Young scholars create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Curated OER
Electronic Spreadsheets & Iditarod 2000
Learners 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
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
Excel Lesson
Young scholars explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Curated OER
Comuter Technology-Applying Spreadsheet Information
Students create spreadsheets and practice sorting within the spreadsheet with three different activities. Students manipulate different materials such as addresses, real estate sales, and athletic participation numbers.
Curated OER
Running a Business
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
Curated OER
Graphs and Spreadsheets
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Curated OER
Graphing With Second Graders
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.
Curated OER
Baseball Relationships - Using Scatter Plots
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
World Education Statistics
Young scholars use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Curated OER
Spreadsheets - WP9/Quattro Pro
Students discover spreadsheet applications using Quattro Pro. They demonstrate basic knowledge and application of hardware, software, and Internet use. They recognize and appreciate the value of recording keeping, data input and data...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Putting Your Money to Work
Students create a collect data on expenses. In this algebra lesson, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson.