D.C.A.
Diploma in Computer Application
COURSE SYLLABUS
Semester -I
FUNDAMENTALS OF COMPUTER
- Introduction of Computer
- Definition of Computer
- Data, Information, Database
- Uses of Computer
- Functions of Computer
- Features of Computer
- Concept of INPUT, PROCESS and OUTPUT
- Block Diagram of Computer
- Anatomy of Computer, Hardware and Software
- Units of Computer
- Input, System and Output Units
- Data Representation
- Binary Digits, Byte, Kilobytes, Megabytes, Gigabytes Terabytes etc.
- Number System
- History and Generations of Computer
- Computer Devices -The Hardware
- Input, Storage and Output Devices
- Driving the Computer- The Software
- Digital Computer, Analog Computer
- Hybrid Computer, Super Computer, Mainframes Computer,
- Mini Computer, Micro Computer
- System Software
- Applications Software
TYPING SKILLS
• Introduction to Computer Keyboard
• Understanding Different Types of Keys (Alphabet Keys, Number Keys, Function Keys, Special Keys)
• Introduction to Touch Typing Method
• Correct Sitting Posture and Hand Position on Keyboard
• Home Row Keys Practice (A S D F J K L 😉
• Finger Placement and Basic Typing Exercises
• Practice of Top Row Keys and Bottom Row Keys
• Typing Practice with Letters, Words and Sentences
• Typing Practice with Numbers and Symbols
• Use of Shift Key and Special Characters
• Speed Typing Practice
• Accuracy Improvement Techniques
• Typing Practice using Paragraphs and Passages
• Typing Practice using Official Letter and Application Format
• Introduction to Typing Software and Tools
• Basic Knowledge of English Typing Tests
• Typing Speed Test Preparation (WPM – Words Per Minute)
• Accuracy and Error Correction Practice
• Practical Typing Exercises and Daily Practice Sessions
MICROSOFT WINDOWS
• Introduction of Operating System
• Definition of Operating System
• Types of Operating System
• What is Windows?
• Desktop, Wallpaper, Icon, Taskbar, Start Menu
• Windows Accessories- Paint, WordPad, Notepad, Calculator
• Control Panel – Programs and Features, Keyboard, Mouse, Power Options, Fonts, Sounds etc.
• Windows Explorer
• File Management, File and Folder Operations
• Creating Files and Folder
• Copy, Move, Rename and Delete files and Folders
• Recycle Bin
• Searching Files and Folders
• System Settings
• Installing and Uninstalling Software
• User Account
• Disk Management
• Disk Defragmentation
• Disk Clean up
• Disk Management
• Basic Troubleshooting and many more.
MICROSOFT WORD
• Introduction of Microsoft Office
• Introduction of Word Processing Software Microsoft Word
• Creating and Saving Documents
• Opening and Closing Documents
• Editing Text
• Page Setup – Paper Size, Orientation, Margins, Gutter
• Moving around the document with keyboard shortcuts
• Protect Documents with password
• Text Formatting with keyboard shortcuts
• Advance Text Formatting
• Advance Paragraph Formatting
• Find, Replace and GoTo
• Change Case – Upper case, Lower case, Sentence case, Capitalize Each Word case, toggle case
• Headers and Footers
• Bullet and Numbering
• Borders and Shading
• Inserting Images, Shapes, 3D Model, SmartArts, Charts, Screenshot, WordArt
• Page Colour and Watermark
• Tabs
• Columns
• Spelling and Grammar
• Page Break and Section Break
• Table
• Table Keyboard Shortcuts
• Hyperlink, Cross Reference
• Mail Merge
• Printing Documents and many more.
MICROSOFT EXCEL
• Introduction of Microsoft Excel
• Introduction of Worksheet or Spreadsheet or Sheet
• Parts or Components of Excel Window
• Moving around the Worksheet with keyboard shortcuts
• Inserting Row, Column and Sheet
• Deleting Row, Column and Sheet
• Formatting Cells, Row, Column and Sheet
• Hide and Unhide Row, Column and Sheet
• Rename Sheet, Change Tab Colour of Sheet
• Data Entry and Editing
• Creating and Managing Databases
• Protecting Worksheet with password
• Formula or Functions in Excel
• Mathematical Function
• Text Function
• Date and Time Function
• Logical Function
• Financial Function
• Inserting and Formatting Charts and Graphs (Column, Pie, etc.)
• Conditional Formatting
• Sorting and Filtering Data
• Auditing – Trace Precedent, Trace Dependent, Remove All
• Pivot Tables
• Data Validation
• Page Setup and Printing and many more.
MICROSOFT POWERPOINT
• Introduction of Presentation Software
• Features of Microsoft PowerPoint
• Creating and Showing Presentation
• Creating Slides, Slide Layouts and Themes
• Inserting Text, Images, Shapes, SmartArts and Charts
• Slide Formatting
• Slide Transitions and Animations
• Slide Show, Custom Show
• Inserting Audio and Video in presentation
• Presentation Design Techniques
• Printing Handouts
• Exporting Presentation in mp4 video Format and many more.
CONCEPT OF INTERNET AND INTRANET
• Introduction to Internet and Intranet
• History and development of the Internet
• Basic concepts and working of the Internet
• Difference between Internet, Intranet and Extranet
• Types of Computer Networks – LAN, MAN, WAN
• Network devices – Modem, Router, Switch and Hub
• Internet Service Provider (ISP) and Internet connection types
• Web Browser and its features
• Popular Web Browsers – Google Chrome, Mozilla Firefox, Microsoft Edge
• Internet Browsing and searching information on the web
• Understanding Website, Web Page, URL and Hyperlink
• Search Engines and their use – Google, Bing, Yahoo
• Downloading and uploading files from the Internet
• Online communication and collaboration
• Introduction to E-mail (Electronic Mail)
• Creating and managing an E-mail account
• Sending, receiving, replying and forwarding E-mails
• Using CC, BCC and attaching files in E-mail
• Internet safety and security basics
• Safe browsing practices and protection from viruses
• Basic awareness of cyber security and online privacy
Semester -II
TALLY
• Introduction to Commerce, Book Keeping and Accountancy
• Basic Accounting Concepts and Principles
• Golden Rules of Accounting
• Understanding Journal Entries and Ledger Posting
• Preparation of Trial Balance
• Preparation of Trading Account, Profit and Loss Account and Balance Sheet
• Introduction to Tally ERP 9 and TallyPrime (Latest Version)
• Downloading and Installing Tally at Default Location and Custom Location
• How to Start and Open Tally
• Understanding Tally Startup Screen and Gateway of Tally
• Creating, Altering and Deleting Company in Tally
• Creating and Managing Ledgers and Groups
• Understanding Accounting Voucher Types
• Passing Payment Voucher, Receipt Voucher, Contra Voucher and Journal Voucher
• Sales Voucher and Purchase Voucher Entry
• Debit Note and Credit Note Entry
• Viewing Trial Balance, Profit and Loss Account and Balance Sheet
• Day Book, Cash Book and Bank Book
• Outstanding Reports and Account Statements
• Introduction to Inventory Management in Tally
• Creating Stock Group, Stock Category and Stock Items
• Creating Unit of Measurement
• Managing Godown or Warehouse
• Stock Summary and Inventory Reports
• Accounts with Inventory
• Recording Sales and Purchase with Inventory
• Introduction to GST (Goods and Services Tax)
• Understanding CGST, SGST and IGST
• Enabling GST in Tally
• Creating GST Ledgers and Stock Items with GST
• Recording GST Purchase and Sales Entries
• Viewing GST Reports
• Invoice Creation in Tally
• Adding Company Logo in Invoice
• Printing Sales Invoice and Purchase Invoice
• Payroll Management in Tally
• Creating Employee Groups and Employees
• Creating Salary Ledgers and Pay Heads
• Generating Payroll Voucher
• Creating and Printing Pay Slip
• Data Backup and Restore in Tally
• Security Control and User Management
• Basic Tally Shortcuts and Practical Working
ADOBE PAGEMAKER
• Introduction to Desktop Publishing (DTP)
• Introduction to Adobe PageMaker and its Uses
• Understanding PageMaker Interface and Workspace
• Creating a New Document
• Page Size, Orientation and Margin Settings
• Understanding Rulers, Guides and Grid
• Working with Pages and Master Pages
• Adding, Deleting and Rearranging Pages
• Page Numbering and Page Layout Management
• Working with Text Frames
• Typing and Editing Text
• Text Formatting (Font, Size, Style and Alignment)
• Paragraph Formatting and Indentation
• Working with Columns and Text Flow
• Importing Text from MS Word
• Working with Graphics and Images
• Placing Images into the Document
• Resizing, Cropping and Positioning Images
• Drawing Shapes and Using Graphic Tools
• Working with Lines, Boxes and Polygons
• Creating Tables and Tab Settings
• Using Color and Fill Options
• Designing Visiting Cards, Letterheads and Brochures
• Designing Pamphlets, Posters and Book Pages
• Working with Layers and Object Arrangement
• Aligning and Grouping Objects
• Spell Check and Find & Replace
• Preparing Documents for Printing
• Printing Documents and Print Settings
• Exporting Files for Publishing
• Practical Projects in PageMaker
ADOBE INDESIGN
- Introduction to Desktop Publishing (DTP) and Professional Page Layout Designing
- Introduction to Adobe InDesign and its Features
- Understanding InDesign Interface and Workspace
- Creating New Documents and Document Setup
- Page Size, Orientation, Margins and Columns Settings
- Understanding Tools of Toolbar
- Selection Tool and Direct Selection Tool
- Page Tool and Gap Tool
- Content Collector Tool and Content Placer Tool
- Type Tool and Type on a Path Tool
- Pen Tool and Anchor Point Tools (Add, Delete and Convert Direction Point)
- Rectangle Frame Tool, Ellipse Frame Tool and Polygon Frame Tool
- Scissors Tool and Free Transform Tool
- Rotate Tool, Scale Tool and Shear Tool
- Gradient Swatch Tool and Gradient Feather Tool
- Note Tool and Color Theme Tool
- Eyedropper Tool and Measure Tool
- Hand Tool and Zoom Tool
- Working with Text and Typography
- Font and Text Size Management
- Character Formatting and Paragraph Formatting
- Using Tabs and Glyphs
- Character Styles and Paragraph Styles
- Changing Text Case
- Creating Bulleted and Numbered Lists
- Inserting Special Characters and Symbols
- Object Management and Layout Control
- Object Transform and Transform Again
- Arranging Objects (Bring Forward, Send Backward)
- Selecting Multiple Objects
- Grouping and Ungrouping Objects
- Locking and Unlocking Objects on Spread
- Generating QR Codes in InDesign
- Working with Text Frames and Text Frame Options
- Object Fitting and Image Placement
- Applying Effects and Transparency
- Working with Paths and Pathfinder
- Converting Shapes and Working with Shapes
- Working with Tables
- Creating Tables and Table Formatting
- Table Styles and Table Options
- View Options and Page Display
- Fit Page in Window
- Fit Spread in Window
- Actual Size View
- Entire Pasteboard View
- Working with Images and Graphics Placement
- Importing and Managing Graphics
- Image Alignment and Layout Adjustment
- Working with Master Pages (Parent Pages)
- Applying Styles and Formatting
- Page Layout and Multi-page Document Design
- Designing Practical Projects
- Visiting Card Design
- Pamphlet and Brochure Design
- Magazine Layout Design
- Newspaper Layout Design
- Book Page Layout Design
- Preparing Documents for Printing and Export
ADOBE ILLUSTRATOR
• Introduction to Vector Graphics and Graphic Design
• Introduction to Adobe Illustrator and its Features
• Understanding Vector Graphics vs Raster Graphics
• Understanding Illustrator Interface and Workspace
• Creating New Documents and Document Setup
• Understanding Toolbar and Drawing Tools
• Selection Tool and Direct Selection Tool
• Pen Tool and Curvature Tool for Creating Shapes and Paths
• Rectangle Tool, Ellipse Tool, Polygon Tool and Star Tool
• Line Segment Tool and Shape Creation Tools
• Eraser Tool and Scissors Tool
• Gradient Tool and Gradient Mesh Tool
• Eyedropper Tool and Width Tool
• Blend Tool and Artboard Tool
• Zoom Tool and Navigation Tools
• Working with File and Edit Options
• Document Setup and Artboard Settings
• Preferences and Workspace Customization
• Paste in Front, Paste in Back and Paste in Place
• Find and Replace Objects
• Working with Objects and Layout Management
• Object Transform and Object Arrangement
• Object Alignment and Distribution
• Grouping and Ungrouping Objects
• Locking and Unlocking Objects
• Expanding Objects and Expand Appearance
• Working with Slices and Export for Web
• Working with Paths and Shape Builder
• Creating and Editing Patterns
• Creating Blend Effects
• Using Envelope Distort
• Converting Raster Images to Vector using Image Trace
• Working with Text Wrap
• Applying Effects and Styles
• 3D and Materials Effects
• Convert to Shape Effects
• Distort and Transform Effects
• Pathfinder and Shape Effects
• Stylize Effects and Effect Gallery
• Using Artistic Effects
• Blur Effects
• Brush Stroke Effects
• Distort Effects
• Pixelate Effects
• Sketch Effects
• Stylize Effects
• Texture Effects
• View Options and Workspace Navigation
• Outline View and Pixel Preview
• Zoom In and Zoom Out
• Fit Artboard in Window
• Fit All Artboards in Window
• Viewing Artwork at Actual Size
• Working with Typography in Illustrator
• Adding and Editing Text
• Text Formatting and Character Settings
• Working with Colors and Gradients
• Applying Fill and Stroke Colors
• Creating Color Swatches and Gradients
• Designing Practical Projects
• Logo Design
• Icon Design
• Visiting Card Design
• Poster and Banner Design
• Brochure and Social Media Graphics
• Preparing Artwork for Print and Digital Media Export
ADOBE PHOTOSHOP
• Introduction to Image Editing and Digital Graphics
• Introduction to Adobe Photoshop and its Features
• Understanding Photoshop Interface, Workspace, Tools and Panels
• Creating New Documents and Opening Images
• Image Cropping, Resizing and Canvas Size Adjustment
• Basic Photo Editing and Color Correction
• Brightness, Contrast and Color Balance Adjustment
• Hue, Saturation and Image Enhancement Techniques
• Working with Selection Tools
• Rectangular Marquee Tool and Elliptical Marquee Tool
• Single Row Marquee Tool and Single Column Marquee Tool
• Lasso Tool, Polygon Lasso Tool and Magnetic Lasso Tool
• Object Selection Tool, Quick Selection Tool and Magic Wand Tool
• Working with Crop and Slice Tools
• Crop Tool and Perspective Crop Tool
• Slice Tool and Slice Selection Tool
• Working with Measurement and Utility Tools
• Frame Tool
• Eyedropper Tool and Color Sampler Tool
• Ruler Tool, Note Tool and Count Tool
• Photo Retouching and Image Correction
• Spot Healing Brush Tool and Remove Tool
• Healing Brush Tool and Patch Tool
• Content-Aware Move Tool and Red Eye Tool
• Working with Painting Tools
• Brush Tool and Pencil Tool
• Color Replacement Tool and Mixer Brush Tool
• Clone and History Tools
• Clone Stamp Tool and Pattern Stamp Tool
• History Brush Tool and Art History Brush Tool
• Working with Eraser Tools
• Eraser Tool
• Background Eraser Tool
• Magic Eraser Tool
• Working with Color and Gradient Tools
• Gradient Tool and Paint Bucket Tool
• Photo Enhancement Tools
• Dodge Tool, Burn Tool and Sponge Tool
• Working with Drawing and Path Tools
• Pen Tool and Path Creation
• Shape Tools (Rectangle Tool, Ellipse Tool, Triangle Tool, Polygon Tool, Line Tool and Custom Shape Tool)
• Working with Text and Typography
• Horizontal Type Tool and Vertical Type Tool
• Horizontal Type Mask Tool and Vertical Type Mask Tool
• Text Formatting and Text Effects
• Working with Layers and Layer Management
• Layer Panel and Layer Creation
• Layer Styles and Layer Effects
• Layer Mask and Clipping Mask
• Applying Filters and Effects
• Filter Gallery and Artistic Effects
• 3D Filters
• Blur and Blur Gallery Effects
• Distort Effects
• Noise Effects
• Pixelate Effects
• Sharpen Effects
• Background Removal Techniques
• Photo Manipulation and Creative Effects
• Logo Design and Banner Design using Photoshop
• Preparing Images for Print and Digital Media
• Saving and Exporting Files in Different Formats