Data and Analytics (Sec 2)

Setting up Anaconda and Jupyter Notebook

February 14, 2025 Leave a Comment

We will use Python for the rest of the semester starting from 2/20.
Please see the instruction link and install the software before the next class.

What is Python?
● Python is an interpreted, high-level, general-purpose programming language.

What is Jupyter Notebook?
● Jupyter Notebooks are a powerful way to write and iterate on your Python code for data analysis. Rather than writing and re-writing an entire program, you can write lines of code and run them one at a time.

What is Anaconda?
● Anaconda is a free and open-source distribution of the Python and R programming languages for scientific computing that aims to simplify package management and deployment.

Exam #1 Study Guide: Data&Information/Schema/SQL [During class time on 2/13]

February 5, 2025 Leave a Comment

The exam is a closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.
Exam # 1 covers all the lectures up to “SQL 2: Getting Information Out of a Database – Advanced Queries”. We will have a review session on 2/11.
Study Guide for Exam #1 (word)
Study Guide for Exam #1 (ppt)
Here are some practice questions, in case you want more exercise.
- SQL Query Practice Problems- Solutions

Assignment #3: SQL 2 – Advanced Queries [Due Tuesday, 2/11/25 at 11:59 pm]

February 4, 2025 Leave a Comment

Due date: Tuesday, 2/11/2025, 11:59 pm.

Here are the instruction: Assignment #3 – SQL Advanced Queries.

Submit your answer sheet as a word or PDF document through Canvas>Assignment>To-Do.

Introducing a new learning tool: MasteryGrids (Extra Credit)

January 30, 2025 Leave a Comment

MasteryGrids system is an interactive learning tool that helps you improve and track your understanding of course concepts. The system visualizes your progress through different course topics using a color-coded grid, where darker shades indicate higher mastery levels. As you work through the exercises and questions, you’ll not only strengthen your knowledge, but you can also earn extra credit. Specifically, you will receive a checkmark for a topic when you complete at least two Independent problems in it, and you can earn up to two extra points toward your final grade if you get checkmarks for all the topics presented in MasteryGrids. However, beyond the extra points, active engagement with MasteryGrids is an excellent way to reinforce learning. You can access the system anytime to practice and improve at your own pace. (Please note that your activity in MasteryGrids will be evaluated based on progress made up until the final exam on April 23.)

To get started, simply follow the http://adapt2.sis.pitt.edu/kt/ and log in using your existing MySQL data server username with “tu” added at the beginning. For example, if your data server username is m123, your MasteryGrids username will be tum123. The password is the same as the one you use for the MySQL server. If you would have any questions, please reach out to Prof. Bauman at kbauman@temple.edu.

Assignment #2: SQL 1 – Basic Queries [Due Tuesday, 2/4/25 at 11:59 pm]

January 28, 2025 Leave a Comment

Here are the instructions: Assignment #2 – SQL Basic Queries and an answer sheet to submit (in Word format).

Submit the answer sheet as a word or PDF document through Canvas>Assignment>To-Do.

Due date: Tuesday, 2/4/2025, 11:59 pm.

Assignment #1: Creating Schemas [Due Tuesday, 1/28/25 at 11:59 pm]

January 20, 2025 Leave a Comment

Here is the assignment instruction based on MySQL Workbench: Use MySQL Workbench and the provided Schema template to complete the assignment and submit your work on Canvas.

Remember, you must submit all the required files mentioned in the instructions. Points will be deducted for submissions in the wrong format.

How to set up MySQL Workbench

January 13, 2025 Leave a Comment

We’ll be using MySQL Workbench to create database schema in our first ICA next Tuesday (1/21).

You can get instructions for how to install MySQL Workbench in this Quick Guide to MySQL Workbench. Use the guide to set up your software. (You only need to follow till Part 2 on page 4! ID/PW is not required at this point)

I suggest you install the software before Tuesday!

If the newest version doesn’t work on your laptop, please install a previous version (e.g., 8.0.30) following the link.

If you are having an issue installing MySQL workbench, you can create database schema using MySQL Workbench on a virtual machine using the Owlab: https://owlab.temple.edu

The machine has MySQL Workbench so once you use your Accessnet account to login, you can search MySQL in the left button search bar. The page below provides the process on how you can log in to the machine: https://cla.temple.edu/tech-notes/remote-access/owlab/

Welcome to MIS2502 Data and Analytics!

January 6, 2025 Leave a Comment

Dear students,

This is your instructor speaking. Hope you had a great winter recess and welcome back!

Please note that we will use this website 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 web site regularly.

The Canvas site will be primarily for assignment submission and sharing videos/recordings. The grades will also be posted on Canvas.

Please also take a few minutes to complete this survey: MIS 2502 Survey: Get to know your background, by Jan 13th. This survey is for me to know a bit about your background.

Our first class will be on Jan 14th at 12:30 p.m. at Alter 234.
Looking forward to seeing you on Tuesday!

Regards,
Jaehwuen Jung