Games: Web Development and Databases
Academic Year 2019/20 - Class Log.
Week 1: Thurs Sept. 12th: Welcome! We installed Anaconda, then created some simple HTML to start our web development travels. See the G3-Sept-12.zip file, as well as today's email for more.
Week 2: Thurs Sept. 19th: We took a quick look at CSS (Cascading Style Sheets) and added a bit of colour and style to our webpage. Then we added a FORM to our HTML page, before creating a very small webapp (written in Python) which allowed us to explore the difference between GET and POST when sending data to our web server for processing.
Week 3: Thurs Sept. 26th: Introduced Jupyter Notebook's and covered some Python basics in the AM session. See the emailed notebook for more details. In the PM session, we looked at the odds code and notebook, as well as took a quick intro/tour of Python's functions.
Week 4: Thurs Oct. 3rd: Integers, strings, lists, and dictionaries. See today's two notebooks for all the details.
Week 5: Thurs Oct. 10th: AM: review and reworking of the dictionary materials from last week (as this is really, really important), then in the PM: we worked on working out the Python code and data structure(s) required to manage a leaderboard in Python.
Week 6: Thurs Oct. 17th: AM: we started to work up a small webapp fragment which allows a game player to record a high score. PM: we stored the high score in a Pickle file, then provided a new URL to display the high scores table.
Week 7: Thurs Oct. 24th: AM: Assignment 1 is active (see the email re: same). PM: Assignment 1 is active.
Week 8: Tues Oct. 29th to Nov 1st: No classes due to Conferring. Assignment 1 is active.
Week 9: Thurs Nov. 7th: AM: Assignment 1 is active. PM: Assignment 1 is active. Due end of day, November 8th 2019.
Week 10: Thurs Nov. 14th: No classes due to Open Day.
Week 11: Thurs Nov. 21st: AM: Worked through solution to Assignment 1, but did not finish. PM: Concluded solution to Assignment 1, with high scores functionality now working.
Week 12: Thurs Nov. 28th: AM: Introduction to RDBMS with first look at CRUD and SQL. PM: More databases with first look at 1-N-F (good database design).
Week 13: Thurs Dec. 5th: AM: After a somewhat shakey start, we explored the sakila database in an attempt to work out which video rentals were overdue. PM: We concluded our tour of the sakila database by answering the question: which film produced the greatest income for the video rental business?
Week 14: Thurs Dec. 12th: AM: No class. Prep for SQL class exam this afternoon. PM: SQL class exam from 3:00pm-5:00pm (last class before Christmas).
Week 15: Thurs Jan. 9th 2020: AM: No class. Repeat SQL class exam. PM: We ran through the solutions to the SQL Class Exam - see the emailed PDF for more details.
Week 16: Thurs Jan. 16th 2020: AM: Introduced the DBcm module. PM: Continued to learn about DBcm (especially using executemany).
Week 17: Thurs Jan. 23rd 2020: AM: Used DBcm to replace the pickle code in the Guessing Game with SQL, then talked about impedance mismatch (and what this means). PM: Looked at MongoDB and PyMongo, and explored what document databases can do for us.
Week 18: Thurs Jan. 30th 2020: AM: Description of the final assignment was distributed this AM, together with a plan of action and some hints/comments. PM: Final assignment is now active.
Week 19: Thurs Jan. 30th 2020: AM: Work continues on the assignment - see the select.zip example for a hint of generating clickable lists. PM: Past paper review, then back to working on the assignment.
Week 20: Thurs Feb. 13th 2020: AM and PM: work on the final assignment concludes.
Week 21: Rag/Study Week.
Week 22 and 23: Final Exams.
Return to the Courses page.