INFORMATION TECHNOLOGY

Paper Code: 
FIT 400
Credits: 
2
Periods/week: 
2
Max. Marks: 
100.00
Objective: 

Course Objectives:

 

The course will enable the students to

  1. To acquaint the students with the introduction of computer system and develops the conceptual understanding of fundamentals of computer system.

 

Course Outcomes (COs):  

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

 
 

CO 1 – Analyse the use office automation tools in daily work.
CO 2 – Design spreadsheets and use basic functions, create charts to analyse data.

CO 3 –Create effective and well formatted documents.

CO 4 – Design presentation using presentation tools and enhance presentation skills
CO 5 – Evaluate the advantage of collaborative documents
 

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

Learning activities:

 Presentations,  Quizzes and  Assignments

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

 

 

 

 

5.00
Unit I: 
Command Line Interface

Introduction to DOS: Important terms in DOS (program, file, directory, names, volume label, disk drive & its name (DOS prompt). Comparison of CLI & GUI.

DOS file system, path & path names, Internal Commands (DIR, CD, MD, RD, COPY, COPY CON, DEL, REN, DATE, TIME, VER, CLS, TYPE, PROMPT, PATH)

External Commands (TREE, DELTREE, EDIT)

 

6.00
Unit II: 
Word Processor

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, creating tables, proofing text (Spell check, Auto correct), Inserting pictures, Mail merging. 

 

6.00
Unit III: 
Spreadsheet

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, Basic Functions (SUM, AVERAGE, COUNT, MAX, MIN, IF), Data Filtering.

 

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, Creating and using master-slide.

 

7.00
Unit V: 
Cloud based 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: 

ESSENTIAL READINGS:

  1. Microsoft Excel 2016 - Data Analysis and Business Modeling PHI Publication 2017
  2. Bott and Leonhard, “Using Office 2000”, Prentice Hall of India    

 

REFERENCES: 

Suggested READINGS: 

  1. Mahapatra & Sinha, “Essentials of Information Technology”,  Dhanpat Rai Publishing
  2. R.K.Taxali, “PC Software For Windows” , Tata McGraw Hill

JOURNALS:

  1. https://www.researchgate.net/publication/334054812_Boolean_Algebra_and_Logic_Gates
  2. Journal of the Brazilian Computer Society, SpringerOpen
  3. Journal of Internet Services and Applications, SpringerOpen

E-RESOURCES:

  1. https://cag.gov.in/uploads/media/introduction-to-computers-by-peter-norton-6th-ed-20210326115622.pdf
  2. https://ptgmedia.pearsoncmg.com/images/9780735699236/samplepages/9780735699236.pdf
  3. https://www.computer-pdf.com/office/
  1. https://www.guru99.com/introduction-to-formulas-and-functions-in-excel.html
  1. https://www.lifewire.com/dos-commands-4070427
  2. https://hmhub.in/introduction-to-windows-in-computer-gui-feature/
  3. https://ncert.nic.in/textbook/pdf/kect104.pdf
  4. https://regoconsulting.com/microsoft-introduction-to-office-365-from-a-savvy-rego-guide/

 

Academic Year: 
2022-23
  • Printer-friendly version