Columns and Rows Teacher Resources
Find Columns and Rows educational ideas and activities
Showing 1 - 20 of 289 resources
Don't Settle for a Byte... Get the Megabyte on Technology
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.
Spreadsheets for Dinner
Students identify spreadsheet terms, create a spreadsheet about nutritional contents of foods, and add the columns of the spreadsheet.
Creating a Spreadsheet and Graph
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.
Introduction To Spreadsheets
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.
Creating A Simple Spreadsheet and Pie Chart
Students make spreadsheets and pie charts. In this spreadsheet and pie chart lesson plan, 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.
Spreadsheets and Formulas 101
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.
Calculating the Mean, Median, Mode, and Range Using Spreadsheet Software
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.
Analyzing Discrete and Continuous Data in a Spreadsheet
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.
Collecting, Organizing, and Analyzing Data
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.
Leonardo da Vinci and the Search for the Perfect Body (Proportions)
Students create a spreadsheet to analyze their data. In this algebra lesson, students input their data into an Excel program and create formulas to analyze and summarise the data. They create ratios using the data in the cells.
Comparison of Data Using 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.
Middle schoolers 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.
Introduction To Spreadsheets
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.
Introduction to Spreadsheets
Students practice using both text and numerical valued columns in a spreadsheet. They design a birthday or holiday wish list with the spreadsheet program after looking through catalogues and newspaper advertisements. They complete the spreadsheet and use autosum.
Using A Volunteer Acquired Database Constructed On The Internet, Examine the Relationship between Dissolved Oxygen and Water Temperature
Ninth graders access a database and open a spreadsheet. In this oxygen and water temperature lesson students save the database, sort it and generate scatter plot graphs.
M & Ms in a Bag
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data between groups.