Stock Portfolio in Microsoft Excel

$5.00

Learning about the Stock Market using Microsoft Excel lets middle schoolers see how an investment can grow and change, as well as the importance of thorough research. Utilizing Microsoft Excel, students “purchase” and track several stocks over a 6 week period. They have the opportunity to sell stocks or hold them, depending on the market research they do. Using a template they create in Microsoft Excel, they will track the increases and declines in their stock investments and see how much they can make their initial investment grow during the 6 weeks. This lesson is intended for beginning Excel users and was created using Microsoft Excel 2013. It is easily adaptable for different versions.

Files Included with this Unit

* Unit Overview & Pacing Guide
* Teacher & Student Resources
* 4 lessons incorporating reading, research, and creation of a Microsoft Excel spreadsheet to track stock purchases, gains and losses for a 6 week period (lessons include rubrics)
* Excel Templates and Samples (including all formulas)
* Tutorial for Students

Total Pages:  18
Teaching Duration:  1 week

Description

Learning about the Stock Market using Microsoft Excel lets middle schoolers see how an investment can grow and change, as well as the importance of thorough research. Utilizing Microsoft Excel, students “purchase” and track several stocks over a 6 week period. They have the opportunity to sell stocks or hold them, depending on the market research they do. Using a template they create in Microsoft Excel, they will track the increases and declines in their stock investments and see how much they can make their initial investment grow during the 6 weeks. This lesson is intended for beginning Excel users and was created using Microsoft Excel 2013. It is easily adaptable for different versions.

Files Included with this Unit

* Unit Overview & Pacing Guide
* Teacher & Student Resources
* 4 lessons incorporating reading, research, and creation of a Microsoft Excel spreadsheet to track stock purchases, gains and losses for a 6 week period (lessons include rubrics)
* Excel Templates and Samples (including all formulas)
* Tutorial for Students

Total Pages:  18
Teaching Duration:  1 week

See a preview of this product

Related Products
Excelling with Excel – Beginner Activities

**************************************************************************
Connect with us for free technology tips, resources and curriculum:
Follow our blog
Follow us on Facebook