Tags

Activity Industry Sector
Health Science and Medical Technology

Activity Originally Created By: Daniel Raffa

Steps 6-9 on Worksheet (final analysis)

Part of Lesson Plan: Investing in Biotechnology Companies

Activity Overview / Details

Steps 6-8 take students through step by step on how to make 2 graphs, one is total value and the other is price per share over the 14 weeks.  The directions are for MS Excel.  Again if you use a different spreadsheet program, I have done it in Google Documents but I like MS Excel better.  Since this is the end of the semester my students have been graphing a lot.  I find that I do not need to model this on the board.  The detailed directions on the worksheet and their peers giving each other guidance is enough for them to create the graphs.  I monitor the class room helping the students who need it and giving guidance where needed. 

Step 9 is making the Power Point Presentation and then inserting the graphs they made into the presentation.  I have attached a student example for you to get an idea. 

Materials / Resource

  • Stock Project Student Example Stock Project Student Example [ Download ]