By now students are working on the fourth week of the stock market challenge using an Excel spreadsheet to set up formulas to calculate the value of their weekly portfolios. They needed to come in with their 4 choices in which to invest their "$10,000" and then monitor the performance of those stocks over a course of 8 to 10 weeks (final number of weeks to be determined after the holidays and based on possible weather complications.) Students have invested in stocks from AAPL to YHOO and everything in between. The most popular investment was Apple, with 25 students purchasing that stock at 118.62 a share. Students received a grade for setting up their first week correctly following the step by step process together in class. (See Tech-onomics 1 Part 2). Some students had corrections to make before going on to week 2. In some cases students chose foreign stocks (they were to purchase stocks traded on NASDAQ or NYSE). Since some students are still making corrections we are not yet ready to post weekly standings.
Along with the skills involved in formatting the Excel spreadsheet, students also have a series of videos relating to the stock market and how it impacts our economy to give them a sense of the why and how of the market. Perhaps they will become investors at an early age. At least they will have a better understanding of all the factors that affect our economy and even their part in it. The video lesson assignment (Tech-onomics 1 Part 1) must be completed no later than December 31. This includes the sharing of the Google Doc so I can review what has been completed. We can then discuss some of the questions raised in January.
In addition to updating stock portfolios we have been participating in the worldwide HOUR OF CODE. Students will need to complete at least a full hour to earn their individual certificates, but I am encouraging them to work beyond that. There are so many skills being developed in the experience of coding that it can benefit them across many subject areas, even if they are not interested in coding as a career.