Published on Accounting and Taxation (https://accountingtaxation.iisuniv.ac.in)

Home > Computer Based Skills II

Computer Based Skills II [1]

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 [2] 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 [3] Introduction and Concepts related to Environmental Studies
  3. https://teresas.ac.in/wp-content/uploads/2020/06/CHAPTER-1-7-MULTIDISCIP... [4] ENVIRONMENTAL-STUDIES.pdf

 

e-Content:

  1. https://journal-bcs.springeropen.com/ [5]
  2. https://jisajournal.springeropen.com/ [6]
  3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity [7]
  4. https://journalofbigdata.springeropen.com/ [8]

 

Academic Year: 
2024-2025 [9]

Follow Accounting and Taxation on:

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India Phone:- +91-141-2400160-61, 2397906-07, Fax: 2395494, 2781158

Source URL: https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-ii-5

Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-ii-5
[2] http://www.ugc.ac.in/oldpdf/modelcurriculum/env.pdf
[3] http://www.soas.ac.uk/cedep-demos/000_P508_EAEMS_K3736-Demo/module/pdfs/p508_unit_01.pdf
[4] https://teresas.ac.in/wp-content/uploads/2020/06/CHAPTER-1-7-MULTIDISCIPLINARY-NATURE-OF-
[5] https://journal-bcs.springeropen.com/
[6] https://jisajournal.springeropen.com/
[7] http://www.sciencedirect.com/journal/thinking-skills-and-creativity
[8] https://journalofbigdata.springeropen.com/
[9] https://accountingtaxation.iisuniv.ac.in/academic-year/2024-2025