ELECTRONIC DATA PROCESSING

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

The course will enable the students to

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

Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

 

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 teh 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, Autolookup & 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. V.K. Kapoor, “Introduction to Electronic Data Processing”, S. Chand & Co.
  2. Shelly, Cashman, ”Microsoft Office Access 2007: Comprehensive Concepts and Techniques”, Cengage Learning

 

REFERENCES: 
  1. Faithe Wempen,” MS Access 2002 fast & easy”, PHI.

 

Academic Year: 
2021-22
  • Printer-friendly version