Michael Remy

The following video provides a great introduction to doing pivot tables in Excel:

Here is the link for week 11 quiz.

You need to complete the quiz before our session starts on Monday.

Announce your group and its members using this form by 4/5.

Those who have not found a group by this deadline will be assigned randomly to the groups.

Submit your individual assignment 2 (answer sheet and Excel spreadsheet) using this form:

Here are some extra office hours to get help with the Individual Assignment 2!

ALEKSI

Thursday (3/30): 3–5pm, – in-person in room Speakman 206D
Friday (3/31): 4.30–5.30pm – in-person in room Spe […]

Here is a simple introduction to the concepts behind MapReduce and Hadoop Big Data technologies.

Note that the products themselves are less interesting than the idea of how we can process huge amounts of data effectively.

Wikipedia has fairly good articles on KPIs (https://en.wikipedia.org/wiki/Performance_indicator) and the SMART criteria (https://en.wikipedia.org/wiki/SMART_criteria).

Time: Friday, 31 March 2023, 10:30–12:00
Room: LW420
Abstract
With the increasing use of recommender systems in various application domains, many algorithms have been proposed for improving the accuracy of r […]

Here is the link for week 9 quiz.

You need to complete the quiz before our session starts on Monday.

Here is a short clip explaining how relative cell references differ from absolute cell references in Excel.
Here is also a link to my Excel demo spreadsheet.

This video demonstrates differences between a relational database and an Excel spreadsheet for storing data:

Here are the specification and dataset for Individual Assignment 2 due 4/5.

Time: Friday, 24 March 2023, 10:30–12:00
Room: LW420
Abstract
Communities make sense of social issues through discourse. An “issue” is a matter of potential concern. Issues can involve public policy or innov […]

Here is the link for week 8 quiz.

You need to complete the quiz before our session starts on Monday.

Time: Friday, 17 March 2023, 10:30–12:00
Room: LW420
Abstract
Increasingly, artificial intelligence (AI) serves as a frontline operator, while humans perform backend operations. Despite growing firms in the g […]

Submit your. cleaned Excel workbook for extra credit using this form (by the end of week):

Here are some of my favorite horror stories how things went wrong due to bad data:

(A blog post with examples – including the classic NASA mishap – of how things go wrong when people get data types wrong.)

Here is the link for week 7 quiz.

You need to complete the quiz before our session starts on Monday.

Time: Friday, 3 March 2023, 10:30–12:00
Room: LW420
Abstract
Older workers use organizational IT in qualitatively different ways than their younger counterparts. In particular, they often focus on a few cor […]

Here are some extra office hours to get help with the Individual Assignment 1!
 
ALEKSI

Wednesday 2/22 2–3pm
Thursday 2/23 3–4pm
Friday 2/24 2–3pm
Tuesday 2/28 4–5pm
Other times availabl […]