Certificate and Executive Programs

Certificate Program: Python in Practice

NOV 07 - Dec 15, 2022

Online

DATE

NOV 07 - DEC 15

2022

TIME

1:00 PM - 3:00 PM

WHO CAN ATTEND

All

PD HOURS

35 Hours

ETHICS HOURS

0 Hours

STATUS

Registration closed on

Oct 31, 2022

EVENT DESCRIPTION

This certificate program is an emerging technology and outcomes driven course, offered by CPA Ontario and powered by Lighthouse Labs, Canada’s Leading Digital Bootcamp Institution.

 VIEW/DOWNLOAD THE BROCHURE

This six-week certificate program will enable you to analyze and visualize data using a popular programming language used by analysts and data scientists.

Learn how to apply high-level analytical thinking to solve data analysis problems using Python. You will work with tools like Jupyter Notebooks and Pandas and analyze real-world datasets to identify patterns and relationships. By the end of this course, you will be able to work effectively with data to drive business strategies and create value for your organization.

This course will provide participants with the opportunity to:

  • Apply high-level analytical thinking to data analysis problems;
  • Gain skills to use and navigate tools, libraries, and environments for data analysis using Python;
  • Develop workflows for data analysis and wrangling tasks using basic Pandas functions and SQL;
  • Develop and apply basic data wrangling techniques and methodologies with various data types and sources to solve accounting and finance problems.
Program Details:

This program takes place on the Lighthouse Labs learning platform and is made up of synchronous and asynchronous components.

  • 2 sessions per week
  • 1 hour of live instructor led learning per session (dates & times outlined below in chart, live sessions will be recorded)
  • On average you should allocated 2-3 hours of asynchronous time per session to complete program work
  • Office hours available

Optional Office hours:

Monday: 2:00 - 3:00 PM EST (after the lecture)

Tuesday: 6:00-7:00 PM EST (Bookable - 1:1 time slots)

Wednesday: 6:00-7:00 PM EST (Bookable - 1:1 time slots)

Thursday: 2:00 - 3:00 PM EST (after the lecture)

Note – office hours are not mandatory

Program Schedule

WeeksTopicsAssessment
Week 1

Data Science Environment Setup

Live Instructor Led Session: Monday, November 7, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Databases and SQL Basics

Live Instructor Led Session: Thursday, November 10, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz
Week 2

Python Fundamentals

Live Instructor Led Session: Monday, November 14, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz
Python Programming

Live Instructor Led Session: Thursday, November 17, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Python Programming Challenge: Poker Hand
Week 3

Python and Pandas

Live Instructor Led Session: Monday, November 21, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz

Programming Test I
Advanced Pandas

Live Instructor Led Session: Thursday, November 24, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz
Week 4

Python and SQL

Live Instructor Led Session: Monday, November 28, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz
Advanced Python

Live Instructor Led Session: Thursday, December 1, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Quiz
Week 5

Advanced Python II

Live Instructor Led Session: Monday, December 5, 1:00-2:00 PM EST (1 hour)

Asynchronous Work: approximately 2-3 hours
Programming Test II
Python Challenge Part I

Thursday December 8

Asynchronous Work: 4 hours

NOTE: There is no instructor-led (synchronous) training for this session, and four hours of independent (asynchronous) work.
Final Project
Week 6

Python Challenge Part II

Monday, December 12

Asynchronous Work: 4 hours

NOTE: There is no instructor-led (synchronous) training for this session, and four hours of independent (asynchronous) work.
Final Project
Demo Day

Thursday December 15, 1:00 - 3:00 PM EST

Showcase your new skills and demonstrate just how far you have come in your learning journey. This is a celebration of you!

NOTE: Your participation in demo day is strongly recommended but not mandatory. It is our hope that you will take this time to connect with your peers and share your project.
Presentation
Assessments:

This course includes short quizzes consisting of multiple-choice questions and programming challenges throughout the course to assess knowledge and skill development.

A final Python challenge (capstone project) will take place towards the end of the program. Learners will need to achieve at least 50% or higher on the final Python challenge to pass the program and earn a certificate. Demo Day will happen at the end of the course giving participants an opportunity to demonstrate their understanding of Python as a whole.

Who Should Attend?

Accountants and financial professionals who want to learn how to use data and data programming languages to make better business decision and solve problems.

No prior programming experience is required. Some basic understanding of arithmetic and statistics concepts and an aptitude for logic and quantitative concepts are highly desirable.

NEED APPROVAL TO ATTEND?

  EMPLOYER REQUEST LETTER

PRICING

$2499.00 Member

$2499.00 Student

$2499.00 Public

Status: Registration closed on Oct 31, 2022

LOCATION

Online

SPEAKER(S) BIO

Jenny Hung, Bs.C (Mathematics), LL.B, CPA.CA, is a data analyst in applied finance and data science instructor. In addition to data science, Jenny is also an algorithmic trader specializing in the Python language in the Forex market, and she also writes about Algo trading as well as the issues related to the financial markets. Jenny developed a financial trading algorithm that combines both quantitative finance insights as well as AI techniques and is capable of automatically selecting trades, choosing strategies, and managing portfolio trades.

SPECIAL INSTRUCTIONS

Course Format:

The course combines both synchronous and asynchronous components learning. Your learning will take place on the Lighthouse Labs learning platform. This is a two-step registration processs. Once you’ve registered and paid on the CPA Ontario portal you are considered registered for the course. You will receive an email from Lighthouse Labs at least 48 hours prior to the course start date with full program detail and information on how to access the course.

Disclaimer:

By registering for this course you consent and confirm your understanding of the following: CPA Ontario will share your first name, last name and email address with Lighthouse Labs for the purposes of providing you access to the course. It is suggested if possible, to use your business email address.

Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.