Chocolate Chip Cookie Mining Simulation

Cookie Mining – with an example of cookies used for the activity.


This is one of my favorite activities from our minerals and mining unit. It takes about 1 whole class period to explain the activity, collect data, eat the cookie (& crumbs), and clean up. We discuss our results the next class and determine who made the most profit.

When determining the value of the chocolate ore, I have the students place their chocolate pieces close together in one area of the map. When they are done, I go around and circle the area of chocolate and give their chocolate a rating. They count the number of boxes their chocolate covers and enter it into their spreadsheet.

If there are crumbs attached to the chocolate, I call that ‘slag’ and it lowers the value of the chocolate ore. This leads to a great discussion afterwards when we compare the profits and talk about land use. Is it better to get out as much chocolate as you can, even if you get a lot of slag, or is it better to remove just the chocolate even though you will have less in the end? How is this similar to coal mining? Diamond mining?

Students try different techniques to extract the chocolate.
Cookie blasting – extracting as much chocolate as you can in 5 minutes.



Graphing Sunrise, Sunset, and Moonrise Data

image (10)

In this activity, students collected data from different cities around the world and entered the sunrise, sunset, and moonrise times into an excel spreadsheet. I have the spreadsheet set up to automatically graph the data as it is entered into excel for 7 consecutive weeks. (I printed out and photocopied the 4th tab of the spreadsheet to make it easier for the students to collect their data and then enter into the spreadsheet)

image (11)

For my classes, I gave everyone the information for the New Jersey data (it is in the spreadsheet as an example, but you can easily delete it and modify as needed). This gave everyone a foundation to make their comparisons. Each student was randomly assigned their first city, and when done, were able to choose any city from the list for their 3rd choice.

Files needed for the lesson: