IT Tools - I

Paper Code: 
CMAT114
Credits: 
2
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to –

  1. Familiarize with creating well formatted documents using various features of word processor tool and Design spreadsheets, apply basic functions to analyze data.
  2. Apply the knowledge to Create tables, forms, queries and reports using MS-Access and the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive.

Course Outcomes (COs):

 Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course Code

Course Title

 

 

 

 

 

 

 

CMAT 114

 

 

 

 

IT Tools - I

 (Practical)

 

 

 

 

 

 

The students will be able to –

 

CO15: Create well formatted documents using various features of word processor tool

CO16: Design spreadsheets; apply basic functions to analyze data.

CO17: Infer the features of presentation software and design effective presentation.

CO18: Creating tables, forms, queries and reports using MS-Access

CO19: Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive.

 

Approach in teaching:

 

Interactive Lectures, Discussion, Power Point Presentations, Informative videos

 

Learning activities for the students:

Self learning assignments, Effective questions, presentations, 

Giving tasks

 

 

Quiz, Poster Presentations,

Power Point Presentations, Individual and group projects,

Open Book Test, Semester End Examination

 

 

 

 

 

Unit I: 
I
Introduction to word processing: Working with formatted documents, Shortcut keys. Finding & replacing text, Go To command. selecting text, changing cases, Paragraph and page formatting, Header & footer, proofing text, Inserting pictures, Mail merging.
 
Unit II: 
II
Spreadsheets: Creating a Table, formatting of table, auto fill series, Basic Functions (SUM, AVERAGE, COUNT, MAX, MIN), Sorting and filtering, Cell referencing, Importing external data, basic charts (bar, column charts)
 
Unit III: 
III
Data management using MS-ACCESS (creating tables, forms, queries and reports), importing and exporting data.
 
Unit IV: 
IV
Presentation Software: using templates and wizards, creating presentation using blank presentation, Adding objects and action buttons. Various presentation views, Working in slide sorter view, adding transition and animations to slide show, Printing slides, adding master-slide.
 
Unit V: 
V
Cloud based Office Tools(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: 
  • Linda Foulkes , Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook, Packt Publishing Limited, 2020.
  • Prabhpreet Chopra and Sanjay Saxena, It Tools and Applications, Vikas Publishing, 2012.
  • Adam Ramirez, Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas: 1 (Excel Academy), Caprioru publication, 2020.
  • Gatenby James, An Introduction to Excel Spreadsheets, Bernard Babani Publishing, 2008. 
 
Academic Year: 
2022-2023
  • Printer-friendly version
  • PDF version