COMPUTER BASED SKILLS- II

Paper Code:

AAF 217

Credits:

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

Course Outcomes (COs):

Course Outcomes	Learning and teaching strategies	Assessment Strategies
On completion of this course, the students will be able to: CO73: Apply the different MS-excel functions on the tabular data. CO74: Use what-if-analysis tools and filter data using lookup functions CO75: Design charts to visualize and analyze the data CO76: Visualise data using Tableau CO77: Apply filters and views while studying different dimensions on data.	Class lectures, Seminars Tutorials, Group discussions, Workshops and Question preparation	Quiz, Poster Presentations, Open book test, Semester End Examination

Course Outcomes

Learning and teaching strategies

Assessment Strategies

On completion of this course, the students will be able to:

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

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

CO75: Design charts to visualize and analyze the data

CO76: Visualise data using Tableau

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

Class lectures, Seminars

Tutorials, Group discussions,

Workshops and Question preparation

Quiz, Poster Presentations,

Open book test, Semester End Examination

6.00

Unit I:

• Mathematical and statistical Functions in spreadsheet: Mathematical Functions ( 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), V lookup, H lookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros

6.00

Unit III:

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

6.00

Unit V:

• Analyzing data using Tableau: Building dashboards, filtering data, creating and formatting maps, building area charts, text tables, bar charts.

Essential Readings:

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

References:

• Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
• Shubhi Lall, Elementary Computer Application
• Mastering DOS – Robbins
• Mastering Windows 98 – Robert & Cowart

e- RESOURCES:

• https://www.excel-easy.com/
• https://www.tableau.com/learn/training/
• https://www.simplilearn.com/tutorials/tableau-tutorial/
REFERENCE JOURNALS:

• https://journal-bcs.springeropen.com/
• https://jisajournal.springeropen.com/
• https://www.sciencedirect.com/journal/thinking-skills-and-creativity
• https://journalofbigdata.springeropen.com/

Academic Year:

2023-2024