Real Data - Tech Learning

Real Data

Tip: Spreadsheets are abstract concepts to many teachers and students. The best way to make it easily understood is by using real data: Provide each participant a bag of different color candies such as M&Ms or Skittles. Walk them through setting up a worksheet calculating the totals and averages of each color in the
Author:
Publish date:

Tip:
Spreadsheets are abstract concepts to many teachers and students. The best way to make it easily understood is by using real data:

  • Provide each participant a bag of different color candies such as M&Ms or Skittles.
  • Walk them through setting up a worksheet calculating the totals and averages of each color in the bags.

Or for those a little more adventurous, set up a profit and loss statement for a made up small business:

  • Use a pet store as your imaginary business.
  • Create categories for pets with fur, pets that swim, etc.
  • Create subcategories for expenses such as food, cages, marketing, etc. and for income estimating selling price per animal.

Have participants pair and share their worksheets and in the first example, their data.

Submitted by:Barbara Bray

Next Tip: New Views for Excel

Featured

Related

Writing for a Real Audience

I know that teachers can use computers and scanners to score tests and print reports, but there must be additional ways to assess student work using the technology available to us. What other ways are teachers using technology to assess student work? Here's one creative strategy some middle and high school

FlyteComm - Real Time Flight Tracking

Name: FlyteComm - Real Time Flight Tracking Brief Description of the Site: Meeting someone at the airport, or planning to take a flight out for the holidays? Calls to the airline (usually recorded) state that the flight is on time, but it is? Waiting for Uncle Joe and Aunt Mary to arrive and need to allow

Data: Mining with a Mission

For some districts, the current obsession with data grows out of the need to comply with No Child Left Behind and additional accountability-related mandates. For others, it dates way back before the phrase "data-driven decision making" rolled so frequently off the tongues of educators. In either case, there is no

Making the Most of Real-Time Data

from Dr. Steven Guttentag Chief Education Officer at Connections Academy With schools spread across the country and instruction happening around the clock at literally thousands of kitchen tables every day of the year, it is not easy to stay on top of student performance and progress. Having access to analytical