Chakchakiya Bazar Malludih, Kasia kushinagar, UP
[email protected]
8957922937
Chakchakiya Bazar Malludih, Kasia kushinagar, UP[email protected]8957922937
Diploma in Computer Applications (DCA) – 6 Months Course
Course Overview:
The 6-month Diploma in Computer Applications (DCA) program is designed to provide students with a solid foundation in computer operations, software applications, and accounting software. This course is ideal for beginners and professionals who want to enhance their computer proficiency.
Course Structure
1. Theory & Lab Sessions:
Each module consists of conceptual learning (theory) followed by hands-on practical lab sessions to ensure deep understanding and application.
2. Course Modules:
Fundamental of Computers (Basic hardware & software concepts)
Operating System (Windows/Linux usage, file management)
Number System (Binary, Decimal, Octal & Hexadecimal conversions)
Typing (Hindi & English) (Speed improvement techniques)
MS Paint (Basic drawing and designing)
MS Office (Word, PowerPoint, Excel – document creation, presentations, spreadsheets)
Project – I (Real-world application of MS Office tools)
Tally Prime (Manual & Computerized Accounting, GST, Ledger, Balance Sheet)
Project – II (Accounting-based project using Tally Prime)
3. Online Learning & MSQ Practice Tests:
Online Portal Access: Students will have access to e-books, video tutorials, and practice materials.
MSQ Practice Tests: Multiple-choice questions (MCQs) after every module to assess learning progress.
4. Assessments & Exams:
Module-wise assignments & quizzes
Mid-term assessment (Theory + Practical)
Final Exam (Comprehensive test including theory, practical & project evaluation)
5. Certification & Marksheet:
Upon successful completion of the course, students will receive:
✔ Marksheet with detailed grades for each module
✔ DCA Certificate recognized by Webminded Computer Institute
This certificate
will enhance job opportunities in offices, banking, and IT sectors.
Fundamental
Operating System
Number System
Typing Hindi & English
Ms Paint
Ms Office (Word, PowerPoint, Excel)
Project - I
Tally Prime ( Mannual Accounting, Accounting Inventory, Voucher Payroll,GST)
Project - II
Fundamental
Operating System
Typing Hindi & English
Ms Office ( Word,Excel,PowerPoint )
Tally Prime ( Manual Accounting, Accounting Inventory,Voucher Payroll,GST )
Graphics Design ( Page Maker , Photoshop , Coreldraw )
Web page Design through HTML
Assembiling & Formatting
Driver Installations ( Printer , VGA , Sound LAN Card etc )
Installation Operating System ( Dos, Windows , XP , Vista 7.8 , Linux )
Software Installation & Computer Security
Hindi Typing
English Typing
Fundamental
Operating System
Typing Hindi & English
Ms- Office ( Word, Excel , PPT )
Mannual Accounting
Tally Prime
Accounting Inventory
Voucher Payroll
GST ( Goods & Service Tax )
PageMaker
Photoshop
Coreldraw
Webpage Design through HTML ,CSS , JS
Assembling
Formatting
Installation Operating System
Driver & Installation
Computer Security
Programming & Problem Solving "c" Language
Software Development through Visual Basic or Java
Introduction to Computer
Introduction to GUI Based Operating System
Ms Office ( Word , Excel , Presentation )
Introduction to Internet and WWW
E- mail, Social Networking & E- Governance Service
Digital Financial Tools & Applications
Overview Of Futureskills & Cyber Security
Fundamental
Operating System
Typing Hindi & English
Manual Accounting
Tally Prime
Accounting Inventory
Voucher Payroll
GST ( Goods & Service Tax )
1.HOME TAB(CLIPBOARD) PART ONE
2.HOME TAB(FONTS---TABLE) PART ONE
3.HOME TAB(FONT COLOR---ALIGNMENT) PART ONE (MS EXCEL)
4.HOME TAB(NUMBERS---STYLES) PART SECOND
5.HOME TAB(CELLS) PART SECOND
6.HOME TAB(EDITING=AUTOSUM) PART SECOND
7.HOME TAB(FILL---FIND _ SELECT) PART SECOND (MS EXCEL)
7.HOME TAB(FILL---FIND & SELECT) PART SECOND (MS EXCEL)
8.PAGE LAYOUT(THEMES---PAGE SETUP)
9.PAGE LAYOUT(SCALE TO FIT---ARRANGE)
10.INSERT TAB (PIVOT TABLE PART ONE) MS EXCEL
11.INSERT TAB(PIVOT TABLE PART TWO)MS EXCEL
12.INSERT TAB(TABLES---CHARTS) MS EXCEL (MS EXCEL)
13.INSERT TAB(SPARKLINES---HEADER _ FOOTER)
13.INSERT TAB(SPARKLINES---HEADER & FOOTER)
14.INSERT TAB(WORD ART---SYMBOLS)
15.FORMULAS TAB PART ONE(INSERT FUNCTION)
16.FORMULAS TAB PART ONE(AUTOSUM)
17.FORMULAS TAB PART ONE(RECENTLY USED---FINANCIAL PART ONE)
18.FORMULAS TAB PART ONE(FINANCIAL PART TWO)
19.FORMULAS TAB(LOGICAL) PART TWO
20.FORMULAS TAB(TEXT)PART TWO
21.FORMULAS TAB(DATE _ TIME)PART TWO
21.FORMULAS TAB(DATE & TIME)PART TWO
22.FORMULAS TAB(LOOK UP & REFERENCE)PART TWO
23.FORMULAS TAB(VLOOK UP+H LOOK UP+MATCH+LOOK UP) PART THIRD
24.FORMULAS TAB(INDEX+TRANSPOSE)PART THIRD
25.FORMULAS TAB(MATH _ TRIG.+MORE FUNCTIONS)PART THIRD
26.1FORMULAS TAB(DEFINED NAMES)PART THIRD
26.2FORMULAS TAB(FORMULA AUDITING+CALCULATION)PART THIRD
27.DATA TAB(GET EXTERNAL DATA) PART ONE
28.DATA TAB(CONNECTIONS) PART ONE
28.DATA TAB(SORT _ FILTER)PART ONE
28.DATA TAB(SORT & FILTER)PART ONE
29.DATA TAB(TEXT TO COLUNMS---DATA VALIDATION) PART ONE
30.DATA TAB(CONSOLIDATE---SCENARIO)PART TWO
31.DATA TAB(GOAL SEEK) PART TWO
32.DATA TAB(DATA TABLE)PART TWO
33.DATA TAB(OUTLINE)PART TWO
34.VIEW TAB(WORKBOOK VIEWS)MS EXCEL
35.VIEW TAB(SHOW---WINDOW)MS EXCEL
36.VIEW TAB(SAVE WORKSPACE---MACROS)MS EXCEL
37.REVIEW PROOFING TAB(SPELLING)
38.REVIEW PROOFING TAB(RESEARCH---COMMENTS)
39.REVIEW PROOFING TAB(PROTECTSHEET---PROTECTWORKBOOK)
40.REVIEW PROOFING TAB(SHAREWORKBOOK---TRACKCHANGES) (MS EXCEL)
41.FILE TAB IN MS EXCEL (MS EXCEL)
