COMPUTER BASED SKILLS II

Paper Code: 
BCP 416
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

Course Outcomes (COs):

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

 
 

Upon successful completion of this course, the student will:

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

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

CO 141:Design charts to visualize and analyse the data

CO 142:Visualize data using Tableau

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

Class lectures

Tutorials

Group discussions and Practical implementation

Quiz, Presentations, Semester End Examination

  

 

6.00
Unit I: 
  • Mathematical and statistical Functions in spread sheet (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), VLOOKUP, Lookup. What if analysis (Data tables, Scenario, Goal seeks, Sub-total, Pivot Table), Macros

 

6.00
Unit 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).

 

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

 

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

 

Essential Readings: 

ESSENTIAL READINGS:

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

 

SUGGESTED READINGS:

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

 

References: 

E-RESOURCES:

 

JOURNALS:

 

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