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