DCA

Course Duration:

Diploma in Computer Application Syllabus

  1. Introduction to Computers
  • Definition and Types of Computers
  • Basic Computer Components (Hardware and Software)
  1. Understanding Operating Systems
  • Overview of Operating Systems
  • Features of Windows OS
  • File Management in Windows
  1. Introduction to Microsoft Office
  • Overview of MS Office Suite
  • Installation and Setup of MS Office
  1. Microsoft Word: Getting Started
  • Overview of the MS Word Interface
  • Creating and Saving Documents
  1. Text Formatting in Word
  • Font Types, Sizes, and Styles
  • Paragraph Formatting (Alignment, Line Spacing)
  1. Working with Lists in Word
  • Creating Bulleted and Numbered Lists
  • Using Multilevel Lists
  1. Inserting Graphics and Tables in Word
  • Inserting Images, Shapes, and SmartArt
  • Creating and Formatting Tables
  1. Document Features in Word
  • Using Headers, Footers, and Page Numbers
  • Inserting Page Breaks and Section Breaks
  1. Advanced Document Formatting
  • Using Styles and Themes
  • Creating and Modifying a Table of Contents
  1. Review and Collaboration Tools in Word
  • Track Changes and Comments
  • Comparing and Merging Documents
  1. Microsoft Excel: Getting Started
  • Overview of the Excel Interface
  • Creating and Saving Workbooks
  1. Data Entry and Basic Formatting in Excel
  • Entering Data: Text, Numbers, Dates
  • Formatting Cells (Font, Borders, Colors)
  1. Formulas and Functions in Excel
  • Understanding Formulas and Basic Functions
  • Common Functions: SUM, AVERAGE, MIN, MAX
  1. Advanced Functions in Excel
  • Using Logical Functions (IF, AND, OR)
  • Lookup Functions (VLOOKUP, HLOOKUP)
  1. Data Management in Excel
  • Sorting and Filtering Data
  • Creating and Formatting Tables
  1. Creating Charts and Graphs in Excel
  • Different Types of Charts (Bar, Line, Pie)
  • Customizing Chart Elements
  1. Introduction to Microsoft PowerPoint
  • Overview of the PowerPoint Interface
  • Creating and Saving Presentations
  1. Designing Slides in PowerPoint
  • Adding Text, Images, and Multimedia
  • Slide Layouts and Design Themes
  1. Slide Show Features in PowerPoint
  • Transition Effects and Animations
  • Setting Up Slide Show Options
  1. Presentation Skills in PowerPoint
  • Tips for Effective Presentations
  • Practicing Delivery and Timing
  1. Introduction to Microsoft Access (Optional)
  • Overview of Database Concepts
  • Creating a Simple Database
  1. Data Entry and Queries in Access
  • Designing Tables and Forms
  • Creating Basic Queries
  1. Reporting in Microsoft Access
  • Creating Simple Reports
  • Exporting Reports to Other Formats
  1. Internet Basics
  • Understanding Web Browsers and Search Engines
  • Internet Safety and Security
  1. Email Communication
  • Setting Up an Email Account
  • Composing and Sending Emails
  1. Managing Email in MS Outlook
  • Organizing Emails with Folders
  • Using Calendar and Tasks Features
  1. Collaboration Tools in Office Suite
  • Using OneDrive for File Sharing
  • Introduction to Microsoft Teams
  1. Hands-On Practice Sessions
  • Lab Sessions for Word, Excel, PowerPoint, and Access
  • Real-Life Scenarios and Practical Applications
  1. Project Work
  • Application of Skills Learned in a Group or Individual Project
  • Presentation of Project Findings
  1. Assessment and Evaluation
  • Periodic Quizzes and Tests
  • Practical Lab Assessments and Final Examination