Module handbook BIAHandbook1516
Book containing materials used in this course biaMaths
Week 1
Slides for Week 1 session 1 Intro to BIA – handout
Sample spreadsheet for exercises week1TestData
An introductory exercise on Excel Intro to excel – session 01
If you know Excel very well, then try the Google Spreadsheet exercise Intro to google spreads 1314
Week 2
Slides for Week 2 session 1 Intro to Statistics and Statistics
Data spreadsheet datavalues
Slides for Week 2 session 2 Statistics 2
Further reading on this material is in the biaMaths book above, from page 36 onwards.
Week 3
Slides for session 1 on variance and SD Variance and SD 1
Slides for session 2 with test details and calculating variance from a distribution table Variance and SD 2
Spreadsheet in class Example from slides – cover A
Example test from last year: 15test1
Week 4
Excel exercise on frequency distribution: ExcelStatisticsExercise
Sample spreadsheet for the exercise: ExampleData
Slides for session 1 – recap and exercises Week 4 session 1
Session 2 is the test
Week 5
Slides for session 1 – more measures Statistics
Spreadsheet Sample data
Material for session 2
Session 1 – Using Excel – tabs, creating nice designs, formulas across tabs, drop down boxes and protecting cells
Degree calculator and Degree calculator blank
Grade calculator exercise Model building – grade calc
Week 6
Session 1 – Model-building-session-2
Session 2 – Data management – session 3 2010
Week 7
Session 1 – Charts – session 4 2010
Session 2 – multiple choice test
This is a 55 minute test, containing 20 questions. These are multiple choice questions (worth 1 mark each). In the test, you will be presented with a spreadsheet that you have to manipulate to find the correct answer from the choices available.
There are practice questions for the test ExcelExs using this spreadsheet films
Here are some more practice questions: More Q
Week 8
Introduction to sets – slides – intro to sets
Introduction to the relational model – slides – sets and relational databases
Database used in examples session1 2010.accdb
Week 9
Lab exercises – sqlsession1 2010
Slides 2 – sets and relational databases 2
Selection in relational databases – slides – database-2-2007-handouts-3-slides
Lab exercises – sqlsession2
Student responses: BIA1516Responses
Week 10
Remember: there are ONLY classes on Monday this week
Student responses: adjusted Spreadsheet and database BIA1516ResponsesAdj
Here are some sample questions: Exercises student data
SETs and databases – Lab on sets and SQL
Week 11
Test on sets and databases
Week 12 (Teaching Period 2)
Cartesain Product, Sets and databases Sets and Cartesian Product
Subsets, Powerset, Nulls and Writing RA and SQL for dummies Sets and CP 2
CP exercises CP in SQL exercises
Author sample database (unzip the file to use) AuthorsDB.accdb
Sample questions on author database questions1
Week 13
Relations and functions slides: relations and functions
Handout on Relations and functions: Sets
More on functions, grouping and subqueries: functions recap and groups
Exercises and notes on SQL functions and grouping: SQL functions
Optional – outer joins
Other types of Joins Other types of Join
Author sample database (unzip the file to use) AuthorsDB.accdb
Sample outer join questions on author database questions2
Week 14
DDL and DML: DDL DML
Handout on DDL/DML: CreatingTables
Problems with the relational model: Problems with RelMod
An example analysis: An Example Analysis
Slides with introduction to WWW, Web servers and HTML lecture 1 handout
Lab Exercise 1 Lab 1
poormarkup zip file (you will have to extract the contents of this zip file): poormarkup.html
Some background reading about HTML5
Week 15
Second session is the test
Lecture Materials: lecture 2 handout
Good resource with explanations about using images
Lab Materials: Lab 2
Word document 1: campus
Word document 2: about
The compressed zip file wordHTML is available for the third activity
Images – use a right mouse click to download these
Week 16
Session one
Introduction to logic Logic
Notes on Logic LogicAppSoftware
Session two
Code for demo in class: CSSinclass
css cribsheet from Phil Molyneux
This page contains the neatest summary of xhtml elements and their semantic use (there are tags here which we have not used )
Week 17
CSS lab: lab3
The compressed zip file CSSinclass is available for the lab activity
Week 18
More on Logic Logic 2
Notes on CSS: CSS 2 notes
Code for lecture: example-code
Copy and paste this into https://jsfiddle.net/
CSS exercises Lab 4
lab4 files for lab exercise
Solutions for the CSS exercises are available
Week 19
Introduction to Probability slides Probability
Probability – OR slides Probability 2
Probability 3 – Probability 3 Handout
Lecture slides lecture 4
Example for lecture codeforlecture
Week 20
Probability 4 – Probability 4 Handout
TCP/IP slides TCP
DNS slides DNS handouts
HTTP slides HTTP clients and servers
CSS and XHTML site redesign project here
Week 21
Revision Pack (see top of page)