Here are the instructions: Assignment #4 – Python Basics.
Submit your answer sheet as an HTML document through Canvas>Assignment>To-Do.
Due date: Thursday, 2/26/2026, 11:59 pm.
Setting up Anaconda and Jupyter Notebook
We will use Python for the remainder of the semester, starting on Feb 19th.
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/12]
- 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/10.
- Study Guide for Exam #1 (word)
- Study Guide for Exam #1 (ppt)
- Here are some practice questions, in case you want more exercise.
Assignment #3: SQL 2 – Advanced Queries [Due Tuesday, 2/10/26 at 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.
Introducing a new learning tool: MasteryGrids (Extra Credit)
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 your progress until each exam date. For instance, you can get extra credit for the SQL part for your work completed BEFORE exam 1.
To get started, simply follow the http://adapt2.sis.pitt.edu/kt/ and log in using your existing MySQL data server username with “s26” added at the beginning. For example, if your data server username is m123, your MasteryGrids username will be “s26m123”. The password is the same as the one you use for the MySQL server. If you would have any questions, please reach out directly to Prof. Bauman at kbauman@temple.edu.
Assignment #2: SQL 1 – Basic Queries [Due Tuesday, 2/3/26 at 11:59 pm]
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/3/2026, 11:59 pm.
Assignment #1: Creating Schemas [Due Tuesday, 1/27/26 at 11:59 pm]
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.
Please set up MySQL Workbench
We’ll be using MySQL Workbench to create a database schema in our first ICA next Tuesday (1/20).
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 next Tuesday!
- If the newest version doesn’t work on your laptop, please install a previous version (e.g., 8.0.44) 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/
Course Recording Policy
Not all classes will be recorded by default. However, if you have to miss a class due to unavoidable circumstances, please let me know at least one hour before class, and I will do my best to record the session so you can review it afterward.
As I mentioned earlier, many of our topics will build closely on material we have already covered. Because of this, missing even a single session can make it harder to follow later discussions. If you anticipate being absent, please let me know in advance so we can avoid any unnecessary difficulties.
Welcome to MIS2502 Data and Analytics!
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 website 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 12th. This survey is for me to know a bit about your background.
Our first class will be on Jan 13th at 12:30 p.m. at Alter 234.
Looking forward to seeing you on Tuesday!
Regards,
Jaehwuen Jung