Computer Based Skills- II

  • Printer-friendly version
  • PDF version
Paper Code: 
25AAF217
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to gain knowledge about essential spreadsheet functions like SUM, COUNT, IF, as well as financial functions like PV, NPV, and data analysis tools like Pivot Tables and Graph plotting. Students will also learn data visualization using Tableau, including connecting data, creating dashboards, and analyzing data effectively.

Course Outcomes: 

Course

Course Outcomes

Learning and teaching strategies

Assessment Strategies

Course Code

Course Title

 

 

 

 

 

 

 

 

 

25AAF217

 

 

 

 

 

 

 

 

Computer Based Skills- II (Practical)

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

CO80: Apply what-if- analysis tools and filter data using lookup functions

CO81: Design charts to visualize and analyze the data

CO82: Visualise data using Tableau

CO83: Apply filters and views while studying different dimensions on data using Tableau

CO84:                           Contribute effectively in course – specific interaction.

Approach in teaching: Interactive Lectures, Discussions, Tutorials, Problem solving                sessions, Presentations

 

 

Learning activities for the students:

Self-

learning assignmen ts, Presentations, Group Discussions

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

 

6.00
Unit I: 
Mathematical and Statistical Functions in Spreadsheet:

• 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:

• 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 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 Visualization using Tableau:

• Data Visualization 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:

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

Essential Readings: 

1. Mastering Word 2000 – Mansfield &Olsen
2. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
3. Mastering Power Point 2000 – Murray

References: 

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

E-Content:
1. https://www.excel-easy.com/
2. https://www.tableau.com/learn/training/
3. https://www.simplilearn.com/tutorials/tableau-tutorial/

Reference 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