This PDF file has the results for the first HTML test (10%) and the second multiple choice test (20%). Grades for the coursework will follow in a week or so. BB1753 ITB.pdf
Here are the feedback sheets for the major piece of coursework on ITB. To find yours, download the PDF and search for your K number (it can be lower or upper case k) BB1753 ITB ALL
This grid shows all the marks in one column (again – by k number only) BB1753 ITB Marks 1112
Please note that grades have not been moderated or passed through an exam board yet, so it is possible that they may change (this is unusual but can happen).
If you see any glaring issues then please email me
Database notes (lecture and lab material) here
Spreadsheet material here
Note on the Second ITB test are here
HTTP clients and servers lecture slides
Database materials on Cartesian Product
Spreadsheet materials on importing different types of data, grouping and subgroups
This article is about the early (pre netscape) browsers that became available and promoted the WWW.
Materials on Databases, including lecture notes and lab exercise on selection
Spreadsheet materials on building larger spreadsheet models, and more complex formulas / functionality
ITB switches to material about spreadsheets and databases from week 6, along with lectures about Internet standards.
Database materials for this week include the lecture slides and the lab exercises
Spreadsheet materials for this week include the lecture slides and the lab exercise
Spreadsheet session 2 is on building a more complex model, and more advanced spreadsheet skills, such as using multiple tabs in your formulas, lookups and relative / absolute addressing
Model building – session 2
Spreadsheet session 1 is on basic spreadsheet skills using Excel
Intro to excel – session 1 2010
If you are using an older version of Excel, the same exercise is available (with different screen shots)
Intro to excel – session 1 2007
The spreadsheet exercise is on representing information in charts: Charts – session 4 2010 (Office 2010)
An older version for Office 2007 is available: Charts – session 4
This exercise requires the Excel file WHSMITH.XLS
Note that is an XLS (Excel 2007) file. You may need to use File – Save As – Excel workbook to save this as the latest file format (with the file extension xlxs).
The following files are required for session 3 – Data management – session 3 2010
insgrp.txt (use a right mouse click and save-as to get this to download)
HTML table (click on this link to see the table)
Completed cars.xls file
A version of the materials using Office 2007 is available – Data management – session 3