Hide Notes 

Slide 1: SARDAR PATEL UNIVERSIT`Y BCA Proposed Syllabus under CBCS (effective from June 2010) SEMESTER-I TITLE Core Courses US01CBCA01 : Fundamentals of Computer Programming Using C US01CBCA02 : Computer Organization US01CBCA03 : PC Software US01CBCA04 : Web Designing Fundamentals US01CBCA05 : Practicals US01FBCA01 : Communication Skills in English-I US01FBCA02 : Mathematics-I US01EBCA01 : Digital Computer Electronics US01EBCA02 : Information Technology in Businesses Foundation Courses Elective NO. OF CREDITS 3 3 3 3 6 2 2 2 24 Total Credits SEMESTER-II TITLE Core Courses US02CBCA01 : Advanced C Programming and Introduction to Data NO. OF CREDITS 3 3 3 3 6 2 2 Structures US02CBCA02 : Systems Analysis and Design US02CBCA03 : Database Management Systems US02CBCA04 : Web Application Development US02CBCA05 : Practicals US02FBCA01 : Communication Skills in English-II US02FBCA02 : Mathematics-II US02EBCA01 : Desktop Publishing US02EBCA02 : RDBMS for small scale organizations US02EBCA03 : Management Information Systems US02EBCA04 : Business Data Processing Through COBOL Foundation Courses Elective 2 24 Total Credits
Slide 2: BCA-I Course : US01CBCA01 (Fundamentals of Computer Programming Using C) Effective from June - 2010 Credits Lectures per week :3 :3 All units carry equal weightage. Unit 1. Development of Algorithms and Flow Charts - Concept of an algorithm and a flow chart, need and definition - Symbols used to draw a flow chart - Typical (primitive) examples of flow charts and algorithms Unit 2. Language Fundamentals Generations of computer languages High-level and low-level languages Translators Introduction to Editors and details about one of the editors Problem analysis Variables, expressions & manipulation Data types in a high-level language, operators I/O statements, Assignment statements Unit 3. Logic Development Unit 4. Structured Programming - Control strategies, Conditions & Loop statements - Method of structured programming Unit 5. Complex Data Types and Command-line Arguments - Arrays, string handling. - Command-line arguments Unit 6. Functions Working with functions Calling functions, passing arguments Common standard library functions User-defined functions MAIN REFERENCE BOOKS : 1. Kernighan B., Ritchie D. : The C Programming Language, Prentice Hall. 2. Cooper H. & Mullish H : The Sprit of C, Jaico Publication House, New Delhi. 3. Balaguruswami : Programming in ANSI C., Tata McGraw Hill Publication.
Slide 3: Course : US01CBCA02 (Computer Organization) Effective from June - 2010 Credits Lectures per week :3 :3 All units carry equal weightage. Unit 1. Introduction to Computers - Block diagram of a simple computer and significance of different functional units - Evolution of computers - Definitions of the terms : hardware, software - Applications of computers Unit 2. Number systems - Binary, octal, decimal, and hexadecimal number systems - Conversion of numbers among binary, octal, decimal, and hexadecimal number systems - Addition and subtraction of binary numbers Unit 3. Representation of Information - Representation of integers - Character codes ( ASCII, Unicode ) - Error detection and correction codes Unit 4. Processor and its Functions - Instruction execution cycle - CPU organization - Parallel instruction execution - Array processors - Multiprocessors - Multiple functional units - Pipelining Unit 5. Memory and Addressing Techniques - Primary memory – Introduction to RAM, ROM, Cache, Registers - Secondary memory - Various types and organization of secondary storage devices such as magnetic disks, optical disks, flash memories. - Addressing techniques like Immediate, Direct, Indirect, Register, Indexing and Stack Common types of Input/Output devices, such as Monitors, keyboard, mouse Printers ( Line, Dot Matrix, Inkjet, Laser ) Scanners Unit 6. I/O Devices MAIN REFERENCE BOOKS : 1. Tanenbaum A.S. : Structured Computer Organization, Prentice-Hall of India Pvt. Ltd. 2. Rajaraman V. : Computer Fundamentals, Prentice-Hall of India Pvt. Ltd.
Slide 4: Course : US01CBCA03 (PC Software) Effective from June - 2010 Credits Lectures per week :3 :3 All units carry equal weightage. Unit 1. Introduction Introduction to personal computers Significance and use of a typical PC Operating System Introduction to Editors Classification of PC Software Introduction to word processing Examples of some popular word processing packages Uses of word processors Creation, editing, and formatting of documents Mail merge facility Global search & replacement of text. Page layout and printing of a document Spelling checker, Tables, Templates, Advanced features Introduction to spreadsheets Examples of some popular spreadsheet packages Uses of spreadsheet packages Addressing cells in a spreadsheet Building Spreadsheets using formulas, conditional calculations, built-in functions Graph-plotting facilities Sorting and filtering data Using externally created data files in a spreadsheet package What-if analysis, Protection facility Using pivot tables Applications of Spreadsheets Unit 2. Word Processing - I Unit 3. Word Processing - II Unit 4. Spreadsheet - I Unit 5. Spreadsheet - II - Unit 6. Presentation tools - Introduction to presentation tools Creating a presentation Formatting slides Slide transition and adding special effects Inserting pictures, sound, charts MAIN REFERENCE BOOKS : 1. Taxali R.K : PC Software for windows made simple, Tata Publishing Co. Ltd. 2. Manuals of PC Software. McGraw-Hill
Slide 5: Course : US01CBCA04 (Web Designing Fundamentals) Effective from June - 2010 Credits Lectures per week :3 :3 All units carry equal weightage. Unit 1. The Internet Introduction to the Internet History of the Internet Services provided by the Internet Some basic terminology and concepts (WWW, URL, webpage, web site, web servers, web browsers, HTML, search engines, etc.) Components of a browser window Use of menus and toolbar buttons History and navigation Setting basic options, security and privacy precautions Managing bookmarks/favorites Tabbed browsing, downloading files, saving web pages for offline reading An introduction to HTML HTML tags Structure of an HTML document Text and paragraph formatting Ordered and unordered lists, nested lists HTML tables Links Images Unit 2. Features of Popular Internet Browsers - Unit 3. Web Page Designing-I Unit 4. Web Page Designing-II Unit 5. Frames and Forms - Frames, framesets, nested framesets - Designing HTML forms - Webpage layout Unit 6. Website Development Tool - Introduction - Key features - Developing websites using the tool MAIN REFERENCE BOOKS: 1. Ivan Bayross, “Web Enabled Commercial Applications Development using HTML, DHTML, Javascript, Perl CGI”, BPB, 2004 2. Douglas E Comer: The Internet, PHI, Second Edition,May 2000 3. Xavier C : World Wide Web Design With HTML, Tata McGraw Hill Publication, 2000 4. Manuals of suitable packages
Slide 6: Course : US01CBCA05 (Practicals) Effective from June - 2010 Credits :6 Practicals per week : 12 Hours University examination duration : 4 Hours Part-I : Weightage-50%  Practical based on computer programming using C Part-II : Weightage-50%  Practical based on PC software and HTML Sample Practical Exercises: Develop algorithms/flow charts/C programs for the following : 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. To prepare a cup of tea. To open a bank account. To purchase a railway ticket for Bombay ( from Anand ). To find maximum from the given three numbers. To find simple interest. To read three sides of a triangle and print whether it will form a triangle or not To find the solution of quadratic equation. To find out N! ( factorial of N ). To find out minimum from N numbers. To find whether given number is prime or not. To print the N terms of fibonacci series. ( i.e. 1, 1, 2, 3, 5, 8, 11 … ). To read a number & check whether it is a palindrome or not. To find out value of NCR. Find the sum of the following series : 14. Sum = 1 + 3 + 5 + 7 ….. up to N terms. 15. Sum = 5 - 10 + 15 - 20 + 25 ….. up to N terms. 16. Sum = 1 + 1 + 2 + 3 + 5 + 8 + 13 ….. up to N terms. 17. Sum = 12 + 22 + 32 + 42 + 52 ….. up to N terms. 18. Sum = 1! + 2! + 3! + 4! ….. up to N terms. 19. Read marks of three subjects and find the percentage of it. Also, print the appropriate class. Here, If percentage < 40 then class is ‘fail’ If 40 <= percentage < 48 then class is ‘pass’ If 48 <= percentage < 60 then class is ‘second’ Else class is ‘first’. Find the value of SUM for the following. 20. SUM = X + X / 2! + X / 3! + X / 4! ….. up to N terms. 21. SUM = 1 - ½ + 1/3 - ¼ + 1/5 ….. up to N terms.
Slide 7: 22. To find the sum of the digits in a given positive numbers. 23. To input a time as a number of seconds after midpoint and outputs it as hours : minutes : seconds. For example, if the input were 50000 the output should be 13 : 53 : 20. 24. To read the price of one dozen bananas and calculate and print the total cost of N bananas. 25. To read a number and find whether it is divisible by two or not. 26. To accept a positive integer and check whether it is one-digited, two-digited or three-digited otherwise print appropriate message. Sample Practical Exercises: [A] 1. Microsoft Word Creating the documents with Special effects like underline, bold, different size, different font, different color. Etc. Find and Replace operations like cut, paste, copy, clipboard. Inserting Date & Time, Pictures, Bullets & Numbering etc. Paragraphs, bullets, indentation etc. Formatting features. Printing the documents, it includes paper-size, margins, header and footer, page no. etc. Creating a table. Mailmerge, spellcheck, drawing table. Template. Creating a presentation Inserting/Deleting slides Different slide views Editing slides Formatting slides Slide transition & additing special effects Inserting sound, picture, chart, organization chart 2. Microsoft PowerPoint 3. Microsoft Excel - Creating Worksheets - Printing, Inserting, Deleting, Copying, Moving worksheets. - Formulas, built-in functions - Graph-Plotting facilities - Database Management System - Using extenternally created data files. - What – if analysis - Formatting cells, Worksheets etc. - Custom Controls - Protection facility - Pivot tables - Macro facility [B] HTML Development of simple web sites using features covered in US01CBCA04.
Slide 8: Course : US01FBCA01 (Communication Skills in English-I) Effective from June - 2010 Credits : 2 All units carry equal weightage. Unit 1. Reading Skills 1. 2. 3. 4. 5. 1. 2. 3. 4. Mechanics of Reading i.e. Eye Movement and Different Reading Styles Issues of Reading Speed and Comprehension Value Reading Gears for different reading purposes Skimming & Scanning Skills Barriers to Effective Reading Importance and purpose of Listening. Barriers to Effective Listening. Ways of improving Listening Skills. Giving Feedbacks i.e Confirmatory and Corrective Unit 2. Listening & Feedback Skills Unit 3. Writing Skills 1. Form words properly using prefixes/suffixes (See the Appendix) 2. Use Phrasal Verbs (See the Appendix) 3. Writing formal letters of invitation (inviting/accepting/declining), letters of complaint and intimation to civil authorities. 4. Paragraph development ie. Topics sentence and supporting sentence, attributes of a god paragraph, types of paragraphs. 5. Writing dialogue on given topics Unit 4. Speaking Skills 1. Use greeting and formulae in everyday conversation 2. Notions and Functions of everyday usage (See the Appendix) 3. Parts of Speech, Types of Sentences, Tenses, Imperatives, Modals, Voice, Determiners, Concord, Interrogation and Negation, basic prepositions 4. Use of Phrasal Verbs Constructions and Registers. 5. Connectives and Linkages (See the Appendix). MAIN REFERENCE BOOKS: 1. Meenakshi Raman & Sangita Sharma, Technical Communication; Principles and Practice , Oxford University Press 2. Chrissie Wright, Communication Skills, Jaico Publication 3. Grant Taylor, English Conversation Practice, New Delhi: Tata McGraw Hill 4. R P Bhatanagar and R T Bell, Communication in English, Hyderabad, Orient Longman. 5. D Sasikumar and P V Dhamija, Spoken English, New Delhi: Tata McGraw Hill 6. M. Farhathullah, Communication Skills for Technical Students 7. Champa Tickoo and Jaya Sasikumar, Writing with a Purpose, Chennai, OUP 8. David Jolly, Writing Tasks: Authentic task approach to individual Writing needs, Cambridge University Press
Slide 9: Course : US01FBCA02 (Mathematics-I) Effective from June - 2010 Credits Lectures per week :2 :2 All units carry equal weightage. Unit 1. Sets Set operations, algebra of sets, finite sets, power set, mathematical induction, symmetric difference, functions, composition of functions, one to one, onto and invertible functions, recursively defined functions, polynomial functions. Unit 2. Algebraic Systems Binary operations, semi groups, groups, homomorphism, rings, domains, fields. integral Unit 3. Matrices Vectors in n, dot product and norm on n, matrix addition, matrix multiplication, scalar multiplication, transpose of a matrix, symmetric and skew symmetric matrices, upper and lower triangular matrices, determinant of matrices up to order 3. Discrete frequency distribution, cumulative frequency distribution, graphical representation, histograms and pi charts, measures of central tendency: mean, median, mode, geometric and harmonic means. Unit 4. Elementary Data Analysis MAIN REFERENCE BOOKS : 1. S. Lipschutz and M. l. Lipson, Discrete Mathematics, Schaum’s Series (International Edition 1992). 2. S. C Gupta, Fundamentals of Statistics, Himalaya Publishing House 2004. 3. S. P Gupta, Statistical Methods, Sultan Chan and sons, 2004.
Slide 10: Elective Students are required to take one of the following courses as an elective. US01EBCA01 US01EBCA02 Course : US01EBCA01 (Digital Computer Electronics) Effective from June - 2010 Credits Lectures per week :2 :2 All units carry equal weightage. Unit 1. Gates and Boolean Algebra - Gates, Boolean algebra, Truth tables - Circuit equivalence, De Morgan's theorems Unit 2. Basic Digital Logic Circuits-I - Usage of Karnaugh maps - Encoders, decoders, comparators Unit 3. Basic Digital Logic Circuits-II - Half adder, full adder, binary adder-subtractor - Multiplexers Unit 4. Memory Elements & Counters - D Flip flops - Shift-left, shift-right and controlled buffer registers - Ring counters MAIN REFERENCE BOOKS : 1. Malvino A. P.: Digital Computer Electronics,2nd Edition, Tata McGraw, Hill Pub. Co. Ltd.,New Delhi, 1990. 2. Gothmann, William H. : Digital Electronics - An Introduction to Theory and Practice, 2nd Edition,PHI,1982. BOOKS FOR ADDITIONAL READING : 1. Tanenbaum A. S. : Structured Computer Organization, 3rd Edition, Prentice-Hall of India Pvt. Ltd., 1993. 2. Hall Douglas V. : Microprocessors and Interfacing - Programming and Hardware., McGraw Hill Book Company, 1986. 3. M.M. Mano : Computer System Architecture, 3rd Edition, Pearson Education, 2000.
Slide 11: US01EBCA02 (Information Technology in Businesses) Effective from June - 2010 Credits Lectures per week :2 :2 All units carry equal weightage. Unit 1. Introduction to Information Systems - I Categories of information, the data pyramid Information systems and technologies Importance of information systems in businesses Information system activities – input, processing, output, storage, control of system performance Components of an information system Information system resources – people, hardware, software, data, network Gaining strategic advantage through IT Managerial Challenges of IT Unit 2. Introduction to Information Systems - II - Unit 3. Functional Business Systems - An introduction to information systems for manufacturing, marketing, accounting, human resources management, financial management, inventory management, etc. Unit 4. Introduction to Enterprise Applications - An introduction to Enterprise Resource Planning, Customer Relationship Management, Supply Chain Management, E-commerce systems MAIN REFERENCE BOOKS : 1. O’Brien J. : Management Information Systems, Tata McGraw-Hill, 2004 2. Jessup L., Valacich J. : Information Systems Today – Why IS Matters, Pearson Education, 2006