Page 1 :
68, , 2.5, , BASICS OF INFORMATION TECHNOLOGY, L T P, - - 6, , RATIONALE, Information technology has great influence on all aspects of life. Primary purpose of using, computer is to make the life easier. Almost all work places and living environment are being, computerized. The subject introduces the fundamentals of computer system for using various, hardware and software components. In order to prepare diploma holders to work in these, environments, it is essential that they are exposed to various aspects of information, technology such as understanding the concept of information technology and its scope;, operating a computer; use of various tools using MS Office/Open Office/Libre Office using, internet etc., form the broad competency profile of diploma holders. This exposure will, enable the students to enter their professions with confidence, live in a harmonious way and, contribute to the productivity., Note:, Explanation of Introductory part should be demonstrated with practical work., Following topics may be explained in the laboratory along with the practical exercises., There will not be any theory examination., LEARNING OUTCOMES, After undergoing the subject, the students will be able to:, •, •, •, •, •, •, •, •, •, •, , Identify Computer Hardware Components, Network Components and Peripherals., Explain the role of an Operating System., Install System and Application Software., Explain the function of the system components including Processor, Motherboard and, Input-output devices., Use Word Processing Software to prepare document., Use Spreadsheet Software to create workbooks and automate calculation., Use Presentation Software to create interactive presentation., Perform fundamental tasks common to most application software including print,, scan, save, edit, cut, copy, paste, format, spell and grammar check., Find and evaluate information on the Web., Install Antivirus., , CORRECTED AND APPROVED BY BOARD OF TECHNICAL EDUCATION,U.P,LUCKNOW IN MEETING HELD, ON 10.07.2019 @RASHMI SONKAR, Page 68
Page 2 :
69, , •, •, , Safeguard against Online Frauds, threats and crimes., Use online office tools(Google suits), , CORRECTED AND APPROVED BY BOARD OF TECHNICAL EDUCATION,U.P,LUCKNOW IN MEETING HELD, ON 10.07.2019 @RASHMI SONKAR, Page 69
Page 3 :
70, , TOPICS TO BE EXPLAINED THROUGH DEMONSTRATION, 1., , Introduction to Computers and Peripherals., Components of Computer, Types of Computer, CPU, RAM, ROM, Hard disk, USB,, Flash drive, CD, DVD,Blue ray, Keyboard, Mouse, Monitor, LCD, Printer, Plotter,, Scanner, Modem, Sound Cards, Speakers, CMOS battery, Sharing of Printers., , 2., , Operation System and Application Software, System Software, Application Software, Virtualization Software, Utility Software,, MS Office/Open Office/Libreoffice, Working with window, Desktop components,, Menu bars, creating shortcut of program. Installation of Application softwares,, Antivirus and Drivers., , 3., , Word Processing, Spreadsheet and Presentation, Usage and creation of word document, spreadsheets and presentation, Google Suits, (Google drive, google sheet, google doc. Google presentation), , ., 4., , Internet, Basics of Networking – LAN, WAN, Wi-Fi technologies, Concept of IP Addrsses,, DNS, Search Engines, e-mail, Browsing and cyber laws., , LIST OF PRACTICAL EXERCISES, 1., 2., 3., 4., 5., 6., 7., 8., , Identify various components, peripherals of computer and list their functions., Installation of various application software and peripheral drivers, Installation of operating system (windows/linux/others), Creation and Management (Rename, delete, search of file and folders), Installation of Antivirus and remove viruses, Scanning and printing documents, Browsing, Downloading, Information using Internet, E-Mail ID creation, comparing, sending and receiving e-mail. Attaching a file with email message., 9. Word Processing (MS Office/Open Office), a), File Management, Opening, creating and saving a document, locating files, copying contents in, some different file(s), protecting files, giving password protection for a file, b), Page set up, Setting margins, tab setting, ruler, indenting, c), Editing a document, Entering text, cut, copy, paste using tool- bars, d) Formatting a document, , CORRECTED AND APPROVED BY BOARD OF TECHNICAL EDUCATION,U.P,LUCKNOW IN MEETING HELD, ON 10.07.2019 @RASHMI SONKAR, Page 70
Page 4 :
71, , Using different fonts, changing font size and colour, changing the appearance, through bold/italic/underlined, highlighting a text, changing case, using, subscript and superscript, using different underline methods, Aligning of text in a document, justification of document, inserting bullets and, numbering, Formatting paragraph, inserting page breaks and column breaks, line spacing, Use of headers, footers: Inserting footnote, end note, use of comments,, autotext, Inserting date, time, special symbols, importing graphic images, drawing tools, e) Tables and Borders, Creating a table, formatting cells, use of different border styles, shading in, tables, merging of cells, partition of cells, inserting and deleting a row in a, table, Print preview, zoom, page set up, printing options, Using find, replace options, f), Using Tools like, Spell checker, help, use of macros, mail merge, thesaurus word content and, statistics, printing envelops and lables, Using shapes and drawing toolbar,, Working with more than one window ., 10., , Spread Sheet Processing (MS Office/Open Office/Libre Office), a), , 11., , Starting excel, open worksheet, enter, edit, data, formulae to calculate values,, format data, save worksheet, switching between different spread sheets, b), Menu commands:, Create, format charts, organise, manage data, solving problem by analyzing data., Programming with Excel Work Sheet, getting information while working, c), Work books:, Managing workbooks (create, open, close, save), working in work books,, selecting the cells, choosing commands, data entry techniques, formula creation, and links, controlling calculations, Editing a worksheet, copying, moving cells, pasting, inserting, deletion cells,, rows, columns, find and replace text, numbers of cells, formatting worksheet,, conditional formatting, d), Creating a chart:, Working with chart types, changing data in chart, formatting a chart, use chart to, analyze data, Using a list to organize data, sorting and filtering data in list, e), Retrieve data with query:, Create a pivot table, customizing a pivot table. Statistical analysis of data, f), Exchange data with other application:, Embedding objects, linking to other applications, import, export document., PowerPoint Presentation (MS Office/Open Office/Libre office), , CORRECTED AND APPROVED BY BOARD OF TECHNICAL EDUCATION,U.P,LUCKNOW IN MEETING HELD, ON 10.07.2019 @RASHMI SONKAR, Page 71
Page 5 :
72, , a), , Introduction to PowerPoint, How to start PowerPoint, Working environment: concept of toolbars, slide layout &, templates., Opening a new/existing presentation, Different views for viewing slides in a presentation: normal, slide, sorter., b) Addition, deletion and saving of slides, c) Insertion of multimedia elements, Adding text boxes, Adding/importing pictures, Adding movies and sound, Adding tables and charts etc., Adding organizational chart, Editing objects, Working with Clip Art, d) Formatting slides, Using slide master, Text formatting, Changing slide layout, Changing slide colour scheme, Changing background, Applying design template, 12., , Google Suits, Using Google drive, Google shut, Google docs, Google slides., , INSTRUCTIONAL STRATEGY, Since this subject is practice oriented, the teacher should demonstrate the capabilities of, computers to students while doing practical exercises. The students should be made familiar, with computer parts, peripherals, connections and proficient in making use of MS, Office/Open Office/Libre office/Google Suit in addition to working on internet. The student, should be made capable of working on computers independently., MEANS OF ASSESSMENT, -, , Class Tests/Quiz, Software Installation and Use, Viva-Voce, Presentation, , RECOMMENDED BOOKS, 1., 2., , Fundamentals of Computer by V Rajaraman; Prentice Hall of India Pvt. Ltd., New, Delhi, Information Technology for Management by Henery Lucas, Tata McGraw Hills, New, Delhi, , CORRECTED AND APPROVED BY BOARD OF TECHNICAL EDUCATION,U.P,LUCKNOW IN MEETING HELD, ON 10.07.2019 @RASHMI SONKAR, Page 72