Data Management Tools

Paper Code: 
25DAC232
Credits: 
4
Periods/week: 
2
Max. Marks: 
100.00
Objective: 

Students will learn how to start working with MS Excel right from the basics to tables, and advanced in data manipulation with database management system.

Course Outcomes: 

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

  1. Apply spreadsheets to perform statistical computations and display numerical and graphical summaries of data sets.
  2. Apply sensitivity analysis on data.
  3.  Identify the descriptive statistics for different problems.
  4. Utilization of predefined functions in analysis of datasets.
  5. Analyze the concept of database in data management.
  6. 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.

One Annual Practical Test, File/Seminar/Reports etc.

 

12.00
Unit I: 
Basics of spreadsheet operations:

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, Cell referencing (Relative, Absolute, Mixed).

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

12.00
Unit II: 
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). Date & Time functions (NOW, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND).

12.00
Unit III: 
Financial Functions:

PV, NPV, IPR, Rate, FV, PMT, NPER, Vlookup, Hlookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros, Protection.

Graphical methods: line graph, bar graph, pie chart, histogram, scatter plot.

Descriptive Statistics (mean, median, mode, standard deviation, sample variance, Range).

12.00
Unit IV: 
Introduction to DBMS:

Definition, Characteristics of DBMS, Architecture & Security, Types of Data Models, Concepts and constraints of RDBMS, Introduction to Structured Query Language, MySQL Installer, Download sample Database, Loading Sample Database.

12.00
Unit V: 
SQL Commands:

SQL Process, SQL Commands – DDL, DML, DCL, DQL, SQL Constraints, Data Integrity, Data Types, SQL Operators, Expressions, Querying Database, Retrieving result sets, Sub Queries, Syntax for various Clauses of SQL, Functions and Joins.

ESSENTIAL READINGS: 
  1. Winston,” Microsoft Excel 2019 Data Analysis and Business Modeling”, PHI, 6th Edition 2019
  2. Denise Etheridge, “Excel Data Analysis”, Wiley Publication, 3rdEdition,2013
  3. Stephen L. Nelson, E. C. Nelson,” Microsoft Excel Data Analysis for Dummies “, Wiley,3rd Edition,2018
  4. Vinicius M. Grippa,” Learning MySQL: Get a Handle on Your Data”, O’Reilly Media, Inc, USA,2021
  5. Microsoft Excel 2016 - Data Analysis and Business Modeling PHI Publication 2017
  6. Denise Etheridge, “Excel Data Analysis”, WileyPublication,Third Edition
  7. R. Elmarsi and S.B. Navathe, “Fundamentals of Database Systems”, Addison Wesley, 7th Ed., 2015.
  8. James R. Groff & Paul N. Weinberg, “The Complete Reference SQL”, McGraw Hill Education, 3 Edition, 2017
REFERENCES: 
  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 7th Edition, McGraw Hill, 2019.
  2. Bipin Desai, “An Introduction to Database Systems”, Galgotia Publications, 2015.
  3. Hector Guerrero ,“Excel Data Analysis - Modeling and Simulation”, Springer,2010
  4. Financial Analysis and Modeling using Excel and VBA: ChandanSengupta, Wiley
  5. Chris Newman ,”Sams Teach Yourself MySQL in 10 Minutes” , Sams Publishing; 1 edition (May 19, 2006)
  6. Alan Beaulieu,”Learning SQL”,O'Reilly Media, Inc,3rdEdition ,2020

e-Resources:

  1. https://spoken-tutorial.org/   
  2. https://www.tutorialspoint.com/management_information_system/classification_of_information.htm
  3.  https://www.managementstudyguide.com/types-of-information-systems.htm
  4. https://www.guru99.com/introduction-to-formulas-and-functions-in-excel.html
  5.  https://trumpexcel.com/excel-functions/
  6. https://www.excel-easy.com/
  7. https://www.tutorialspoint.com/excel_data_analysis/index.htm
  8. https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home
  9. https://www.w3schools.com/mySQl/default.asp
  10. https://www.mysqltutorial.org/mysql-basics/
  11. https://www.javatpoint.com/mysql-tutorial

Journals:

  1. https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
  2. https://journal-bcs.springeropen.com/
  3. https://jisajournal.springeropen.com/
  4. https://www.sciencedirect.com/journal/thinking-skills-and-creativity
Academic Year: 
2025-26
  • Printer-friendly version