What you'll learn
Certificate in Computer Application (CCA)
Course Duration: 3 to 6 Months
Eligibility: 10th Pass or Equivalent
Mode: Offline / Online (Flexible Learning)
Language: English and Assamese (Bilingual)
Course Description:
The Certificate in Computer Application (CCA) course is designed to provide fundamental computer knowledge and essential office application skills. It aims to make students proficient in using computers for professional, educational, and personal purposes.
The course covers basic computer operations, MS Office tools, Internet usage, Email communication, Google Workspace tools, and practical applications of Artificial Intelligence (AI) in daily computing.
Upon successful completion, students will be able to perform documentation, data management, presentation design, and online communication effectively.
Course Objectives:
- To understand the basic concepts of computer systems and operations.
- To learn to create and manage documents, spreadsheets, databases, and presentations.
- To develop internet and email communication skills.
- To use Google tools for online productivity and collaboration.
- To explore and apply AI tools in daily computer tasks.
Show More
Course Syllabus
Detailed Syllabus
Module 1: Fundamentals of Computer
- Introduction to Computers
- Characteristics, Advantages & Limitations of Computer
- Types and Components of Computer
- Input, Output, and Storage Devices
- Computer Hardware and Software
- Operating Systems (Windows Basics)
- File and Folder Management
- Computer Security and Maintenance
- Number Systems and Binary Concept
Module 2: WordPad and Notepad
- Introduction to WordPad & Notepad
- Creating, Editing, Formatting, and Saving Documents
- Inserting Objects and Images
- Page Setup and Printing Documents
Module 3: MS Word (Microsoft Word)
- Introduction to Word Interface
- Creating, Editing, and Formatting Documents
- Page Layout and Styles
- Tables, Images, Charts, and Shapes
- Mail Merge and Label Printing
- Creating Resume, Report, and Letter
Module 4: MS Excel (Microsoft Excel)
- Introduction to Excel Interface
- Creating and Formatting Worksheets
- Basic Formulas and Functions (SUM, AVERAGE, IF, etc.)
- Charts and Graphs
- Data Sorting and Filtering
- Preparing Invoices and Reports
- Introduction to Pivot Tables
Module 5: MS PowerPoint (Microsoft PowerPoint)
- Basics of PowerPoint Interface
- Creating and Designing Slides
- Inserting Images, Audio, and Video
- Applying Transitions and Animations
- Creating Interactive Presentations
- Printing and Presenting Slides
Module 6: MS Access (Microsoft Access)
- Introduction to Database Concepts
- Tables, Fields, and Records
- Creating Queries and Forms
- Designing Simple Reports
- Managing and Analyzing Data
Module 7: Internet and Email
- Introduction to the Internet
- Web Browsing and Search Engines
- Creating and Managing Email Accounts (Gmail)
- Sending, Receiving, and Attaching Files
- Online Forms, Downloads, and Safety Tips
- Cloud Storage and Online Data Sharing
Module 8: Uses of AI in Daily Computing
- Introduction to Artificial Intelligence
- AI Tools for Text, Image, and Voice Assistance
- Using ChatGPT, Microsoft Copilot, and Google Gemini
- AI in Document Writing and Data Analysis
- Ethics and Safe Use of AI Tools
Module 9: Google Workspace (Docs, Sheets, Slides)
- Introduction to Google Workspace
- Creating and Editing Google Docs
- Using Google Sheets for Online Data Management
- Designing Presentations in Google Slides
- Sharing, Collaborating, and Real-Time Editing
Practical Projects:
- Prepare Resume and Cover Letter (MS Word)
- Create a Monthly Expense Sheet (MS Excel)
- Design a Presentation on “Digital India” (PowerPoint)
- Create a Simple Database of Students (MS Access)
- Send an Email with Attachments
- Prepare a Report using Google Docs and AI Assistance
Assessment:
- Theory Exam: 40 Marks
- Practical Exam: 50 Marks
- Project & Viva: 10 Marks
- Total: 100 Marks
Certification:
After successful completion of the course and exams, the student will be awarded a
“Certificate in Computer Application (CCA)” from Sankar Azan Computer Saksharata Mission (SACSM).
PixcelsIT View Profile
Bestseller
