91368 Databases

Finally updated the eBook that can be used to teach level 2 databases (web / sql). This was necessary as ‘version 1’ used an old (ie: obsolete) function which meant that when we did the topic this year things were more ‘interesting’ than anticipated for roughly half the class.

Updated the eBook that can be used to teach level 2 databases (web / sql). This was necessary as ‘version 1’ used an old (ie: obsolete) function which meant that when we did the topic this year things were more ‘interesting’ than anticipated for roughly half the class.

Here is the link (this has been shared with colleagues around NZ via NZACDITT):

There are quite a few improvements in the resource for example…

  • Some unnecessary material (such as banner creation / recycling) has been removed
  • The planning / test plan part has been streamlined (and made easier)
  • html5 is used to do basic form validation
  • More advanced form validation is included. The resource shows how regular expressions can be used to check name / phone numbers are valid. If there are errors, users are sent back to the original form. Whilst this is not required by the standard, it is very useful going on to level 3 and also helps make the material relevant to kids.
  • It uses SASS (which is very optional – this is made clear throughout the resource and kids can put in colour values rather than variables if they want).