Lesson 3: Forensic Sheets

In this lesson, we’re going to act like detectives and use our spreadsheet skills to try and solve a most serious crime…  (a completely fictitious one, but play along for fun).

Forensic Accounting

Scenario

You’ve been called in by the Glenview Police to offer your expertise in organizing, editing, and analyzing data in Google Sheets. A crime of a most serious nature has been committed in Glenbrook South’s Graphics Lab. The only evidence that the crime scene detectives were able to recover were a series of Google Sheets and a broken wall clock that is believed to be the suspects weapon.

The victim’s name is Hector Macfadden – Mr. Michael Macfadden’s identical twin brother and husband to Isabella Macfadden.

Your job is to organize, edit, and analyze the data in the Google Sheets to try to determine what took place.

Groups

 

Anna

Enrique

Raol

Ralf

JC

Celina

Florian

Bilguun

Oka

Ashir

Ailar

Suld

The Evidence

Visit each of the links below at the corresponding station with your group members, make a copy of the data for your group start sleuthing.

  1. Phone Records: goo.gl/RnDLds
  2. Contact List: goo.gl/goX3NE
  3. Hector and Isabella’s Checking Account: goo.gl/wHUqE5
  4. Michael’s Checking Account: goo.gl/rwfqKZ