Posts tagged data
6th and 7th grade students have kicked off their 12-week stock market exchange competition, sponsored by math teacher Pam.
This project ties in nicely with our advanced spreadsheet functions. We’ll use spreadsheets to pull in information and analyze trends. Today we played with historical stock data using a new formula:
Available attributes are:
- price: market price of the stock – delayed by up to 20 minutes.
- priceopen: the opening price of the stock for the current day.
- high: the highest price the stock traded for the current day.
- low: the lowest price the stock traded for the current day.
- volume: number of shares traded of this stock for the current day.
- marketcap: the market cap of the stock.
- tradetime: the last time the stock traded.
- datadelay: the delay in the data presented for this stock using the googleFinance() function.
- volumeavg: the average volume for this stock.
- pe: the Price-to-Earnings ratio for this stock.
- eps: the earnings-per-share for this stock.
- high52: the 52-week high for this stock.
- low52: the 52-week low for this stock.
- change: the change in the price of this stock since yesterday’s market close.
- beta: the beta value of this stock.
- changepct: the percentage change in the price of this stock since yesterday’s close.
- closeyest: yesterday’s closing price of this stock.
- shares: the number of shares outstanding of this stock.
- currency: the currency in which this stock is traded.
A few students also pulled in weekly or daily data for a stock using:
=GoogleFinance(“symbol”, “attribute”, “start_date”, “num_days|end_date”, “interval”)
- “symbol” – stock symbol
- “attribute” – high, low, open, close, vol, or all (quote also works, and defaults to close).
- “start_date” – the date for the historical data. When only the start_date is specified, the historical data is just for that day.
7th grade has studied Spreadsheet functionality for a couple of months now. Finally we get a chance for some free exploration and to follow our personal interests. For 4 classes, students choose one path and try to bring an idea from concept to completion. The choices for these independent projects are:
- find a data set and use formulas and graphs to make the data interesting and easy to understand
- example – figure out how many basketball courts there are in each zip code in Seattle
- example – a prime number tester that asks for a number and then tells you if it is prime or not
- create a game in a spreadsheet that uses formulas and/or scripts to make it cool.
- example – battleship that is automatically set up when you click a button.
- example – battleship that keeps score and tells you when you win.
- build a survey that dumps results into a spreadsheet and then analyze the results
- example – find out what the most popular cell phone service is and what kind of texting plan most students have.
And here is a breakdown of what students actually chose. It seems like option #1 didn’t enough creativity to capture attention. The majority of students chose to create surveys – what a great way to use technology to interact with other people and learn more about your world.
Samples of work will be posted on the blog as projects are completed.
7th grade spreadsheet mastery continues with some essential skills that allow students to effectively manage data and control the way it looks. We took some time to learn how to:
- resize rows & columns
- delete rows & columns
- merge cells
- control the color & size of text
- change the background color
- change colors with rules
- reference cells with coordinates
What’s a fun way to learn this stuff? BATTLESHIP! Students used the above skills to build spreadsheet-based BATTLESHIP boards and then paired up to play. There were plenty of ideas for improvements, some of which will be attempted by students during independent projects. Abe mentioned an auto-scoring system that uses formulas to figure out who is winning. Mason is attempting a BATTLESHIP board that is one-player and allows the spreadsheet to counter-attack.
Below are Kallie and Enzo’s finished boards: