Lawrence Dignan
Your reading for April 24
Here’s your reading for the week ahead:
In-Class Exercise 12.2: Sentiment Analysis Using Excel
Here is the exercise.
And here is the spreadsheet you’ll need for the exercise [In-Class Exercise 12.2 – Sentiment Analysis Tools.xlsx].
Nathan office hours April 13
Nathan’s office hours to help with any questions about the online class yesterday will be from 12:15 pm – 1:45 pm this Thursday (April 13) at Alter 236G. Time can also be used for any group trying to refine, nail down their group assignment topic.
Weekly Question #10: Complete by April 17, 2017
Leave your response as a comment on this post by the beginning of class on April 17, 2017. 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.)
Reading Quiz #9: Complete by April 17, 2017
Some quick instructions:
- You must complete the quiz by the start of class on April 17, 2017.
- 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.
Ready? Take the quiz by clicking this link.
In-Class Exercise 12.1: Manually Determining the Sentiment of Text Data
Here is the exercise.
Your reading for April 17
Here’s your reading for April 17:
WebEx chat for April 10th class
Here’s the video and WebEx walkthrough for the April 10 class. Apologies in advance for the production value, but you’ll get the gist and we can follow up on April 17. I kept it quick. Nathan’s in class exercise walkthrough is here for the second more complicated one. You’ll see where to break for the in-class activity. Just hit pause and do it on the second one.
Other programming notes:
- The link in the WebEx I noted is here for Hadoop’s side projects and buzzwords to note.
- Gradebook should be updated by now. At the far right, you’ll see projections for where you stand now regarding the final grade (assuming status quo performance on participation, quizzes etc).
- I’m sequestered at an offsite so will be slow to respond to email.
Reading Quiz #8: Complete by April 10, 2017
Some quick instructions:
- You must complete the quiz by the start of class on April 10, 2017.
- 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.
Ready? Take the quiz by clicking this link.
In-Class exercise 11.2: Working with ‘Pivot Tables’ in Tableau
Here is the exercise.
Here is the excel spreadsheet you will need to complete this exercise [In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats]