|
Learning outcome (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|---|---|---|
|
Upon successful completion of this course, the student will: CO 152: Apply the different MS-excel functions on the tabular data. CO 153: Use what-if-analysis tools and filter data using lookup functions CO 154: Design charts to visualize and analyse the data CO 155: Visualize data using Tableau CO 156: Apply filters and views while studying different dimensions on data.
|
Class lectures Tutorials Group discussions and Practical implementation |
Quiz, Presentations, Semester End Examination |
• Mathematical and statistical Functions in spread sheet (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), VLOOKUP, Lookup. What if analysis (Data tables, Scenario, Goal seeks, Sub-total, Pivot Table), Macros
• 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 Visualisation using Tableau (Desktop/cloud version): Getting started, connecting your data, workspace area (adding dimensions. hierarchies, data pane, views, sheets)
• Building dashboards, filtering data, creating and formatting maps, building area charts, text tables, bar charts.
• Mastering Word 2000 – Mansfield &Olsen
• Mastering Excel 2000 – Martin, Hansen, Klingher& Beth
• Mastering Power Point 2000 – Murray
• Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
• ShubhiLall, Elementary Computer Application
• Mastering DOS – Robbins
• Mastering Windows 98 – Robert & Cowart
Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-ii
[2] https://accountingtaxation.iisuniv.ac.in/academic-year/2022-2023