TPT
Total:
$0.00

Stock Market Game - Stock Market Class Challenge Google Sheets Microsoft Excel

Rated 5 out of 5, based on 1 reviews
5.0 (1 rating)
;
Proven Computer Lessons
1.5k Followers
Grade Levels
8th - 12th
Standards
Formats Included
  • Zip
  • Google Apps™
  • Excel Spreadsheets
Pages
58 pages
$15.00
$15.00
Share this resource
Report this resource to TPT
Proven Computer Lessons
1.5k Followers
Includes Google Apps™
The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).

Description

Perfect for any class to teach students about the Stock Market. There are so many stock market activities out there. I have used this Stock Market Class Challenge to teach 8th graders about the stock market for over 10 years. It is straight forward and easy to follow for students since students are only allowed to invest $1,000. Students can relate much more to $1,000 rather than tens or hundreds of thousands some stock market games use. Students are not allowed to sell their stocks until the end of the activity so they really see the ups and downs of their particular stocks they choose. Students become so involved, you would think they really did invest their own money.

Students will research potential stocks, make a “pretend purchase” and track their stocks for 1 semester (or however long you use chose) either bi-weekly or weekly until “selling” their stocks at the end of the challenge. Students will use Google Sheets or Microsoft Excel and the Internet to complete the activities. Students should be somewhat familiar with how to use Google Sheets or Microsoft Excel. Step-by-step directions are included for each activity.

Stock Market Class Challenge includes 9 Stock Market activities with PowerPoint presentations to introduce most activities, teacher directions, editable Stock Market Progress Sheet, and editable Stock spreadsheets for demonstrations and answers. Each activity is approximately 40 minutes with the exception of the weekly or bi-weekly Stock Market Progress.

Stock Market Game Class Challenges Activities:

  • Activity 1 Stock Market Basics – Presentation to Introduce the Stock Market
  • Activity 2 Stock Market – Research – Students research potential stocks to invest their $1,000
  • Activity 3 Stock Market – Buying Stocks – Presentation to show students how to create a spreadsheet of their stock purchase.
  • Activity 4 Stock Market Progress Spreadsheet – Presentation to show students how to track their earnings or losses.
  • Activity 5 Stock Progress Updates – Presentation and Editable Stock Market handout.
  • Activity 6 MLA Report – Students report on their stock progress, why they chose they stocks, etc.
  • Activity 7 Selling Stocks – Presentation and students sell their stocks at the end of the challenge and determine who would have “profited” the most if their investments were real.
  • Activity 8 Stock Market Terms Crossword Puzzle – Students will use the Internet to complete the Stock Market Terms Crossword Puzzle.
  • Activity 9 Stock Market Ups & Downs – Students research the reasons why the stock market has ups and downs.
Total Pages
58 pages
Answer Key
N/A
Teaching Duration
1 Semester
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Standards

to see state-specific standards (only available in the US).
Make sense of problems and persevere in solving them. Mathematically proficient students start by explaining to themselves the meaning of a problem and looking for entry points to its solution. They analyze givens, constraints, relationships, and goals. They make conjectures about the form and meaning of the solution and plan a solution pathway rather than simply jumping into a solution attempt. They consider analogous problems, and try special cases and simpler forms of the original problem in order to gain insight into its solution. They monitor and evaluate their progress and change course if necessary. Older students might, depending on the context of the problem, transform algebraic expressions or change the viewing window on their graphing calculator to get the information they need. Mathematically proficient students can explain correspondences between equations, verbal descriptions, tables, and graphs or draw diagrams of important features and relationships, graph data, and search for regularity or trends. Younger students might rely on using concrete objects or pictures to help conceptualize and solve a problem. Mathematically proficient students check their answers to problems using a different method, and they continually ask themselves, "Does this make sense?" They can understand the approaches of others to solving complex problems and identify correspondences between different approaches.
Use appropriate tools strategically. Mathematically proficient students consider the available tools when solving a mathematical problem. These tools might include pencil and paper, concrete models, a ruler, a protractor, a calculator, a spreadsheet, a computer algebra system, a statistical package, or dynamic geometry software. Proficient students are sufficiently familiar with tools appropriate for their grade or course to make sound decisions about when each of these tools might be helpful, recognizing both the insight to be gained and their limitations. For example, mathematically proficient high school students analyze graphs of functions and solutions generated using a graphing calculator. They detect possible errors by strategically using estimation and other mathematical knowledge. When making mathematical models, they know that technology can enable them to visualize the results of varying assumptions, explore consequences, and compare predictions with data. Mathematically proficient students at various grade levels are able to identify relevant external mathematical resources, such as digital content located on a website, and use them to pose or solve problems. They are able to use technological tools to explore and deepen their understanding of concepts.

Reviews

Questions & Answers