Excel to Python for Data Science

The micro-credential will help students familiar with handling data in Excel to prepare data and do basic analysis in Python. Students will get practice on cleaning and ordering large data sets and will use Python to explore data structures, understand how to read common data formats and discuss the use of different data. Learning Outcomes • Understand the reasons to use Python instead of Excel. • Be able to program in Python. • Be able to load, manipulate, and visualise data using Pandas and Numpy. • Be able to automate data analysis with Python and Jupyter Notebooks. Key Topics • Transition to Python • Data Loading • Data Wrangling • Data Visualisation • Data Manipulation • Abstraction Activities • Self-directed learning • Case studies, group work and in class exercises • 6 quizzes - 1 per topic • A major work that consolidates all learning. Three submissions over the duration of the micro credential • Written reflection on the application of the knowledge gained in the micro credential to the learner’s role in the organisation - assessed Volume of Learning 75 hours Credit Points 5 AQF Level 8