Topic outline

  • WELCOME MESSAGE

    Welcome to Introduction to Computer Science Level II (CS2) - Data Analytics 

    My name is Professor Francisca Oladipo and I am the Course Lead of this Course

    This Course is for .................................

    Kindly watch this video for other details about this course 

  • STUDY UNIT 1 - INTRODUCTION TO PROGRAMMING IN PYTHON

    Programming is a way of instructing the computer to perform various tasks. These instructions are written in a language that the computer understands. Just like Ethiopians can understand Amharic, Somalia understand Somali, Kenyans and Ugandans understand Swahili, so is the case with computers. Computers understand instructions that are written in a specific syntax called a programming language.


  • STUDY UNIT 2 - STRING MANIPULATION AND DATA STRUCTURE IN PYTHON

    Apart from different data type such as integer, float, string and Boolean, Python also has data structure which include list, tuple, set, and dictionary. Data structures are a collection of data elements that are structured in some manner and are the core of Python programming language.

    In this study unit, you will learn string manipulation and data structure in Python

  • STUDY UNIT 3 -FLOW CONTROL, LOOPS AND FUNCTIONS IN PYTHON

    In the eyes of most philosophers of programming, the one thing that separates programming from the early days’ automation - such as the Jaquard loom - is its ability to make decisions as to what to do next. In the programming world, that is known as flow control - control of the "flow" of executed code.

    In this study unit, you will learn conditions (branching) statements in python. Conditions (branching) are known as control structures and they determine whether a block of code will run or not. You will also learn Python loops, functions and how to import different packages in Python

    • CS2 Study Unit 3 ebook - Flow Control, Loops and Functions in Python File 1.2MB PDF document

      Click on the link to access the ebook.readable module on Study Unit 3 - Flow Control, Loops and Functions in Python

      Upon completion of this study unit, you should be able to:   

      3.1   Employ control statement to make decisions in Python

      3.2   Create functions to solve problems with Python

      3.3   Import different packages in Python to do some tasks

  • STUDY UNIT 4 - INTRODUCTION TO DATA AND DATA SCIENCE

    Data is present everywhere and is collected every day. We make calls and send messages on the phone every minute. We tweet and retweet messages on Twitter, post pictures and videos on Instagram, countries like Kenya, Somalia, South Sudan, Uganda, and Ethiopia count their citizens and foreigners at a well-defined point of time. Hospitals take clinical records of patients, and teachers count the number of students present in school every day. With these available huge amounts of data, organizations focus more and more on using the insights from data to evaluate progress, build solutions and make an informed decision. The need to extract useful insight is a must for a business in today’s world.


  • STUDY UNIT 5: INTRODUCTION TO NUMPY ARRAY

    NumPy is a Python package/library that stands for ‘Numerical Python’. It is the core library for scientific computing, which contains a powerful n-dimensional array object. It is also a linear algebra for python and almost all of the libraries in the Python ecosystem rely on it as one of their main building blocks.


    • Study Unit 5: Introduction to NumPy array Lecture Note File

      Click on the link to access the ebook/readable module of Introduction to NumPy Array

      Learning Outcomes of Study Unit 5       

      Upon completion of this study unit, you should be able to:   

      5.1   Create one dimensional NumPy Arrays from Python list, access values stored within them and do some mathematical operations

      5.2   Create n-dimensional Arrays and carry out different mathematical operations on them

      5.3   Work  with NumPy Array use cases
    • 5.1: Introduction to Numpy array Lesson

      This Lesson introduces how to create one dimensional NumPy Arrays from Python list, access values stored within them and do some mathematical operations.

      After you have read section 5.1 in the book, kindly watch this video for a summary of NumPy Array

    • 5.2: how to create n-dimensional Arrays and carry out different mathematical operations on them. Lesson

      This Lesson introduces how to create n-dimensional Arrays and carry out different mathematical operations on them.

      After you have read section 5.2 in the book, kindly watch this video for a summary of how to create n-dimensional Arrays and carry out different mathematical operations on them.

    • 5.3: Working with NumPy Array Lesson

      This Lesson introduces how to Work with NumPy Array use cases

      After you have read section 5.3 in the book, kindly watch this video for a summary of how to Work with NumPy Array use cases

    • Introduction to Numpy array Quiz

      INSTRUCTIONS

      This Quiz covers a certain portion of the final grade. 

      Learners are advised to attempt this quiz before the deadline (_ _/ _ _/ 2021)


  • STUDY UNIT 6: INTRODUCTION TO DATA ANALYSIS WITH PANDAS

    Pandas is a popular Python package for data science. It offers powerful, expressive, and flexible data structures that make data cleaning and analysis fast and easy in Python. Pandas is an open source data analysis and manipulation tool that is often used in tandem with numerical computing tools like NumPy and SciPy, analytical libraries like statsmodels and scikit-learn, and data visualization libraries like matplotlib and Seaborn. You can think of Pandas as an extremely powerful version of spreadsheet like Microsoft Excel, with a lot more features.      


    • Study Unit 6: Introduction to Data analysis with pandas Lecture Note File

      Click on the link to access the ebook/readable module of Introduction to Data analysis with pandas

      Learning Outcomes of Study Unit 6

      Upon completion of this study unit, you should be able to:   

      6.1   Work with Pandas Package to create series, Data frame and get information about your data

      6.2   Manipulate Data Frames with Pandas

      6.3   Load data in any file and export them

      6.4   Clean and preprocess your data

      6.5   Carry out exploratory data analysis with Pandas Profiling

      6.6   Aggregate and do group operation with your data   

      6.7   Join, Combine and reshape data frame with Pandas


    • 6.1: Introduction to Data analysis with pandas Lesson

      This Lesson introduces how to Work with Pandas Package to create series, Data frame and get information about your data

      After you have read section 6.1 in the book, kindly watch this video for a summary of how to Work with Pandas Package to create series, Data frame and get information about your data

    • 6.2: Manipulating Data Frames with Pandas Lesson

      This Lesson introduces how to Manipulate Data Frames with Pandas

      After you have read section 6.2 in the book, kindly watch this video for a summary of how to Manipulate Data Frames with Pandas


    • 6.3: Loading data in any file and exporting them Lesson

      This Lesson introduces how to Load data in any file and export them

      After you have read section 6.3 in the book, kindly watch this video for a summary of how to Load data in any file and export them

    • 6.4: Cleaning and preprocessing your data Lesson

      This Lesson introduces how to Clean and preprocess your data

      After you have read section 6.4 in the book, kindly watch this video for a summary of how to clean and preprocess your data

    • 6.5: Carry out exploratory data analysis with Pandas Profiling Lesson

      This Lesson introduces how to Carry out exploratory data analysis with Pandas Profiling

      After you have read section 6.5 in the book, kindly watch this video for a summary of how to Carry out exploratory data analysis with Pandas Profiling

    • 6.6: Aggregate and do group operation with your data Lesson

      This Lesson introduces how to Aggregate and do group operation with your data   

      After you have read section 6.6 in the book, kindly watch this video for a summary of how to Aggregate and do group operation with your data   


    • 6.7: Join, Combine and reshape data frame with Pandas Lesson

      This Lesson introduces how to Join, Combine and reshape data frame with Pandas 

      After you have read section 6.7 in the book, kindly watch this video for a summary of how to Join, Combine and reshape data frame with Pandas

    • Introduction to Data Analysis with Pandas Quiz

      INSTRUCTIONS
      This Quiz covers a certain portion of the final grade. 
      Learners are advised to attempt this quiz before the deadline (_ _/ _ _/ 2021)




  • STUDY UNIT 7: INTRODUCTION TO DATA VISUALIZATION

    Data visualization refers to the graphical representation of data by visual elements such as charts, infographics, and maps to understand the data. There is a story behind every data, and data visualization brings them to life. It enables decision-makers, stakeholders or your readers to see data analytics presented visually, so they can grasp difficult concepts or identify new patterns.

    • Study Unit 7: Introduction to Data Visualization Lecture Note File

      Click on the link to access the ebook/readable module of Introduction to Data Visualization

      Upon completion of this study unit, you should be able to:   

      7.1   Work with the concept of storytelling through data visualization                                          

      7.2   Visualize data with and Seaborn and Matplotlib package


    • 7.1: Work with the concept of storytelling through data visualization Lesson

      This Lesson introduces how to Work with the concept of storytelling through data visualization                                          

      After you have read section 7.1 in the book, kindly watch this video for a summary of how to Work with the concept of storytelling through data visualization                                          


    • 7.2: Visualize data with and Seaborn and Matplotlib package Lesson

      This Lesson introduces how to Visualize data with and Seaborn and Matplotlib package

      After you have read section 7.2 in the book, kindly watch this video for a summary of how to Visualize data with and Seaborn and Matplotlib package

    • Introduction to Data Visualization Quiz

      INSTRUCTIONS

      This Quiz covers a certain portion of the final grade. 

      Learners are advised to attempt this quiz before the deadline (_ _/ _ _/ 2021)

  • STUDY UNIT 8: INTRODUCTION TO BUSINESS INTELLIGENCE

    In the past few decades, there has been a monumental transition in the creation, collection, and use of data. While great strides have been made in data management, the desire to extract business value hidden within the piles (or rather ‘‘mountains’’) of these data is the new trend. bits and bytes that today are not only stored within structured data systems. The Systemic processes involved in getting business insights from data is referred to as Business Intelligence.

    This study unit will introduce you to Business Intelligence concepts and its importance. This unit is aimed to equip you (learners) with skills on how to mine data from a relational database, how to extract valuable information and create meaningful dashboards that can be used by business owners to make day to day decisions. In addition, you will get to know some of the Open-Source Business Intelligence software, how to quickly set them up and how to use them

    • CS2 Study Unit 8 ebook - Introduction to Business Intelligence File 9.3MB PDF document

      Click on the link to access the ebook/readable module of Introduction to Business Intelligence

      Upon completion of this study unit, you should be able to:

      8.1          Describe Business Intelligence, its technologies, benefits, platforms and tools

      8.2          Explain the basic principles of DBMS, Data modelling using E-R and Crow’s feet notation

      8.3          Describe the concept SQL statements and build syntax

      8.4          Explain Data mining concept and its different analytic models

      8.5          Describe visualization, dashboards and chart methods

      8.6          Use and Implement Power BI


    • Study Unit 8 Lesson 1 - Overview of Business Intelligence

      This Lesson covers the definition of Business Intelligence, its benefits, plat forms, tools etc. 

      Read Section 8.1 in the ebook and watch these videos

  • Study Session 9: Introduction to Digital Marketing

    This Study Unit explores the concepts of digital marketing, how digital marketing has revolutionized the way individuals, businesses and organizations operate their businesses on digital platform. The students should be able to explain how SEO works, apply SEO strategies, and run digital campaigns with Google Ads.

  • STUDY UNIT 10: INTRODUCTION TO CONTENT MARKETING AND EMAIL MARKETING

    This week, we are going to explore the concepts of content marketing, and how business organizations, individuals and brands can leverage its power to remain visible on the WWW. The learners should be able to develop a working content marketing strategy and create winning email marketing campaigns.

  • STUDY UNIT 11: INTRODUCTION TO SOCIAL MEDIA MARKETING AND WEB ANALYTICS

    In study Unit (10), we will take a dive into the world of Social Media Marketing (SMM) focusing on its importance to digital marketing. Everyday billions of users worldwide throng the popular social media platform for entertainment, education, networking, business, and to connect with each other. SMM will teach learners how to reach people where they are on Social Media Platforms. Lastly, we will explore how to use analytics to measure the performance of your digital marketing campaigns.

    • CS2 Study Unit 11 ebook or Readable Module - Introduction to Social Media Marketing and Web Analytics File

      Click on this link to access the ebook or readable module on Study Unit 11:  Social Media Marketing and Web Analytics

      Upon completion of this study unit, you should be able to:    

      1.1 State the importance of Social Media Marketing and identify various social media platforms.

      1.2 Demonstrate how to set up Social Media accounts.

      1.3 Develop competence in creating Social Media Campaigns with Facebook and Instagram Advertising Tools.

      1.4 Understand various web analytics terminologies.



    • Study Unit 11 lesson 1- An Overview of Social Media Marketing

      In this Lesson, the subtopics covered the definition of social media marketing, purpose, and benefit of using social media marketing. 

      After you have read lesson 1 in the Study Unit 11 ebook/readable module, watch this video for the summary of overview of social media marketing 

       
    • Study Unit 11 Lesson 2- Social Media Accounts Setup

      In this Lesson, the subtopics covered the aspect of Social Media Accounts Setup with emphasis on how to create Facebook account, Instagram, LinkedIn, Pinterest, Snapchat, and Whatsapp.

      After you have read lesson 2 in the Study Unit 11 ebook/readable module, watch this video for the summary of Social Media Accounts Setup.
    • Study Unit 11 Lesson 3-Competence in Creating Social Media Campaigns with Facebook and Instagram Advertising Tools

      In this Lesson, the subtopics covered the aspect of competence in creating social media campaigns with Facebook and Instagram advertising tools.

      After you have read lesson 3 in the Study Unit 11 ebook/readable module, watch this video for the summary of the study section 11.3.

    • Study Unit 11 Lesson 4- Overview of Web Analytics

      In this Lesson, the subtopics covered Web Analytics Work, how to insert google tracking code on a  website,  tracking code on a WordPress site, google search  console, analytics terminologies, and web analytics tools and platforms

      After you have read lesson 4 in the Study Unit 11 ebook/readable module, watch this video for the summary of the  Overview of Web Analytics.