Internal Controls
IT in Audit
Data Visualization
Data Protection
General
100

Common Control Procedures

What is physical controls?

What is authorization and approval limits?

What is segregation of duties?

What is management controls?

What is arithmetic and accounting controls?

What is human resources controls?

100

IT controls

What is general controls?

What is application controls?

100

This will insert a quick chart on a new worksheet instantly.

What is F11?

100

The practice of safeguarding sensitive information from unauthorized access, use, disclosure, disruption, modification, or destruction.

What is data protection?

200

This is IA role in Internal control

What is key risk?

What is financial and operating information?

What is compliance?

200

Importance of IT controls

What is address the risks related to the data and information flowing through multiple IT system?

200

This is what it's called when a user is able to understand at a glance.

What is the 10 second rule?

200

A regulation in the EU that came into effect in 2018 and applies to all organizations processing the personal data of EU residents.

 What isGeneral Data Protection Regulation (GDPR)?

300

Purpose of Internal Controls

What is to ensure compliance?

What is ensure the quality of internal and external reporting?

What is to facilitate effective operation?

300

Categories of GITCs

What is access to programs and data?

What is computer operations?

What is program development?

What is program changes?

300

This chart is used to show relationships and flows.

What is funnel, chord or network navigator?

300

Data that could be used to identify an individual or that could be used for fraudulent purposes

What is sensitive data?

300

This is a formal written statement that defines the approved purpose, authority, and responsibility of the internal audit activity

What is Internal Audit Charter?

400

Objectives of Internal Controls

What is safeguarding assets?

What is preventing and detecting fraud?

What is efficient conduct of business?

What is completeness and accuracy?

What is management processes and financial statements?

400

Understanding the IT Environment

What is obtain background information on It systems?

What is identify IT systems relevant to Financial management?

What is assess complexity of IT systems?

What is preliminary risk assessments?

400

This chart looks similar to another chart; however this chart is used to show frequencies.

What is histogram?

400

A plan for responding to a data breach or other security incident.

What is an incident response plan?

400

An appraisal activity established or provided as a service to the entity. Its functions include, amongst other things, examining, evaluating and monitoring the adequacy and effectiveness of internal control

What is Internal Audit?

500

Components of Internal Controls

What is control environment?

What is risk assessment?

What is monitor? 

What is information/communication?

What is control activities?

500

Objectives of Application Controls

What is completeness?

What is authorization?

What is segregation of duties?

What is validity?

What is accuracy?

500

This chart is created by a series of adding and subtracting values to visualize how the starting value of something reaches the end.

What is waterfall?

500

Expected to take a more focused oversight role in respect of risk management and internal control

What is Audit Committee?

M
e
n
u