Leave your response as a comment on this post by the beginning of class on April 7, 2016. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
Here is the question:
Think about a data-driven service that you use regularly (i.e., Blackboard, Amazon.com, Facebook). Imagine you want to store the data for that service in a spreadsheet – what would each row in the spreadsheet represent? What would some of the data columns be?
(For example, Yelp.com stores restaurant reviews. A row would be an individual review, and some columns would be the name of the restaurant, the type of food they serve, the address, the star rating, and the name of the reviewer.)
Here is the exercise.
And here is the spreadsheet you’ll need for this exercise [In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats.xlsx].
And here is the answer key.
Some quick instructions:
You must complete the quiz by the start of class on March 29, 2016.
- When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It will then take you to the quiz.
If it says you don’t have access, make sure you’re signed out of your regular Gmail (non-TUMail) account!
- You can only do the quiz once. If you submit multiple times, I’ll only use the first (oldest) one.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Leave your response as a comment on this post by the beginning of class on March 31, 2016. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
Here is the question:
Once last time, find another online article dated within last two weeks from a credible source that has something to do with data and is interesting and relevant to you. Copy and paste the URL directly into your response followed by a few sentences that explain what is interesting about it.
Here is the Excel function example worksheet we discussed in class. It demonstrates VLOOKUP(), MATCH(), and CONCATENATE().
The weekly question is busy studying for the exam. You should be too!
No new readings, no quiz! Study for the exam instead!
Here is the study guide for the second exam.
Exam 2 is on March 24, 2016.