The contribution of marks from prior levels of study to the progression award is governed by University regulations. PS10. Admissions Criteria Qualification(s) Required for Entry to this Programme: Details: Level 2: Key Skills requirement / Higher Level Diploma: Maths, English and/or GCSEs required at Grade C or above: 5 GCSE’s including Maths and English An ICT or Science based subject is desirable Level 3: at least one of the following: AS/A Levels To include at least one of the following: ICT, Computing or Science based subject Advanced Level Diploma: Pass in related subject BTEC National Certificate/Diploma: 160 points in ICT, Computing or Science based subject VDA: AGNVQ, AVCE, AVS: 160 points in ICT, Computing or Science based subject Access to HE or Year 0 provision: Pass in ICT, Computing, Business, Engineering or Science based subject International Baccalaureate: Cases taken on an individual basis but normally awards of 24 points or more required. Irish / Scottish Highers / Advanced Highers: Normally level D Work Experience: Mature students with relevant work experience offers made on interview only Other HE qualifications / non-standard awards or experiences: Mature students with relevant work experience offers made on interview only APEL / APCL possibilities: Please refer to University of Plymouth Academic Regulations () Interview / Portfolio requirements: All students are interviewed. Mature students would have to demonstrate at interview the necessary motivation, potential, experience and/or knowledge. Independent Safeguarding Agency (ISA) / Disclosure and Barring Service (DBS) clearance required: No
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.