Quickie Stock Market Simulation

Quickie Stock Market Simulation
Quickie Stock Market Simulation
Quickie Stock Market Simulation
Quickie Stock Market Simulation
Grade Levels
Product Rating
8 Ratings
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

34 MB|8 pages
Product Description
This assignment is designed to take only one day, and is for a short introduction to the stock market for grades 5-8.

This is a VERY fun an interactive lesson! My 7th students absolutely loved it and wanted to keep trying it again and again. It was fun to watch them light up as they started to get a small idea of what investing in the stock market really means!

Students open up an Excel file--which uses macros, so be sure to enable them. This also means that it will NOT WORK on Google Sheets--because Google Sheets is too basic for something this advanced.

At the push of a button, 5 random stocks are chosen from a hidden list of 100. The students decide how much to invest in each stock, then go to the following year and see if their stocks went up or down. Then they may buy and sell. The information includes actual stock prices from 2011 to 2015, so there is a great element of reality to the assignment. Finally, students will look up their stocks and their current prices online to see what their portfolio is worth today. A final score is given on how much they increased their assets in the five-year period.

The file also includes a finished example, and a step by step video for the teacher to explain exactly how it works. SUCH a fun lesson!

*** UPDATE***

I have updated the file to include several improvements:
2017 is now included. Students will track 2012 - 2017 to today's date.
Several companies were replaced because they have been bought out, have too expensive stock, or are hard to find doing a google search.
Students who make over $1200 will get a "check" on their paper, indicating to the teacher to check their page and make sure there is no errors or cheating--it's just really hard to make that much!
Columns have been widened, so if you want to invest more than $500 to start, the columns will accommodate larger numbers. If you invest more than $500, ignore the "check" option and count it as a "complete."
Print area has been set so students who print the "today" page will only print a blank page

The instruction videos and example have NOT been updated, but the assignment is still the same so it shouldn't really matter. Re-download if you have already purchased for the updated version!

Related Products
I have a full series for Stock Market that includes four lessons:
Stock Market Unit Lesson 1 - The Pie Game
Stock Market Unit Lesson 2 - Simple Stock Simulation
Stock Market Unit Lesson 3 - Stock Market Vocabulary
Stock Market Unit Lesson 4 - Investopedia Simulation

How to get TPT credit to use on future purchases:
Please go to your My Purchases page (you may need to login). Beside each purchase you'll see a Provide Feedback button. Simply click it and you will be taken to a page where you can give a quick rating and leave a short comment for the product. Each time you give feedback, TPT gives you feedback credits that you use to lower the cost of your future purchases. Your feedback is much appreciated, and helps me provide more work that you are looking for. I am always quick to respond to questions as well.

Be the first to know about my new discounts, freebies and product launches:

Look for the green star next to my store logo and click it to become a follower. Voila! You will now receive email updates about this store.
Total Pages
8 pages
Answer Key
Does not apply
Teaching Duration
45 minutes
Report this Resource
Digital Download
More products from Mrs Funny Business
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up