Home  |    Add Bookmark   |   Print Friendly   |   Rate This Lesson Plan   |   Suggest a Variation

## Lesson Plan

You may save this lesson plan to your hard drive as an html file by selecting "File", then "Save As" from your browser's pull down menu. The file name extension must be .html.

This lesson provided by:
 Author: Melody Bailey System: Shelby County School: Shelby County Board Of Education

General Lesson Information
 Lesson Plan ID: 10765 Title: Trading and Tracking Stock Portfolios Online Overview/Annotation: Student teams will trade stocks and track the progress of their Alabama Stock Market Simulation portfolio by using spreadsheet software and the Internet. They will relate the information to a previous social studies unit on economics and will be utilizing math concepts they have learned. The Internet will be used to research stock trends.

Associated Standards and Objectives
Content Standard(s):
 TC2 (6-8) 5. Use basic features of word processing, spreadsheets, databases, and presentation software. Examples: word processing—reports, letters, brochures spreadsheets—discovering patterns, tracking spending, creating budgets databases—contact list of addresses and telephone numbers presentation software—slideshow TC2 (6-8) 11. Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize information. Examples: locating—Boolean searches, graphic organizers, spreadsheets, databases collecting—probeware, graphing calculators organizing—graphic organizers, spreadsheets evaluating—reviewing publication dates, determining credibility synthesizing—word processing software, concept-mapping software TC2 (6-8) 13. Use digital tools to formulate solutions to authentic problems. Examples: electronic graphing tools, probes, spreadsheets MA2015 (6) 9. Understand a rational number as a point on the number line. Extend number line diagrams and coordinate axes familiar from previous grades to represent points on the line and in the plane with negative number coordinates. [6-NS6] a. Recognize opposite signs of numbers as indicating locations on opposite sides of 0 on the number line; recognize that the opposite of the opposite of a number is the number itself, e.g., - (-3) = 3, and that 0 is its own opposite. [6-NS6a] b. Understand signs of numbers in ordered pairs as indicating locations in quadrants of the coordinate plane; recognize that when two ordered pairs differ only by signs, the locations of the points are related by reflections across one or both axes. [6-NS6b] c. Find and position integers and other rational numbers on a horizontal or vertical number line diagram; find and position pairs of integers and other rational numbers on a coordinate plane. [6-NS6c] MA2015 (6) 11. Solve real-world and mathematical problems by graphing points in all four quadrants of the coordinate plane. Include use of coordinates and absolute value to find distances between points with the same first coordinate or the same second coordinate. [6-NS8] MA2015 (6) 23. Draw polygons in the coordinate plane given coordinates for the vertices; use coordinates to find the length of a side joining points with the same first coordinate or the same second coordinate. Apply these techniques in the context of solving real-world and mathematical problems. [6-G3] MA2015 (7) 1. Compute unit rates associated with ratios of fractions, including ratios of lengths, areas, and other quantities measured in like or different units. [7-RP1] MA2201007070000102.jpg MA2015 (7) 2. Recognize and represent proportional relationships between quantities. [7-RP2] a. Decide whether two quantities are in a proportional relationship, e.g., by testing for equivalent ratios in a table or graphing on a coordinate plane and observing whether the graph is a straight line through the origin. [7-RP2a] b. Identify the constant of proportionality (unit rate) in tables, graphs, equations, diagrams, and verbal descriptions of proportional relationships. [7-RP2b] c. Represent proportional relationships by equations. [7-RP2c] Example: If total cost t is proportional to the number n of items purchased at a constant price p, the relationship between the total cost and the number of items can be expressed as t = pn. d. Explain what a point (x, y) on the graph of a proportional relationship means in terms of the situation, with special attention to the points (0, 0) and (1, r) where r is the unit rate. [7-RP2d] MA2015 (7) 3. Use proportional relationships to solve multistep ratio and percent problems. [7-RP3] Examples: Sample problems may involve simple interest, tax, markups and markdowns, gratuities and commissions, fees, percent increase and decrease, and percent error. MA2015 (7) 11. Solve problems involving scale drawings of geometric figures, including computing actual lengths and areas from a scale drawing and reproducing a scale drawing at a different scale. [7-G1]

Local/National Standards:

Primary Learning Objective(s):

Students will use the Internet to research stock trends to find prospective stocks to purchase. Students will use online trading to simulate trading of stock. Student teams will use spreadsheet software to track purchases, sales, increases and decreases in stock values, and calculate portfolio values.

Student teams will use the Internet to research stocks of companies by looking at charts and graphs to determine good investments.

Preparation Information
 Total Duration: Greater than 120 Minutes Materials and Resources: Alabama Stock Market Tracking sheets for each team (see attached) Technology Resources Needed: Computer lab with Internet access for first day of project, classroom computer with Internet access for weekly updates for students Background/Preparation: Students will need to be enrolled in the Alabama Stock Market simulation game. Cost is \$15.00 per team with a maximum of 5 students per team. Students will need basic knowledge of spreadsheets.

Procedures/Activities:
 1.)Introduce students to the Alabama Stock Market website.You may also want to have available daily newspapers for students to view stocks and prices. Students will simulate trading stocks using this website. In the computer lab, allow time for students to use the Internet to research stock trends in order to find prospective stocks to purchase.(AlabamaSMS)Students can conduct research, make purchases, view account details, and find other information pertaining to the stock market and the simulation. 2.)Students will print an account detail and summary sheet each week from the Alabama Stock Market Simulation website. 3.)Student teams will set up tables in a spreadsheet program using the Alabama Stock Market Simulation format as a guide to track purchases of stocks. 4.)Teams will check tables for accuracy. 5.)Allow student teams time each week to update information. 6.)After the fifth week of data is entered, create charts to show the changes in the individual stocks and the portfolio values. 7.)At the end of the 10-week trading period, have students enter final data from their portfolios. Print tables and graphs with the final information. Lead a class discussion as to which stocks were good investments and how prospective buyers might make these determinations.

 Attachments:**Some files will display in a new window. Others will prompt you to download. Stock Tracking Spreadsheet.xls Stock Market Graph Rubric.doc

Assessment
 Assessment Strategies The completed student tables and graphs will be assessed. The attached rubric will be used to assess the product.

 Acceleration: Students may want to complete one of the following stock market WebQuests: http://frontiernet.net/~jljkd/stock/ or http://www.hobart.k12.in.us/kuyachich/QUEST/stqt.html. Intervention:
 Each area below is a direct link to general teaching strategies/classroom accommodations for students with identified learning and/or behavior problems such as: reading or math performance below grade level; test or classroom assignments/quizzes at a failing level; failure to complete assignments independently; difficulty with short-term memory, abstract concepts, staying on task, or following directions; poor peer interaction or temper tantrums, and other learning or behavior problems. Presentation of Material Environment Time Demands Materials Attention Using Groups and Peers Assisting the Reluctant Starter Dealing with Inappropriate Behavior Be sure to check the student's IEP for specific accommodations.