Data Analysis Using Spreadsheets-II

Paper Code: 
24ADAS200
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Study the advanced concept of MS Excel.
  2. Apply the concepts of advanced data manipulation using spreadsheets.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

24ADAS 200

Data Analysis using Spreadsheets-II

(Practical)

 

CO115.Effectively use spreadsheets to perform statistical computations on different data sets.

CO116.Perform sensitivity analysis on data.

CO117.Compute and interpret the descriptive statistics for different problems.

CO118.Explain the usage of different functions in textual analysis.

CO119.Develop advanced data management skills for industry.

CO120. 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

 

 

Revision of Concepts covered in Sem I.

Working around Multiple Spreadsheets.

Financial Functions (PV, NPV, IRR, Rate, FV, PMT, NPER).

Decision Making & Advance Spread-Sheet Tools:  What if analysis (Data tables, Scenario, Goal seek, Sub-totals, Pivot Table), Macros, Protection.

Text Functions (Len, Mid, Find, Proper, Rept , Trim, Upper, Substitute, Concatenate

Date & Time functions (NOW, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE) SECOND).

Advanced Graphing and Charting: Data Trends, Combination charts, Box plots

Basic Data Descriptors: Revisions of Measures of central tendency & dispersion, Descriptive Measures of Association, Normal distribution: NORM.DIST, NORM.INV functions. 

Data from other sources: Importing external data from different database files, text files. Creating Custom Views of your Worksheet, Importing Live Data.

Adding plugins and third party tools.

Collaborative Tools: Using Google Sheets for collaboration. Use of Google Drive to save, store, share and access files and folders from anywhere.

 

ESSENTIAL READINGS: 

SUGGESTED TEXT BOOKS

  1. Denise Etheridge, “Excel Data Analysis”, Wiley Publication, Third Edition
  2. Hector Guerrero ,“Excel Data Analysis - Modeling and Simulation”, Springer

 

REFERENCES: 

SUGGESTED REFERENCE BOOKS

  1. Financial Analysis and Modeling using Excel and VBA: Chandan Sen Gupta, 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. International Journal of Data Science and Analytics, Springer: https://www.springer.com/journal/41060

 

Academic Year: 
2024-25
  • Printer-friendly version