LESSON TITLE: Team Statistics Spreadsheet
CURRICULUM AREA: Math / Technology
GRADE LEVEL: 6th, 7th, & 8th
What is your ACC team’s average for Free Throws Made, Minutes Played, Field Goals Made, Assists, and 3 point Field Goals?
Use a computer excel program to prepare a spreadsheet for each ACC team.
Without talking, students must communicate to their classmates their birthdays. They are to line up from January to December in the order of their birthdays from January 1 through December 31.
Use 12 teams with each team representing one of the ACC schools. Have the teams create a spreadsheet of the players on their team in the EQ categories. Students will title their spreadsheet with the name of their school. They may center the title by using the right click and format cells. Each team will have columns for Free Throws Made, Minutes Played, Field Goals Made, Assists, and 3 point Field Goals. Students may use the format, column width, auto format for their columns. You will obtain the statistics by using ACC.com. After students have filled all the columns, use insert function to average each column. Teams will print out their school’s statistics and later present them to the class. The class will decide which team should be more successful based on the statistics.
Higher order questions about how to create a spreadsheet.
RESOURCES: Newspapers, ACC.com.
RE-TEACHING AND ENRICHMENT ACTIVITIES:
After tournament, add tournament data
Compare teams’ data
Create graphs for each category