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

Home > COMPUTER BASED SKILLS II

COMPUTER BASED SKILLS II [1]

Paper Code: 
BCS 416
Credits: 
2
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 (COs):

 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

 

 

 

BCS 416

Computer Based Skills II (Practical)

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

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

CO 171:Design charts to visualize and analyze the data

CO 172:Visualize data using Tableau

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

CO 174:Contribute effectively in course – specific interaction.

Approach in teaching:
Interactive Lectures, Discussion, Tutorials, Reading assignments, Interactive White Board, Incorporating technology in teaching
 

Learning activities for the students:
Self learning assignments, Effective questions

Class test, Semester end examinations, Quiz,  Assignments, Class interaction, Presentation, Case study analysis, Open ended questions, think-pair-share, Socratic seminar

 

6.00
Unit I: 

Mathematical and statistical Functions in spreadsheet( 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 (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: 

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 Visualisation using Tableau (Desktop/cloud version):Getting started, connecting your data, workspace area(adding dimensions. heirarchies, data pane, views, sheets)

 

6.00
Unit V: 

Building dashboards, filtering data, Creating and formatting maps, building area charts, text tables, bar charts.

 

Essential Readings: 

Essential Readings:

  • Mastering Word 2000 – Mansfield &Olsen
  • Mastering Excel 2000 – Martin, Hansen
  • Klingher& Beth Mastering Power Point 2000 – Murray

 

Suggested Readings:

 

References: 

e-Content:

 

 

Academic Year: 
2023-2024 [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-4

Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-ii-4
[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/2023-2024