Monopoly spreadsheet unit

Image

Students will Play Monopoly using Checks.

Students will keep track of their balance using a check ledger.

Students will write checks for expenses.

Students will use Standard Monopoly rules to play.

Students are required to make purchase 2 properties during the 6 days of game time.

If a student warns another player that someone owes him/her rent the student who did the warning has to pay.

Students will make a spreadsheet to balance their check ledger.

Students will make an assets sheet to total their assets.

Students will write a formula balancing their check ledger and adding in their assets.

Checks have to be purchased from the banker. .50 cents for 9 checks. No more than 9 checks can be purchased at one time.

Bankers own all properties. Any properties not sold the banker has to claim on his/her asset sheet. Bankers sell properties when a player lands on it. Properties may be auctioned if a player does not want it. Auction prices start at the mortgage price on the back of the card.

Bankers keep track of the money in the “free parking” When a player lands on free parking they win the lottery and get the money in free parking. Players put fines, taxes and fees in free parking.


When you complete this lesson, you will be able to:

  1. Start and exit from Microsoft Excel.
  2. Identify parts of the Excel screen.
  3. Work with dialog boxes, menus, and toolbars.
  4. Customize Excel.
  5. Use help.
  6. Understand how to save over a network.
  7. Work with Multiple workbooks.

Introduction

Excel is a spreadsheet program ( application). That you can use with Windows operating systems.

A spreadsheet is a grid in which you can enter, calculate, and manage data. In the past, spreadsheets were created by entering data by hand on a ledger paper. When calculators came along, the calculation of data was made easier but it was still entered by hand.

Today, however, advanced spreadsheet programs like Excel make it easy to manage numeric information, to create charts, and to maintain lists of data.

Below is an example spreadsheet designed to duplicate a traditional check ledger. Our first lesson will be to take the money you earned in the Monopoly game and create this spreadsheet.

 

date check # Checks and deposits amnt checks deposits balance
    balance forwarded     $1,500.00
1/22/10 2 kma bank $0.50    
  2 deposit   $362.00  
  1 jobob $200.00    
  3 clint e $180.00    
  4 annie oakley $10.00    
  5 bank $250.00    
  7 deposit   $200.00  
Advertisements

About merlehall

I am a technology teacher for Macon Middle School. In Northeast Missouri. I have been using an online classroom with Moodle for the past several years. My students use a hybrid online, brick and mortar class. My classes are designed to support the core classes in that: In 8th grade we study the Constitution of the United States using smartboards, podcast, vidcast, internet research and word. In 7th we study economics using HTML, game creation, ebook writing, podcast, game playing, excel spreadsheets, and database design. In 6th grade we study geography and math using Monopoly with checks, spreadsheets, and work on keyboarding, speed typing, touch typing and dictation. In addition to education I am an avid fisherman, hunter, hot air balloon lover, front porch setter, square dancer, so you will also be seeing information on these subjects as well from time to time.
This entry was posted in education and tagged . Bookmark the permalink.

One Response to Monopoly spreadsheet unit

  1. Website says:

    I have learn several excellent stuff here. Certainly worth bookmarking for revisiting.
    I surprise how much effort you set to create such a fantastic informative web site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s