Coming soon
Introduction to Information Technology - Practical
Paper Code:
25AFIT400
Credits:
2
Contact Hours:
30.00
Max. Marks:
100.00
Objective:
The course will enable the students to
- Learn the practical usage of computers in day to day applications.
- Use computer for basic purposes of preparing documents, personnel/business letters, excel spreadsheets and professional PowerPoint presentations.
Course Outcomes:
6.00
Unit I:
Introduction to Computers
- Introduction to Computers (definition, characteristics & uses), System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
- Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter).
- Definition and brief history of AI, AI applications and impact on society, basic concepts of machine learning and generative AI.
6.00
Unit II:
Word processors
- Introduction to word processing, Features of Word processors, Working with formatted documents, Shortcut keys. Finding & replacing text, Go To (F5) command. Formatting documents, Selecting text, formatting characters, Changing cases, Paragraph formatting, Indents, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs. Proofing text (Spell check, Auto correct), Inserting pictures, Mail merging, Printing.
6.00
Unit III:
Spreadsheets
- Introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, Rows and columns, cell entries (numbers, labels, formulas), spell check, find and replace, Adding and deleting rows and columns, filling series, fill with drag, data sort, formatting worksheet, Introduction to charts, types of charts, Renaming sheet, Printing worksheet.
- Functions (FLOOR, CEILING, ROUND, SUM, PRODUCT, QUOTIENT); Text (EXACT, LEFT, LEN, LOWER, MID, PROPER, REPLACE, RIGHT, TRIM, UPPER, VALUE,); Statistical Functions (AVERAGE, COUNT, MAX, MIN, MEDIAN, MODE)
6.00
Unit IV:
Presentation Software
-
Introduction, Use of presentation software, Presentation tips, components of slide, templates and wizards, using template, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, Creating presentation using blank presentation, Adding slides, changing color scheme, changing background and shading, adding header and footer, adding clip arts, Various presentation views, Working in slide sorter view, adding transition and animations to slide show, Printing slides.
6.00
Unit V:
Cloud based Office Tools
- Introduction to cloud services: Google drive, Google docs, Google sheets, Google slides. Sharing and creating files, uploading and downloading files and folders. Creating and designing forms using Google forms. Introduction to office365 and its applications.
Essential Readings:
- Peter Norton, “Introduction to Computers”, TMH, 2017.
- Bott and Leonhard, “Using Office 2000”, Prentice Hall of India
- Max Clark , The Microsoft Office 365 Bible, Kindly Edition.
- Manmeet Singh Mehta, Microsoft Excel Professional 2021 Guide, BPB Publications.
SUGGESTED READINGS
- L. Young, “Internet Complete Reference”, TMH
- Mahapatra & Sinha, “Essentials of Information Technology”, Dhanpat Rai PublishingR.K.Taxali, “PC Software For Windows” , Tata McGraw Hill
JOURNALS
References:
- https://www.javatpoint.com/computer
- https://www.tutorialspoint.com/basics_of_computers/basics_of_computers_i...
- https://www.excel-easy.com/
- http://www.raymundoconnor.com/wp/wpcontent/uploads/2017/09/lo1_word_proc...
- https://support.microsoft.com/en-us/office/Analyse-data-in-excel-3223aab...
- https://www.ibm.com/in-en/cloud/learn/cloud-computing#toc-types-of-c-WQ3...
- https://www.javatpoint.com/computer-network-tutorial
- https://www.geeksforgeeks.org/basics-computer-networking/
- https://www.simplilearn.com/what-is-computer-security-article
- https://www.geeksforgeeks.org/cyber-law-it-law-in-india/
- https://www.infosecawareness.in/cyber-laws-of-india
- https://www.techtarget.com/searchcio/definition/e-business
Academic Year:
