Computer Based Skills II

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

Course Objectives:

This course will enable the students to gain knowledge about various Microsoft Tools

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

 

24BCS415

Computer Based Skills II (Practical)

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

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

CO 3:Design charts to visualize and analyze the data

CO 4:Visualize data using Tableau

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

CO 6: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: 
Spreadsheet Functions
  • Mathematical and statistical Functions in spreadsheet( SUM, COUNT, MAX, MIN, IF, COUNTIF, C      EILING, 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 and Data analysis in spreadsheets
  • Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER),
  • Vlookup, Hlookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros

 

6.00
Unit III: 
Data visualization and descriptive statistics
  • 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 essentials
  • 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: 
Dashboard creation and advanced visualisation
  • Building dashboards, filtering data, Creating and formatting maps, building area charts, text tables, bar charts.

 

Essential Readings: 

Essential Readings:

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

 

 

References: 

Suggested Readings:

  1. Textbook of Environmental Studies for Undergraduate Courseshttps://www.ugc.ac.in/oldpdf/modelcurriculum/env.pdf Introduction to Environmental Auditing and Management
  2. https://www.soas.ac.uk/cedep-demos/000_P508_EAEMS_K3736-Demo/module/pdfs/p508_unit_01.pdf Introduction and Concepts related to Environmental Studies
  3. https://teresas.ac.in/wp-content/uploads/2020/06/CHAPTER-1-7-MULTIDISCIP... ENVIRONMENTAL-STUDIES.pdf

 

e-Content:

  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: 
2024-2025
  • Printer-friendly version
  • PDF version