Senior

TechnoInvestor

Play a stock market game. Form collaborative teams to trade stocks in fictitious companies. Write a report.

(5 Reviews)

$49.00 / year

Choose License Type: Contact us for district and school pricing.

Price information is unavailable.

To learn more about TechnoKids Computer Curriculum please contact us.

contact us

Description

Stock Market Game for Teens

Develop financial literacy by playing a stock market game. In TechnoInvestor, students learn spreadsheet skills by assuming the role of a stockbroker working at an investment firm. There they buy and sell stocks to earn money for their client. They learn how the stock market functions by purchasing shares in fictitious companies listed on the TechnoStock Exchange (TSE). Students keep track of their investment portfolio using Microsoft Excel. The spreadsheet program allows them to organize their purchases and calculate their current value. Students then manipulate this information to create graphs that summarize stock values, display trendlines, and report earnings. Upon completion of this project, students produce an investor’s report in Microsoft Word that contains detailed information about the financial status of the client.

Make Investing Fun for Teens

The TechnoInvestor course has everything teachers need for a stock market simulation. You receive downloadable resources including currency, stock certificates, fictional company profiles, and a serial set of newsletters to assist in trading decisions. You do not need to be a financial expert to teach investing. The Teacher Guide includes detailed lesson plans as well as step-by-step assignments. In addition, the course provides customizable assessment tools, samples, and checklists. These are time-saving materials for busy teachers.

Innovative Stock Market Simulation

Teach advanced spreadsheet skills as students play the role of stockbrokers. They form investment teams to buy and sell fictitious stocks. Excel is used to track the portfolio, make decisions, add conditional formatting, graph earnings, and prepare an investor report.

Boost Collaboration

In their investment groups, students participate in a series of four trading sessions. They begin by reading company profiles and a newsletter which gives up-to-date information on the market events impacting the companies on the exchange. Students make group decisions on which stocks to buy and sell. Then they individually record the trades in Excel. Being a team player is a valuable life skill, which is vital in the workplace.

Build Spreadsheet Skills

As they organize their portfolio, students learn to graph and analyze data, make calculations using formulas, apply styles, format content, set page breaks and print area, and add a trendline to forecast.

Foster Financial Literacy

Not only does TechnoInvestor teach essential spreadsheet skills but the assignments develop analytical reasoning. Build decision making in your students. The activities have them examine financial data and evaluate current events to make informed decisions. This real-world problem solving task makes investing relevant to kids.

 

Additional information

Ages

11, 12, 13, 14, 15, 16, 17, 18

Grades

grade 6, grade 7, grade 8, grade 9, grade 10, grade 11, grade 12

Program

Excel, Word

Tech Integration

business studies, language arts, math

Tech Skill

spreadsheet, word processing

License

Starter, Class, Classrooms

Starter License Includes

online teacher guide, online student workbook, get started, printable assessment tools, sample files, extension activities, certificates, parent letters

Class License Includes

online teacher guide, getting started tips, course calendar, online student workbook, online assignments, printable assessment tools, online quizzes, student reporting, sample files, extension activities, certificates, parent letters

Classroom License Includes

online teacher guide, getting started tips, course calendar, class management tools, online student workbook, online assignments, printable assessment tools, online quizzes, student reporting, sample files, extension activities, certificates, parent letters

Product Type

Course

The TechnoInvestor course has 21 assignments divided into six sessions.

Stock Market Game

Will stocks rise or fall? Data breaches, product recalls, new services, management changes, and industry awards influence stock prices. Where should you invest your TechnoDollars?
  • TechnoAir Airlines: manages fifth largest airline in the nation
  • TechnoMotor Company: manufactures a wide-range of vehicles
  • Pizza King: operates fast food chain with more than 2500 restaurants
  • Green Power: develops renewable energy products
  • Kids Bank: provides banking, insurance, and wealth services
  • Ruby Games: designs online action-adventure games
  • Pets R Family: sells pet supplies, healthcare plans, and vet services
 

Session 1: The TechnoStock Exchange

Students learn about the stock market and make an initial investment by purchasing shares in various companies listed on the TechnoStock Exchange (TSE). This information is recorded in a table created using Microsoft Excel and saved to a student folder.

Session 2: Calculate Value of Stock Holdings

Students read the first issue of Money and Markets; a newspaper that reports on business. Applying this information, they buy and sell shares. Once their financial transaction is complete, they enter the data into the Microsoft Excel table and manipulate the data using mathematical formulas.

Session 3: Are You Making or Losing Money?

Students read the second issue of Money and Markets and, based on the news, trade shares on the TSE. Afterwards they enter the trading information into the Microsoft Excel table. The information is further manipulated using conditional formatting so that earnings over the initial investment amount of 400 Technodollars are highlighted.

Session 4: The Rise and Fall of Stock Values

Students continue to invest in stocks listed on the TSE. Students begin by returning to their investment groups and reading the third issue of Money and Markets. After discussing the current events and how they have affected the stock values, students determine how they will proceed with their trade. They log their decisions in the Investment Record Trade 4 assignment before applying their knowledge of Microsoft Excel to prepare a new table to enter the information electronically. Students then graph the rise and fall of one stock and forecast its future value using a trendline.

Session 5: History of Earnings

Students make their final stock trade. They create a graph to summarize their earning history. They begin by joining their investment groups and reading the fourth issue of Money and Markets. Groups then discuss the current events that have occurred and the impact they have had on the companies listed on the TSE. Students decide on their final trade of this simulation and record their trades in the Investment Record Trade 5 assignment. Students ready their investment portfolio to include their latest transactions. They then create a graph that summarizes the earning history of their investment portfolio.

Session 6: Investor Report

Students write a report to summarize the value of their investment portfolio. This report includes an explanation of earnings, current stock holdings, and recommendations for further financial growth.

Optional Stock Market Game Activities

  • Stock Market on the Internet: Track actual companies.
  • Cash at a Glance: Apply conditional formatting.
  • Data Bars and Icon Sets: Advanced formatting tricks.
  • Graph a Stock with a Trendline: Determine the future trends.
  • Bearish or Bullish? Learn about stock market terms.
  • Gross Profit Margin: Use a formula to calculate profit.

Integrate Technology into a Mathematics Investment Unit using Excel

Integrate computers into a mathematics problem solving, financial literacy, entrepreneurship, or business studies unit. Students participate in a stock market game, buying and selling stocks. Stock market lesson plans boost student interest with a real world simulation.
  • Relate mathematics to real-world situations
  • Apply problem-solving strategies
  • Develop financial literacy
  • Collaborate in a team to make investment decisions
  • Organize investment data in a worksheet
  • Graph data and analyze the information
  • Add a trend line that forecasts future stock value
  • Format content in a spreadsheet
  • Calculate investment portfolio value using formulas
  • Summarize stock market investments in a report

TechnoInvestor | Stock Market Game

Download

Play a stock market game. Form collaborative teams to trade stocks in fictitious companies. Write a report.

5 reviews for TechnoInvestor

  1. technokids.com

    This is one of my students’ favorite units. They love trading stocks and seeing their value increase or decrease. I love that students are learning about spreadsheets and interpreting information while having fun.
    Ambridge Area Junior High,Freedom
    December 22,2024
  2. technokids.com

    TechnoInvestor is very helpful as it directly connects to the real trading sector in the world. I am a student and many of us – if not all – feel intrigued in grade 7 to learn and invest in the stock market.
    Unionville Montessori Private School,Markham
    November 05,2015
  3. technokids.com

    The TechnoKids curriculum is fun for my students and a time saver for me. TechnoInvestor is one of their favorites and the recent update will make it even more exciting. Thanks for keeping up-to-date.
    Neuse Charter School,Smithfield
    April 14,2015
  4. technokids.com

    TechnoInvestor is going great. One of my Investor students placed first at District FBLA Leadership Conference in Spreadsheet Applications.
    Atlanta High School,Atlanta
    March 03,2015
  5. technokids.com

    Projects are easy to follow, self-paced, and incorporate various techniques of the MS Office Suite. The projects allow students to enhance their language arts skills and math techniques. Middle school students can learn about the ups and downs of the stock market by using MS Excel and TechnoInvestor. I have evaluated many different types of software and am very impressed with the TechnoKids Curriculum.
    St. Theresa School,Ashburn
    August 25,2010
Add a review

Your email address will not be published. Required fields are marked *

Our Ed Tech Blog for Teachers

View All

FAQ

Have questions? We’re here to help.

View All FAQ

How long does it take to teach a course?

Every course includes a schedule. It lists the time recommended for each assignment. Typically, it takes between 30-60 minutes to complete an assignment depending on the grade level. Based on this time frame, a typical course takes between 360-600 minutes to complete. This is about 6-8 weeks if your students have computer class twice a week. However, if your students have computer class every day, a course can be completed in about 2-3 weeks.

How do I decide which assignments to teach?

You may not have the time to teach an entire TechnoKids course. The good news is that TechnoKids offers flexibility. Many courses can be shortened by omitting assignments or lengthened by including skill reviews and extension activities. You can easily adapt the course to suit your schedule. Refer to the Ideas for Implementation section in the teacher guide for suggestions.

Does the course integrate into other subjects?

TechnoKids courses are inter-disciplinary. This means the lesson plans blend computing skills with general content areas such as language arts, geography, or business studies. If you do not have a dedicated digital literacy class, refer to the Technology Integration Suggestions section in each teacher guide for ideas on how you can include the course in other subject areas.

Is the course a subscription?

Yes. When you purchase a course, you have access to the instructional materials for 12 months. After that time, should you want to continue, you will need to renew the subscription.

Is the course online?

Yes. You must sign into TechnoHub to access the course content from your bookshelf. The teacher guide and student workbook for a course are available online only. However, resources such as assessment tools, handouts, course slides, templates, and samples are downloadable.