A continuation of the skills learned in stage one of the Programme with emphasis on Advanced
features of Excel.
It will also introduce the student to the Linux environment with a look at Shell scripting and use of
Python through Linux
Linux Environment:
Introduction to the Linux directory structure
Use of basic commands in Linux such as ls, cd, pwd, mv
Introduction to a Linux editor such as gedit or nano
Write basic shell scripts
Using Python within a Linux environment
Excel Advanced:
Pivot tables
Pivot reporting
MOD function
Advanced formulae such as SumIf, Count, vLookup
Use of statistical functions
Other advanced functions e.g. pattern matching, index and match
LaTex :
Revisit Latex and use it to write up a project
The material will all be laboratory based with plenty of practice in each discipline.
Module Content & Assessment | |
---|---|
Assessment Breakdown | % |
Other Assessment(s) | 100 |