Lecture Materials

Lecture 1 Overview — What is Data?

• Slides, 1 per page
• Slides, 4 per page
• Disability Services Announcement

Lecture 2 Data and Environments

• Slides, 1 per page
• Slides, 4 per page

Lecture 3 Introduction to Python

• Slides, 4 per page
• Python Notes (NCSS Challenge Week 1)
• Python website
• Python 2.7.2 release

Lecture 4 Using Spreadsheets

• Slides, 1 per page
• Slides, 4 per page

Lecture 5 Regular Expressions

• Slides, 1 per page
• Slides, 4 per page

Lecture 6 sed and Python if statements

• Slides, 1 per page
• Slides, 4 per page
• Python Notes (NCSS Challenge Week 1)
• example.py

Lecture 7 Modelling in Excel

• Slides, 1 per page
• Slides, 4 per page

Lecture 8 Introduction to Databases

• Slides, 1 per page
• Slides, 4 per page

Lecture 9 Python

• Python Notes (NCSS Challenge Week 2)

Lecture 10 Data Modelling

• Slides, 1 per page
• Slides, 4 per page

Lecture 11 Introduction to SQL

• Slides, 1 per page
• Slides, 4 per page

Lecture 12 Python

• Python Notes (NCSS Challenge Week 2)

Lecture 13 More SQL

• Slides, 1 per page
• Slides, 4 per page

Lecture 14 The Project + Revision

• Slides, 1 per page
• Slides, 4 per page

Lecture 15 Python Review + Dictionaries

• Python Notes (NCSS Challenge Week 3)
• Python Notes (NCSS Challenge Week 4)
• dow.py

Lecture 16 Review

• Slides, 1 per page
• Slides, 4 per page
• multdiv.py

Lecture 17 Internet Technologies

• Slides, 1 per page
• Slides, 4 per page

Lecture 18 Internal workings of Hash Tables (Python Dictionaries)

Lecture 19 Common Gateway Interface

• Slides, 1 per page
• Slides, 4 per page
• HTML and CGI examples
• get_form.html
• post_form.html
• psocket.py
• README for psocket script
• test.py (rename to test.cgi)
• hello.py (rename to hello.cgi)

Lecture 20 Software Engineering

• Slides, 1 per page
• Slides, 4 per page

Lecture 21 Python (NCSS Challenge Week 4)

• Python Notes (NCSS Challenge Week 4)

Lecture 22 Testing and Debugging

• Slides, 1 per page
• Slides, 4 per page
• Debugging Challenge 1
• Debugging Challenge 2
• grades_buggy.py
• grades_correct.py

Lecture 23 Python (NCSS Challenge Week 4)

• Python Notes (NCSS Challenge Week 4)
• facebook.py
• latin_taxi.py
• multdiv.py
• readfile.py

Lecture 24 Python (NCSS Challenge Week 5)

• Python Notes (NCSS Challenge Week 5)

Lecture 25 XML and Web Services

• Slides, 1 per page
• Slides, 4 per page

Lecture 26 Python (NCSS Challenge Week 5)

• Python Notes (NCSS Challenge Week 5)

Lecture 28 Information Visualisation

• Slides, 1 per page
• Slides, 4 per page

Lecture 31 Reports and Presentations

• Slides, 1 per page
• Slides, 4 per page