ARJAN INFOTECH

Diploma in Computer Applications (DCA) — Complete Course Content

Duration: 6 Months | Total Lectures: 200 | Total Hours: 300

Subject-wise detailed content

1. Computer Fundamentals — 15 Lectures

1. Introduction to computers
2. History and generations of computers
3. Types and applications of computers
4. Hardware and software
5. Input and output devices
6. CPU, ALU and control unit
7. RAM, ROM and storage devices
8. Operating systems
9. Computer memory and storage units
10. Number systems — basic introduction
11. Computer networking fundamentals
12. Introduction to LAN, WAN and the internet
13. Computer viruses and antivirus
14. Basic troubleshooting
15. Practical test and revision

2. Windows & File Management — 10 Lectures

1. Windows introduction and desktop
2. Start menu, taskbar and settings
3. Files and folders
4. Copy, cut, paste, rename and delete
5. Recycle Bin and file recovery
6. File extensions and file types
7. Installing and uninstalling software
8. USB drives and external storage
9. Printing and PDF management
10. Practical assignment

3. English Typing — 10 Lectures

1. Keyboard introduction
2. Home-row keys
3. Finger positioning
4. Upper-row and lower-row practice
5. Capital letters and punctuation
6. Number keys and symbols
7. Paragraph typing
8. Accuracy improvement
9. Speed tests
10. Final typing test

4. MS Word — 25 Lectures

1. Introduction to MS Word
2. Creating, opening and saving documents
3. Text selection and editing
4. Font formatting
5. Paragraph formatting and alignment
6. Line spacing and indentation
7. Bullets and numbering
8. Borders and shading
9. Page margins and orientation
10. Page size and page breaks
11. Header and footer
12. Page numbering
13. Inserting tables
14. Table formatting
15. Pictures and shapes
16. SmartArt and WordArt
17. Find and replace
18. Columns and tab settings
19. Mail merge
20. Labels and envelopes
21. Resume preparation
22. Official letters and applications
23. Reports and notices
24. Printing and PDF export
25. Complete practical project

5. MS Excel — 35 Lectures

1. Introduction to Excel
2. Workbook and worksheet
3. Rows, columns and cells
4. Data entry and editing
5. Cell formatting
6. Number, date and currency formats
7. Basic formulas
8. SUM, AVERAGE and COUNT
9. MIN and MAX
10. Relative and absolute references
11. IF function
12. AND and OR functions
13. SUMIF and COUNTIF
14. SUMIFS and COUNTIFS
15. IFERROR function
16. LEFT, RIGHT and MID
17. LEN, TRIM and CONCAT
18. TODAY and NOW
19. Date and time calculations
20. VLOOKUP
21. HLOOKUP
22. XLOOKUP
23. Sorting data
24. Filtering data
25. Conditional formatting
26. Data validation and drop-down lists
27. Remove duplicates and text tools
28. Charts and graphs
29. PivotTables
30. PivotCharts
31. Printing and page setup
32. Student attendance sheet
33. Student fee management sheet
34. Salary and sales reports
35. Final Excel dashboard project

6. MS PowerPoint — 12 Lectures

1. Introduction to PowerPoint
2. Creating and saving presentations
3. Slide layouts and themes
4. Text formatting
5. Pictures and shapes
6. Tables and charts
7. SmartArt
8. Slide transitions
9. Animations
10. Hyperlinks and action buttons
11. Slide show and presentation delivery
12. Final presentation project

7. Internet & Email — 15 Lectures

1. Introduction to the internet
2. Web browsers and search engines
3. Effective online searching
4. Creating and using email
5. Sending and replying to emails
6. Attachments and downloads
7. Email CC and BCC
8. Professional email writing
9. Online forms
10. Uploading documents
11. Cloud storage
12. Online meetings
13. Cybersecurity and password safety
14. Phishing and online fraud awareness
15. Practical assessment

8. Tally, Accounting & GST — 30 Lectures

1. Introduction to accounting
2. Accounting principles
3. Assets, liabilities, capital, income and expenses
4. Debit and credit rules
5. Journal entries
6. Ledger accounts
7. Trial balance
8. Introduction to Tally
9. Company creation
10. Accounting groups and ledgers
11. Payment vouchers
12. Receipt vouchers
13. Contra vouchers
14. Journal vouchers
15. Sales vouchers
16. Purchase vouchers
17. Credit notes and debit notes
18. Inventory introduction
19. Stock groups and stock items
20. Units of measurement
21. Godowns and stock management
22. GST fundamentals
23. GST configuration in Tally
24. GST sales entries
25. GST purchase entries
26. Tax invoices
27. GST reports
28. Bank reconciliation
29. Profit and loss account and balance sheet
30. Complete accounting practical project

9. Graphic Design & Canva — 15 Lectures

1. Introduction to graphic design
2. Colours, fonts and typography
3. Design principles and layouts
4. Canva introduction
5. Canva tools and templates
6. Social media post design
7. Promotional poster design
8. Flyer design
9. Brochure design
10. Logo design basics
11. Image cropping and editing
12. Background removal
13. Text effects and visual elements
14. Exporting designs for print and digital use
15. Final promotional design project

10. HTML & CSS — 15 Lectures

1. Introduction to websites
2. HTML structure
3. Headings and paragraphs
4. Text formatting and lists
5. Hyperlinks
6. Images
7. Tables
8. Forms and input fields
9. HTML attributes
10. Introduction to CSS
11. Colours and backgrounds
12. Fonts and text styling
13. Margins, padding and borders
14. Basic page layouts
15. Build a simple institute webpage

11. AI Tools & Productivity — 8 Lectures

1. Introduction to artificial intelligence
2. Generative AI and AI tools
3. Writing effective prompts
4. AI-assisted letters and documents
5. AI for Excel learning and formulas
6. AI-assisted presentations
7. AI-assisted graphic design
8. Responsible AI use, privacy and fact-checking

12. Practical Projects & Final Examination — 10 Lectures

1. Computer fundamentals revision
2. Typing and Word practical
3. Excel formulas practical
4. Excel reporting practical
5. PowerPoint practical
6. Internet and email practical
7. Tally accounting practical
8. Graphic design practical
9. HTML webpage project
10. Final theory exam, practical exam and viva

Recommended certificate title: Diploma in Computer Applications (DCA) — Arjan Infotech.