Course Overview:

Course Objectives:

1. Equip students with essential Excel skills for data analysis, including advanced formulas and pivot tables.
2. Teach how to use Power BI to process and visualize data, turning raw information into interactive reports and dashboards.
3. Develop skills in data cleaning, transformation, and analysis to extract insights from large datasets.
4. Understand best practices for data visualization and storytelling through dashboards.
5. Enable students to apply data analytics to make informed, data-driven decisions in any business or industry context

Course Requirements:

1. Basic understanding of computer use and Microsoft Office.
2. Access to Microsoft Excel (any version) and Power BI Desktop (free version).
3. No prior experience in data analysis is required, but familiarity with Excel will be helpful.

Accreditations:

1. Upon successful completion, participants will receive a Certificate of Achievement in Data Analytics with Power BI and Excel from the institution.
2. The course may count towards Continuing Education Units (CEUs) or Professional Development Units (PDUs), depending on your institution's accreditation body.

Examination and Award:

1. Final Examination: A written and practical exam where students must demonstrate their ability to use Excel and Power BI for data analytics and visualization.
2. Capstone Project Presentation: Submit and present the final data analysis project, showcasing all techniques learned throughout the course.

Examination Weights:

1. Final Examination: 40%
2. Capstone Project: 40%
3. Assignments and Quizzes: 20%

Module 1: Introduction to Data Analytics

Topics:

1. Overview of Data Analytics: Importance and Applications
2. Role of Power BI and Excel in Data Analysis
3. Fundamentals of Data-Driven Decision Making
4. Key Concepts in Data Analytics (Data Cleaning, Transformation, Visualization)

Learning Outcomes:

1. Understand the significance of data analytics in business decision-making.
2. Recognize the role of Excel and Power BI in data analysis.
3. Develop a foundational understanding of data cleaning, transformation, and visualization processes.

Module 2: Working with Excel for Data Analytics

Topics:

1. Basic Excel Functions: Worksheets, Cells, and Data Entry
2. Techniques for Data Cleaning in Excel (Sorting, Filtering, Removing Duplicates)
3. Advanced Formulas and Functions (VLOOKUP, INDEX, MATCH, IF Statements)
4. Pivot Tables and Pivot Charts: Creating and Customizing Reports
5. Conditional Formatting and Data Validation

Learning Outcomes:

1. Gain proficiency in data entry, cleaning, and preparation using Excel.
2. Apply advanced formulas and functions to solve data analysis problems.
3. Use Pivot Tables and Pivot Charts to summarize and present data effectively.
4. Understand and apply Excel’s data validation and formatting features for better analysis.

Module 3: Power BI Fundamentals

Topics:

1. Introduction to Power BI and Its Components (Power Query, Power Pivot, Power View)
2. Connecting and Importing Data into Power BI
3. Cleaning and Transforming Data with Power BI
4. Building Basic Visualizations: Charts, Graphs, and Tables
5. Introduction to Interactive Dashboards in Power BI

Learning Outcomes:

1. Understand Power BI's interface and key components for data analysis.
2. Import and prepare data in Power BI for analysis and reporting.
3. Create basic visualizations, charts, and tables for data presentation.
4. Develop an understanding of interactive dashboard creation in Power BI.

Module 4: Data Visualization and Reporting

Topics:

1. Best Practices for Data Visualization (Choosing the Right Visuals)
2. Customizing Visuals and Reports in Power BI and Excel
3. Interactive Elements in Power BI: Slicers, Filters, and Drill-Downs
4. Storytelling with Data: Crafting Meaningful Reports and Dashboards
5. Publishing and Sharing Reports in Power BI

Learning Outcomes:

1. Learn to apply data visualization best practices for effective reporting.
2. Customize charts, tables, and visuals in Excel and Power BI to meet analysis needs.
3. Build interactive and user-friendly reports and dashboards with filters, slicers, and drill-downs.
4. Understand how to publish and share Power BI reports with stakeholders.

Module 5: Advanced Power BI Techniques

Topics:

1. Mastering DAX (Data Analysis Expressions) for Complex Calculations
2. Forecasting and Trend Analysis in Power BI
3. Setting Up Alerts and Data-Driven Actions in Power BI
4. Integrating Power BI with Excel, SQL, and Other Applications

Learning Outcomes:

1. Learn to use DAX for advanced data analysis and custom calculations in Power BI.
2. Gain skills in using Power BI for forecasting and trend analysis.
3. Set up alerts and automate data-driven actions within Power BI.
4. Integrate Power BI with external data sources, such as Excel and SQL, for more advanced analysis.

Module 6: Capstone Project

Topics:

1. Data Collection and Problem Definition for Real-World Analysis
2. Using Power BI and Excel to Analyze and Visualize Data
3. Report and Dashboard Design: Key Takeaways and Best Practices
4. Final Assessment: Presenting Your Data Findings

Learning Outcomes:

1. Apply all concepts learned throughout the course to a real-world dataset.
2. Design and build an interactive report/dashboard in Power BI and Excel.
3. Demonstrate the ability to analyze, visualize, and present data insights clearly and effectively.

Course Overview:

Course Objectives:

1. Understand and apply the core principles of web and graphic design, including layout, typography, and color theory.
2. Gain practical experience using design tools such as Adobe XD, Figma, Photoshop, Illustrator, and Webflow for web and graphic design tasks.
3. Master HTML, CSS, and JavaScript to create responsive, functional websites.
4. Understand user experience (UX) and user interface (UI) design principles for designing seamless websites and digital experiences.
5. Learn the fundamentals of web accessibility, ensuring designs are inclusive and usable for all users.
6. Build and deploy websites using Content Management Systems (CMS) like WordPress and platforms like GitHub Pages and Netlify.
7. Develop effective communication skills to collaborate with clients and incorporate feedback into design solutions.
8. Create a professional portfolio website to showcase skills and work, improving employability or attracting freelance opportunities.

Course Requirements:

1. No prior experience in web or graphic design is necessary.
2. Basic computer skills and familiarity with using the internet.
3. A passion for learning design concepts and a desire to create beautiful, functional websites.
4. Access to a computer with an internet connection and design software (free trials of Adobe XD, Figma, and other mentioned tools will be provided).

Accreditations:

• Upon successful completion, participants will receive a Certificate of Achievement in Web and Graphic Design.
• The course may count towards Continuing Education Units (CEUs) or Professional Development Units (PDUs), depending on the accrediting institution.

Examination and Award:

• Final Examination: A combination of practical assignments and a written exam covering both web design and graphic design topics. Students will be assessed on their ability to create a fully functional website, apply design principles, and use tools effectively.
• Capstone Project: A hands-on project where students demonstrate their design and development skills by building a website with both graphic design and web development elements.

Examination Weights:

1. Final Examination: 40%
2. Capstone Project: 40%
3. Assignments and Quizzes: 20%

Module 1: Introduction to Web and Graphic Design

Topics:

1. The Role of Web and Graphic Designers
2. Core Design Principles (Balance, Alignment, Contrast, Hierarchy, Proximity)

Learning Outcomes:

1. Understand the distinctions between web design (creating websites) and graphic design (visual elements for branding, logos).
2. Apply fundamental design principles to create balanced and visually appealing layouts for both web and graphic design projects.

Module 2: Web Design Fundamentals

Topics:

1. Overview of Web Technologies (HTML, CSS, JavaScript)
2. User Experience (UX) and User Interface (UI) Design
3. Introduction to Design Tools (Adobe XD, Figma, Webflow)

Learning Outcomes:

1. Gain an understanding of how HTML, CSS, and JavaScript work together to create functional websites.
2. Learn key principles of UX/UI design to create intuitive and user-friendly websites.
3. Get hands-on experience with design tools for building wireframes, prototypes, and interface designs for web projects.

Module 3: HTML and CSS Essentials

Topics:

1. HTML Structure and Elements (Headings, Links, Images, Lists)
2. CSS Basics and Styling (Text, Colors, Layouts)
3. Responsive Design with Media Queries

Learning Outcomes:

1. Master the basics of HTML to build the structure of a webpage, including semantic HTML for better SEO and accessibility.
2. Learn CSS to style websites, including layout techniques like Flexbox and Grid.
3. Understand responsive design principles and implement media queries to make websites mobile-friendly.

Module 4: Graphic Design Principles and Tools

Topics:

1. Typography and Color Theory
2. Image Editing and Logo Creation (Adobe Photoshop, Illustrator)
3. Designing for Branding (Visual Identities, Logos, Icons)

Learning Outcomes:

1. Understand how to choose fonts and color schemes that align with brand messaging and design goals.
2. Gain proficiency in Photoshop and Illustrator to edit photos, create logos, and design vector graphics.
3. Learn how to design branding materials like logos and icons that represent businesses and products effectively.

Module 5: Advanced Web Design Techniques

Topics:

1. Advanced CSS Styling (Animations, Transitions)
2. Introduction to JavaScript for Designers (Interactivity, Forms, Sliders)
3. Web Accessibility (WCAG Guidelines, Making Websites Inclusive)

Learning Outcomes:

1. Enhance your CSS skills by incorporating animations, transitions, and responsive elements to improve website interactivity.
2. Learn basic JavaScript concepts to add interactive features such as buttons, sliders, and forms to websites.
3. Understand web accessibility principles and how to design websites that are inclusive and usable by all, including people with disabilities.

Module 6: Content Management Systems (CMS)

Topics:

1. Setting Up WordPress Websites
2. Installing Themes and Using Plugins (SEO, Forms, Galleries)

Learning Outcomes:

1. Learn how to set up and customize a WordPress website, install themes, and utilize plugins for extended functionality.
2. Understand how to implement basic SEO techniques and optimize content for search engines.

Module 7: Portfolio Development and Web Deployment

Topics:

1. Building a Personal Portfolio Website
2. Deploying Websites with GitHub Pages, Netlify, and Web Hosting Providers

Learning Outcomes:

1. Design and build a personal portfolio website to showcase your web and graphic design projects.
2. Gain experience in deploying websites using platforms like GitHub Pages, Netlify, and traditional web hosting services.

Module 8: Capstone Project

Topics:

1. Real-World Web Design Project (Building a Functional Website)
2. Project Presentation and Feedback

Learning Outcomes:

1. Apply all the skills learned throughout the course to complete a fully functional website for a hypothetical client, integrating both graphic design and web development elements.
2. Present your capstone project to peers and instructors for feedback and refinement.

Course Overview:

Course Objectives:

1. Understand the key principles of cybersecurity, including the importance of confidentiality, integrity, and availability (CIA Triad).
2. Be able to identify and mitigate various types of cyber threats such as malware, phishing, DDoS, and insider threats.
3. Gain a strong foundation in network security, including firewall configuration, VPNs, and intrusion detection/prevention systems.
4. Understand the basics of cryptography, encryption, and secure communication protocols.
5. Learn endpoint security best practices, including antivirus tools, patch management, and endpoint detection.
6. Familiarize themselves with key cybersecurity tools like SIEM, vulnerability scanning, and network monitoring tools.
7. Understand identity and access management, including authentication, access control models, and multi-factor authentication (MFA).
8. Be able to create and implement security policies, disaster recovery plans, and comply with industry regulations.
9. Develop awareness of social engineering tactics and how to build a cybersecurity-conscious organizational culture.
10. Explore emerging trends in cybersecurity, including cloud security, IoT security, and AI-driven security solutions.

Course Requirements:

1. No prior experience in cybersecurity is required.
2. Basic knowledge of computer systems and networks is helpful but not mandatory.
3. Access to a computer with an internet connection and the ability to install or use necessary tools (free versions of software will be provided).
4. A keen interest in learning about cybersecurity concepts and practices.

Accreditations:

• Upon successful completion of the course, students will receive a Certificate of Completion in Cybersecurity Essentials.
• The course may be eligible for Continuing Education Units (CEUs) or Professional Development Units (PDUs) depending on the accrediting institution.

Examination and Award:

• Final Examination: The final exam will consist of both theoretical and practical components. Students will be assessed on their knowledge of core cybersecurity principles, the application of various security measures, and their ability to respond to cyber incidents.
• Hands-On Project: Students will complete a hands-on project, which includes tasks such as configuring a firewall, performing a vulnerability scan, and simulating a phishing attack.

Examination Weights:

1. Final Exam: 40%
2. Hands-On Project: 40%
3. Assignments and Quizzes: 20%

Module 1: Introduction to Cybersecurity

Topics:

1. Definition and Importance of Cybersecurity
2. Overview of Cyber Threats and Attacks
3. Key Objectives: Confidentiality, Integrity, and Availability (CIA Triad)
4. Cybersecurity Trends and Challenges

Learning Outcomes:

1. Understand the importance of cybersecurity in protecting digital assets.
2. Gain familiarity with the CIA Triad and how it applies to security.
3. Identify the current trends and challenges facing the cybersecurity industry.

Module 2: Threat Landscape

Topics:

1. Types of Cyber Threats: Malware, Phishing, DDoS, Insider Threats, APTs
2. Vulnerabilities and Exploits
3. Risk Assessment Basics

Learning Outcomes:

1. Recognize common types of cyber threats and their impacts on organizations.
2. Learn the basics of risk assessment and how to assess vulnerabilities in digital systems.
3. Understand the role of exploits and how attackers use them to gain unauthorized access.

Module 3: Fundamentals of Network Security

Topics:

1. Networking Basics: IP Addressing, Subnetting, Protocols (HTTP, HTTPS, FTP, SSH)
2. Firewalls and IDS/IPS
3. Virtual Private Networks (VPNs)
4. Wireless Security

Learning Outcomes:

1. Understand basic networking concepts such as IP addressing and protocols.
2. Learn about firewalls, IDS/IPS systems, and their role in securing networks.
3. Gain knowledge of VPNs and wireless security protocols.

Module 4: Cryptography Essentials

Topics:

1. Encryption and Decryption
2. Symmetric vs Asymmetric Encryption
3. Hashing (MD5, SHA-256)
4. Digital Signatures and Certificates
5. Public Key Infrastructure (PKI)
6. Secure Communication Protocols (TLS, SSL)

Learning Outcomes:

1. Understand how encryption and decryption protect data confidentiality.
2. Learn the differences between symmetric and asymmetric encryption.
3. Become familiar with cryptographic hashing and its use in securing data.
4. Understand the role of digital signatures, certificates, and PKI in cybersecurity.

Module 5: Endpoint Security

Topics:

1. Secure Operating Systems (Windows, Linux, macOS)
2. Antivirus and Antimalware Tools
3. Patch Management and Software Updates
4. Endpoint Detection and Response (EDR) Tools

Learning Outcomes:

1. Learn how to secure different operating systems and implement endpoint protection.
2. Gain practical experience with antivirus tools and endpoint security measures.
3. Understand the importance of software updates and patch management in preventing vulnerabilities.

Module 6: Cybersecurity Tools and Techniques

Topics:

1. Security Information and Event Management (SIEM)
2. Vulnerability Scanning and Penetration Testing
3. Network Monitoring Tools (Wireshark, Splunk)
4. Forensics Tools

Learning Outcomes:

1. Understand how SIEM tools aggregate and analyze security data.
2. Learn about vulnerability scanning and how to identify security weaknesses in systems.
3. Gain hands-on experience with tools like Wireshark for network monitoring and Splunk for security data analysis.

Module 7: Identity and Access Management (IAM)

Topics:

1. Authentication Methods (Passwords, Biometrics, MFA)
2. Authorization and Access Control Models
3. Role-Based Access Control (RBAC)
4. Single Sign-On (SSO) and Identity Federation

Learning Outcomes:

1. Learn about various authentication methods and how MFA enhances security.
2. Understand authorization models such as RBAC and how they control access to systems.
3. Gain knowledge of SSO and identity federation in managing user access.

Course Description:

Key Learning Outcomes:

1. Fraud Detection and Prevention: Learn how to identify, deter, and prevent fraud within organizations, ensuring a secure working environment.
2. Investigation Skills: Develop the expertise to investigate fraud and corruption, particularly in private and public sector cases.
3. Report Writing: Gain proficiency in creating clear and professional fraud investigation reports.
4. Legal Knowledge: Understand the legal aspects of fraud examinations, especially when dealing with legal prosecutions.
5. Ethics and Accountability: Learn the significance of ethics in fraud detection and how to mentor others to build a culture of accountability.
6. Career Advancement: Enhance career prospects, marketability, and job security with a globally recognized CFE credential.

Course Topics:

• Definition and Types of Fraud
• The Role of a Fraud Examiner
• Ethical and Legal Considerations in Fraud

• Methods to Identify Fraud Risks
• Tools and Techniques for Fraud Detection
• Red Flags of Fraud in Different Sectors

• Implementing Anti-Fraud Programs
• Internal Controls and Risk Management
• Fraud Prevention Best Practices

• Investigative Techniques and Procedures
• Interviewing Techniques for Fraud Investigations
• Gathering and Analyzing Evidence

• Writing Clear, Professional Reports
• Case Study Analysis and Reporting
• Communicating Findings Effectively

• Understanding Legal Procedures in Fraud Cases
• The Role of Fraud Examiners in Legal Proceedings
• Preparing for Court Testimony

• Creating Ethical Guidelines for Organizations
• Mentoring and Training Employees on Fraud Prevention
• Role of Ethics in Preventing Fraud

Target Participants:

• Professionals in Accounting, Auditing, and Finance: Those looking to expand their skill-set in fraud detection and prevention.
• Internal and External Auditors: Individuals seeking expertise in investigating financial fraud and corruption.
• Compliance Officers and Risk Managers: Those responsible for creating and maintaining fraud prevention strategies.
• Law Enforcement Personnel: Professionals in public and private sectors focused on investigating crimes related to fraud.
• Managers and Executives: Leaders interested in understanding fraud prevention and building ethical organizational cultures.
• Anyone Interested in Fraud Examination: Individuals pursuing a career in fraud detection, investigation, and prevention.

Participant Expectations:

• Active Participation: Participants should engage in discussions, case studies, and exercises to gain practical skills.
• Completion of Assignments: Assignments will be given throughout the course to apply learning in real-world scenarios.
• Final Exam: A comprehensive exam will test the knowledge gained during the course.
• Professional Conduct: Participants are expected to uphold ethical standards and apply principles of fraud prevention and investigation in practice.

Course Details:

• Duration: 4 Weekends (8 sessions total)
• Start Date: 4th April 2024
• Time: Sessions will be held on weekends, providing flexibility for working professionals.
• Mode of Delivery: In-person (depending on availability and participant location)
• Fee: $1515 (includes course materials, certification exam, and access to a network of fraud prevention professionals)

Why Take This Course: