Collaborative spreadsheets (w/ Google Drive)

This is a group assignment using spreadsheets in Google Drive. Make sure to use the "copy" hint from class so the professor can edit the spreadsheets without changing the originals.

GPA Calculator

Create a spreadsheet that computes a weighted average for a grade point average.

The spreadsheet should:

Collatz conjecture

Create a spreadsheet that explores the Collatz conjecture.

Take any natural number, \( n \). If \( n \) is even, compute \( \frac{n}{2} \). If \(n\) is odd, compute \(3n+1\). Repeat the previous process until \(n=1\). The conjecture states that all natural numbers will eventually go to 1.

The spreadsheet should:

Linear system

Create a spreadsheet that helps students find the solution to a system of two linear equations.

The spreadsheet should:

Challenge +1 MTP

Also show the graph of the intersection, possibly using a scatter plot with treadlines.

Can't Stop (Monte Carlo simulation)

Create a spreadsheet to estimate probabilities for the game Can't Stop.

The spreadsheet should:

Game rules:

  1. Choose three numbers (2-12).
  2. Roll four six-sided dice.
  3. Separate the dice into two pairs. There will be various ways to do this.
  4. Find the sum of each pair. Is your number among one of the sums?

For example: Say a person chooses 2, 6, and 7 as a target values. Now the student rolls a 3, 3, 4, 4. Depending on how I pair up the dice, I get the following sums: 6, 7, 7, 7, 7, 8, with a total of 5 matches. That said, you should only count this result as 1 towards the probability count, not 5, because each die roll can contribute at most one to the count.

Challenge +1 MTP

Also compute the theoretical probability.

Farkle (Monte Carlo simulation)

Create a spreadsheet to estimate probabilities for the game Farkle.

Note: We will assume that six dice are rolled only once representing the first roll of a player's turn.

The spreadsheet should:

Challenge +1 MTP

Also include scoring and expected value for the "adding" scoring variation for 4-of-a-kind, 5-of-a-kind, and 6-of-a-kind.

Example: Let's say the roll was 3-3-3-3-5-6. Three 3's are worth 300 points. The fourth 3 adds on that value, so 3-3-3-3 is worth 300+300 = 600 points!. Don't forget the 5 is worth 50. So this situation is worth 650 points. The effect is cumulative so a roll of 3-3-3-3-3-6 would score 300+300+300 = 900 points.

Discussion questions

N/A

Submission

Submit the URL for your assignment to the correct Canvas discussion board. Recall that the discussion board is used as a way to share ideas between (preservice) teachers.

Please print relevant pages if you want more detailed feedback.

Special note: To get a link for your spreadsheet, please use the following directions to share in copy mode


Collaborative spreadsheets scoring guide 20 MTP

GPA calculator

Requirements

Directions for students are _____ clear.


Collatz conjecture

Requirements

Directions for students are _____ clear.


Linear system

Requirements

Directions for students _____ clear.


Can't Stop probabilities

Requirements

Directions for students are _____ clear.

Explanation for probability computation is _____ clear.


Farkle

Requirements

Directions are _____ clear.


Challenges

Aesthetic bonus

Points: 0