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 |
|
· 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).
· Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER), Vlookup, Hlookup. What if analysis (Data tables, Scenario, Goal seek, 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. heirarchies, data pane, views, sheets)
· 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
SUGGESTED READINGS:
· Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
· ShubhiLall, Elementary Computer Application
· Mastering DOS – Robbins
· Mastering Windows 98 – Robert & Cowart