M1: IT-Tools and PC Applications Objective of the Course The objective of this course is to present overview of IT tools used in day to day use of computers and data base operations. The Course has been designed to provide knowledge on various hardware and software components of computer, operating system, various packages used for different applications, data base concepts & operations and various issues related to IT and application of IT. At the end of the course the students will be able to:-  Acquire the foundation level knowledge required to understand computer and its operations.  Understand the hardware and software components of the computer.  Understand the basic concept of operating system and get knowledge about various different operating systems.  Understand to use the packages of word processing, spread sheet and presentation in detail.  Understand various data base concepts and operations.  Understand the issues related to IT and IT applications. Outline of Course S. No. Topic Minimum number of hours 1. Introduction to Computer 05 hrs 2. Number System 05 hrs 3. Introduction to Operating System 05 hrs 4. Microsoft DOS 05 hrs 5. Microsoft Word 10 hrs 6. Microsoft Excel 15 hrs 7. Microsoft Power Point 05 hrs 8. Data Base Operations 05 hrs 9. Information Technology and Society 05 hrs Detailed Syllabus 1. Introduction to Computer : a. Introduction to Computer b. Input devices, c. Output devices, d. Computer Memory & storage, e. Application Software, f. Systems Software, g. Utility Software, h. Open source i. Proprietary Software j. Central Processing Unit, 2. Number System : a. Binary number system, b. Binary to Decimal Conversion, c. Decimal to Binary Conversion, d. Octal number system, Octal to Decimal Conversion, e. Decimal to Octal Conversion, f. Hexadecimal number system, g. Hexadecimal to Decimal Conversion, h. Decimal to Hexadecimal Conversion 3. Introduction to Operating System a. Operating System, b. Relation between System software and Application software, c. Operating System simple setting, using mouse and changing its properties, d. changing system date and time, e. changing display properties, f. Add or remove Program g. File and Folder management h. System tools – Disk cleanup, i. Disk defragmenter. 4. MS Dos (Microsoft Disk Operating System) a. What Is Disk Operating System b. What is Commond.Com, IO.sys, MSdos.sys c. Internal Command & External Command d. File Management Command : Copy Con, Type, Rename, Del, Copy, Xcopy, e. Attrib, Backup, Restore, f. Find , Sort , More, Chkdsk, g. Restore, Find, Sys, Type, Del, Data, Time, prompt. h. Directory Command: Dir, MD, RD, Tree, Path, 5. MS Word a. File : Save, Save as , Open, Close, Recent,Print ,Print Preview b. Home : Cut , Copy, Paste, Format painter, Font Formatting., Paragraph Formatting, Find Replace and Goto c. Insert : Pages : Cover Page, Blank Page, Page Breaks Insert Table, Table Formatting , Table Layout, Insert Picture , Picture Formatting, Text Wrapping Header and Footer , Page Numbering Insert –Textbox, Drop Cap, Date and Time, SymbolsEquation & Symbol d. Page Layout: Page Themes, Page Setup- Margin, Orientation size, Column. Page Breaks - Page break, Column break. Page Background - Water Mark, Page color, Page border. Paragraph spacing, indent spacing, Justify e. Reference : Footnote, Endnote, Caption, Comment f. Mail Merge : Start mail merge, Excel Integration , Write and insert field, Preview result g. Review & View : Word count, Spelling and Grammar , Comment , Document view, Show, Zoom h. File Operation and Security : Password Security, Track Change, Convert PDF i. Advanced Tools: Table of Contents, Indexes, Adding Comments, Tracking changes, Macros, Introduction to Google docs. 6. MS Excel a. Home Merge and center, Wrap text, Increase decimal , Decrease decimal Conditional formatting Insert column , Delete column Editing – Auto Sum ,Fill, Clear Insert Charts Pivot Chart Object Link Sheet and Rename Sheet Page layout Print Area , Scaling , Page Background b. Formula: Sum, Average, Max, Min, Mod. If, Sumif, Count if, Len, Count, Round. Left, Right, Concatenate. Time, Date, Day, Now, Today, Month, Now. Preparing marks Statement. Formula Auditing, Database Functions (DSUM, DMIN, DMAX, DCOUNT, DCOUNTA), Vlookup and Hlookup Introduction to Google Sheets. c. Data : Sorting , Filter, Advanced Filter Data Validation, Consolidation ,Goal Seek , Scenario Manager Data Table Text to Columns, Remove Duplicate Subtotal, Group and Ungroup d. Topic View : Normal View, Page layout , Page Break, Custom View, Full Screen, Zoom Show, Ruler , Formula Bar , Heading and Gridlines, e. Topic Windows : New Window, Arrange All, Freeze panels, Split, Hide, View Side by Side , Synchronous scrolling , Reset Window Position , Save Workspace , Switch Window. 7. MS Power Point a. Home : Paste Special , New slide, Slide Layout, Section & Arrange b. Insert : Smart Art, Action, Slide numbering, Video and Audio, Insert Object & Text , Word Art , Align- Align Centre, Right, Left, Top, Middle, Bottom c. Slide Properties : Slide Design , Slide Transition, Background style d. Object Animation & Transition : Animation, Advanced Animation Timing & Transition to the slide e. Slide Show & View : From beginning, From current show Custom Show, Setup show Hide Show, Rehearse Time, Record Slide Show, Presentation View- Normal,, Slide sorter Notes page, Reading View, Master View- Side Master, Handout Master, Notes Master Color/ Gray Scale View. 8. Data Base Operations: Database, Relational Database, Creating, dropping, manipulating table structure. Data Entry Form, Reports, Practicing these concepts using Access. 9. Information Technology and Society Indian IT Act, Intellectual Property Rights – issues. Application of information Technology in Railways, Airlines, Banking, Insurance, Inventory Control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.

2. Computer Organisation3. Elements of word processing4. Spreadsheets (ms-Excel)5. DataBase Operations (Ms-Acess)6. Web Designing and HTML,CSS Programming Concepts7. Networking Concepts & Introduction to Internet8. Accounting Fundamentals9. Accountimg Using Tally Erp-9 & Tally Prime with GST10. Basic Disk Operating Commands11.Programing and problem solving through C & C++12.Introduction to Multimedia and its Applications13.Adobe Photoshop 7.0 and Cs6 Editing14.Typing (Keyboard , Software)15. Computer Hardware16. Data Entry Operations