COURSE CURRICULUM

Certificate in Computer Application


Module 1:

Digital Systems & Operating Environments

Module Description:

This module introduces learners to digital systems and operating environments. It covers the fundamental components of a computer system and the role of operating systems in managing hardware and software.

  • Understanding digital systems and components
  • Introduction to operating systems and their functions
  • Managing system resources and user interfaces
  • Overview of different operating systems (Windows, Linux, MacOS)
  • File and system management techniques
Module 2:

Basic Hardware & Networking

Module Description:

This module provides learners with the foundational knowledge of computer hardware and networking principles. It covers the components that make up a computer system and the basic concepts of networking.

  • Introduction to computer hardware components
  • Basic concepts of computer networking (LAN, WAN)
  • Network devices: routers, switches, and modems
  • Understanding IP addresses and networking protocols
  • Basic troubleshooting for hardware and networking issues
Module 3:

Advanced MS Office – Word & Excel

Module Description:

This module focuses on advanced features in Microsoft Word and Excel, helping learners create professional documents and spreadsheets with advanced formatting, functions, and data management tools.

  • Advanced Word features: Styles, Tables, and References
  • Excel data analysis tools: Pivot Tables, Charts, and Data Validation
  • Working with complex formulas and functions (VLOOKUP, IF statements)
  • Customizing document layouts and styles
  • Automating tasks with macros and templates
Module 4:

Interactive Presentations & Online Collaboration

Module Description:

This module equips learners with the skills to create interactive and engaging presentations and collaborate effectively using online tools like Google Workspace and Microsoft Teams.

  • Designing interactive PowerPoint presentations with animations and multimedia
  • Using Google Slides for real-time collaboration
  • Effective online communication and teamwork techniques
  • Incorporating online collaboration tools like Google Docs, Sheets, and Teams
  • Delivering presentations and engaging the audience
Module 5:

Database Management with MS Access & SQL

Module Description:

This module teaches the basics of database management using MS Access and SQL. Learners will gain hands-on experience in creating databases, designing queries, and managing data.

  • Introduction to relational databases and SQL
  • Creating and managing tables in MS Access
  • Designing queries for data retrieval and manipulation
  • Working with forms and reports in MS Access
  • Basic SQL commands (SELECT, INSERT, UPDATE, DELETE)
Module 6:

Basic Graphic Design & Image Editing

Module Description:

This module introduces the basics of graphic design and image editing using tools like Adobe Photoshop and Canva. Learners will gain the skills to create professional-quality designs for various purposes.

  • Introduction to design principles: layout, color theory, and typography
  • Using Adobe Photoshop for image editing and manipulation
  • Basic photo retouching and enhancement techniques
  • Creating logos, social media posts, and promotional materials
  • Using Canva for quick and easy graphic design projects
Module 7:

Web Design & Visual Communication

Module Description:

This module introduces learners to the fundamentals of web design, focusing on visual communication principles and user-friendly design techniques. It covers HTML, CSS, and design best practices for building accessible websites.

  • Basic web design principles: layout, navigation, and user experience
  • Introduction to HTML and CSS for webpage development
  • Creating responsive web designs using Flexbox and Grid
  • Introduction to visual communication and design tools
  • Building a basic website with HTML and CSS
Module 8:

Programming Foundations with Python

Module Description:

This module provides learners with the foundational skills in programming using Python. It covers basic programming concepts such as variables, loops, functions, and data structures.

  • Introduction to Python syntax and programming environment
  • Working with variables, data types, and operators
  • Control flow: conditional statements and loops
  • Writing and using functions for code reuse
  • Basic data structures: lists, dictionaries, and tuples
Module 9:

Digital Safety, Cloud Computing & Cybersecurity

Module Description:

This module focuses on digital safety practices, cloud computing, and the importance of cybersecurity. Learners will gain the knowledge needed to protect themselves and their data in the digital world.

  • Understanding digital safety and online threats (phishing, malware, etc.)
  • Introduction to cloud computing and storage solutions
  • Best practices for securing personal and professional data
  • Fundamentals of cybersecurity: firewalls, encryption, and security protocols
  • Using cloud services like Google Drive and OneDrive securely
Module 10:

Career Development, Business Automation & Emerging Technologies

Module Description:

This module focuses on career development, business automation tools, and emerging technologies. It prepares learners for a future in the rapidly changing tech landscape, covering both soft skills and technical innovations.

  • Career planning and skill development for the tech industry
  • Introduction to business automation tools (CRM, ERP systems)
  • Emerging technologies: AI, IoT, Blockchain
  • How automation and emerging technologies are shaping businesses
  • Preparing for job interviews, networking, and continuous learning