Raspberry Pi and iPad

I guess this is what happens you you watch too many YouTube videos. After watching the “my favourite iPad accessory is an Raspberry Pi” video I’ve ordered and built a little Pi.

I’m using the guides flagged up under the video to set up powering it from the USB C on the iPad. There are

Raspberry Pi Setup Guide – http://bit.ly/37menGI Ben Hardill’s USB-C Setup Guide – http://bit.ly/2Ky4SKQ

Long term goals with this are to try and get back into programming for fun, a little every day. I also want to see what can be done with these little Pi systems, which are remarkable little things.

BITS test 2

Information about the database test

This test is a twenty minute, one hour multiple choice test on all the material we have covered (relational model, algebra, SQL)

In the test you will be given a sample database (in an SQL text file) which you will need to download and load onto a mySQL database server.

You can either use your own machine, or use studentnet for this work.


1 – If you are using your own machine, create an empty database (call it testDatabase) BEFORE you copy/paste the SQL text into the phpmysql interface.

2 – If you are using studentnet please ensure that you have a valid password sorted out BEFORE the test (try logging in an hour before).

It will be impossible for the test to be run again in the time that we have available.

There is a sample SQL test database available that has the same structure as the database that will be used in the test. This is a compressed file so unzip the content and then copy/paste the text sampleDatabase.sql

Here are some sample questions to try out before the test – Sample-database-questions

BITS week 5

This weeks material is very practical, involving the redesign of a website into semantic XHTML and CSS. As this is exactly the same process that you will be performing in the assignment, the lecture has been duplicated below, so that you can repeat the process should you wish (or if you missed the lecture).

The lecture notes can be downloaded as a PDF – Lecture 5 handout

If you attended the lecture and feel confident, you can jump straight into the lab exercise

Lab Exercise Styling the page – exercise sheet Lab 5  and the Zip file containing HTML, CSS and images for lab 5

A solution for the complete site is available (i.e. the completed redesign shown in lecture and attempted in lab from the zip file)

If you missed the lecture or wish to see the process again, you can start from here:

This weeks materials are all about using Semantic XHTML and CSS to style a preexisting web site. The web site in question is the (old) version of the Faculty of Business Website (see image).

Activity One Download, extract and then have a look at the markup for this page Faculty of Business and Law.html (zip) – see if you can understand it.

Activity Two Watch the first part of the video – the lecture notes used in all these videos can be downloaded as a PDF – lecture 5 handouts

Video 1 is about 15 minutes long

Activity Three Try and edit your file (from Activity One) to remove all the excess HTML and CSS, like in the video. A completed solution is available to see if what you’ve created matches the video version

Activity Four Watch the second part of the video – where the logical parts of the document are marked up using DIVs and SPANs

Video 2 is about 7 minutes long

Activity Five Edit your document (or the solution given in Activity Three) to mark up the logical parts of the document – a completed version is available to check against. Watch out for the correct number of closing DIV tags where there are DIVs within DIVs – the trick is to have two closing DIVs at the end of the central column (closing the news area and the contentMain area), and two closing DIVs at the end of the column on the right (closing the badges part and the contentSub part).

Activity Six Watch the third part of the video on how to structure and add CSS files – and then what normalisation does

Video 3 is about 6 minutes long

Activity Seven Watch the final parts of the video which shows the steps required to style the site to recreate the original design markup used in the lecture Because this is the longest part of this process, this has been split into two parts

Styling the whole document – sorting out the column placement and overall styles (such as fonts) – about 7 minutes

Styling each individual sub area and tidying up – about 18 minutes

You should now be prepared for the Lab Exercise which asks you to style the page

Lab Exercise Styling the page – exercise sheet for Lab 5 and the Zip file containing HTML, CSS and images for lab 5

A solution for the complete site is available (i.e. the completed redesign shown in lecture and attempted in lab from the zip file)

One of the nicest books explaining the whole semantic xhtml and structured CSS approach is Transcending CSS by Andy Clarke

ITB coursework feedback and marks

The feedback sheets for the coursework are here:BB1753 ITB All

This is a very large PDF. To find your feedback, download the file and open it in adobe reader (PC) or preview (Mac) – you should then use the search function to find your student ID number (kxxxxxxxx).

This PDF has all the grades for the module in one grid – sorted by student ID number: BB1753 ITB 1213 trimmed

Note that these grades have to go through moderation and have not yet been scrutinized by an exam board. It is possible that there may be changes (although unlikely).

If there are any problems, then please come and see me to sort it out