ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
धामणगाव एजुकेशन सोसायटी खाजगी औद्योगिकी प्रशिक्षण संस्था , धामणगाव रेल्वे
2
अभ्यास विश्लेषण तक्ता [WEEKLY Spilt Up Syllabus]
3
आठवडा क्र.प्रात्यक्षिक क्रमांक व नाव प्रात्यक्षिक मध्ये अंतर्भूत केलेले कौशल्य सैद्धांतिक पाठ क्रमाक व पाठाचे नाव सैद्धांतिक पाठ मध्ये घावयाच्या माहितीचा संशिप्त तपशील शेरा
4
WEEK 11. Visit COPA Lab. of the institutes and locate the electrical connections with computer system setup1. Safe working practices
·      Scope of the COPA trade.
5
2. Identifying safety symbols and hazard identification.
·     Safety rules and safety signs.
6
3. Practice safe methods of fire fighting in case of electrical fire.
·      Types and working of fire extinguishers.
7
4. Use of fire extinguishers2. Introduction to Computer components
·       Introduction to computer system. Concepts of Hardware and Software.
8
5. Identify computer peripherals and internal components of a
disassembled desktop computer.
·    Function of motherboard components and various processors.
9
6.. Assemble components of
desktop computer
·         Various Input/ Output devices in use and their features.
10
WEEK 27. Practice on Windows interface and navigating windows. (7Hrs)
8. Practice on managing files and folders using removable drives. (5Hrs)
9. Customize the desktop
settings and manage user accounts. (5Hrs)
10. View system properties and control panel details. (5Hrs)
11. Work with keyboard shortcut commands. (5Hrs)
12. Print and scan document using different commands.
(3 Hrs)
3.Introduction Windows Operating System• Introduction to operating System
• Main features of Windows OS
• Concept of various shortcut commands.
11
WEEK 3
13. View the BIOS settings and their modifications. (3 Hrs)
14. Install Windows operating system. (5 Hrs)
15. Format hard disk and create partition. (3 Hrs)
16. Identify and rectify common hardware and software issues during OS installation. (4 Hrs)
17. Install necessary application software for Windows i.e. Office Package, PDF Reader, Media Player etc. (5 Hrs)
18. Configure Bluetooth and wi- fi settings. (3 Hrs)
19. Install Drivers for printer, scanner, webcam and DVD etc. (4 Hrs)
20. Burn data, video and audio files on CD/DVD using
application software. (3 Hrs)
4.Computer basics and Software Installation• Introduction to the booting process.
• Introduction to various types of memories and their features.
• Basic Hardware and software issues and their solutions.
• Usage of Application software and Antivirus.
12
WEEK 421. Use basic DOS commands for directory listing. (10 Hrs)
22. Manage files and folders using DOS commands. (6 Hrs)
23. Install Linux operating system. (6 Hrs)
24. Install necessary application software for Linux i.e. Office Package, PDF Reader, Media Player etc. (6 Hrs)
5. Introduction to DOS Command Line Interface & Linux Operating Systems
·         Introduction to basic DOS Internal and External Commands .Introduction to Open Source Software.
13
WEEK 525. Use Basic Linux commands for directory listing, file and folder management, password etc. (10 Hrs)
26. Use the Linux graphical user interface for file and folder management, exploring the system etc. (10 Hrs)
27. Customize desktop settings and manage user accounts in Linux. (6 Hrs)
28. View system properties and
manage system setting in Linux. (6 Hrs)
• Introduction to Linux Operating System features, structure, files and processes.
• Basic Linux commands.
14
WEEK 629. Open MS Word and familiarise with basic word components. (3 Hrs)
30. Practice creating, saving and renaming of word documents. (3 Hrs)
31. Edit document using basic formatting tools. (8 Hrs)
32. Practice Inserting and formatting tables and other objects. (12 Hrs)
33. Work with Page layout settings and printing documents. (6 Hrs)
6.Word Processing Software• Introduction to the various applications in MS office.
• Introduction to Word features, Office button, toolbars.
15
WEEK 734. Use templates, autocorrect tools, and record and execute a macro. (6 Hrs)
35. Use Mail merge tool. Use conditional Mail Merge, External Data Source. Practice Letters, Label & Envelop printing using Mail Merge. (10 Hrs)
36. Use Table of Context, Indexing, Hyperlink,
Bookmark, Comment, equation, symbols, citation, cross-reference, footnote, translate, synonyms, thesaurus, spell check &grammar, compare etc. ( 6 Hrs )
37. Practice Typing using open source typing tutor. 		• Creating, saving and formatting and printing documents using Word.
16
WEEK 838. Practice of using shortcut
keys and use Open Office as word processor.
·         Working with objects, macro, mail merge, templates and other tools in Word.
17
WEEK 939. Open MS Excel and familiarise with basic application components. (4 Hrs)
40. Practice creating, saving and formatting excel spread sheets. (9 Hrs)
41. Use absolute and relative referencing, linking sheets, conditional formatting etc. (9 Hrs)
42. Practice Excel functions of all major categories i.e. Financial, Logical, Text, date & time, Lookup, Math, Statistical etc. (12 Hrs)
7.Spread Sheet Application• Introduction to Excel features and Data Types.
• Cell referencing and linking Sheets.
18
WEEK 1043. Use various data types in
Excel, sorting, filtering and validating data. (8 Hrs)		• Introduction to various functions in all categories of Excel.
• Concepts of sorting, filtering and validating data.
19
WEEK 1144. Create and format various static and dynamic charts. (10 Hrs)
45. Practice Importing & exporting excel data. (4 Hrs)
46. Perform data analysis using “what if” tools and Pivot Table and record and execute a macro. (10 Hrs)
• Analyzing data using charts, data tables, pivot tables, goal seek and scenarios.
20
WEEK 1247. Modify Excel page setup and printing and use open office as Spreadsheet application. (4 Hrs)
48. Execute simple projects
using Excel & Word. (20 Hrs)
8. Image editing, Presentations• Introduction to Open Office.
• Introduction to the properties and editing of images.
• Introduction to different formats of images and their uses.
21
WEEK 1349. Use Windows Paint or image editing software like Open Office Draw, GIMP, Irfan View or a similar tool. (6 Hrs)
50. Perform Image editing using open source applications. (12 Hrs)
51. Open power point presentation and familiarise with basic application components. (6 Hrs)
52. Create Slide shows, Insert picture and theme. (6 Hrs)
• Introduction to Power Point and its advantages.
• Creating Slide Shows.
• Fine tuning the presentation and good presentation technique.
22
WEEK 1453. Add new slide, format text, link with word and excel documents. (5 Hrs)
54. Practice animating slide transitions and objects. (4 Hrs)
55. Create slide shows by
inserting audio & video and
synchronise with presentation. (6 Hrs)
56. Modify slide page setup and print the slides. (3 Hrs)
57. Create a simple presentation project using
open office. (12 Hrs)
9. Database Management Systems• Concepts of Data and Databases.
• Overview of popular databases, RDBMS, OODB and NOSQL.
• Rules for designing good tables. Integrity rules and constraints in a table.
• Relationships in tables.
23
WEEK 1558. Create database and design a simple tables in Access. (6 Hrs)
59. Practice enforcing integrity constraints and modify properties of tables and fields. (6 Hrs)
60. Create relationships and join tables. (6 Hrs)
61. Create and format Forms. (6 Hrs)
62. Create simple queries with various criteria and calculations. (12 Hrs)
• Introduction to various types of Queries and their uses.
• Designing Access Reports and Forms.
• Introduction to macros, designer objects controls, their properties and behaviour.
24
WEEK 1663. Create Simple update, append, make table, delete and crosstab queries. (9 Hrs)
64. Modify form design with controls, macros and events. (6 Hrs)
65. Import and export data to and from Access and create and format various types of reports. (6 Hrs)
66. Compress and Encrypt
databases. (3 Hrs)
10. Networking Concepts• Introduction to Computer Networks,
Necessity
• Client Server and peer to Peer networking concepts.
• Concept of Proxy Server and proxy firewall server.
• Concept of DHCP Server.
• Network topologies. Introduction to LAN, WAN and MAN.
25
WEEK 1767. View Network connections. Connect a computer to a network and share Devices
i.e. Printers, files, folders and drives. (6 Hrs)
69. Work with various Network devices, connectors and cables. Create straight and cross cable and punch a UTP cable in the patch socket and test the connectivity. (6 Hrs)
70. Practice IP Addressing and Subnet masking for IPV4/ IPV6 and pinging to test networks. (6 Hrs)
71. Configure Hub and Switch. (6 Hrs)
• Network components, viz. Modem, Hub, Switch, Router, Bridge, Gateway etc.
• Network Cables, Wireless networks and Blue Tooth technology.
• Concept of ISO - OSI 7 Layer Model.
• Overview of various Network protocols Viz. TCP/IP, FTP, Telnet etc.
• Concept of Logical and Physical Addresses, Subnetting and Classes of Networks.
26
WEEK 1872. Set up and configure wired and wireless LAN in a Computer Lab within at least three computers. Use patch panel & I/O Box for wired LAN and installing & configuring Internet connection in a single PC and in a LAN. (12 Hrs)
73. Set up a proxy server/ DHCP Server with firewall. (9 Hrs)
74. Set up video conferencing using open source software. (6 Hrs)
75. Use various tools (by open source /free) for network troubleshooting, maintenance and security for both Wired and
Wireless(6 Hrs)
11. Internet Concepts• Introduction to www, Concept of Internet, Web Browsers, internet servers and search engines.
• Concepts of Domain naming Systems and E mail communication.
• Introduction to video chatting tools and Social Networking concepts.
27
WEEK 19Browse the Internet for information (use at least 3 popular browsers). (3 Hrs)
77. Create and use e-mail for communication with attachment, priority setting, address book. (3 Hrs)
78. Communicate with text, video chatting and social networking sites. (6 Hrs)
79. Use online dictionary, translation software, storage space, share files with e-mail links, download manager, download & upload YouTube files, google map & earth etc. Update windows & other software. (6 Hrs)
80. Configure Outlook, mail service in mobile phones. Use tools like Skype, Google+ etc. (6 Hrs)
81. Browser setting for Bookmark, cookies, favourites and pop ups, default website, trusted site, restricted site, content, history and advanced setup
12. Web Design Concepts• Concepts of Static and Dynamic Web pages.
• Introduction to HTML and various tags in HTML.
• Concepts of different controls used in Web Pages.
28
WEEK 2082. Practice with basic HTML elements (e.g. head, title, body), tag and attributes. (3 Hrs)
83. Design simple web page with text, paragraph and line break using HTML tags. (5 Hrs)
84. Format text, change background colour and insert pictures in web page.(6 Hrs)
85. Design simple web page with tables and lists. (6 Hrs)
86. Use marquees, hyperlinks and mailto link in designing web pages. (6 Hrs)
87. Create frames, add style and design layout. (10 Hrs)

• Concepts of CSS and applying CSS to HTML.
• Introduction to open source CMS viz, Joomla, Word press etc. and Web authoring tools viz. Kompozer, Front Page etc.
29
WEEK 2188. Insert text box, check box and combo box in web page. (6 Hrs)
89. Design web page using password field, submit button, reset button and radio button etc. (6 Hrs)
90. Design a web page adding flash file, audio and video files. (10 Hrs)
• Concept of good web page designing techniques.
30
WEEK 2291. Design web page with forms and form controls using HTML tags. (8 Hrs)
92. Create web page using Cascading Style Sheet (CSS). (12 Hrs)
93. Use WYSIWYG (Kompozer) web design tools to design and edit web pages with
various styles. (12 Hrs)
13. Introduction to JavaScript• Introduction to
Programming and Scripting Languages.
• Introduction to JavaScript and its application for the web.
31
WEEK 2394. Practice with basic elements of JavaScript. (12 Hrs)
95. Embed JavaScript in HTML to display information in web pages, documentation and formatting of HTML source code. (18 Hrs)
• Introduction to Web Servers and their features.
• JavaScript Basics – Data
types, Variables
32
WEEK 2496. Use JavaScript Variables, Data types, Constants and Operators. (18 Hrs)
97. Use Control statements and Loops in JavaScript. (18 Hrs)
Constants and Conversion between data types.
• Arithmetic, Comparison, Logical Operators in JavaScript. Operator precedence.
33
WEEK 2598. Practice with switch case, loop controls and Errors in JavaScript. (18 Hrs)
99. Practice with Arrays in JavaScript page. (12 Hrs)
• Program Control Statements and loops in JavaScript.
• Arrays in JavaScript – concepts, types and usage.
34
WEEK 26100. Practice with functions in JavaScript web page. (18 Hrs)
101. Practice with String, Math and Date functions in JavaScript. (24 Hrs)
• The String data type in JavaScript. Introduction to String, Math and Date.
• Introduction to Functions in JavaScript.
35
WEEK 27102. Use online tool or open source software to develop and edit web pages containing Titles, different font sizes and colours, frames, lists, tables, images, image map, controls, CSS, forms, hyperlinks etc., use web template to create a web page of various styles. (36 Hrs)• Built in JavaScript functions overview.
• Concepts of Pop Up boxes in JavaScript.
• Introduction to the Document Object Model.
36
WEEK 28103. Develop a simple web project using HTML, JavaScript and host it in IIS and a registered domain.
(36 Hrs)
• Concepts of using Animation and multimedia files in Java Script.
37
WEEK 29104. Practice with basic functions of VBA Editor.(3 Hrs)
105. Use form controls like buttons, Check boxes, Labels, Combo Box, Group Box, List Box, Option Button, Scroll Bar and Spin button. (10 Hrs)
106. Modify object properties in VBA program. (6 Hrs)
107. Write simple programs involving VBA Data types, Variables, Operators and Constants. (16 Hrs)

14. Introduction to VBA, Features and Applications.• Introduction to VBA features and
applications.
• Properties, events and methods associated with the Button, Check Box,
Label, Combo Box, Group
38
WEEK 30108. Create Message boxes and Input boxes in VBA. (6 Hrs)
109. Work with conditional statements like if, Else-if, and Select. (10 Hrs)
110. Practice with Loop, Loop Control and Case statements in VBA. (13 Hrs)
Box, Option Button, List Box, Scroll Bar and Spin button controls.
• VBA Data types, Variables and Constants.
39
WEEK 31111. Create and Manipulate Arrays in VBA. (10 Hrs)
112. Practice with string variables in VBA programming. (10 Hrs)
113. Write programs involving Mathematical, Conversion, Date and String Functions in VBA. (16 Hrs)
• Operators in VBA and operator precedence.
• Mathematical Expressions in VBA.
40
WEEK 32114. Create Functions, Procedures, Passing Parameters and Using Returned Data. (12 Hrs)
115. Practice with built in functions in VBA programs. (12 Hrs)
• Introduction to Arrays in VBA.
• Introduction to Strings in VBA.
• Conditional processing in VBA, using the IF, Else-if, Select Case Statements.
• Introduction to Loops in VBA.
41
WEEK 33116. Create and edit macros. (12 Hrs)
117. Write code to work with Excel in VBA forms. (12 Hrs)
• VBA message boxes and input boxes.
• Introduction to Creating functions and Procedures in VBA.
42
WEEK 34118. Practice with methodsand events in VBA Programming. (20 Hrs)
119. Debug, Step through code, Breakpoints, find and fix errors while debugging. (18 Hrs)
• Using the built in functions.
• Introduction to Object Oriented Programming Concepts. Concepts of Classes, Objects, Properties and Methods.
43
WEEK 35120. Develop a simple project involving MS excel and
VBA. (26 Hrs)
• The user forms and control in Excel VBA.
• Introduction to Debugging Techniques
44
WEEK 36121. Practice Basic accounting with tally interface. (08 Hrs)
122. Create Company, Account and Voucher entry in Tally. (08 Hrs)
123. Generate reports for Invoice, Bill, Profit & Loss account etc. (08 Hrs)
124. Perform Cost Centre & Cost Category management. (10 Hrs)
15.Using Accounting Software• Basics of Accounting, Golden Rules of Accounting, Voucher Entry, Ledger Posting, Final Accounts Preparation.
• Cash Book. Ratio Analysis, Depreciation, Stock Management.
• Analysis of VAT, Cash Flow, Fund Flow Accounting.
45
WEEK 37125. Create and manage budgeting systems. (08 Hrs)
126. Create Scenario and Variance Analysis. (6 Hrs)
127. Use Tally for Costing, Ratio Analysis, Cash flow and Funds flow statements. (08 Hrs)
128. Analyze and Manage Inventory control. (10 Hrs)
• Introduction to Tally, features and Advantages.
• Implementing accounts in Tally.
• Double entry system of book keeping.
• Budgeting Systems, Scenario management and Variance Analysis
46
WEEK 38129. Perform Point of Sales and Taxation (VAT, Excise, Service Tax). (6 Hrs)
130. Perform System Administration and use other Utilities. (6 Hrs)
131. Create users, take Backup
& Restore of Company. (6 Hrs)
132. Use Multilingual Functionality in Tally. (6
Hrs)
• Costing Systems, Concepts of Ratios, Analysis of financial statements.
• Inventory Basics, POS Invoicing, TDS, TCS, FBT, VAT & Service Tax.
• Tally Interface
47
WEEK 39133. Browse E-commerce websites viz. ebay, Amazon, flipkart, OLX, quikr etc. and prepare comparative statement of the main features of these sites. (8 Hrs)
134. Upload products for selling in E-Commerce Sites and make online purchase from E Commerce sites.(14 Hrs)
135. Manage security issues in E-Commerce and payment operations. (8
Hrs)
16. E -Commerce Concepts• Introduction to E- Commerce and advantages.
• Building business on the net.
• Payment and Order Processing, Authorization, Chargeback and other payment methods.
• Security issues and payment gateways.
48
WEEK 40136. Protect information, computers and networks from viruses, spyware and other malicious code. (3 Hrs)
137. Provide firewall security for Internet connection and Network System. (6 Hrs)
138. Protect the computer against various internet threats. (3 Hrs)
139. Make backup copies of important file, data and information. (3 Hrs)
140. Secure your Wi-Fi
networks using password WEP, WPA-PSK, WPA2-
PSK, SSID, MAC address filtering. Create individual user accounts for each member. (9 Hrs)
141. Limit member access to data and information, and restrict authority to install unnecessary downloads.
(6 Hrs)

17. Cyber Security:• Overview of Information Security, SSL, HTTPS, Security threats,
information Security vulnerability and Risk management.
• Introduction to Directory Services, Access Control, Security, Privacy protection, Audit and Security.
• Introduction to IT Act and penalties for cyber crimes.
49
50
51
52
INSTRUCTORPRINCIPAL
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100