Welcome to Smt. Tanuben & Dr. Manubhai Trivedi College of Information Science, Wadia Women Campus, Athwalines, Surat, 395001
Click on Subject to View It's Syllabus

Unit 1. Introduction and Presentation of statistical data

Types of variables

Univariate, bivariate and multivariate data

Univariate and bivariate frequency distributions

Unit 2. Measure of central tendency-mean, median and mode

Unit 3. Measures of dispersion (absolute as well as relative)

Mean deviation

Standard deviation

Coefficient of mean deviation and coefficient of variation

Unit 4. Correlation

Introduction

Types of correlation and scatter diagrams

Rank correlation coefficient

Unit 5. Regression

Concept of dependent and independent variables

Introduction to liner regression

Line of regression (with one independent variable)

Methods should be explained conceptually and corresponding examples should be given. No proof should be given to any of the methods.

Download Syllabus

Unit 1. Introduction

1.1 Concepts of Software.

1.2 Software characteristics.

1.3 Software Engineering: definition.

1.4 Types of Software

Unit 2. Software Process Model

2.1 Waterfall Model

2.2 Prototype Model

2.3 Incremental Model

2.4 Spiral Model

Unit 3. Requirement analysis

3.1 Introduction.

3.2 Requirement gathering techniques & Fact Finding, Recording Outcome.

3.3 Effort distribution.

3.4 Importance of Requirement Specifications.

3.5 SRS Characteristics.

3.6 Software Requirement Specification Document.

Unit 4. System Design

4.1 UML (Class Diagram, Use Case)

4.2 DFD, Data Dictionary and Process Specification.

4.3 Design model.

4.4 Principal and Concepts.

4.5 Functional Independence.

4.6 Effectiveness of Modular Design.

Unit 5. Software Testing

5.1 Testing Fundamentals and principals.

5.2 Types of Testing.

5.2.1 Black Box & White Box

5.2.2 Unit Testing

5.2.3 Integration Testing

5.2.4 System Testing

5.3 Introduction to change Over

5.3.1 Types of change over

Download Syllabus

Unit-1: Introduction to SQLite:

1.1 SQLite advantages, features and Fundamentals:

1.1.1 SQLite datatype : ( Dynamic type, SQLite manifest typing & type affinity) (NULL, INTEGER, REAL, TEXT, BLOB)

1.1.2 Transaction, Rollback, Commit

1.2 Data Filtering and Triggers

1.2.1 Filtering: Distinct, where, between, in, like, Union, intersect, Except, Limit, IS NULL

1.2.2 Having, Group by, Order by, Conditional Logic (CASE)

1.3 SQLite joins: Inner, left, cross, self, Full outer joins. 

1.4 SQLite Trigger:

1.4.1 Concepts of Trigger, Before and After trigger (on Insert , Update, Delete)

1.4.2 Create, Drop trigger, Disable and Enable trigger

Unit-2: Database backup and CSV handling:

2.1 SQLite dump : 2.1.1 Dump specific table into file, Dump only table structure 2.1.2 Dump entire database into file 2.1.3 Dump data of one or more tables into a file

2.2 CSV files handling:

2.2.1 Import a CSV file into a table

2.2.2 Export a CSV file from table

Unit-3: Python interaction with SQLite:

3.1 Module: Concepts of module and Using modules in python.

3.1.1 Setting PYTHONPATH, Concepts of Namespace and Scope

3.1.2 Concepts of Packages in python

3.2 Importing sqlite3 module

3.2.1 connect () and execute() methods.

3.2.2 Single row and multi-row fetch ( fetchone(), fetchall())

3.2.3 Select, Insert, update, delete using execute () method.

3.2.4 commit () method.

Unit-4: Python Interaction with text and CSV:

4.1 File handling ( text and CSV files) using CSV module :

4.1.1 CSV module , File modes: Read , write, append

4.2 Important Classes and Functions of CSV modules:

4.2.1 Open(), reader(), writer(), writerows(), DictReader(), DictWriter()

4.3 Dataframe Handling using Panda and Numpy:

4.3.1 csv and excel file extract and write using Dataframe

4.3.2 Extracting specific attributes and rows from dataframe.

4.3.3 Central Tendency measures :

4.3.3.1 mean, median, mode, variance, Standard Deviation

4.3.4 Dataframe functions: head, tail, loc, iloc, value, to_numpy(), describe()

Unit-5: Data Visualization using dataframe:

5.1 importing matplotlib.pyplot and plotting: ( only two dimensional Plots)

5.1.1 range() , subplot() , legend(), columns(), len() functions.

5.2 scatter plot: concept of Scatter plot, set title, xlabel and ylabel)

5.3 Line chart : concept of line plot: plot(), set_title(), legend()

5.4 histogram chart : Concepts of histogram hist(),set title, xlabel and ylabel

5.5 Bar Chart : Concepts of Bar chart, bar(),set title, xlabel and ylabel.

Download Syllabus

Unit 1. Concepts of OOPS: ( Max. 20% of Weightage)

1.1 Difference between procedural programming and OOPS

1.2 Various library(header) files require for C++

1.3 Data types in C++

1.4 Concepts of String:

1.4.1 character Array

1.4.2 pointer to character array

1.4.3 Use of String.h and its important functions: (strcmp, strcat, strcpy, strlen, strrev )

1.5 Concepts of Class and Objects.

Unit 2. Data Encapsulation and inheritance: (Max. 20% Weightage)

2.1 Access controls concepts (Public, Private, Protected) and difference among them.

2.2 Declaring simple class, member variables and member functions.

2.3 Concepts and use of enum.

2.4 Concepts of Data hiding, abstraction and encapsulation with examples

2.5 Concepts of Inheritance and Types of Inheritance

2.6 Constructors and Destructors

Unit 3. Polymorphism (Max. 20% Weightage)

3.1 Concepts of Polymorphism

3.2 Compile time and Run time Polymorphism

3.3 Overloading and Overriding: Concepts, difference and application

3.4 Concepts of friend function

3.5 Concepts of virtual function and pure virtual function

Unit 4. Data Structure (Max. 20% Weightage)

4.1 Introduction of Data Structure and application areas.

4.2 Recursion concepts

4.3 Difference among Linear and Non-Linear Data Structure

4.4 Stack

- Concepts of Stack(LIFO)

- Pop, Push and Display(Peep)

- Application areas of Stack

( Infix to postfix, Infix to prefix )

Unit 5. Queue (Max. 20% Weightage)

5.1 Concepts of Queue(FIFO)

5.1.1 Concepts of Queues and its basic operations

5.2 Implementation of Queue:

5.2.1 Simple Queue: insert, delete and display

5.2.2 Double ended Queue: insert, delete and display

5.2.3 Circular queue: Insert, delete and display.

Download Syllabus

Unit 1. Working with HTML5 and CSS:

1.1 concepts of CSS:

1.1.1 Adding CSS (Inline,Internal,External)

1.1.2 HTML Links and attribute.(_self, _blank, _parent, _top)

1.1.3 Absolute URL and Relative URL in <href>

1.1.4 <img> tag and its attributes (src, alt, style,width,height)

1.2 HTML forms :

1.2.1 form Elements and their attributes :

1.2.1.1 form (action, method, novalidate, autocomplete,target)

1.2.1.2 label, input (text, radio button, Checkboxes, submit/reset button)

1.2.1.3 select(id, name,<option>),

1.2.1.4 textarea (name, rows, cols),

1.2.1.5 button(type, onclick)

1.2.1.6 datalist

1.2.2 Media : Video, Audio

Unit 2. Design Web Sites Using Bootstrap4

2.1 Bootstrap Introduction

2.2 Grid Structure

2.3 Table, Colours, Alerts, Form Controls

2.4 Buttons and ButtonGroups

2.5 Images, Media Objects

2.6 Pagination

2.7 Bootstrap Grids

2.8 Bootstrap Themes

Unit 3. Overview of Java Script

3.1 Overview of Client & Server-SideScripting

3.2 Structure of Java Script

3.3 Data types and Variables

3.4 Operators (Arithmetic, Assignment, Comparison, Logical and Conditional Operator)

3.5 Control Structure

3.5.1 If…Else, switch..case

3.5.2 While, Do…While, For Loop

3.5.3 break, continue

3.6 Java Script String and Events

3.6.1 Javascript Strings types

3.6.2 String functions: concat(), split(), indexOf(), lastIndexOf(),substring(), trim(), slice(), replace(), charAt()

3.6.3 Javascript Events :

3.6.3.1 Mouse Events : (click, mouseover, mouseremove, mouseout, mouseup)

3.6.3.2 keyboard Events : ( keyup,keydown)

3.6.3.3 Form Event : (focus, submit, blur, change)

Unit-4: JavaScript Objects :

4.1 Creating object : (By object literal, By creating instance of Object, By using an object constructor)

4.2 Date object : 4.2.1 Date constructor: Date(), Date(milliseconds), Date(dateString), Date(year, month, day, hours, minutes, seconds, milliseconds) 4.2.2 Date Methods: getDate(), getDay(),getMonth(), getHours(), setDate, setMonth(),setDay(), toString()

4.3 Document Object Model (DOM):

4.3.1 DOM concepts

4.3.2 DOM properties

4.3.3 DOM methods : write(), writeln(),getElementById(),getElementsByName()

Unit-5: JavaScript Functions:

5.1 JavaScript Functions:

5.1.1 Defining function (with and without parameters)

5.1.2 calling function

5.1.3 return statement

5.1.4 Page redirection

5.2 Dialog boxes : Alert, confirm, prompt

5.3 Form validation :

5.3.1 Basic validation (All form details are filled)

5.3.2 Data format validation (email, number, string, mobile number, name)

[All Units carry Equal Weightage]

Download Syllabus

Unit-1: Concepts of Mobile computing.

1.1 Fundamentals of Mobile computing:

1.1.1 Concepts of fixed and wireless network

1.1.2 Introduction of Multiplexing, Modulation

1.1.3 Fundamentals of spectrum, Bluetooth technology

1.1.4 Concepts of Wireless Application Protocol(WAP)

1.1.5 Concepts of Mobile Agents.

1.2 Introduction of Android

1.2.1 History, concepts and Features of Android

1.2.2 Concepts of API framework

1.3 Intro. of Android Architecture ( Software Stack)

1.3.1 kernel Native Libraries

1.3.2 Concepts of Native Libraries and Android Runtime(Dalvik VM)

1.3.3 Application Framework

1.3.4 Application

Unit-2: Setting up Android Environment:

2.1 Android Emulator

2.1.1 Setting up JDK and Android Studio

2.1.2 Android SDK manager

2.2 Creating Android Virtual Device (AVD)

2.3 Creating first App:

2.3.1 Activity

2.3.2 Layout

Unit-3: XML (Extensible Markup Language)

3.1 Characteristic and Use of XML

3.2 XML syntax (Declaration, Tags, elements)

3.3 root element, case sensitivity

3.4 XML document:

3.4.1 Document Prolog Section

3.4.2 Document element section

3.5 XML declaration and rules of declaration.

Unit-4:Creating basic App

4.1 Basic App using Android studio

4.1.1 Create new android project

4.1.2 Write message and run

4.1.3 Understanding different components.

4.2 Dalvik Virtual Machine (DVM)

4.3 Understanding AndroidManifest.xml

Unit-5: Android Widgets(UI):

5.1 Hiding Title bar

5.2 screen Orientation ( Portrait, Landscape)

5.3 Form Widget Palette

5.3.1 Placing text fields and Button

5.3.2 Button onClick event

5.4 Displaying Notification:

5.4.1 Toast Class

5.4.2 Displaying message on Toast

5.5 ToggleButton:

5.5.1 ToggleButton Attributes:(textOff, textOn)

5.5.2 Event methods : getTextOff(), getTextOn(), setChecked()

5.6 CheckBox:

5.6.1 Event methods: isChecked(), setChecked()

Download Syllabus

1. Codes and database interaction using Python and SQLite based on Paper-303

Version recommended : SQLite : ver. 2.8 or above, Python: 3.6 or above

303: - Database handling based on SQLite ( Unit-1 and Unit-2 ).

- Python interaction with SQLite, csv, text files.

Data Visualisation using dataframe obtained from multi-column cleaned labelled dataset (SQLite table, csv or txt file).

2. Practical implementation of OOPs concepts based on Course-Paper-304 (Unit-1,

2 and 3).

3. Practical implementation of Data Structure (Simple Stack operations (Push, Pop, Display) and Queue (Simple queue and circular queue)).

4. Practical implementation based on Course-Paper-305-01 or 305-02.

(No specific Editor / IDE are recommended).

Download Syllabus