IT Tools - II

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

This course will enable the students to –

  1. Apply the different MS-excel functions on the tabular data and filters and views while studying different dimensions on data.
  2. Design charts to visualize and analyze the data and visualise data using Tableau

Course Outcomes (COs):

 

 Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course Code

Course Title

 

 

 

 

 

 

 

 

CMAT 214

 

 

 

 

 

IT Tools - II

 (Practical)

 

 

 

 

 

 

The students will be able to –

 

CO33: Apply the different MS-excel functions on the tabular data.

 

CO34: Use what-if-analysis tools and filter data using lookup functions

 

CO35: Design charts to visualize and analyze the data

 

CO36: Visualize data using Tableau

 

CO37: Apply filters and views while studying different dimensions on data.

 

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
Mathematical and statistical Functions in spreadsheet( SUM, COUNT, MAX, MIN, IF, COUNTIF, CEILING, FLOOR, TRUNC, ABS, FACT, INT, LOG, MOD, POWER, ROUND, EXP), logical functions(IF, AND, OR), Date & Time functions(NOW, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND).
 
Unit II: 
II
Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER), Vlookup, Hlookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros
 
Unit III: 
III
Plotting line graph, bar graph, pie chart, histogram, scatter plot based on the given data. Descriptive    Statistics (mean, median, mode, standard deviation, sample variance, Range).
 
Unit IV: 
IV
Data Visualization using Tableau (Desktop/cloud version): Getting started, connecting your data, workspace area (adding dimensions. hierarchies, data pane, views, sheets).
 
Unit V: 
V
Building dashboards, filtering data, creating and formatting maps, building area charts, text tables, bar charts.
 
Essential Readings: 
  • 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