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

Having gained familiarity with technical and subject specific vocabulary, students will be introduced to the types of reading. The basic receptive skill will help students help students prioritise and eliminate content.

§  Reading strategies – acquaint the learners with the functions and benefits of reading strategy in the academic and professional set-up

§  Reading: skimming, scanning – introduce learners to the types of reading. The integral aspects of each method will be familiarized to the students. They can be given practice sessions through subject material provided

§  Intensive and extensive reading – benefits and features of the two types of reading can be elaborated. To emphasise on the learner the difference, practice sessions with subject material can be carried out

§  Summarising – consolidation of key ideas can be carried out in the spoken and written format. Technical literature can be provided for the purpose

The ancillaries of speaking skill is in focus here. Prior to delving into the productive skill, the nitty gritty that enhance its effectiveness is made familiar to the learner. Classroom activities and vicarious learning through case studies and video clippings can be screened.

§  Competence in non-verbal communication- create an awareness of the role of non-verbal communication in a professional set-up

§  Functions of non-verbal communication – the various utilities of nonverbal communication can be elaborated to students with case studies

§  Benefits of non-verbal communication – elucidate the advantages of non-verbal communication with reference to cultural distinctions

§  Proxemics, Chronemics, Kinesics, Haptics, Gestures, Paralanguage - vicarious learning of these aspects of non-verbal communication can be carried out through video clippings of suitable material and print media

The productive skills are finessed through identification and refining of the elements mentioned in this unit. They contribute to holistic presentation. Task based activities must be used to practise. Business Communication texts and worksheets will provide ample support.

Nuances of Communication – communication in the work place requires knowing the dos and don’ts of professional communication. An introduction to listening, speaking, reading and writing with reference to professional communication can be provided.

§  Opening techniques

§   Speech markers

§   Fillers

§  Turn taking

§  Backchannelling

§  Dealing with interruptions

every element mentioned can be elaborated. Ample examples can be provided through audio visual media, it can be provided to them through demonstrations and verbal reinforcement language checklists can be provided to aid students understand implementation of the elements. A follow up through mock sessions must be carried out in groups

Having dealt with speaking skill in the previous unit, the other productive skill; writing is taken into consideration here. The various forms of sriting in an official context will be taught in form and content.

§  Report writing – a corporate requirement is the ability to report on meetings and conferences. The format and requirements of a report writing can be taught to the students through samples and later they can be made to draft reports of their own and peer evaluated

§  Note taking – corporate atmosphere calls for not taking at every step. Students need to be taught the framework of note taking. They can be given samples as reference. Later they can be made to listen to technical audio clips and provide the note taking carried out at an individual level.

§  Minutes – corporate life calls for being in attendance of numerous meetings. Taking down the minutes is a skill that is assumed to be possessed by one. The essentials of maintaining the minutes must be made conversant through illustrations. This can be emphasised by classroom activities of the same

 Lastly students will be introduced to typical work scenarios through hands-on sessions.

§  Small talk – the purpose and role of small talk must be taught to the students. They can be screened video clippings of the same. Mock sessions can be performed in the class. The key phrases and language used can be imparted through provision of language worksheets and skills checklists

§  Meeting- types of meetings, hierarchy of most often featuring members, etiquette to be held at meeting and the duties to be performed can be taught implicitly. Chairing, setting the agenda, controlling the smooth functioning, participating, deliberating and diplomacy must be made clear. The key phrases and language used can be taught through language worksheets and skills checklists

§  Group discussion – group discussions are carried out at every level. Students must be familiarized with the basics of a group discussions. Agreeing, disagreeing, and being diplomatic are essentials to be imparted. The soft skills and language essentials most commonly noted can be made comprehensible to the students. Vicarious learning and language charts can be used as learning tools.

[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 

Random Experiment- Sample space and events. Probability. rules. Conditional probability and Bayes theorm.

Definition, types of random variables, probability functions, expectations and variance

Laspeyres’, Paasches’, Fishers price and quantity index numbers. Time reversal and factor reversal tests. 

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.

Basic Adders: Half adder, Full adder, 4-bit Parallel adders, Subtractor: Half subtractor, Full subtractor Implementation using logic gates, Decoders: 4-bit decoder, BCD to decimal decoder, Encoder: Decimal to BCD encoder, Multiplexer: 4 to 1 multiplexer, Demultiplexer: 1 to 4 demultiplexer.

Latches: SR latch, Clocked flip-flops: SR flip-flop, D flip-flop, JK flip-flop, Positive edge-triggered flip flops, Timing diagrams, Master-slave JK flip-flop.

Modes of operation of registers: SISO, SIPO, PISO, and PIPO, Asynchronous counters: Four-bit ripple counter, Decade counter, Synchronous counters: Four bit synchronous counter, Decade counter

Self-Learning

Introduction to RAM, SRAM, DRAM, ROM, PROM, EPROM, EEPROM

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.

Functions: Definition, Accessing and prototyping, types of functions, passing arguments to functions, recursion, passing arrays to functions. Pointers: Definition, notation, applications, call by reference.

Structures: Definition, Processing, user defined data type typedef - Unions – definition, declaration and accessing union elements. Enumerated Data type.Files: File opening in different modes, closing, reading and writing. fopen, fclose, fprintf, fscanf, getw, putw.

Storage Structures: extern, register, static, auto. Bitwise Operations: AND, OR, exclusive OR, complement, right shift and left shift operators. Preprocessor: Types of C preprocessor directives. Macros- comparison with functions. File Inclusion. Command line Arguments.

[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.

An extension of rudimentary research is present in this chapter. Students will be encouraged to analyse texts, interpret and rewrite them.

§  Rhetoric analysis; a comparative analysis of two texts – in context to the literature prescribed, students must be enabled to make a detailed study of the texts and chart out differences and similarities.

§  Critical analysis – students can be taught to scrutinise the text based on the context and produce a systematic response

§  Paraphrasing – in a professional atmosphere data needs to be interpreted and paraphrased. Tasks with data analysis can be used to help students comprehend the implementation of paraphrasing in the written

Productive skill; writing is nurtured in this chapter. A few elements of the same was handled in the first semester. Here students will further finesse their writing skills

§  Official letter – the types and format of official letter can be imparted through examples. Students can be then asked to draft letters of their own. Etiquettes of letter writing, register, style and specific language phrases must be taught. H examples can be used to emphasise.

§  Internet correspondence – the soft skills for corresponding through email, carbon copying, blind carbon copying, salutations, register, style, format and diction must be made familiar to the students,

§  Resume writing – the organization of a resume along with the covering letter can be imparted to the learners through providing several samples. They can then be made to draft a resume with covering letter of their own.

The previous semester dealt with a few productive oral skills. Furthering their productive expertise, speaking skills are taken into consideration. Students will be encouraged to demonstrate their skills under guidance of the teacher.

Interview – types of interviews can be elaborated to the learners. The essential language and skills required must be emphasised verbally and through case studies. Students can be encouraged to demonstrate the acquired knowledge through simulated sessions

§  Presentations – the critical features and language checklists must be emphasised. Introducing the topic, linking, sequencing and dealing with questions must be mad familiar. The soft skills and paralinguistic aspects can be taught through examples. Group demonstrations must be mandatory

§  Conference – the soft skills and language finesse required must be made clear to the students. Checklists can be provided as learning aids. Chairing sessions, targeting issues, key language, and steering the meeting is required to be acquainted. Audio visual examples can be screened and re-emphasis through practice sessions can be carried out.

[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.

CPU Scheduling concepts; Scheduling criteria; Scheduling algorithms; Overview of thread scheduling; Multi-processor scheduling

Overview; Swapping; Memory allocation; Segmentation; Paging, Structure of the page table

File system structure, Directory structure

Overview; Demand paging; Copy on Write; Page replacement; Allocation of  Frames; Thrashing

[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

Pointers, Using Dynamically Allocated Storage, Singly Linked Lists, Dynamically Linked Stacks and Queues, Polynomials, Representing Polynomials as Singly Linked Lists, Adding Polynomials, Erasing Polynomials, Polynomials as Circularly Linked Lists, Doubly Linked Lists.

Introduction, Terminology, Representation of Trees, Binary Trees, Abstract Data Type, Properties of BinaryTrees,BinaryTreeRepresentations,BinaryTreeTraversalsBinarySearchTrees:Introduction, SearchingaBinarySearchTree, InsertinganElement,DeletinganElement,HeightofBinarySearch Tree

Introduction, Bubble Sort, Insertion Sort, Selection Sort, Quick Sort, Merge Sort. Graphs— Introduction-Definition-representation-Depth first search-Breadth first search

[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

Structure of Algebras, Semigroups, Groups, Subgroups, Generators of a group, Cosets and Lagranges Theorem, Isomorphism, Automorphisms, Permutation groups, Odd and Even permutations

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. 

Meaning, objectives and classifications of cash book. Difference between cash dicount and trade discount. Problems on Three column cash book

Meaning, Need for preparation of Final Account, Components of Final accounts. Problems with adjustments

Meaning, Need for providing Depreciation. Problems on different methods of Depreciation (Straight Line Method and Written Down Value Method)

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.

Inheritance, Strings And Exception Handling Inheritance

Inheritance basic - member access and inheritance - constructors  and  inheritance  -  using super to call superclass constructors - using super to access superclass members - creating a multilevel hierarchy - superclass references and subclass objects - method overriding - using abstract classes -using final - the objectclass.

Strings

Constructing strings - operating on strings - arrays of strings - strings are immutable - using a string to control a switch statement - different string handling functions.

 Exceptionhandling

The exception hierarchy - exception handling fundamentals - the consequences  of  an  uncaught exception - using multiple catch statements - catching subclass exceptions -  try blocks can be nested - throwing an exception - using finally -using throws - java’s built in exceptions - creating exceptionsubclasses.

Multithreading fundamentals - the thread class and runnable interface - creating a thread - creating multiple threads - determining when a thread ends  -thread  priorities  -  synchronization - suspending, resuming, and stoppingthreads.

Introducing swing - the origins and design philosophy of swing - components and containers

- layout managers - swing event handling - use of JButton -work with JTextField - create a JCheckBox - work with JList.

 SelfStudy

Advanced SWING components

 INTRODUCING  JAVAFX                                                                                                          

Javafx basic concepts - the javafx packages - the stage and scene classes -nodes and scene graphs - layouts - the application class and the life-cycle methods - launching a javafx application - a javafx application skeleton -compiling and running a javafx program - the application thread - a simple javafx control- label - using buttons and events - three more  javafx controls-CheckBox – ListView – TextField-introducing effects and transforms.

[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.

Functional dependencies and Normalization for Relational Databases - Normalization concepts, first, second, third normal forms, Boyce-Codd normal form.

Relation, Integrity constraints - domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations.

Transaction and System concepts – Desirable properties of Transactions – Schedules and Recoverability. Lock-Based Protocols – Locks, Granting of Locks, and Two phase locking protocol and implementation of locking.

SQL data definition and data types, specifying constraints in SQL, schema change statements, Basic queries, More Complex SQL queries, INSERT, DELETE and UPDATE statements in SQL, Views – Concept of a view in SQL.

Recovery Concepts: Recovery Outline and Categorization of Recovery Algorithms, Caching Buffering of Disk Blocks, Write-Ahead Logging, Steal/No-Steal, and Force/No-Force, Checkpoints in the System log and Fuzzy Check pointing, Transaction Rollback.

Introduction to Database security issues, Discretionary Access Control Based on Granting/Revoking of Privileges and Multi-level security.

Distributed database concepts, Data fragmentation, Replication, and Allocation Techniques for Distributed database design, Types of Distributed database systems.

Brief introduction to Data warehousing and Data mining.

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.   The German and sports- Speak about Hobbies

2.    Weekday activities, Months and Years and  Seasons

3.  The – definite article and yes or no questions 

1.   Talk about Places and Buildings

2   Definite Article and indefinite Article

3  Events in Hamburg

1.     Talk about food    

2.     Learn to make sentences with Objects

3.     Talk about shopping and conversation relating to food

1.     Understand time

2.     Talk about activities relating to time and days

3.     Learn Possessive article.

1.     Planning a Birthday party with friends

2.     Writing an Invitation and talk about Birthday parties

3.     Order and pay in Restaurants

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

1.     Pontoise and Ile de France- The City

2.     Annecy- Youth hostel and accommodation

3.     The wording of address in France- postal codes and departments

1.     The French and sports- The Reality shows

2.     New ways of meeting- The Differences men/ women

3.     Surnames of married women/ children- Announcements and family functions

1.     Rhythm of Life and Rhythm of the city- Internet and media in daily life

2.     The Outings

3.     Family life and Household chores- Routine and change in rhythm

1.     Festivals and rituals in France

2.     Telephone conversations- Social network- Guide and Forum of Travel

3.     People magazines and the life of celebrities.

1.     Montreal- the seasons, the weather

2.     Overseas France and the Reunion

3.     Brussels, European capital

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