Here are the instructions: Assignment #4 – Python Basics.
Submit your answer sheet as an HTML document through Canvas>Assignment>To-Do.
Due date: Thursday, 10/9/2025, 11:59 pm.
Setting up Anaconda and Jupyter Notebook
We will use Python for the remainder of the semester, starting on October 2.
Please see the instruction link and install the software before the next class.
Once you’ve installed Anaconda, you can check out this video to learn how to open and run Python code in Jupyter Notebook.
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 9/25]
- 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 9/23.
- Study Guide for Exam #1 (word)
- Study Guide for Exam #1 (ppt)
- Here are some practice questions, in case you want more exercise.
Additional Support for MIS2502
To provide additional support, we’ve arranged extra office hours and a study session. Please utilize these resources if needed.
Jaeyeon Jeong (PhD Student, jaeyeon.jeong@temple.edu)
-
Office Hour
– Monday, 3:00–4:00 PM, Speakman 208G
Yulu Yang (Fox Peer Teacher, yulu.yang@temple.edu)
- Office Hours:
– Monday, 2:00–3:00 PM, Alter 236A
– Friday, 10:30–11:30 AM
Zoom link: Join here
Meeting ID: 994 5312 3711, Passcode: 531810 -
Study Session:
– Wednesday, 2:00–3:00 PM, Speakman 200
Assignment #3: SQL 2 – Advanced Queries [Due Tuesday, 9/23/25 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 the progress made up to each exam. For example, the SQL section will be evaluated based on the progress completed by September 24, and extra points will be awarded accordingly.
To get started, simply follow the http://adapt2.sis.pitt.edu/kt/ and log in using your existing MySQL data server username. 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, 9/16/25 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, 9/16/2025, 11:59 pm.
Assignment #1: Creating Schemas [Due Tuesday, 9/9/25 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.
IT Career Fair 2025
Join us on Monday, Sept. 8, 2025, for our annual IT Career Fair. Conduct interviews and network with high-performing students and graduates affiliated with Temple University’s nationally recognized Management Information Systems programs.
Date and Time: Sep 8, 2025, Monday, 11 am – 3 pm
Location: Howard Gittis Student Center – Room 200
Please use this LINK to register. Registration will end this Friday.
How to set up MySQL Workbench
We’ll be using MySQL Workbench to create database schema in our first ICA next Tuesday (9/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 next 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/