Here are the instructions and csv file: Assignment #6 – Python Pandas and Sales.csv.
Submit your answer sheet as an HTML document through Canvas>Assignment>To-Do.
Due date: Thursday, 3/19/2026, 11:59 pm.
Assignment #5: Python and JSON [Due Thursday, 3/12/26 at 11:59 pm]
Here are the instructions and JSON file: Assignment #5 – Python and JSON and restaurant.json.
Submit your answer sheet as an HTML document.
Due date: Thursday, 3/12/2026, 11:59 pm.
Assignment #4: Python Basics [Due Thursday, 2/26/26 at 11:59 pm]
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/