This will require that the students start with the column of numbers, drag down the entire column and then drag over the column of names. All of the numbers and names should be highlighted. Find the Basic Statistics Teach the students how to use the functions by typing in the function name. Students can look at the top and bottom numbers in the sorted column of data to find the range . Create a Chart You can use your frequency table from grades.doc as a basis for creating a bar chart.
Students can scroll to a different part of grades.xls or create a new spreadsheet.
Enter the numbers along the bottom of the frequency table in one column and the number of students who had that score in the column next to it. Have the student use the chart option to create a bar chart of the data. You can compare the chart on the spreadsheet to the one on paper to see how similar they are. If time permits, students can change from a bar chart to a line chart or create 3-D charts. This last exercise allows students to use all of the basic statistics as well as create line charts that ask them to identify trends in the data.