DCA
Diploma in Computer Application
1
Basics of Computer
- What is a Computer? · Data vs Information · Pros/Cons · History · Generations
- Applications in various fields · Intro to AI
2
Types of Computers
- By size/capacity: Micro · Mini · Mainframe · Super
3
Computer Architecture & Components
- Input · Processing · Output devices · Hardware vs Software · System Unit · Abbreviations
- Module‑End Test: Basics of Computer
4
Microsoft Windows OS
- Programs · File Explorer/This PC · Control Panel · Shortcuts
- Module‑End Test: Microsoft Windows
5
MS Word 2019
- Editing/Formatting · Paragraph/Page setup · Graphics · Spell/Grammar · Mail Merge · Macros · Printing
- Shortcuts · Module‑End Test: Word
6
MS Excel 2019
- Formatting · Functions (SUM, IF, VLOOKUP) · Conditional Formatting · Sort/Filter
- Pivot Tables & Charts · Shortcuts · Module‑End Test: Excel
7
MS PowerPoint 2016
- Slides · Objects · Animations & Transitions · Shortcuts · Module‑End Test: PowerPoint
8
MS Access 2016
- Tables · Queries · Forms · Reports · Shortcuts · Module‑End Test: Access
9
Internet & Email
- Basics of Networking · Safe Internet usage · Creating/Using Emails
- Module‑End Test: Internet & Email