SOFT7008 Week 08 Lecture

In the lecture we briefly recapped on connecting to a Database. We spent most of the class discussing the assessments.

I showed students how to access the e-Journals on the CIT Library website.  IEEE and ACM are good places to look for authoritative articles.

At 1900-ish we moved to the lab. Students worked on the assignments.

SOFT7008 Week 08 Classes

Class 15: Database Consistency [& Normalization]

Class 16: Connecting to a Database

SOFT7008 Week 07 Lecture

I did a quick recap of relational databases, normalization, and SQL. I could tell from everyone's faces that it was news to nobody.

At 1900 we moved to the lab to work on this week's exercise.

SOFT7008 Week 07 Classes

This week we begin our look at Relational Databases & SQL

Class 13: Introduction to Databases

Class 14: Introduction to SQL

SOFT7008 Week 06 Lecture

We looked at the different ways to make data persist in PHP and how long it can last.  We also considered a bit how cookies can pose a threat to privacy.

SOFT7008 Week 05 lecture

Some students came to class despite the weather warning.

Students worked on the checksum exercises. We did some on the board.

SOFT6008 Week 06 Classes

Class 11: Remembering Values

Class 12: Cookies

More about cookies:

• http://www.theatlantic.com/technology/archive/2011/08/the-next-online-privacy-battle-powerful-supercookies/243800/
• http://www.theatlantic.com/technology/archive/2012/02/im-being-followed-how-google-151-and-104-other-companies-151-are-tracking-me-on-the-web/253758/
• http://www.wired.com/threatlevel/2010/07/zombie-cookies-lawsuit/
• http://www.wired.com/business/2009/08/you-deleted-your-cookies-think-again/
• http://www.wired.com/threatlevel/2012/02/google-safari-browser-cookie/
• http://www.wired.com/business/2010/12/zombie-cookie-settlement/
• https://www.cookielaw.org/
• https://www.aboutcookies.org/

SOFT6008 Week 05 Class

In light of the weather warning for tonight I e-mailed exercises to students and suggested that they could work from home if they wish. I will be available online on Google Hangouts to answer any questions.  For those students that want to come to class I will be here anyway.

SOFT7008 Week 05 Videos

Class 09: The magic of cheksums

Class 10: User input validation in PHP

SOFT7008 Week 04 Lecture

I spoke a bit about HTML 5 inputs and how the browser do some very basic form validation for us.

We did some exercises using regular expressions. They didn't go as well as I would have liked. So perhaps some students need look at those again.

I previewed next weeks videos by introducing checksums.  We looked at the Luhn credit card validation algorithm.  Students seemed less impressed by this magic that I was expecting.

We moved to the lab at 2000


I e-mailed students the specification for the coding component of the module.

SOFT7008 Week 04 Videos

This is a solution to the exercise posed last week.


Week 04 Videos are Classes 07 & 08

Class 07

Class 08

More:

About regular expressions: https://regexone.com/lesson/introduction_abcs

SOFT7008 Week 03 Lecture

We looked at passing parameters.

We paid particular to the difference between passing variables by value and by reference.

Students did a paper exercise on passing by value and by reference.

We looked at recursive functions for multiplication and Fiboancci sequence. The Colin tried the code for the Towers of Hanoi off the top of his head.  The code was OK but tracing the execution of it on the board was a head-wreck.

We moved to the lab at about 1930

SOFT7008 Week 03 Videos

Video lectures for Week 03:

Class 05

Class 06

SOFT7008 Week 02 Lecture

I did a very rapid summary of the contents of this weeks lecture videos.

I gave students exercises to do. They took a bit longer than I was expected.

I did Exercise 1 on the screen and e-mailed it to students.  We went to the lab early so that students without machines could get cracking on the code.

SOFT7008 Week 01 Lecture

While we were waiting for everyone to arrive I gave out a HTML exercise.

For this module should should already know

• some HTML
• how to program

I spoke a little bit about the inverted classroom model.  Note everybody watched the videos in advance.  But that's not a big surprise

I asked students to install XAMPP on their machine if they had them handy.  We looked at how to view html file and PHP files via localhost. The files must be in htdocs.

We looked at variables in PHP and string manipulation.

Students did an exercise on variable substitution in PHP. That's tricky.

We looked at the assessment for the module.

We didn't continue on the the labs at 2015. We all went home.

I asked students to watch the following videos before next week's facetime.  We'll see how that works and whether it frees up time for coding.

Class 03

Class 04

SOFT7008 Week 01

I e-mailed students and asked them to watch these videos in advance of the class.

Class 01

Class 02

LEGS8007 IP Law Repeat

The exam for the repeat of this module will be on the 24th May at 10 am in Melbourn.

SOFT7008 Week 11

There are no more lectures for this module.  Starting this week there will be evening support sessions on both Monday and Wednesday nights.

SOFT7008 Week 10 Lecture(s)

Class 17 Web Application Security

Further reading:

https://www.wired.com/2016/05/hacker-lexicon-sql-injections-everyday-hackers-favorite-attack/

https://arstechnica.com/information-technology/2012/08/passwords-under-assault/

https://arstechnica.com/information-technology/2013/03/how-i-became-a-password-cracker/

SOFT7008 Week 09 Lectures

Class 15 Database Design

Class 16 Connecting to the Database