WEB TECHNOLOGIES - MINOR (by CSE) - III/IV - 2022-23 - PVP20 - PVPSIT

• syllabus
• Micro Syllabus
• Academic Calendar
• Attendance
• Class Schedule

• Day	Time	Room No.
  Mon	4:00 - 5:00	448
  Tue	4:00 - 5:00	448
  Wed	4:00 - 5:00	247
  Thu	4:00 - 5:00	448

  Unit - I

• Basics of HTML
• Html_Images_Lists_Links_Tables
• Html Form Tags
• Chart of HTML Basic Tags
• Program on HTML FORM TAGS
• FRAMES IN HTML
• CSS NOTES 
• Programs ( click here)

Unit - II

JavaScript 

• Programs ( click here)

• JavaScript Notes (ppt) 
• Functions in JavaScript(ppt)
• Events in JavaScript (ppt)
• Event Handlers in Java Script (word)
• Objects
  

XML

• Programs ( click here)

• XML Syntax
• XML Declaration
• XML pdf (external - good one)

Video on DTD - 

• XML Schema and Parsers are out of the syllabus

Unit - III (JDBC)

• JDBC architecture
• Driver Picture
• JDBC STEPS ( ppt - external link - https://www.albany.edu/~goel/classes/spring2006/itm602/notes/jdbc.ppt)
• Courtesy Sanjay Goel
• Programs
• Statement Example
• PreparedStatement Example
• CallableStatement Example

ASSIGNMENT - I 

Unit - IV (Servlet)

• Introduction to Servlet, Life Cycle of a Servlet, Executing Sample Servlet in a Server
• Servlet Request and Servlet Response 
• Deployment Descriptor file - web.xml
• ServletContext and ServletConfig
• MVC architecture

ASSIGNMENT - II

Mobile Application Development (IV - I CSE PVPSIT)

MAD Theory (19CS3701)

• Academic Calendar
• Syllabus

• Micro Syllabus

• Lesson Plan

Unit - I

• Android Stack / Architecture of Android
• Android vs Symbian vs windows
• Android Versions
• Dalvik Virtual Machine
• Dalvik Virtual Machine, Emulator, Android App Components

Unit - II

• Android UI Components - external link
• Activity
• Android app resources
• Android Manifest File

Unit - III ( HOME ASSIGNMENT)

• Android Layout
• Dialogs
• Fragments
• Fragment Life Cycle

Unit - IV (Question Bank for Assignment - II)

• Intents
• Shared Preferences
• JSON in Android
• Difference between JSON and XML (external link)

Unit - V 

• Android Databases

FINAL INTERNAL MARKS

MAD LAB(19CS3751)

• LAB Syllabus
• Lesson Plan
• ppt - Sample Hello World Android Application 
• Menus in Android- Theory
• Steps to create menus in Android Studio
• Steps to follow
• Experiment - 1
• Experiment - 2
• Experiment - 3
• Experiment - 4
• Experiment - 5
• Experiment - 6
• Experiment - 7
• Experiment - 8
• Experiment - 9
• Marks Distribution for Internal & External Lab Exams
• Dates for Experiments

Data Mining using Python LAB_IV_2021-22_R20_IT_LBRCE

 Syllabus

Lesson Plan - A Section

Lesson Plan - B Section

Experiment - 1 

1. Download Dataset from Kaggle
2. Loading the Dataset
3. Dealing with missing data

Experiment - 2 

• Dealing with Categorical Data, Feature Scaling, Splitting dataset into Training and Testing Sets

Experiment - 3

• Similarity and Dissimilarity Measures using python 
• Pearson’s Correlation, Cosine Similarity, Jaccard Similarity, Euclidean Distance, Manhattan Distance

Experiment - 4 - Build a model using a linear regression algorithm on any dataset.

 

Experiment - 5 - Decision Tree

Experiment - 6 - Naive Bayes Classifier

Experiment - 7 - Apriori Algorithm

Experiment - 8,9,10 - Clustering - K - means, Hierarchical, DBSCAN

D2D A-Section   B-Section

DWDM_Theory_IV_2021-22_R20_IT_LBRCE

• Academic Calendar

• Syllabus
• Time Tables
• IV - A 
• IV - B
• Lesson Plan
• Lecture Notes
• Unit - I ppt (click here to view)
• Unit - II
• Datamining Introduction, Motivating Challenges
• Datamining Origin & Tasks, Types of Data
• Data Quality
• Data Preprocessing
• Similarity and Dissimilarity measures (by Dr.Bhagath, CSE, LBRCE)
• Measures of Similarity and Dissimilarity
• Unit - III
• Classification - Decision Tree
• Model Overfitting
• Bayes Theorem, Naive Bayes Classifier

• Descriptive Questions (Cycle - I)
• Assignment Questions (Cycle - I)
• Assignment Marks
• Mid Objective Question Paper
• Key for Mid Objective Question Paper

• Unit - IV - Association Analysis: 
• Basic Concepts and Algorithms: Problem Definition, Frequent Item Set Generation, Apriori Principle, Apriori Algorithm
• Rule Generation, Compact Representation of Frequent Itemsets, 
• FPGrowthAlgorithm
• Unit - V - Clustering:
• ppt
• DBSCAN solved problem
• DBSCAN ASSIGNMENT LINK 
•  K-Means Solved Problem-1
• K-means Solved Problem - 2
• K -means Solved Problem - 3
• Agglomerative Hierarchical Clustering - solved problem
  
• Cycle - II
• Descriptive Questions
• Objective Questions
• Assignment Questions
• ICT Tools used
• Mid-II Question Papers
• DESCRIPTIVE - final answers - Scheme
• solution for 2(a) - Apriori
• solution for 3(a) - K means
• solution for 3(d) - Dendrogram - Hierarchical - Single link - Euclidean
• OBJECTIVE - Answers
• Mid Marks
  
• A Section
• B Section
  
• Consolidated Internal Marks
• A Section
• B Section
• External Question Paper

Python Material

1. Cheat Sheet for Regular Expression ( Courtesy: www.dataquest.io )
2. python ppt for keywords, Data Types, Literals , print() & input(), Operators
3. Order of Programs in Neopat
1. Branching and Looping - Practice Test
4. Lists in python - external link
5. Dictionaries in python - external link

Introduction to Database 2021-22 ECE VII LBRCE

• Academic Calendar

• Roll List

• Time Table

  Day	Time	Class room
  Thursday	3:10-4:10	ECE IV year B Section
  Friday	3:10-4:10	ECE III year C Section
  Saturday	3:10-4:10	ECE III year B Section

• Syllabus

• Course Hand out / Lesson Plan

• Descriptive Questions ( Unit Wise)

• External Question Paper

• Objective Questions ( Unit Wise)

• Unit - I ( click for notes)

• Unit - II ( click for notes)

• Mid-I Question papers 

• Descriptive

• Objective

• Mid-I Marks

                             DESCRIPTIVE

                             OBJECTIVE

• Unit - III(ppt)( click for notes)

  • Notes for Relational Algebra and SQL (pdf)

    Video on Set Operations like Union, Join, Intersect and Minus - youtube

    Video on Cursors in SQL - youtube 
    

• Unit - IV

                       Functional Dependency (ppt)
                      Video Lecture on Functional Dependency(video)

                        Notes for Normalization(ppt)
                        Notes for Normalization(pdf)
                        Videos

                            1NF & 2NF

                                      3NF & BCNF 

 Unit - V 

                    Transaction System

                    Serializability of Schedules

                   Log based Recovery

                   Testing of Serializability

                   Check Point

                   ARIES Algorithm

                   Deadlock Handling

Mid-II Question Papers

                    DESCRIPTIVE

MID-II MARKS

                    DESCRIPTIVE

                    OBJECTIVE

CONSOLIDATED MID MARKS 

                     A SECTION

                     B SECTION

                     C SECTION

Introduction to Database

Syllabus

Course Hand out (or) Lesson Plan

MID - I MARKS - THEORY   

MID - II MARKS - THEORY - QUIZ - ASSIGNMENT MARKS

Descriptive QUESTIONS

Academic Calendar ( Revised & New )

External link for Textbook

 Unit - I

1. Database System vs File System - Video
2. video2 - Unit -1 - outline
3. ppt for notes - click here

Objective Questions - Unit I

Unit - II

1. ppt for notes - click here

        Objective Questions - Unit II

Mid - I Question Paper

Mid - I Quiz Question Paper

Assignment - Answer all questions from Mid I Descriptive Question Paper

Unit - III

1. Relational Data Model Concepts
2. Integrity Constraints, Relational Algebra, SQL- Tables, Views, Index, Query, Sub Query, Aggregate Functions, DML Operations, Set Operations and Cursors. 

Unit - IV

1. Functional Dependencies
2. Normalization - 1NF,2NF,3NF,BCNF, MVD & 4NF, Lossless Join decomposition, JD & 5NF, ID-Inclusion dependency.

Unit - V

1. Transaction System - Desirable properties of transaction
2. Testing of Serializability
3. Serializability of schedules
4. Conflict & View Serializable Schedule
5. recoverability
6. Log based recovery - external link
7. Check Points
8. ARIES algorithm - external link
9. Deadlock handling - external link

EXTERNAL QUESTION PAPER