Lesson Plans and Worksheets
Browse by Subject
Columns and Rows Teacher Resources
Find Columns and Rows educational ideas and activities
Do your learners like dinosaurs and theme parks? An ambitious lesson plan 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 spreadsheet that has information on cost, size, and weight of the dinosaurs. They must also produce a document which describes their plan.
Students make spreadsheets and pie charts. In this spreadsheet and pie chart lesson, students set up a spreadsheet by making header rows and labels. They chart a cup full of M & M candies in the spreadsheet before making a pie chart that shows the distribution of candy colors in their cup.
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals create a tool to help them plan and stay on track for eating healthy. Most of this project is done outside of class, actual class time is approximately 1-2 hours. While an interesting project, nutritionally speaking, the math and analysis is relatively basic.
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length and record their data on a spreadsheet.
Fourth graders practice using a spreadsheet to compare and contrast data. Using a primary source, they locate and enter data into the appropriate cells and discuss and graph the information to show how it has changed over time. They share their information with the class to end the lesson.
Students are introduced to spreadsheets and assess how to enter numbers, labels and simple data into a spreadsheet and how to use the data to calculate totals. They are also introduced to spreadsheet software that enables them to explore mathematical and scientific models.