Excel Exercise - Assignment 1
From Katherine Kendall
Assignment 1: Data Collection-Stock market data
Assignment Goal: This exercise is designed to allow students to visit a publicly available data source and extract relevant stock market data.
Weekly Outcomes: At the completion of this week’s assignment, students will understand how to select and extract data relevant to assigned tasks.
Weekly Topics/Tasks: Data Collection
On Yahoo Finance, find stock data for most recent complete year and filter monthly for your assigned company
Download data from Yahoo Finance and open an Excel spreadsheet
In your spreadsheet, format columns to accommodate data width
Save worksheet as “Last Name – Company”