- The exam is closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.
- Exam # 2 covers all the lectures from “Semi-structured data” to “Data visualization”.
- Study Guide for Exam #2 (word)
- Study Guide for Exam #2 (ppt)
- Additional practice questions covered on 3/25
Assignment #6: Python Pandas [Due Thursday, 3/20/25 at 11:59 pm]
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/20/2025, 11:59 pm.
Assignment #5: Python and JSON [Due Thursday, 3/13/25 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 through Canvas>Assignment>To-Do.
Due date: Thursday, 3/13/2025, 11:59 pm.
Assignment #4: Python Basics [Due Thursday, 2/27/25 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/27/2025, 11:59 pm.
Setting up Anaconda and Jupyter Notebook
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]
- 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.
Assignment #3: SQL 2 – Advanced Queries [Due Tuesday, 2/11/25 at 11:59 pm]
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)
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]
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]
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.