Archive for the ‘BIS’ Category

BITS week 8 and 9

November 18th, 2013 No comments

Lecture slides on Cartesian Product and Join – database 3 2011 handouts

Lab exercise on CP and Join – SQL Session 3


More advanced Joins –database 3 join extra 2007 3 slides handouts

Lab exercises on more advanced Joins –SQL SESSION OUTER


Lecture slides on writing queries for dummies – database 4 2007 handouts

Lab exercises on DDL/DML – SQL Session 4

Categories: BIS, BIT, Databases Tags:

BBM007 feedback and grades

June 10th, 2013 No comments

The feedback sheets for the portfolio are here: BIS Portfolio Mark sheets 1213 without names

This is a 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 BBM007 Marksheet 1213

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 / email me to sort it out


Categories: BIS Tags:

BBM007 Business Internet Systems Assessment

April 24th, 2012 No comments

The assessment for this module is by two components:-

  • 35% of the grade comes from two tests taken in teaching period 1
  • 30% comes from the collection of your exercises in teaching period 2
  • 35% of the grade comes from group work, analysing, designing and prototyping a database implementation

About the group work

The specification for the group work is Assignment 1415, with more detail on the (broad) assessment categories in this diagram marking scale

Please note the instructions in the assignment about submission – each group will submit ONE word document with everything in it. This will be done electronically (only – no print version is required). The document should follow the guidelines specified here.

About the portfolio work

You should hand in a single word document containing code and screen shots for the exercises and activities set in teaching period 2.

Both the portfolio of work and the project work should be completed by Thursday April 2nd @ 9:00AM. There will be two different drop boxes, one for the group work and one for the individual portfolio work.


Categories: BIS Tags:


February 23rd, 2012 No comments

This material covers the basics of CSS – the use of appropriate selectors , ids and classed etc.

Lecture slides on CSS: CSS lecture handouts

Lab exercises: CSS lab exercises

The following resources are used in the CSS exercises

Categories: BIS Tags: ,


February 23rd, 2012 No comments

This material covers the basics of semantic XHTML – the use of appropriate elements (tags) such as head, body, title, h1..h6, p, img, table, ul etc.

Lecture slides on HTML: HTML handout

Lab exercises: HTML Lab

The following resource are used in the HTML exercises




Use a right mouse click (and select save image as) and place these images in the same folder as your other files.

Categories: BIS Tags:

Relational Databases – mySQL and projection

January 30th, 2012 No comments

The lecture slides used for the first session on databases relational database handout slides

SQL file required to set up the EMP database in mySQL empDB

SQL notes on using mySQL and the projection statement SQL Session 1

Notes on setting up your own version of MAMP (mac) Installing and using MAMP

Notes on setting up your own version of XAMPP (Windows 7) Installing and using XAMPP

Categories: BIS, BIT Tags: ,

BBM007 exam revision pack

May 5th, 2011 No comments

Details about the BBM007 exam are in the MBIT Revision 1011 PDF

It contains all relevant exam questions and has other hints and tips

Categories: BIS Tags:

Web Application Develeopment – php and mysql

March 31st, 2011 No comments

Connecting PHP to mysql and processing results

Lab files

Lecture Slides (PDF)

Categories: BIS Tags:

Web Application Development – forms and more

March 31st, 2011 No comments

Web Application Development – forms, GET and POST, introduction to control structure

Slides (PDF)

Categories: BIS Tags:

BBM 007 Assessment

February 21st, 2011 No comments

Full details of the assessment can be seen in Assignment (PDF)

Hints and tips about structuring the report can be seen in this post/document

This work should be done in pairs and submitted as a single word document, with all code, diagrams and data examples included in the document.

The hand-in date/time is 2nd May 2011 at 6:00pm. Electronic submission (only) is required – either through the digital drop box  or using the email address

You submit one document per group. If you submit by email I will email you back so you know its arrived (probably the next day in the morning).

Categories: BIS, Databases Tags: