1. Finish Activity 1 (Parts 1& 2). (Look for details posted in last class' blog entry)
2. Start thinking about your guiding questions (what will you like to learn) about the Stock Market and tracking shares and write them down in you new G-Shared Doc, that later be included in your Investigation stage.
3. Explore Using
formulas in a spreadsheet to generate number patterns. Let's try this:
- If we would to generate a simple pattern of numbers which is contained in a single column, looks like this: 1,1,0,2,2,0,3,3,0,4,4,0,...
- How do you think we can generate the same pattern using a formula instead of typing all the numbers in a column?
- There are several different ways you can use to achieve the desired pattern. How many ways can you find of doing it?
4. Try other number patterns that you would lie to generate. Eg: Fibonacci Numbers
5. Work on Activity 8: from The NYSE Up Close and Personal Activity Booklet.
Can we be internationally minded here? Is NYSE the only stock exchange in the world? Do you know any other Stock Markets?
- Your task is to invest the money in shares (justify your choice of shares: min 3 companies, max 5 companies, with at least one international company)
- You must also design a spreadsheet that keeps track of the value of the shares on a daily basis in a way that is easy to understand (she is not an excel specialist but she likes everything to be explained to her).
- She wants to know how much the value has changed from the initial investment and from day to day.
- Let's look into these:
- How many companies can I invest in?
- How much does it cost to make a trade?
- How long will the investment be?
- Where and how will you follow the prices?
- How will you test the product?
- How sophisticated will your spreadsheet/formulas need to be? Will you need multiple pages? How do you make cell references between different pages?
6. Start your Process Journal for Project 2 today! Make your daily record of what you learnt/progressed today.
