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 a Spreadsheet
Students create a spreadsheet to analyze data. In this technology lesson, 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
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
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
Making a Spreadsheet
Students explore spreadsheet software. In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer. Students represent hotel, food, transportation, and entertainment costs...
Curated OER
Math Hunt
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra activity, 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
Graphing Favorite Fruit
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
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...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
ESL Kid Stuff
Daily Routines & Times of the Day
What time do you eat breakfast? Or go to school? Language learners practice crafting and answering questions about their daily routines.
Curated OER
Build Your Dream Science Lab
Would your ideal science lab be filled with bubbling beakers and zapping Tesla coils? Or would it contain state-of-the-art computer technology and data analysis? Dream big with an innovative lesson that connects math and language...
Inside Mathematics
Graphs (2006)
When told to describe a line, do your pupils list its color, length, and which side is high or low? Use a learning exercise that engages scholars to properly label line graphs. It then requests two applied reasoning answers.
Curated OER
Houses and Cars and Loans
Young scholars create a spreadsheet to track their spending. In this algebra instructional activity, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need...
Curated OER
ACC Basketball Statistics
Students use math skills and create a spreadsheet. In this statistics and computer skills lesson, students gather ACC basketball statistics, convert fractions to decimals and then percents. Students use the gathered information to create...
Curated OER
T-Shirt Lettering
Students determine the cost of a t-shirt using a variety of mathematical operations to solve problems. Then they use a spreadsheet to calculate the cost of lettering a t-shirt and display this information in a graph.
Curated OER
Triangle Midsegment
Learn how to calculate the length and midsegments of triangles. Learners differentiate between similar and congruent triangles. They create a spreadsheet with their findings.
Curated OER
Thinking Outside the Box
Now this lesson sounds fun! Students throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Curated OER
Budget Making
Students develop a budget for spending and saving. In this economics lesson, students create a budget based on personal, family and government income. They discuss jobs at home and allowances. They discuss how they manage their money...
Curated OER
Introduction to the National Debt
Students relate the national debt to the economy. In this algebra lesson, students discuss what the national debt is, create a national budget based on priority and what the government should spend money on. They analyze their findings...
Curated OER
What's your favorite physical fitness activity?
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Curated OER
Metrically Me!
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.