Computer Based Skills -II

Paper Code: 
AAF 217
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

Course Outcomes

Learning and teaching strategies

Assessment Strategies

On completion of this course, the students will be able to:

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

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

CO75: Design charts to visualize and analyze the data

CO76: Visualise data using Tableau

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

 

Class lectures, Seminars

Tutorials, Group discussions,

Workshops and Question preparation

Quiz, Poster Presentations,

Open book test, Semester End Examination

 

6.00
Unit I: 
  • Mathematical and statistical Functions in spreadsheet: Mathematical Functions ( 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).

 

6.00
Unit II: 
  • Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER), V lookup, H lookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros

 

6.00
Unit III: 
  • Plotting Graphs: 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).

 

6.00
Unit IV: 
  • Data Visualisation using Tableau (Desktop/cloud version):Getting started, connecting your data, workspace area(adding dimensions. heirarchies, data pane, views, sheets)

 

6.00
Unit V: 
  • Analyzing data using Tableau: Building dashboards, filtering data, creating and formatting maps, building area charts, text tables, bar charts.

 

Essential Readings: 
  • Mastering Word 2000 – Mansfield &Olsen
  • Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
  • Mastering Power Point 2000 – Murray

 

 

References: 

SUGGESTED READINGS:

  • Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
  • Shubhi Lall, Elementary Computer Application
  • Mastering DOS – Robbins
  • Mastering Windows 98 – Robert & Cowart

 

e- RESOURCES:

 

JOURNALS:

 

 

Academic Year: 
2022-2023
  • Printer-friendly version
  • PDF version