Columns and Rows Teacher Resources
Find Columns and Rows educational ideas and activities
Showing 1 - 20 of 310 resources
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 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.
Pupils set up a spreadsheet with columns/row labeled "Estimate" and "Actual". Then they record their guesses in the "Estimate" column, count the actual number of that particular color M & M, and record the number in the
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.
Young scholars 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.
Middle schoolers 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 plan.
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.
Learners 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.
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.
Pupils graph and analyze data using a spreadsheet.
Students 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.
Students create a spreadsheet to track their spending. For this algebra lesson, 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.
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.