7th Grade Economics Excel Spreadsheets

Stock Portfolio in Microsoft Excel | Distance Learning

By Innovations in Technology

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.

This lesson is great for distance learning/remote learning. You can upload it to your school's learning management system (Google Classroom, Edmodo, Canvas, etc.) or share with students via Google Drive.

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

Related Products
⭐ Excelling with Excel - Beginner Activities
⭐ Excelling with Excel - Intermediate Tutorial & Activities

Remember to leave feedback for credits on future purchases!

**************************************************************************

Connect with us for free technology tips, resources and curriculum:

Follow our blog

Follow us on Facebook

$5.00