Diploma in Computer Application (DCA)
Computer Fundamentals & MS Word
Focus: Documentation and Word Processing
Computer Basics: Hardware vs. Software, Operating Systems (Windows 10/11), and File Management.
Introduction to MS Word: Interface, Ribbon, and Quick Access Toolbar.
Editing & Formatting: Font styles, paragraph alignment, bullets, and numbering.
Advanced Layouts: Page setup, columns, breaks, and Watermarks.
Tables & Illustrates: Creating tables, inserting shapes, SmartArt, and Clip Art.
References & Tools: Mail Merge (Labels/Envelopes), Table of Contents, and Spell Check.
MS Excel
Focus: Data Analysis and Spreadsheet Management
Excel Basics: Cells, Rows, Columns, and Worksheet Navigation.
Formulas & Functions: Sum, Average, Count, Min/Max, and Logical functions (IF, AND, OR).
Data Visualization: Creating and formatting 2D/3D Charts and Sparklines.
Data Management: Sorting, Filtering, Data Validation, and Goal Seek.
Advanced Features: VLOOKUP/HLOOKUP, Pivot Tables, and Pivot Charts.
Protection: Locking cells and protecting workbooks.
MS PowerPoint & MS Outlook
Focus: Data Analysis and Spreadsheet Management
Excel Basics: Cells, Rows, Columns, and Worksheet Navigation.
Formulas & Functions: Sum, Average, Count, Min/Max, and Logical functions (IF, AND, OR).
Data Visualization: Creating and formatting 2D/3D Charts and Sparklines.
Data Management: Sorting, Filtering, Data Validation, and Goal Seek.
Advanced Features: VLOOKUP/HLOOKUP, Pivot Tables, and Pivot Charts.
Protection: Locking cells and protecting workbooks.
CorelDraw (Part 1)
Focus: Vector Graphic Design Basics
Interface Overview: Toolbox, Property Bar, and Color Palettes.
Drawing Tools: Rectangle, Ellipse, Polygon, and Spiral tools.
Shaping Objects: Pick tool, Shape tool, Smudge, and Roughen.
Curve Editing: Using the Pen tool and Bezier tool for custom paths.
Color Theory: Uniform fills, Fountain fills, and Mesh fills.
CorelDraw (Part 2) & Design Projects
Focus: Advanced Design and Commercial Printing
Text Handling: Artistic vs. Paragraph text, fitting text to paths.
Effects: Drop Shadow, Transparency, Contour, Blend, and PowerClip.
Vector vs. Raster: Converting bitmaps to vectors (PowerTrace).
Real-world Projects: * Logo Design.
Business Cards & Letterheads.
Brochures and Social Media Banners.
Tally Prime
Focus: Computerized Accounting and GST
Accounting Basics: Golden Rules of Accounting, Ledgers, and Groups.
Company Management: Creating, altering, and deleting companies in Tally Prime.
Voucher Entry: Payment, Receipt, Contra, Sales, and Purchase vouchers.
Inventory Management: Stock Groups, Items, and Units of Measure.
Taxation (GST): Enabling GST, CGST/SGST/IGST calculations, and GSTR reports.
Financial Reporting: Generating Profit & Loss A/c, Balance Sheets, and Day Books.