| Required textbook: A Guide to Microsoft Excel for Scientists and Engineers by Bernard V Liengme published by Arnold ISBN: 0 470 23775 9 This book is compulsory - you must get it before the 11th of February |
Another useful book which is in the library but not
required: Guide to Mathematical Modelling by Edwards and Hamson |
Continuous assessment consists of short automated tests
at the start of every practical and a short written test mid-way through the
course. Attendance and Continuous Assessment |
| Bernard V Liengme's web site. | You can find lecture notes on QBasic and Mathematical Modelling at this web page. | Past papers now available through the exam advice page |
| If you missed any handouts, you can get access to the slides by following the links in the schedule below. | If you haven't used Microsoft Excel before, here are 3 practicals you can do: Practical No. 1, Practical No.2, and Practical No. 3 | Click here to access any available multiple choice tests.When asked, select "Run from its current location" and then select "OK". When asked for your name enter your surname immediately followed by your first initial. |
This timetable is incomplete and subject to change.
| Main Student Resources Index | ||||
| Week No | Starting Monday | Practical (Monday 5.00pm E0028) |
Lecture 1 (Thursday 9.00am - GEW1) |
Lecture 2 (Thursday 10 am) |
| 1 | 21/1/02 | .QBASIC Exercises and
assignments 1, 2 and 3 QBASIC 4,5 and 6 QBASIC 7, 8 and 9 |
Qbasic programming: introduction, doing calculations | |
| 2 | 28/1/02 | QBASIC 10, 11 and 12
QBASIC 13 and 14 |
Purpose and overview of the
course. Introduction to Mathematical Modelling |
QBasic programming: simple selection, repetition. Subroutines |
| 3 | 4/2/02 | QBASIC 15 and 16
QBASIC 17, 18, 19 |
Modelling Skills | QBasic programming: arrays, global variables, functions. |
| 4 | 11/2/02 | QBASIC 20,21, 22 QBASIC exercises and assignments: 23and 24 | Modelling Skills (cont.) | The Modelling Process |
| 5 | 18/2/02 | QBASIC exercises and assignments: 25,26,27,28 You'll have to do this in your own time: Crash course introduction to Excel: Excel -1, Excel - 2Excel 3 |
The Modelling Process (cont.) | Excel Chapters 1,2,3 |
| 6 | 25/2/02 | Excel Chapter 1,2,3 Do Chapter 2 exercises: 9,10,11 |
Apologies Read: Excel Chapters 4,5,6 | |
| 7 | 4/3/02 | Excel Assignments Chapter
4,5,6 Chapter 5: Exercise 2: Save as Chap5-2.xls: Exercise 4 (a only) Chapter 6: Exercise 5: Save as Chap6-5.xls |
Classifying Models Excel 7 Excel: Curve Fitting | |
| 8 | 11/3/02 | Chapter 7: Curve Fitting Problems at end of chapter: 1 and 5. |
Classifying Models, Units User defined Functions and Visual Basic programming | |
| 9 | 18/3/02 | Mid-term assessments | ||
| Easter Break | ||||
| 10 | 8/3/02 | Chapter 8: User Defined Functions | Differential Equations: The Euler method | The Euler method: QBasic |
| 11 | 15/4/02 | The Euler method: QBasic | Relationships Between Variables | The Euler Method: Excel |
| 12 | 22/4/02 | Chapter 12: The Euler Method: Excel | The Euler Method: Higher order equations | Chapter 12: Differential Equations (Runge Kutte) |
| 13 | 29/4/02 | Chapter 12: Differential Equations (Runge Kutte) | Data and Regression | |
| 14 | 6/5/02 | Regression in Excel | ||
| 15 | 13/5/02 | |||
| Exam: Advice | ||||