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.
Input DevicesKeyboard, Mouse, Trackball, Joystick, Digitalizing tablet, Scanners, Digital Camera, MICR, OCR, OMR, Bar-Code Reader, Voice Recognition, Light Pen, Touch Screen.
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 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.
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
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.
• 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.
(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.
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.
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.
DTP (Desk Top Publishing)
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.
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.
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
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.