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. ...
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...
Council for Economic Education
Loan Amortization - Mortgage
When you buy a home for $100,000, you pay $100,000—right? On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
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
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
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
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.
Dominic Szablewski
Z-Type Concepts: Typing, Basic Computer Skills, Keyboarding
Your students will be typing faster than you in no time with the help of this fun game. Similar to the classic Atari game Space Invaders, students must type words to prevent space ships from attacking as they move from the top of the...
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
Pedestrian Safety for Students
Students create a spreadsheet. For 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
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
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
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson plan, 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
Sales Spreadsheet
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Fantasy Basketball
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Curated OER
Iterating Linear Functions
Young scholars use a spreadsheet to investigate data. In this algebra lesson, students collect and graph data on a coordinate plane. They explain properties of a linear equation both algebraically and orally.
Curated OER
Dough Lake Topology
Young scholars practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Curated OER
Iterating the Function over Real Numbers
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.
Curated OER
A Christmas Project
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Curated OER
Finding Mean, Mode and Median in the Computer Lab
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Curated OER
Reading + Keyboarding= Success
Students practice their keyboarding skills. In this typing lesson, students use interesting stories to practice their skills. They practice throughout the semester and then monitor their improvement.
Curated OER
World Education Statistics
Students 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
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.