Columns and Rows Teacher Resources

Find Columns and Rows educational ideas and activities

Showing 1 - 20 of 292 resources
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to create a website to present their information.
Students identify spreadsheet terms, create a spreadsheet about nutritional contents of foods, and add the columns of the spreadsheet.
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the graph are listed in a step-by-step format.
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 spreadsheet that has information on cost, size, and weight of the dinosaurs. They must also produce a document which describes their plan.
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 use a teacher made spreadsheet to explore how calculations work. Then student teams work together to create their own store order form on a spreadsheet. They play a simulated game show where students shop at each others stores.
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.
Students enter data and formulas into spreadsheet software in order to calculate the area of a rectangle, and copy and paste the formula to other cells in the spreadsheet software in order to calculate the area of other rectangles.
Students discover the advantage of using spreadsheet software for calculations and learn the vocabulary involved. They learn to compute the mean, median, mode, and range of a set of data using the spreadsheet software.
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.
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.
Students practice using a spreadsheet as a graphing and statistical tool. They review concepts of mean, median and range. They create their own rows and columns and enter formulas.
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve problems as well.
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.
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.
Fourth graders predict colors of M&Ms and collect data after opening the bag. They graph their data on a grid and draw conclusions about the color distribution and numbers of candies in bags. Theycreate a spreadsheet on the computer and enter their data.
Ninth graders access a database and open a spreadsheet.  In this oxygen and water temperature lesson plan students save the database, sort it and generate scatter plot graphs. 
Students graph and analyze data using a spreadsheet.
Pupils are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
Young scholars create a spreadsheet to track their spending. In this algebra lesson plan, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and house.

Browse by Subject


Columns and Rows