Important Spreadsheet Features

There are many important features of a spreadsheet. Also, certain features can be used together for a more advanced spreadsheet. For example, you can use the formatting, cell name, and editing features while using the graphing or template feature. However, I have selected the graphing and template features as my two important spreadsheet features. These features can be utilized for the sixth through eighth grades.

Templates

English
Students can record the total number of points received on grammar quizzes for the semester. Also, they can compute their average based on points received.

Math
Students can record how fast an automobile can travel and the relationship among distance and time. Also, students can create a spreadsheet to keep track of monthly expenses for the Math Club.

Reading
Students can keep track of AR points for the school year by month and compare the number of books read per month.

Science
Students can record how fast a train can travel and the relationship among distance and time.

Social Studies
Students can keep track of classroom elections while learning about the election process. They can use a spreadsheet to add and figure percentages regarding the election. Also, the students can record, per each candidate, the number of votes per homeroom, the number of votes received, and the percentage of total votes.


Graphing

English
Students can create a bar graph to compare the average grammar grade between homerooms, girls, and boys.

Math
Students can create a table to compare test grades for the semester. For example they can record scores for Test 1, Test 2, and Test 3. This would also utilize the formatting and cell names features of spreadsheets.

Reading
Students can convert the template created to record AR points for the school year into a pie chart. This will provide a more detailed visual for the percentages of AR points by including a color-coded chart.

Science
Students can graph the rate of speed of a car, plane, and train. They can use a line graph to compare the rates of speed.

Social Studies
Students can compare the length of time between different wars. For example, the Civil War, World War I, World War II, and the Vietnam War. A bar graph could be used to compare the number of years for each war.