DATA ANALYSIS USING SPREADSHEETS-II

Paper Code: 
ADAS 200
Credits: 
2
Periods/week: 
4
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 (COs).

Course outcome (at course level)

Learning and teaching strategies

Assessment Strategies

 
 

On completion of this course, the students will:

  1. Effectively use spreadsheets to perform statistical computations on different data sets.
  2. Perform sensitivity analysis on data.
  3. Compute and interpret the descriptive statistics for different problems.
  4. Explain the usage of different functions in textual analysis.
  5. Develop advanced data management skills for industry.

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:  HLookup, VLookUp.

 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: 
  1. Denise Etheridge, “Excel Data Analysis”, Wiley Publication, Third Edition
  2. Hector Guerrero ,“Excel Data Analysis - Modeling and Simulation”, Springer

 

REFERENCES: 
  1. Financial Analysis and Modeling using Excel and VBA: Chandan Sen Gupta, Wiley

 

E RESOURCES:

 

JOURNALS:

  • International Journal of Data Science and Analytics, Springer: https://www.springer.com/journal/41060

 

 

 

Academic Year: 
2023-24
  • Printer-friendly version