ELECTRONIC DATA PROCESSING

Paper Code: 
CAI 202
Credits: 
3
Periods/week: 
45
Max. Marks: 
100.00
Objective: 

 The course will enable the students to

  1. Develop a conceptual understanding of fundamentals of the electronic data processing system and their application in business.
  2. Understand the basics of data base management system.

Course Outcomes (COs):

Course Outcomes

(At Course Level)

Learning And Teaching Strategies

Assessment Strategies

The Students will:

CO21. Explain the data processing fundamentals.
CO22. Assess the role of databases in different data processing applications.
CO23. Design table, forms, queries and report objects in database for various problems.
CO24. Demonstrate the concepts of linking, importing and exporting tables/databases in different case studies.
CO25. Applying the knowledge in designing forms and reports using MS Access

Learning and Teaching Strategies-

Approach in teaching:

Interactive Lectures, Discussions, student centered approach, through video Tutorials Learning activities:

Presentations, Quizzes and Assignments

 

Assessment Strategies-

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects and peer review.

 

 

10.00
Unit I: 

Data Processing Fundamentals: Introduction, Data, Information and Data Processing, Data structure, Need for data processing, Data Processing cycle and functions, Methods of data processing, Applications of data processing, major functional areas within the data processing department. Advantages and disadvantages of electronic data processing, use of computers in management. 

 

12.00
Unit II: 

Computer Processing Techniques: Introduction, On line, Batch and Real time processing systems, Time sharing, Multi-Programming system, Multi-Processing system, Distributed data processing system, Spooling, Office automation, Modular Programming, Interactive Processing.  File Organization: Introduction, Elements of a computer file, types of files, File organization, factors in file design, file handling, database, Introduction to DBMS: advantages and disadvantages of database management system, comparison with conventional file system

 

14.00
Unit III: 

DBMS package (ACCESS): Introduction to Access, Creation of database & tables, Data Types, Field Properties, primary key, indexes. Operations on tables: Add record, delete record and edit text Sort, find/replace, and filter/select, re-arrange columns, freeze columns. Edit a Tables- move, copy, delete, rename, and modify table structure.

Setting up Relationships- Define relationships, add a relationship, delete a relationship, save relationship.

 

12.00
Unit IV: 

Linking, Importing, Exporting data: basic concepts, importing or linking other Access databases, using linked tables, importing or linking spreadsheets, text & HTML files; exporting data from Access to text file, Access to Excel files, Access to HTML files & other Access databases.

Convert Access 2007 Databases to Other Access Formats Queries: basic concepts, types of queries, Query wizard; creating, running, saving and changing a query; selection criteria, Auto lookup & cross-tab queries.

 

12.00
Unit V: 

Introduction to Forms: Types of Basic Forms (Columnar, Tabular, Datasheet, Hierarchical), Forms Wizard, opening & saving a form, Form Controls

Designing queries in design view & SQL view (Select, where, order by, Aggregate functions: max, min, sum, count) using forms

Introduction to Reports: Types of Basic Reports (Columnar, Tabular, Groups/Total, Summary), Report Wizard, opening, saving, previewing and printing report.

 

ESSENTIAL READINGS: 

 

  1. David Whiteley, E-Commerce, Tata McGraw Hill Education,2017
  2. PT Joseph, S.J., E-commerce an Indian Perspective, 6th Edition, PHI,2019
  3. T.N. Chhabra, R.K.Suri, E-Commerce new vistas for business, Dhanpat Rai & Co.,2005
  4. Carlo Vercellis, Business Intelligence: Data Mining and Optimization for Decision Making, John Wiley & Sons, Ltd. 2013
  5. Anil K. Maheshwari, Business Intelligence and Data_Mining, BEP,2015
  6. Arvind Narayanan, Joseph Bonneau, Edward Felten, Andrew Miller, Steven Goldfeder, Bitcoin and Cryptocurrency Technologies, Princeton University Press ,2016
  7. Vinod Kumar Garg, N.K.Venkit krishnan, Enterprise Resource Planning: Concepts & practices, Second Edition, PHI.2011.

 

REFERENCES: 

SUGGESTED READINGS: 

  1. Eframi Turban, Jae Lee, David King, K. Michale Chung, Electronic Commerce, Pearson Education
  2. Business Intelligence Strategy: A Practical Guide for Achieving Bi Excellence
  3. Mike Biere, "Business Intelligence for the Enterprise", IBM Press,2003 - Business & Economics

 E-RESOURCES:

  1. https://www.excel-easy.com/

 

 JOURNALS:

1. https://www.tandfonline.com/journals/mjec20

2. https://www.journals.elsevier.com/electronic-commerce-research-and-applications

3. https://www.springer.com/journal/10660

 

Academic Year: 
2022-23
  • Printer-friendly version