detailed syllabus advance diploma in computer application...
Post on 25-Mar-2018
219 Views
Preview:
TRANSCRIPT
DETAILED SYLLABUS
ADVANCE DIPLOMA IN COMPUTER APPLICATION
(ADCA)
ISO 9001 : 2008 Certified
ANANT INFOTECH OLD COURT ROAD, TOHANA (Fatehabad) Haryana – 125120
ADCA Advance Diploma in Computer Application Eligibility : 10th Duration : 1 Year (Two Semester)
Semester 1 Semester 2 Fundamentals of Computers & IT Professional Typing MS Word MS Excel MS Power Point Internet Package Practical
One Month One Month One Month One Month One Month One month
Hardware and Networking Programming with C Language Web Designing with HTML Financial Accounting with Tally Practical
One month 45 Days One Month 45 Days
Semester - 1
Fundamentals of Computers & Information Technology
UNIT- I
Input Devices
Keyboard, Mouse, Trackball, Joystick, Digitalizing tablet, Scanners, Digital Camera,
MICR, OCR, OMR, Bar-Code Reader, Voice Recognition, Light Pen, Touch Screen.
Output Devices
Monitors – Characteristics and types of Monitors – Digital, Analog, Size, Resolution,
Refresh Rate, Interlaced/Non-Interlaced, Dot Pitch, Video standard - VGA, SVGA, XGA
etc.
Printers – Daisy Wheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Card and
Speakers.
UNIT – II
Storage Devices
Storage Fundamentals – Primary Vs Secondary
Data Storage and Retrieval methods – Sequential, Direct and Index-Sequential. Various
Storage Devices – Magnetic Tape, Magnetic Disks, Cartridge tape, data drives, hard disk
drives, Floppy disk, Optical disk – CD, VCD, CR-R, CD - ROM, DVD.
Number System
Data Representation in Computers. Number System of Computers – Decimal, Binary,
Octal, Hexa - Decimal Representation for their Conversion, Coding System – ASCII,
BCD, EBCDIC etc. and Arithmetic of Number System.
UNIT – III
Computer Software
Need, Types of Software’s – and Interpreter. Operating System– Functions, Types-
Batch, Single, Multiprogramming, and Multiprocessing. System Software – Operating
System, utility Program, Programming languages, Assemblers, Compilers
Application Software – Word Processing, Spreadsheet, presentation Graphics, Data
Base Management Software, Characteristics, uses and examples and area of application
of each of them.
Programming Languages – Machine, Assembly, High level, 4GL their merits and
demerits.
Computer Virus
• Virus working principals, Types of Viruses, Virus detection and Prevention.
UNIT – IV
Data Communication and Networks
Analog & Digital Signals, Communication Process, Direction of Transmissions
Flow-Simplex, Half – Duplex, Full Duplex. Communication Protocols. Communication
Channels – Twisted, Coaxial, Fiber optic, serial and Parallel Communication.
Modem – Working and Characteristics, Types of N/W connections – Dialup,
Leased Lines, ISDN, Types of Network – LAN, WAN, MAN etc. Topologies of LAN –
Ring, Bus, Star, and Mesh for tree Topologies. Component of LAN – Media, NIC, NOS,
Bridges, HUB, Routers, Repeaters and Gateway
UNIT – V
Paint
Chess, Flower, Nature Scene, House, Free Hand Picture, Car, +5 as you wish
Notepad
Creating, Saving, and opening text document, copy-paste, find replace, change
font, font style, word wrap
WordPad
Creating, Saving, and opening document, typing, editing, formatting, bold, italic,
underline, strike, subscript, superscript, alignment, insert object, hyperlink.
CMD
Introduction, History &Versions of DOS. Help command, all commands with
practical, batch file creation, virus making with batch files, hidden commands, external
commands, Data Security with CMD commands, DOS basics-Physical structure of disk,
drive name, FAT, file & directory structure and naming rules, booting process, DOS
system files.
DOS commands - Internal-DIR, MD, CD, RD, COPY, DEL, REN,VOL, DATE, TIME,
CLS, PATH, TYPE, ETC. - DISKCOMP, DOSKEY, TREE, MOVE, LABEL, APPEND,
FORMAT, SOFTFDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS ETC. -
Executable V/s Non executable files in DOS.
Professional Typing
Home Row Keys
All 10 finger use
All Keyboard Detail
Proper Style of typing
Sitting Style
Tips for long time typing
Office Package- 2003, 2007, 2010
(Word, Excel, PowerPoint)
UNIT- I MS-Word: -
Introduction to Word Processing, Introduction to MS-Word: Features, Creating,
Saving, and opening document in word, Toolbars, Rulers, Menus, keyboard shortcuts.
Editing a Document- Moving, scrolling in a document, opening multi document
windows, editing text – selecting, inserting, coping, deleting, moving text etc. Previewing
documents, Printing documents. Formatting Documents:
Paragraph formats, aligning text and paragraph, Borders & Shading, header & Footer,
Auto formatting, Auto correct, Bullets, numbering, Templates & wizards.
UNIT – II
Advanced Features of MS-Word.
Spell check, Thesaurus, find & Replace, Inserting – page Numbers, pictures, files,
Auto text, Symbols etc. Creation & working with tables, Document protection, Adding
Graphics, mail merge, envelops & mailing labels. Macros etc.
UNIT-III
MS-Excel
Worksheet basics, Creating worksheet, entering data into worksheet, heading info., Data,
text, dates, alphanumeric values, saving & quitting from worksheet. Opening & Moving
around in an existing worksheet. Toolbars and Menus, keyboard shortcuts. Working with
Single and multiple workbooks – coping, renaming, moving, adding, and deleting, coping
entries and moving between workbooks.
UNIT IV
Advanced Features of MS-Excel
Working with formulas & cell referencing - Auto sum - Coping Formulas –
Absolute & Relative addressing. Working with ranges – Creating, editing and selecting
ranges. Formatting of Worksheet – Auto Format, Changing – alignment, Character
Styles, Column width, date format, borders & colors, currency sign. Graphics and Charts
– Using wizards, various chart type, Formatting grid lines & legends Previewing &
printing worksheet – page setting, print tittles, adjustment Margins, page break, headers
and footers.
Functions – Date & Time, Math’s for Trigonometry, Statistical, Text and Logical
functions, Database. Creating and using Macros. Database – Creation, Sorting, query &
filtering a database. Multiple Worksheets – Concepts, Creating & using.
UNIT – V MS-PowerPoint: -
Creating a New Presentation, Working with Presentation, using wizards, Slides &
it’s different views, Inserting, Deleting and copying of slides, working with Notes,
Handouts, Adding Graphics, Working with PowerPoint objects, designing & presentation
of a slide show, printing Presentations, Notes, and Handouts with print options.
Internet Package
UNIT – I
INTERNET
Evolution, Protocols, Interface Concepts, Internet Vs Intranet, Growth of Internet,
ISP, Connectivity – Dial–up, broadband etc., URLs, Domain names, Portals, Application,
Internet Features and Applications
Internet basics, Starting of internet ARPANET, Detail of Network, Connection Medium,
Detail of internet speed, Leased line, Up-to, Broadband connection, Types of modem,
Connection of Internet, Browsers, WWW, Different types of Websites, Googling, Make
an E-mail Id, Make a social profile like facebook, Online form filling, How to make a
blog, Online News Reading, Online Tv-Radio, Downloading song, Downloading
Software, Make a backup server online, Hindi typing by internet, recharge with internet
banking, speed post/courier tracking, online job searching, Internet Banking, Online
Shoping.
Semester - 2
Computer Hardware & Networking
Hardware Basics of Electricity & Electronics
Basic concepts of Electricity – voltage, resistance, current, power, AC/DC, Using
Digital Multimeter for measurement of resistance / voltage / current.
Electronic Components – Resistor, capacitor, inductor, transformer, diode, transistors:
their function, types, identification, etc.
Testing Instruments, Integrated Circuits, PCB
Analog & Digital Signals, Numbering Systems (binary & hexadecimal), ASCII Codes,
BCD. Functional description of gates, Flip-flop (RS.T, D, JK), Registers, Multiplexers /
Demultiplexers, Encoder/Decoder, ADC/DAC, Counter, Adder, Subtractor, Parity
Generator/Checker, Basics of Semiconductor memories (Different types of RAM /
ROM), Timing Circuits, Electronic Display (7 segment, LED, LCD, Plasma, LED
matrix)
Getting started with PC hardware support, Operating systems, Electricity and
power systems, CPUs and motherboards, Basic Input/Output System, Memory systems,
Bus structures, Expansion cards, Ports, connectors, and cables, Data storage devices,
Video and multimedia input/output devices, Printers, Portable computers and devices,
Monitoring and management, Connecting computers, Security, Safety, Troubleshooting
and maintaining a PC, Professionalism and communication, Windows installation and
upgrades. Electricity and power systems, CPUs and motherboards, Memory systems,
Expansion cards, Data storage devices, Ports, connectors, and cables, Printers and
scanners, Display devices, Portable computers and devices, Networking, Security,
Maintaining the PC environment.
Networking
Basic networking concepts, The OSI model, Network adapters, Introducing
protocols, Network cabling and devices, Internetworking components, Remote and WAN
connectivity, Troubleshooting hardware components.
TCP/IP fundamentals, TCP/IP addressing and subnetting, Name resolution,
Firewalls and proxies, Troubleshooting network connectivity. Identifying network
operating system features, Network clients, Directory services, Accessing and managing
resources in a Windows network, Monitoring and troubleshooting a Windows server,
managing and troubleshooting NetWare network resources, Fault tolerance and disaster
recovery, Routine maintenance.
Programming with C Language
1. C Language – Character set Tokens of C - tokens-constant-keywords and
identifiers - variables- data types- declaration and assignment of variables-
defining symbolic constants.- Operators and Expressions:
Types of Operators- Arithmetic, Relational and Logical Operators Assignment,
increment and decrement of operators - conditional bitwise and special operators -
arithmetic expression and its evaluation - hierarchy of arithmetic operations -
evaluations, precedence and associatively - mathematical functions.
2. Control Branching and Decision-Making in C - If statement Switch statement -
GOTO statement - The ? : Operators.-
3. Decision - Making and Looping nesting in a loop, statements in C While do, and
for statements with variations.
4. Arrays in C – Single, Two - dimensional and Multi-dimensional arrays.
5. Handling of Character Set: Declaration & Initialization of string variables -
reading from and writing to screen -Arithmetic operations - String handling
functions.
6. Structures and Unions:
Definitions initialization and assigning values to members arrays of structures and
arrays within structures structure with in structure- unions - size of structures.
7. Pointers:
Declaration and initialisation of pointers - pointer expression - pointer and arrays -
pointer and character strings pointers and functions - pointers and structures
pointer on pointers.
8. File Maintenance in “C” :
Defining, Opening and closing a file - Input/Output operations on a file- random
access to file - command line arguments.
9. User Defined Functions:
Form of “C” functions- calling a function - nesting of functions - recursion -
functions with arrays.
Practicals:
Writing various programs in C.
Web Designing with HTML
Introduction
The World Wide Web (WWW) and history of HTML
Hypertext and Hypertext Markup Language
Why HTML
Objective of this HTML course
HTML Documents
1. Dividing the document into 2 parts.
✔ Headers tags
✔ Body tags
2. Paragraphs
3. Formatting
4. Elements of an HTML Document
✔ Text Elements
✔ Tag Elements
5. Special Character elements
6. Image tags
7. HTML Table tags
8. Lists
✔ Numbered list
✔ Non-Numbered lists
✔ Definition lists
9. Anchor tag, Name tag etc.
10. Hyperlinks - FTP/HTTP/HTTPS
11. Links with images and buttons
12. Links to send email messages
13. Text fonts and styles
14. background colors/images
15. Marquee Behavior
16. Forms related tags (action, method, name, input, submit etc)
HTML Media Tags
1. Inserting audio files
2. Inserting video files
3. Screen control attributes
4. Media control attributes
5. HTML Object
Financial Accounting with Tally
TALLY 9.0 1. Create, Alter and Delete a Co. 2. Purchases 3. Sales 4. Payment 5. Receipt 6. Party
Out Standing 7. Confirmation of Account 8. Reminder Letter 9. Contra 10. Bank Book
11. Journal 12. Godown Creation's 13. Inter Godown Transfer 14. BOM 15. Compound
Unit 16. Alternate Unit 17. Cost Center 18. Cost Category 19. Use pre Defined-Cost
Centre During Entry 20. Stock Group 21. Stock Categories 22. Standard Rates 23. Batch
Wise Details 24. Stock Query 25. Purchase Order 26. Receipt Note 27. Sales Order 28.
Delivery Note 29. Rejection In 30. Rejection Out 31. Debit Note 32. Credit Note 33.
VAT 34. Voucher Type Different Vat Class 35. Vat on Capital Goods 36. CST 37.
Import Export 38. VAT Refundable on Export Goods 39. URD Dealer 40. TDS 41. TCS
42. FBT 43. Excise 44. Service Tax 45. Job Costing 46. Interest Calculation 47. Allow
Multi Currency 48. Income/Exp Statement Instead of P/L 49. Integrate Account and
Inventory 50. Allow Invoicing 51. Maintain Budgets And Controls 52. Use Reversing
Journal And Optional Voucher 53. Enable Cheque Printing 54. Allow 0 Value Entries 55.
Use Different Actual & Billed Qty 56. Separate Discount Coolum On Invoice 57. Use
Multiple Price Level 58. Track Additional Cost of Purchase 59. Credit Limit 60. Post
Dated Cheque 61. Point of Sale 62. Ageing Analysis 63. Reorder Level 64. Reorder
Status 65. Transfer to Excel 66. Security Control 67. Tally 7.2 Transfer to 9 68. Split
Data 69. Group Company 70. Back up 71. Restore 72. Deprecation 73. Import of Data
74. Multy Account Printing 75. Statistics 76. Language 77. Voucher Numbering 78.
Change Period 79. Payroll 80. Show Consumption & Gross Profit (Stk summary) 81.
Show using Alternate unit 82. Show trail of compound unit 83. Show Gross profit (P/L)
84. Show Working Capital Figure 85. Change Voucher 86. Group Summary 87. Show
Monthly reports with Graphs 88. Use Separate menu for final A/C Statement 89.
Physical Stock Register 90. Balance Sheet (New Column) 91. Auto Column Balance
Sheet 92. Stock Summary (New Column) 93. Trail Balance (New Column) 94. Bank
Book(New Column) 95. Sales Register (New Column) 96. Purchase Register (New
Column) 97. Journal Register (New Column) 98. Debit Note(New Column) 99. Credit
Note (New Column) 100. Godown (New Column) 101. Categories (New Column) 102.
Statistics (New Column) 103. Payroll Statement (New Column) 104. Pay sheet (New
Column) 105. Show Transactions( Trail Balance) 106. Show Closing Balance(Trail
Balance) 107. Method of Showing Balance Sheet 108. Stock Group Analysis 109.
Category Analysis 110. Stock Item Analysis 111. Group Analysis 112. Ledger Analysis
113. Transfer Analysis 114. Ageing Analysis 115. Profit &loss A/C (Auto Column) 116.
Stock Summery (Auto Column) 117. Payroll Statement (Auto Column) 118. Pay Sheet
(Auto Column) 119. Statistic (Auto Column) 120. Categories (Auto Column) 121.
Godown (Auto Column) 122. Movement Analysis (Auto Column) 123. Physical Stock
Register(Auto Column) 124. Stock item (Auto Column) 125. Debit Note(Auto Column)
126. Credit Note(Auto Column) 127. Journal Register (Auto Column) 128. Purchase
Register(Auto column) 129. Sales Register(Auto Column) 130. Cash/Bank Book (Auto
Column) 131. Copies 132. Titling 133. Print Language 134. No Preview 135. With
preview 136. Sub Titling 137. Print With Company Name 138. Print With Company
Address 139. Print Date Range Of Report 140. Print Page Number in Report 141. Page
Nos 142. Pre Printed 143. Plain Paper 144. Print Format 145. Select Printer 146. Page
Setup 147. Height Of Normal Invoice 148. Width Of Normal Invoice 149. Space To
Leave On Top 150. Space To Leave On Left
top related