Computer Based Skills II

  • Printer-friendly version
  • PDF version
Paper Code: 
25BCP416
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

25BCP416

Computer based Skills II (Practical)

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

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

CO 147 Design charts to visualize and analyse the data

CO 148 Visualize data using Tableau

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

CO 150 Contribute 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

SUGGESTED READINGS:

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

References: 

E-RESOURCES:

·         https://www.excel-easy.com/

·         https://www.tableau.com/learn/training/

·         https://www.simplilearn.com/tutorials/tableau-tutorial/

JOURNALS:

·         1.https://journal-bcs.springeropen.com/

·         2.https://jisajournal.springeropen.com/

·         3.https://www.sciencedirect.com/journal/thinking-skills-and-creativity

·         4.https://journalofbigdata.springeropen.com/

Academic Year: 
2025-2026