Course Code- DCA
Course Fees: 8,000
SYLLABUS:
Semister 1:-
Sl No | Paper Code | Subject Name | Mark Theory | Practical Marks (Internal) |
1 | 1DCA1 | Fundamentals of Computer s & Information Technology | 100 | |
2 | 1DCA2 | PC Packages(Word,Excel,Powerpoint | 40 | 60 |
3 | 1DCA3 | GUI Programming in Visual Basic | 50 | 50 |
4 | 1DCA4 | DTP(Desk Top Publishing) | 50 | 50 |
5 | 1DCA5 | Internet & Web Page Designing | 70 | 30 |
Detailed Syllabus:
1DCA1
Fundamentals of Computers & Information Technology
UNIT – I
Introduction to Computer and IT
Brief history of development of Computers. Computer System Concept , Computer System Characteristics, Capabilities and Limitations, Types of Computer-Analog, Digital, Hybrid, General, Special Purpose, Micro, Mini, Super. Generations of Computers. Types of PCL, Computer Organization and working, basic components of a computer System Control Unit, ALU, Input / Output Functions and characteristic, Memory-RAM, ROM, EPROM, PROM and other types of Memory.
UNIT- II
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 tandard – VGA, SVGA, XGA etc. Printers – Daisy Wheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Card and Speakers.
UNIT – III
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 – IV
Computer Software
Need, Types of Software’s – System Software, Application Software. System Software – Operating System, utility Program, Programming languages, Assemblers, Compilers and Interpreter. Operating System– Functions, Types- Batch, Single, Multiprogramming, and Multiprocessing.
Programming Languages – Machine, Assembly, High level, 4GL their merits and demerits.
Application Software – Word Processing, Spreadsheet, presentation Graphics, Data Base Management Software, Characteristics, uses and examples and area of application of each of them.
Computer Virus
• Virus working principals.
• Types of Viruses.
• Virus detection and Prevention.
UNIT – V
Data Communication and Networks
Analog & Digital Signals, Communication Process, Direction of Transmissions Flow-Simplex, Half – Duplex, Full Duplex. Communication Protocols.
Communication Channels – Twisted, Coaxial, Fiberb 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 Gateways.
1DCA2
PC Packages
(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, Templets & 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
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 & its 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, Handouts with print options.
1DCA3
GUI Programming in Visual Basic
UNIT – I
Integrated Development Environment of Visual Basic
IDE of VB, user Interface, Designing, Basics of Event Driven Programming, Form – Designing, Showing & Hiding.
UNIT-II
Working With Forms & Standard Controls:
Form: Text Box, Command Button, Combo Box, List Box, Dir list, File list and other Controls.
UNIT – III
Data Types * Control Statements
Data Types, Variables & Constant, Arrays, Dynamic Arrays, Array as Function, Collections, Procedures, Arguments Passing, Functions Return Values. Control
Flow Statements: – If-then, if-then-else, select case.
Looping Statements: – Do -Loop, For – Next, While-wend, Nested Control Structure, Exit Statement.
UNIT – IV
Building Blocks of Visual Basic: –
Graphics Controls, Image Handling in VB, Coordinate System, Graphic methods – Text Drawing, Lines & Shape, Filling Shapes, and Grid Methods.
Menu Editor: – Pull-down and Pop-up Menus.
Multiple Document interface – Parent & child forms & method Error Handling: – Types of errors, Error handling methods and Functions.
UNIT-V
Database Programming with Visual Basic
Database Programming with VB – Data Control Methods, Properties, Visual data manager, Connectivity with database, Data bound controls.
1DCA4
DTP (Desk Top Publishing)
DTP:
Kinds of DTP software, CorelDraw: Different versions, Ventura Publisher, Adobe Photo Shop, MS – Publisher, MS-office: Word, Excel, PowerPoint, Access, Paint shop Pro-5, Quark x-press, Lotus Application, I photo plus, Photo Finish (For Scanning), Omni Page Limited Edition (OCR) Aldus Page Maker.
PageMaker 5.0 Feature:
File:- New, Open, Save, Save all, Revert, Export, Place, Links, Book Preference, Page Setup, Print, Exit.
Edit: Copy, Paste, Multiple paste, Select all, Paste Special, Insert Object, Edit
Story Utilities: Aldus Assitions, Index Entry, Show Index, Create Index, Create TOC
Layout: View, Guides and rules, Column guides, Go To Page, Insert Page, Remove Page, Display master items, Auto flow.
Types: Font, Size, Leading, Set width, Track, Type Style, Type Space, Paragraph, Indents/tabs, Hphenation, Alignment, Style, Define Style
Element: Fill and link, Rounded corners, Define colors.
Windows: Arrange icons, Tile, Cascade, Tool box, Stype Palette, Color Palette,
Library palette
Help: Contents, Search, Shortcuts, using PageMaker Help, Learning PageMaker 5.0, About PageMaker.
1DCA5
Internet & Web Page Designing
UNIT – I
INTERNET
Evolution, Protocols, Interface Concepts, Internet Vs Intranet, Growth of Internet, ISP, Connectivity – Dial – up, Reused Line, VSAT etc., URLs, Domain names, Portals, Application, E – mail.
Concepts, POP and WEB based E-mail, Merits, addresses, Basic of Sending & Receiving, E-mail protocols, Mailing list, Free E-mail Services.
Internet Protocols: –
Data Transmission Protocols, client/server Architecture & its Characteristics, FTP & its usages. Telnet Concept, Remote Logging, Protocols, Terminal Emulation, Message Board, Internet Chatting.
UNIT – II
WWW (World Wide Web)
History, Working, Web Browsers, its Functions, concept of search Engines, Searching the web, HTTP, URLs, Web server, Web Protocols.
UNIT-III
Concepts, Domain name Registration, space on Host server for web site, HTML, Design Tools, HTML editors, Image editors, Issues in web site creation & maintenance, FTP S/W for upload web site.
UNIT – IV
HTML –
Concepts of Hypertext, versions of HTML, Elements of HTML Syntax, Head & Body Sections, Building HTML Documents, Inserting texts, Images, Hyperlinks, Backgrounds and Color Controls, Different HTML Tags, Table Layout and Presentation, use of Font size & attributes, List types and its tags, use of Frames and forms in web pages.
UNIT – V
Introduction (Front Page-2000), HTML view, Tables, Properties. E-Commerce on introductions, concepts, Advantages and disadvantages, Technology in E – Commerce, Internet & E-Business, Application.
Electronic Payment Systems: Introduction, Types of electronic Payment System, Digital Token-Based, electronic Payment Systems, Credit Card Based, E – Payment Systems, Risk in E-Payment Systems.