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

Android Programming R17 IT LBRCE

 Android Programming Syllabus

Course Handout

Academic Calendar

Descriptive Questions

MID - I Question Paper  - Theory - Quiz

MID -II Question Paper - Theory - Quiz

Mid I -MARKS  

Mid II Marks

Quiz Marks

Previous Question Paper Nov 2017

Previous Question Paper Nov 2018

Unit - I  Introduction to Android platform

1. Android Architecture
2. Android Features
3. Various Versions of Android ( with Features)
4. Dalvik Virtual Machine, Emulator, Android App Components
5. Android Manifest File
1. Video for Manifest file
6. Android App Resources
7. Android Activity

Unit - II  Android User Interface

1. video - Android Studio Basics and sample android project creation 
2. Layouts
3. Basic Android UI -- External link
4. Android UI
5. Styles and Themes
6. Measurements
7. Fragments

Unit - III Intents and Broadcasts

1. ppt on Intents
2. ppt on BroadcastReceivers
3. ppt on Notifications
4. Intents - External Link
1. Youtube video on Intents
2. youtube video - practical - implicit intent
3. youtube video - practical - explicit intent
5. Broadcast Receivers 
   
1. Youtube video on BroadcastReceivers

Unit - IV     Data Storage

1. PPT for Files, Shared Preferences, SQLite & Content Providers
2. Youtube Video for SQLite Theory
3. Youtube Video for Content Providers Theory

Unit - V Advanced Topics

1. Location based Services - old
2. Location based Services - New
3. Alarms
4. RSS Feed(external link)
5. Using Camera(external link)
6. Gestures(external link)
7. Integrating PHP/MYSQL.(external link) - notes
8. Using Internet Resources – Connecting to internet resource, (external link) - Notes
1. using download manager. - notes
9. Publishing android app(external link)

WEB TECHNOLOGIES ECE VIII SEM section- A

Syllabus
Descriptive Questions
( FIND OUT WHETHER YOU CAN ANSWER ALL THESE QUESTIONS OR NOT)
Assignment Marks

External Exam Question Paper

External Exam Key

Unit - I

• HTML - VIDEO

• Notes
• Links & Tables

• CSS - VIDEO

• Notes

• Java Script - VIDEO

• Notes

Unit - II

• XML - good doc
• XML VIDEO 1
• XML VIDEO 2

• DTD - explanation about each tag in DTD
• XML Schema - explanation
• XML SCHEMA examples
• XSLT
• plain xml document
• XSLT document
• xml document with xml
• output for above program
• DOM & SAX Parsers
• Example program
• Java Beans
• ppt
• Example

Unit - III

• Servlet Introduction  - Video

• ServletRequest & ServletResponse
• web.xml for Servlet
• RequestDispatcher
• Session Management
• ServletConfig and ServletContext

Unit - IV

• JSP Introdction
• Components of JSP
• Conditional Processing
• Displaying Values using Expression
• Using expression to set an attribute
• Declaring variables and methods
• Error handling and Debugging
• JDBC THEORY

Unit - V

• Swings PPT - Lecture Notes - NEW
• Struts ppt - Under construction

• Youtube video for Swings introduction - click here 

  Youtube video for JApplet - click here 

• JLabel program 
• JButton Program
• JTextField Program
•   Youtube video for JLabel, JTextField & JButton - click here
• JCheckbox Program
• Youtube video for JCheckbox - click here
• JRadioButton Program 
• youtube video - click here
• JCombobox Program
• JTabbedpane Program
• JScrollpane Program
• youtube video - click here
• JFrame Program1
• JFrame Program2
•  youtube video - click here
• JTree Program
• youtube video - click here