Department Events
Data Analysis using
The course will enable the students to
1.Study the concept of working with spreadsheets right from basics to Tables,
2.Understand the working on advanced data manipulation with spreadsheets
Course | Learning outcome (at course level) | Learning and teaching strategies | Assessment Strategies | |
Course Code | Course Title | |||
25CBDA 114 |
Data Analysis using Spreadsheets- I (Practical) | CO19.Effectively use spreadsheets to perform statistical computations and display numerical and graphical summaries of data sets. CO20 Perform conditional operations on data. CO21 Compute and interpret the descriptive statistics for different problems. CO22 Explain the usage of predefined functions in analysis of datasets. CO23 Develop data management skills through effective data visualization for real world scenario. CO24 Contribute effectively in course-specific interaction | Approach in teaching: Interactive Lectures, Discussion, Demonstrations, Group activities, Teaching using advanced IT audio-video tools . Learning activities for the students: Effective assignments, Giving tasks. | Assessment Strategies Class test, Semester end examinations, Quiz, Practical Assignments, Individual and group projects. |
Understanding and preparing data for analysis
Formatting Features, Format Painter Cell referencing (Relative, Absolute, Mixed). Name Ranges, conditionally highlighting cells
Arranging data for a situation. Paste Special function,
Data Tabulation in Excel
Creating a Table, Adding, deleting new rows or columns, moving a Table, Removing duplicate rows from a table. Sorting and filtering a table, auto filter, advanced filter, formatting of table. Series, auto fill series. Freeze Panes & Split windows.
Building Logic: Understanding basic functions, Functions and its parts, some useful mathematical and statistical Functions in spreadsheet (eg. SUM, COUNT, MAX, MIN, IF, COUNTIF, CEILING, FLOOR, TRUNC, ABS, FACT, INT, LOG, MOD, POWER, ROUND, EXP), logical functions (IF, AND, OR). IF() + AND(), IF() + OR(), Concept and use of nested IF(), COUNTIF() & COUNTIFS(), SUMIF() & SUMIFS() and AVERAGEIFS(),HLookup, VLookUp. Graphing and Charting: line graph, bar graph, pie chart, histogram, scatter plot. Descriptive Statistics (Frequency distributions, mean, median, mode, standard deviation, sample variance, range, interquartile-range).
1. Winston,” Microsoft Excel 2013: Data Analysis and Business Modeling”, PHI
2. Denise Etheridge, “Excel Data Analysis”,WileyPublication, Third Edition
SUGGESTED READINGS:
1. Hector Guerrero, “Excel Data Analysis - Modeling and Simulation”, Springer
2. Financial Analysis and Modeling using Excel and VBA: ChandanSengupta, Wiley
e-RESOURCES:
1. https://www.w3schools.com/EXCEL/index.php
2. https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af- a5b3-d7c22f6990bb
3. https://www.tutorialspoint.com/advanced_excel/index.htm
4. https://www.coursera.org/learn/excel-advanced
JOURNALS:
1. Journal of Machine Learning Research (JMLR),ACM, https://dl.acm.org/journal/jmlr
