X hits on this document

339 views

0 shares

0 downloads

0 comments

82 / 116

LESSON TITLE: Team Statistics Spreadsheet

CURRICULUM AREA: Technology

GRADE LEVEL: 6th, 7th, & 8th

ESSENTIAL QUESTION:

What is your ACC team’s average for Free Throws Made, Minutes Played, Field Goals Made, Assists, and 3 point Field Goals?

ACTIVITY SUMMARY:

Use a computer excel program to prepare a spreadsheet for each ACC team.

ACTIVATING STRATEGIES:

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.

METHOD:

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.

SUMMARY STRATEGIES:

Higher order questions about how to create a spreadsheet.

RESOURCES: Newspapers, ACC.com.

RE-TEACHING AND ENRICHMENT ACTIVITIES:

  • 1.

    After tournament, add tournament data

  • 2.

    Compare teams’ data

  • 3.

    Create graphs for each category

82

Document info
Document views339
Page views339
Page last viewedSun Dec 11 08:22:02 UTC 2016
Pages116
Paragraphs2617
Words16985

Comments