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

Home > COMPUTER BASED SKILLS 2

COMPUTER BASED SKILLS 2 [1]

Paper Code: 
BCS 417
Credits: 
02
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

Course Outcome (COs):

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

 
 

Upon successful completion of this course, the student will be able to:

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

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

CO 148:       Design charts to visualize and analyze the data

CO 149:       Visualize data using Tableau

CO 150

     
     
     

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

Class lectures

Tutorials

Group discussions and Practical implementation

Quiz, Presentations, Semester End Examination

 

 

6.00
Unit I: 
Mathematical and Statistical Functions

·       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

·       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: 
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 Visualisation

·       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: 
Creating and Formatting

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

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

·       ShubhiLall, Elementary Computer Application

·       Mastering DOS – Robbins

·       Mastering Windows 98 – Robert & Cowart

References: 
  •  

1.https://www.excel-easy.com/ [2]

2.https://www.tableau.com/learn/training/ [3]

3.https://www.simplilearn.com/tutorials/tableau-tutorial/ [4]

 

 

  •  

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: 
2022-2023 [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-2

Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-2
[2] https://www.excel-easy.com/
[3] https://www.tableau.com/learn/training/
[4] https://www.simplilearn.com/tutorials/tableau-tutorial/
[5] https://journal-bcs.springeropen.com/
[6] https://jisajournal.springeropen.com/
[7] https://www.sciencedirect.com/journal/thinking-skills-and-creativity
[8] https://journalofbigdata.springeropen.com/
[9] https://accountingtaxation.iisuniv.ac.in/academic-year/2022-2023