Course Detail(IT072 : Introduction to Python for Accounting and Finance Professionals)

SkillsFuture Credit, UTAP Funding

IT072 : Introduction to Python for Accounting and Finance Professionals

14.00 CPE Hours (Category 5)
Classroom

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 

Note:

As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop.

Programme Objective

This course is an introduction to Python, a popular programming language, which will be delivered in a context relevant to professional accountants. Python is a user -friendly language taught as an introductory Computer Science courses in the universities, while also being powerful and flexible enough to be used in a variety of professional settings, e.g. in data science, artificial intelligence and web development.
 
Participants will learn how Python can be used to consolidate data from reports of varying templates, crawling data from e-commerce sites to evaluate the organisation’s pricing strategies, and making documents in the workplace secure from prying eyes.

Programme Outline

 

Day 1: 
- Getting started with Jupyter
- Python basics: Variables, Loops, Conditionals and Data Types
- Introduction to data processing with the Pandas library
- Using plotting libraries to present data with simple graphs
- Python in the real world: Compiling tweets, and cracking a zip file
  
Day 2: 
- Using data tools in Python for financial analysis
- Reading from public stock ticker APIs, manipulating and presenting stock data
- Excel vs Python, when to use each, and how to complement one another
- Working with Excel files and Google Sheets
- Python in the real world: sorting out Excel data, reading weather data using APIs
 

Training Methodology

A hands-on and highly participative learning course conducted in a computer lab. Participants will be given opportunities to perform simple coding using Python and create simple charts from data sets.
 

Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Accounting professionals who wish to learn the beginner-friendly language Python and apply them to their work. Any participants who wish to gain introductory knowledge on Python.

Competency Mapping

Category 5 = 14.00 Hours

Schedule & Fees

Date & Time

29 Jul 2024 (9:00 AM - 5:00 PM)
30 Jul 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 763.00
For Non-Members: $ 915.60

Programme Facilitator(s)

Team of Professional (IT072)

Venue

60 Cecil Street
ISCA House
Singapore 049709

Testimonial


Learning the basic of coding is good to have for foundation building and will create an interest for further
training.

Past Participant


This course is a really good introduction to Python. It is short and practical, and you definitely can explore more
on your own after the course.

Past Participant

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 31 Dec 2024
Course Reference Number: TGS-2020501906

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees. 

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $43.20 for any revision of invoice.

 

2] NTUC Union Training Assistance Programme (UTAP)

UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
 
To find out more on the UTAP funding and support validity period please click here.
 

Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

 

Programme Facilitator(s)


Michael Gonsalves

Michael Gonsalves came to Singapore to join Tinkercademy in 2015, and he's spent over 500 hours of classroom time teaching programming and electronics to students aged 5 to 50 (maybe older, we didn't ask). He's developed lessons in a variety of languages and tools, e.g. Scratch, Python, data science, Raspberry Pi, littleBits, Circuit Stickers, and robotics. In addition to his teaching experience, Mike has data science experience as an actuarial analyst, computer science experience as a web consultant.

Fritz Lim

Fritz Lim has been in the education industry for more than 15 years. He started out at Nanyang Polytechnic in 2005, where he taught C/C++ programming, web development and other subjects related to sound and music. He is currently a freelance educator and adult trainer for programming courses in Python, C#, web development, and mobile app development, as well as sound design and sound mixing.

Ang Swee Chye

Swee Chye is a Consultant and Trainer with more than 20 years of experience implementing Enterprise Business Solutions for many Corporations in more than 10 different countries. He has taught WSQ Web Development to working professionals, and currently conducts training in Cyber Security, Robotics, Mobile Apps, Internet of Things, Web Development and Programming.

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 

Note:

As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop.

Programme Objective

This course is an introduction to Python, a popular programming language, which will be delivered in a context relevant to professional accountants. Python is a user -friendly language taught as an introductory Computer Science courses in the universities, while also being powerful and flexible enough to be used in a variety of professional settings, e.g. in data science, artificial intelligence and web development.
 
Participants will learn how Python can be used to consolidate data from reports of varying templates, crawling data from e-commerce sites to evaluate the organisation’s pricing strategies, and making documents in the workplace secure from prying eyes.

Programme Outline

 

Day 1: 
- Getting started with Jupyter
- Python basics: Variables, Loops, Conditionals and Data Types
- Introduction to data processing with the Pandas library
- Using plotting libraries to present data with simple graphs
- Python in the real world: Compiling tweets, and cracking a zip file
  
Day 2: 
- Using data tools in Python for financial analysis
- Reading from public stock ticker APIs, manipulating and presenting stock data
- Excel vs Python, when to use each, and how to complement one another
- Working with Excel files and Google Sheets
- Python in the real world: sorting out Excel data, reading weather data using APIs
 

Training Methodology

A hands-on and highly participative learning course conducted in a computer lab. Participants will be given opportunities to perform simple coding using Python and create simple charts from data sets.
 

Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Accounting professionals who wish to learn the beginner-friendly language Python and apply them to their work. Any participants who wish to gain introductory knowledge on Python.

Competency Mapping

Category 5 = 14.00 Hours

Programme Facilitator(s)

Michael Gonsalves

Michael Gonsalves came to Singapore to join Tinkercademy in 2015, and he's spent over 500 hours of classroom time teaching programming and electronics to students aged 5 to 50 (maybe older, we didn't ask). He's developed lessons in a variety of languages and tools, e.g. Scratch, Python, data science, Raspberry Pi, littleBits, Circuit Stickers, and robotics. In addition to his teaching experience, Mike has data science experience as an actuarial analyst, computer science experience as a web consultant.

Fritz Lim

Fritz Lim has been in the education industry for more than 15 years. He started out at Nanyang Polytechnic in 2005, where he taught C/C++ programming, web development and other subjects related to sound and music. He is currently a freelance educator and adult trainer for programming courses in Python, C#, web development, and mobile app development, as well as sound design and sound mixing.

Ang Swee Chye

Swee Chye is a Consultant and Trainer with more than 20 years of experience implementing Enterprise Business Solutions for many Corporations in more than 10 different countries. He has taught WSQ Web Development to working professionals, and currently conducts training in Cyber Security, Robotics, Mobile Apps, Internet of Things, Web Development and Programming.


Upcoming Schedule

Date & Time

29 Jul 2024 (9:00 AM - 5:00 PM)
30 Jul 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 763.00
For Non-Members: $ 915.60

Programme Facilitator(s)

Team of Professional (IT072)

Venue

60 Cecil Street
ISCA House
Singapore 049709