Instructor: Jing Gong, Section 002/004

Jing Gong

Jing Gong joins the Fox School on a tenure-track appointment from Carnegie Mellon University, where she studied for a PhD in Information Systems and Management. She is interested in using empirical models to analyze firm and consumer behavior in online markets, with primary focuses in electronic commerce, digital marketing, two-sided online markets, online labor markets, and business analytics. Her research uses interdisciplinary approaches such as econometrics, Bayesian statistics, economic structural modeling, field experiment, and text analytics. Jing’s work has appeared in several major conferences and workshops including International Conference on Information Systems (ICIS), Workshop on Information Systems Economics (WISE), Conference on Information Systems and Technology (CIST), Marketing Science Conference, and China Summer Workshop on Information Management (CSWIM). She was the 2014 recipient of the Best Student Paper Award at the Conference of Information Systems and Technology and the 2014 Best Paper Award runner-up, at the China Summer Workshop on Information Management. Jing holds a Bachelor's Degree in Information Management and Information Systems from Tsinghua University in Beijing, China.

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

Setting up MySQL Workbench Before Week 4

We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around February 6, 2018.

(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;

If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.

You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to setup your software and connection.

(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Under Grades in Canvas.

  • To find it, in Canvas, click Grades, then click “MySQL Account
  • You will find the MySQL username and password are added as comments to “MySQL Account.”
  • The first value that starts with “m” is the username, and the second value is the password.

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.

Using ERDPlus to Creat Entity Relationship Diagrams (ERD)

Starting from Thursday, January 18, we will learn how to create Entity Relationship diagrams (ERDs) to model databases.

To create ERDs, we will use ERDPlus, a free tool that is quite easy to use.

Specifically, we will use the standalone version of ERDPlus (https://erdplus.com/#/standalone), which allows us to create an ERD within a browser.

This is a short YouTube tutorial on the site that shows you how to create a diagram, and export the diagram as an image which can be placed into a Word document. Please watch this video on your own before Tuesday, January 23.

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!