Module Additional Assessment Details
1. 1 hour 15 min. multiple-choice test weighted at 50% (LO's 1, 2, 4)
2. 1 hour 15 min practical test using Excel & SPSS weighted at 50%. (LO's 2, 3 and 4)
Module Indicative Content
Students will meet mathematics and statistics that will support core studies in computing and will include an introduction to a statistical package, SPSS. Statistics topics covered will include graphical representation of data, averages and measures of dispersion, simple probability and the Normal distribution. The mathematical content will include applied algebra, numeracy and number systems.
An introduction to spreadsheets including formatting, absolute and relative addresses, built-in spreadsheet functions and graphs.
Appropriate integration of the Mathematical content with Excel will also be covered.
Module Learning Strategies
The delivery mode will be 1 hour lecture and 1 hour tutorial all semester for the mathematics and statistics, 2 hours of Excel practical every other week.
Module Resources
Statistical Software SPSS
Excel
Module Special Admissions Requirements
None.
Module Texts
For background reading only:
The basic practice of statistics, D.S. Moore (Freeman 1999), 0716736276
Improve your maths, G. Bancroft & M. Fletcher (Addison-Wesley 1998), 0201331306
Mathematics for Computing, Robert Callan (Letts Educational 1998), 1858053757
SPSS Analysis without anguish, S.J. Coakes & L.G. Steed (Wiley 2003), 0470802774
Excel 2003 in easy steps, Stephen Copestake (Computer Step 2003), 1840782668