COMPUTER BASED SKILLS 2

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