Bachelor of Computer Application (BCA) Community Share and Help
Syllabus BCA107
Computer Fundamental and Data Processing
Gujarat University FY BCA Syllabus (Revised) Effective from June, 2006
| Part A: | ||
| 1. | Computer Fundamentals | 5% |
| Definition and Block Diagram of computer | ||
| Types of Computers : Personal Computer, Laptop Computer, Palmtop Computers | ||
| 2. | Basic Concept of S / W and H / W | 10% |
| Introduction to H / W | ||
| Input Devices | ||
| Key Board, Mouse, OCR, MICR, BCR, Scanner, Touch Screen, Electronic Pen, Digital Camera, Web Cam | ||
| Output Device | ||
| VDU, Printer (dot Matrix, Ink-Jet, Laser), LCD Projector, Multi Functioning Device | ||
| Introduction to Software | ||
| Types of S / W | ||
| Application Software | ||
| System Software | ||
| Utility Software | ||
| 3. | Memory Organization | 10% |
| Primary Memory | ||
| Ram, Rom, Cache | ||
| Secondary Memory | ||
| Hard Disk, Floppy Disk, CD, DVD, Pen Drive, Zip Drive | ||
| Introduction to Emerging Technologies | ||
| USB, Blue Tooth, Infrared | ||
| Part B: | 30% | |
| 1. | Introduction to Electronic Data Processing | 15% |
| Data, Information and data processing cycle | ||
| Methods of data processing – manual & electronic | ||
| Introduction to Online Processing | ||
| Batch Processing | ||
| Real time Processing | ||
| Time Sharing | ||
| Multiprogramming Systems | ||
| Multi Processing Systems | ||
| Concept of Gird Computing Spooling Modular Programming | ||
| Advantages and disadvantages of electronic data processing | ||
| 2. | Files | 15% |
| Types of files | ||
| Master and transaction file | ||
| back-ups | ||
| File Sorting Searching | ||
| Direct Access files organization | ||
| Index sequential file organization | ||
| Advantages and Disadvantages of different file organization. | ||
| Part- C DBMS Package ( MS ACCESS / Star Office / Open Office): | 45% | |
| DBMS concepts | ||
| creating database | ||
| tables | ||
| fields and its properties | ||
| data types | ||
| primary key | ||
| adding / editing data | ||
| navigating | ||
| sorting | ||
| filtering designing queries in design view & SQL view ( Select, Where, group by, having, order by, Aggregate functions: max, mi, sum, count ) using forms | ||
| report generation facilities | ||
| relationships | ||
| macro | ||
| TEXT BOOK: | ||
| Fundamentals of Computers, P.K. Sinha, BPB | ||
| Introduction to Computer Data Processing & Systems Analysis, V.K. Kapoor, Sultan Chand & Sons | ||
| Teach yourself ACCESS 97, Seigal, BPB. | ||
| REFERNCE BOOKS | ||
| Fundamentals of Information Technologies, S. Jaiswal, Galgotia | ||
| Fundamentals of Computers, V. Rajaraman, PHI | ||
| Data Processing & Information Technology, C.S. French BPB | ||
| ABC of MSACCESS, Cowart, BPB. | ||
| Working in MS OFFICE, Ron Mansfield, TMH | ||
| ACCESS 2000-The Complete Reference, Anderson, TMH | ||
| Practical Based on MS ACCESS | ||
| Term Work should be based on syllabu |
| Total Marks of this Subject | 100 Marks |
| External (University ) Examination | 70 Marks |
| Internal Sessional Examination | 20 Marks |
| Term Work | 10 Marks |
| Teaching Hours per week | 3 Hrs |
| Practicals | There is no practical in this subject. |
Last Updated on 10th Jun 2009