Instructor: Jing Gong, Section 002/004

Uncategorized

Schedule changes for the following weeks (Assignment 2 deadline extended to Thursday 2/15 before class)

As you might have heard, the campus will be closed and classes will be canceled this Thursday (2/8). We will still have Exam 1 on Tuesday 2/20, but the rest of the class schedules will be adjusted accordingly.

Class Schedule:

  • Thursday, 2/8: Class canceled
    Tuesday, 2/13: Lecture – SQL 2 (Putting Data into the Database); ICA 3 – SQL In (using MySQL Workbench)
    Thursday, 2/15: ICA 3 – SQL In (using MySQL Workbench) continued; Review for Exam 1
    Tuesday, 2/20: Exam 1 (****** No Change ******)
    Thursday, 2/22: Lecture – Extract, Transform, Load (ETL)

Assignment:

  • Assignment #2 (SQL Out) – The deadline is extended to Thursday 2/15 before class.

ITA Office Hour (no change):

  • Nathan Pham: Friday (2/9), 1:00 – 2:00 pm, in Alter 240D (Breakout room).
    Aaron Cheng: Monday (2/12), 1:00 – 2:00 pm, in Speakman 201F.

Let me know if you have questions regarding the schedule changes.

Best,
Jing

Companies Using MySQL

You might be interested to know how popular MySQL is in the real world. What companies are running MySQL? Well, the list is quite long (see a complete list of companies using MySQL here), but here are some examples.

  • E-Commerce: Amazon, Airbnb, Alibaba, Booking.com, craigslist, ebay, Google, Groupon, Uber, Yahoo
  • Telecom: Alcatel-Lucent, AT&T Wireless, Comcast, Verizon Wireless
  • Technology: Apple, Cisco, Dell, Hewlett-Packard, Intel, NEC, Symantec, Xerox
  • Web/Social: Facebook, LinkedIn, Twitter, Pinterest, Quora, Wikipedia, Yelp
  • Media/Entertainment: NBCUniversal, New York Times, Youtube
  • Retail: Sears, Walmart, Spirit, Macy’s West
  • Travel/Airlines: Continental Airlines, Virgin America, KAYAK, Orbitz

Agenda for Week 4 (Week of 2/5)

Dear all,

Below is the agenda for Week 4.

Class Schedule:

Assignment:

  • Bonus Assignment (Database Schema) – due on Tuesday, 2/6 before class
  • Assignment #2 (SQL Out) – I will announce this assignment soon, which will be due on Tuesday, 2/13 before class.

ITA Office Hour:

  • Nathan Pham: Friday (2/9), 1:00 – 2:00 pm, in Alter 240D (Breakout room).
  • Aaron Cheng: Monday (2/12), 1:00 – 2:00 pm, in Speakman 201F (Breakout room).

And a MySQL joke, just for fun:

Source: http://database.ca/databasehumorhumourjokes.aspx

Best,
Jing

Agenda for Week 3 (Week of 1/30)

Dear all,

Below is the agenda for Week 3.

Class Schedule:

Assignment:

  • Assignment #1 – ER Modeling is due on Tuesday, 1/30 before class.
  • Bonus Assignment – I will announce a bonus assignment on Database Schema, which will be due on Tuesday, 2/6 before class

ITA Office Hour:

  • Aaron Cheng will hold office hour on Monday 1/29, between noon and 1:00 pm, in Speakman 201F.

(Also note that January 29 is the last day to add or drop a full term 16-week course).

Best,
Jing

Resources for Assignment 1 (ER Modeling)

As Assignment 1 is due next Tuesday, 1/30, here are some additional resources to get help:

1. Our ITA Aaron Cheng will hold office hour on Monday 1/29, between noon and 1:00 pm, in Speakman 201F.

2. As always, I hold regular office hours on Tuesdays and Thursdays between 12:50 and 1:50 pm, in Speakman 201C. If you have a quick question, simply email me and I will get back to you as soon as possible.

3. If you’d like to practice on ERD, here is a practice question: Additional ERD Practice Question

  • It will not be collected. Step by step explanation and solution is provided.

Agenda for Week 2 (Week of 1/23)

Dear all,

Below is the agenda for Week 2.

Class Schedule:

  • Tuesday — More on ERDs (primary keys, relationships, cardinality); ICA #1.2 – Creating ERDs
  • Thursday — From ERDs to Schemas; ICA #1.3 – Converting ERDs to schemas

Assignment:

  • Assignment #1 – ER Modeling is due on Tuesday, 1/30 before class.

(Also note that January 29 is the last day to add or drop a full term 16-week course).

Best,
Jing

Professional Achievement Point Requirement (MIS Majors Only)

Hello everyone,

I have one quick update regarding professional achievement point which applies to MIS majors.

The MIS department has instituted a professional achievement point requirement for MIS majors. Students are required to accumulate 1,000 professional achievement points to meet this graduation requirement.

As a departmental policy, starting from this spring semester, all MIS majors who take MIS2502 are required to to earn a minimum of 200 professional achievement points by the end of the semester.  Students who have earned a “C” or better but do not earn the minimum number of professional achievement points by the end of the semester will receive an “Incomplete” for this course regardless of performance on exams or class participation!

If a student earn earns the minimum number of professional achievement points within one year from the end of the semester and notifies their instructor, the instructor will update their grade from “Incomplete” to a traditional grade.

If a student fails to  earn the minimum number of professional achievement points within one year from the end of the semester or does not notify their instructor that they have earned the minimum number of professional achievement points then their “Incomplete” will be changed to an “F” automatically by the system and will be the student’s permanent grade.

You are STRONGLY encouraged to, at a minimum, do the following to earn professional achievement points:

  1. Create an e-Portfolio and have it listed with the department.
  2. Become an active member of AIS and participate in professional development activities.
  3. Attend the IT Awards Reception (spring semester only) and the MIS Department’s Career Fair.
  4. Volunteer your time for department sponsored events.
  5. Discuss opportunities to earn points for projects with your MIS instructors.

Please contact Professor Mart Doyle (mdoyle@temple.edu) for further information.

Netflix and Data Analytics

This is the video that I was planning to show you in Monday’s class. Unfortunately, the audio in the classroom was not working. Netflix is a great example of how firms can utilize data to create competitive advantages. If you are interested in learning more, check these articles:

 

MIS 2502 Survey: Get to know your background

Please take a couple of minutes to complete this optional survey: MIS 2502 Survey: Get to know your background (link: https://goo.gl/forms/XWAZkAeJkUQnup542) by January 21 (the end of the 1st week). This is for me to know a bit about you so that I can adjust the materials based on your background and interests. Your response would be much appreciated.

Looking forward to seeing you on Tuesday!

Best,

Jing

Welcome to MIS2502 Data Analytics!

Dear students,

Welcome to MIS2502 Data Analytics! This site will host the coursework for both Section 002 and Section 004, by Professor Jing Gong.

Please note that we will use this site to post up-to-date materials such as syllabus/schedule, class announcements, slide decks, in-class activities, and assignment instructions. While I will try to make announcements both in class and on the community site, it is a good idea for you to check the website regularly.

The Canvas site (Canvas.temple.edu) will be primarily for assignment submission, and sharing answer keys and videos/recordings. The grades will also be posted on Canvas.

Looking forward to a great semester!