Computer Based Skills II

Paper Code: 
24BCP416
Credits: 
02
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to understand working knowledge of MS Excel and other Microsoft office software.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

24BCP416

Computer based Skills II (Practical)

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

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

CO 3Design charts to visualize and analyse the data

CO 4Visualize data using Tableau

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

CO 6Contribute effectively in course specific interaction.

Approach in teaching:

Interactive Lectures, Discussions, Tutorials, Problem solving sessions, Presentations

 

Learning activities for the students:
Self-learning assignments, Case Study Analysis, Presentations, Group Discussions

 

Continuous Assessment Test, Semester End Examinations, Quiz, Solving Numerical Problems, Assignments, Class Presentations, Individual and group projects.

 

6.00
Unit I: 
Mathematical and statistical Functions
  • 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
  • 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: 
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: 
Tableau
  • 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: 
Charts
  • 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

 

References: 

SUGGESTED READINGS:

  • Dr. Leena Bhatia &Dr. Bindu Jain, Elementary Computer Application

 

E-RESOURCES:

 

JOURNALS:

 

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