Data Analysis using Spreadsheets-I

Paper Code: 
24CBDA114
Credits: 
03
Periods/week: 
06
Max. Marks: 
100.00
Objective: 

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 Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course

Code

Course

Title

 

 

 

 

 

24CBDA 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).

 

ESSENTIAL READINGS: 

SUGGESTED TEXT BOOKS

  1. Winston ,”Microsoft Excel 2013: Data Analysis and Business Modeling”, PHI
  2. Denise Etheridge, “Excel Data Analysis”,WileyPublication, Third Edition

 

REFERENCES: 

SUGGESTED REFERENCE BOOKS

  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

 

Academic Year: 
2024-25
  • Printer-friendly version