Students can use the columns and rows of the spreadsheet to create tables for collecting and summing data. Use text to label the columns and rows, and then insert numerical data into the appropriate squares, called cells. A project that utilizes the sum function is to create a shopping list in the spreadsheet. Have one column for the name of the item to be purchased and another column for the price of the item. Use the final row to sum the prices for a total cost.
As with the summing project, students should begin by labeling columns and rows to create a table. Numerical values must be entered into the appropriate cells. Utilize the average function to compute the average of data that is meaningful to the student. An example of a project that uses this function is averaging the touchdowns scored per game for each school in the district. Label the columns of your table with the names of each school, and list the game dates as row labels. Enter touchdowns scored for each school on each game date. Use the final row to compute the averages.
Data entered into a spreadsheet can be converted into a chart by using a chart wizard. Use columns and rows to create a table containing the data you wish to chart. Select the kind of chart you wish to create, such as a bar, line or pie chart. Examples of projects using the chart feature are creating a bar chart to show how time is spent after school each day, a line graph that shows test scores over time, or a pie chart featuring the class's favorite television shows.
Data collected for a spreadsheet project should be analyzed. A written paragraph or report to interpret the data should convey the student's understanding of the data and conclusions drawn from the data. Analysis of an averaging project can include identifying the highest and lowest averages, while analysis of a bar chart can identify high and low points on the chart. Further analysis and research can be completed to reveal possible causes for high and low data points. By analyzing and drawing conclusions, students will begin to see the value of using spreadsheets to collect and display data.