INTRODUCTION TO INFORMATION TECHNOLOGY

Paper Code: 
25AFIT400
Credits: 
2
Max. Marks: 
100.00
Objective: 

Course Objectives:

The course will enable the students to

  1. Learn the practical usage of computers in day-to-day applications.
  2. Use computer for basic purposes of preparing documents, personnel/business letters, excel    spreadsheets and professional PowerPoint presentations.

 

Course Outcomes: 

Course Outcomes (COs):

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course Title

25AFIT400

 

Introduction To Information Technology

 

CO1. Explain the fundamental concepts of computer and use of AI in daily life
CO2. Create effective and well-formatted documents.

CO3. Design spreadsheets and use basic functions, create charts to analyses data.

CO4. Design presentation using presentation tools and enhance presentation skills
CO5. Explain the advantages of collaborative documents

CO6. Contribute effectively in course-specific interaction   
 

Interactive Lectures, Discussions, student centered approach, Through Video Tutorials

Learning activities:

 Presentations,  Quizzes and  Assignments

  • Assignments
  • Classroom activity
  • Continuous Assessment
  • Semester End Examination

 

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: 
  1. Peter Norton, “Introduction to Computers”, TMH,2001
  2. Bott and Leonhard, “Using Office 2000”, Prentice Hall of India    

 

References: 
  1. L. Young, “Internet Complete Reference”, TMH
  2. Mahapatra& Sinha, “Essentials of Information Technology”, Dhanpat Rai Publishing

R.K.Taxali, “PC Software For Windows” , Tata McGraw Hill 

Academic Year: