Coming soon
Computer Based Skills- II
Course Objective:
This course will enable the students to gain knowledge about essential spreadsheet functions like SUM, COUNT, IF, as well as financial functions like PV, NPV, and data analysis tools like Pivot Tables and Graph plotting. Students will also learn data visualization using Tableau, including connecting data, creating dashboards, and analyzing data effectively.
Course Outcomes (COs):
|
Course |
Course Outcomes |
Learning and teaching strategies |
Assessment Strategies |
|
|
Course Code |
Course Title |
|||
|
24AAF217 |
Computer Based Skills- II (Practical) |
CO79: Apply the different MS-excel functions on the tabular data. CO80: Use what-if-analysis tools and filter data using lookup functions CO81: Design charts to visualize and analyze the data CO82: Visualise data using Tableau CO83: Apply filters and views while studying different dimensions on data using Tableau CO84: Contribute effectively in course – specific interaction. |
Approach in teaching: Class lectures, Seminars Tutorials, Group discussions,
Learning activities for the students: Workshops and Question preparation |
Quiz, Poster Presentations, Open book test, Semester End Examination |
• 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).
• 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
• 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).
• Data Visualization using Tableau (Desktop/cloud version):Getting started, connecting your data, workspace area(adding dimensions. heirarchies, data pane, views, sheets)
• Analyzing Data using Tableau: Building dashboards, filtering data, creating and formatting maps, building area charts, text tables, bar charts.
1. Mastering Word 2000 – Mansfield &Olsen
2. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
3. Mastering Power Point 2000 – Murray
1. Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
2. Shubhi Lall, Elementary Computer Application
3. Mastering DOS – Robbins
4. Mastering Windows 98 – Robert & Cowart
E-Content:
1. https://www.excel-easy.com/
2. https://www.tableau.com/learn/training/
3. https://www.simplilearn.com/tutorials/tableau-tutorial/
Reference Journals:
1. https://journal-bcs.springeropen.com/
2. https://jisajournal.springeropen.com/
3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity
4. https://journalofbigdata.springeropen.com/
