Syllabus for
Bachelor of Computer Applications
Academic Year  (2021)

Bachelor of Computer Applications is a 3-year undergraduate programme spread over six semesters. The course is designed to bridge the gap between IT industries and academic institutes by incorporating the latest developments into the curriculum and to give students a complete understanding within a structured framework. The curriculum supports students to gain adequate programming practices along with a theoretical foundation and also includes interdisciplinary courses and electives for widening the domain expertise. State-of-the-art infrastructure provides an excellent learning environment to hone the knowledge of each student. 

Programme Outcome/Programme Learning Goals/Programme Learning Outcome:

PO2: Problem Analysis: Analyze real-time problems using various tools and techniques.

PO3: Design and Development: Design and develop solutions to meet the desired needs.

PO4: State-of-art Technologies: Adapt and apply emerging tools and technologies.

PO5: Entrepreneurship and Innovation: Provide sustainable and innovative solutions for real-time problems.

PO6: Lifelong Learning: Engage in continuous reflective learning in the context of technological advancement.

PO7: Communication and Team Building: Demonstrate effective communication and interpersonal skills.

CIA: 50%

ESE: 50%

MS-WORD

The purpose of this course is to teach students to identify word processing terminology and concepts, Create technical documents, Animation and Design document, format and edit documents, use simple tools and utilities, Mail merge concepts and Mathematical expressions.

MS-EXCEL

This course will teach you the skills you'll need to successfully use Excel. This course will start with basic skills, and then move forward to more advanced features and techniques.

MS-WORD

1. Create and Design Admission/Enquiry Forms in Microsoft Word.
2. Create a mail to ‘n’ number of contacts from label and send mail to ‘n’ number of contacts selected from label using mail merge.
3. Prepare a document about any topic in mathematics which uses mathematical symbols.
   At least 5 mathematical symbols should be used.
   Assign a password for the document to protect it from unauthorized access.
   Demonstrate the use of Hyperlink Option.
   Write a macro that sets margins to your document, a font of size and double spaced document.

      4. Create and Design Seminar/Conference/Workshop brochure.

MS-EXCEL

1.      Enter the order id, product name, unit price, quantity and discount. Perform      the following operation using MS – Excel.

2.      Enter the following details of 20 students data’s in column wise, s.no, roll no, name, test – 1, test –   2 and test – 3 marks, total, mention and grade from

     Cell A to h and do the following operations in excel

a. Calculate the total score of each student

b. Display the word "Fail" if the student failed and "Pass" if the student passed in Mention column.
c. Students are considered failed if their total is less than 30. Otherwise, they pass.

d. Count the number of students who failed in subject wise

e. Count the number of students who passed in a subject in the column "# of passed students.

f. Calculate the percentage of students who failed in all subjects and write "% of failed students"

g. Calculate the percentage of students who passed in all subjects write "% of passed students"
Format the cell in percentage <="80--"> <="75--"> <="70--"> <="65--"> <="55--"> <="50--"> <="45--"> <="40--">

h. Display grade letter of each student in Grade column, based on the following conditions:

75 <total Score <=80   à A

70 <total Score <=85   à B+

65 <total Score <=70   à B

55 <total Score <=65   à C+

50 <total Score <=55   à C

45 <total Score <=50   à D+

40 <total Score <=45   à D

35 <total Score <=40   à E+

30 <total Score <=35   à E

Total Score < 30   à F

3.      Create a basic calculator with VBA in Excel.

4.      Write some code in VBA (Visual Basic for Application) to manipulate records in Excel spreadsheet and work with VBA user form to build graphic user interface application.
In case that you have a lot of records in your data sheets, manipulating records--add new, update, save, delete, move, and find record is hard. With VBA, you can solve this problem.

5.      Write some code in VBA (Visual Basic for Application) to manipulate records in Excel spreadsheet and work with VBA user form to build graphic user interface application.
In case that you have a lot of records in your data sheets, manipulating records--add new, update, save, delete, move, and find record is hard. With VBA, you can solve this problem.

6.      Prepare a pay-bill using a worksheet. The work sheet should contain

          Employee Id, Name, Designation, Experience and Basic Salary and Job ID.

          If Job Id is 1 then DA is 45% of the basic salary. HRA is Rs. 5500.
          If Job Id is 2 then DA is 40% of the basic salary. HRA is Rs. 4500. For all

          the other Job ids DA is 35% of the basic salary and HRA is Rs. 3500. For all

          the above Job ids PF to be deducted is 4%. For the job ids 1&2 Rs. 100 to be

          deducted as Professional Tax.

a.       Find the net pay. 
b. Use filter to display the details of employees whose salary is greater than 10,000.
c. Sort the employees on the basis of their net pay. 
Use  advance  filter  to  display  the  details  of  employees  whose  designation  is Programmer and Net Pay is greater than 20,000 with experience greater than 2 yrs.

7. Using Excel project the Product sales for any five products for five years.

 a. Compute the total sales of each product in the five years.
 b. Compute the total sales of all the products in five year.
 c. Compute the total sales of all products for each year.
 d. Represent annual sale of all the products using Pie-Chart
 e. Represent annual sales of all products using Bar Chart.
 f. Represent sale of a product for five years using Pie-Chart.
 g. Label and format the graphs.

This course focuses on  preparing students to communicate verbally and non-verballyin an effective manner. The aim is to introduce students to communication in a professional environment. It is instrumental in learners comprehending the role of technical english in communication. 

Objectives:

1. Introduce learners to language skills in their area of specialisation.

2. Enavle them to enhance career prospects and employability through English langiage skills

3. Help students gain understanding of language at the workplace

4. To develop verbal and non-verbal skills in English communication

This unit undertakes to revise the foundation of language; the grammar section of language learning. Students will be reviewed the grammar aspects mentioned through task based activities

Concept of time in language – reflective learning will be used to help students detect their grammatical errors in tenses and rectify.

§  Degrees of comparison – using technical literature students can be engaged in apprehending degrees of comparison

§  Direct and reported speech – to enable learners carry on a comprehensible conversation either spoken or written, in a business context

§  Subject verb agreement – through worksheets and task based learning students will be familiarized to construct error free sentences

§  

Learners will be acquainted with the basic of English language learning. They will be taught to identifying technical vocabulary from the general. Technical magazines prescribed by the institution that are subject specific can be used as teaching tools.

§  Introduction to technical lexicon – help students identify jargon and technical terminologies. Assist them comprehend the significance of implementation with moderation through their subject literature.

§  Internet lexis and contextualisation – provide meanings accurately to ensure right exercise of terms in a professional scenario through hands-on experience

§  Circumstantial usage of diction – aid the comprehension of word usage as verbs and nouns based on the requirement. Differentiating the meanings of synonyms and their orientation in a text

§  Integrating technical vocabulary in describing process and procedure – through prescribed texts students can be made to enhance their language by right integration of diction.

§  Mind mapping of textual diction and allied words – diagrammatically mapping of words based on their meaning, context and usage will re-emphasise the words in the minds of the learners

[2] Carter, Ronald and Michael McCarthy. Cambridge Grammar of English. CUP, 2006.

[3] Leech, Geoffrey, Jan Svartvik. A Communicative Grammar of English. Third Edition. New Delhi: Pearson Education, 2009.

Knapp .M. Essentials of Non-Verbal Communication Theory Rea. FL: Harcourt, 1995.

MID SEMESTER EXAM - 50

CIA II -20

Course Description: This course aims at introducing the students into the world of Discrete Mathematics. It includes the topic like Mathematical Logic, Method of proofs, Mathematical induction, Permutations and combinations and Binomial coefficients. Also, this course emphasizes general techniques of problem solving and explores the creation of mathematical patterns.

Course Objective: This course will help the learner to

COBJ1. understand and use the notions of Mathematical Logic.

COBJ2. give proofs for Mathematical problems by using different methods of proofs

COBJ3. prove the mathematical problems/statements by using Mathematical Induction

COBJ4. use the permutations,combinations,binomial coefficients for solving problems appropriate problems

Propositional Logic, Applications of Propositional Logic, Propositional Equivalences, Predicates and Quantifiers.

Nested Quantifiers, Rules of Inference, Introduction to Proofs, Proof Methods and Strategy.

Mathematical Induction (Pg.311-333), The Basics of Counting, The PigeonholePrinciple, Permutations and Combinations, Binomial Coefficients and Identities

ESE - Question Paper Pattern

To acquaint students with various statistical methods.
To cultivate statistical thinking among students.
To prepare students for future courses having quantitative components. 

Importance of Statistics, Primary and secondary data, data collection methods. Presentation of numerical and categorical data. 

Mean, median, mode and partition values-quartiles for grouped and ungrouped data. Range, quartile deviation, standard deviation and coefficient of variation for grouped data 

ESE: 50%

This is an introductory course that provides the required knowledge about the digital fundamentals of computers. The course covers a few topics like number systems, logic gates, and flips flops. The course starts with an introduction to number systems and its applications in computers. The discussion about the working of devices like encoders and decoders, multiplexers, and demultiplexers are dealt with.

Number systems: Decimal numbers, Binary numbers: Counting in binary, The weighted structure of binary numbers, Octal numbers, hexadecimal numbers, and their mutual conversions, Binary arithmetic: Addition, subtraction, multiplication, and division of binary numbers, 1‘s and 2‘s complement, signed numbers, arithmetic operations: addition, subtraction with signed numbers, 9‘s and 10‘s complement, BCD numbers, BCD addition, BCD subtraction, Gray code: Binary to Gray code conversion, Gray to Binary conversion, Weighted code: 8421 code and non-weighted codes: ASCII and EBCDIC.

Boolean operations and expressions, Laws and rules of boolean algebra, Demorgan‘s Theorem, Boolean expressions, Simplification of a Boolean expression.

AND gate, OR gate, NOT gate, NAND gate, NOR gate, X-OR gate, X-NOR gate, The universal property of NAND gate and NOR gate, Realization of basic gates. The boolean expression for logic circuits, Karnaugh map SOP with examples.

Self learning: Universal property of NOR gates.

Bartee, Thomas C: Digital Computer Fundamentals, 6 Edition,TMH, 2010.

ESE - 50%

The course provides students with a comprehensive study of C programming language. The course lectures stress the strengths of C, which provides the outcome of writing efficient, maintainable and portable code. Course includes few lab exercises to make sure the student has not only gained the knowledge but can also apply and execute it. Objectives of the course are,

·         To study about algorithms, flowcharts and programs.

·         To solve problems through logical thinking.

Evolution of Computers, Generation of Computers, Classification of Computers.Characteristics of Computers. Advantages of Computers. Block Diagram of a Digital Computer. Types of Programming Languages.Structured Programming.Algorithms and Flowcharts with Examples.Programming Logic.

History of C- Character set - Structure of a C program - constants, variables and keywords. Expressions – Statements – Operators – Arithmetic, Unary, Relational and logical, Assignment, Conditional. Library functions. Data Input and output – Single character input, getchar, getch, getc – Single character output putchar, putc, Formatted I/O scanf, printf, gets, puts.

Branching: condition: if, if..else, switch. Looping: while, do..while, for, nested control structures, break, continue statement, goto statement. Arrays: definition, processing, types - One and Two dimensional arrays. String, string operations, arrays of strings.

[1]    Balagurusamy E., Programming in ANSI C, 6thEdition,TataMcGraw-Hill,2012.

[2]    Deitel H M and Deitel P J, C- How to Program, 5thEdition, Prentice-Hall, 2006.

[3]   SmarajitGhosh, All of ‘C’,2ndEdition,2009.

[4]    M. T. Somashekara, Problem Solving with C, PHI,2009

ESE - 50%

This course offers an experimental view of hardware components, digital circuits and logic gates of a computer. Objective of the course is to understand the working principle and logic design of digital circuits.

1. Demonstration of the components of (i) Kindle (ii) iPad (iii) Smart Phone (iv) Laptops

2. Demonstration of the installation and discussion of the features of different Operating

Systems. Eg: Mac, Unix, Ubuntu, Windows etc.

3. Verification of the truth tables of AND, OR & NOT gates.

4. Verification of the truth tables of NAND & NOR gates.

5. Verification of the truth table of XOR using NAND gates.

6. Verification of the truth table of Half Adder circuits using NAND gates.

7. Verification of the truth table of Full Adder circuits using NAND gates.

8. Verification of the truth table of D flip flop.

9. Verification of the truth table of JK flip flop.

10. Verification of the truth table of RS flip flop.

11. Binary To Gray Code and Gray Code to Binary Converter

12. Verification of the Function table of Binary Ripple Counter using JK FF.

13. Verification of the Function table of Decade Counter.

14. Verification of the Function table of Serial In Serial Out Shift Register using D FF.

Bartee, Thomas C: Digital Computer Fundamentals, 6 Edition,TMH, 2010.

ESE - 50%

To learn problem solving through procedural language programming technique and Understand fundamentals of programming such as variables, conditional and iterative execution, methods, etc.

1. To demonstrate the usage of operators and data types in C

a.       Write a program to print the size of all the data types with its modifiers supported by C and its range.

2. Write a program to convert Fahrenheit to Celsius.

2. To demonstrate the usage of if, if-else

a. Write a program to check whether the given number is a Prime number or not.

b. Write a program to accept three numbers and find the largest and second largest among them.

3. To demonstrate the concept of while, do-while, for loops, break and continue

a. Write a program to print all prime numbers between any 2 given limits.

b. Write a program to print all the Armstrong numbers between any 2 given limits.

4. To demonstrate the concept of arrays and strings

a. Write a program to check whether a string is a Palindrome.

b. Write a program to check whether a given matrix is an Identity matrix or not.

c. Write a program to perform matrix multiplication.

5. To demonstrate the concept of switch-case

a. Write a program to count the different vowels in a line of text.

b. Write a program to accept two numbers and perform various arithmetic operations (+, -, *, /) based on the symbol entered.

6. To demonstrate the usage of functions and recursion

a. Write a program to find the roots of a quadratic equation

b. Write a recursive program to find the factorial of a number.

7. To demonstrate the concept of structures and unions

a. Create an employee structure and display the same.

b. Create a student database storing the roll no, name, class etc. Implement modify and search operations.

8. To demonstrate the concept of

a. Write a function to swap two numbers using pointers

b. Write a program to access an array of integers using pointers

9. To demonstrate the concept of File

a. Create a file and store some records in it. Display the contents of the same. Implement search, modify, and delete operations.

10. To demonstrate the concept of Bitwise operators and preprocessors

a. Perform the different bitwise operations (menu driven program) .The i/p and the o/p should be displayed in Binary form.

b. Write a program to include your own header file.

Text Books and Reference Books

[1]   Byron Gottfried, JitenderChhabra ,Programming with C, 3rd Edition. Tata McGraw-Hill, 2010

[1]    Balagurusamy E., Programming in ANSI C, 6^thEdition,Tata McGraw-Hill,2012.

[2]    Deitel H M and Deitel P J, C - How to Program, 5^thEdition, Prentice-Hall, 2006.

[3]    SmarajitGhosh, All of ‘C’,2^ndEdition, 2009.

[4]    M. T. Somashekara, Problem Solving with C, PHI, 2009

ESE weightage 50%

This course is designed to help the students to explore and provide statistical knowledge with pragmatic tools for statistical analysis. The main objective of the course is to provide Hands-on Experience on any Statistical Tool.

1.      Calculate mean, median, mode and display results in proper format.

2.      Calculate the product and sum of two vectors.

3.      Calculate Range, quartile deviation, standard deviation and coefficient of variation for grouped data.

4.      Partition values-quartiles for grouped and ungrouped data and display formatted results.

5.      Data Base Creation (including vector, matrix, data frames).

6.      Graphical representation (Bar, Pie, Line, Histogram, Scatter).

7.      Cross tabulation and Descriptive Statistics.

8.      Implement Correlation.

9.      Perform simple Regression and show results in chart.

10.  Testing of hypothesis for single mean.

11.  Testing of hypothesis for comparison of means.

12.  Chi-square test for independence of attributes.

communicative english BCA 221

Course Description:

This course focuses on making students understand the vitality of English as a tool in implementing and; interpreting technical and professional communication. The course aims at detecting and nurturing research skills through English for professional development. A holistic approach to recognize the fundamental role of language in technical communication is undertaken.

Course Objective:

§  Nurture an enquiring spirit through English language in Technical communication

§  Enhance English implementation in English learning for professional purposes

§  Encourage students towards autonomous learning through enhanced English comprehension that go beyond the classroom

The most regularly used words in their field of knowledge, the most often committed mistakes and their right pronunciation will be given to the students. Applications available in this context can be made familiar to learners.

§  Phonetics – students can me taught phonetics through phonetic apps that enable the student to relate the symbol with the sound. They can be taught to read and transcribe words to ensure ample understanding

§  Commonly mispronounced words – technical vocabulary can be focused here. Audio sessions can be implemented to enable auditory retention

§  Common errors in grammar – cooperative language learning will help students familiarize common errors and rectifications

Students need to learn to read and study literature of their subject. Any form of literature in context to the subject can be taken and students can be involved in these chapters mentioned below

§  Comprehensive questioning of procedural writings &  Comprehension answering of procedural queries – through subject based literature students can be taught cognition and responding to the prescribed material through writing and speaking

§  Issuing of instructions – instructions being an integral part of their area of expertise, students need to be made familiar with the sequencing and of ideas and brevity of language. This can be carried out through written and spoken format.

§  Procedural instructions – a set of operating procedures for a piece of technical equipment can be carried out in through first through oral presentations and writing exercises

§  Discussion of processes, errors or glitches – going beyond the usual, students must be acquainted with dealing the nitty-gritty of technical literature. They must be taught to spell out glitches or errors to enable smooth functioning

An integral part of in-depth learning involves research. In this unit research will be introduced to the students. The nuances of  exploratory study and their approaches will be made familiar to the students

§  Structure of the essay – students need to be familiarized on the format and elements that contribute to a holistic essay. Deconstruction of essays can be carried out through cooperative learning and deliberated.

§  Topic sentence recognition – Technical English calls for detection of topic sentence recognition of any technical literature. Students can be taught on detecting keywords and significant concepts that will aid in the process

§  Thesis statement identification – research publications are an integral part of technical writing. Students can be provided research articles and familiarized on the format and texture of a thesis statement

§  Interpretation of data – quantitative study is entirely dependent on data analysis and interpretation. The language to be used in the process can be fine-tuned for the students through case studies of the same

§  Comprehension, organization of ideas and execution of writing project proposal – once learners have been taught the elements of a research paper, they can be encouraged to work in groups and draft their own research paper integrating all the major elements.

[2] Meenakshi Raman and Sangeetha Sharama . 2009. Technical Communication-Principles and Practice; - Oxford University Press,

[3] Jay. Effective Presentation. New Delhi: Pearson, 2009.

Lynch, Tony. Study Listening. New Delhi. CUP, 2008.

MID SEMESTER EXAMINATION - 50

CIA II - 20

Course Description: This course aims at introducing the students into the world of Discrete Mathematics. It includes the topic like Set Theory, Functions and Relations. They gain a historical perspective of the development of modern discrete mathematics and application of the same in the field of Computer Science.

Course Objectives: This course will help the learner to

COBJ1. be proficient in the topics set theory, functions and relations.

COBJ2. enhance the problems solving skills in set theory, functions, relations, sequences, series and matrices

CO1. Demonstrate a working knowledge of set notation and elementary set theory, recognize the connection between set operations and logic
CO2. Prove elementary results involving sets
CO3. Apply the different properties of injections, surjections, bijections, compositions, and inverse functions
CO4. Demonstrate the use of mathematical reasoning by justifying and generalizing patterns and relations
CO5. Determine when a relation is reflexive, symmetric, antisymmetric, or transitive, apply the properties of equivalence relations and partial orderings, and explain the connection between equivalence relations 

Sets, Set Operations, Functions

Sequences and Summations, Cardinality of Sets, Matrices

Relations and Their Properties, Equivalence Relations, Partial Orderings 

 The course statistics-II describes the concept of correlation and regression, probability distribution and testing hypothesis.

 Objectives of the course are 

• To acquaint students with various statistical methods.
• To cultivate statistical thinking among students.
• To train the students to apply the suitable statistical methods for real life data set for analysis.

Scatter diagram, Karl Pearson’s and Spearman’s correlation coefficient and their properties. Regression and properties of regression coefficient.

ESE 50%

Course Objectives

This course is an introduction to the concepts behind modern computer operating systems. Topics will include what an operating system does (and doesn't) do, system calls and  interfaces, processes, resource scheduling and management (of the CPU,  memory,  etc.),  virtual memory.

Objectives of the course are

To acquire the fundamental knowledge of the operating system architecture and its components

To know the various operations performed by the operating system.

Operating System Fundamentals; Computer System organization and architecture; Operating System structure and operations; Basics of process, memory and storage management and protection and security; Operating System services; User interface; System calls; System programs; Operating System structure; System boot.

Process concept; Process scheduling; Operations on processes; Inter Process Communication; Overview of Threads; Multi-threading models; Threading issues

Need of synchronization; Critical section problems; Peterson‘s solution; Synchronization hardware; Mutex Locks; Semaphores, Classical  problems  of  synchronization, Synchronization examples, Thread synchronization using mutex and semaphore.

[1] A. Silberschatz, P.B. Galvin and G. Gagne, Operating System Concepts.9th Edition, New Delhi: Wiley India, 2011.

[1]   Stalling William, Operating Systems: Internals and Design  Principles.  7th  Edition, Prentice Hall,2011.

[2]   Dietel et al, Operating System.3rd Edition. Pearson Education,2004.

[3]    A.S. Tanenbaum, Modern Operating Systems.3rd Ed, Prentice Hall,2007.

ESE : 50

Data Structure is considered as one of the fundamental paper towards a more comprehensive understanding of programming and application development. The student is expected to work towards a sound theoretical understanding of Data Structures and also compliment the same with hands-on implementing experience.

Objectives of the course are

- Tobeabletopracticallyimplementthedatastructureslikestack, queue, array, etc.

- To understand and implement different searching and sorting techniques.

Introduction to data structures- Arrays and Structures: Abstract Data Type, Array in C, Dynamically Allocated Arrays, Structures, Unions, Internal Implementation of Structures, Self-Referential Structures, Polynomial Representation, Polynomial Additions.-sparse matrix

Linear Search, Iterative Binary Search, Recursions, Recursive Binary Search, String Abstract Data Type, String in C, Pattern Matching.

Stacks- stacks using dynamic arrays- queues – circular queue using dynamic arrays- Evaluation of Expressions, Evaluating Postfix Expressions, Infix toPostfix

[2] Tremblay J.P and Sorenson P.G: An Introduction to Data Structures with Applications,2nd  Edition, 2002, TMH.

ESE---50%

Course Objectives

This lab introduces basic commands in LINUX and helps students in familiarizing  the  concepts of operating system through various commands related to  operating  system  activities.

[1] A. Silberschatz, P.B. Galvin and G. Gagne, Operating System Concepts.9th Edition, New Delhi: Wiley India, 2011.

ESE : 50

The course is designed to provide a practical exposure on data structure and its applications.

1. Strings:

   1. Write a menu driven program to compare, concatenate, copy strings and find the length of astring.

   2. Write a menu driven program to find the index of a pattern in a given string and to extract asubstring.

2. Arrays

   1. Write a program to insert and delete an element(s) in one dimensionalarray.

   2. Write a program to insert and delete an element(s) in twodimensional arrays.

3. Sparse Matrix

   1. Write a menu driven program to read a sparse matrix of integer values and to search the sparse matrix for any element specified by theuser.

   2. Write a program to print the appropriately triple < row, column, "value" > that represents the elements in the sparsematrix.

4. SearchingTechniques:

   1. Write a program to implement Linear Search withsentinels

   2. Write a program to implement Binary Search usingrecursion

5. Sortingtechniques:

   1. Write a menu driven program to implement insertionsort

   2. Write a menu driven program to implement selectionsort.

   3. Write a menu driven program to implement quick sort usingrecursion

   4. Write a menu driven program to implement merge sort usingrecursion.

6. Singly linkedlist:

   1. Write a menu driven program to implement singly linked lists creation, insertion and deletion

7. Stack:

   1. Write a menu driven program to implement different operations on a stack using an array and linkedlist.

8. Queue:

   1. Write a menu driven program to implement different operations on a queue using an array and linkedlist.

9. Binary searchtrees:

   1. Write a menu driven program to create a binary search tree and to perform Insertion and different types oftraversal

10. Graphs:

    1. Write a menu driven program to implement breadth first search(bfs)

    2. Write a menu driven program to implement depth first search(dfs)

Category	Component	Description	Marks
Part -1 CIA-100 Marks	CIA	Section A Programs	25
		Section B Programs	25
		Section C Programs	25
		Section D Programs	25
Part-2 ESE-100 Marks	Test1	Questions based-on Section A	20
	Test2	Questions based-on Section A (and/or) B	25
	Test3	Questions based-on Section A (and/or) B (and/or) C	25
	Test4	Questions based-on Section A (and/or) B (and/or) C (and/or) D	30
		Total	200

- CIA is the regular assessment of programs from the list having four sections (A-D). Each program carries 25 marks and the average in each section is considered for final CIA.

- Evaluation Rubrics for each program in CIA is asfollows:

Attendance andon-timecompletion [5Marks]

Draft(observation) & Final Program(upload) [5Marks]

Complexity (Concepts&Operations) [5Marks]

FormattingandValidation [5Marks]

Viva-voce [5Marks]

- If a student fails to appear for any of the Test, there will be only one repeat test conducted in the last week of the semester. To appear for the repeat test, the student has to apply for the same in the format given by the class teacher and by paying the required fee, one week before the scheduled date. Appearance in the re-test is subject to the approval by the Course teacher, Programme Coordinator and Head of theDepartment.

The main objective of this tools lab is to practically implement the concepts in accounting.

1.     Creation of inventory groups andledgers.

2.     Consider an asset with an initial cost of Rs10000, a salvage value (residual value) of Rs1000

       and a useful life of 10 periods (years).Solve the above using Straight Line Depreciation.    

3.     Vouchers, types and vouchers entry.

4.     Creation of various accounting Ledgers.

5.     Purchase order and sales order processing.

6.     Generating trial balance, income statement and balancesheet.

7.     Displaying Income statement and balance sheet under different options and time periods

8.     Creation of pay rollrecords.

9.     Recording of Pay roll information and salary statement.

ESE:50%

This course aims at familiarizing the students with the basic concepts, some important results and proofs in Number Theory and includes some fundamental theories required for learning cryptography. It also introduces the students to some of the fundamental concepts of Group Theory.

• Define and interpret the concepts of divisibility, congruence, greatest common divisor, prime, and prime-factorization.
• Solve congruences of various types, and make use of the theory of congruences in perceiving applications in cryptography.
• Define and analyze groups, semigroups, subgroups, order of an element, cyclic groups, coset decomposition and prove theorems related to these concepts.

Divisibility, Division Algorithm, Modular Arithmetic, Application of Congruences, Cryptology, Primes and Greatest Common Divisors

Representation of Integers, Algorithms, Modular Exponentiation, Euclidean Algorithm, Results on Congruences, Chinese Remainder Theorem, Fermat's Theorem, Applications of Number Theory, Public Key Cryptography

ESE: 50%

The objective of this paper is to provide some basic knowledge about accounting concepts, conventions, and procedure to record the business transactions. This is also to give them an overall idea about how accounting standards are followed in recording and maintaining books of accounts. It helps them in reading and analysing the financial position of the company. 

Meaning and Need, Steps in Journalizing, Problems on Journal Entry.

Meaning, Classification and Advantages. 

Accounting Meaning, Need for accounting, Users of Accounting Information, Meaning of Bookkeeping, Accounting principles, Accounting cycle, Phases of Accounting, Accounting Equation

Meaning, Nature and Principles of Double Entry. 

Meaning, Difference between Journal and Ledger, Steps in posting. Problems on Ledger

Meaning and objectives of preparing Trial Balance.Comprehensive problems on Journal, Ledger and Trial Balance. 

2.  Accounting for Managers, Himalaya Publishing House, R Venkata Raman and Srinivas, 2020 

3. S.N. Maheshwari  & S.K. Gupta “Introduction to Accounting” 2020

     This course teaches students how to develop java applications. Course gives an overview of difference between C++ and Java. Students will be developing and testing java application as a practical course work.  The course introduces the concept of UI design in java using SWING and JAVAFX.

Java Fundamentals

Object oriented programming concepts – Benefits of OOPS-The origins of java -  java’s  lineage C and C++ - how java impacted the internet - java bytecode - a first simple program - the java keywords - identifiers in java - the java classlibraries.

Introducing data types and operators

Why data types are important - java’s primitive types - literals - a closer look at variables -     the scope and lifetime of variables - operators - type conversion in assignments - casting incompatible types - operator precedence-expressions.

 Programcontrolstatements                                                                                                       Input characters from the keyboard - if statement - switch statement  -  for  loop  -  the  enhancedforloop-thewhileloop-thedo-whileloop–break–continue-nestedloops.

Arrays 

Class fundamentals - how objects are created - reference variables and assignment - methods returning a value - using parameters - constructors - parameterized constructors - the new operator revisited - garbage collection - the this keyword - controlling access  to  class  members - method overloading -overloading constructors - understanding static - introducing nested and innerclasses.

[2]   Dr.Rao,Nageswara ,Core Java,An Integrated Approach ,New Edition Kongent Solutions Inc, 2009. 2005.

ESE - 50%

This course concentrates on introduction, principles, design and implementation of DBMS. It introduces about the distributed system and brief about data mining and data warehouse. To provide  strong  foundation  of  database  concepts   and   develop   skills   for   the   design   and implementation  of  a  database  application  with  a  brief  exposure  to  advanced   databaseconcepts.

Data Models – Categories of data models, Schemas, Instances, and Database states. DBMS Architecture and Data Independence – The Three schema architecture, Data independence - DBMS Languages and Interfaces. Classifications of Database Management Systems.

Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use aDBMS.

Using High Level Conceptual Data Models for Database Design, Example Database applications. Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams.

Single Level Ordered Indexes – Primary indexes, Clustering indexes and Secondary indexes. Multi-level indexes, Hashing concepts.

ESE-50%

This course teaches students how to develop java applications. Course gives an overview of difference between C++ and Java. Students will be developing and testing java application as a practical course work.  The course introduces the concept of UI design in java using SWING and JAVAFX.

1.      To implement different entry controlled and exit controlled looping statements

2.      To Implement nesting of switch statement

3.      To Implement single and multi-dimensional arrays

4.      To implement constructor overloading and method overloading

5.      To implement static keyword

6.      To Implement multilevel inheritance

7.      To implement super and this keyword

8.      To implement abstract and final keyword

9.      To implement methods of String class

10.  To Implement exception handling and custom exceptions

11.  To implement package and interface

12.  To implement File Stream classes

13.  To Implement multithreading

14.  To implement mouse and keyboard events

15.  To implement different layout managers

16.  To design a customer registration form using advanced swing components

17.  To implement 2D Shapes using JavaFX

18.  To implement CheckBox and ListView events using JavaFX

19.  To implement JavaFx Effects and Transformation

[2]   Dr.Rao,Nageswara ,Core Java,An Integrated Approach ,New Edition Kongent Solutions Inc, 2009. 2005.

ESE - 50%

The main objective of this lab is to provide a strong foundation in database concepts, understand and implement the use of Structured Query Language (SQL) and Procedural Structured Query Language (PL/SQL) to create and query databases.

1. Introduction TO SQL

a. Introduction

b. Logging on to SQL interface

c. Choosing and Describing Tables

d. Elements of the SQL Query

e. The System Dummy Table

f. Selecting Tables and Columns

g. Duplicate Information DISTINCT

h. Sorting Information

2. Data Definition Language (DDL)

a. Create

b. Drop

c. Alter

d. Rename

3. Integrity Constraints

a. Types of Constraint

b. Referential Integrity

c. Defining Constraints

4. Data Manipulation Language DML

a. Select

b. Insert

c. Update

d. Delete

5. Filtering Data Using Where

a. Where Operators

b. Where with Keywords

c. Where and Logical Operators

6. SQL Functions and Data types

a. Date and Time Functions

b. Numeric Functions

c. String Functions

d. Conversion Functions

7. Group By

a. Group Function Examples

b. Group Function with Having

8. Retrieving Data from Multiple Tables using Joins

a. Natural Join

b. Inner Join

c. Outer Join

9. Sub-Queries

a. Basic Subqueries

b. Multiple Column Subqueries

c. Subqueries with Having

d. Correlated Subqueries

10. Views

a. CREATE VIEW

b. WITH CHECK OPTION

11. Indexes

a. Create Index

b. Unique Option

c. When and What to Index

d. Drop Index

12. Data Control Language (DCL)

a. Grant

b. Revoke

13. Transaction Control Language

a. Commit

b. Rollback

c. Savepoint

d. Set Transaction

14. PL/SQL

a. Variables and type declarations

b. Loop structure

c. Procedures and Functions

d. PL/SQL Blocks

e. Cursor/ Cursor loops

f. Exceptions

CIA - 50%

German is a Generic elective for the students of the BCA Program. The book, Netzwerk A1 that conforms to the Common European Framework of Reference is a method that introduces students to the culture and language of the German-speaking world. Meant for adult beginners, it begins with the basics and quickly plunges learners to interact in everyday situations.

Course Objectives

·                   To develop the four basic skills -listening, speaking, reading, and writing,

              required in the acquisition of a language

·                    To develop an awareness about the German culture

        To be able to interact with German people in everyday situations

 Upon completion of the course the student -

·       Will have a fair acquisition of the basic skills of listening, speaking, reading and writing

·       Will be quite familiar with the German culture

·       Will be able to carry out simple day to day conversations in German

1.     First and Last Names of German Families

2.     Numbers and Alphabets

1.     Greetings- Usage of “du” and “Sie”

2.     Say where you are from and where you live.

3.     Formal and Informal Introduction

1.       www.klett-sprachen.de/netzwerk A1 

          The Miracle of Bern: A young boy from a working class family in post-war Germany struggles with his estranged father returning from war captivity, while a friend of his plays for the German National Soccer Team at the… 

French is taught as a Generic elective for the students of the BCA Program. The book, Alter Ego+ A1 which conforms to the Common European Framework of Reference is a method that introduces students to the culture and language of the French-speaking world. Meant for adult beginners, it begins with the basics and quickly plunges learners to interact in everyday situations.

Course Objectives

·       To develop the four basic skills -listening, speaking, reading, and writing, required in the acquisition of a language

·       To develop an awareness about the French culture

To be able to interact with French people in everyday situations

·       Will have a fair acquisition of the basic skills of listening, speaking, reading and writing

·       Will be quite familiar with the French culture

Will be able to carry out simple day to day conversations in French

1.     First and Last Names of French Families

2.     Few French and International personalities

1.     Greetings- Usage of “tu” and “vous”

2.     Telephone Numbers in France

3.     Some cultural / festive events in Paris- The Francophone

Course description: It is a fundamental course in Graph Theory involving some basic concepts like Classes of Graphs, Isomorphism, Connectivity, spanning trees and few standard graph algorithms.

Course objectives: This course will help the learner to

COBJ1: gain familiarity with fundamental concepts of Graph Theory

COBJ2: understand and apply knowledge to analyze and solve problems using models of Graph Theory

Graphs and Graph Models, Graph Terminology and Special Types of Graphs, Representing Graphs and Graph Isomorphism, Connectivity.

Euler and Hamilton Paths, Shortest-Path Problems, Planar Graphs, Graph Coloring

The main objective of this paper is to bring them knowledge about the basics of finance. It also intends to provide various forms of techniques to make decision about long-term investment. Various forms of financial statement analysis like ratios, fund flow and cash flow statement also included to make them know about the tools of financial performance analysis.

Introduction, Definition, Objectives of Financial Management-Profit Vs Wealth Maximization, Functional areas of Financial Management.Time Value of Money- Compounding and discounting techniques, Financial Markets- Theory. 

Meaning, Importance, Process of Capital Budgeting. Payback Period, Accounting Rate of return, Net Present Value, Profitability Index, Internal Rate of Return, Capital Rationing.

[2] M. N. Arora. Management Accounting, Himalaya Publication, 4 th Edition, 2010 

[2]    R K Sharma , Shashi K Gupta. Practical Problems in Management Accounting, 5 th Edition , 2011

ESE-50%

Course Objectives          

To demonstrate the different ways to analyze and evaluate the performance of an algorithm.

To apply different design techniques of algorithms to solve problems.

A simple example of design using insertion sort, pseudo code for insertion sort and analysis of time complexity. Performance Analysis - Space complexity and Time complexity (posteriori testing, and a priori approach), Asymptotic Notations (O, Ω, Θ).Polynomial Vs. Exponential Algorithms. Average, Best and Worst case complexity.

Introduction to Divide and Conquer Algorithms - Finding the Maximum and Minimum, Quick sort (Derivation of Average case analysis and Worst case analysis), Binary Search (Derivation of Average case analysis), and Strassen's Matrix Multiplication.

This course is an introduction to software development process and design. It includes  the descriptions about stages of software development, various process models and software engineering principles.

Nature of software- Defining software, Software Application Domains, Legacy Software - Software Engineering, The software process, Software Engineering practice – The essence of Practice, General Principles - Software Myths.

A generic process model – Defining a framework activity, identifying a Task Set, Process Patterns - Process Assessment and improvement, Prescriptive Process Models – The waterfall Model, Incremental Model, Evolutionary Process Model, Concurrent Models- A Final Word on Evolutionary Processes.

Requirement Analysis, Data modelling concepts, Class-based modelling, Requirement modelling strategies, Flow oriented modeling.

Requirements Engineering, Establishing the groundwork – Identifying Stakeholders, Recognizing multiple viewpoints, Working toward Collaboration, Asking the first questions-, Eliciting requirements – Collaborative requirement gathering, Quality function Deployment, Usage Scenario Elicitation Work Products - Developing use cases, building the requirements model – Elements of the requirements Model, Analysis pattern - Negotiating requirements, validating requirements.

[2] Rumbaugh, James, Object Oriented Modeling and design, Pearson Education, New Delhi, 2005.

This subject will provide basic understanding of WWW, Web Development, Client side and Server side technologies to develop and deploy Websites on Internet.

Clients, Servers, and Communication. The Internet - Basic Internet Protocols  -The  World Wide Web - HTTP request message - response message - Web Clients - Web  Servers  - Markup Languages: XHTML. An Introduction to HTML –  History  –Versions  -Basic  XHTML Syntax and Semantics - Fundamentals of HTML.

CSS - Introduction to Cascading Style Sheets – Features - Core Syntax - Style Sheets and HTML - Cascading and Inheritance - Text Properties – Positioning.

Introduction to JavaScript – Functions – Objects – Arrays – Built - in Objects - JavaScript Debuggers. Browsers and the DOM - Introduction to the Document Object Model DOM History and Levels - Intrinsic Event Handling - Modifying Element Style  - The Document  Tree -DOM Event Handling.

1.Web Technologies-A Computer Science Perspective, Jeffrey C.Jackson,  Pearson Education, 2008.

2. Internet & World Wide Web - How To Program, H.M.Deitel, P.J. Deitel , et.al , Pearson Education, Fifth Edition, 2012.

2.  Web Technologies Uttam K Roy, Oxford University Press, 2011.

3.  Web Programming: Desktop Management, Aferganatel, PHI, 2004.

4.  Web Technology, Rajkamal, Tata McGraw-Hill, 2001.

ESE:50%

The course introduces the concepts of converting the real time problems into an interactive window based application to attain a solution.

1. Introduction to windows form application design

(Tool box, Property window,Solution Explorer,Server Explorer) Properties associated with each control

2. Introduction to common controls Part I and their properties 

Text boxes

Rich Text Box 

Label

Link label 

Button 

Panel

Event associated with each of the control 

Changing the properties at runtime with C# code

3. Validating controls 

Numbers

Texts

Regular expression

4. Looping structures 

If structure in C# 

Switch case in C# 

While loop in C#

Do .. While loop in C# 

For loop in C#

5. Introduction to common controls Part II and their properties 

List Box

Combo box 

Check box 

Radio button 

Group Box

Events associated with each of the control

Changing the properties at runtime with C# code

6. Introduction to common controls Part III and their properties 

Date time picker 

Month Calendar 

Numeric Up Down

Events associated with each of the controls 

Changing properties at runtime using C# code

7. Introduction to common controls Part IV and their properties 

Progress bar

Tool Tip 

Picture box

Properties associated with each of the controls 

Changing properties at runtime using C# code

8. Introduction to Menus & Toolbars and their properties 

Menu  Strip

Status Strip 

Tool Strip

Events associated with each of the controls 

Changing properties at runtime using C# code

9. Introduction to Dialog control and their properties 

Font Dialog

Open File Dialog 

Save File Dialog

Events associated with each of the controls 

Changing properties at runtime using C# code

10. Introduction to database using SQL Server and their properties 

Creating a table

Introducing Primary Key 

Introducing Data types

Writing Queries in SQLServer (SELECT, UPDATE, DELETE, INSERT)

11.  Windows Form Interaction with database using INSERT, UPDATE Query 

Connecting form with database

Writing INSERT query in windows form to store data in the database

12.  Windows Form Interaction with database using SELECT, DELETE Query 

Connecting form with database

Writing SELECT query in windows form to store data in the database

13. Introduction to the control data grid. Retrieving data from the database to the grid control

14. Report generation

Generating reports using tools  available

15. Converting the application  to an exe file

The purpose of this course is to prov­­ide comprehensive understanding to develop web applications with database systems. Started with web programming using HTML, CSS, PHP and connect with database concepts DDL, DML andPL/SQL.

Part 1: Web Technology HTML

1)     Develop static pages usingHTML

(Using Heading elements, Text Elements, Logical Styles, Physical Styles, Ordered, Unordered and Definition list, Hyper Links, Image Link, Link to page containing Images and Videos, FileLink)

2)     HTML Page usingFrames.

(Navigation, Floating, Inline Frames , Frames to add Images and Videos)

CSS/ XSL /DTD

3)     Add a Cascading Style sheet for designing the webpage.

4)     Create any catalog and display it using CSS orXSL

5)     Document Type Definition (DTD) to validateXML

JavaScript / PHP

6)     Design a dynamic web page with validation usingJavaScript

7)     PHP program to perform File operations / RegularExpressions

8)       PHP program to sort the records which are stored in thedatabase

Data Connectivity and Web Services

9)     Install DBMS/ Configure DBConnectivity

10)JSF and Web ServicesConfigurations

Part 2: Database Management System Project

ESE:50%

This course covers the programming paradigms associated with python. It explores the object-oriented programming, Graphical programming aspects of python with help of

built-in modules. The objective of this course is to provide comprehensive knowledge of python programming paradigms

Underlying mechanism of Module Execution- Sequences, Mapping and Sets- Dictionaries- Functions - Lists and Mutability- Problem Solving Using Lists and Functions

Classes: Classes and Instances-Inheritance—Polymorphism- Abstract classes-Exceptional Handling- Regular Expressions using “re” module.

2. T.R.Padmanabhan, Programming with Python,Springer Publications,2016

ESE 50%

The goal of this course is to introduce the basics computer networks. Students will learn their fundamental layered structure, understand common offered layered services, examine protocols and algorithms used to operate the network.

Objectives of the course are

• To study about network components.

• To study about topologies and network models.

• To study about various network protocols, algorithms.

Data communications : components – Network criteria – physical structures – network models – categories of networks –interconnection of networks – inter network Protocols and standards : protocols-standards-standards organizations- internet standards Network models: Layered tasks – OSI model – layers in the OSI model – TCP/IP protocol suite.

Digital Transmission: Digital to digital conversion: Line coding – line coding schemes – block coding - analog to digital conversion – PCM - transmission modes: serial transmission – parallel transmission

Analog Transmission: Digital to analog conversion: FSK-ASK-PSK Analog to Analog conversion: Amplitude modulation – Frequency modulation – phase modulation Multiplexing: Frequency division multiplexing – Time division multiplexing

Transmission Media Guided media: Twisted pair cable – coaxial cable – fiber optic cable Unguided media: radio waves - micro waves – infrared.