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

SDF Funding, SkillsFuture Credit, UTAP Funding

IT072 : Introduction to Python for Accounting and Finance Professionals (Live Webinar)

14.00 CPE Hours (Others)
Classroom

Please be informed that as per Ministry of Health’s (MOH) guidelines on tighter measures that was announced on 24th March 2020, we will be changing the format of the session on 3 & 4 Aug 2020 into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

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

Others = 14.00 Hours

Schedule & Fees

Date & Time

28 May 2020 (9:00 AM - 5:00 PM)
29 May 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Team of Professional (IT072)

Venue

Online Classroom in or outside of
Singapore

Date & Time

03 Aug 2020 (9:00 AM - 5:00 PM)
04 Aug 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00   $ 599.20
For Non-Members: $ 898.80   $ 719.04
Discounts till 31 Aug 2020

Programme Facilitator(s)

Team of Professional (IT072)

Venue

Online Classroom in or outside of
Singapore

Date & Time

16 Nov 2020 (9:00 AM - 5:00 PM)
17 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00
For Non-Members: $ 898.80

Programme Facilitator(s)

Team of Professional (IT072)

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

03 Feb 2020 (9:00 AM - 5:00 PM)
04 Feb 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Team of Professional (IT072)

Date & Time

31 Oct 2019 (9:00 AM - 5:00 PM)
01 Nov 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Team of Professional (IT072)

Date & Time

28 Aug 2019 (9:00 AM - 5:00 PM)
29 Aug 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Team of Professional (IT072)

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 3 Apr 2020

Course Reference Number: CRS-N-0046077

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (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:

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

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 $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 3 Apr 2020
Funded Hours: 14 hours
Course Reference Number: CRS-N-0046077

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

3] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members. NTUC member gets to enjoy UTAP funding 50% of the unfunded course fee capped at $250 every year. This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2020 – 31 March 2021.
 
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

  • Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
  • Course by training provider must be supported under UTAP and training must commence within the supported period and;
  • Unfunded course fee must not be fully sponsored by company or other types of funding
  • Unfunded course fee must be S$20.00 and above, and;
  • Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
  • UTAP application must be made within 6 months after course ends.


To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
 
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)


Akmal bin Abd Rahman
BSc, Computer Science and Electrical & Computer Engineering, Cornell University, USA

Soon Yin Jie
BSc, MSc Electrical Engineering, Stanford University, USA

 
After finishing their public service stints as education officers with MOE, Akmal and Yinjie have harnessed their passion for creating and learning with technology to create a start-up which provides coding training to schools, tertiary institutions, startups, and corporations such as DBS, EDB, Sephora, and Temasek Holdings. In the last 6 years, working closely with the Infocomm Media Development Authority, Akmal, Yinjie and their colleagues have trained thousands of students and executives in various programming languages and platforms such as Python for data science, iPhone app development, web development, and electronics prototyping in Arduino and microbit. They've also worked to create apps (search for IC Photo on the iOS App Store if you're renewing your passport), and one of their web apps, Helpling, was acquired by technology conglomerate Rocket Internet.
 
They create web and mobile apps for proprietary use, and provide software consultancy services.
 
  • Corporate clients include Temasek Holdings, Sephora Ltd, DBS, EDB, MOE, NTUC, Ngee Ann Polytechnic, Singapore Polytechnic, Republic Polytechnic, ITE Central, National University of Singapore, Nanyang Technological University
  • IMDA appointed vendor for the ICM Learning Roadmap for schools, teaching web development, mobile development, the maker movement, and networking security for over 40 schools.
  • Pilot vendor for the Code@SG Movement, bringing programming literacy to schools as part of core curriculum to over 3,000 students.
  • Pilot industry partner for the Digital Maker programme, developing a custom breakout board and mobile application for the launch of the micro:bit in Singapore
  • Pilot and appointed vendor for the PlayMaker programme, introducing age-appropriate technology toys to over 160 preschools to foster creativity and learning through play.
  • Conducted Courses for Singapore Design Week, NTUC Learning Hub’s Future Creator series, Maker Faire Singapore, Infocomm Media Youth Festival, Camp Asia, IMDA Tech Saturday

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.

Work
  • Business & Education Development Manager, Tinkertanker. 2015 – present.
  • Web Consultant, Self-employed. 2013 – 2015.
  • Digital Marketer, Self-employed. 2007 – 2013.
  • Actuarial Analyst, Towers Perrin Tillinghast, 2006 – 2007.
  • Negotiations Teaching Assistant, The Wharton School, 2005 – 2006.
  • Research Assistant, Wharton Management Department, 2004 – 2005.

Education
  • The Wharton School, University of Pennsylvania. Bachelor of Science in Economics, Cum Laude, 2006.

Please be informed that as per Ministry of Health’s (MOH) guidelines on tighter measures that was announced on 24th March 2020, we will be changing the format of the session on 3 & 4 Aug 2020 into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

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

Others = 14.00 Hours

Programme Facilitator(s)

Akmal bin Abd Rahman
BSc, Computer Science and Electrical & Computer Engineering, Cornell University, USA

Soon Yin Jie
BSc, MSc Electrical Engineering, Stanford University, USA

 
After finishing their public service stints as education officers with MOE, Akmal and Yinjie have harnessed their passion for creating and learning with technology to create a start-up which provides coding training to schools, tertiary institutions, startups, and corporations such as DBS, EDB, Sephora, and Temasek Holdings. In the last 6 years, working closely with the Infocomm Media Development Authority, Akmal, Yinjie and their colleagues have trained thousands of students and executives in various programming languages and platforms such as Python for data science, iPhone app development, web development, and electronics prototyping in Arduino and microbit. They've also worked to create apps (search for IC Photo on the iOS App Store if you're renewing your passport), and one of their web apps, Helpling, was acquired by technology conglomerate Rocket Internet.
 
They create web and mobile apps for proprietary use, and provide software consultancy services.
 
  • Corporate clients include Temasek Holdings, Sephora Ltd, DBS, EDB, MOE, NTUC, Ngee Ann Polytechnic, Singapore Polytechnic, Republic Polytechnic, ITE Central, National University of Singapore, Nanyang Technological University
  • IMDA appointed vendor for the ICM Learning Roadmap for schools, teaching web development, mobile development, the maker movement, and networking security for over 40 schools.
  • Pilot vendor for the Code@SG Movement, bringing programming literacy to schools as part of core curriculum to over 3,000 students.
  • Pilot industry partner for the Digital Maker programme, developing a custom breakout board and mobile application for the launch of the micro:bit in Singapore
  • Pilot and appointed vendor for the PlayMaker programme, introducing age-appropriate technology toys to over 160 preschools to foster creativity and learning through play.
  • Conducted Courses for Singapore Design Week, NTUC Learning Hub’s Future Creator series, Maker Faire Singapore, Infocomm Media Youth Festival, Camp Asia, IMDA Tech Saturday

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.

Work
  • Business & Education Development Manager, Tinkertanker. 2015 – present.
  • Web Consultant, Self-employed. 2013 – 2015.
  • Digital Marketer, Self-employed. 2007 – 2013.
  • Actuarial Analyst, Towers Perrin Tillinghast, 2006 – 2007.
  • Negotiations Teaching Assistant, The Wharton School, 2005 – 2006.
  • Research Assistant, Wharton Management Department, 2004 – 2005.

Education
  • The Wharton School, University of Pennsylvania. Bachelor of Science in Economics, Cum Laude, 2006.

Upcoming Schedule

Date & Time

03 Aug 2020 (9:00 AM - 5:00 PM)
04 Aug 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00   $ 599.20
For Non-Members: $ 898.80   $ 719.04
Discounts till 31 Aug 2020

Programme Facilitator(s)

Team of Professional (IT072)

Venue

Online Classroom in or outside of
Singapore