Syllabus Computer Science CS AI 1
Syllabus Computer Science CS AI 1
I – VI Semesters
SCHEME AND SYLLABUS
CONTENTS
Vision, Mission and Program Educational Objectives (PEO)
Program Outcomes (PO) with Graduate Attributes
Mapping of POs with PEOs
SCHEME
SYLLABUS
To impart value-based quality academia; to empower students with wisdom and to charge them
with rich Indian traditions and culture; to invoke the self, to broaden the same towards nation
building, harmony and Universal brotherhood.
MISSION
To ensure sustained progress and development in imparting quality education, to pioneer new
avenues of teaching and research and to emerge as an institution with potential for excellence.
VISION
To cultivate a learning environment that blends core computing principles with AI-driven
M1 problem-solving.
M2 To encourage creativity, teamwork, and communication in developing intelligent, human-
centered technologies.
M3 To equip students with hands-on experience in AI tools, programming, data analytics, and
machine learning.
To promote industry readiness through internships, interdisciplinary projects, and exposure
M4 to AI applications in society.
To equip students with practical skills in programming, machine learning, data handling, and AI
PEO2 tools for successful engagement in industry, entrepreneurship, or research.
To foster adaptability, innovation, and collaborative skills necessary for continuous learning and
PEO3
professional development in the dynamic field of Artificial Intelligence.
To develop responsible computing professionals with an awareness of the societal, environmental,
PEO4 and ethical implications of AI-driven technologies.
M2 2 2 3 2
M3 3 3 2 2
M4 2 3 3 3
PEO 2 3 3 2 3 2 3
PEO 3 2 2 2 2 3 3
PEO 4 2 1 3 2 2 2
Apply data science techniques such as data preprocessing, visualization, and statistical analysis
PSO2 to extract insights from real-world datasets using tools like Python and SQL.
Build and deploy AI-powered applications that demonstrate automation, decision-making, and
PSO3 human-like interactions across domains such as healthcare, education, and business.
Evaluate the ethical, social, and environmental impact of AI systems and apply responsible AI
PSO4 practices that ensure fairness, transparency, and accountability.
SCHEME ON EXAMINATIONS
As per the University Regulation the following split up of marks are to be followed.
(i) SPLIT UP FOR INTERNAL AND EXTERNAL MARKS FOR THEORY AND
PRATICAL PAPER:
Sl. No. Paper Internal External Total
1. Theory 50 50 100
2. Practical 50 50 100
CIA 30
Generic Skill 15
Attendance 5
Total 50
SEMESTER I
Componen Course Cou Name of the course Ove Hrs Tot Marks
t Category rse r Distribution al
Cod All L T P S con CIA ES Total
e Cre tact E
dits Ho
urs
Part I AECC Language I 3 4 - - - 4 50 50 100
Part II AECC English I 3 4 - - - 4 50 50 100
Part III Core Course Python Programming 5 4 1 5 50 50 100
I
Core Python Programming 5 - 1 5 - 6 50 50 100
Practical I Practical
Generic Mathematics I 3 4 1 5 50 50 100
Elective I
PART IV Skill Data Visualization 2 - - 2 - 2 50 50 100
Enhanceme
nt Course –
DS I
Skill Skill Enhancement 2 2 - - - 2 50 50 100
Enhanceme Course
nt Course – – NME I (A)- Office
NME Automation / Those
who have studied
Tamil up to XII Std.
shall take either
Fundamentals of
information
Technology(or)
Network Security
(or) Advanced
Tamil. B)
Those who have not
studied Tamil up to
XII Std. and taken a
Non-Tamil Language
under Part-I shall
take Tamil
comprising of two
courses (level will be
at 6th Standard).
Soft Skill I Soft Skills I 2 2 - - - 2 50 50 100
Total 25 20 3 7 - 30 400 40 800
0
SEMESTER II
Componen Course Co Name of the Ove Hrs Tot Marks
t Category urs course r Distribution al
e All L T P S con CIA ESE Total
Co Cre tact
de dits Ho
urs
Part I AECC Language II 3 4 - - - 4 50 50 100
Part II AECC English II 3 4 - - - 4 50 50 100
Part III Core Course Java 5 4 1 5 50 50 100
II Programming
Core Java 5 - 1 5 - 6 50 50 100
Practical II Programming
Practical
Generic Mathematics II 3 4 1 5 50 50 100
elective II
PART IV Skill Introduction to 2 - - 2 - 2 50 50 100
Enhanceme MYSQL
nt Course –
DS I
Skill Skill 2 2 - - - 2 50 50 100
Enhanceme Enhancement
nt Course – Course – NME II
NME II – AI for Everyone
/ Those who have
studied Tamil up
to XII Std. shall
take either HTML
&Web design or
Crypto Currency
(or) Advanced
Tamil.
Those who have
not studied Tamil
up to XII Std. and
taken a Non-
Tamil Language
under Part-I shall
take Tamil
comprising of two
courses
(level will be at
6th Standard).
Soft Skill II Soft Skills II 2 2 - - - 2 50 50 100
Total 25 2 3 7 30 400 400 800
0
SEMESTER III
Component Course Cour Name of Ove Hrs Total Marks
Category se the course r All Distribution contact
Code Cre L T P S Hours CIA ESE Total
dits
Part I AECC Language 3 5 - - - 5 50 50 100
III
Part II AECC English III 3 4 - - - 4 50 50 100
Part III Core Data 5 5 1 6 50 50 100
Course Structures
III
Core Data 5 - 1 5 - 6 50 50 100
Practical Structures
III Practical
Generic Statistics I 3 5 1 6 50 50 100
elective
III
PART IV Industrial 1 - - - - - - - -
Visit
EVS 1 - - - 1 - - -
Soft Skill 2 2 - - - 2 50 50 100
III
Total 22 22 3 5 - 30 300 300 600
SEMESTER IV
Componen Course Cou Name of the Over Hrs Tot Marks
t Categor rse course All Distribution al
y Cod Cred L T P S con CIA ESE Total
e its tac
t
Ho
urs
Part I AECC Language IV 3 5 - - - 5 50 50 100
Part II AECC English IV 3 4 - - - 4 50 50 100
Part III Core Introduction 5 5 1 6 50 50 100
Course to Artificial
IV Intelligence
Core Prolog 5 - 1 5 - 6 50 50 100
Practica Practical
l IV
Generic Statistics II 3 4 1 5 50 50 100
elective
IV
PART IV EVS 2 2 - - - 2 50 50 100
Soft 2 2 - - - 2 50 50 100
Skill IV
Total 23 22 3 5 30 350 350 700
SEMESTER V
Componen Course Cou Name of Ove Hrs Total Marks
t Category rse the r Distribution contac
Cod course All L T P S t CIA ES Total
e Cre Hours E
dits
Part III Core Computer 4 4 1 - - 5 50 50 100
Course V Vision
Core Natural 4 4 1 - - 5 50 50 100
Course Language
VI Processing
Core Computer 4 - 1 4 - 5 50 50 100
Practical Vision
V Practical
Core Natural 4 - 1 4 - 5 50 50 100
Practical Language
VI Processing
Practical
Disciplin Computer 3 4 1 - - 5 50 50 100
e Specific Networks /
Elective I Software
- Engineerin
Employa g/
bility Computing
Course I System
Fundament
als
Disciplin Cloud 3 4 1 - - 5 50 50 100
e Specific Computing
Elective / Big Data
II - Analytics /
Employa Expert
bility System
Course II
Part IV Internshi 2 - - - - - - - -
p
Value 2 - - - - - 50 50 100
Educatio
n
Total 26 16 6 8 30 350 350 700
SEMESTER VI
Componen Course Cours Name of Ove Hrs To Marks
t Categor e the course r All Distribution tal
y Code Cre L T P S co CIA ESE Total
dits nta
ct
Ho
urs
Part III Core Machine 4 5 1 - - 6 50 50 100
Course Learning
VII
Core Fuzzy 4 5 1 - - 6 50 50 100
Course Logic
VIII
Core Machine 4 - 1 5 - 6 50 50 100
Practica Learning
l VII Practical
Disciplin Mobile Ad- 3 4 1 - - 5 50 50 100
e hoc
Specific Network /
Elective Data
III - Mining and
Employ Warehousi
ability ng /
Course Artificial
III Neural
Network
Disciplin Internet of 3 4 1 - - 5 50 50 100
e Things and
Specific its
Elective Application
IV - s / Robotics
Employ and its
ability Application
Course s
IV /Informatio
n Security
Core Mini 2 - - 2 - 2 50 50 100
Project Project
PART V Extensio 1 - - - - - - - -
n
Activity
Total 21 18 5 7 - 30 300 300 600
Component Credits
Part I 12
Part II 12
Part III 94
Part IV 23
Part V 1
Total
142
Extra Credits 21
(maximum )
Overall 163
Part II English 4 3 12
Core Theory 4 4 16
Core Practical 4 5 20
Core Practical 3 4 12
Core Project 1 2 2
Generic Elective 4 3 12
Discipline Specific 4 3 12
Elective
1. Part IV Skill Enhancement 2 2 4
Course - NME
2. Skill Enhancement 2 2 4
Course - Discipline
Specific
3. Soft Skill 4 2 8
4. Industrial Visit 1 1 1
5. EVS 1 2 2
6. Value Education 1 2 2
7. Internship/Industri 1 2 2
al Training
Note: Students can take extra credit course from their own department or
from
Skilled based vocational courses (2C) e.g. basic computing skill, tailoring,
jewel making, beauty parlour course, interiors etc., through skill development
cell of college.
LEARNING OUTCOME:
•
To interpret the fundamental Python syntax and semantics.
•
To infer the use of Python control flow statements.
•
To express proficiency in the handling of strings and functions.
•
To determine the methods to create and manipulate Python programs by utilizing
the data structures like lists, dictionaries, tuples and sets.
• To identify the commonly used operations involving file systems.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Explain the basic concepts, features, and syntax of Python programming.
Demonstrate the use of variables, data types, and operators in Python programs.
CO2 Construct Python programs using conditional and looping control structures.
CO/PO PO1 PO2 PO3 PO4 PO5 PO6 PSO1 PSO2 PSO3 PSO4 PSO5
CO1 3 2 3 3 2 1 0 2 2 2 3
CO2 2 2 3 2 3 3 0 2 2 2 3
CO3 3 3 2 3 2 2 3 2 3 2 2
CO4 2 0 1 2 2 3 3 2 3 2 2
CO5 1 3 2 2 0 1 3 2 0 3 1
Sl.
CONTENTS OF MODULE Hrs Cos
No.
MODULE I: Introduction: The essence of computational problem
solving – Limits of computational problem solving-Computer
algorithms-Computer HardwareComputer Software-The process of
1 computational problem solving-Python programming language – 15 CO1
Literals – Variables and Identifiers – Operators – Expressions and
Data types, Input / output.
MODULE II: Control Structures: Boolean Expressions – Selection
Control – If Statement- Indentation in Python- Multi-Way Selection
– Iterative Control- While Statement- Infinite loops- Definite vs. CO2
2 15
Indefinite Loops- Boolean Flag. String, List and Dictionary,
Manipulations Building blocks of python programs,Understanding
and using ranges.
MODULEIII: Functions:Program Routines- Defining Functions-
More on Functions: Calling Value-Returning Functions- Calling
3 Non-Value-Returning Functions- Parameter Passing – Keyword 15 CO3
Arguments in Python – Default Arguments in Python-Variable
Scope. Recursion: Recursive Functions.
LEARNING OUTCOME:
• To write, test and debug Python Programs.
• To implement Conditionals and Loops for Python Programs
• To work with functions and Strings in Python.
• To use functions and represent Compound data using Lists, Tuples and Dictionaries.
• To read and write data from & to files in Python and develop Application.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Explain the basic concepts, features, and syntax of Python programming.
Demonstrate the use of variables, data types, and operators in Python
programs.
CO2 Construct Python programs using conditional and looping control structures.
P P P P P P
CO/ PS PS PS PS PS
O O O O O O
PO O1 O2 O3 O4 O5
1 2 3 4 5 6
CO
3 2 2 3 2 1 3 2 2 2 1
1
CO
3 3 3 3 2 1 3 3 2 2 2
2
CO
3 3 2 3 2 2 3 3 2 2 2
3
CO
3 3 3 3 3 2 3 3 2 2 2
4
CO
3 3 3 3 2 2 3 2 2 2 2
5
CORRELATION: 3- STRONG, 2- MEDIUM, 1- LOW
LAB EXERCISES:
1. Program to convert the given temperature from Fahrenheit to Celsius and vice versa
depending upon user’s choice.
2. Write a Python program to construct the following pattern, using a nested loop
*
**
***
****
*****
****
***
**
*
3. Program to calculate total marks, percentage and grade of a student. Marks obtained in
each of the five subjects are to be input by user. Assign grades according to the following
criteria: Grade A: Percentage >=80
Grade B: Percentage >=70 and 80
Grade C: Percentage >=60 and <70
Grade D: Percentage >=40 and <60
Grade E: Percentage < 40 4. Program, to find the area of rectangle, square, circle and triangle
by accepting suitable input parameters from user.
5. Write a Python script that prints prime numbers less than 20.
6. Program to find factorial of the given number using recursive function.
7. Write a Python program to count the number of even and odd numbers from array of N
numbers.
8. Write a Python class to reverse a string word by word.
9. Given a tuple and a list as input, write a program to count the occurrences of all items of
the list in the tuple. (Input: tuple = ('a', 'a', 'c', 'b', 'd'), list = ['a', 'b'], Output: 3)
10. Create a Savings Account class that behaves just like a Bank Account, but also has an
interest rate and a method that increases the balance by the appropriate amount of interest
(Hint: use Inheritance).
11. Read a file content and copy only the contents at odd lines into a new file.
12. Create a Turtle graphics window with specific size.
13. Write a Python program for Towers of Hanoi using recursion
14. Create a menu driven Python program with a dictionary for words and their meanings.
15. Devise a Python program to implement the Hangman Game.
TEXT BOOKS:
REFERENCE BOOKS:
1. Mark Lutz, “Learning Python Powerful Object Oriented Programming”, O’reilly Media
2018, 5th Edition.
2. Timothy A. Budd, “Exploring Python”, Tata MCGraw Hill Education Private Limited
2011, 1 st Edition.
3. John Zelle, “Python Programming: An Introduction to Computer Science”, Second
edition, Course Technology Cengage Learning Publications, 2013, ISBN 978- 1590282410
4. Michel Dawson, “Python Programming for Absolute Beginers”, Third Edition, Course
Technology Cengage Learning Publications, 2013, ISBN 9781435455009
E-REFERENCES:
1. https://www.google.co.in/books/edition/Programming_with_Python
2. https://www.programiz.com/python-programming
3. https://www.guru99.com/python-tutorials.html
SKILL ENHANCEMET COURSE- DS I
LEARNING OUTCOME:
Understand the principles and importance of data visualization to effectively
communicate patterns, trends, and insights from raw data.
Develop proficiency in Python libraries such as Matplotlib, Seaborn, and Plotly to
create static and interactive visualizations.
Apply appropriate visualization techniques based on data types and analysis goals for
informed decision-making.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Create basic plots such as bar charts, line graphs, and pie charts using
Python's
visualization libraries.
LAB EXERCISES:
TEXT BOOKS:
1. Claus O. Wilke , “Fundamentals of Data Visualization: A Primer on Making Informative
and Compelling Figures”, O'Reilly; First Edition (31 March 2019)
REFERENCE BOOKS:
1. Boozman Richard Richard, “Data Visualization with Python: Create Stunning Graphs and
Visualizations with Matplotlib and Seaborn”, Lincoln Publishers.
E-REFERENCES:
1. https://seaborn.pydata.org/
2. https://www.geeksforgeeks.org/data-visualization/data-visualization-with-python-
seaborn/
SKILL ENHANCEMET COURSE- NME- I
LEARNING OUTCOME:
The major objective in introducing the Computer Skills course is to impart training for
students in Microsoft Office which has different components like MS Word, MS Excel and
Power point.
The course is highly practice oriented rather than regular class room teaching.
To acquire knowledge on editor, spread sheet and presentation software.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Understand the basics of computer systems and its components.
CO2 Understand and apply the basic concepts of a word processing package
CO3 Understand and apply the basic concepts of electronic spreadsheet
software.
CO4 Understand and apply the basic concepts of database management
system.
CO5 Understand and create a presentation using PowerPoint tool.
P P P P P P
CO/ PS PS PS PS PS
O O O O O O
PO O1 O2 O3 O4 O5
1 2 3 4 5 6
CO1 3 0 3 2 2 2 2 2 2 3
2
CO2 2 2 0 3 3 3 3 3 2 2 3
CO3 2 2 2 3 2 2 2 2 3 2 3
CO4 1 2 2 2 1 3 1 2 3 3 3
CO5 1 1 2 1 2 2 1 3 1 3 1
CORRELATION: 3- STRONG, 2- MEDIUM, 1- LOW
Sl.
CONTENTS OF MODULE Hrs Cos
No.
Module I:Introductory concepts: Hardware and Software -
Memory unit – CPU-Input Devices: Key board, Mouse and
1 Scanner. Output devices: Monitor, Printer. Introduction to 2 CO1
Operating systems - Introduction to Programming
Languages
Module II :Word Processing: File menu operations -
Editing text – tools, formatting, bullets and numbering -
CO2
2 Spell Checker - Document formatting – Paragraph 2
alignment, indentation, headers and footers, printing –
Preview, options, merge.
Module III: Spreadsheets: Excel – opening, entering text
3 and data, formatting, navigating; Formulas – entering, 2 CO3
handling and copying
Module IV: Charts – creating, formatting and printing,
4 analysis tables, preparation of financial statements, 2 CO4
introduction to data analytics.
Module V: Power point: Introduction to Power point -
Features – Understanding slide typecasting & viewing slides
CO5,
5 – creating slide shows. Applying special object – including 2
objects & pictures – Slide transition – Animation effects,
audio inclusion, timers.
TEXT BOOKS:
1. Peter Norton, “Introduction to Computers” –Tata McGraw-Hill.
REFERENCE BOOKS:
1. Jennifer Ackerman Kettel, Guy Hat-Davis, Curt Simmons, “Microsoft 2003”,
Tata McGraw- Hill
E-REFERENCES:
1. https://tallyeducation.com/tepl/offline-courses/office-automation/
2. https://cceindia.in/
SECOND SEMESTER
CORE II
LEARNING OUTCOME:
• Understand the core features of Java, its environment, and fundamental programming
concepts.
• Gain knowledge of Java's object-oriented principles
• Explore the use of packages, exception handling, and error management techniques to
enhance Java applications.
• Learn how to work with threads, manage synchronization, and handle file operations in
Java.
• Develop interactive applets and GUI applications using AWT components.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Write basic Java programs using correct syntax, and apply concepts like data
types, variables, and control flow.
CO2 Design and implement Java programs using object-oriented principles like
classes, objects, inheritance, and interfaces.
CO3 Create robust Java applications using user-defined packages, exception handling,
and error management.
CO4 Create multithreaded programs, synchronize threads, and handle file operations
using Java I/O classes.
CO5 Develop interactive Java applets and GUI applications using AWT components,
handling basic graphics and user input.
P P P P P P
CO/ PS PS PS PS PS
O O O O O O
PO O1 O2 O3 O4 O5
1 2 3 4 5 6
CO
3 2 1 0 3 3 2 1 2 3 2
1
CO 2 3 2 3 2 2 3 2 2 3 2
2
CO
2 1 0 3 1 3 0 3 2 3 2
3
CO
2 3 2 2 3 3 1 3 3 2
4 2
CO
1 3 0 3 2 3 3 3 3 3 2
5
Sl.
CONTENTS OF MODULE Hrs Cos
No.
MODULE I: Introduction: Review of Object-Oriented
concepts - Java buzzwords (Platform independence,
Portability, Threads)- JVM architecture –Java Program
structure - Java main method - Java Console
1 12 CO1
output(System.out) - simple java program - Data types -
Variables - type conversion and casting- Java Console
input: Buffered input - operators - control statements - Static
Data - Static Method - String and String Buffer Classes
MODULE II: Java user defined Classes and Objects –
Arrays – constructors - Inheritance: Basic concepts - Types
of inheritance - Member access rules - Usage of this and
Super key word - Method Overloading - Method overriding CO2
2 12
- Abstract classes - Dynamic method dispatch - Usage of
final keyword -Packages: Definition - Access Protection -
Importing Packages - Interfaces: Definition –
Implementation – Extending Interfaces
MODULE III: Exception Handling: try – catch - throw -
throws –- finally – Built-in exceptions - Creating own
Exception classes - garbage collection, finalise -
3 Multithreaded Programming: Thread Class - Runnable 12 CO3
interface – Synchronization – Using synchronized methods
– Using synchronized statement - Interthread
Communication – Deadlock.
MODULE IV:The AWT class hierarchy - Swing:
Introduction to Swing - Hierarchy of swing components.
Containers - Top level containers - JFrame - JWindow -
JDialog - JPanel - JButton - JToggleButton - JCheckBox -
4 12 CO4
JRadioButton - JLabel,JTextField - JTextArea - JList -
JComboBox – JscrollPane - Event Handling: Events -
Event sources - Event Listeners - Event Delegation Model
(EDM) - Handling Mouse and Keyboard Events
MODULE V: Adapter classes - Inner classes -Java Util
Package / Collections Framework:Collection & Iterator CO5,
5 Interface- Enumeration- List and ArrayList- Vector- 12
Comparator
TEXT BOOKS:
1.Herbert Schildt, The Complete Reference, Tata McGraw Hill, New Delhi, 7th Edition,
2010. Gary Cornell, Core Java 2 Volume I – Fundamentals, Addison Wesley, 1999.
REFERENCE BOOKS:
1. Herbert Schildt , Dr. Coward, Danny “Java: The Complete Reference” 2. Kathy Sierra & Bert
Bates, "Head First Java", O'Reilly Media, 2nd Edition.
2. E. Balagurusamy, "Programming with Java", Tata McGraw-Hill.
3. Joshua Bloch, "Effective Java", Pearson Education.
4. Paul Deitel & Harvey Deitel, "Java: How to Program", Pearson Education.
E- REFERENCES:
1. Java Tutorials by W3Schools: https://www.w3schools.com/java/
2. Baeldung Java Tutorials: https://www.baeldung.com/
3. GeeksforGeeks Java Programming: https://www.geeksforgeeks.org/java/
CORE PRACTICAL II
LEARNING OBJECTIVES:
Develop Java programs to perform arithmetic operations, demonstrate conditional and
iterative statements, and handle command-line arguments.
Implement constructors, method overloading, and method overriding in Java programs.
Explore inheritance, the final keyword, and the use of String and StringBuffer classes.
Create user-defined packages, demonstrate thread methods, and implement thread
synchronization.
Develop and test applets, including their lifecycle, user input handling, and graphical
features, along with AWT controls and layout managers.
Course Outcomes: At the end of the Course, the Student will be able to:
PO1 PO2 PO3 PO4 PO5 PO6 PSO1 PSO2 PSO3 PSO4 PSO5
CO1 3 3 2 3 3 2 3 2 2 2 2
CO2 3 3 3 3 2 2 3 3 2 2 2
CO3 3 3 2 3 3 3 3 3 2 2 2
LAB EXERCISES:
1. Write a Java program that prompts the user for an integer and then prints out all
the prime numbers up to that Integer?
2. Write a Java program to multiply two given matrices.
3. Write a Java program that displays the number of characters, lines and words in a
text?
5. Generate random numbers between two given limits using Random class and print
messages according to the range of the value generated.
6. Write a program to do String Manipulation using Character Array and perform the
following string operations: a) String length b) Finding a character at a particular
position c) Concatenating two strings
7. Write a program to perform the following string operations using String class: a)
String Concatenation b) Search a substring c) To extract substring from given
string
8. Write a program to perform string operations using StringBuffer class: a) Length
of a string b) Reverse a string c) Delete a substring from the given string
9. Write a java program that implements a multi-thread application that has three
threads. First thread generates random integer every 1 second and if the value is
even, second thread computes the square of the number and prints. If the value is
odd, the third thread will print the value of cube of the number.
10. Write a threading program which uses the same method asynchronously to print
the numbers 1 to 10 using Thread1 and to print 90 to 100 using Thread2. 10. Write
a program to demonstrate the use of following exceptions. a) Arithmetic Exception
b) Number Format Exception c) Array Index Out of Bound Exception d) Negative
Array Size Exception
11. Write a Java program that reads on file name from the user, then displays
information about whether the file exists, whether the file is readable, whether the
file is writable, the type of file and the length of the file in bytes?
12. Write a program to accept a text and change its size and font. Include bold italic
options. Use frames and controls.
13. Write a Java program that handles all mouse events and shows the event name at
the center of the window when a mouse event is fired. (Use adapter classes).
14. Write a Java program that works as a simple calculator. Use a grid layout to
arrange buttons for the digits and for the +, -,*, % operations. Add a text field to
display the result. Handle any possible exceptions like divide by zero.
15. Write a Java program that simulates a traffic light. The program lets the user select
one of three lights: red, yellow, or green with radio buttons. On selecting a button,
an appropriate message with “stop” or “ready” or “go” should appear above the
buttons in a selected color. Initially there is no message shown.
TEXT BOOKS:
1. Abraham Silberschatz, Peter B. Galvin, Greg Gagne “Operating System Concepts”,
Tenth Edition, 2018, John Wiley & Sons.
REFERENCE BOOKS:
E-REFERENCES:
1. https://docs.oracle.com/javase/tutorial
2. https://www.javatpoint.com/java-tutorial
3. https://www.w3schools.com/java/
SKILL ENHANCEMET COURSE- DS II
LEARNING OUTCOME:
Understand and manage MySQL database users, databases, and table structures
through command-line operations and SQL statements.
Develop skills to perform CRUD operations using various SQL queries, constraints,
and clauses to handle and manipulate data effectively.
Apply relational database concepts such as joins, views, aggregate functions, and
grouping to retrieve meaningful insights from structured data.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Perform user management and database administration tasks such as creating
users,
managing privileges, and handling databases using MySQL.
CO2 Create, modify, and manage tables and views to structure and organize data in a
relational
format.
CO3 Construct and execute SQL queries to insert, update, delete, and retrieve data
from
databases using appropriate clauses and constraints.
CO4 Utilize aggregate functions, grouping, and filtering techniques to perform
analytical
operations on datasets.
CO5 Implement various types of joins to query and combine data from
multiple related tables for comprehensive data analysis.
CO/ P P P P P P PS PS PS PS PS
PO O O O O O O O1 O2 O3 O4 O5
1 2 3 4 5 6
CO
3 2 3 2 2 3 2 3 3 2 3
1
CO
3 2 2 3 3 3 2 3 3 3 3
2
CO
3 3 3 2 2 2 2 3 3 2 3
3
CO
3 2 2 3 2 3 2 2 3 3 3
4
CO
2 3 3 2 2 2 3 3 2 2 3
5
PRACTICAL EXERCISES:
1. User Management
a. MySQL Create User
b. MySQL Drop User
c. MySQL show Users
d. Change User Password
2. Databases
a. MySQL Create Database
b. MySQL Select Database
c. MySQL Show Database
d. MySQL Drop Database
4. MySQL Queries
a. MySQL Queries
b. MySQL Constraints
c. MySQL insert Query
d. MySQL Update Query
e. MySQL Delete Query
f. MySQL Select Query
g. Insert On Duplicate Key Update
5. MySQL Clauses
a. MySQL Where
b. MySQL AND
c. MySQL OR
d. MySQL LIKE
e. MySQL Limit
f. MySQL Order By
g. MySQL Group By
h. MySQL Having
i. MySQL Distinct
j. MySQL Union
k. MySQL Union All
TEXT BOOKS:
1. Manish Soni, “MySQL Text Book”, Poorav Publications
REFERENCE BOOKS:
1. Vikram Vaswani, “MySQL(TM): The Complete Reference”, McGraw Hill Education; 1st
edition
E-REFERENCES:
1. https://www.w3schools.com/MySQL/default.asp
2. https://www.mysqltutorial.org/
SKILL ENHANCEMET COURSE- NME- II
LEARNING OUTCOME:
• Understand the basics of artificial intelligence and its subfields.
• Explore real-world applications of AI across different industries.
• Gain insights into the ethical, social, and economic implications of AI.
• Develop an appreciation for the potential of AI to drive innovation and transformation.
Course Outcomes: At the end of the Course, the Student will be able to:
CO1 Define and explain the fundamental concepts and subfields of AI.
P P P P P P
CO/ PS PS PS PS PS
O O O O O O
PO O1 O2 O3 O4 O5
1 2 3 4 5 6
CO
2 3 0 3 1 3 0 2 3 2 3
1
CO
3 2 0 2 2 2 0 3 2 2 3
2
CO
2 1 3 1 2 1 0 2 2 3 3
3
CO
3 3 2 2 2 1 3 1 3 2 3
4
CO
1 0 1 3 3 1 2 0 2 1 3
5
CORRELATION: 3- STRONG, 2- MEDIUM, 1- LOW
Sl.
CONTENTS OF MODULE Hrs Cos
No.
Module I:Introduction to Artificial Intelligence
• Definition and scope of AI
• Historical overview and key milestones
1 • Differentiating AI from human intelligence 2 CO1
TEXT BOOKS:
1. Saptarsi Goswami, Amit Kumar Das, Amlan Chakrabarti, “AI for Everyone: A Beginner's
Handbook for Artificial Intelligence (AI)”, Pearson Education
REFERENCE BOOKS:
E-REFERENCES:
1. https://ai-for-all.in/#/home
2. https://www.edx.org/learn/artificial-intelligence/ibm-ai-for-everyone-master-the-basics
APPENDIX
There are three educational Outcomes as defined by the National Board of Accreditation.
MAPPING OF OUTCOMES
DEPARTMENTAL MISSION
DEPARTMENTAL VISION
BLOOM’S TAXONOMY
Bloom’s taxonomy is a classification system used to define and distinguish different levels of
human cognition—i.e., thinking, learning, and understanding. Educators have typically used
Bloom’s taxonomy to inform or guide the development of assessments (tests and other
evaluations of student learning), curriculum (units, lessons, projects, and other learning
activities), and instructional methods such as questioning strategies. [eduglosarry.org]