Information Technology Institute
This module covers the methods and instruments for creating effective visualisations based mostly on rules from graphic design, perceptual psychology and cognitive science. Students will learn how to course of large volumes of knowledge to create interactive visualisations for ease of exploration. Topics which are coated include visualising patterns, proportions, relationships, spatial and temporal components, and multi-dimensional visualisations. The spreadsheet is an indispensable device for professionals, especially in the banking and finance business, to unravel business problems and make better informed choices.
Students will be outfitted with the technical know-the way to formulate statistical fashions, and make informed choices by evaluating the statistical fashions using software program instruments. Topics lined embrace frequency distribution, chance distribution, quantitative modelling, correlation analysis and linear regression analysis.
This module will introduce college students to the usage of spreadsheets as a reporting and modelling device. Through hands-on practical sessions in class using a industrial spreadsheet system similar to Microsoft Excel, students will discover numerous spreadsheet capabilities and simple macros used for analysing, formatting and presenting knowledge. Suitable sorting and search algorithms and the use of Application Protocol Interface (API) shall be launched when required. Other key matters embody the introduction of system …
