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)