i am providing the Detailed syllabus of B.C.A.
(NETAJI SUBHAS OPEN UNIVERSITY)
1.1 Introduction to IT, Computer Fundamentals & Internet technology
INTRODUCTION TO IT: Objectives, Information technology, Data and information, Areas where it has changed our lives (Business, Science, Medicine), Developments in office automation (Electronic filing system, Intelligent copy machine, Document reader), Disadvantages of computer (Unemployment, Trend of depersonalization, The system security issue)
INTRODUCTION TO COMPUTER: Objectives, Definition and description of a Computer, Von Neumann architecture, Advantages and limitations of a computer, History of computer -- Computer generation & associated technology.
Classification of Computers -- Digital & Analog Computers
Concepts os Hardware, Software, Types of Software
Data Representation – ASCII , BCD, EBCDIC (Concepts)
Number System & inter-conversions between them, arithmetic operations. (Basics only)
Computer Architecture Overview – CPU, ALU, Memory & Types of Storage, Bus, registers, Peripheral devices.
Operating System Concepts (concept only) and basic DOS commands.
Internet – concepts of Web Sites, Internet Browsing & search engines, e-mail, URL (concepts only).
Introduction of Computer Languages – Generations types & their origination only.
Basic Handling – Familiarization with Windows environment.
1.2 Office Automation & Database Concepts
Windows: Working with Windows, MS Office Programs, Title Bar, Status Bar, Menu Bar, Tool Bar, Using Office Assistant, Windows Help, Creating short cut icons, Starting a program & opening a document, Saving & naming the document, Using favourite folders, Closing, Deleting & undeleting a document, Renaming, Copying & Moving a document, Search.
MS Word: Familiarization with word document, Edit Features , moving, correcting, inserting text, Print utility, Formatting, Margins, line spacing, alignment, Font size, Indent, Page Numbers & Page Breaks, Tables & Graphics, Pictures & Autoshapes, Spell check, Mail Merge, Macro. Conversion from Table to text format & vice versa.
MS Excel: Worksheet concepts, Selecting, Cut, Copy, Paste, Autofill, Adding/Removing columns/rows, Changing column width, Formatting text & numbers, Auto Format, Spell Check, Chart Wizard, Creating, enhancing & Printing a chart. Formulas, Copying formulas, Ranges. Functions. Macros,
MS Access: RDBMS concepts & overviews, Creating & saving Tables -- Concepts of primary key in Access, Adding, editing & deleting fields, Changing the view & changing fields, Data entry & editing, Creating database, Tables, Inserting / Deleting records into/from tables, Establishing Relationship between tables, Forms, Creating, saving & editing query Forms, Auto Forms, Using Report Wizard, Creating & Printing Reports.
MS Powerpoint: Creating Slide Shows, Slide Transition, Customs Animation, Inserting Objects into Slides, Print Utility, Word Handout.
MS Outlook: Concepts & Familiarization.
DBMS Concepts: Purpose of DBMS, Concepts of Data, Data Independence, Data Models, Database languages, Transaction Management, Storage Management, & Database Administration, Overall System Structure.
RDBMS concepts – Primary key, foreign key, candidate key, super key, entity set, Relationship & E R Model. SQL basics
Reference Books:
1) PC Software for Windows – R. K. Taxali, TMH
2) Data Base System Concepts, Silverchatz, Korth & Sudarshan, MH
1.3 Programming Methodology (Basic C)
Algorithm, Flowcharts, Concepts of Machine language, Assembly Language, High Level Language. Generations of Language. Overview and Comparison of Compilers & Interpreters.
Introduction to C: Basic structure of C Program, Basic data types, Constants, Declarations.
Operators: Arithmetic, relational, Logical, Conditional, Hierarchical, ‘?:’ Operator
I/O: Basic input/output statements, Scanf(), printf(), putchar(), getchar(), getch(), gets(), puts().
Flow Control: Loop control – IF, FOR, WHILE, DO…WHILE, SWITCH, Break, Continue.
Function: Concepts of function, Function structure, Value Passing – By value & By reference. Comparison between Call by value & call by reference.
Storage Class Specifiers
Arrays: Defn, Dimension concept, Initialisation, Passing array to a function, Passing Array by reference.
Strings: Initialisation, String Handling through built in C functions, String Handling & Manipulation.
Pointer: Concepts of Pointer & accessing variables through pointers.
File Concepts
Reference Books:
1) Let Us C --- Kanetkar --- BPB
2) Working with C --- Kanetkar --- BPB
1.4 Mathematical Foundation for Computer
Science – I
Algebra: Sets, Union, intersection, complement, mapping, notion of group, ring, field with simple examples; Polynomials, division algorithm, fundamental theorem of classical algebra (without proof), Descartes rule of sign and their application, relation between roots and coefficients, symmetric function of roots, tr