DATA MANAGEMENT TOOLS

Paper Code: 
BAC 232
Credits: 
4
Contact Hours: 
2.00
Max. Marks: 
100.00
Objective: 

Course Objectives:

The course will enable the students to

1. Study the concept of working with MS Excel right from basics to Tables,

2. Understand the working on advanced data manipulation with MS excel database management system.

3. Analyze the concept of database in data management

 

Course Outcomes:

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Students will be able to:

CO5:Effectively use spreadsheets to perform statistical computations and display numerical and graphical summaries of data sets.

CO6: Perform sensitivity analysis on data.

CO7: Compute and interpret the descriptive statistics for different problems.

CO8: Explain the usage of predefined functions in analysis of datasets.

CO9: Analyze the concept of database in data management.

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

 

 

12.00

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, Cell referencing (Relative, Absolute, Mixed).
Data from other sources: Importing external data from different database files. Creating Custom Views of your Worksheet.

12.00

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

Decision Making & Advance Spread-Sheet Tools: 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

Introduction: Database Management Systems
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

Data definition and Manipulation
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 2013: Data Analysis and Business Modeling”, PHI
  2. Denise Etheridge,“Excel Data Analysis”,WileyPublication,Third Edition
  3.  Wayne L.Winston,”Excel 2010 Data Analysis and Business Modeling,
  4. Hector Guerrero ,“Excel Data Analysis - Modeling and Simulation”, Springer
  5. Financial Analysis and Modeling using Excel and VBA: ChandanSengupta, Wiley
  6. Chris Newman ,”Sams Teach Yourself MySQL in 10 Minutes” , Sams Publishing; 1 edition (May 19, 2006)
Academic Year: 
2020-2021
  • Printer-friendly version
  • PDF version