Warning message
Information shown for on this page is for 2017-18 semester, not for the current semester!
IT 102, 2017-18
Room: Harriman115
Time: Sunday 9:15AM - 10:00AM
Grades: 7-10
Prerequisites:
Material fee: $0.00
Homeworks
These homeworks are copyrighted material, posted here for use by
SchoolNova students and parents. Everyone else is welcome to print a copy of these materials for their personal use;
any redistribution or commercial use is prohibited
- Assigned on 09/17: IT102 Overview |
- Assigned on 09/24: History of RDBMS Technology |
Install MySQL Server and MySQL Workbench
- Assigned on 10/1: Entity Relationships |
- Assigned on 10/15: Data Definition Language |
- Assigned on 10/22: Foreign Keys |
- Assigned on 10/29: SQL Select Statement |
- Assigned on 11/5: SQL Select Statement, part II |
- Assigned on 11/12: SQL Insert, Update, Delete |
- Assigned on 11/19: SQL Exercises |
- Assigned on 12/3: Normalization |
- Assigned on 12/10: Normalization, 2NF and 3NF |
- Assigned on 12/17:
No homework
- Assigned on 01/7: Introduction to Python |
- Assigned on 01/14: Python I/O |
- Assigned on 01/21: Tkinter |
- Assigned on 01/28: Web Services |
- Assigned on 02/4: Date and Time |
- Assigned on 02/11:
Students,
Most of you encountered an error in today's exercise while trying to create a Windows executable file from the weather application. Unfortunately, the library we used - py2exe - supports Python v3.3 or v3.4 only. We installed Python v3.6 for this class. I don't think we should downgrade Python for the sake of the exercise, and apologize for not uncovering this incompatibility ahead of the class. Have a great weekend, and I will see you on Feb. 25.
Sincerely,
Serge
- Assigned on 02/25: Regular Expressions |
- Assigned on 03/4: Regular Expressions - Exercises |
- Assigned on 03/11: Cybersecurity: Key Logger |
- Assigned on 03/25: Cybersecurity: Passwords |
- Assigned on 04/8: Cybersecurity: Spam, Spoofing and Phishing |
- Assigned on 04/15: Cybersecurity: Port Scanning |
- Assigned on 04/22: Common Gateway Interface |
- Assigned on 04/29: Collections: List, Tuple and Dictionary |
- Assigned on 05/6: Python and MySQL |
- Assigned on 05/13: Bubble Sort Algorithm |