Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Lecture

Practical

Tutorial

Module Offerings

4502AMPCC-SEP-PAR

Aims

To provide an audio production student with a rudimentary knowledge of fundamental maths, statistics and data analysis, using spreadsheet formulae and graphs, integrated within a technical report.

Learning Outcomes

1.
Perform fundamental mathematical and statistical analysis of data using spreadsheets
2.
Graphically present technical data in an appropriate manner and integrate into other presentation forms and reports

Module Content

Outline Syllabus:Spreadsheet usage; cell types, absolute and relative referencing BIDMAS and use of formulae Multi-sheet referencing Data cleansing and table organisation (pivot tables) Graphs; types, uses and presentation Basic algebra and equation manipulation Ratio, proportion, rates of change Binary and hexadecimal conversion and simple digitization Statistical methods, Mean, Mode Median and range, confidence, correlation, regression and Anova Technical report layout and writing Graphical and tabular data presentation and integration within reports. Discussion of data within technical reports. Macros and inserting sound files into spreadsheets Basic electronics laboratory skills
Additional Information:This level 4 module is an essential integrating element of the first year of study. It provides students with relevant mathematical and technical skills to support all aspects of their university studies

Assessments

Essay