Published on Computer Science & IT (https://csit.iisuniv.ac.in)

Home > Data Analysis Using Spreadsheets-II

Data Analysis Using Spreadsheets-II [1]

Paper Code: 
25ADAS200
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

 

 

 

 

 

 

 

 

 

 

 

 

 

25ADAS

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

 

Unit I: 

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.

 

Unit II: 
ESSENTIAL READINGS: 

1.   Denise  Etheridge, “Excel Data  Analysis”, Wiley Publication, Third Edition

2.   Hector  Guerrero ,“Excel Data  Analysis - Modeling  and  Simulation”, Springer

 

REFERENCES: 

SUGGESTED READINGS:

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

e-RESOURCES:

1.   https://www.w3schools.com/EXCEL/index.php [2]

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 [3]

4.   https://www.coursera.org/learn/excel-advanced [4]

JOURNALS:

1.International Journal of Data  Science and  Analytics,  Springer:https://www.springer.com/journal/41060 [5]

 

Academic Year: 
2025-26 [6]

Follow Computer Science & IT on:

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India Phone:- +91-141-2400160-61, 2397906-07, Fax: 2395494, 2781158

Source URL: https://csit.iisuniv.ac.in/courses/subjects/data-analysis-using-spreadsheets-ii-2

Links:
[1] https://csit.iisuniv.ac.in/courses/subjects/data-analysis-using-spreadsheets-ii-2
[2] http://www.w3schools.com/EXCEL/index.php
[3] http://www.tutorialspoint.com/advanced_excel/index.htm
[4] http://www.coursera.org/learn/excel-advanced
[5] http://www.springer.com/journal/41060
[6] https://csit.iisuniv.ac.in/academic-year/2025-26