ELEMENTARY COMPUTER APPLICATION SOFTWARES

A. INTRODUCTION TO COMPUTER SYSTEM
Basic Computer Concept
Computer Appreciation - Characteristics of Computers, Input, Output, Storage units, CPU, Computer System.
Input and Output Devices
Input Devices - Keyboard, Mouse, joystick, Scanner, web cam,
Output Devices- Soft copy devices, monitors, projectors, speakers, Hard copy devices, Printers – Dot matrix, inkjet, laser, Plotters. (4 lectures)
Computer Memory and Processors
Memory hierarchy, Processor registers, Cache memory, Primary memory- RAM, ROM, Secondary storage devices, Magnetic tapes, Floppy disks, hard disks, Optical Drives- CD-ROM, DVD-ROM, CD-R, CD-RW, USB Flash drive, Mass storage devices: USB thumb drive. Managing disk Partitions, File System. Basic Processor Architecture, Processor speed, Types of processor.

Numbers Systems and Logic Gates
Decimal number system, Binary number system, Octal number system, Hexadecimal number system, Inter-conversion between the number systems. Basic Logic gates-AND, OR, NOT, Universal logic gates- NAND, NOR
Computer Software
Computer Software- Relationship between Hardware and Software, System Software, Application Software, Compiler, Names of some high level languages, Free domain software.

Internet & its uses
History of Internet, WWW and Web Browsers: Web Browsing software, Surfing the Internet, Chatting on Internet, Basic of electronic mail, Using Emails, Document handling, Network definition, Common terminologies: LAN, WAN, MAN, Node, Host, Workstation, Bandwidth, Network Components: Severs, Clients, Communication Media. Wireless network

Operating system-Windows
Operating system and basics of Windows, The User Interface, Using Mouse and Moving Icons on the screen, The My Computer Icon, The Recycle Bin, Status Bar, Start and Menu & Menu-selection, Running an Application, Windows Explorer Viewing of File, Folders and Directories, Creating and Renaming of files and folders, Opening and closing of different Windows, Windows Setting, Control Panels, Wall paper and Screen Savers, Setting the date and Sound, Concept of menu Using Help, Advanced Windows, Using right Button of the Mouse, Creating Short cuts, Basics of Window Setup, Notepad, Window Accessories

B. MICROSOFT OFFICE 2007 AND LATEST VERSIONS
Word Processing
Word processing concepts: saving, closing, Opening an existing document, Selecting text, Editing text, Finding and replacing text, printing documents, Creating and Printing Merged Documents, Character and Paragraph Formatting, Page Design and Layout. Editing and Checking. Correcting spellings. Handling Graphics, Creating Tables and Charts, Document Templates and Wizards, Mail merge and Macros.

Microsoft Excel (Spreadsheet)
Spreadsheet Concepts, Creating, Saving and Editing a Workbook, Inserting, Deleting Work Sheets, entering data in a cell / formula Copying and Moving from selected cells, handling operators in Formulae, Functions: Mathematical, Logical, statistical, text, financial, Date and Time functions, Using Function Wizard. Formatting a Worksheet: Formatting Cells changing data alignment, changing date, number, character or currency format, changing font, adding borders and colors, Printing worksheets, Charts and Graphs – Creating, Previewing, Modifying Charts. Integrating word processor, spread sheets, web pages. Pivot table, goal seek, Data filter and scenario manager

Microsoft Power Point (Presentation Package)
Creating, Opening and Saving Presentations, Creating the Look of Your Presentation, Working in Different Views, Working with Slides, Adding and Formatting Text, Formatting Paragraphs, Drawing and Working with Objects, Adding Clip Art and other pictures, Designing Slide Shows, Running and Controlling a Slide Show, Printing Presentations. Creating photo album, Rehearse timing and record narration. Master slides.

Reference Books
Nishit Mathur, Fundamentals of Computer , Aph publishing corporation(2010)
Misty E. Vermaat,.Microsoft word 2013 1st Edition (2013).
Satish Jain, M.Geeta, MS- Office 2010 Training Guide, BPB publication (2010)
Joan Preppernau, Microsoft PowerPoint 2016 step by step, Microsoft press(2015)
Douglas E Corner, The Internet Book 4th Edition, prentice –Hall(2009)
Faithe wempen, word 2016 in depth 1st edition, que publishing(2015)
Steven welkler, Office 2016 for beginners, Create Space Independent publishing Plateform (2016)