DATA ANALYSIS USING SPREADSHEETS-I

Paper Code: 
CBDA 114
Credits: 
3
Periods/week: 
6
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 (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 and display numerical and graphical summaries of data sets.
  2. Perform conditional operations on data.
  3. Compute and interpret the descriptive statistics for different problems.
  4. Explain the usage of predefined functions in analysis of datasets.
  5. Develop 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.

 

 

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()

 

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: 
  • Winston ,”Microsoft Excel 2013: Data Analysis and Business Modeling”, PHI
  • Denise Etheridge, “Excel Data Analysis”,WileyPublication, Third Edition

 

REFERENCES: 
  • Hector Guerrero ,“Excel Data Analysis - Modeling and Simulation”, Springer
  • Financial Analysis and Modeling using Excel and VBA: ChandanSengupta, Wiley

E-RESOURCES:

JOURNALS:

 

 

 

Academic Year: 
2022-23
  • Printer-friendly version