SECTION B: DETAILS OF TEACHING, LEARNING AND ASSESSMENT Items in this section must be considered annually and amended as appropriate, in conjunction with the Module Review Process. Some parts of this page may be used in the KIS return and published on the extranet as a guide for prospective students. Further details for current students should be provided in module guidance notes. ACADEMIC YEAR: 2016-2017 NATIONAL COST CENTRE: 121 MODULE LEADER: Chris Jenkins OTHER MODULE STAFF: SUMMARY of MODULE CONTENT •Mathematical functions, if statements, lookups, pivot tables. •Applications and production of business graphs. •Spreadsheet macros, customising the user’s environment. •Linking spreadsheets. •Using a spreadsheet as a database manager. • Summary statistics – measures of location and variation, selection of appropriate measures. •Distributions – frequency distribution, histograms, ogives, discrete probability distributions and expected values. • Comparing distributions – including use of relative frequencies and boxplots. • Correlation SUMMARY OF TEACHING AND LEARNING [Use HESA KIS definitions] Scheduled Activities Hours Comments/Additional Information Lectures 12.5 . Demonstration 3 Practical Classes and Workshops 7 Guided Independent study 77.5 (NB: 1 credit = 10 hours or learning; 10 credits = Total 100 100 hours, etc) to Weighting Name Category Element Component Component Comments objectives include links learning E_ Written exam 100% T1 Total = 100% - 100% Coursework C1 Total = 100% Practical P_ Updated by: Date: Approved by: Date: Caroline Cripps 30/08/16 Tina Simpson 30/08/16 Recommended Texts and Sources: Anderson, D., Sweeney, D. and Willliams, T. (2007) Quantitative methods for business. Frye, C. (2010) Microsoft Excel 2010: plain and simple. Farnham: O’Reilly Media.
SECTION B: DETAILS OF TEACHING, LEARNING AND ASSESSMENT Items in this section must be considered annually and amended as appropriate, in conjunction with the Module Review Process. Some parts of this page may be used in the KIS return and published on the extranet as a guide for prospective students. Further details for current students should be provided in module guidance notes. ACADEMIC YEAR: 2016-2017 NATIONAL COST CENTRE: 121 MODULE LEADER: Chris Jenkins OTHER MODULE STAFF: SUMMARY of MODULE CONTENT •Mathematical functions, if statements, lookups, pivot tables. •Applications and production of business graphs. •Spreadsheet macros, customising the user’s environment. •Linking spreadsheets. •Using a spreadsheet as a database manager. • Summary statistics – measures of location and variation, selection of appropriate measures. •Distributions – frequency distribution, histograms, ogives, discrete probability distributions and expected values. • Comparing distributions – including use of relative frequencies and boxplots. • Correlation SUMMARY OF TEACHING AND LEARNING [Use HESA KIS definitions] Scheduled Activities Hours Comments/Additional Information Lectures 12.5 . Demonstration 3 Practical Classes and Workshops 7 Guided Independent study 77.5 Total 100 (NB: 1 credit = 10 hours or learning; 10 credits = 100 hours, etc) Category Element Component Name Component Weighting Comments include links to learning objectives Written exam E_ T1 100% Total = 100% Coursework C1 - 100% Total = 100% Practical P_ Updated by: Caroline Cripps Date: 30/08/16 Approved by: Tina Simpson Date: 30/08/16 Recommended Texts and Sources: Anderson, D., Sweeney, D. and Willliams, T. (2007) Quantitative methods for business. Frye, C. (2010) Microsoft Excel 2010: plain and simple. Farnham: O’Reilly Media.
FdSc-Computing-Networking-Software-Development-Handbook-2017-2018.docx