Syllabus of BCA in Sambalpur University

Hello sir would you please provide me BCA first year Syllabus of Sambalpur University??? bcoz yesterday I lost my syllabus….

[Shaleen]

Hello friend, here I am providing you BCA first year Syllabus of Sambalpur University, please have a look……

Bachelor in Computer Application (BCA)
First Year

Paper - I : Computer Fundamental and Operating Systems

Unit I – Introduction to Computers & Number System - 10 Hrs (15 Marks)

What is Computers, History & Generation of Computer, Stages of Data Processing, Computer Hardware, Computer Software, Types of Computer, Computer Memory, Number System.

Unit II - Ms DOS Operating System - 15 Hrs (25 Marks)

Function of Operating System, Job scheduling, Real-time OS, Multiprogramming, Timesharing, Introduction to Dos, System File, Dos Architecture, Booting, Internal and External Commands, Batch File.

Unit III - Ms Windows Operating System - 15 Hrs (25 Marks)

Introduction to Windows Operating System, Components of Windows, Customizing the Desktop, Personalizing the System, Files and Folders, Comparison between Windows and DOS.

Unit IV Introduction to Networking & Internet - 10 Hrs (15 Marks)

Introduction to Networking (Communication channel, Modem, Mode of Transmission, Type of Network).Internet(Type of Internet Access, Introduction to TCP/IP, domain, ISP, Telnet, Web Browsing, Web Search Engine, E-Mail), Computer Virus.

Books Suggested
1. Computer for Beginners by E. Balaguruswamy
2. Microsoft DOS – Peter Norton’s – Techmedia
3. Mastering Windows – BPB Publication

Paper - II : Office Automation

Unit I - Documentation Using MS-Word - 10 Hrs (15 Marks)

Introduction to Office Automation, Creating & Editing Document, Formatting Document, Auto-text, Autocorrect, Spelling and Grammar Tool, Document Dictionary, Page Formatting, Bookmark.

Unit II - Advance MS-Word - 10 Hrs (15 Marks)

Advance Features of MS-Word [Mail Merge, Macros], Tables, File Management, Printing, Styles, linking and embedding object, Template.

Unit III - Electronic Spread Sheet using MS-Excel - 20 Hrs (35 Marks)

Introduction to MS-Excel, Creating & Editing Worksheet, Formatting and Essential Operations, Formulas and Functions, Charts, Advance features of MS-Excel (Pivot table & Pivot Chart, Linking and Consolidation), Database Management using Excel (Sorting, Filtering, Table, Validation, Goal Seek, Scenario).

Unit IV - Presentation using MS-PowerPoint - 12 Hrs (15 Marks)

Presentations, Creating, Manipulating & Enhancing Slides, Organizational Charts, Excel Charts, Word Art, Layering art Objects, Animations and Sounds, Inserting Animated Pictures or Accessing through Object, Inserting Recorded Sound Effect or In-Built Sound Effect.

Books Suggested
1. Microsoft Office – Complete Reference – BPB Publication
2. Learn Microsoft Office – Russell A. Stultz – BPB Publication

Paper – III : Programming Logic and Technique

Unit I - Problem, Program, Data - 10 Hrs (15 Marks)

Introduction to Programming, Input-Output-Process Sequence, Problem Definition, Program and Program Life Cycle, Data Handling, Program Elements (Variable, Constant, Data Types), Storing Multiple Data Using Array, Implementing Expression/Operator (Arithmetic, Logical, Relational), Flow Chart, System Flow Chart, Program Flow Chart, Concept of Algorithm, Flowchart Symbols, Operators, Program Structure.

Unit II - Program Technique - 15 Hrs (25 Marks)

Straight Line Program, Selection or Conditional Construct, Nested Condition, Iteration, Nested Loop, Subprogram (Function, Procedure, Recursion)

Unit III - Dealing with Multiple Data and Files - 15 Hrs (25 Marks)

Array Operation (Inserting, Searching, Sorting, Merging), Structure Programming, Different Form of Structure, Top-Down, Modular Programming, File (Serial File, Sequential File, Index File, Random File).

Unit IV - Pseudocodes & Programming Aids - 10 Hrs (15 Marks)

Introduction Pseudocodes, Operations & Basic Logic (Sequence, Selection, Iteration) Constructs, Advanced Pseudocoding Concepts, Query (Sequential Query, Random Query, File Query) Types of Error, Program Testing, Dry Run, Program Development Process, Design and Implementation.

Books Suggested
1. Introduction to programming – Hampel Tronic – AIPD
2. Business System- M.Jain & S.Jain - BPB

Paper - IV : Business Data Processing

Unit I - Introduction to Data Processing - 15 Hrs (20 Marks)

Introduction to Data and Information, Logical and Physical Concept of Data, File organization, Different Systems of Data Processing, Business Data Processing (Identification Data, Classification of Business Data File, Data Security, Data Integrity and Type of Checking, Basic Task in Business Data Processing, File Generation, File Backup).

Unit II - Business Accounting – 15 Hrs (20 Marks)

Accounting, Accounting Conventions (Single and Double Entry), Basic Accounting Equation, Types of Accounts, Personal Accounts, Impersonal Accounts, Real, Nominal, Terms in Accounting, Assets, Liabilities, Capital, Goods, Debtor, Creditor, Gross Profit, Net Profit, Revenue, Expense, Types of Vouchers, Journal Entries, Final Accounts, Trading / Manufacturing Account, Profit / Loss Account, Balance Sheet,

Unit III - Introduction to ACCESS - 20 Hrs (25 Marks)

Introduction to Database, DBMS, RDBMS, Feature of Access, Designing Database, Relationship (One to One, One to Many, Many to One, Many to Many), Create Table (Design View, Wizard, Datasheet View), Query (Update Query, Delete Query, Selection Query, Cross Table Query, Make Table Query).

Unit IV - Forms, Reports and Labels - 10Hrs (15 Marks)

Create (Manually, Form Wizard, Auto Form), Sorting, Filtering, Report Creation (Design View and Wizards), Report using Single Tables/ Multiple Tables/Queries, Labels.

Books Suggested
1. O’ Level Business System – V. Jain –BPB
2. An introduction to Accounting – T.S. Grewal – Sultan Chand & Co
3. ‘Access 2000 Developer hand book – Gilbert – BPB

Paper - V : Programming with ‘C’

Unit I - ‘C’ Language Fundamentals – 10 Hrs (15 Marks)

Introduction to ‘C’ Language, Pre Processor, Program Element (Token, Keyword, Data Type, Variable, Delimiter, Identifiers, Constant, Library Function, Conversion Specifies, Operators).

Unit II - Program Development in ‘C’ – 20 Hrs (25 Marks)

Program control statement (Sequential Statement, Decision Statement and Looping statement), Array (One Dimensional, Two Dimensional, Multi Dimensional), Array of Character, Sting Manipulation using Library Function, Function (Call by Value, Call by Reference, Recursion), Different Storage Classes.

Unit III - User Defined Types and Pointer – 15 Hrs (25Marks)

User Defined Data Types (Structure, Union and Enumeration), Pointers in 'C', Pointer Arithmetic, Pointer Comparison, Pointer to Array, Pointer to Structure, Pointer to Function, Pointer to Pointer, Dynamic Memory Allocation, TypeDef.

Unit IV - Files, Macros and Graphics – 10 Hrs (15 Marks)

Macros, Introduction to File, File I/O, Introduction to Graphics.

Books Suggested
1. E. Balaguruswamy “Programming in C”, Tata McGraw Hill
2. H. Schildt, “C The Complete Reference”, Tata McGraw Hill
3. Y. Kanetkar, “Let us C”, BPB Publications

Paper - VI : Communicative English

Unit I - Basic Communication Processes – 8 Hrs (10 Marks)

Processing Communication, The Self and Communication, Language and Communication, Nonverbal Communication

Unit II - Written Communication Skills – 12 Hrs (25 Marks)

Business Writing principles, Writing to Persuade, Layout of a Business Letter
Report Writing: Introducing Report concepts, Short Reports and Proposals, Planning, Preparing and Organization Long Business Report, Indexing Information, Paragraph writing
Indirect Messages: Handling negative and sensitive information

Unit III - Effective Listening & Oral Communication Skills – 12 Hrs (25 Marks)

The Nature of Effective Listening, Types of Listening, Barriers to Effective Listening, Guidelines to Effective Listening, The Nature & Importance of Effective Speaking, Types of Speech, Barriers to Effective Speaking, guidelines to effective speaking, Meetings: Purpose, planning, Agenda preparation, and conducting, Presentations: Understanding Audience, Using Audio – Visual Aids

Unit IV - Organizational Communication – 8 Hrs (20 Marks)

Group communication; Group discussion norms, Communicating for Job hunting : Preparing the right Resume, Interviewing : Purpose, Principles and Techniques; Negotiating Skills, Argumentation and Critical Thinking, Diversity and Intercultural Communication

Books Suggested
1. Vik, Gilsdorf, “Business Communication”, Irwin
2. K K Sinha, “Business Communication”, Himalaya Publishing House / Galgoria Publication
3. Bovee, “Business Communication”, Pearson ‘ PHI
4. Mohan, Banerjee, Business Communication, Mac million
5. Raman, Singh – Business communication – Oxford Press

Paper VII : Mathematics – I

Unit I - Number Bases & Computer Based Arithmetic – 15 Hrs (20 Marks)
1. Introduction to Number Set
2. Level of Precisions, Number Bases
a. Single Precision Representations
b. Double Precision Representations
3. Conversion of Numbers
4. Real Number, Octal Arithmetic, Hexadecimal Arithmetic, Modular Arithmetic
5. Binary Addition, Subtraction, Multiplication, Division
6. Number Storage in the Computer Word [16 bit, 32 bit, Size limits of Data]
7. Storage of Numbers, Fractions, Mixed Numbers, Using 2's Complement Method
8. Nines Complement, Tens Complement
9. Re-Complementing Cases
10. Shift Operations

Unit II - Floating Point Representations – 10 hrs (15 Marks)
1. Introduction to floating point numbers
2. Fixed Point and Floating Point Binary
3. Floating Point Storage and its Storage Format
4. Normalized Floating Point Form(Decimal), Exponent Form(Binary)
5. Storing Negative Mantissa, Negative Exponent
6. Floating Point Arithmetic (Decimal)

Unit III - Solution of Simultaneous Linear Equation - 10 hrs (15 Marks)
1. Matrix Inversion Method
2. Gaussian Method
3. Modification of Gauss Method to Compute Inverse

Unit IV - Statistics – 20 hrs (30 Marks)
1. Frequency Distribution
2. Measures of Central tendencies
3. Dispersion, Skewness, Kurtosis
4. Mathematical Expectation
5. Curve Fitting
6. Regression
7. Time Series Analysis

Books Suggested
1. Introductory Methods of Numerical analysis - S.S.Sastry – Prentice Hall
2. Introductory Numerical Analysis – Dr. Nanai Gopal Datta – Shreedhar Prakashani
3. Statistics – S.P. Gupta - S.Chand & Co.

Address:
Sambalpur University
Jyoti Vihar
Burla, Odisha 768019

[MAP]Sambalpur University Burla, Odisha[/MAP]

Hello sir I am BCA 3rd year student of Sambalpur University and want to know syllabus so here can you please provide me ?

[sumit]

Hey as Sambalpur University is located at Sambalpur, India, in the Indian state of Odisha. Popularly known as Jyoti Vihar.

Syllabus

Paper – I : Front End Technology using Visual Basic

Unit I - Introduction and Programming Fundamentals of VB – 15 Hrs (20 Marks)

Introduction to Visual Basic, IDE and its Components, VB Data type, Variable Scope, Module, Conditional Statement, Looping, Procedure, Function, Event, Forms Controls (Property, Event, Method) Control Array, Dilogbox ( MsgBox ( ), InputBox() ), MDI form, Menu (Standard Module, MDI).

Unit II - Basic ActiveX and Common Dialog Boxes, File Input Output – 10 Hrs (15 Marks)

Introduction to Activex control, Common Dialog Control, File Operation.

Unit III - Database Handling - 15 Hrs (25 Marks)

Introduction to Database, Bound Control and UnBound Control, Recordset, Types of Connectivity (DAO, RDO, ADO), Introduction to Data Report, Design Data Report, Group Report.

Unit IV - Graphical Application in VB – 15 Hrs (20 Marks)

Draw (Line, Circle, Box, Ellipse), Animations, Graphical Command Button.

Paper – II : Mathematics - II

Unit I - Numerical Calculation & Error and Numerical Differentiation - 10 Hrs (15 Marks)

Numerical Calculation and Error

Numbers and their Accuracy

. Errors and their Computation (Absolute, Relative, Percentage Error)

Numerical Differentiation

Basic Property of Finite Difference Calculus

. Notations of Finite Difference Calculus

Method of Constructing Difference Table

Numerical Differentiation using Newton's Forward Formula

Unit II - Solution of Algebraic & Transcendental Equation & Interpolation - 15 Hrs (20 Marks)

Zeros of Single Transcendental Equations

Zeros of Polynomials Using Different Methods (Bisection, False Position)

Introduction to Interpolation

Interpolation for Equal Intervals (Newton-Grogery Forward and Backward Different Interpolation formula)

Unit III - Linear Programming - 10 Hrs (15 Marks)

Basic of Linear Programming

Mathematical Model

Some Important Definitions

c. Solution of an Linear Programming by Graphical Method

Unit IV - Simplex Method - 10 Hrs (15 Marks)

1. Mathematical Model

Assumption of Linear Programming

2. Principles of Simplex Method (Solution of Linear Programming Problem using Simplex Method)

Unit V - Assignment & Transportation Problem, Convex Set & Their Properties-15 Hrs (15 Marks)

Assignment and Transportation Problem
Assignment Models

Hungarian Method of Solution of Assignment Problem
Special Cases in Assignment Problems

Transportation Problem (North West Corner Rule, Lowest Cost Entry Method, Vogel's Approximation Method)


Paper – III : RDBMS using Oracle

Unit I - Introduction to Database - 10 Hrs (15 Marks)

Database, Database Management System, Entity, Attribute, Relationship, Database Model, RDBMS, Keys (Primary, Foreign, Candidate key).

Unit II - Interactive SQL Commands - 15 Hrs (20 Marks)

Data Definition Language (Create, Alter, Truncate, Drop), Data Manipulation Language (Select, Update, Insert, Delete), Data Control Language, SQL Function.

Unit III - Database Object with Securities and Privileges - 10 Hrs (15 Marks)

Indexes, Views Clusters, Synonym, Sequence, Granting and Revoking Permission.

Unit IV - PL/SQL - 10 Hrs (15 Marks)

Introduction to PL/SQL, PL/SQL Architecture, PL/SQL Block Structure, PL/SQL Datatype, Sequential Control, Conditional Control and Iteration Control.

Unit V - Cursor Management & Exception Handling in PL/SQL & Packages -10 Hrs (15 Marks)

Cursor, Procedure, Function, Exception Handling, Packages, Trigger.


Paper – IV : Web Technology - II (Core Java)

Unit I - Introduction to JAVA - 10 Hrs (15 Marks)

Introduction to Java, Java Virtual Machine, Object Oriented Principle, Object and Classes, Java Keywords, Variable, Data types and Literals in Java, String, Operators and Casting, Control of Flow, (Selection Statements, Iteration Statements),Command Line Argument.

Unit II - Classes and Inheritances - 10 Hrs (15 Marks)

Introduction to Class and Object, Method, Overloading Method, Constructor, Constructor Overloading, this Keyword, Introduction to Inheritance, Using Super, Multilevel Hierarchy, Abstract class, Using Final.

Unit III - Package and Interface - 20 Hrs (20 Marks)

Package (Defining Package, Finding Package), Introduction to Interface, Defining, and Implementing of Interface, Predefined Package.

Unit IV - Exception Handling and Threads - 10 Hrs (15 Marks)

Exception Handling, Type of Exception, Try, Catch, and Finally. Multiple Catch blocks, Nested Try Statements, throw, throws, Thread Model, Multithreading.

Unit V - Applet, AWT, Input Output Stream - 10 Hrs (15 Marks)

Introduction to Applet, Applet Methods, Introduction to AWT (Working with Windows, Graphic, Text), GUI Components, Using AWT Controls, Layout Managers, and Menus, Event Classes, Event Listener Interface.


Paper – V : Computer Communication and Networking

Unit I - 12 Hrs – 20 Marks

Physical Layer:
Introduction to Computer Communication and Network : Network Topologies, Types of Network, OSI Model, Protocol Stack, Network Protocols. Analog Signals & Digital Signals. Data Transmission: Sampling, Transmission Mode. Analog Transmission: Modulation (Analog & Digital Signals). Multiplexing: FDM, WDM & TDM. Transmission Media: Guided Media, Unguided Media (Wireless). Circuit Switching.

Unit II - 10 Hrs – 20 Marks

Data Link Layer:
Error detection and correction: - Type of Errors, Detection, Error Correction, Framing.
Data Link Control and Protocols: - Flow and Error control, CRC, REC, FEC, Hamming Code, Stop-and Wait ARQ, Go-Back, N ARQ, Selective Repeat ARQ, HDLC.
ALOHA, CSMA, CSMA/CD.

Multiple Access: Random Access, Controlled Access, Area Network: Ethernet, Wireless LANS: IEEE 802-11, Frame Relay, ATM

Module-III: - 10 Hrs – 20 Marks

Network Layer: Host to Host Delivery: IP Addressing and Routing, Gateway, N/W Layer Protocols: ARP, IPV4, ICMP, IPV6, Transport Layer: Process-to-Process Delivery: UDP, TCP Congestion Control & Quality of Service.

Module-IV: - 8 Hrs – 20 Marks

Application Layer: Client Server Model, Domain Name System (DNS), E-mail (SMTP), File Transfer (FTP) HTTP, WWW.


Paper - VI : Management Information System

Unit I - 10 Hrs (20 marks)

Fundamentals of Information Systems, Systems approach to problem solving, Developing information system solutions, Levels of MIS (Top, Middle, Lower).

Unit II - 12 Hrs (20 marks)

Corporate Databases & Database Management, Data Organization, Data models, Data Security & Information quality.

Unit III - 15 Hrs (20 marks)

Transaction Processing Systems, Executive Information Systems, Decision Support Systems, Expert Systems, Information Systems in Marketing, Manufacturing, HRM, Accounting and Finance.

Unit IV - 10 Hrs (20 marks)

Information Resource Management, Planning Implementing & Controlling Information Systems, Computer Crime, Ethics & Society.


Address:
Sambalpur University
Jyoti Vihar, Sambalpur,
Odisha 768019
Phone:0663 243 0157

please sir provide me Bca second year syllabus of sambalpur university

Sir please provide me old question paper of bad at least 5year in all subject