Government of Karnataka

Department of Technical Education

C-25 Diploma Curriculum

Computer Science and Engineering

Scheme of Studies
(Effect from the AY 2025-26)
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Curriculum Structure
I Semester Scheme of Studies - Diploma in Computer Science and Engineering
CIE Theory SEE Practice SEE

Hours/week
Department

Hours per week

Total Contact
Teaching

Marks Marks Marks

Credits
Course Code Course Name Total
Sl. L T P Max Min Max Min Max Min Marks
No.

Integrated Courses

1 SC 25SC11I Engineering Mathematics-I 4 0 4 8 6 50 20 50 20 - -

100

2 CS 25CS01I IT Skills 3 0 4 7 5 50 20 - - 50 20 100

3 EE 25EE01I Fundamentals of Electrical & 3 0 4 7 5 50 20 - - 50 20

100
Electronics Engineering.
CS Basics of Digital Logic and
4 25CS11I 4 0 4 8 6 50 20 50 20 - - 100
Computer Organization
Audit Course

5 CS 25CS12T Environmental Sustainability 2 0 0 2 2 50 20 - - -

- 50

6 Personality Students are expected to engage in any one of these activities from 1st semester to 6th semester(No
NCC/NSS/YOGA/SPORTS… Credits)
Development
Total 16 0 16 32 24 250 - 100 - 100
- 450

DepartmentofTechnicalEducation,GovernmentofKarnataka 1
 Government of Karnataka
DEPARTMENT OFTECHNICAL EDUCATION
Curriculum Structure
II Semester Scheme of Studies - Diploma in Computer Science and Engineering
CIE Theory SEE Practice SEE

Hours/week
Department

Hours per week

Total Contact
Teaching

Marks Marks Marks

Credits
Course Code Course Name Total
Sl. L T P Max Min Max Min Max Min Marks
No.

Integrated Courses

1 SC 25SC21I Engineering Mathematics-II 4 0 4 8 6 50 20 50 20 - - 100

2 ENG 25EG01I Essential English 4 0 4 8 6 50 20 - - 50 20

100
Communication

3 ME 25ME02I Computer Aided Engineering. 3 0 4 7 5 50 20 - - 50 20

100
Graphics

4 CS 25CS21I Thinking Programming with 4 0 4 8 6 50 20 50 20 - -

100
Python
Audit Course

5 CS 25CS22T Indian Constitution 2 0 0 2 2 50 20 - - -

- 50

6 Personality Students are expected to engage in any one of these activities from 1 st semester to 6th semester (No
NCC/NSS/YOGA/SPORTS… Credits)
Development
Total 17 0 16 33 25 250 - 100 - 100
- 450
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Curriculum Structure
III Semester Scheme of Studies - Diploma in Computer Science and Engineering
CIE Theory SEE Practice SEE

Hours/week
Department

Hours per week

Total Contact
Teaching

Marks Marks Marks

Credits
Course Code Course Name Total
Sl. L T P Max Min Max Min Max Min Marks
No.

Integrated Courses

1 CS 25CS31I Database Concepts & 4 0 4 8 6 50 20 50 20 - -

100
Technologies
2 CS 25CS32I Computer Networks 4 0 4 8 6 50 20 50 20 - - 100

3 CS 25CS33I Data Structures with Python 3 0 4 7 5 50 20 - - 50 20 100

4 CS 25CS34I System and Network 3 0 4 7 5 50 20 - - 50 20

100
Administration
Audit Course
KA 25KA31T Kannada –I
5 2 0 0 2 2 50 20 - - -
(ಸಾಹಿತ್ಯ ಸಿಂಚನ-I/ಬಳಕೆ ಕನನಡ-I) - 50

Total 16 0 16 32 24 250 - 100 - 100

- 450
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Curriculum Structure
IV Semester Scheme of Studies - Diploma in Computer Science and Engineering
CIE Theory SEE Practice SEE

Hours/week
Department

Hours per week

Total Contact
Teaching

Marks Marks Marks

Credits
Course Code Course Name Total
Sl. L T P Max Min Max Min Max Min Marks
No.

Integrated Courses

1 CS 25CS41I Operating Systems and 4 0 4 8 6 50 20 50 20 - -

100
Administration
2 CS 25CS42I Object Oriented Programming 4 0 4 8 6 50 20 50 20 - -
100
with Java

3 CS 25CS43I Data Analysis and Algorithm 3 0 4 7 5 50 20 - - 50 20

100
Design

4 CS 25CS44I Web Development 3 0 4 7 5 50 20 - - 50 20 100

Audit Course
KA 25KA41T Kannada –II
5 2 0 0 2 2 50 20 - - -
(ಸಾಹಿತ್ಯ ಸಿಂಚನ-II/ಬಳಕೆ ಕನನಡ-II) - 50

Total 16 0 16 32 24 250 - 100 - 100

- 450
SEMESTER 1
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Engineering Semester 1
Course Name IT Skills Type of Course Integrated
7 per week
Course Code 25CS01I Contact Hours
Teaching Scheme 3: 0:4 Credits 5
CIE Marks 50 SEE Marks 50 (Practice)

1. Rationale: This content equips learners with essential IT skills needed to thrive in a technology-driven
world by fostering digital literacy and problem-solving abilities. Through logical thinking and block coding,
students develop computational thinking crucial for solving real-world challenges. Emphasizing cyber
safety and security ensures learners adopt responsible and ethical digital practices. Incorporating
multimedia design, AI, cloud, and IoT tools prepares students to innovate and leverage emerging
technologies. This holistic approach bridges foundational IT skills with advanced applications, enabling
learners to adapt and excel in diverse fields.

2. Course Outcomes : At the end of the Course, the student will be able to:
Use computer, Internet.
CO-01
Develop problem-solving skills by applying logical thinking and block coding techniques.
CO-02
Develop engaging multimedia presentations.
CO-03
Implement best practices of cyber safety and security.
CO-04
Use Free AI, cloud and IoT services to solve computing problems.
CO-05

3. Course Content
Week CO PO Lecture(3HRS) Practice(4HRS)
(Knowledge Criteria) (Performance Criteria)
Introduction to Computers 1. Identify the parts of a computer system.
2. Create a file, folder and find details of
● Definition and basic understanding the Operating system and hardware being
of a computer. used.
● Generations of Computers
3. Connect components and install
● Types of Computers
application software such as scratch.
● Block Diagram of a Digital Computer
● Functional Units of the CPU: 4. List out important factors/criteria to be
○ ALU considered while buying a computer:
1 1 1
○ Control Unit a. Purpose – Professional, Gaming,
General use, Portability
Memory Systems: Types of Memory and b. Budget
Their Usage: c. Processor – Brand, Cores and threads,
Primary Memory: RAM(SRAM, DRAM). clock speed
Cache Memory: Levels of cache (L1, L2, d. Memory (RAM) – Minimum required
L3) and their purpose in speeding up data and type
access. e. Storage – Type(HDD, SSD), Capacity
 Secondary Memory: ROM (Read-Only f. Display – Size, Resolution, Refresh rate
Memory), Hard Disk Drives (HDD) and g. Ports and connectivity: USB, HDMI,
Solid State Drives (SSD) Ethernet etc.
Input/output Systems: Types of I/O h. Graphics – Integrated/ Dedicated
Devices, Cables and Connectors i. Operating system – Windows, Linux,
Software: System software (e.g., Mac
operating systems) vs. application j. Battery life in case of a laptop
software (e.g., word processors,
k. Build quality and design, Brand
browsers).
warranty etc.

Internet skills: 1. Create Email account such as Gmail and

What is Computer Networks? Explore various services offered in Google
Types of Networks. Physical and Logical accounts such as a. Gmail b. docs c. Sheets
address, Protocols, Key Devices in a d. forms etc.
Network (Router, Switch, Modem, Access 2. Download any application software
Point) required for your learning ( Such as internet
What is the Internet, Common browser) and install it on your machine.
Applications of the Internet? 3. Design, develop and host a personal
Browsers, Web Server, Client–Server website using any free platform such as
2 1 1,4 Model, URL, Search Engine, Domain name wix.com or worldpress.com
and domain name system, websites. 4. Manual and Automatic address
Personal website, website hosting. assignment
(Windows and Android)
a) IPv4 address
b) Subnet mask
c) DNS and Default gateway
5. Test Internet speed

Cybersecurity
What is Cybersecurity? 1. Demonstrate Two-factor authentication
Confidentiality, 2. Browser settings
Integrity, Availability. 3. Android App permissions and settings.
Brief awareness of cyber safety 4. Firewall concepts and settings.
measures, 5. Setup Wireless network security.
Data, Types of Data (Personal,
Organizational) Protecting your personal
1,4, data and devices: Device sync
3 4
5,7 Online identity - Where is your data?
Terms of service while signing up for a
web application and sharing your data.
Home WiFi Security, Public Wi-Fi risks.

Basic security issues in your mobile

phones and personal computers,
Importance of privacy and Password
policy (Best practices). Two factor
authentication.
4 4 1,4, Security Attacks (Demonstration) 1. Installation of Antivirus software
 5,7 Malware and its types, Phishing, Social 2. Installing and Updating Browser Plug-ins.
Engineering, DoS attack, On-path attack, 3. Privacy settings in social media
Man in the middle attack, accounts.
Eavesdropping, Spamming, Identity Security audit ( Antivirus, strong password,
theft, Password attacks, SEO Poisoning firewall, app settings and permissions,
Etc. unwanted apps) of all your personal smart
Internet Safety computer, college computer and smart
Anti-virus software, phone.
HTTP vs HTTPS, Firewall, Cookies.

Staying Safe from Online Predators,

Cyberbullying and Cyber harassment,
Using Social Networks Safely.
Introduction to Problem Solving 1. Write an algorithm for programmable
Steps for Problem Solving problems
Algorithms: a. Add/subtract two numbers
What is Algorithm, How and why to b. Find the largest/smallest of 3 numbers
design Algorithm. c. Find the square of a number
Sequencing, Selection, iteration. d. Calculate and print the sum of 'N'
numbers
e. check whether a number is odd or
even.
1,2,
5 2 2. Write Algorithm to accept numbers till the
3,7
user enters 0 and then
find their average.
3. Write Algorithm to draw following pattern
on screen
*
********
**************
*********
*
Flowcharts: Write flowchart for programmable problems
What is Flow Chart, How and why to a. Add/subtract two numbers
design Flow Chart. b. Find the largest/smallest of 3 numbers
Sequencing, Selection, iteration. c. Find the square of a number
d. Calculate and print the sum of 'N'
numbers
e. check whether a number is odd or
1,2, even.
6 2
3,7 2. Write Algorithm and flowchart to
accept numbers till the user enters 0 and
then
find their average.
3. Write Algorithm and Flowchart to draw
fallowing pattern on screen
*
********
 **************
*********
*
Block coding 1. Explore different code blocks
What is block coding? 2. Design and implement a scratch project
How does block-based coding work? to move a object 10 steps and say hello.
Introduction block coding platforms ( MIT 3. Design and implement scratch project
scratch or Edublock) with 2 objects interacting
1,2, Different blocks and their uses Teacher can use any free visual block coding
7 2
3,7 Motion tools for execution, some examples are
Looks a.https://scratch.mit.edu/
Sound
b.https:// edublocks.org
Events
c. https://mblock.cc

Block coding 1. Explore different code blocks

Different blocks and their uses 2. Design and implement program to
Control check largest of 3 numbers.
Sensing 3. Design and implement program
Operators calculate sum of n even numbers
Variables 4. Design a simple game using the MIT
1,2,
8 2 scratch tool.
3,7
5. Convert block code to python code
Teacher can use any free visual block coding
tools for execution, some examples are
a.https://scratch.mit.edu/
b.https:// edublocks.org
c. https://mblock.cc
Cloud Computing:
● Definition, applications, and real
world examples. ● File management (upload your
● Cloud service models (SaaS, PaaS, documents, class notes, study materials ),
IaaS) Organizing, and Sharing Files Using Google
● Deployment models (Public, Drive
Private, Hybrid, Community) with ● Real-Time Collaboration on Google
examples. Docs(Edit a document such as your lab
2,4,
9 5, 1 Cloud Storage and Online Collaboration observation in Google docs, name the
5
● Cloud Storage: Google Drive, versions and demonstrate.)
OneDrive, Dropbox ● Creating and Managing a Shared Task
● Basics of Online Collaboration List Using Google Sheets
Tools: Google Docs, Sheets, and Slides ● Creating a Basic Online
● File Sharing and Permissions: Survey(feedback) Using Google Forms
Securing Shared Data
Web-Based Applications: Online Forms
and Surveys
What is Internet of Things, IoT Examples. 1. Create a simple visual block code to
How Does IoT works : Sensors, Actuator in blink LED in Arduino board using visual block
2,4,
10 5, 1 IoT, Control unit/data processing. code, upload code to Arduino board and
5
Applications of IoT. demonstrate.
Examples of IoT in everyday life: Smart 2. Create a Traffic signal controller with 3
 home, smart lighting, Building
LED ( RED, YELLOW and GREEN), upload
information system, Automation in code to Arduino board and demonstrate.
Manufacturing, IoT in automobiles etc. Note : Students and Teachers to use visual
The Future of IoT. block code platform such as
a. https://www.tinkercad.com/
b. https://mblock.cc
for building IoT application and
demonstration.
Multimedia and Presentation: 1. Explore interfaces of editing tool such
Multimedia Building blocks as adobe photoshop
Text, Audio, Image, Animation, Video a. Customizing Workspaces.
Resolution, Size, Compression. b. File Handling
Multimedia file formats c. Setting size and resolution
Image: JPEG, PNG, GIF, TIFF, PNG d. parameters.
11 3 4,7
Audio: MP3, WAV, MP4 etc e. Importing files.
Video: MP4, AVI, WMV, FLV, MPEG, MOV f. Working with Layers
etc g. Explore tool box
Image editing techniques h. Explore Filters
2. Perform photo compositing
3. Create Personal Visiting card
Design a graphic 1. Create Invitation for College fest
 Cards 2. Create Banner for College admission
 Flyer promotion activities
 Banner 3. Create social media graphic for college
social media and placement accounts.
 Advertisement
12 3 4,5
Using blend modes create
 Logo
 Poster
Creating custom shape &
text Wrapping
Artificial Intelligence Know the usage of free AI tools:
Definition of AI Learning and Study Tools:
Difference between AI and Human ChatGPT (Free Plan):
Intelligence (https://chat.openai.com/)
Google Gemini
Types of AI https://gemini.google.com/
Wolfram Alpha
• Narrow AI (Weak AI)
(https://www.wolframalpha.com/)
• General AI (Strong AI
5,1, 4,5,
13 • Superintelligent AI
3 7 Writing and Language Tools:
Real-World Applications and Use Cases Grammarly (Free Plan)
of AI: (https://www.grammarly.com/)
AI in Industry Quillbot(https://quillbot.com/)
• Healthcare DeepL Translator(https://www.deepl.com/)
• Finance LanguageTool(https://languagetool.org/)
• Automotive
• Retail Creativity and Visual Tools:
AI in Consumer Products Canva (Free for Education)
 Smart Assistants: Siri, Alexa, and Google Runway ML (Free Plan)
Assistant. Problem Solving
AI in Social Media: Content Copilot: Assists with coding and
recommendation, ad targeting programming tasks, offering real-time
Entertainment: Netflix and Spotify etc. suggestions and error corrections to
Generative AI enhance learning
How AI works:
Google Teachable Machine
https://teachablemachine.withgoogle.com/

4. Learning Resources
Week Resources
1 1. https://edu.gcfglobal.org/en/basic-computer-skills/
2. https://www.geeksforgeeks.org/computer-fundamentals-tutorial/
3. Any youtube demo videos
4. ChatGPT
5. NCERT School books
2 1. https://edu.gcfglobal.org/en/topics/internet/
2. https://www.geeksforgeeks.org/basics-computer-networking/
3. Any youtube demo videos
4. ChatGPT
5. School books
3 1. https://edu.gcfglobal.org/en/topics/onlinesafety/
2. https://www.geeksforgeeks.org/cyber-security-types-and-importance
3. https://www.w3schools.com/cybersecurity
4. Introduction to Cybersecurity: Netcad.com course
5. ChatGPT
6. School books
4 1. https://edu.gcfglobal.org/en/topics/onlinesafety/
2. https://www.geeksforgeeks.org/cyber-security-types-and-importance
3. https://www.w3schools.com/cybersecurity
4. https://www.cisco.com/c/en_in/products/security/common-cyberattacks.html#~types-of-
cyber-attacks
5. Introduction to Cybersecurity: Netcad.com course
6. ChatGPT
7. School books
5 1. NCERT class 11 Computer Science
2. Youtube videos
6 1. NCERT class 11 Computer Science
2. Youtube videos

7,8 1. https://scratch.mit.edu/explore/projects/tutorials/
2. https://developers.google.com/blockly
09 1. https://www.geeksforgeeks.org/cloud-computing-tutorial/
2. https://cloud.google.com/
3. https://aws.amazon.com/education/awseducate/
4. https://edu.gcfglobal.org/en/topics/usingthecloud/
10 1. https://www.javatpoint.com/iot-internet-of-things
2. https://www.ibm.com/topics/internet-of-things
 3. https://www.tinkercad.com/
4. https://mblock.cc
11,12 1. https://helpx.adobe.com/in/photoshop/user-guide.html
2. https://webneel.com/
3. https://clippingpathindia.com/
4. https://www.photoshopessentials.com/basics/
5. https://www.befunky.com/
13 1. NCERT Informatics Practices for Class 11
2. https://www.geeksforgeeks.org/What-is-ai-artificial-intelligence/
3. https://teachablemachine.withgoogle.com/
4. https://scratch.mit.edu/search/projects?q=AI
5. https://gemini.google.com/
6. https://www.perplexity.ai/
7. https://chatgpt.com/
8. https://www.meta.ai/
9. https://copilot.microsoft.com/
10. https://www.canva.com/ai-image-generator/
11. https://www.slido.com/

5. CIE Assessment Methodologies

Duration
Sl.No Test Max
CIE Assessment (minutes)
Week marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
Average of all
3 CIE-3TheoryTest 10 90 50 CIE=50 Marks
4. CIE-4Practice Test 13 180 50
CIE-5 Portfolio evaluation of
5 all the activities 1-13 50
through
Rubrics
Total 50 Marks

6. SEE – Practice Assessment Methodologies

Duration Min marks to pass
Sl.No Max
SEE – Practice Assessment (minutes)
marks
1. Semester End Examination-Practice 180 50 20
7. Theory Test model question paper
Program Computer Science and Engineering Semester -1
Course Name
IT skills Test III
Course Code 25CS01I Duration 90 min Marks 50

Name of the Course Coordinator:

Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q.No Questions Marks
Level Outcome

Section - 1
a) Write Algorithm to accept numbers till the user enters 0 A 2 25
and then find their average. 15 Marks
1 b) Describe Steps for Problem Solving with example. 10 A 2
Marks
1. a) Write Flowchart to draw fallowing pattern on A 2
screen
*
********
**************
2 *********
*
15 marks A 2
b) List different symbols used in flowchart, list and describe
their functions 10 marks
Section – 2
a) Explain any 2 loop and decision blocks with example 5 U 2 25
Marks
b) What is IoT? Illustrate with example. 10 Marks U 5
3
c) What are cloud service models? Illustrate its applications A 5
with example. 10 Marks

a) What is block coding? Illustrate its advantages 5 marks U 2

b) What are cloud deployment models? Illustrate its U 5
applications with example 10 marks
4
c) List and explain applications of IoT with example 10 U 5
Marks

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman
8. CIE Practice Test model question paper
Program Semester 1
Computer Science and Engineering
Course Name Test II
IT skills
Course Code 25CS01I Duration 180 min Marks 50

Name of the Course Coordinator:

Questions CO Marks

50
1. Design Algorithm, flowchart and implement program to check largest of 3 2
numbers in MIT scratch

Scheme of assessment

a) Algorithm 10
b) Flow Chart 10
c) Scratch Application block code design and implementation 20
d) Demonstration 10
TotalMarks 50

Sign of the Course Coordinator Signature of the HOD

9. SEE- Model Practice Question Paper

Program Semester 1
Computer Science and Engineering

Course Name Course Code : 25CS01I Duration 180

IT skills
min
CO Marks
Questions
1,2,3,5 50
1. i. Design Algorithm, flowchart and implement program to a simple apple
catching game in MIT scratch
ii. save your algorithm, flowchart in cloud
iii. Create a digital poster for your game and demonstrate
Scheme of assessment 10
a) Algorithm and flowchart 10
b) Scratch Application block code design and implementation 10
c) Use of cloud services 10
d) Multimedia design 10
d) Demonstration
Total Marks 50

Signature of the Examiner 2) Signature of the Examiner

10. Rubrics for Assessment of Activity(Qualitative Assessment)
Sl. Dimension Excellent (10) Good (8) Satisfactory (6) Needs Improvement Score
No. (4 or below)
9-10 7-8 5-6 <=4
Demonstrates thorough 8
Shows good Demonstrates basic Lacks understanding
understanding of
Understanding of understanding of understanding but of concepts or is
1 underlying concepts and
Concepts concepts with minor struggles with deeper unable to explain
explains them
gaps. applications. them clearly.
confidently.
Writes basic code 6
Writes efficient, well- Writes functional Writes poor or non-
with some
structured, and and mostly clean functional code with
2 Implementation Skills inefficiencies and lack
commented code with code with minor little to no structure
of comments or
appropriate logic. inefficiencies. or comments.
structure.
Actively collaborates, Participates well, Does not participate 7
Participates minimally
contributes ideas, and shares ideas, and in teamwork or
3 Teamwork/Collaboration and may not engage
supports peers collaborates with creates disruptions
fully with peers.
effectively. minor lapses. within the team.
Fails to present 9
Presents results Struggles to explain
Explains the results and results clearly or
with minor results clearly or
4 Presentation of Results process clearly with shows lack of
inaccuracies or gaps makes incorrect
accurate conclusions. understanding of the
in explanation. conclusions.
process.
Fails to complete the 10
Completes the task well Completes the task Completes the task
task within the
within the allotted time on time with minor with significant delay
5 Adherence to Time allotted time or
with no compromise on compromises in or compromises in
quality is highly
quality. quality. quality.
compromised.
TOTAL 40
Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

11. Model Questions

Week T/P Questions
1 T 1. What is Computer? Explain digital computer with block diagram
2. Illustrate generations and types of computer
3. List and describe functional blocks of computer
4. What are different types of memory in digital computer? Illustrate each with
example
5. Differential between main memory and secondary memory
6. Differential between Input and Output devices
7. List and explain different digital computer cables and connectors
8. What is an operating system? Illustrate uses of operating system
9. Describe different types of software with examples
10. List the factors to be considered while purchasing a computer
P 1. Connect parts of computer, create a folder for yourself & install scratch
software in it.
2 T 1. What is computer network? Illustrate types
2. Differentiate LAN, MAN, WAN
3. Differentiate Physical and Logical address
4. Illustrate key network devices
5. What is Internet? List applications
6. Illustrate Client – server model
7. Explain browser and web server
8. What is domain name system? Illustrate domain names with example
9. What is an URL? Illustrate with example
10. Illustrate search engine with example
 P 1. Create E- Mail account and demonstrate the services it offer
2. Download and install any web browser
3. Design and host a personal website for yourself
4. Configure IP address for your computer
3 T 1. What is Cyber security? Illustrate Confidentiality,Integrity, Availability.
2. What is data? Describe types of data
3. List measures to protect your personal and organizational data
4. Where is your social media data is stored? Did you dive permission to store
and share your data? Discuss
5. Discuss important settings in your home wifi settings.
6. What are the risks while using public Wifi?
7. Discuss Basic security issues in your mobile phones and personal computers
8. Discuss importance of two factor authentication
P 6. Demonstrate Two-factor authentication
7. Demonstrate Browser settings
8. Demonstrate smart phone App permissions and settings.
9. Install Firewall and demonstrate settings.
10. Demonstrate Wireless network security settings
4 T 1. What is virus ? illustrate with example.
2. Differential between ransomware and spyware
3. List and explain different types of malwares
4. What is Phishing? Illustrate with example
5. Discuss social engineering
6. Illustrate denial of service attack.
7. Illustrate On-path attack, Man in the middle attack, Eavesdropping, Spamming,
Identity theft, Password attacks, SEO Poisoning.
8. What is an antivirus software? Discuss its importance
9. Differential between HTTP and HTTPS
10. What is firewall? How does it protect your device?
11. Illustrate cookies, explain role of cookies in security risk.
12. What is Cyberbullying?
P 4. Install of Antivirus software and demonstrate settings
5. Demonstrate the process of updating Browser Plug-ins and settings
6. Demonstrate Privacy settings in social media accounts.
7. Perform Security audit ( Antivirus, strong password, firewall, app settings and
permissions, unwanted apps) of all your smart phone.
5 T 1. Describe Steps for Problem Solving with example.
2. Illustrate Algorithm with an example.
3. Write Algorithm to accept numbers till the user enters 0 and then find their
average
4. Write Algorithm to draw fallowing pattern on screen
*
********
**************
*********
*
5. Write Algorithm to Calculate and print the sum of 'N' numbers
6. Write Algorithm to check whether a number is odd or even
 P 1. Write Algorithm to accept numbers till the user enters 0 and then find their
average.
2. Write Algorithm to draw fallowing pattern on screen
*
********
**************
*********
*
3. Write Algorithm to Calculate and print the sum of 'N' numbers.
4. Write Algorithm to check whether a number is odd or even.
6 T 2. List different symbols used in flowchart, list and describe their functions.
3. Write Flowchart to accept numbers till the user enters 0 and then find their
average find their average.
4. Write Flowchart to draw fallowing pattern on screen
*
********
**************
*********
*
5. Write Flowchart to Calculate and print the sum of 'N' numbers.
6. Write Flowchart to check whether a number is odd or even.
P 1. Write Flowchart to accept numbers till the user enters 0 and then find their
average find their average.
2. Write Flowchart to draw fallowing pattern on screen
*
********
**************
*********
*
3. Write Flowchart to Calculate and print the sum of 'N' numbers.
Write Flowchart to check whether a number is odd or even.
7,8 T 1. What is block coding? Illustrate its advantages
2. Explain any 2 loop and decision blocks with example
3. Design and implement program to check largest of 3 numbers.
4. Design and implement program calculate sum of n even numbers.
P 1. Design and implement a scratch project to move a object 10 steps and say hello.
2. Design and implement program to check largest of 3 numbers.
3. Design and implement program calculate sum of n even numbers.
4. Design a simple game using the MIT scratch tool.
9 T 1. What is cloud computing? Illustrate its applications with example
2. What are cloud deployment models? Illustrate its applications with example
3. What are cloud service models? Illustrate its applications with example
4. Differentiate between SaaS / PaaS and IaaS
5. Differentiate between Public / Private / Hybrid cloud models
P 1. Demonstrate creating folder, organizing files and editing documents in google
drive.
2. Collect attendance using google form, edit the data in google drive and
 demonstrate its advantages
10 T 1. What is IoT? Illustrate with example.
2. Illustrate components of IoT.
3. Discuss features of IoT.
4. List and explain applications of IoT with example.
P 1. Create a simple visual block code to blink LED in Arduino board using visual block
code, upload code to Arduino board and demonstrate.
2. Create a Traffic signal controller with 3 LED ( RED, YELLOW and GREEN), upload
code to Arduino board and demonstrate.
11 T Illustrate Building blocks of multimedia.
Write a note on image resolution and how is this connected to image file size
Discuss major multimedia file formats.
P 2. Explore interfaces of editing tool such as adobe photoshop
i. Customizing Workspaces.
j. File Handling
k. Setting size and resolution
l. parameters.
m.Importing files.
n. Working with Layers
o. Explore tool box
p. Explore Filters
2. Perform photo compositing
3. Create Personal Visiting card
12 T 1. Illustrate steps in creating multimedia banner.
2. Illustrate steps in creating Logo or poster.
P 1. Create Invitation for College fest
2. Create Banner for College admission promotion activities
3. Create social media graphic for college social media and placement accounts.
13 T 1. What is Artificial Intelligence? Describe a real world example.
2. Illustrate AI types and Use.
3. Illustrate applications of AI.
4. Write note on generative AI.
P 1. Google Teachable Machine : Demonstrate classification of male and female
2. Gemini: Demonstrate its use for generating answers, creating summary etc.
3. ChatGPT: Demonstrate its use for creating project report.
4. Copilot: Demonstrate using copilot to design personal website
5. Canva AI: Create banner for your college fest/admission promotion.
6. Grammerly : Demonstrate Correcting your activity report for any grammatical
errors

12. Equipment/software list with Specification for a batch of 30students

Sl.No. Particulars Specification Quantity
01 Computers Intel i5, 4 GB RAM, 1 TB SDD 30
02 Internet Connectivity
03 Arduino board Basic 10
04 LED 20
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION

Program Computer Science and Engineering Semester 1

Course Name Basics of Digital Logic and Computer Type of Course Integrated
Organization
8 Hours per week
Course Code 25CS11I Contact Hours
Teaching Scheme 4:0:4 Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale
This course is designed to provide a comprehensive foundation for understanding how computers
operate at their core. By studying fundamental digital circuits, students acquire a clear understanding of
how data is represented, manipulated, and stored, alongside the mechanisms through which logical
operations are performed to solve computational problems. Furthermore, key concepts in computer
organization empower students to explore the architecture, functionality, and collaboration of essential
hardware components that enable the seamless execution of instructions.

2. Course Outcomes: At the end of the Course, the student will be able to

Analyze and comprehend the data representation in digital systems.

CO-01
Design a digital circuit using suitable gates for the given scenario
CO-02
Simulate and examine the functionalities of combinational and sequential circuits using
CO - 03 appropriate software tools.

Explain the basic architecture and functioning of a computer

CO - 04
Explain the interaction of hardware components in execution of an instruction.
CO-05
3. Course Content
Week CO PO Lecture(4HRS) Practice(4HRS)
(Knowledge Criteria) (Performance Criteria)
Data representation Organize and play games like:
Numerical – Binary, octal and Conversion Bingo game
hexadecimal Number Conversion Relay
BCD, ASCII, Unicode Base Conversion Escape Room
Conversions between number systems. Binary to ASCII Decoder Game
1 1 1
Binary Jigsaw Puzzle
Binary Game (cisco.com)
Binary Bonanza! Binary Number game - Fun,
Free, Online Way to Learn Binary
(penjee.com)
Negative Numbers and Binary Learn Binary Arithmetic - Binary Tutorial
arithmetic (ryanstutorials.net)
Signed magnitude, 1’s complement, Treasure hunt game
2 1 1,2 and 2’s complement representation.
Floating point representation
Arithmetic operations in binary
(addition, subtraction)
Logic gates Every Circuit or similar simulator can be used
Overview of digital logic design and its Explore a simulator interface
applications in computer science and Examine the functionality of each gate using
engineering. simulator
3 2 1,2,3 Design simple circuits using logic gates.
Logic gates-Definition, symbol and
Visualize gate operations using LED-based kits
truth table and their applications– NOT,
or online simulators.
OR, AND, NOR, NAND, XOR, XNOR
https://www.youtube.com/watch?v=HjneAhC
y2N4
Boolean Algebra and Simplification Every Circuit or similar simulators
Laws, Rules and theorem Test and analyze the Boolean laws and rules
4 2 1,2,3
Boolean expressions – SOP, POS

Circuit design using Boolean expression Utilize simulators to create and test digital
Derive Boolean expression from truth circuits based on Boolean expressions. Analyze
5 2 1,2,3
table how the simplifying expression impacts circuit
performance and complexity.
Combinational Logic Circuits Virtual Labs (vlabs.ac.in)
 Arithmetic Circuits: half adder, full simulator.io | Anonymous board
adder Half-Subtractor and Full- Examine the working of
Subtractor.  Half-Adder and Full-Adder circuits.
6 3 1,2
 Multiplexers and Demultiplexers.
 Data Processing Circuits: Multiplexer,
Demultiplexer, Encoder and Decoder  Comparator
 Comparator Circuits:
Single-bit and multi-bit comparators.
Sequential Logic Circuits simulator.io | Anonymous board
7 3 1,2 Flip-Flops – definition, types, 1. Examine the functionality of different flip flops
applications
  Registers- definition and shift register Simulation of
types 1. Flip-Flop-based counters and shift registers.
 Counters: Asynchronous (Ripple) and 2. Simulate flip-flops and counters using
Synchronous Counters. software like Tinkercad or Logisim.
 Compare combinational and sequential
circuits

Computer Organization The central processing unit (CPU): Its

Definition- computer architecture and components and functionality | Enable
computer organization. Sysadmin (redhat.com)
Von Neumann Architecture Central CPU-OS simulator
8 4 1,2 Processing Unit (CPU) – components Get familiar with environment of CPU with
and performance metrics. simulator
https://www.youtube.com/watch?v=d86ws7
mQYIg
https://www.youtube.com/watch?v=h9Z4oGN
89MU
Instruction Set Architecture Demonstrate how the CPU handles interrupts
 (ISA) – definition and role (both hardware and software) and returns to
9 4 1 Instruction types normal execution.
 Addressing modes https://www.youtube.com/watch?v=PVNAP
 Interrupts - types, handling mechanism WUxZ0g
Specialized Processors https://www.youtube.com/watch?v=h9Z4oG
 Emergence of specialized processors N89MU
10 4 1 for specific tasks (GPU, TPU, NPU).
 Components of a GPU - Compute Units, Compare CPU, GPU, TPU and NPU
Cores and
 Functionalities of GPU
Memory and its Hierarchy https://www.youtube.com/watch?v=h9Z4oG
 Units of memory N89MU
 Types - Primary Memory, https://www.youtube.com/watch?v=5Mh3o
11 5 1 Secondary Memory and Tertiary 886qpg
Memory
 Memory Hierarchy
 Applications of Memory Types
Input/output (I/O)  Locate and identify common I/O ports on a
Input devices computer
12 5 1 Output devices  Identify I/O devices connected to a computer
I/O Ports – Definition, common ports ,
standards and protocols
System Buses and Communication Identify the system buses in the computer
System bus and types of buses
13 5 1 Bus Architecture: - parallel and serial
Bus protocols and standards: PCI, USB,
SATA.

4. Learning Resources:

5. CIE Assessment Methodologies

 Test Duration Max
Sl.No CIE Assessment (minutes)
Week marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
3 CIE-3TheoryTest 10 90 50 Average of all
4. CIE-4Practice Test 13 180 50 CIE=50 Marks
CIE-5 Portfolio evaluation
of all the activities through
5 1-13 50
Rubrics
Total 50 Marks

6. SEE - Theory Assessment Methodologies

SEE – Theory Assessment Duration Min marks to

Sl.No Max marks
(minutes) pass
1. Semester End Examination-Theory 90 50 20

7. CIE Theory Test model question paper

Program Computer Science & Engineering Semester - I
Course
Name Basics of Digital Logic and Computer Organization Test I/ III
Course Code 25CS11I Duration 90 min Marks 50
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.

Q.No Questions CL CO MARKS

Section - 1
a) Group the following numbers into their respective number
systems (Decimal, Binary, Hexadecimal). If a number can belong to
multiple systems, treat it as decimal by default. Explain your
reasoning for each classification: 62, 1FA,0101011,75 – (10M)
b) Represent the decimal number -34 in binary using the following
methods (sign-magnitude, 1's complement, and 2's complement)
for an 8-bit representation. – (6M) 2 1
1
c) Perform binary addition on the following two 8-bit
numbers:10110011 and 11001101 –(4M)
25
d) A digital clock uses Binary-Coded Decimal (BCD) to display
numbers on a seven-segment display. Explain why BCD is used
instead of pure binary and show how the number 25 is represented
in BCD format. –( 5M)
a) Convert the decimal number 87 into its equivalents in binary,
octal, and hexadecimal number systems. Explain the steps you took
2 for each conversion. – (10M) 2 1
b) A temperature sensor gives readings in an 8-bit two’s
 complement format, where positive numbers represent
temperatures above zero and negative numbers represent
temperatures below zero. If the sensor reads 11100100, convert
this reading to decimal to find the temperature. (6M)
c) Convert each character of the word “HELLO” to its ASCII binary
representation. (5M)
d) Perform the subtraction 100101 - 1011 using two’s complement
binary arithmetic.(4M)
Section – 2
a) Which gates would you use to design a circuit for these scenario,
justify your selection (12M)

b) Construct the truth table for a 3-input AND gate, where the
inputs are A, B, and C, and the output X is defined as: (5M)
3 X=A⋅B⋅C
c) You are part of a team solving a digital treasure hunt. To unlock
the treasure chest, you need to figure out the secret combination
using a circuit made entirely of NAND gates. Follow the clues,
determine the outputs, and uncover the secret combination.

Clue 1 : Single NAND Gate -You find a locked door controlled by a

single NAND gate. The inputs A and B are both connected to
switches. The door opens only if the output X=1.
What are the possible combinations of A and B to open the door?
25
(8M)

a) Identify the following gates and construct truth table for each
(12M)

b) A circuit consists of two inputs, A and B. The output is high only

when both A and B are either high or low. Which logic gate is used
4 in this circuit, and why? –(5M)
c) You’ve been given a mysterious circuit that encodes or decodes a
secret binary message using XOR gates. Your task is to figure out
the input, the circuit logic, and the hidden message.
i. If The binary message M=11001and the secret key K=10101 what is
the encoded message X
ii. To decode the message, the encoded message X is passed through
the same XOR gate with the original key K=10101. what is the
decoded message M. - (8M)
 Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Sign of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program 1
Computer Science & Engineering Semester
Course Name Basics of Digital Logic and Computer Organization Test I/ III
Course Code 25CS11I Duration 90 min Marks 50
Name of the Course Coordinator:
Questions CO Marks
1. A security system outputs F if:
Door 1 is locked (A) OR Door 2 is locked (B), AND Alarm is OFF (C).
Write the Boolean expression, simplify it, construct truth table and verify
it using simulator.
2. Design a 2-bit magnitude comparator that compares two 2-bit binary numbers, A
and B, and generates the following outputs:
a) A>B: Output is 1 if A is greater than B.
b) A=B: Output is 1 if A is equal to B. 2,3 50
c) A<B: Output is 1 if A is less than B.
Tasks:
a) Construct the truth table for the 2-bit magnitude comparator, considering all
possible values of A and B.
b) Derive the logic expressions for each output (A>B, A=B, A<B).
c) Implement the circuit using basic logic gates (AND, OR, NOT, XOR, etc.).
d) Validate the circuit by simulating it with a tool.
Scheme of assessment
a) Understanding and Problem Analysis - 10
b) Truth Table and Logic Expressions - 15
c) Circuit Design and Implementation - 15
d) Presentation and Documentation – 10
Total Marks 50

Signature of the Course Coordinator Signature of the HOD

9. SEE–Model Theory Question Paper

Program Computer Science & engineering Sem 1
Course Name Basics of Digital and computer organization Marks 50
Duratio 90
Course Code 25CS11I
n Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cogniti Course
Q Questions Mark
ve Outco
N s
Levels mes
o
 Section -1
a) Perform the following conversions:
a) Convert 10111010(2) to its hexadecimal equivalent.
b) Convert 7F3(16) to its decimal equivalent.
c) Convert 89(10) to its BCD representation. 2 1 10
1
b) Explain the concept of character data representation with examples.
c) Perform the subtraction 100101(2) −1011(2) using two's complement
binary arithmetic. Show all intermediate steps.
a) Explain the characteristics of the following number systems with
examples:
Binary (Base-2) , Decimal (Base-10)
Octal (Base-8), Hexadecimal (Base-16)
b) Add the following two 8-bit binary numbers and provide the final 2 1 10
2
result:
a) 10110011(2)
b) 11001101(2)
c) Convert the decimal number −47 into an 8-bit two's complement
binary representation. Show all steps involved in the conversion.
Section -2
a) A home security system has three sensors: one on the door (D),
one on the window (W), and one on the motion detector (M). The
alarm (A) should go off if:
Either the door or the window sensor is triggered, OR The motion 3 2 10
3
detector is triggered while the door is closed.
Write the Boolean expression for this alarm system, simplify it if
possible, and draw the logic circuit.
a) A fan is controlled by temperature sensors (T) and humidity sensors
(H). The fan turns on if:
The temperature is high (T), OR Both the temperature and humidity
4 are at moderate levels. 3 2 10

Formulate the Boolean expression to represent the fan control

system. Simplify it if possible and draw the circuit using logic gates.
Section -3
a) Classify different types of combinational circuits and provide
examples for each category.
5 Construct truth tables for a half-adder circuit, showing all possible 2 3 10
b)
input combinations and their corresponding outputs (sum and carry).
a) Construct truth tables for D and JK flip-flops, clearly indicating the
input-output relationships. Interpret the behavior of these flip-flops
based on their truth tables. 2 3 10
6
b) Compare combinational circuits and sequential circuits, highlighting
their key differences in functionality, design, and applications.
Section -4
 a) Explain the operational mechanics of the Von Neumann
architecture, including the fetch-decode-execute cycle.
7 b) Explain the concept of addressing modes and categorize the 2 4 10

common types with examples.

a) Categorize the common types of addressing modes and provide
examples for each. 2 4 10
8
b) Describe the key components of a Graphics Processing Unit (GPU).

Section -5
a) Explain the functions of each bus type in the data transfer process
within a computer system.
b) Classify the various types of input and output devices used in
9 computing systems 2 5 10
c) A user needs to store a video library of 500 HD movies, where each
movie is 5 GB. How much storage space is required in terms of
terabytes?
a) Provide examples for each type of memory and describe their
specific functions and applications within the system.
10 b) Explain the role of the system bus in computer communication, 2 5 10

including how it connects different components

11. Rubrics for Assessment of Activity (Qualitative Assessment)

Sl. Dimension Excellent Good Satisfactory Needs Improvement Score

No. (4 or below)
9-10 7-8 5-6 <=4
Demonstrates thorough Shows good Demonstrates basic Lacks understanding of 8
Understanding of understanding of understanding of understanding but concepts or is unable
1
Concepts underlying concepts and concepts with minor struggles with deeper to explain them
explains them confidently. gaps. applications. clearly.
Writes efficient, well- Writes functional Writes basic code with Writes poor or non- 6
Implementation structured, and and mostly clean some inefficiencies functional code with
2
Skills commented code with code with minor and lack of comments little to no structure or
appropriate logic. inefficiencies. or structure. comments.
Participates well, Does not participate in 7
Actively collaborates, Participates minimally
Teamwork/Collabo shares ideas, and teamwork or creates
3 contributes ideas, and and may not engage
ration collaborates with disruptions within the
supports peers effectively. fully with peers.
minor lapses. team.
Presents results with Struggles to explain Fails to present results 9
Explains the results and
Presentation of minor inaccuracies results clearly or clearly or shows lack
4 process clearly with
Results or gaps in makes incorrect of understanding of
accurate conclusions.
explanation. conclusions. the process.
Completes the task well Completes the task Completes the task Fails to complete the 10
within the allotted time on time with minor with significant delay task within the
5 Adherence to Time
with no compromise on compromises in or compromises in allotted time or quality
quality. quality. quality. is highly compromised.
TOTAL 40

Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

12. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quantity
01 Computers 15
02 Internet Connection 100mpbs
SEMESTER 2
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Engineering Semester 2
Thinking Programming with
Course Name Type of Course Integrated
Python
Course Code 25CS21I Contact Hours 8 Hours per week
Teaching Scheme 4:0:4 Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale:
The course aims to combine foundational problem-solving skills with practical programming experience in
Python. This integrated approach enables learners to develop a logical mindset while gaining hands-on
coding experience in one of the world’s most versatile and beginner-friendly programming languages. The
course goes beyond teaching programming syntax. It’s an essential step toward developing logical,
computational, and technical proficiency for success in the digital age.

2. Course Outcomes: At the end of the Course, the student will be able to:
Apply computational thinking to solve the given problem and illustrate the solution as an
CO-01
algorithm
Develop a programmer's mindset through the application of fundamental programming
CO-02
concepts.
CO-03 Code and execute a program to solve the given problem using python concepts

CO-04 Identify and resolve both syntactical and semantic errors.

CO- 05 Apply modular programming approach to optimize the program.

3. Course Content
Week CO PO Lecture(4HRS) Practice(4HRS)
(Knowledge Criteria) (Performance Criteria)
Computational Thinking Organize Games and Activities to instill
Introduction, Components, Importance and Computational Thinking
Applications of CT in various fields.
1 1 1,2 Decomposition: Consider a problem
statement to learn decomposition (refer
table 1 for examples) –
Pattern recognition: Analogy; Classification;
Sequencing; Ranking; Series
Algorithmic thinking For a given problem
Problem Types for Algorithmic Solutions [  Identify the key components
definition and examples] (input, output and logic) of an
 Searching Problems algorithm
 Sorting Problems  Develop a step-by-step algorithm
 Optimization Problems to solve it.
 Graph Problems
 String Processing Problems
2 1 1,2  Numerical Problems
 Combinatorial Problems
 Cryptographic Problems
Algorithm Representation: Natural
Language, Pseudocode, Flowchart
[ Note: Sorting Algorithms: designed to
arrange data in a specific order
Examples: Bubble Sort, Merge Sort, Quick
Sort]
Introduction to Programming Organize Games and Activities to instill
What is programming? ; Why we need Programmer Thinking
Programming; How to Think like a
3 2 1 programmer;
Programming Paradigms;
Programming Languages and their
Paradigms
Basic Programming Concepts: Syntax ; Setup and get familiar with Your
Tokens and types; Variable -Rules for Development Environment such as
4 2 1 creating variables; constants; datatypes; VsCode
errors ; comments ; Best programming
practices;
Introduction to python programming:
Features and applications ; Data types Practice Programs to understand
5 2 1
(primitive); Assignment statement; Type datatype, and their conversion.
conversion;
Input and output statements: Practice Programs to understand
input (); print (); reading input and formatting output
6 3,4 1
Formatting output - string concatenation,
format() and f-strings
Operators and their Precedence Practice Programs to understand
7 3,4 1
Expressions Operators and Expressions
8 3,4 2,3 Flow control Practice programs to understand the
 Conditional statements: if, if-else, if-elif, concept of conditional statements
match case
Iterative statement – for loop: structure of Practice programs to understand the
the for loop using range();concept of break concept of for loop
9 3,4 2,3 and continue with the for loop;

Iterative statement - While loop : structure; Practice programs to understand the

10 3,4 2,3 concept of Break, continue, pass concept of while loop
statements with while loop;
Nested loops : Use cases of nested loops; Practice programs to understand the
11 3,4 2,3 control flow in nested loops using break, concept of nested loops
continue, and else;
Functions : Need for functions ; create Practice programs to understand the
function ; function call: with and without concept of functions
12 3,4,5 2,3
arguments; return statements; Variable
scope
Modules & Packages : Significance of Practice programs to understand the
modules and packages; Import and use concept of modules and packages
built-in modules; Create new module;
13 3,4,5 2,3
Create a package with multiple modules;
import statement ( import, import…as ..,
from….import, import *)

4. Learning Resources:
week Suggested program/ activity list
1 Case based learning:
 Improving the Transport System in the Countryside
 Analyzing the Reach of Government Schemes
 Smart Irrigation System for Optimal Water Usage
 Impact of Social Media on Students
2 Problem / use case based learning
Devise an Algorithm and draw flowchart for problems such as
 Swapping two values
 Finding largest / smallest among two/three number
 Computing area/ perimeter of given shape (circle, triangle, rectangle, square)
 Metric conversion (meter – KM, pound – kilo gram, Celsius – Fahrenheit)
 Determine given number is even or odd, positive or negative.
3 Think Like a Programmer - Google Books
Think Like a Programmer: Introduction (youtube.com)
General problem solving techniques- refer the book or youtube videos
https://www.codecademy.com/resources/blog/how-to-think-like-a-programmer/
4 Prepare Your Development Environment:
1. Download and install the necessary compiler or interpreter
 Python: Download from python.org.
 Java: Install the Java Development Kit (JDK) from Oracle or OpenJDK.
2. Verify the installation by checking the version using the terminal/command prompt
3. Install an IDE ( for python VSCode or Pycharm)
 Open your IDE and explore its features:
 Create a new project.
  Write a simple "Hello, World!" program.
 Learn to run and debug your code.
 Explore useful features like syntax highlighting, auto-completion, and integrated
terminal.
5 Create variables, assign values, and display their data types:
a. Create variables of different data types and assign values
b. Display the values and their respective data types using the type() function.
Assignment Statements:
a. Single variable assignment: Assign a value to a single variable.
b. Multiple variable assignment: Assign values to multiple variables in one statement.
c. Assign the same value to multiple variables.
Type Conversion
a. Demonstrate Python's ability to convert types automatically during operations.
b. Use functions like int(), float(), str(), or bool() to explicitly convert data types.
6 1. Write a program that:
a. Accepts user input for name and age.
b. Prints a formatted message using different string formatting methods.
2. Read message from the user and Format it with different methods and display.
3. Demonstrate swapping the values(numerical) of two variables using a temporary
variable.

7 1. Write python equivalent expressions for math expressions such as

a. f = ax +b
b. f = a2 + b2 + 2ab.
c. f = a3 + b3 + 3ab(a + b)
d. area = πr2

e.

f.
2. Translate textual problem statements into Python expressions
3. Write a program that:
a. Accepts two numbers from the user.
b. Converts them to integers (if they are not already).
c. Performs arithmetic operations (add, subtract, multiply, divide) and displays the results
with the data types and appropriate message.
4. Calculate the total cost of an item after applying a 15% discount to its original price of
Rs150.
5. Calculate the compound interest on a principal of Rs10000 at an annual interest rate of 5%
for 3 years, compounded annually.
6. Compute area of triangle, rectangle.
7. Swapping values of two variables without using a temporary variable
8 1. Create a program to manage airline ticket bookings based on the passenger's selected
class: "economy", "business", or "first".
a. Prompt the user to input details such as name, age, destination, and class preference
(economy, business, or first).
b. Validate inputs (e.g., ensure the name contains only letters, age is a positive integer, and
class selection is valid).
c. Display appropriate error messages for invalid entries and allow the user to re-enter the
 data.
2. Build a system to suggest clothing based on the temperature.
a. If temperature ≥30°C, suggest "Wear light clothes."
b. If 20°C ≤ temperature < 30°C, suggest "Wear moderate clothing."
c. If temperature < 20°C, suggest "Wear warm clothes."

3. Implement a discount system for an e-commerce website.

a. If the total purchase is ≥Rs5000, apply a 20% discount.
b. If Rs2000 ≤ total < Rs5000, apply a 10% discount.
c. If total < Rs2000, no discount is applied.

4. Create a program that simulates an ATM machine to check:

a. If the entered PIN is correct, allow the user to proceed.
b. Validate that the withdrawal amount doesn’t exceed the account balance.
c. Ensure that the withdrawal amount is in multiples of a specific denomination (e.g.,
Rs100).
9 1. Generate numbers from 1 to 10 using range().
2. Generate numbers for a given range.
3. Write a program to display square numbers from 1 to 10.
4. Write a Python program that accepts an integer input from the user and determines
whether the number is a prime number or not. If the number is prime, display an appropriate
message; otherwise, indicate that it is not prime.
5. Write a Python program that accepts a message and a number from the user. The
program should then print the specified message the given number of times.
6. Write a Python program to calculate the factorial of a given number. The program
should:
a. Accept a non-negative integer as input.
b. Use an iterative approach to compute the factorial.
c. Handle invalid inputs (e.g., negative numbers or non-numeric inputs) by displaying
appropriate error messages.
7. Evaluation of mathematical series like
S=1+2+3+………+n
S=12+22+32+…….+n2
Hn=1+1/2+1/3+…….+1/n
10 1. Implement the Euclidean algorithm to find the GCD of two integers using a while loop.
2. Collect daily weather data (e.g., temperature, humidity) from the user. Allow data entry
to continue until the user decides to stop or inputs a sentinel value.
3. Simulate a loan repayment system where a borrower pays a fixed amount each month.
Continue reducing the loan balance until it is fully paid off, and display the balance after each
payment.
4. Write a program that simulates a countdown timer. Start with a given number of
seconds and decrement until it reaches zero, displaying the countdown at each step.
5. Write a program that takes an integer and calculates the sum of its digits using a while
loop.
6. Write a program that simulates a simple user authentication system. The program
should:
a. Repeatedly ask the user to input their username and password.
b. Verify the entered credentials against a pre-defined username and password.
c. Allow the user up to three attempts to enter the correct credentials.
d. Provide appropriate feedback for each attempt (e.g., "Incorrect username or password").
e. If the correct credentials are provided within three attempts, display a success message
 and terminate the program.
f. If all three attempts are exhausted, display a failure message and terminate the
program.
11 1. Write a program to identify all prime numbers within a user-defined range. The program
should:
a) List all the prime numbers within the range.
b) Calculate and display the total count of prime numbers found.
c) Compute and display the sum of these prime numbers.

2. Write a Python program to perform the following tasks for a user-defined range of
integers:
a) Identify and list all non-prime numbers within the given range.
b) Categorize the non-prime numbers into even and odd.
c) Count the total number of even and odd non-prime numbers.
d) Calculate and display the sum of even and odd non-prime numbers separately.

3. Write a Python program to perform the following tasks for a user-defined range of
integers:
a) Identify and list all palindrome numbers within the specified range.
b) Count the total number of palindrome numbers found.
c) Display the results in a user-friendly format.

4. Write a program to generate and display a multiplication table for numbers 1 to 10.
5. Generate star or number patterns like a pyramid or diamond shape.
12 1. Write simple functions for arithmetic calculations (e.g., addition, factorial).
2. Define a function assign_priority() for ticketing system which assigns priorities to support
tickets based on the issue type (low, medium, high and returns a priority level.
3. Define function calculate_interest() for banking system, to calculate the interest on
savings accounts based on the principal amount, rate, and time period.
4. An online store offers a discount based on the total purchase amount. If the customer’s
total purchase exceeds a certain threshold, they get a percentage discount. Define a function
apply_discount() that accepts the total amount and returns the final price after discount.
13 1. Create a module that includes a function to calculate the area of a circle and use it in
another script.
2. Create a package for a small project, such as a calculator application with modules for
arithmetic, trigonometric, and logarithmic operations.

5. CIE Assessment Methodologies

Sl.No Duration Max
Test
CIE Assessment Week (minutes) marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
Average of all CIE=50
3 CIE-3TheoryTest 10 90 50 Marks
4. CIE-4Practice Test 13 180 50
CIE-5 Portfolio evaluation of
5 all the activities through 1-13 50
Rubrics
 Total 50 Marks

6. SEE - Theory Assessment Methodologies

Duration
Sl.N Max
SEE – Theory Assessment (minutes) Min marks to
o marks
pass

1. Semester End Examination-Theory 90 50 20

7. CIE Theory Test model question paper

Program Computer Science & Engineering Semester – 2

Course Thinking Programming with Python Test I/III
Name
Course 25CS21I Duration 90 min Marks 50
Code
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q.No Questions Marks
Level Outcome

Section – 1
a. You are tasked with organizing a class party. The goal is to
ensure everything is well-prepared, including food, decorations,
activities, and invitations. Use decomposition to break down this
problem into smaller, manageable tasks. – (10 M)
b. Identify the pattern and provide an explanation to complete
the series. (10M) 2,3 1
1
1. 3, 6, 11, 18, 27,____,____,_____,_____
2. 1, 1, 2, 3, 5, 8, ___,____,_____,_____
3. 2, 4, 12, 48, ___,____,_____,____
4. A2, B4, C8, D16, ___,____,_____,____
c. Explain the four pillars of computational thinking. – (5M)
a. You are tasked with organizing a birthday party for your best
25
friend. The goal is to ensure the party runs smoothly. To accomplish
this, break the task into smaller, manageable steps and write down
the plan. – (10M)
b. A magical machine only accepts even numbers and rejects
odd ones. If you input an even number, the machine lights up green;
2 if you input an odd number, it lights up red. Write an algorithm and 2,3 1

draw flowchart to help a wizard decide whether a number can be

accepted by the machine or not.- (7M)
c. Identify different types of problems and provide an example
algorithm to solve each. - (8M)
 Section – 2
a. Explain the concept of a variable. Why are variables essential
in programming?
b. Define tokens. List and explain the different types of tokens
with examples.
3 c. List the rules for naming variables in Python. Provide 2 2
examples of valid and invalid variable names.
d. Why are constants important in programming? Illustrate with
an example where a constant would be beneficial.
e. What are syntax errors, logical errors, and runtime errors?
1. How can learning programming enhance one's logical
25
thinking, creativity, and problem-solving abilities?
2. Explain the concept of "thinking like a programmer" and its
importance in solving real-world problems.
3. Explain how identifying patterns in problems can lead to
4 efficient solutions. Use an example to demonstrate this process. 2 2
4. Trace the evolution of programming paradigms through the
generations of programming languages.
5. A team is building a web application with a real-time chat
feature. Discuss which programming paradigms and languages might
be best suited for this task and why.
Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program Computer Science & Engineering Semester 2

Course Name Thinking Programming with Python Test II/IV

Course Code 25CS21I Duration 180 min Marks 50

Name of the Course Coordinator:

Questions CO Marks

a. Write a program that performs the following tasks: 50

a. Generate Random Numbers:
Generate a random number within a given range [a, b], where a and b are user inputs.
b. Determine non-prime Number:
Determine that generated random number is not prime.
c. Classify non-prime Number:
Further classify numbers into: Even / Odd
Instructions:
 Clearly identify and describe the key concepts needed to develop the program.
 Structure the program into separate, reusable modules or functions.
Scheme of assessment
a) Program Design and Conceptual Clarity (Clear identification of the key concepts, Explanation of
the logic and methodology used and organization of the program.) - 10
b) Implementation and Execution - 30
c) Best Practices (Code Readability and Error Handling )- 10

Total Marks 50

Signature of the Course Coordinator Signature of the HOD

9. SEE–Model Theory Question Paper

Program Computer Science and Engineering Semester 2
Course Name Thinking Programming with Python Marks 50
Course Code 25CS21I Duration 90 Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q No Questions Marks
Levels Outcomes

Section -1

a. Your College is hosting a science fair, and you are

responsible for planning and organizing the event. The
goal is to ensure the fair runs smoothly, including setting
2 1
1 up booths, scheduling presentations, managing
participants, and inviting visitors. Use decomposition to
divide the problem into smaller tasks.
a. Five students—Alice, Bob, Charlie, Diana, and
Ethan—participated in a coding competition. Based on
their scores, the following information is known:
1. Bob scored higher than Diana but lower than
Charlie.
2 2. Alice scored lower than Ethan but higher than 2 1
Diana.
3. Ethan did not score the highest.
4. Charlie scored the highest.
What is the ranking of the students from highest to
lowest?
Section -2

b. Develop a step-by-step algorithm to check

whether a given number is a palindrome. A number is
considered a palindrome if it remains the same when its
digits are reversed. For example:
3 Input: 1221 → Output: Palindrome 2 2
Input: 123 → Output: Not a Palindrome
Your algorithm should clearly handle positive integers
and explain each step, from receiving input to displaying
the result.
a. Design an algorithm to determine the
correctness of a One-Time Password (OTP) entered by a
4 user. 2 2
The algorithm should:
 Prompt the user to input an OTP.
  Compare the entered OTP with the pre-stored or
system-generated OTP.
 Validate whether the OTP matches the expected
value.
 Provide appropriate feedback for a correct or
incorrect OTP.
 Allow the user up to three attempts to enter the
correct OTP. If the attempts exceed three, lock the
process and notify the user.
Write the algorithm step-by-step to include all these
conditions clearly.
Section -3

a. Write a program that simulates a simple user

authentication system. The program should:
1. Ask the user to input their username and
password.
2. Verify the entered credentials against a pre-
defined username and password.
3. Allow the user up to three attempts to enter the
5 correct credentials. 2 3
4. Provide appropriate feedback for each attempt
(e.g., "Incorrect username or password").
5. If the correct credentials are provided within
three attempts, display a success message and
terminate the program.
6. If all three attempts are exhausted, display a
failure message and terminate the program.
a. Write a Python program to calculate the factorial
of a given number. The program should:
1. Accept a non-negative integer as input.
2. Use the formula n!=n×(n−1)×(n−2)×⋯×1
6 2 3
3. Handle invalid inputs (e.g., negative numbers or
non-numeric inputs) by displaying appropriate error
messages.

Section -4
For the below code snippet, identify and fix issues if
found.

7 3 4

a. Below is a code snippet written to determine

whether a number is prime or not. Will the given code
8 3 4
correctly identify whether a number is prime? If not,
explain why and suggest how to fix the issue
 Section -5

An online store offers a discount based on the total

purchase amount. If the customer’s total purchase
exceeds a certain threshold, they get a percentage
9 3 5
discount. Define a function apply_discount() that
accepts the total amount and returns the final price
after discount.
Refactor the following code using a modular approach
by breaking it into functions or reusable components.

10 3 5

10. Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Excellent (10) Good (8) Satisfactory (6) Needs Improvement (4 Score
No. or below)
9-10 7-8 5-6 <=4
Demonstrates thorough Shows good Demonstrates basic 8
Lacks understanding of
Understanding of understanding of underlying understanding of understanding but
1 concepts or is unable to
Concepts concepts and explains them concepts with minor struggles with deeper
explain them clearly.
confidently. gaps. applications.
Writes basic code with Writes poor or non- 6
Writes efficient, well- Writes functional and
Implementation some inefficiencies and functional code with
2 structured, and commented mostly clean code with
Skills lack of comments or little to no structure or
code with appropriate logic. minor inefficiencies.
structure. comments.
Participates well, Does not participate in 7
Actively collaborates, Participates minimally
Teamwork/Collabora shares ideas, and teamwork or creates
3 contributes ideas, and and may not engage
tion collaborates with disruptions within the
supports peers effectively. fully with peers.
minor lapses. team.
Fails to present results 9
Explains the results and Presents results with Struggles to explain
Presentation of clearly or shows lack of
4 process clearly with minor inaccuracies or results clearly or makes
Results understanding of the
accurate conclusions. gaps in explanation. incorrect conclusions.
process.
Completes the task on Fails to complete the 10
Completes the task well Completes the task with
time with minor task within the allotted
5 Adherence to Time within the allotted time with significant delay or
compromises in time or quality is highly
no compromise on quality. compromises in quality.
quality. compromised.
TOTAL 40
Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

11. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quantity
01 Computer i3 or i5 30
SEMESTER 3
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Semester 3
Engineering
Course Name Database Concepts & Type of Course Integrated
Technologies
8 per week
Course Code 25CS31I Contact Hours
Teaching Scheme 4:0:4 Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale:
This course is designed to equip students with a comprehensive understanding of modern database
systems by integrating essential theoretical concepts with practical skills. The course focuses on
enabling students to conceptualize, design, and implement both relational and NoSQL databases, with
an emphasis on performing basic CRUD (Create, Read, Update, Delete) operations.

2. Course Outcomes: At the end of the Course, the student will be able to:

Identify the elements of ER model for a given requirement, draw ER diagram and validate with
CO-01
the given requirement.
Translate the ER diagram into a relational schema and verify its compliance with integrity
CO-02
constraints and normalize the design up to the third normal form (3NF)
CO-03 Create database objects and perform data manipulation operations using suitable tool.

CO-04 Query the database to retrieve the required information using suitable SQL statements.

CO- 05 Design and implement a NoSQL database, and perform fundamental CRUD operations.

3. Course Content
Lecture(4HRS) Practice(4HRS)
Week CO PO
(Knowledge Criteria) (Performance Criteria)
Introduction to Database Systems  Setting up database environments
(MySQL/PostgreSQL and MongoDB
 Overview of databases and their Atlas)
significance  Explore the interface (MySQL
 Types of database systems (RDBMS, Workbench/ PostgreSQL PgAdmin
NoSQL, Distributed, and Cloud and local or cloud MongoDB)
1 1 1 Databases.)
 Advantages of database systems over
file systems
 Overview of Database Management
Systems (definition, key features and
examples)

2 1 1 Database Models and Architecture a. Consider a database scenario and

 identify the levels of abstraction
a. Database models: ER, Relational, and (external, conceptual, and internal).
NoSQL b. Analyze a case study where a
b. Three-tier architecture and DBMS database underwent schema
components evolution (e.g., adding/removing
c. Data Independence: Logical and tables or columns). Identify how
Physical logical independence was maintained.
c. Study a database migration example
where physical storage was optimized
(e.g., moving to SSDs or cloud-based
storage) without affecting application
functionality.
d. Set up database connections
(MySQL/PostgreSQL/MongoDB) in
Python using appropriate modules.
ER Modeling a. Identify the ER elements for the given
 Introduction to Entity-Relationship requirements.
(ER) model b. Drawing ER diagrams for simple use
 Entities, attributes, relationships, and cases
Constraints. c. Design an ER diagram for a library or
e-commerce system.
d. Design a comprehensive ER diagram
for a healthcare management system,
3 1 1
including cardinalities and
participation constraints for entities
like "Doctor," "Patient,"
"Appointment," and "Medicine."
e. Use database modeling tools like
MySQL Workbench/ PostgreSQL
PgAdmin to create ER diagrams and
validate them against requirements.
Relational Model and Integrity a. Convert ER model to Relational model
Constraints b. Translate any given ER diagram into
 Introduction to Relational Model Relational schema
4 2  Integrity Constraints c. Use MySQL Workbench or PgAdmin
 Steps for Converting ER Diagrams into to create database objects and apply
Relational Schema integrity constraints through the GUI,
without writing SQL statements
Structured Query Language (SQL) – Create database, tables and enforce data
Basics integrity constraints using DDL
 Introduction to SQL; commands.
 Categories of SQL Commands with Perform basic CRUD operations through
5 3
definition and syntax programming language such as PYTHON.
 Data types in SQL 
 Update anomalies

Functional Dependency(FD)  Identify Functional Dependencies in a

 Definition and examples. Table
 Types of functional dependencies  Consider relations and apply
6 2
 Role of FD in normalization. normalization rules to bring them to
Normalization 1NF, 2NF, and 3NF.
 Purpose and benefits of
 normalization.
 Normal forms: 1NF, 2NF, 3NF
Querying Databases  Write SQL queries to filter, sort, and
 SQL Clauses: Where, Distinct, Order limit data using clauses.
By, Limit;  Use operators to refine queries and
7 4  SQL Operators: Logical Operators, match complex conditions.
Comparison Operators  Apply aggregate functions to
 Aggregate functions summarize data and perform
calculations.
Advanced Database Querying  Perform different types of joins to
 Joins: INNER, OUTER, CROSS combine data from multiple tables.
 GROUP BY and HAVING clauses  Group data and filter the results using
 Subqueries: Single-row subqueries; GROUP BY and HAVING clauses.
8 4
Multi-row subqueries; Scalar  Write and optimize subqueries for
subqueries; Correlated subqueries; filtering and data retrieval.
 Views  Create and use views to simplify
complex queries and manage data.
Transactions and Concurrency  Create, manage, and roll back
Introduction to Transactions transactions
Concurrency Control:  Understand and apply locking
 Need for Concurrency Control; mechanisms to control concurrent
9 3
 Concurrency Issues; access to data.
 Concurrency Control Techniques;  Execute DCL commands to provide
TCL commands privileges to different users
DCL commands
Introduction to NoSQL Databases MongoDB Shell Basic commands : show
 Overview; Key Features; Types; dbs, use <dbname>, show collections
Advantages and Disadvantages;
10 5  CAP theorem
 Comparison between RDBMS and
NoSQL
 Overview of MongoDB
MongoDB Data Model and CRUD  Create MongoDB for E-Commerce
Operations Website.
MongoDB Data Model: Collections and  Perform CRUD operations
Documents; Data types
11 5 CRUD Operations
 Create: insertOne(), insertMany()
 Read: find(), findOne()
 Update: updateOne(), updateMany()
 Delete: deleteOne(), deleteMany()
Aggregation in MongoDB Write the aggregation pipeline
 Aggregation Pipeline
12 5
 Stages in the Aggregation Pipeline
 Expression Operators
Database Design and Implementation Designing and implementing a database
Developing a mini-project involving both for a real-world use case
13 3
RDBMS and NoSQL databases
4. Suggested programs/activities:
Week Suggested Programs/activities
1  Setting up database environments (MySQL/PostgreSQL and MongoDB Atlas)
 Explore the interface (MySQL Workbench/ PostgreSQL PgAdmin and local or cloud
MongoDB)

2 Identifying Levels of Abstraction in a Given Database Scenario

Scenario:
A retail company uses a database to manage inventory, sales, and customer information. The
system allows:
 Customers to browse products and place orders through an online shopping platform.
 Store managers to track inventory levels and restock products.
 The finance team to generate revenue reports and analyze sales trends.

3 Design ER model for the below database requirement.

1. A food delivery platform connects customers with multiple restaurants, allowing them to
browse menus, place orders, and have food delivered to their location. The database must
manage a wide range of data, including restaurant information, menu items, customer
profiles, orders, payment processing, and delivery tracking. The system must also support
delivery logistics, managing driver assignments, and tracking order status from preparation to
delivery.
1. Restaurant Management:
 Store restaurant details, including name, location, contact information, and
operational hours.
 Manage menus with categories, items, pricing, and availability status.
2. Menu Management:
 Maintain records of menu items, including ingredients, preparation time, price, and
availability.
 Support special offers, discounts, and promotions for menu items.
3. Customer Management:
 Store customer profiles with information such as name, contact details, addresses,
and order history.
 Allow customers to save favorite restaurants, past orders, and payment preferences.
4. Order Management:
 Track customer orders from placement through preparation, dispatch, and delivery.
 Manage order status updates in real-time, including stages such as "Preparing," "Out
for Delivery," and "Delivered."
5. Delivery Management:
 Assign delivery drivers to orders based on location, availability, and estimated delivery
time.
 Track driver locations in real-time for efficient route optimization and status updates.
6. Payment Processing:
 Handle various payment methods including credit/debit cards, digital wallets, and
cash on delivery.
Maintain secure transaction records and support refunds for cancellations or disputes.

2. Design a database for a To-Do List Application that helps users manage their tasks
effectively. The database should store and organize information about users, tasks,
categories, and their relationships.
 Requirements:
rd.

status((e.g., Pending, In Progress, Completed), and due date.

Users should be able to organize tasks into categories.
A task can belong to multiple categories, and a category can include multiple tasks.
Each task should be linked to the user who created it.

4 Convert above ER Diagram to Relational Schema.

5 Create Retail_Store_Management Database and Product Table with following requirements:
 each product should have a unique identifier
 Each product should have a Product Name, which must be unique and cannot be NULL
 Each product should have a Price, and the price must be greater than zero
 Each product should have a Description, whose value can be null.
Modify Structure:
After creating the table,
 Remove the Description field from the table structure (as per requirement).
 Add Quantity , and the default value for it should be set to 0.
Execute DML Commands on the Created Tables
 Insert Data into the Product Table
 Update Data in the Product Table
 Delete Data from the Product Table
 Select Data from the Product Table
 Examine update anomalies and understand their impact on data integrity
Design a database for an Inventory Management System for a retail store. The system should
keep track of the store's products, suppliers, and customer orders. The database must include
the following requirements:
 Each product has a unique ID, name, category, quantity in stock, price per unit, and
supplier details.
 Each supplier has a unique ID, name, contact information, and the products they supply.
 Each customer has a unique ID, name, contact details, and purchase history.
Each order must have an order ID, customer details, date of the order, products purchased,
quantities, and total cost.
6 Normalize given schema up to 3NF
7 Suggestive Basic SQL Queries on To do list database
 Retrieve User Information for specific email id
 Count Tasks for all Users
 Retrieve the First 5 Tasks
 Retrieve Tasks Due Today
 Find the Maximum Due Date of Tasks for a Specific User
 Count the Number of Pending Tasks for a Specific User
 Find the Average Number of Tasks for specfic user

8 Suggestive Advanced SQL Queries on To do list database

 Retrieve Tasks with No Categories Assigned.

 Count Tasks in Each Category.
 Retrieve Categories Without Any Tasks
 Retrieve Users Who Have Tasks with High Priority
 Retrieve Tasks and Their Categories using JOIN
 Retrieve Categories with More Than 5 Tasks Assigned.
 Retrieve Users with Their Total Task Count using subquery

9 Create a transaction for the scenario:

 A customer wants to transfer money from their savings account to their checking
account.
 If any of the steps fail (for example, if there is insufficient balance in the savings
account), roll back the transaction to ensure that no changes are made to the
database.
DCL
 Grant SELECT privilege on a table to a user
 Grant multiple privileges to a user
 Grant all privileges on a table to a user
 Grant privileges on all tables in a schema
 Revoke SELECT privilege from a user
 Revoke multiple privileges from a user
 Revoke all privileges from a user
 Revoke privileges on all tables in a schema
10 MongoDB Shell Basic commands : show dbs, use <dbname>, show collections
11 Create MongoDB for E-Commerce Website with following collections
Products: Stores product details like name, description, price, category, etc.
Users: Stores user details like username, email, password, etc
Orders: Stores order details like user ID, product IDs, order status, etc.
 Adding a Product
 Adding a User
 Adding an Order
 Find All Products in a Category
 Find a Specific Product by Name
 Retrieve Orders for a Specific User
 Find User Details by Username
 Update Product Stock
 Update User Address
 Delete a Product
 Delete an Order
12 Write the aggregation pipeline
 to calculate the total sales for each product within a specified date range.
 to calculate the average price of products in each category
 to filter products within a certain price range and then calculate the total number of
products in each category.

5. CIE Assessment Methodologies

Duration
Sl.No Test Max
CIE Assessment (minutes)
Week marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
3 CIE-3TheoryTest 10 90 50 Average of all
CIE=50 Marks
4. CIE-4Practice Test 13 180 50
CIE-5 Portfolio evaluation of
5 all the activities through 1-13 50
Rubrics
Total 50 Marks

6. SEE - Theory Assessment Methodologies

Duration
Sl.No Max
SEE – Theory Assessment (minutes) Min marks to
marks
pass

1. Semester End Examination-Theory 90 50 20

7. CIE Theory Test model question paper

Program Computer Science and Engineering Semester -3
Course Name Database Concepts & Technologies Test I/III
Course Code 25CS31I Duration 90 min Marks 50
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q.No Questions Marks
Level Outcome

Section – 1
a. Why is data integrity better maintained in databases
than in file systems? Provide examples. – 5
b. Identify and explain the key features of a DBMS. – 10
c. Explain the difference between total and partial
participation with examples. – 4
d. Identifying Levels of Abstraction in below given
Database Scenario - 6
2,3 1
1 A university uses a database to manage information about
students, courses, and enrollments. The database allows:
 Students to view their grades and register for
25
courses via an online portal.
 Professors to input grades and access class rosters.
 The administration to generate reports on
enrollment statistics and course performance.
a. Describe the three-tier architecture of a DBMS and
explain the role of each tier. - 5
b. Create an ER diagram for a retail store that includes
2 2,3 1
entities like "Product," "Customer," "Order," and
"Supplier." Include attributes and relationships and
constraints. – 20

Section – 2
Translate the given ER diagram to relational schema

3 3 2
25

4 Translate the given ER diagram to relational schema 3 2

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Sign of the Course Coordinator Signature of the HOD Signature of the IQAC
Chairman
8. CIE Practice Test model question paper
Program Computer Science and Engineering Semester 3
Course Name Database Concepts & Technologies Test II/IV
Course Code 25CS31I Duration 180 min Marks 50
Name of the Course Coordinator:
Questions CO Marks
Develop a database system to support a Ticket Raising Application that facilitates 50
efficient management and resolution of user-reported issues. The system should be
capable of handling user information, ticket details, categorization, prioritization,
assignment, and tracking of ticket resolution. Requirements:
a. Store user information such as name, email, phone number, and role (e.g.,
Customer, Support Agent, Admin).
b. Maintain secure login credentials for users.
c. Allow customers to raise tickets with details such as:
 Issue description
 Category (e.g., Technical, Billing, General Inquiry)
 Priority level (e.g., Low, Medium, High, Critical)
 Assign a unique identifier and timestamp to each ticket.
d. Track the status of each ticket (e.g., Open, In Progress, Resolved, Closed) and
record timestamps for status changes.
e. Store resolution details, including:
 Comments or actions taken by the support agent and resolution
timestamp.
f. Assign tickets to support agents based on expertise, workload, or availability.
Scheme of assessment
a. Database Design – 15
 Entity-Relationship (ER) Diagram -5
 Correct conversion of ER diagram into a normalized relational schema. - 5
 Use of appropriate data types for attributes and Implementation of integrity constraints-5
b. Database Implementation – 20
 Correct creation of database objects using tools - 5
 Application of constraints - 5
 Data Population - 5
 Execution of basic INSERT, UPDATE, DELETE, and SELECT statements - 5
c. Querying (basic and advanced) - 10
d. Documentation and Presentation – 5
Total Marks 50

Sign of the Course Coordinator Signature of the HOD

9. SEE–Model Theory Question Paper

Program Computer Science and Engineering Semester 3
Course Name Database Concepts & Technologies Marks 50
Course Code 25CS31I Duration 90 Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q No Questions Marks
Levels Outcomes
 Section -1
a. Explain how the components of a DBMS work
together to handle a query.
b. Given a description of a university database, draw 2 1 10
1
an ER diagram with entities, attributes, and
relationships.
a. Identify entities, attributes, and relationships for a
hospital management system.
2 b. Explain the differences between the external, 2 1 10
conceptual, and internal schemas with examples.

Section -2
a. Write a relational schema for a library management
system with at least 5 attributes and specify the
keys and constraints.
b. Normalize the following table to 3NF: 2,3 2 10
3
| OrderID | CustomerName | ProductName |
SupplierName | SupplierContact |
Identify the keys and explain each step.
a. Explain the integrity constraints in the context of
database
b. Identify the type of FD in the following example:
4 2,3 2 10
If EmployeeID determines Department, and
Department determines Manager, then
EmployeeID determines Manager.
Section -3

a. What are the five categories of SQL commands?

Provide one example for each. - 5
5 b. Explain the use of COMMIT and ROLLBACK in an 2 3 10
inventory management system with an example. –
5
a. What are the ACID properties of a transaction?
Provide examples for each property. – 5
b. Write an SQL query to create a table Employees
6 2 3 10
with columns: EmpID (Primary Key), Name (Not
Null), Salary (Decimal), and Department (Varchar).
–5
Section -4

a) Write an SQL query to retrieve records from the

"inventory" table where "stock" is less than 10 but not
equal to 0.
b) Write an SQL query to find all orders where the
7 3 4 10
"quantity" is between 10 and 50 or the "status" is
"shipped".
c) Write an SQL query to count the number of
employees in each department.
 a) Write an SQL query to sort the "products" table by
price in descending order and display only the first 10
results.
b) Write an SQL query to find the average price of 3 4 10
8
products in the "products" table.
c) Write a single-row subquery to find the product with
the highest price.
Section -5

a. Explain the CAP theorem with examples. – 6

b. Explain the difference between - 4
9 3,2 5 10
1. insertOne() and insertMany()
2. find() and findOne()
a. Given a collection of student records, write queries
to:
1. Insert multiple student records.
2. Find students with marks greater than 80.
10 3, 2 5 10
3. Update the "status" field for students with marks
below 50 to "at risk". - 6
b. What is the purpose of the aggregation framework
in MongoDB? – 4

10. Rubrics for Assessment of Activity (Qualitative Assessment)

Sl. Dimension Excellent Good Satisfactory Needs Improvement Score

No. (4 or below)
9-10 7-8 5-6 <=4
Demonstrates thorough 8
Shows good Demonstrates basic Lacks understanding
understanding of
Understanding of understanding of understanding but of concepts or is
1 underlying concepts and
Concepts concepts with minor struggles with deeper unable to explain
explains them
gaps. applications. them clearly.
confidently.
Writes basic code 6
Writes efficient, well- Writes functional Writes poor or non-
with some
structured, and and mostly clean functional code with
2 Implementation Skills inefficiencies and lack
commented code with code with minor little to no structure
of comments or
appropriate logic. inefficiencies. or comments.
structure.
Actively collaborates, Participates well, Does not participate 7
Participates minimally
contributes ideas, and shares ideas, and in teamwork or
3 Teamwork/Collaboration and may not engage
supports peers collaborates with creates disruptions
fully with peers.
effectively. minor lapses. within the team.
Fails to present 9
Presents results Struggles to explain
Explains the results and results clearly or
with minor results clearly or
4 Presentation of Results process clearly with shows lack of
inaccuracies or gaps makes incorrect
accurate conclusions. understanding of the
in explanation. conclusions.
process.
Fails to complete the 10
Completes the task well Completes the task Completes the task
task within the
within the allotted time on time with minor with significant delay
5 Adherence to Time allotted time or
with no compromise on compromises in or compromises in
quality is highly
quality. quality. quality.
compromised.
TOTAL 40
11. Equipment/softwarelistwithSpecificationforabatchof30students

Sl.No. Particulars Specification Quantity

01 Computers i3/i5 processor 30
02 Internet connection 100mbps
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Engineering Semester 3
Course Name Computer Networks Type of Course Integrated
8 per week
Course Code 25CS32I Contact Hours
Teaching Scheme 4: 0:4 Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale:

This course is designed to equip students with the foundational knowledge and practical skills needed to
design, implement, and troubleshoot computer networks in various environments. It addresses the
selection of appropriate communication technologies and the resolution of issues like signal loss, latency,
and noise to ensure optimal network performance. Learners will gain hands-on experience in configuring
IP addressing, routing, subnetting, and protocols like TCP/UDP and DNS using network simulators. The
course also emphasizes designing secure and scalable networks, from home office setups to enterprise-
level solutions, tailored to specific requirements. By mastering these skills, students will be well-prepared
for roles in network administration, engineering, and IT consulting.

2. Course Outcomes: At the end of the Course, the student will be able to:
Select an appropriate communication technology for a given network and ensure optimal
CO-01
performance by addressing issues arising from transmission impairments
Design a network for a given specification by using the right network components, devices,
CO-02 topologies, protocols and software.
Troubleshoot common network issues.
CO-03
Demonstrate the configuration of IP address, routing, subnetting, client-server interaction (TCP,
CO-04 UDP) and DNS for a given WAN network using a network simulator.
Design and implement simple Home Office network for given specification.
CO-05

3. Course Content
Week CO PO Lecture(4HRS) Practice(4HRS)
(Knowledge Criteria) (Performance Criteria)
Perspectives on Networking – 1. Demonstrate different network
End user perspectives on Networking cables and connectors.
and Internet. 2. Demonstrate connecting
Communication Systems - Basic Computer to home modem/router
elements of communication systems through Ethernet cable or Wifi
with block diagram, List commonly 3. Automatic and Manual IP Setting
used terms in electronic (Computer and Smart phone) and
1 1,2 1,7 demonstrate connecting to
communication systems.
Data representation, Data flow. Internet, discuss IP address,
Subnet mask, Default gateway and
Communication Channels:
DNS in end user perspective.
Guided Media (Over view)- Twisted
pair, Coaxial Cable, Optical Fibers.
Analog and Digital Signals, Periodic
and Non-Periodic Signals, Sine Wave,
 Phase, Wavelength, Digital Signals,
Bitrate, Bit-length, Modulation,
Demodulation.
Unguided Media: Micro Wave, Radio
wave, Infrared etc.
Electromagnetic waves – what are
electromagnetic waves and their
properties
Electromagnetic spectrum -
classification and its applications.
Transmission Impairment – 1. Explore all ISP in your area/locality
Attenuation, Distortion and Noise, and select best internet ISP/plan
Performance - Bandwidth, based on cost and performance.
Throughput, Latency, Jitter (Basic 2. Test the download/upload speed
concepts only). in your computer/mobile phone
Transmission Modes – Parallel and also check type, bandwidth and
Serial Transmission. Asynchronous ISP.
and Synchronous Transmission. 3. Demonstrate Transmission mode
Overview of Networking. Categories (Video Demonstration)
2 1,2,3 1,2,7 of networks – Personal Network, 4. Demonstrate Bandwidth,
LAN, MAN, WAN, Internetworking Throughput, Latency, Jitter (Video
(Illustrate Network from LAN Demonstration)
connected using a HUB to 5. Use pathping command to find
Internetwork). actual path between source to
A brief History – ARPANET, MILNET, destination with information
CSNET, NSFNET, ANSNET. about network latency/delay &
The Internet today – Backbone ISP, network loss.
Regional ISP, Local ISP.
World Wide Web.
Protocol and Standards- Network Simulator: Demonstrate
The communication rules (Method, Packet tracer or any other
language, Confirmation) – Protocols. network simulator
Standards. 1. Installation
Protocol layers 2. User Interface3
OSI Model : OSI Layers and Their 3. Components and cables
3 1,2,3 1,2,3,7
Functions, OSI Layering Concepts 4. GUI and CLI Configuration
and Benefits, OSI Encapsulation 5. Configure end devices.
Terminology. 6. Demonstrate Working of all 7
layers by opening a webpage in a
simulated network using packet
tracer
TCP/IP Networking Model - Overview 1. Determine the IP Address
of the TCP/IP Networking Model. Configuration of a Computer
TCP/IP Application Layer, HTTP (Windows) and Test the
Overview, HTTP Protocol Network Interface TCP/IP Stack
Mechanisms. (Ping).
4 1,2,3 1,2,3,7
TCP/IP Transport Layer, TCP Error 2. Install and configure wireless
Recovery Basics, Same-Layer and access point over the LAN.
Adjacent-Layer Interactions. 3. Determine the MAC Address of a
TCP/IP Network Layer, Internet Host (PC and Phone).
4. View Wireless and Wired NIC
 Protocol and the Postal Service, Information and make a table
Internet Protocol Addressing Basics, explaining each.
IP 5. Manual and Automatic address
Routing Basics. assignment (Windows and
TCP/IP Link Layer (Data Link Plus Android Pone)
Physical), TCP/IP Model and a) IPv4 address
Terminology, Data Encapsulation b) Subnet mask
Terminology. Names of TCP/IP c) DNS
Messages. 6. Demonstrate Addressing in
Addressing : Physical, Logical, Port packet tracer
Hardware and Software components 1. Demonstrate working of
of Network - Common network common network devices.
devices - Computers, Access points, 2. Install and configure NIC.
Hub, Switch, Router, repeaters, NIC, 3. Twisted Pairs: UTP Cabling
Modem. LAN Cables – Co-axial, Pinouts for 10BASE-T and 100BASE-
twisted pair, optical fibre, LAN T, Straight Through Cable Pinout,
connectors- co-axial cable, and Crossover Cable Pinout
twisted pair cable, optical fibre, Demonstration.
Connectors, Firm wares, ISPs.
4. Crimping of RJ45: Straight and
Wired Local Area Networks Protocol Cross. a) Punching Cat 6 cable to
5 1,2,3,5 1,2,3,4 and technologies: Ethernet (IEEE I/O Box. Use punching tool. b)
802.3) – Frame Format, Ethernet Check connectivity using LAN
Evolution, Access Methods: tester.
CSMA/CD, CSMA/CA, Fast Ethernet,
5. Create and Demonstrate all
Gigabit Ethernet.
possible network topologies using
Error Detection in Ethernet. simulator.
Broadcast and Collision domain. 6. Demonstrate Broadcast and
Overview of network topologies - Collision domain ( Video
Basic topologies- bus, ring, star, mesh demonstration)
and hybrid.
Wireless LAN ( IEEE 802.11) – 1. Build a physical Ethernet LAN
Architecture, Frame Format,BSS, ESS, Network and demonstrate file
MAC Sublayer, CSMA/CA, Hidden and sharing, printer sharing.
Exposed Station Problems, 2. Install and configure wireless
Ethernet access layer devices – Hub, access point over the LAN.
Switch, The MAC address table, 3. Configure and install a ethernet
Ethernet Broadcast and Broadcast switch/Hub (Use simulator if
domain, ARP. hardware devices are not
Hierarchical Network Design – available)
6 1,2,3,5 1,3,4
Physical and logical addresses, 4. Create/model a simple Ethernet
Benefits of a Hierarchical Design, network using 3 hosts and a
Access, Distribution, and Core layers switch, Observe traffic behavior
(Demonstrate Hierarchical Network on the network and Observer
Design in packet tracer) data flow of ARP broadcasts and
pings.
5. Demonstrate Collision and
Broadcast domain in packet
tracer.
7 2,4,5 1,3,4 Introduction to Network Layer 1. Build a simple peer-to peer
 Switching - Circuit Switching, Packet network and verify physical
Switching. connectivity and Assign various
Packet Switching in Network Layer- IPv4 addresses to hosts and
Connectionless Service, Connection- observe the effects on network
Oriented Service. Network Layer communication.
Services – Logical Addressing, Services 2. Configure IP addresses of a
Provided at the Source Computer, network (real or simulated) and
Services Provided at Each Router, ping across to test and
Services Provided at the Destination troubleshoot.
Computer. 3. View Wireless and Wired NIC
Other Network Layer Issues - Error Information and make a table
Control, Flow Control, Congestion explaining each.
Control, Routing
IP Addressing, Address Space, 1. Subnetting : Your college is given an
Notation. ip 192.168.100.0/24, you have 5
Classful addressing , Two different departments, design and
Levelling addressing, Three-Level implement subnetting using packet
Addressing, Classless addressing tracer.
– Subnetting, Subnet mask, 2. Connect to web server using
Super netting, CIDR, Variable simulator, Demonstrate how packets
length subnet mask. are sent across the Internet using IP
8 2,4,5 1,3,4
Special addresses addresses and working of HTTP
Network Address Translation services.
(NAT). 3. Implement Network Address
Delivery and forwarding of IP Translation using packet tracer
packets - Direct Delivery, Indirect
Delivery. Forwarding. Structure
of a Router. IP V4 – Datagram,
fragmentation.
Routing: The Need for Routing - 1. Implement simple static routing
Criteria for Dividing the Local for the practice activity of week 8 (
Network. IPv4 Routing - IPv4 Host subnetting)
Routing, Router, Forwarding Decisions 2. Troubleshooting of IP Addressing
and the IP Routing Table, The default a) Change a routing table entry
gateway, A Summary of Router b) Wrong address
Forwarding Logic, A Detailed Routing c) incorrect subnet mask.
Example. Routing Protocols - IPv4 3. Demonstrate ICMP commands.
Routing Protocols – static and
9 2,4,5 1,3,4 dynamic. Other Network Layer
Features - Using Names and the
Domain Name System, The Address
Resolution Protocol, ICMP Echo and
the ping Command. IGMP.
IPv4 Issues - Need of IPv6, Ipv4 vs
IPv6, IPv4 and IPv6 Coexistence. IPv6
features - IPv6 Address
Representation. Concept of Virtual
LAN’s(VLAN’s)
Transport Layer Services- Process-to- 1. Demonstration of Port addressing
10 2,4,5 1,3,4 Process Communication, Addressing: and well-known port numbers
Port Numbers, Multiplexing and (HTTP, DNS, SMTP) using packet
 Demultiplexing, Flow Control, Error tracer
Control – Sliding window. Congestion 2. TCP vs. UDP Comparison
Control. (Compare the behavior of TCP
Connectionless and Connection- and UDP protocols)
Oriented Services. a. Create a network with two PCs
Transport Layer protocols- Simple connected through a router.
protocol, Stop and Wait, Go back N. b. Configure one PC to run an HTTP
(TCP) server and the other a DNS
(UDP) server.
c. Use the Web Browser and DNS
Client tools on the other PC to
access these services.
d. In Simulation Mode, filter for TCP
and UDP packets and compare
reliability, acknowledgment, and
retransmission behavior.
3. Demonstrate Sliding window,
Congestion control, Stop and
Wait, Go back N (Only
demonstration)
The Client Server relationship – Client 1. Create a client – server model in
Server interaction. URI, URN, URL simulator and observe the
User datagram protocol – User client interaction between the
datagram, UDP services, UDP server and PC using packet
Applications. tracer.
Transmission Control protocol: TCP a. Create a network with one
services , features. server, a switch, and two PCs.
Popular TCP/IP Applications, a) Configure IP addresses for all
Connection Establishment and devices.
Termination. b) Enable HTTP and FTP services
11 2,4,5 1,3,4
Port Numbers – TCP and UDP. Socket on the server.
pairs, The netstat command. c) Use the Web Browser and
Command Prompt on the
clients to access HTTP and
FTP services.
d) Open Simulation Mode to
capture and analyze HTTP
GET and FTP
request/response packets.
2. Demonstrate Netstat command
Introduction to application layer: 1. Configure a DNS server using
Client Server paradigm. packet tracer and Observe the
HTTP conversion of a URL to an IP
DHCP address.
12 2,4,5 1,3,4 DNP 2. Observe DNS lookup using the
nslookup command.
Telnet and SMTP,POP, IMAP, FTP.
3. Use simulator to demonstrate
Telnet and SSH
4. Configure and test DHCP using
 packet tracer.
5. Configure a HTTP service and
demonstrate working of HTTP
Troubleshoot Common Network 1. Demonstrate troubleshooting
Problems - The Troubleshooting Commands with a scenario- ipconfig,
Process, Network Troubleshooting ping, netstat, tracert, nslookup.
Overview, Gather Information - 2. Troubleshooting Common Issues
Nature of problem, Equipment, Using Packet Tracer Simulation Mode
Configuration and Topology, Previous a) set up a basic network with a
Troubleshooting. Structured router, switch, and PCs.
Troubleshooting Methods - Bottom-
13 1,2,3 1,2,3,4,7 b)Introduce issues like:
Up, Top-Down, Divide-and-Conquer,
c) Incorrect subnet mask.
Follow-the-Path, Substitution,
Comparison, Educated Guess. d)Disabled router interfaces.
Guidelines for Selecting a e)Use Simulation Mode to observe
Troubleshooting Method packet flow:
Troubleshoot Wireless Issues - Causes f) Identify where packets drop or
of Wireless Issues, Authentication and fail.
Association Errors. g) Fix the configuration and test.

4. Learning Resources
Week Resources
1 1. NCERT Class 12 Physics Chapter 8
2. Networking courses on Netcad.com : Networking basics and Networking essentials
3. Skillsforall.com : Networking basics and Networking essentials
4. Youtube.com
5. ChatGPT
2 1. NCERT Class 12 Computer Science
2. TCP/IP protocol suite Behrouz A. Forouzan
3. Data Communication and Networking Behrouz A. Forouzan
4. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
5. Computer Networks by Andrew S. Tanenbaum
6. Networking courses on Netcad.com : Networking basics and Networking essentials
7. Skillsforall.com : Networking basics and Networking essentials
3 1. NCERT Class 12 Computer Science
2. TCP/IP protocol suite Behrouz A. Forouzan
3. Data Communication and Networking Behrouz A. Forouzan
4. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
5. Computer Networks by Andrew S. Tanenbaum
6. Networking courses on Netcad.com: Networking basics and Networking essentials, Getting
Started with Cisco Packet Tracer
7. Skillsforall.com: Networking basics and Networking essentials
4 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach
by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com : Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
5 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials, Getting
Started with Cisco Packet Tracer
6. Skillsforall.com: Networking basics and Networking essentials, Getting Started with Cisco
Packet Tracer
7. Cisco.com : Connector and Cable Specifications
6 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials, Getting
Started with Cisco Packet Tracer
6. Skillsforall.com: Networking basics and Networking essentials, Getting Started with Cisco
Packet Tracer
7 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
8 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
7. https://www.youtube.com/watch?v=_BVvXph43aM
8. https://techacadhelp.com/11-5-5-packet-tracer-subnet-an-ipv4-network/
9. https://www.geeksforgeeks.org/static-nat-configuration-in-cisco/
09 1. CP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
7. https://www.youtube.com/watch?v=ziDv9esbEG0
10 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
7. https://www.youtube.com/watch?v=D4Re_gv3rz0&t=18s
11 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
 5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
12 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials
13 1. TCP/IP protocol suite Behrouz A. Forouzan
2. Data Communication and Networking Behrouz A. Forouzan
3. Computer Networks: A Systems Approach by Bruce S. Davie and Larry L. Peterson
4. Computer Networks by Andrew S. Tanenbaum
5. Networking courses on Netcad.com: Networking basics and Networking essentials
6. Skillsforall.com: Networking basics and Networking essentials

5. CIE Assessment Methodologies

Duration
Sl. Test Max
CIE Assessment (minutes)
No Week marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
Average of all
3 CIE-3TheoryTest 10 90 50 CIE=50 Marks
4. CIE-4Practice Test 13 180 50
CIE-5 Portfolio evaluation of
5 all the activities 1-13 50
through
Rubrics
Total 50 Marks

6. SEE - Theory Assessment Methodologies

Duration
Sl. Max
SEE – Theory Assessment (minutes) Min marks to
No marks
pass

1. Semester End Examination-Theory 90 50 20

7. CIE Theory Test model question paper

Program Computer Science and Engineering Semester -3
Course Name Computer Networks Test I
Course Code 25CS321 Duration 90 min Marks 50

Name of the Course Coordinator:

Note: Answer any one full question from each section. Each full question carries equal marks.
 Cognitive Course
Q.No Questions Marks
Level Outcome

Section - 1

a) Illustrate Communication system with block diagram. 5 L2 1 25

Marks L3
b) Discuss optical fibers, Why are optical fibers preferred 1
1 for long-distance communication? 10 Marks
c) Why is serial transmission preferred for long-distance L3 1
communication? 10 Marks
a) How does data represented in computer? 5 Marks L3 1
b) Why is line-of-sight important for microwave L3 1
communication? 5 Marks
2 c) What is bitrate and bit length? How they are connected 1
to network speed? 5 Marks L3
d) Illustrate different categories of networks. 10 Marks L2 1
Section – 2

a) Illustrate the seven layers of the OSI model. 10 L2 2 25

Marks
b) What is encapsulation in the context of the OSI model? L2 2
Why is encapsulation essential for data transmission in a
3
network? 10 Marks
c) Illustrate main functions of Network layer in OSI model. L2 2
5 marks

a) Illustrate working of TCP/IP with diagram 10 L3 2

Marks
b) Differentiate between Physical, Logical, Port addressing L3 2
4 10 Marks
c) Discuss the purpose of routing in the network layer 5 L3
marks 2

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program Semester 3
Computer Science and Engineering
Course Name Test IV
Computer Networks
Course Code 25CS32I Duration 180 min Marks 50

Name of the Course Coordinator:

Questions CO Marks

50
Your college is given an IP 192.168.100.0/24, you have 5 different departments and 2,5
 each department needs separate subnetwork, design and implement the network
using packet tracer.
Or
Design a network with minimum 2 routers and 4 switches, configure network and
demonstrate static routing using packet tracer.
Scheme of assessment
15
a) Design IP Address scheme (Written)
b) Network design (Creating topology, configuring devices, IP assignment etc) 20
c) Verify connectivity / Routing 10
d)Demonstrate working / Troubleshoot if any error 05
TotalMarks 50

Signature of the Course Coordinator Signature of the HOD

9. SEE–Model Theory Question Paper

Program Computer Science and Engineering Semester 3
Course Name Computer Networks Marks 50
Course Code 25CS32I Duration 90 Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q No Questions Marks
Levels Outcomes

Section -1

Discuss optical fibers, Why are optical fibers preferred L3 1 10

1 for long-distance communication? 10 Marks
a) Why is line-of-sight important for microwave L3 1 10
communication? 5 Marks
2 c) What is bitrate and bit length? How they are L3 1
connected to network speed? 5 Marks
Section -2

What is encapsulation in the context of the OSI model? L2 2 10

3 Why is encapsulation essential for data transmission in
a network? 10 Marks
Differentiate between Physical, Logical, Port addressing L3 2 10
4
Section -3

a) There are multiple computers are accessing single L3 5 5

medium. You are designing a network want to avoid
any collision among data packets. How can you achieve
5 it? Explain briefly (CSMA/CA)
b) For every Computer there is a Physical address and a L3 5 5
logical address why?
a) Differentiate between Circuit Switching and Packet L2 4
6 Switching.
b) Why routing is necessary? L3 4
 Section -4

a) What is Network Address Translation? Explain L2 4 5

7 b) Your institute allocated with an IP 192.168.100.0/24,
you have 5 different departments, design subnetting L3 4 5
a) Change the following IP addresses from dotted- L3 4 2.5+2.5
decimal notation to binary notation: =5
a. 114.34.2.8 L3 4
8
b. 129.14.6.8
b) Why we are using Sliding window protocol? Explain 5
Section -5

a) Differentiate between Top down and Bottom up L3 3 5

approaches in trouble shooting L2 3 5
9 b) How do you thoubleshoot wireless connectivity
issues
a) Explain any 3 application layer protocols L2 2,5 5
b) The cat-6 cable is connected from computer to L3 3 5
outside internet through a switch and a modem, but
10 there is an error saying “No internet”. What are the
possible causes for this error? How can you resolve this
issue?

10. Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Excellent Good Satisfactory Needs Score
No improvement
9-10 7-8 5-6 Below 5
1 Knowledge Demonstrates an in- Understands Basic Limited 8
of Hardware depth understanding most hardware understanding understanding
Components of all hardware components and of hardware of hardware
components, their their roles, with components but components
roles, and minor gaps or struggles with and their
interconnections with inaccuracies. details or functions.
accurate terminology. technical
terminology.
2 Configuratio Configures and Configures and Completes Unable to 6
n and installs installs configuration complete
Installation hardware/software hardware/softwa and installation configuration
Skills accurately without re correctly with with frequent or installation
assistance, following minimal guidance; some without
industry best guidance; few errors in significant
practices. errors. execution. errors or
assistance.
3 Troubleshoo Identifies and Diagnoses and Can diagnose Unable to 2
ting and resolves issues resolves most and resolve diagnose or
Problem- systematically and issues with minor basic issues but resolve issues
Solving efficiently using inefficiencies or struggles with without
appropriate tools and errors more complex significant
methods. problems. assistance.
4 Documentati Produces detailed, Documentation Documentation Documentation 3
on and well-organized, and is clear and is basic, with is incomplete,
Reporting professional organized but several errors or unclear, or
documentation with contains minor incomplete missing
 no errors. errors or details. important
omissions. details.
5 Teamwork Actively contributes Contributes Participates in Limited 2
and to team efforts, effectively to the team activities participation or
Collaboratio communicates team with good but lacks ineffective
n effectively, and communication; initiative or collaboration in
assumes leadership may rely on effective team tasks.
when necessary. others for communication.
leadership.
Total/50 21/5
0

11. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quantit

y
01 Computers 30
02 Internet Connectivity
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION

Program Computer Science and Semester 3

Engineering
Course Name Data structures with Python Type of Course Integrated
Course Code 25CS33I Contact Hours 7 Hours per week
Teaching Scheme 3:0:4 Credits 5
CIE Marks 50 SEE Marks 50 (Practice)

1. Rationale:

The course is designed to provide learners with a comprehensive understanding of how data is
organized, stored, and manipulated in computational systems. By covering both linear and nonlinear
data structures, as well as Python's built-in data structures, the course equips students with the
knowledge and practical skills necessary to design efficient algorithms and solve computational
problems effectively.

2. Course Outcomes :At the end of the Course, the student will be able to:
CO-01 Analyze and distinguish between different data structures and their properties to determine
their suitability
for the use cases.
CO-02 Devise a solution to the given problem by selecting the appropriate built in data structures
CO-03 Develop and implement the solution incorporating error handling mechanisms.
CO-04 Explain the functionality of Abstract Data Types (ADT) such as Stacks, Queues, Lists, and Trees.
CO-05 Implement Abstract Data Types(ADT) using User-defined data structures(UDT) to develop
solutions for a given problem.

3. Course Content
Week CO PO Theory Practice

Introduction to Data Structures Recap of python concepts

Classification: [practice programs using
Built in data structures functions]
User defined data structures
1 1 1,7 Linear & non linear Explore and document real time
Operations on data structures: Traversal, applications of Built-in data
Insertion, Deletion, Searching, Sorting, structures and user defined data
and Merging. structures.

Sets:
Practice programs to understand
● Characteristics and uniqueness of
the concept of
elements.
2 1,2 2,4 ● Sets and its operations.
● Set operations: Union, intersection,
● Tuple and its operations
difference, symmetric difference.
● Removing duplicates from a list
 using sets.
Tuples:
● Characteristics and immutability.
● Basic operations: Creating,
Accessing elements and slicing
● Packing and unpacking tuples.
Lists:
● Characteristics and use cases.
● Common operations: Creating,
Indexing, slicing, appending,
Practice programs to understand
removing, sorting.
the concept of
● List comprehensions.
● Lists and its operations.
3 1,2 2,4 Dictionaries:
● Dictionaries and its
● Key-value pairs: Characteristics and
operations
use cases.
● Adding, updating, deleting entries.
● Iterating through dictionaries.
● Dictionary methods (e.g., keys(),
values(), items())
Strings:
● Creating and assigning strings
Practice programs to understand
● Indexing
the concept of
String manipulation & built-in methods:
4 1,2 2,4 ● Strings and its methods.
● Concatenation
● Files and its operations
● Repetition
● Slicing
Files: File attributes; operations
Error and Exception Handling: Practice programs to understand
Types of errors; the concept of
5 1 2,4
Exception handling ● Exception handling
Raising exception
Introduction to Recursion
● Definition of recursion.
● How recursion works (stack memory
and execution flow).
● Difference between recursion and
Practice programs to understand
iteration.
the concept of recursion
6 3 2,4 Structure of a Recursive Function
● Base case.
● Recursive case.
● Identifying recursive patterns in
problems.
Use cases of recursion:
Factorial calculation.
Getting started with ADT and UDT:
Abstract data type(ADT): Practice programs to understand
Common ADTs: Stacks, Queues, Lists, the concept of ADT and UDT.
7 1,2,3 2,4
Trees, Graphs, Hash Tables.
User-Defined Data Type(UDT): class
Using UDTs to Implement ADTs
Stack data structure Practice programs to understand
8 1,3 2,4
LIFO (Last In, First Out) principle the concept of Stack data
 Real life examples structure and its operations
Stack Operations
Implementation of Stack
Queue Data Structure
FIFO(First In, First Out) principle Practice programs to understand
9 1,3 2,4 Real life examples the concept of Queue data
Queue operations structure and its operations
Implementation of Queue
Linked Lists
● Definition and basic structure (Node,
Head, Tail)
● Linked list vs. arrays
● Types of linked lists: Singly Linked List,
Doubly Linked List, Circular Linked List
Practice programs to understand
Singly Linked List
the concept of singly linked list its
10 1,3,4 2,4 ● Structure and representation
operations
● Basic operations:
a. Insertion (at beginning, end, and
middle)
b. Deletion (from beginning, end, and
middle)
c. Traversal
d. Searching
Doubly Linked List
● Structure and representation (with
previous and next pointers)
● Basic operations:
Practice programs to understand
a. Insertion (at beginning, end, and
11 1,3,4 2,4 the concept of singly linked list
middle)
and its operations
b. Deletion (from beginning, end, and
middle)
c. Traversal (both forward and
backward)
Introduction to Trees
● Definition and Terminology
● Properties of Trees
Practice programs to understand
● Binary tree representation in memory
12 1,3,5 2,4 the concept of tree data structure
Basic Operations:
and its operations
● Insertion, Deletion, Searching
● Traversal: In-order, Pre-order,
Post-order
Tree Traversal(recursive and iterative):
● In-order Practice programs to understand
13 1,3,5 2,4
● Pre-order the concept of tree traversals
● Post-order

4. Learning Resources:
Sl No References
1 "Python for Everybody" by Dr. Charles Severance
2 “Automate the Boring Stuff with Python" by Al Sweigart
3 "Python Data Structures and Algorithms" by Benjamin Baka
4 https://docs.python.org/3/tutorial/datastructures.html
5 https://www.geeksforgeeks.org
6 https://www.w3schools.com
7 https://www.tutorialspoint.com
8 https://www.khanacademy.org
9 https://www.datacamp.com
10 https://www.programiz.com

5. CIE Assessment Methodologies

Sl.No Test Duratio Max
CIE Assessment Wee n marks
k (minute
s)
1. CIE-1TheoryTest 4 90 50 Average of
all CIE=50
2. CIE-2 Practice Test 7 180 50 Marks
3 CIE-3 TheoryTest 10 90 50
4. CIE-4 Practice Test 13 180 50
CIE-5 Portfolio evaluation
5 of all the activities 1-13 50
through Rubrics
Total 50 Marks

6. SEE – Practice Assessment Methodologies

S Duration Max
l SEE – Practice Assessment (minutes) marks Min marks to
. pass
N
o
1. Semester End Examination- 180 50
20
Practice

7. CIE Theory Test model question paper

Program Computer Science and Engineering Semester -3rd
Course Name Data structure with python Test I/III
Course Code 25CS331 Duratio 90 min Marks 50
n
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Q.No Questions Cognitiv Course Mar
e Level Outcom ks
e
Section - 1
 a)What is the difference between a tuple and a list in 25
Python? Give a scenario where you would prefer using a
tuple over a list.
(5marks)

b)Write a Python function that takes a list of integers as

input and returns a new list where:(10 marks)
● All even numbers are squared.
● All odd numbers are multiplied by 3.
1 Example Input: [1, 2, 3, 4, 5, 6]
Example Output: [3, 4, 9, 16, 15, 36]

c)Write a Python function that takes a list of tuples,

where each tuple contains the name and the age of a
person. The function should return the name of the
oldest person.(10marks)
Example Input: [('John', 45), ('Alice', 50), ('Bob', 30)]
Example Output: 'Alice'
a)Describe the basic operations that can be performed
on a set in Python. Provide examples of how to compute
the intersection, union, and difference between two
sets.(5marks)
b)Write a Python function that takes a list of tuples,
where each tuple contains the name and the age of a
person. The function should return the name of the
oldest person.(10 marks)
Example Input: [('John', 45), ('Alice', 50), ('Bob', 30)]
Example Output: 'Alice'
2 c)Write a Python function that takes two sets and returns
a tuple containing:(10 marks)
● The intersection of the two sets.
● The union of the two sets.
● The difference between the first set and the
second set.
Example Input:
set1 = {1, 2, 3, 4, 5}
set2 = {4, 5, 6, 7}
Example Output:
({4, 5}, {1, 2, 3, 4, 5, 6, 7}, {1, 2, 3})
Section - 2
Analyze the code and write the output 25
def sum_nested_elements(nested_structure):
total_sum = 0
stack = [nested_structure] # Initialize the stack with
the outer structure
print(stack)
3
while stack:
current = stack.pop() # Take the last element from
the stack
print(current)
for item in current:
if isinstance (item, (list, tuple)): # If it's a list or
 tuple, add to the stack
print(item)
stack. append(item)
print(stack)
elif isinstance (item, (int, float)): # If it's a
number, add to the total
total_sum += item
return total_sum

nested_list = [1, 2, (3, 4), [5, (6, 7)], 8]

total = sum_nested_elements(nested_list)
print(f"Total sum of elements: {total}")
a)Create a Python program to Create a collection named
trees – Oak, Pine, Mango, Neem, Maple, Teak, Mango,
Neem, Maple, Pine, Mango, Oak, Pine, Mango, Peepal,
Banyan, Sal,
Compute and display the result with relevant messages
for following:
1. Ask the user to input a tree name to count how
many times it appears in the collection.
2. Ask the user to input a tree to find its position in
the collection.
3. Get the last 5 tree names from the collection
4. Find the unique tree names from the collection
Suggest the suitable python concept to solve above and
justify your selection.

4
b)Swami Vivekananda was a renowned Indian Hindu
monk and one of the most influential spiritual leaders of
the 19th century.
For the above text, create a python program to
1. measure the length of the text.
2. count the number of words in the text.
3. Count the occurrence of these stop words – of,
the, at, in, with
4. Capitalize these words and display the text –
Narendranath, Vivekananda
5. Find numeric and alphanumeric words from the
above text.

Suggest the suitable python concept to solve above and

justify your selection.

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Sign of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman
8. CIE Practice Test model question paper
Program Computer Science and Engineering Semester

Course Name Data structure with python Test

Course Code 25CS331 Duratio 180 min Marks 50
n
Name of the Course Coordinator:

CO Mar
Questions ks
Problem Statement: Text and Numerical Data Separation with Word 50
Classification
Write a program that processes a given paragraph and performs the following
tasks:
1. Read Input Data:
○ Read a text file containing text data. Each line of the file may contain
multiple words.
2. Process Words:
○ Extract all the words from the file, ignoring special characters and
punctuation.
3. Separate Text and Numerical Data:
○ Parse the paragraph to separate numerical data (e.g., numbers,
digits) and text (e.g., words or characters).
4. Classify Words:
○ From the separated text, classify words into the following
categories:
■ Uppercase Words: Words containing only uppercase letters
(e.g., "HELLO").
■ Lowercase Words: Words containing only lowercase letters
(e.g., "world").
■ Mixed Case Words: Words containing both uppercase and
lowercase letters (e.g., "Python").
5. Output:
○ The original paragraph.
○ A list of numerical data extracted from the paragraph.
○ Separate lists for Uppercase, Lowercase, and Mixed Case words.
Scheme of assessment (customize scheme as per requirement of your problem statement)

a) Program Design and Conceptual Clarity (Clear identification of the key concepts, Explanation
of the logic and methodology used and organization of the program.) - 10
b) Implementation and Execution - 30
c) Best Practices (Code Readability and Error Handling )- 10

TotalMarks 50

Signature of the Course Coordinator Signature of the HOD

9. SEE- Model Practice Question Paper
Program Semester 3
Computer Science and Engineering
Course Name Course Code 25CS33I Duration 180
Data Structures using
min
python
Questions CO Marks
1. Design a student grade management system for your college to track and
manage student grades. Let the system designed by you include the following
requirements.
• Add new student records with their name, subject, and grade.
1, 2, 3, 4,
• Update a student's grade if there was a mistake. 50
5
• Search for a student’s grade by their name or subject.
• Calculate and display the average grade for all students.
The system should handle errors, such as trying to update or search for a non-
existent student, and offer a simple menu for interaction.
Scheme of assessment (customize scheme as per requirement of your problem statement)

a) Program Design and Conceptual Clarity (Clear identification of the key concepts, Explanation of the
logic and methodology used and organization of the program.) - 10
b) Implementation and Execution - 30
c) Best Practices (Code Readability and Error Handling )- 10

Total Marks 50

1) Signature of the Examiner 1 2) Signature of the Examiner 2

10. Suggestive practice programs:

The List is an Example and not inclusive of all possible activities of the course. Student and Faculty are
encouraged to choose activities that are relevant to the topic
week Suggestive practice programs

01
1. Build a system to store email addresses of users subscribing to a newsletter.
● No duplicate email addresses are allowed.
● Add new email addresses.
● Check if a specific email address is already subscribed.

2. Given two classes, store the register no. of students in each class using sets. Find students
who are common to both classes.
● Perform an intersection operation to find common students.
● Perform a union operation to list all students from both classes.

02 3. Removing Duplicate Products

Problem:
Create a program to store product IDs of items in a warehouse. Use sets to ensure there are no
duplicate product IDs.
Tasks:
● Add product IDs to the set.
● Display all unique product IDs.
4. Storing Personal Information
Problem:
Create a program to store and display personal information of individuals. Each person’s data
 should be stored in a tuple (Name, Age, City).
Tasks:
● Access specific fields (e.g., print only the name of each individual).
● Try modifying an entry to demonstrate immutability.
1. Storing Favorite Books
Problem:
Write a program to keep track of your favorite books using a list.
Tasks:
● Add books to the list.
● Remove a book if it’s no longer a favorite.
● Display all favorite books.
2. Tracking Progress in a Game
Problem:
Store the levels completed in a game as a list.
Tasks:
● Add a level when it’s completed.
● Display the total number of levels completed.
● Access the last completed level using negative indexing.
03 3. Storing Product Prices
Problem:
Store the prices of products in a store using a dictionary. Use the product name as the key and
the price as the value.
Tasks:
● Add new products and their prices.
● Retrieve the price of a specific product.
● Update the price of a product.
4. Mapping Country Codes to Names
Problem:
Create a dictionary to map country codes (e.g., "US", "IN", "GB") to their respective country
names.
Tasks:
● Add new country codes and names.
● Retrieve the name of a country given its code.
1. Validating Email Addresses
Problem:
Write a program to check if an email address is valid.
Tasks:
● Check if the email contains "@" and ".".
● Validate the length of the email address.
● Extract the username and domain name.
2. Counting Words in a Sentence
Problem:
04 Write a program to count the number of words in a sentence.
Tasks:
● Split the sentence into words.
● Count and display the total number of words.
3. Writing a Daily Journal
Problem:
Create a program to maintain a daily journal. Each entry should be written to a file named
journal.txt.
Tasks:
● Take a journal entry as input from the user.
 ● Append the entry to the file with a timestamp.
● Display the content of the journal.
4. Writing and Reading a Shopping List
Problem:
Create a program to store and retrieve a shopping list.
Tasks:
● Write the shopping items to a file named shopping_list.txt.
● Read and display the list from the file.
● Add new items to the file.
1. Dividing Two Numbers
Problem:
Write a program to divide two numbers entered by the user.
Tasks:
● Handle the ZeroDivisionError if the user attempts to divide by zero.
● Display an appropriate error message when an invalid input is entered (e.g., non-
05 numeric values).
2. Validating User Input
Problem:
Write a program that asks for a user's age and checks if it is a valid number.
Tasks:
● Handle invalid input errors (e.g., non-numeric values) using ValueError.
● Display an appropriate error message if the input is not a valid integer.
1. Factorial Calculation
Problem:
Write a program to calculate the factorial of a number using recursion.
Tasks:
● Prompt the user to input a number.
● Calculate the factorial of the number using a recursive function.
● Display the result.
06
2. Fibonacci Sequence
Problem:
Create a program to generate the nth number in the Fibonacci sequence using recursion.
Tasks:
● Prompt the user for the position (n) in the Fibonacci sequence.
● Use recursion to find the nth Fibonacci number.
● Display the result.
Library Management System (ADT and UDT)
Problem:
Create a library system where you can keep track of books. Implement a Book class (UDT) and
use a List (ADT) to manage the collection.
07 Tasks:
● Define a Book class with attributes like title, author, ISBN, and availability.
● Create a list of Book objects and allow adding, removing, and searching books by title or
ISBN.
● Implement the option to check the availability of books and issue books to users.
Parentheses Balancing
● Problem Statement: Implement a program to check whether the parentheses in a
mathematical expression are balanced using a stack. For example, the expression (a +
08 b) * (c + d) is balanced, while ((a + b) * (c + d) is not.
● Key Features:
○ Push each opening parenthesis onto the stack.
○ Pop when encountering a closing parenthesis, and check if it matches the
 opening parenthesis at the top of the stack.
○ If the stack is empty at the end of the expression, the parentheses are
balanced.
Ticket Reservation System
● Problem Statement: Create a ticket reservation system for a bus service, where
passengers are served in the order of their booking. New bookings are added to the
queue, and they are processed in the same order.
09
● Key Features:
○ Enqueue: Add new ticket bookings to the queue.
○ Dequeue: Process bookings in the order they were made.
○ Peek: View the next booking to be processed.
Implement a Shopping Cart
● Problem Statement: Build a simple shopping cart system where each item has a product
name and price. The cart should allow adding new items, removing items, and displaying
the current contents of the cart.
10
● Key Features:
○ Add new items (product name, price) to the cart (insert at the end).
○ Remove an item by product name (delete by value).
○ Display all items in the cart (traverse the list).
Train Carriage System
● Problem Statement: Implement a train carriage system where each node represents a
train carriage, and the train can move forward or backward by attaching or detaching
carriages.
11
● Key Features:
○ Add carriages to the front or back of the train.
○ Remove carriages from the front or back.
○ Move through the carriages (using both forward and backward traversal)
Family Tree Representation
● Problem Statement: Create a family tree where each person has a name and a list of
children (if any). The root of the tree represents the oldest ancestor, and each node
represents a person.
12 ● Key Features:
○ Add family members and their relationships (parent-child).
○ Traverse the tree to display the family history (e.g., ancestors or descendants).
○ Find all children of a specific person.
○ Search for a person in the family tree.
Family Tree Representation (Pre-order/Post-order Traversal)
● Problem Statement: Implement a family tree where each node represents a family
member, and each member can have multiple children. Use pre-order and post-order
traversal to display family members.
13 ● Key Features:
○ Add family members and their relationships (parent-child).
○ Use pre-order traversal to display the root family member followed by their
descendants.
○ Use post-order traversal to display descendants first, followed by the ancestor.
 11. Rubrics for Assessment of Activity(Qualitative Assessment)
Sl. Dimension Excellent (10) Good (8) Satisfactory (6) Needs Improvement Score
No. (4 or below)

9-10 7-8 5-6 <=4

1 Understanding Demonstrates thorough Shows good Demonstrates basic Lacks understanding of 8

of Concepts understanding of understanding of understanding but concepts or is unable to
underlying concepts concepts with minor struggles with explain them clearly.
and explains them gaps. deeper
confidently. applications.
2 Implementatio Writes efficient, well- Writes functional Writes basic code Writes poor or non- 6
n Skills structured, and and mostly clean with some functional code with
commented code with code with minor inefficiencies and little to no structure or
appropriate logic. inefficiencies. lack of comments comments.
or structure.
3 Teamwork/ Actively collaborates, Participates well, Participates Does not participate in 7
Collaboration contributes ideas, and shares ideas, and minimally and may teamwork or creates
supports peers collaborates with not engage fully disruptions within the
effectively. minor lapses. with peers. team.

4 Presentation of Explains the results and Presents results with Struggles to explain Fails to present results 9
Results process clearly with minor inaccuracies or results clearly or clearly or shows lack of
accurate conclusions. gaps in explanation. makes incorrect understanding of the
conclusions. process.

5 Adherence to Completes the task well Completes the task Completes the task Fails to complete the 10
Time within the allotted time on time with minor with significant task within the allotted
with no compromise on compromises in delay or time or quality is highly
quality. quality. compromises in compromised.
quality.
TOTAL 40

Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

12. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quanti

ty
01 Computers i3 or i5 30
02 Internet Connection 100 Mbps
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Semester 3
Engineering
Course Name System and Network Type of Course Integrated
Administration
7 Hours per week
Course Code 25CS34I Contact Hours
Total 91
Teaching Scheme 3:0:4 Credits 5
CIE Marks 50 SEE Marks 50 (Practice)

1. Rationale:
The course System and Network Administration is designed to equip learners with the
skills and knowledge required to manage, maintain, and troubleshoot computer
systems and networks. By combining theoretical knowledge with hands-on practice,
this course prepares learners for a critical role in the IT infrastructure of
organizations. As technology forms the backbone of modern organizations, proficient
administrators are critical to ensuring systems remain secure, reliable, and efficient.

2. Course Outcomes: At the end of the Course, the student will be able to:

Identify hardware specifications & assemble a computer as per given technical

CO-01
specifications.
Install an Operating system, configure and modify administration settings, carry out basic
CO-02
troubleshooting & performance monitoring
Comprehend the file system, accomplish Formatting & Partitioning a storage drive, back
CO-03
up data and use file systems' recovery tools effectively.
Configure Network, check and update network administration settings, provide basic
CO-04
network security & sharing activities.
Plan Layout for setting up Lab & follow e-waste protocols while disposing computer
CO-05
hardware, to ensure compliance with all required state pollution control board
regulations.
 3. Course Content
Week CO PO Lecture(3HRS) Practice(4HRS)
(Knowledge Criteria) (Performance Criteria)

Computer hardware Hardware Identification:

categories & their usage. 1. Computer Case- Types, Features
2. Identify the front and rear panel
External components controls and ports on a PC
Input devices cabinet.
Output devices
3. A look inside the computer case.
4. Identify different cables and
Internal components
1 1 1 Processing devices CMOS battery, front & back panel
Storage devices connectors, power connectors.
Network devices 5. Identify Storage devices(Hard
disk, SSD), PSU, Cooling systems
Cables and connectors & their connection to the
used with computers motherboard.
6. Identify the networking devices
connected to the computer.

Power supply unit - SMPS 1. Unmount the power supply from

What is SMPS? the PC cabinet. Identify the types
Need for SMPS of output connectors.
SMPS parts and connectors.
2. Identify output voltages using
Working principles of SMPS
Types of SMPS color coding.
SMPS voltage color codes 3. Measure voltage levels using a
Measuring SMPS voltage multimeter.
2 1 1,5
levels. 4. Mount the power supply into the
How to choose right power PC cabinet, connect different
supply for PC components and test the PC.
Common issues in SMPS.
5. Troubleshoot Power supply
Troubleshooting common
problems in SMPS through SMPS fan.
6. Diagnose power supply faults
using PSU Tester.

Exploring Motherboard 1. Identify various components of

the motherboard.(Draw
What is a motherboard? motherboard layout)
Types of motherboard(Form
2. Compare motherboards of
factor)
Components of Motherboard various types
How does a motherboard 3. Precautions to be taken before
3 1 1,5 work? removing the motherboard from
Main functions of the PC cabinet.
motherboard 4. Using the CPUID CPU-Z tool, find
different features of the CPU.
Popular Motherboard
5. Check the Electric flow path and
Manufacturers.
Desktop motherboard Vs Laptop data flow path
motherboard
 6. Using Windows resource
Common motherboard issues monitor to troubleshoot
and maintenance. performance issues.
Mother troubleshooting
7. Using the CPUID CPU-Z tool,
techniques
Usage of CPUID CPU-Z tool. identify the CPU cache features
of your working system.

Chipset Architecture and 1. Hands-on identification of

components Northbridge and Southbridge
Northbridge chips on motherboards
Southbridge
2. Identify the components
Booting process connected to the north bridge
(FIRMWARE) and south bridge.
3. Implement basic power
• POST: management features using
4 1 1,4,5 • BIOS/UEFI BIOS/UEFI settings.
• Bootloader Execution
4. Checking System Information in
• OS Kernel Loading
• System Processes BIOS/UEFI & Change the Boot
Initialization Order
• User Authentication 5. Analyze the chipset design of a
specific device (e.g., smartphone,
laptop) and suggest
improvements

Operating System 1. Install and boot Windows 10/11

Installation or any Linux OS
Creating OS Image (Bootable 2. Modify basic admin settings like:
Device)
a. Changing Desktop Background
Operating system : Functions
and types b. Inverting and rearranging
5 2 1,2,5 Understanding file systems screen
and partitions c. Testing Microphone
3. Document OS installation
procedures
Windows
Linux

Windows Command line 1. Using command prompt or

interface powershell,
Basic Navigation commands Execute basic navigation
File and directory commands,
management commands Execute file and directory
writing simple PowerShell management commands.
6 2 1,2,4,5 scripts. 2. Use command line to encrypt
File security. and decrypt files and folders
3. Adding, modifying, and deleting
User Account and Permission user accounts.
Management 4. Windows: Using User Accounts
in Control Panel or via
User Profile Issues: Create a PowerShell (New-LocalUser,
 New Profile,Profile Repair Set-LocalGroup).
5. Create a New Profile, Profile
Repair
6. Scripts in powershell like
read/write data from
console/file

OS configuration and 1. Solve system startup issues

Administration using Safe Mode, Automatic
Repair, System Restore, system
System Startup Issues and reset, Image recovery
solutions: Safe Mode, 2. Check and/or Solve
Automatic Repair, System Performance Issues using Task
Restore, system reset, Image Manager, Resource Monitor,
recovery Event Viewer, Disk Cleanup,
7 2 1,2,4,5
Check for Malware, Update
Performance Issues: Task Drivers, Check Disk Health
Manager, Resource Monitor, 3. Document about “Blue Screen of
Disk Cleanup, Check for Death (BSOD), or bluescreen
Malware, Update Drivers,
error”
Check Disk Health
4. Document about “white screen
error”

File system 1. Practice data recovery methods

overview, file systems, types,
2. Working with a task manager to
properties, conversion from
one file type to another troubleshoot configuration and
(ex:.doc/docx to pdf)
other performance related
Configuring system: Disk
partitioning, Shrink, extend. issues. (Startup tasks and auto
Data recovery: Recover files,
services) using comand line and
recover apps and the
8 3 1,2,4,5
registry; GUI
Recover Windows 10/11.
3. Working with a task scheduler.
Configure and manage
windows updates: 4. Customizing windows desktop
auto/manually; testing and
5. System restore
troubleshooting updates.
Setting up file permissions (NTFS in
Windows)

Monitor and manage: 1. Monitor the processes, System

Performance monitoring; performance using Task
optimize windows services; manager (Windows)/ Process
tune scheduled tasks.
related Commands in Linux.
Customizing windows
9 3 1,2,4,5 desktop. 2. Troubleshoot the system
File and System delaying for booting (disabling
Corruption: unnecessary Startup
• System File Checker applications, Services)
(SFC) 3. Work with task scheduler:
• Deployment Imaging
 Service and Windows/Linux
Management Tool 4. Install printer driver,
(DISM) 5. Network driver disable/ enable,
• Check Disk Utility
6. System driver update
Drivers Management:
Device drivers, Network
drivers, System drivers

Network Configuration and 1. Configure Network Connections,

Management : IP Addressing
Configure IP Settings, Set DNS
( Static IP Addressing:
Dynamic IP ), Subnetting, Server, Network Adapter
DNS Configuration, Gateway
Information, Disable or Enable
Configuration,VLAN
Configuration Network Adapter.
2. Ping, Trace Route, Checking
Network Troubleshooting:
Identify the Problem, Establish Open Ports, Network Statistics,
a Baseline,Check Physical
Flush DNS Cache, Reset TCP/IP
Layer,Verify the Data Link
Layer,Test Network Stack,
10 4 1,2,3,4,5 Connectivity,Use
3. Windows Firewall
Traceroute,Check IP Address
Configuration,DNS Resolution Configuration, Configure
Issues,Examine Firewall and
Network Profiles, Manage
Security Settings
Wireless Networks
Network Security: Firewall,
4. Share any Files and Folders
Network profile, Managing
wireless network with other System in the
network.
Network Sharing
5. Access another computer using
remote desktop app

Network Monitoring and 1. Monitor network activity using

Reporting: Monitor Network
Task manager and resource
Activity, View Network Usage
monitor
Advanced Network
2. Install a VM(Hypervisor)
Configuration: Create and
Manage Virtual Networks document VM Network
11 4 1,2,4,5 (Hyper-V Manager), Manage Utilization Metrics
Routing (Modem) and 3. Run basic network commands in
Remote Access guest OS installed on VM
4. Download and install any third
Virtual Private Network: party VPN app and connect
Definition, Types of VPN,
Implementation internet through VPN

12 5 7,8 E-waste management: • Visit https://greene.gov.in and

 E-Waste: Definition and https://kspcb.karnataka.gov.in/
types of electronic waste
to find the latest regulations and
(e.g., computers,
smartphones, home policies taken up by the
appliances).
Government of India.
Global statistics on e-waste
generation. • Visit a nearby e-waste
Environmental and health
management plant and
impacts of improper e-waste
management. understand the management
E-Waste Management
process.
Lifecycle:
Lifecycle of electronic
• Document how to reduce carbon
devices: production, usage,
and disposal. footprint
Processes in e-waste
recycling: collection, sorting,
and recovery.
Policies and Regulations on
E-waste: Global e-waste
policies
National laws and policies on
e-waste

Mini Project Activity- Design and document a layout and

Layout Management Setup a computer lab in your
Lab setup Management: Polytechnic along with safety measures
13 1,2,3,4,5 1,2,3,4,5,6 Resource purchase, and all necessary applications and
Installation, Electrical safety network security measures.
measurement

4. Learning resources:
Week References
01 https://discover.hubpages.com/technology/The-Four-Main-Categories-Of-Computer-
Hardware-Parts
https://www.javatpoint.com/what-are-the-computer-cables
02 https://www.intel.com/content/www/us/en/gaming/resources/power-supply.html
https://en.wikipedia.org/wiki/Switched-mode_power_supply
https://www.amd.com/en/resources/support-articles/faqs/GPU-104.html
03 https://www.geeksforgeeks.org/what-is-a-motherboard/
https://www.studocu.com/en-us/document/purdue-university-global/information-technology-
concepts/12-exploring-motherboards-processors-and-memory/37160479
04 https://www.baeldung.com/cs/chipset
https://www.javatpoint.com/booting-in-operating-system
https://learn.microsoft.com/en-us/windows-hardware/drivers/bringup/boot-and-uefi
05 https://www.javatpoint.com/how-to-install-windows-10
https://answers.microsoft.com/en-us/windows/forum/all/steps-to-install-windows-
10/a499989c-f31f-49d0-8dbb-3b6425a5f47b
https://www.geeksforgeeks.org/how-to-install-ubuntu-desktop/
06 https://learn.microsoft.com/en-us/windows-server/administration/windows-
commands/windows-commands
https://www.freecodecamp.org/news/command-line-commands-cli-tutorial/
 https://www.geeksforgeeks.org/most-useful-cmd-commands-in-windows/

https://devblogs.microsoft.com/scripting/table-of-basic-powershell-commands/
07 https://learn.microsoft.com/en-us/troubleshoot/windows-client/performance/windows-boot-
issues-troubleshooting
https://learn.microsoft.com/en-us/troubleshoot/windows-client/performance/windows-
startup-issues-troubleshooting
https://support.microsoft.com/en-us/windows/system-configuration-tools-in-windows-
f8a49657-b038-43b8-82d3-28bea0c5666b

08 https://learn.microsoft.com/en-us/windows-server/storage/disk-management/overview-of-
disk-management
https://support.microsoft.com/en-us/windows/windows-file-recovery-61f5b28a-f5b8-3cc2-
0f8e-a63cb4e1d4c4
09 https://support.microsoft.com/en-us/windows/system-configuration-tools-in-windows-
f8a49657-b038-43b8-82d3-28bea0c5666b
https://support.microsoft.com/en-us/windows/update-drivers-manually-in-windows-ec62f46c-
ff14-c91d-eead-d7126dc1f7b6
10 https://learn.microsoft.com/en-us/training/paths/configure-networking-windows-clients/
https://support.microsoft.com/en-us/windows/change-tcp-ip-settings-bd0a07af-15f5-cd6a-
363f-ca2b6f391ace

https://support.microsoft.com/en-us/windows/setting-up-a-wireless-network-in-windows-
97914e31-3aa4-406d-cef6-f1629e2c3721
https://learn.microsoft.com/en-us/windows/security/operating-system-security/network-
security/windows-firewall/

https://www.windowscentral.com/8-networking-command-tools-every-user-should-know-
windows-10
11 https://www.vmware.com/topics/virtual-networking
https://www.kaspersky.com/resource-center/definitions/what-is-a-vpn

12 https://greene.gov.in/
https://kspcb.karnataka.gov.in/

5. CIE Assessment Methodologies

Duration
Sl. Tes Max
CIE Assessment (minutes
No t
) marks
We
ek
1. CIE-1TheoryTest 4 90 50
Average of all
2. CIE-2 Practice Test 7 180 50 CIE=50 Marks
3 CIE-3 TheoryTest 10 90 50

4. CIE-4 Practice Test 13 180 50

CIE-5 Portfolio evaluation of

5 all the activities through 1-13 50
Rubrics
Total 50 Marks
6. SEE – Practice Assessment Methodologies
Duration
Sl.No Max
SEE – Practice Assessment (minutes) Min marks to
marks
pass

1. Semester End Examination- 180 50

20
Practice

7 CIE Theory Test model question paper

Program Computer Science and Engineering Semester -III
Course Name System and Network Administration Test I
Course Code 25CS34I Duration 90 Mark 50
min s
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Q.No Questions Cogni Cours Mar
tive e ks
Level Outco
me
Section - 1
a) Categorize the given devices/components into multiple L3 1 25
categories i. Mouse ii. Phone Display iii. RAM iv. RJ45 v. Flash Drive
vi. NIC vii. Printer viii. Projector ix. Cache
-05

b) Ajay a computer science diploma II year student. One of his L3 1

1 friends wanted to buy a new desktop, so he asked Ajay’s
suggestions, feeling he might know more about computers. What
are your suggestions to him with respect to hardware? -10

c) Compare the hardware components of a computer with your

mobile phone. -10 L2 1
a) How can you diagnose power supply faults using PSU Tester? L3 1
5
L3 1
b) Rachana was sitting on a plastic chair before trying to check the
2 system unit cabinet. Though the power supply is not connected she
got an electric shock. How can you analyze this problem? What are
the safety measures for this? (static electricity) -10
L2 1
c)How does SMPS work? -10
Section – 2
a) Anil and Hruthvik are debating whether the north bridge is 1 25
faster or the south bridge is faster? How can you conclude it?
Justify your answer. -05 L3
b) One of the computers in your lab was hanged when Vedant ran L3 1
application ‘X’. He doesn't want to restart the computer but has to
3
kill application ‘X’ . How can you help him? -10

c) Khushi wants to install an operating system from his pen drive. L3 1,2
But it is not loading. Someone told her to change it to BIOS. She
does not understand it clearly. Can you help her with this regard 10
a) How can you differentiate single boot virtual machine L2 1,2
4 installation? -5
L2 1,2
 b) Compare windows/Linux OS with android OS -10

c) Rehman installed an older version of the operating system on his L3 1,2

computer. Some of his hardwares like Wi-Fi, is not working. How
can you resolve this issue? (Chipset not installed) -10
Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional questions in each
section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program Computer Science and Engineering Semester 1
Course Name System and Network Administration Test II

Course Code 25CS34I Durati 180 Marks 50

on min
Name of the Course Coordinator:

Questions CO Mar
ks
50
1. You are instructed to install newer version of Operating system in a 1,2,3
computer in your lab. Decide the OS, document hardware requirement
for the same, before installing the OS check the BIOS/UEFI settings and
do necessary updates in it. Install OS on right PC. Create a new account
name CSE_LAB1_01 with a strong password

Scheme of assessment

a) Choosing OS and document Hardware 10

b) BIOS/UEFI settings 10
b) Installation of OS and related operations 15
c) OS related operations 10
d) Portfolio Evaluation 05
TotalMarks 50

Sign of the Course Coordinator Signature of the HOD

9. SEE–Model Practical Question Paper

Program Computer Science and Engineering Semester
Course Name System and Network Administration Marks 50
Course Code Duration 180
Min
Questions Cognitive Course Marks
Levels Outcomes
 You are tasked with setting up and maintaining
a computer system for a small office
environment. The goal is to ensure that the
hardware components are correctly identified,
software is installed and configured, issues are
resolved efficiently, and the network is
operational for seamless communication.

Requirements:
Hardware: Verify hardware specifications and 1,2,3,4,5
Section -1 compatibility with the system requirements. L3 45
Software Installation:
Install an operating system (e.g., Windows/
Linux) on a computer.
Install essential drivers and utility software
required for system functionality
Diagnose ,resolve and document any hardware
and software issues faced
Network Configuration: Set up a basic wired
or wireless network for the office, ensuring
connectivity between devices

Section -2 Portfolio Evaluation/Viva L3 5

2) Signature of the Examiner 1 2) Signature of the Examiner 2

10. Rubrics for Assessment of Activity (Qualitative Assessment)

Sl. Dimension Excellent Good Satisfactory Needs Score

No. improvement
9-10 7-8 5-6 Below 5
1 Knowledge of Demonstrates an in- Understands most Basic Limited 8
Hardware depth understanding of hardware understanding of understanding
Components all hardware components and hardware of hardware
components, their their roles, with components but components and
roles, and minor gaps or struggles with their functions.
interconnections with inaccuracies. details or
accurate terminology. technical
terminology.
2 Configuration Configures and installs Configures and Completes Unable to 6
and Installation hardware/software installs configuration and complete
Skills accurately without hardware/software installation with configuration or
assistance, following correctly with frequent installation
industry best practices. minimal guidance; guidance; some without
few errors. errors in significant errors
execution. or assistance.
3 Troubleshooting Identifies and resolves Diagnoses and Can diagnose and Unable to 2
and Problem- issues systematically resolves most resolve basic diagnose or
Solving and efficiently using issues with minor issues but resolve issues
appropriate tools and inefficiencies or struggles with without
methods. errors more complex significant
problems. assistance.
4 Documentation Produces detailed, well- Documentation is Documentation is Documentation 3
and Reporting organized, and clear and basic, with is incomplete,
professional organized but several errors or unclear, or
documentation with no contains minor incomplete missing
 errors. errors or details. important
omissions. details.
5 Teamwork and Actively contributes to Contributes Participates in Limited 2
Collaboration team efforts, effectively to the team activities participation or
communicates team with good but lacks ineffective
effectively, and communication; initiative or collaboration in
assumes leadership may rely on others effective team tasks.
when necessary. for leadership. communication.
Total/50 21/50
Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

11. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quantit

y
01 Computers 10
02 PSU Tester 10
03 Multimeter 10
04 Individual components- SMPS/PSU 400 watts 10
05 Individual components- SMPS/PSU 800 watts 10
06 Motherboard ATX 10
07 Motherboard Micro ITX 10 10
08 RAM stick DDR3 10
09 RAM stick DDR4 10
10 CMOS battery 10
11 Windows 10/11 OS user license for multi users -
12 POST diagnostic card 10
SEMESTER 4
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Semester 4
Engineering
Course Name Operating System & Type of Course Integrated
Administration
8 per week
Course Code 25CS41I Contact Hours
Teaching Scheme 4:0:4 Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale:
This course provides a comprehensive introduction to the fundamental concepts of operating
systems, Linux operating system and shell programming including their structure, functionality,
and design principles. Students will gain hands-on experience with process management,
memory management, file systems, and learn how to navigate and utilize Linux environments,
and write scripts to automate tasks and manage system resources effectively.

2. Course Outcomes: At the end of the Course, the student will be able to:
Understand and analyze basic concepts of Operating system and memory management
CO-01
technique and virtualization
Analyze and apply process management and scheduling techniques and understand file
CO-02
systems.
Explore and communicate technical concepts related to storage, networking, and security
CO-03
Perform basic system administration tasks like monitoring system performance, managing users,
CO-04
and handling permissions using shell scripting.
Analyze the power and energy-efficient optimization strategies in OS and Implement cloud-
CO-05
based solutions for advanced OS technologies.

3. Course Content
Week CO PO Theory Practice

Introduction to Operating Systems- 1. Demonstrate the installation of

 Overview of Operating System Windows & Linux OS
 Need for OS, Structure 2. Demonstrate Boot methods
using videos
 OS Types (Batch, Multitasking, Real-
1 time, Distributed, etc.) 3. Demonstrative videos on File
System and formatting
 Types of OS installation
4. Explore the post installation
1  Dual mode operation
tasks.
 Kernel and microkernel
 Functions of OS (resource
management, process management,
memory management, etc.)
 Booting process and system
initialization
2 1 Install and configure configuring
 Memory management- virtual machines (VMs)
 Memory Organization: RAM, Cache 2 Download and install a terminal
Memory, Virtual Memory emulator
 Memory Allocation: Contiguous 3 Demonstration through videos.
1,2 Memory Allocation, Paging and Page 4 Commands to view memory
Tables, Segmentation consumption(free, free –b, free –
Virtualization technology- k, free –g)
 Definition and importance of
virtualization
 Virtual Memory: Demand Paging, Page
Replacement Algorithms (FIFO, LRU,
Optimal, and Clock algorithms)
File system – File and Directory commands:
 Definition and role of file systems in 1. Create and delete directories
operating systems and files, File movement, copy
2  Types of file systems (local vs. commands, Pipes
distributed) 2. Commands for viewing File, File
 File system security issues comparison, File manipulation,
3  Access control lists (ACLs) vs. File Altering file permission, File
permissions compression and decompression.
 Next-generation file systems (e.g., 3. Text processing
Fusion File System, F2FS for SSDs) commands(grep,sort,uniq,cat,cut,
paste,head,tail,wc,tr).
 The role of AI in file system
management
Process Management – 1 process creation and
 Definition and components of a management commands - system
process calls fork() and exec(); bg, fg, pkill,
 Process states and state transitions nice, top, ps.
(new, ready, running, waiting,
3
terminated)
4
 Process control block (PCB)
 Process scheduling (long-term, short-
term, and medium-term scheduling)
 Inter-process communication (IPC):
shared memory, message passing

Process Synchronization and 1. Demonstration through videos.

Concurrency- 2. Commands to exhibit thread
 Critical Section Problem concepts. (top, htop, and ps to
Synchronization Mechanisms: monitor system threads).
 Semaphores: Binary and counting. 3. Design a system to prevent
3
 Monitors and Condition Variables. deadlock in a multi-processing
5
Deadlock: environment using resource
 Necessary Conditions for Deadlock. allocation graphs or safe states.
 Deadlock Prevention and Avoidance
Strategies.
 Resource Allocation Graphs.
 Deadlock Detection and Recovery
 I/O Management and Disk Scheduling- 1 Monitoring I/O on a System:
 I/O Devices and Device Drivers: Types command in Linux is used to
3,4 of I/O devices: Hard Disk, Keyboard, monitor CPU and I/O
Display, Printers. statistics(iostat, iotop, dstat)
Role of Device Drivers in OS. 2. Discuss the impact of
 Types of Buffers: Single, Double, fragmentation on both read and
Circular. write operations and how the
6 operating system can mitigate
 Importance of Buffering in I/O
Operations, fragmentation.
 Direct Memory Access (DMA): 3.
Overview of DMA.
 Use of DMA in I/O operations.

Storage management: 1. Basic commands for storage

• Disk partition, formatting, mounting; partitions.
• Logical Volume Management (LVM)- 2. Install and configure LVM.
Use of LVM, creating Volume groups, 3. Simulate RAID configurations
7 logical volume and disk mirroring, and understand how data is
• Extend Disk using LVM, Adding Swap stored and recovered.
3
Space
• Introduction to RAID – Hardware &
Software, RAID levels
Networking, security and protection in 1. Work on user accounts:
Operating System: useradd, passwd, userdel,
Networking Basics: usermod,groupadd,
• Sockets and networking in OS groupmod,gpasswd, groupdel;
• Remote Procedure Calls (RPC) system-config.
8
• Distributed File Systems (DFS)
3 • Security Principles
• Authentication, Authorization, and
Access Control
• Encryption and Data Integrity
• User Authentication
• Passwords, multi-factor authentication

Linux administration 1.Use mkdir to create a new

directory named OS_lab.
4 • History and Overview of Linux 2.Navigate into the OS_lab
• Basic Linux Commands (ls, cd, cp, mv, directory using cd.
rm, mkdir, rmdir) 3.Create subdirectories named
• Permissions and Ownership data, scripts, and logs
9
• File Types and Attributes
4. Demonstrate grep
• Working with Files and Directories
(find, locate, grep, tar, zip/unzip) 5. use text processing cmd cat,
• Text Processing Utilities (cat, more, more, head.
less, head, tail, grep etc)

10 Shell Programming 1.Use variables and take user

 • Shell Overview and Types (Bash, Zsh, input in a script.
Ksh, Tcsh) 2. Write a shell script that prints
• Role of the Shell in Unix-like OS “Shell Scripting is Fun!” on the
• Basic Shell Commands (ls, cd, pwd, cat, screen
echo, etc.) 3. Write a script to print a given
• Shebang (#! /bin/bash) in scripts number in reverse order.
• Writing Simple Shell Scripts
4 • Creating variables, accessing variables
using $ and ${}, Special variables ($1,
$2, $#, $@, $?)

• Input/Output, and Control Structures

Advanced Shell Scripting 1.Write a basic shell script to

automate a task.
• Functions and Error Handling 2.Write a shell script to check to
• Arrays and String Manipulation see if the file “file_path” exists. If
• Script Debugging Techniques it exist, display “file_path
• Advanced Topics: Process Substitution, passwords are enabled.” Next,
Command Substitution check to see if you can write to
the file. If you can, display “You
have permissions to edit
11 4 “file_path.””If you cannot, display
“You do NOT have permissions to
edit “file_path””
3. Write a shell script that consists
of a function that displays the
number of files in the present
working directory. Name this
function “file_count” and call it in
your script.

Performance and Optimization 1. Consider an application that

Performance Evaluation simulates a large number of
System performance metrics: CPU particles interacting with each
utilization, throughput, latency other in a physics-based
5
simulation. How would you
System Tuning
use multicore processing and
Kernel tuning, memory tuning
multithreading to speed up
Multicore and Multithreading the simulation? Outline the
Parallel computing models and threading steps to divide the work into
12 Energy-Efficient Operating Systems parallel tasks and ensure
Power management and optimization in proper synchronization.
OS 2. Using a parallel computing
2. model like the SPMD (Single
Program Multiple Data)
model, describe how you
would break down the
problem and distribute the
work across multiple threads
or processors. How would you
 ensure that data
dependencies are handled
correctly and that the
workload is balanced?
 Real-time operating systems (RTOS) 1. implement a simple real-time
and their features system and understand key
• Kernel development and module concepts of RTOS such as
programming tasks, scheduling, and
13 • OS-level debugging and profiling tools interrupts.
5
• Cloud-based operating systems (Google 2. understand the concept of
Fuchsia, Chrome OS) cloud-based operating
systems, their architecture,
 Emerging OS technologies
and the benefits of using cloud
(Microservices architecture,
OS in real-world applications.
Containers)

4.Learning Resources
Sl No References
1 Operating System Concepts by Silberschatz, Galvin, and Korth
2 Supplementary Text: Modern Operating Systems by Andrew S. Tanenbaum
3 The Linux Command Line: A Complete Introduction by William E. Shotts Jr.
4 Advanced Programming in the UNIX Environment by W. Richard Stevens, Stephen A. Rago
5 Supplementary Text: Bash Cookbook by Carl Albing, JP Vossen
6 https://methodist.edu.in/web/uploads/labmanual/OS%20Lab%20Manual.pdf
7 https://it.mitindia.edu/PDF/manuals/IT7411.pdf
8 https://people.iitism.ac.in/~download/lab%20manuals/cse/CSC211.pdf

5. CIE Assessment Methodologies

Duration
S Tes Max
CIE Assessment (minutes
l t
) marks
. We
N ek
o
1. CIE-1TheoryTest 4 90 50 Average of all
CIE=50 Marks
2. CIE-2Practice Test 7 180 50

3 CIE-3TheoryTest 10 90 50

4. CIE-4Practice Test 13 180 50

CIE-5 Portfolio evaluation of

5 all the activities 1-13 50
through
Rubrics
Total 50 Marks

6. SEE - Theory Assessment Methodologies

Duration
Sl.No Max
SEE – Theory Assessment (minutes) Min marks to
marks
pass
1. Semester End Examination- 90 50
20
Theory
7. CIE Theory Test model question paper
Program Computer Science and Engineering Semester -4
Course Name Operating System & Administration Test
Course Code 25CS41I Duratio 90 min Marks 50
n
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitiv CO
Q.No Questions Marks
e Level
Section - 1
a) What are the major components of an operating L2 1
system
b) How does an operating system manage hardware L3 1
1 resources like CPU, memory, and I/O devices
c) What is a virtual machine, and how does an OS L2 2
support virtualization?
a) Why is it necessary for an operating system to have L2 1 25
both User Mode and Kernel Mode
b) What is a system call, and how does it interact with L2 1
the OS
2 c) How does a Command-Line Interface (CLI) differ from L3 2
a Graphical User Interface (GUI) in terms of functionality
and user experience?

Section - 2

a) In what scenarios would you choose Shortest Job L2 25

First (SJF) over First-Come, First-Served (FCFS)

b) What factors influence the time taken during a L2

context switch, and how can this time be minimized?

c) Consider the following processes with their arrival L3

times and burst times using FCFS Problem.

i) Calculate the completion time, turn-around time, and

3 waiting time for each process

ii) Find the average turn-around time and waiting time

for the processes.

Process Arrival Burst

Time Time
 P1 0 8
P2 1 4
P3 2 9
P4 3 5

a) Explain any algorithms used for detecting deadlocks. L2

b) Explain the two main types of threads supported by L2
most operating systems
c) Using the Round Robin scheduling algorithm, L3
determine the order in which the processes will be
executed.
Calculate the average turnaround time and waiting time
for the processes.
4
Process Burst Time

P1 10
P2 5
P3 8
P4 6

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program Semester 4
Computer Science and Engineering
Course Name Test
Operating System & Administration
Course Code 25CS41I Duration 180 min Marks 50

Name of the Course Coordinator:

CO Marks
Questions
1) Write a shell script to generate a multiplication table of the given number.
2) Write a shell script to display files which has read, write and execute 4 10
Permissions
4 10
3.) Execute commands - system calls fork() and exec(); bg, fg, pkill, nice, top, ps.

4)We need to synchronize files between two directories: /source_dir and 2 10

/backup_dir. The synchronization should ensure that:

 Any new or modified files from /source_dir are copied to /backup_dir. 4 20

 Deleted files from /source_dir should also be removed from /backup_dir.
 The script should be able to run automatically at regular intervals (e.g., every
hour).
 Any issues (e.g., files that couldn't be copied) should be logged.

Total Marks 50
 Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

9. SEE–Model Theory Question Paper

Program Computer Science and Engineering Semester 4
Course Name Operating System & Administration Marks 50
Course Code 25CS41I Duration
90
Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitiv Course
Q No Questions Mar
e Levels Outcome
ks
s
Section -1

a) Explain different types of Operating system and L2 5

List its functions.
b) What is the difference between user space and L2 1 5
kernel space in an OS structure?
1
c) Explain how a virtual machine monitor (VMM) L3 10
interacts with the kernel and the user space of an
operating system.
a) Describe the purpose of a distributed operating L2 5
system and how it differs from a centralized operating
system. L2 1 5
b) How does a Command Line Interface (CLI) differ
2 from a Graphical User Interface (GUI)? L3 10
c) Why is Dual Mode Operation essential in modern
multi-tasking operating systems like Windows or
Linux?
Section -2

a) What is the role of the program counter in the L2 5

process Control Block?
b) Consider the following processes with their burst L3 10
times and a time quantum of 4:
i) Using the Round Robin scheduling algorithm,
determine the order in which the processes will be
executed.
ii) Calculate the average turnaround time and waiting
time for the processes. 2
3 Process Burst Time
P1 10
P2 6
P3 4
P4 1

c) What is the relationship between threads and L2 5

processes in a multi-threaded system
 a) What are the differences between deadlock L2 5
prevention, deadlock avoidance, and deadlock
detection strategies.
b) In the producer-consumer problem, how can L3 2 10
4 semaphores be used to synchronize the producer and
consumer processes?
c) Explain the state transition diagram of Process. L2 5
Section -3

a) Consider a system with 3 frames in physical L3 3 10

memory and the following reference string:
7, 0, 1, 2, 0, 3, 0, 4, 2, 3, 0, 3, 2, 4
Apply the First-In-First-Out (FIFO) page
replacement algorithm and find:
5 i)The number of page faults
ii)LRU
b) How does paging differ from segmentation in L2 5
memory management
c) Explain the basic structure of a file system L2 5
a) How do you compare the performance of different L3 3 10
disk scheduling algorithms
b) What is a directory structure, and how are files L2 5
6
organized within it
c) What is the purpose of buffering in I/O operations? L2 5
Section -4

a) After adding a new CPU-intensive application, L3 4 10

your system performance has dropped. What
steps would you take to assess whether the
CPU is a bottleneck? 10
7 b) Your laptop runs out of battery quickly, even L3
when you're not using many applications. How
would you optimize power usage to extend
battery life?
a) How do you handle error handling in shell scripts L3 4 10
b) Write a shell script to count the number of lines, L3 x
8 words, and characters in a file. 10

Section -5

a) What is a Real-Time Operating System (RTOS), L3 5 10

and how does it ensure that tasks are
completed within strict timing constraints? L3 10
9 b) How can a cloud-native OS improve scalability
and resource management in a cloud
environment?
a) How does an OS-level debugger interact with L3 5 10
system processes to troubleshoot issue.
10 b) Explain how perf can be used to profile CPU L3 10
performance, and how it helps in identifying
bottlenecks in system performance
10. Suggestive Activities for Tutorials:
The List is an Example and not inclusive of all possible activities of the course. Student and Faculty
are encouraged to choose activities that are relevant to the topic

Sl.No. Suggestive Activities for

Tutorials
Implement simple system calls like read(), write(), open(), and close(), representing
01 interaction between a user program and the kernel space.
Simulate and calculate various performance metrics such as turnaround time, waiting
02 time, and throughput for each algorithm.
Simulate a deadlock situation in a multithreaded environment (e.g., using resource
03
allocation graphs or the Banker's algorithm).
04 Simulate segmentation and paging techniques and manage memory for processes.
Implement a file allocation strategy such as contiguous allocation, linked
05 allocation, or indexed allocation.
Identify critical systems and define the procedures to recover them in the event of a
06 natural disaster, cyberattack, or hardware failure.

11. Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Beginner Intermediate Good Advanced Expert StudentsSc

No ore
. 2 4 6 8 10

1 Understandi Lack of Lack of Demonstrat Shows good Demonstrates 8

ng of Key understandin understandin es basic understandi comprehensiv
Concepts g of basic g basic understandi ng with e
concepts concepts, ng with minor errors understanding
with multiple some or missing of OS concepts
misconceptio inaccuracies details.
ns.
2 Problem Unable to Requires Solves Solves most Effectively 6
Solving solve significant problems problems solves any
problems assistance or independen independent problems that
without struggles to tly with ly, though arise during
significant resolve minimal may need the
external help. issues. guidance assistance installation/set
for complex up process
issues. with minimal
guidance.
3 Depth of Lack of Provides little Provides Provides Provides deep 2
Analysis providing analysis or limited adequate insights with
analysis with examples. analysis analysis with correct and
some with few some relevant
examples examples or examples or examples.
applications applications

4 Documentati Provides little Provides an Provides a Provides a Provides a 2

on and or no incomplete or mostly clear clear report clear, detailed
Reporting documentati unclear report with with some report or
on, or it is report, some details or documentatio
very unclear. lacking missing unclear n on the setup
sufficient details. sections. process,
detail. troubleshootin
g steps, and
results.
 Average Marks=(8+6+2+2)/4=4.5 5

Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

12. Equipment/softwarelistwithSpecificationforabatchof30students

Sl.No. Particulars Specification Quantity

01 Computers i3 or i5 30
02 Internet Connection 100 Mbps
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science & Engineering Semester 4
Course Name Object Oriented Programming with Java Type of Course Integrated
8 Hours /
Course Code 25CS42I Contact Hours Week
Teaching Scheme L: T:P Credits 6
CIE Marks 50 SEE Marks 50 (Theory)

1. Rationale

This course is designed to equip students with a comprehensive understanding of object-oriented

programming (OOP), a foundational paradigm in modern software development. The focus is on
enabling students to write maintainable, modular, and scalable code while gaining practical
experience in implementing these concepts using Java. As a versatile programming language, Java is
widely used for enterprise applications, mobile apps, and web services, making it an ideal choice for
mastering OOP concepts and SOLID principles.

2. Course Outcomes: At the end of the course, the student will be able to:
Explain the core principles of object-oriented programming and their significance in software
CO-01 development.
Create Java programs that leverage object-oriented concepts to solve real-world problems
CO-02
effectively.
Refactor code to enhance readability, maintainability, and efficiency while adhering to SOLID
CO-03
principles.
Demonstrate the use of exception handling mechanisms in Java to identify and manage runtime
CO-04
errors, ensuring application reliability.
CO-05 Establish database connectivity using Java and perform data operations

3. Course Content

Week CO PO Theory Practice

Introduction to Object-Oriented  Setting up the Java

Programming development environment
Define Object-Oriented Programming (OOP) Install JDK and set up an IDE
such as VScode
and its key objectives.  Write your first java
Principles of OOP: Encapsulation, Abstraction, program "Hello, World!"
1 1 1 Inheritance and Polymorphism
Real-world Examples of OOP
Overview of SOLID Principles
Importance of SOLID Principles
Overview of Java
Introduction to basic Java syntax: Variables,
 data types, operators, control statements

Classes and Objects  Create a class representing a

Understanding classes and objects. real-world entity.
Defining classes and creating objects in Java.  Instantiate objects and
instance variables, methods, constructors. manipulate object attributes.
Understanding this keyword.  Demonstrate constructor
S - Single Responsibility Principle usage and method calling.
Definition, intent and benefits;  Create simple Java programs
1,2,3 1,2,3 Example of violation and implement SRP by dividing
2
Example of correct SRP responsibilities across multiple
classes.
 Given sample code, check
compliance with SRP.
 Provided a simple class with a
violation of SRP, refactor the
code to adhere to SRP.
Encapsulation and Access Modifiers  Implement encapsulation by
 Introduction to encapsulation. creating classes with private
 Access modifiers: public, private, variables and public
3 1,2 1,2,3 protected, default. getter/setter methods.
 Getter and setter methods.
 Why encapsulation is important in
OOP.
Inheritance  Implement inheritance.
 Understanding inheritance.  Demonstrate method
 extends keyword and method overriding. overriding and using the super
 super keyword and constructor chaining. keyword.
 Types of inheritance  Provided a simple class with a
4 1,2,3 1,2,3
OCP - Open/Closed Principle violation of OCP, refactor the
 Definition, intent and benefits; code to adhere to OCP using
 Example of violation inheritance.
 Example of correct OCP  Given sample code, check
compliance with OCP.
Polymorphism  Demonstrate method
 Understanding polymorphism overloading and overriding
 Method overloading and method with examples.
overriding.  Implement interfaces and
 Compile-time vs runtime polymorphism. abstract classes
5 1,2,3 1,2,3
 Interfaces and abstract classes.  Use polymorphism to call
Reinforce OCP with polymorphism methods on objects of
Using inheritance and interfaces to achieve different classes.
OCP.  Code programs demonstrating
OCP with polymorphism.
Abstraction  Create an abstract class with
 Introduction to abstraction in Java. abstract methods and a
 Abstract classes vs interfaces. concrete subclass.
6 1,2,3 1,2,3  When to use abstract classes and  Provided a simple class with a
interfaces. violation of LSP, refactor the
 Real-world examples of abstraction. code to adhere to LSP.
LSP - Liskov Substitution Principle
  Definition, intent and benefits;
 Example of violation
 Example of correct LSP
Exception Handling  Write Java programs to handle
 Introduction to exception handling. exceptions.
 try, catch, finally, throw, and throws  Create custom exception
7 2,4 1,2,3 keywords. classes and use them in a
 Types of exceptions: Checked vs program.
unchecked exceptions.
 Best practices for handling exceptions.
Collections Framework - I  Create programs to
 Introduction to Java Collections manipulate collections
8 2 1,2,3
Framework.
 List, Set, Map, and Queue interfaces.
Collections Framework - II  Create programs to
 Working with ArrayList, and LinkedList. manipulate collections
 Iterators & enhanced for loop  Design an interface that builds
9 2,3 1,2,3 ISP: Interface Segregation principle different types of toys and
 Definition, intent and benefits; check Compliance with ISP.
 Example of violation
 Example of correct ISP
Multithreading  Create simple multi-threaded
 Introduction to multithreading. programs.
 Creating threads using Thread class and  Demonstrate thread
10 2,4 1,2,3
Runnable interface. synchronization using
 Thread synchronization and thread synchronized keyword.
lifecycle.
File Handling and Annotations Write a Java program that
 Introduction to file handling in Java. a. reads a text file and prints
 Reading from and writing to files its contents to the console
 Serialization & deserialization b. creates a new text file and
Java Annotations writes some content to it.
11 2,4 1,2,3  What are annotations in Java? c. append data to an existing
 Commonly used annotations (@Override, file
@Deprecated, @SuppressWarnings) handle exceptions properly.
 Custom annotations and their use cases  Write a Java program that
uses annotations to store file
paths or configurations.
Database Connectivity in Java  Performing CRUD Operations
 Overview of JDBC (Java Database using JDBC
Connectivity):  Applying DIP to Database
 What is JDBC and why is it used? Connectivity
 Basic components of JDBC: Driver,
12 3,5 1,2,3 Connection, Statement, ResultSet.
 Steps for Database Connectivity in Java
 JDBC API and Database Operations
Dependency Inversion Principle (DIP)
 Definition, intent and benefits;
 Example of violation
  Example of correct DIP
 Create a simple java
13 1,2,3,4,5 1,2,3 Mini Project
application such as To Do list

4 CIE Assessment Methodologies

Duration
Sl. Test Max
CIE Assessment (minutes)
No Week marks
1. CIE-1TheoryTest 4 90 50
2. CIE-2Practice Test 7 180 50
Average of all
3 CIE-3TheoryTest 10 90 50 CIE=50 Marks
4. CIE-4Practice Test 13 180 50
CIE-5 Portfolio evaluation of
5 all the activities 1-13 50
through
Rubrics
Total 50 Marks

5. SEE – Practice Assessment Methodologies0

Duration
Sl. Max
SEE – Practice Assessment (minutes) Min marks to
No marks
pass

1. Semester End Examination-Practice 180 50 20

6. CIE Theory Test model question paper
Program Computer Science and Engineering Semester – IV
Course Name
Object Oriented Programming with Java Marks 50
Course Code 25CS42I Duration 90 min Marks 50

Name of the Course Coordinator:

Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q.No Questions Marks
Level Outcome
Section - 1
a) Explain the concept of OOP and its key objectives. L2 1 5
b) Describe the different control statements used in Java. L2 1 5
c) Explain how Single Responsibility Principle (SRP) is
L3 2 15
violated in the below code and refactor the code to
adhere to SRP.

a) Briefly explain importance of SOLID principles. L2 1

b)
L2
1
5

5
Explain the use of different access modifiers in the
Employee class.
c) Explain how Open/Close Principle (SRP) is violated in
2 the below code and refactor the code to adhere to
OCP.

L3
2

15
 Section - 2
a) Explain with an example how encapsulation is L2 1 5
implemented in Java using getter and setter methods.
b) Write a Java program to demonstrate the use of L2 1 5
constructors and the this keyword.
c) Refactor the following code to adhere to encapsulation 2 15
L3
principles:

a) Write a Java program to demonstrate the types of L2 1 10

inheritance (single and multilevel).
c) Refactor the following real-world example of a banking
application to demonstrate the principle of abstraction.
L3 2 15

Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Signature of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman
7. CIE Practice Test model question paper
Program Computer Science and Engineering Semester IV

Course Name Object Oriented Programming with Java Marks 50

Course Code 25CS42I Duration 180 min Marks 50

Name of the Course Coordinator:

Questions CO Marks

1. Suppose you are tasked with developing a simple Library Management System in
Java that demonstrates key Object-Oriented Programming (OOP) principles and
SOLID principles. The system should allow the following operations:
a) Adding books to the library.
1,2,3,4 50
b) Borrowing and returning books.
c) Displaying available books.
d) Handling exceptions such as borrowing unavailable books or returning
books not in the library.

Scheme of assessment(Can be altered as per week wise concepts by the Faculty)

1. Writing the program by identifying and proper use of concepts - 30
a. Defining classes – 5
b. Encapsulation – 5
c. Inheritance and Polymorphism- 10
d. SRP/OCP adherence– 5
e. Exception Handling – 5
2. Final Integration and execution - 20

TotalMarks 50

Signature of the Course Coordinator Signature of the HOD

8. SEE–Model Theory Question Paper

Program Computer Science and Engineering Semester IV
Course Name Object Oriented Programming with Java Marks 50
Course Code 25CS42I Duration 90 Min
Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q No Questions Marks
Levels Outcomes

Section -1
Illustrate the concept of encapsulation with an example in
Java. Explain how access modifiers (private, protected, L2 1 10
1
public) help achieve encapsulation.
Differentiate between instance variables, class variables,
2 L2 1 10
and local variables in Java. Write a program to demonstrate
 their declaration, initialization, and scope.

Section -2
Create a class to represent a student with attributes for
3 name, roll number, and marks. Write methods to calculate L3 2 10
the grade and display the student details.
Implement a Java program to demonstrate polymorphism
4 using method overriding with examples like shape area L3 2 10
calculation.
Section -3
Write a program to read an integer array from a file
5 L2 3 10
Handle exceptions like file not found or invalid data format.
Write a program to handle file reading and parsing errors in
6 a CSV processing system. Include exception handling for L2 3 10
scenarios like missing files and invalid formats.
Section -4
Write a Java program that simulates a parking lot with a
limited number of parking spaces using multi-threading.
Each car is represented by a thread, and the car tries to park
in the lot. If a space is available, it parks. If no space is
available, the car waits until a space is free.
Requirements:
7 L3 4 10
a. Parking Lot with Limited Spaces: The parking lot has a
fixed number of spaces (e.g., 3).
b. Car Class: Each car is a thread and tries to park.
c. Main Class: The main method should create a
parking lot with a fixed number of spaces and start
multiple car threads (e.g., 5 cars).
Write a Java program to simulate a traffic light system using
multi-threading. Let each thread represents a traffic light at
8 L3 4 10
an intersection with a random time interval for red, yellow,
and green signals.
Section -5

Write a Java code for a student database using JDBC.

Implement only read operation. Use ArrayList to hold the
9 L3 5 10
results from a database query, and iterate using enhanced
for-loops.
Design a Java program to manage an online store inventory
10 using JDBC. Use collections like HashMap to store product L3 5 10
details and demonstrate search operation.

Signature of the Examiner 2) Signature of the Examiner

9. Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Excellent (10) Good (8) Satisfactory (6) Needs Score
No. Improvement (4
or below)
9-10 7-8 5-6 <=4
Demonstrates Demonstrates 8
Lacks
thorough Shows good basic
understanding of
Understanding understanding of understanding of understanding but
1 concepts or is
of Concepts underlying concepts concepts with struggles with
unable to explain
and explains them minor gaps. deeper
them clearly.
confidently. applications.
Writes efficient, well- Writes basic code Writes poor or 6
Writes functional
structured, and with some non-functional
Implementatio and mostly clean
2 commented code inefficiencies and code with little to
n Skills code with minor
with appropriate lack of comments no structure or
inefficiencies.
logic. or structure. comments.
Does not 7
Actively collaborates, Participates well, Participates participate in
Teamwork/Coll contributes ideas, shares ideas, and minimally and teamwork or
3
aboration and supports peers collaborates with may not engage creates
effectively. minor lapses. fully with peers. disruptions within
the team.
Presents results Struggles to Fails to present 9
Explains the results
with minor explain results results clearly or
Presentation of and process clearly
4 inaccuracies or clearly or makes shows lack of
Results with accurate
gaps in incorrect understanding of
conclusions.
explanation. conclusions. the process.
Completes the task Completes the Completes the Fails to complete 10
well within the task on time task with the task within the
Adherence to
5 allotted time with no with minor significant delay allotted time or
Time
compromise on compromises in or compromises in quality is highly
quality. quality. quality. compromised.
TOTAL 40
Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the
activities

10. Equipment/softwarelistwithSpecificationforabatchof30students

Sl.No. Particulars Specification Quantity

01 Computers i3/i5 30
02 Internet Connection 100mbps
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION

Program Computer Science and Semester 4

Engineering
Course Name Data Analysis and Algorithm Type of Course Integrated
Design
7 Hours per week
Course Code 25CS43I Contact Hours
Teaching Scheme 3:0:4 Credits 5
CIE Marks 50 SEE Marks 50 (Practice)

1. Rationale:
This course aims to equip learners with the essential tools and skills necessary to handle data
efficiently, apply advanced algorithm design strategies, and evaluate their performance in terms of
time and space complexity. By integrating NumPy, Pandas, Matplotlib, and algorithmic concepts, the
course prepares students to solve complex real-world problems and perform data-driven tasks
efficiently.

2. Course Outcomes :At the end of the Course, the student will be able to:
Utilize appropriate Python modules and functions to perform efficient numerical
CO-01
computations and solve data-driven problems.
CO-02 Analyse given data and visualise insights using right python modules
CO-03 Select and apply appropriate algorithm design strategies, to solve computational problems.

CO-04 Analyse space and time complexities of the algorithm to evaluate their efficiency.
Identify and resolve issues in the implementation of algorithmic solutions to ensure correctness
CO- 05
and efficiency

3. Course Content
Wee CO P Theory Practice
k O
NumPy Arrays: Overview, Implement a python code to
Array Creation Methods: array(), arange(), ● Create and manipulate 1D and 2D
linspace(), zeros(), ones(), empty() arrays.
● Write code to display array
Random Number Generation: attributes such as shape, size, and
Creating random arrays with: dimension.
1 1 np.random.rand(), np.random.randn(), ● Create arrays of evenly spaced
np.random.randint() values using np.arange() and
np.linspace().
Array Indexing and Slicing ● Generate random arrays of
integers and floats.
Setting the random seed with ● Retrieve specific rows, columns, or
np.random.seed() subsets of a 2D array.
 ● Apply Boolean indexing to filter
Aggregation functions: np.sum(), np.mean(), elements based on conditions.
np.median(), np.std(), np.var() ● Modify a given array using slicing
and indexing.
● Compute statistical measures
(mean, median, standard
deviation) for a dataset
NumPy Arrays contd. Implement a python code to
Array Reshaping:
Changing the shape of arrays: np.reshape(), ● Reshape a 1D array into 2D and
np.resize() vice versa.
Flattening arrays: ● Flatten a 2D array and explore the
np.flatten(), np.ravel() difference between np.flatten()
Transposing arrays: and np.ravel().
np.transpose(), np.swapaxes() ● Combine arrays horizontally and
2 1 vertically, and split them into
Stacking arrays:
np.hstack(), np.vstack() smaller arrays.
Splitting arrays: ● Perform element-wise operations
np.split(), np.hsplit(), np.vsplit() on two arrays
Broadcasting in NumPy ● Perform arithmetic operations
Element-wise Operations Using ufuncs: between arrays of different
np.add(), np.subtract(), np.multiply(), shapes using broadcasting.
np.divide()
Getting Started with pandas Implement a python code to
● Differences between pandas and
Excel/numpy. ● Create and explore a Series for a
Series and DataFrame Basics small dataset (e.g., sales or
● Creating a Series and exploring its student scores).
attributes (e.g., .values, .index). ● Create DataFrames from
● Creating DataFrames (from dictionaries, dictionaries and NumPy arrays.
lists, numpy arrays). ● Use .head() and .tail() to inspect
● DataFrame attributes (.shape, .columns, the structure of the DataFrame.
.dtypes, .head(), .tail()). ● Retrieve specific rows and
Data Selection and Manipulation columns from a DataFrame using
Indexing and Selection .loc[] and .iloc[].
3 2 ● Selecting rows and columns using .loc[] ● Apply filters to a dataset using
and .iloc[]. Boolean indexing (e.g., selecting
● Boolean indexing to filter rows based on rows based on conditions).
conditions. ● Modify the index of a DataFrame.
Modifying Data ● Add and delete columns in a
● Adding new columns, Updating column DataFrame.
values. ● Handle missing values in a dataset
● Dropping columns and rows (.drop()). by filling or dropping them.
Handling Missing Data ● Sort a DataFrame based on
● Detecting missing values (.isnull(), specific columns or index.
.notnull()).
● Filling missing values (.fillna()).
● Dropping missing data (.dropna()).
Pandas contd. Implement a python code to
Data Analysis and Grouping:
4 2 ● Compute basic statistics (sum,
Sorting and Ranking
● Sorting values by rows or columns mean, etc.) for a dataset.
 (.sort_values(), .sort_index()). ● Group a dataset by a specific
● Ranking data using .rank(). column and compute aggregated
Aggregation and Descriptive Statistics statistics for each group.
● Summary statistics (.mean(), .median(), ● Use multiple aggregation
.std(), .describe()). functions on grouped data.
● Aggregation methods (.sum(), .count(),
.min(), .max()).
Grouping Data
● Grouping data with .groupby().
● Aggregating grouped data (.size(), .agg(),
.apply()).
● Given a list of numbers [1,2,3,4,5],
Functional Programming use a lambda function with the
map() function to square each
Built-in higher-order functions in Python: element of the list. Return and
map(), filter(), reduce(). display the new list of squared
values.
Lambda functions: ● Given a list of integers
1 ● Syntax and use cases for anonymous [12,15,8,24,30], write a lambda
5 functions.
2 function with filter() to select only
● Difference between lambda functions the numbers that are divisible by
and regular functions. 5. Display the filtered list.
● Using the list [1,2,3,4,5], write a
lambda function that uses
reduce() to compute the product
of all elements in the list. Display
the final result.
Data visualization with python Install and set up Matplotlib and
Seaborn.
● Importance of Data Visualization
1.Create basic plots using Matplotlib:
● Types of visualizations: Line plots, bar
● Line plot
charts, histograms, scatter plots, etc.
● Bar chart
● Overview of Python visualization libraries:
● Scatter plot
Matplotlib, Seaborn, and Plotly.
6 2 Matplotlib: Structure of Matplotlib-Figure,
Axes, and Plotting. 2.Create a customized line plot, bar
Plot customization: chart, and scatter plot.
● Titles, labels, and legends. ● Modify titles, labels, and legends.
● Adjusting axis limits and scales ● Change plot colors and styles.
(logarithmic vs linear).
● Styling plots (colors, markers, line styles).
Seaborn: Introduction to Seaborn and its 1.Create basic plots using Seaborn:
● Boxplot
advantages over Matplotlib.
● Histogram with KDE
Seaborn's default aesthetic style. ● Pairplot
Types of plots in Seaborn: Boxplot, violin plot, Work with Seaborn’s built-in datasets
7 2 pairplot, heatmap, etc. (e.g., tips, iris)
Customizing Seaborn plots:
2.Create and customize Seaborn
● Changing plot colors, palettes, and
plots:
styles.
● Modify plot colors using Seaborn
● Adjusting plot sizes and axis labels.
color palettes.
● Plotting categorical data (e.g., barplot,
 countplot). ● Customize axis labels and titles.
● Create bar plots and count plots
for categorical data.
Introduction to algorithm design paradigms. 1.Write a program to calculate the
Importance of algorithm design and analysis. sum of the first n numbers using:
Algorithm efficiency: Time complexity and · A loop (O(n))
space complexity. · A formula (O(1))
Asymptotic Analysis Asymptotically analyse the space
● Types of Asymptotic Notation complexity and time complexity of
● Steps to Perform Asymptotic Analysis both approaches by varying n value
● Best, worst, and average-case time and plot the graph using asymptotic
3 complexities. notations.
8 4 ● Common Time Complexities in Asymptotic
5 Analysis 2.Write a program to calculate the
Fibonacci sequence
Problem-solving strategies: Brute force, ● Recursively and
Decrease and conquer, Divide and conquer, ● Iteratively
greedy, Dynamic programming. Asymptotically analyse the space
complexity and time complexity of
both approach by varying n value
and plot the graph using asymptotic
notations
1. Implement Linear Search
Brute force approach compute space and time
● Bubble sort, complexities. Plot the graph using
3 asymptotic notations.
9 4 ● Selection Sort, 2. Implement Bubble, Selection
5 ● Linear Search. sorting algorithms compute
space and time complexities. Plot
the graph using asymptotic
notations
Decrease and conquer: Insertion Sort. 1. Implement insertion sort
Greedy – Concepts only. algorithms compute space and
3 time complexities. Plot graph
10 Dynamic programming: Fibonacci sequence.
4 using asymptotic notations.
5 2. Implement Fibonacci sequence
with dynamic programming. Plot
graph using asymptotic notations
Divide and conquer - 1. Implement Merge and quick
sorting algorithms. compute
Merge Sort,
space and time complexities. Plot
3 Quick Sort, graph using asymptotic notations
11 4 and compare both solutions.
Binary search.
5 2. Implement Binary Search using
recursion. Compute space and
Backtracking – Concepts only time complexities. Plot graph
using asymptotic notations.
Introduction to Graphs
3 Graph definitions, terminology. Implementing BFS and DFS
12 4 Types of graphs.
Represent graphs in different ways: ● BFS Implementation:
5
(adjacency matrix, adjacency list, and edge ○ Use a queue to traverse the
 list). graph level by level.
● DFS Implementation:
Graph Traversal Algorithms ○ Implement both recursive and
Breadth-First Search (BFS) iterative approaches for DFS.
Depth-First Search (DFS)
Introduction to Hashing. Implement Password Verification
Hashing - Perfect hashing functions. System Using Hashing(use Python's
3
Hash table hashlib module, which provides
13 4 Hash Functions, Operations, Hash collision, hashing functions like SHA-256 to
5 Application. demonstrate secure password
handling.)

4. Learning Resources:
Sl No References
1 "Data Analysis with Python" by David Taieb
2 "Python for Data Analysis" by Wes McKinney
3 "Algorithms: Design and Analysis" by Tim Roughgarden
4 https://docs.python.org/3/tutorial/datastructures.html
5 https://www.geeksforgeeks.org
6 https://www.w3schools.com
7 https://www.tutorialspoint.com
8 https://www.khanacademy.org
9 https://www.datacamp.com
10 https://www.programiz.com

5. CIE Assessment Methodologies

Sl CIE Assessment Test Duration Max
Week (minutes) marks
1. CIE-1 TheoryTest 4 90 50

2. CIE-2 Practice Test 7 180 50

3 CIE-3 TheoryTest 10 90 50 Average

of all
4. CIE-4 Practice Test 13 180 50 CIE=50
Marks
CIE-5 Portfolio evaluation of
5 all the activities through 1-13 50
Rubrics
Total 50 Marks

6. SEE – Practice Assessment Methodologies

Sl Duration Max Min marks to
SEE – Practice Assessment (minutes) marks pass
1. Semester End Examination- 180 50
20
Practice

7. CIE Theory Test model question paper

Program Computer Science and Engineering Semester 4
Course Name Data Analysis and Algorithm Design Test
Course Code 25CS43I Duration 90 min Marks 50
Name of the Course Coordinator:
Note: Answer any one full question from each section. Each full question carries equal marks.
Q.No Questions CL CO Marks
Section - 1
Problem Statement: Weather Data Analysis 25
A meteorological department has collected temperature data for a
city over a year. The data is stored as a 2D NumPy array, where each
row represents a month's data, and each column represents the daily
temperatures for that month.
Your task is to analyze the temperature data using NumPy to answer
the following questions:
○ Load the temperature data (a 12 x 31 NumPy array where
rows represent months and columns represent days).
1
○ Verify the shape of the array to ensure it matches the
expected dimensions.
○ Calculate the average temperature for each month.
○ Identify the month with the highest and lowest average
temperatures.
○ Determine the day of the year with the highest
temperature.
○ Find the day of the year with the lowest temperature.
Problem Statement: Sales Data Analysis
A retail store collects daily sales data for a week from three branches.
The data is stored in a 2D NumPy array, where each row represents a
day of the week, and each column represents the sales figures for a
specific branch.
Your task is to analyze the sales data using NumPy to answer the
following questions:
○ Load the sales data into a 2D NumPy array.
○ Verify the shape of the array (it should be 7 x 3).
2
○ Calculate the total sales for each branch over the week.
○ Find the branch with the highest total sales.
○ Calculate the total sales for each day across all branches.
○ Identify the day with the highest total sales.
○ Compute the average daily sales for the entire store.
○ Identify the day with sales closest to the weekly average.
○ Sort the sales data for each branch in ascending order
(row-wise).
○ Flatten the array to analyze all sales figures as a single list.
Section - 2
Problem Statement: Student Grades Analysis 25
A school maintains a record of students' grades for three subjects
(Math, Science, and English) in a CSV file. Each row represents a
student, and the columns represent the student's name, roll number,
and their grades for the three subjects.
○ Load the student grades data into a Pandas DataFrame.
3
○ Display the first 5 and last 5 rows of the dataset.
○ Print the column names and the number of students
(rows).
○ Calculate the average grade for each subject.
○ Find the subject in which students scored the highest
average grade.
 ○ Find students who scored more than 90 in Math.
○ Sort the students by their total marks in descending order.
○ Assign a rank to each student based on their total marks.
Problem Statement: Employee Salary Data Analysis
A company maintains an employee salary record in a CSV file. The
dataset contains the following columns: Employee ID, Name,
Department, Salary, and Joining Date. Each row represents an
employee.

○ Load the employee salary data into a Pandas DataFrame.

○ Display the first 5 rows of the dataset.
○ Show the total number of employees and the list of
4 unique departments.
○ Calculate the average salary for the entire company.
○ Find the department with the highest average salary.
○ Identify the employee with the highest salary in the
company.
○ Find employees whose salaries are greater than 80,000.
○ List all employees who joined the company before 2015.
○ Calculate the total salary expenditure for each
department.
○ Count the number of employees in each department.
Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Sign of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

8. CIE Practice Test model question paper

Program Computer Science and Engineering Semester 4
Course Name Data Analysis and Algorithm Design Test
Course Code 25CS43I Duratio 180 min Marks 50
n
Name of the Course Coordinator:

Questions CO Mar
ks
Problem Statement: Sales Data Analysis and Visualization 50
Problem Statement:
A retail company wants to analyze its sales data for the past year, which is stored in a
CSV file. The dataset includes daily sales figures for various product categories (e.g.,
Electronics, Clothing, and Groceries). The company wants to perform the following
tasks to understand its sales performance and visualize key metrics:
1. Load the sales data from a CSV file into a Pandas DataFrame.
2. Clean the data by handling any missing values or outliers.
3. Use NumPy to perform calculations such as calculating the daily sales growth
and determining the total sales for each month.
4. Group the data by product category and calculate the average sales per
category, as well as the total sales for each product.
5. Plot key visualizations using Matplotlib, such as:
○ A line plot to show the sales trend over time.
○ A bar chart to compare the total sales per product category.
 ○ A pie chart showing the market share of each product category

Scheme of assessment (customize scheme as per requirement of your problem statement)

a) Program Design and Conceptual Clarity (Clear identification of the key concepts, Explanation
of the logic and methodology used and organization of the program.) - 10
b) Implementation and Execution - 30
c) Best Practices (Code Readability and Error Handling )- 10
TotalMarks 50

Signature of the Course Coordinator Signature of the HOD

9. SEE- Model Practice Question Paper

Program Computer Science and Engineering Semester 4

Course Name Data Analysis and Algorithm Course Code : 25CS43I Duration 180
Design min
Questions CO Marks

Social Media Engagement Analysis 50

Problem:
You have data from a social media platform showing User_ID, Post_ID, Likes,
Comments, Shares, and Date.
● Import the data into a Pandas DataFrame.
● Calculate the total number of interactions (likes, comments, shares) for each
post.
● Group the posts by date and calculate the average engagement (total
interactions per post).
● Implement a Divide and Conquer algorithm to segment users into different
engagement levels based on their total interactions.
● Create a bar chart to visualize total interactions by post.
● Plot a time series graph of user engagement over time.
Scheme of assessment:

a)Load and analyse data (10 Marks)

b)Algorithm selection and design((10 marks)
c)Implementation(20 marks)
c)Visualization(5 marks)
d)Presentation(5 marks)
Total Marks 50

Signature of the Examiner 2) Signature of the Examiner

10. Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Excellent (10) Good (8) Satisfactory (6) Needs Score
No. Improvement
 (4 or below)

9-10 7-8 5-6 <=4

1 Understanding of Demonstrates Shows good Demonstrates basic Lacks 8
Concepts thorough understanding of understanding but understanding of
understanding of concepts with struggles with concepts or is
underlying concepts minor gaps. deeper applications. unable to explain
and explains them them clearly.
confidently.
2 Implementation Skills Writes efficient, well- Writes functional Writes basic code Writes poor or non- 6
structured, and and mostly clean with some functional code
commented code code with minor inefficiencies and with little to no
with appropriate inefficiencies. lack of comments or structure or
logic. structure. comments.
3 Teamwork/Collaboration Actively collaborates, Participates well, Participates Does not 7
contributes ideas, shares ideas, and minimally and may participate in
and supports peers collaborates with not engage fully teamwork or
effectively. minor lapses. with peers. creates disruptions
within the team.
4 Presentation of Results Explains the results Presents results Struggles to explain Fails to present 9
and process clearly with minor results clearly or results clearly or
with accurate inaccuracies or makes incorrect shows lack of
conclusions. gaps in explanation. conclusions. understanding of
the process.
5 Adherence to Time Completes the task Completes the task Completes the task Fails to complete 10
well within the on time with minor with significant the task within the
allotted time with no compromises in delay or allotted time or
compromise on quality. compromises in quality is highly
quality. quality. compromised.
TOTAL 40

Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

11. Equipment/softwarelistwithSpecificationforabatchof30students

Sl.No. Particulars Specification Quantity

01 Computers i3 or i5 30
02 Internet Connection 100 Mbps
 Government of Karnataka
DEPARTMENT OF TECHNICAL EDUCATION
Program Computer Science and Semester 4
Engineering
Course Name Web Development Type of Course Integrated
25CS44I 7 per week
Course Code Contact Hours

Teaching Scheme 3: 0:4 Credits 5

CIE Marks 50 SEE Marks 50 (Practice)

1. Rationale: The course aims to equip students with a comprehensive understanding of user interface
(UI) and user experience (UX) design principles, alongside practical front-end development skills. By
incorporating a design thinking approach, the course empowers students to create functional, visually
appealing, and user-friendly web applications.

2. Course Outcomes: At the end of the Course, the student will be able to:
CO1 Create visually appealing user interfaces using design tools.

CO2 Transform UI designs into functional web interfaces using HTML and CSS.

CO3 Develop a responsive webpage with interactive functionality using JavaScript.

CO4 Develop reusable React components and implement component interaction

Develop a fully functional Single Page Application (SPA) by integrating state management, routing,
CO-5
and UI components

3. Course Content
Week CO PO Theory Practice

Introduction to UI/UX Design Learn wire framing and prototyping using

• Overview of UI/UX; Differences and their Figma or similar design tools. Gain hands-on
roles in web development; experience with the tool's interface, including
• Principles of UI/UX Design; UI elements its key features and functionalities, to create
(Buttons, Text Fields, Dropdowns, effective and user-friendly design mockups
1 1
Checkboxes and Radio Buttons, Sliders,
Date Pickers, Cards, Navigation Bars,
Progress Bars, Notifications/Alerts, etc)
• Examples of good and bad UI/UX.
• Color theory & Typography
Design thinking - 5 stages • Create a simple wireframe for a login or e-
Integrating Design Thinking with UI/UX design commerce page.
• Create wireframes to visualize layouts and
2 1 structures.
Case Study
• Problem: Users find it challenging to navigate
a banking app to transfer money.
 • Problem: Users frequently abandon their
orders during the checkout process in a food
delivery app.
Use Design Thinking to redesign UI/UX to solve
above problems
HTML Basics Prepare and get familiarize with Your
1. Structure of an HTML document. Development Environment like VScode or similar
Basic Tags, Elements, Attributes and IDE
comments
Text formatting tags : <p>; <h1> -<h6>; <b>, Practice using HTML tags to structure and design
3. 2
<i>, <u>, <strong>, <em>,<b>,<hr> user interfaces, focusing on creating layouts,
 Lists: Ordered <ol> and Unordered <ul>;
Refer table for suggestive exercises
 Links: <a>;
 Images: <img>;
 block & inline elements: <div> and <span>
1. Tables - <table>, <tr>, <td>, <th> Practice using HTML tags to structure and design
2. Forms and Input Elements user interfaces, focusing on creating layouts,
Form structure: <form> Refer table for suggestive exercises
Input fields: <input>, <textarea>,
4 2 <button>
Dropdowns and checkboxes: <select>,
<option>, <input type="checkbox">
Radio buttons: <input type="radio">
Media elements.
1. What is CSS? Why is it important? Create a simple HTML file and apply inline,
Different ways to apply CSS: Inline, internal, and external CSS.
Internal, External. Refer table for suggestive exercises
5 2
2. Understanding the CSS syntax: Selectors,
properties, and values.
3. Color; Background; Fonts and Text Styling
What is JavaScript? Role of JavaScript in web Refer table for suggestive exercises
development.
ES6 features;
Embedding JavaScript in HTML: <script> tag.
6 3  Variables (var, let, const) and data types.
Operators and expressions.
Conditional statements (if-else, switch).
 Loops (for, while, do-while).
Loop control statements: break and continue.
 Functions and scope Refer table for suggestive exercises
 DOM Manipulation: What is DOM? Selecting and modifying HTML elements.
Accessing elements, modifying elements, Event handling (e.g., click, mouseover).
creating and adding elements, removing Basic form validation
elements
7 3  Event handling : event and types [ Mouse
events, keyboard event, form events,
windows events]
Event Listeners
Event propagation and delegation
 Arrays and Objects: Refer table for suggestive exercises
Arrays: Create, Indexing, array methods, ES6
enhancements for arrays
8 3
Objects: create, accessing properties, object
methods
ES6 Enhancements for Objects
Introduction to JSON
What is JSON? Structure; Syntax Rules; Create and Parse JSON
Common Use Cases
Working with JSON in JavaScript
9 3
Converting JavaScript Objects to JSON
Converting JSON to JavaScript Objects
Handling JSON in APIs
Working with JSON in Web Applications
Introduction to React: Setting up the environment- install required tools
How traditional websites worked – vscode node.js
Evolution of websites Create your first React app using vite – create –
10 4 What is React? run - stop
How react app works? Create your first component
Basic Syntax of React .js
React components and props
React Component Interaction Learn state management with React hooks
State and lifecycle methods. Create and interact with react forms
React Hooks: What are React Hooks?
11 4
Hook – purpose, syntax and basic usage
[useState, useEffect, useContext, useReducer]
React Forms and React Styles
Introduction to React Router Install React Router and Setup
Basic Routing Dynamic Routing with Parameters
Dynamic Routing Learn how to redirect users based on certain
12 5 Nested Routing conditions using the <Redirect /> component.
Redirects and Programmatic Navigation Learn how to create protected routes that only
Protected Routes allow authenticated users to access certain pages.
Create a login system with protected routes
Introduction to SPA: Build simple REACT SPA.
What is a Single Page Application;
13 5 Characteristics; Advantages; Basic Structure
of a React SPA;
Building a Basic SPA with React.

4 .Learning Resources:
1. https://www.geeksforgeeks.org/principles-of-ui-ux-design/
2. https://www.elinext.com/services/ui-ux-design/trends/typography-color-principles-in-ui-ux-design/
3. https://medium.com/design-bootcamp/using-colors-and-typography-wisely-ui-ux-design-strategies-to-
capture-user-attention-52b0eb5d35f3
4. https://chatgpt.com/
5. https://www.youtube.com/watch?v=c9Wg6Cb_YlU
6. https://youtu.be/dXQ7IHkTiMM?si=BTzfn7b-DCHgb2he
Books
1. "Don't Make Me Think" by Steve Krug
2. "The Design of Everyday Things" by Don Norman
Online Courses
Coursera
1. “UI/UX Design Specialization” by California Institute of the Arts: Comprehensive introduction to UI/UX
design.
2. “Introduction to User Experience Design” by Georgia Tech: A beginner-friendly course on UX
fundamentals.
Udemy
1. “User Experience Design Fundamentals” by Joe Natoli: Beginner-friendly with practical examples.
2. “Learn Figma – UI/UX Design Essential Training”: Focused on wireframing and prototyping using Figma.
LinkedIn Learning
1. “UX Design: From Concept to Prototype”: Covers wireframing and prototyping tools like Sketch and
Adobe XD.
https://www.springboard.com/blog/design/design-thinking-process/
https://www.geeksforgeeks.org/five-phase-model-for-design/
https://www.youtube.com/watch?v=4nTh3AP6knM
https://www.youtube.com/watch?v=_r0VX-aU_T8

"The Design Thinking Playbook" by Michael Lewrick, Patrick Link, and Larry Leifer
"Design Thinking: Understanding How Designers Think and Work" by Nigel Cross
“Learning Design Thinking”: Focuses on applying design thinking in real-world scenarios.
“Design Thinking Guide for Successful Professionals”: Practical and industry-oriented.
Stanford d.school Resources
HBR Design Thinking
"Learning Web Design: A Beginner's Guide to HTML, CSS, JavaScript, and Web Graphics" by Jennifer
Niederst Robbins
"HTML5: The Missing Manual" by Matthew MacDonald

freeCodeCamp HTML : "HTML and HTML5":

Codecademy HTML : "Learn HTML":
Coursera HTML : "HTML, CSS, and JavaScript for Web Developers" by Johns Hopkins University
Udemy HTML : "Build Responsive Real World Websites with HTML5 and CSS3"

https://www.youtube.com/watch?v=IWcUJLUAO2A
https://www.youtube.com/watch?v=6OhMbf2v_jI
https://react.dev/learn/describing-the-ui

5. Suggested Programs
week suggestive program/activity
Wireframe
1 Login page
participation registration form for an event, etc
Conduct warmup activities to ignite Design Thinking

 Empathize: Understanding user behaviors, needs, and pain points.

 Define: Clearly articulate the user problem
2
 Ideate: Brainstorm creative solutions to the problem
 Prototype: Create Visual Representations - Create wireframes to visualize layouts and
structures.
 Test: Validate the prototype by gathering user feedback.
 "Create Your First HTML Document"
create a basic HTML document to demonstrate your understanding of fundamental HTML structure
and tags. The document should meet the following requirements:
a. Include a <head> section with a title for the webpage.
b. Add a main heading (<h1>) to introduce the page with a welcoming message.
3
c. Include a paragraph (<p>) describing the purpose of the page.
d. Create an unordered list (<ul>) with at least three list items (<li>) explaining basic facts about
HTML.
e. Add a hyperlink (<a>) to an external website, ensuring it opens in a new tab.
Format the text to enhance the visual appeal and readability
Design a product detail page for an e-commerce website. The page should display the product
name, image, description, price, and availability. There should also be options to select the quantity
and add the product to the shopping cart.

Design a login and registration page for a website. The login form should include fields for email
and password, while the registration form should include additional fields such as username, email,
password, and confirm password.

Design a user profile page where users can view and edit their personal details such as name,
email, phone number, profile picture, and address. The page should have a navigation bar at the
top and a sidebar with links to other user settings (e.g., Account Settings, Privacy Settings).
4
Design a product listing page for an e-commerce website. The page should display a list of products
with the following details: product name, price, product image, description, and a "Add to Cart"
button. The page should be responsive and adapt to different screen sizes (desktop, tablet, and
mobile).

Project - Create a basic webpage that includes:

 A title and headings.
 Paragraphs and images.
 A table and a form.
 Links to navigate between sections or pages.
Adding a video and audio file to your webpage.

Style basic elements like <p>, <h1>, and <div>

Create an HTML page and apply different selectors to style elements.
5 Experiment with background colors and text colors using various color formats.
Style paragraphs and headings using different fonts and text properties.
Enhance the visual appeal of the UI design in the above section by applying CSS
6&7 Write and execute your first JavaScript program.
Practice using console.log() for debugging.

Write code to compare two numbers and display the larger one
Calculate the Total Bill (Shopping Cart)
Create a program that calculates the total price of items in a shopping cart. The cart is represented
as an array of prices. Use a loop to iterate through the array and calculate the total.

Create a Personal Expenses Tracker

Design and build a simple web-based personal expenses tracker that allows users to:
Add an expenses (description, amount, and date).
View the list of expenses.
Calculate and display the total amount spent.
HTML
a. Create a form with the following fields:
Description (text input)
Amount (number input)
Date (date input)
b. A button to add the expense to the list.
c. Add a table or list to display the expenses.
CSS
a. Style the form to make it visually appealing.
b. Add hover effects on the "Add Expense" button.
c. Use a color scheme to distinguish the form, expense list, and total amount display.
JavaScript
a. Validate the form fields (e.g., all fields must be filled).
b. Add functionality to:
c. Add the entered expense to the list when the button is clicked.
d. Calculate and update the total amount after each addition.

Create a To-Do List Application

Design and build a simple web-based to-do list application that allows users to:
 Add tasks to a list.
 Mark tasks as completed.
 Delete tasks from the list.
HTML
a. Create a form with a single input field to enter a task description.
b. Add a button to add the task to the list.
c. Create a section to display the list of tasks, with each task having:
 A checkbox to mark it as completed.
 A delete button to remove it from the list.
CSS
a. Style the form and task list to make the application visually appealing.
b. Use different styles for completed tasks (e.g., strikethrough text or a light background color).
c. Add hover effects on buttons and smooth transitions for task updates.
JavaScript
Add functionality to:
a. Validate that the input field is not empty before adding a task.
b. Add the task to the list dynamically.
c. Mark tasks as completed when the checkbox is clicked.
d. Remove tasks from the list when the delete button is clicked.
Create a Temperature Converter
Design and build a simple web-based temperature converter that allows users to:
 Input a temperature in Celsius or Fahrenheit.
 Convert the temperature to the other unit.
 Display the result dynamically on the page.
HTML
Create a form with:
 An input field for the temperature value.
 A dropdown menu to select the unit (Celsius or Fahrenheit).
 A button to perform the conversion.
 Add a section to display the converted temperature.
 CSS
 Style the form and result section to make the application visually appealing.
 Add a consistent color scheme and spacing for a clean layout.
 Use hover effects for the button
JavaScript
Add functionality to:
 Validate that the input field contains a valid number.
 Perform the conversion based on the selected unit:
 Celsius to Fahrenheit: (C × 9/5) + 32
 Fahrenheit to Celsius: (F − 32) × 5/9
 Display the result dynamically on the page.

Create a Currency Converter

Design and build a simple web-based currency converter that allows users to:
 Input an amount in one currency.
 Select the currencies for conversion (e.g., USD to EUR).
 Display the converted amount dynamically based on a fixed exchange rate.
HTML
Create a form with:
 An input field for the amount.
 Two dropdown menus to select the source currency and target currency.
 A button to perform the conversion.
 Add a section to display the converted amount.
CSS
 Style the form and result section for a professional look.
 Add a consistent color scheme and spacing.
 Use hover effects for the button and smooth transitions for dynamic updates.
JavaScript
Add functionality to:
 Validate the input to ensure it is a positive number.
 Use predefined exchange rates to calculate the conversion. For example:
 USD to EUR: 1 USD = 0.85 EUR
 EUR to USD: 1 EUR = 1.18 USD
 USD to INR: 1 USD = 74.50 INR
 Add more currencies as needed.
 dynamically display the converted amount.
8 Create a simple contact list to store contact information and perform operations like searching and
adding new contacts.
Design a simple system to manage the items in the shopping cart of an online store using arrays
and objects. The system should allow users to add, remove, and update items in the cart, calculate
the total cost, and display the cart's contents.
Create a system to manage movie rentals. Each movie has a title, genre, rental price, and
availability status. The system should allow users to add and remove a movie, update movie info,
display all movies and rent a movie.
Develop a system to manage tasks for a project. Each task has a title, description, priority, and
completion status. The system should allow following operations:
 Add Task: Add a new task to the system.
 Remove Task: Remove a task by taskID.
 Update Task Info: Update the title, description, priority, or status of a task.
 Mark Task as Completed: Mark a task as completed.
 Display All Tasks: Display the list of all tasks with their titles, priorities, and statuses.
 Filter Tasks by Priority: Display tasks with a specific priority level.
9
Create and Parse JSON
a. Write a JSON string for a "Book" with attributes like title, author, price, and genres. Parse it into
an object and access its properties.
b. Create a JSON object for a "Student" with nested "Subjects" and "Scores". Parse it and calculate
the average score.
c. Convert JSON data (string) into a JavaScript object using JSON.parse().
d. Convert a JavaScript object into a JSON string using JSON.stringify().
10  Create a Simple Greeting Component - Create a React component called Greeting that
accepts a name as a prop and displays a message like "Hello, [name]!".
 Build a ColorBox component that displays a colored box. It should take a color prop (e.g.,
red, blue, green) and render the box in that color.
 Create a ProductCard component that displays product information like name, price,
description, and an "Add to Cart" button. On clicking the button, log a message "Product
added to cart".

11 Counter App:
 Create a simple counter app with useState.
 Add buttons to increment and decrement the counter.
Effect on Mount:
 Use useEffect to log a message to the console when the component is mounted.
 Add a cleanup function in useEffect to demonstrate component unmounting.
Form Validation App:
 Create a form with multiple fields (e.g., name, email, password).
 Use useState to manage the form data and useEffect to validate the fields.
 Show validation messages when the fields are invalid.
 Create a LoginForm component with two input fields (username and password) and a submit
button. Display a message saying "Welcome, [username]" when the user submits the form.

 Create a LoginForm component with two input fields (username and password) and a submit
button. Display a message saying "Welcome, [username]" when the user submits the form.
 Create a TodoList component where users can add new tasks to a list and remove tasks by
clicking a delete button next to each task.
 Create a Rating component that displays 5 stars. Clicking on a star sets the rating, and all stars
up to that point should be highlighted.
 Build a SearchFilter component that allows users to search through a list of items. Display only
the items that match the search query.
 Create a ShoppingList component that renders an array of items (e.g., "Apples", "Bananas",
"Oranges"). Display the items in a <ul> list.
 Create a ToggleButton component with a button that toggles between "ON" and "OFF" states
when clicked.
 Build a Counter component with a button that increments the count each time it's clicked.
 Create a Stopwatch component with start, stop, and reset buttons. Display the time elapsed
since the stopwatch was started.
 Build a ThemeSwitcher component with a button that toggles between light and dark themes.
The background color and text color should change accordingly.
 Build a Slider component that allows users to select a value between a defined range (e.g., 0-
100) using an input slider. Display the selected value.
12 Basic Routing
 Create a simple React app with three pages: Home, About, and Contact.
 Use react-router-dom to create routes for each page.
 Display a navigation menu with links to each page.
 Output: When you click on the links, the corresponding pages should render without reloading the
entire page.
Nested Routes
 Create a "Dashboard" page that contains two sub-pages: "Profile" and "Settings".
 Use nested routes to render these sub-pages inside the Dashboard component.
 Display links for "Profile" and "Settings" inside the Dashboard page.
Output: Clicking on "Profile" or "Settings" should render the appropriate content inside the
Dashboard page.
Dynamic Routing
 Create a route to display a user profile page.
 The URL should contain a user ID (e.g., /profile/:id).
 Use useParams to extract the id from the URL and display it on the page.
Output: Visiting /profile/1 should display a profile for user 1, and /profile/2 should display a profile
for user 2.
Redirecting
 Create a login page where a user can submit a form.
 After a successful login, redirect the user to the "Home" page using the Redirect
component.
Output: After the login form is submitted, the user should be redirected to the Home page.
Programmatic Navigation
 Create a button that, when clicked, programmatically navigates to a new route (e.g., from
"/home" to "/about").
Output: Clicking the button should redirect the user to the new route.
Navigation Bar
 Create a navigation bar with links to different pages (Home, About, Contact).
Output: The active link should be highlighted based on the current route.
13 E-Commerce Product Catalog
Features:
Display a list of products with filters (e.g., price, category).
Add items to a shopping cart.
Update the cart dynamically without refreshing the page.
Key Concepts:
Dynamic rendering of products.
State management for the shopping cart.

Online Quiz Application

Features:
Display multiple-choice questions one at a time.
Show results and scores after completion.
Include a timer for each question.
Key Concepts:
Dynamic rendering of questions.
State management for answers and scores.
Conditional rendering for results and feedback.

To-Do List Application

Features:
Add, edit, and delete tasks.
 Mark tasks as completed.
Filter tasks by status (e.g., All, Active, Completed).
Key Concepts:
Component-based design (e.g., using React or Vue).
State management for tasks.
Routing (e.g., different views for "All" and "Completed" tasks).

6. CIE Assessment Methodologies

Duration Max
Sl.No Test
CIE Assessment (minutes)
Week marks
1. CIE-1TheoryTest 4 90 50
Average of all CIE=50
2. CIE-2Practice Test 7 180 50 Marks

3 CIE-3TheoryTest 10 90 50

4. CIE-4Practice Test 13 180 50

CIE-5 Portfolio
5 evaluation of all the 1-13 50
activities through
Rubrics
Total 50 arks

7 SEE – Practice Assessment Methodologies

Duration
Sl.No Max
SEE – Practice Assessment (minutes) Min marks to pass
marks

1. Semester End Examination-Practice 180 50 20

8. CIE Theory Test model question paper

Program Web Development Semester - 4
Course Name Computer Science & Engineering Test
Course Code 25CS44I Duration 90 min Marks 50

Name of the Course Coordinator:

Note: Answer any one full question from each section. Each full question carries equal marks.
Cognitive Course
Q.No Questions Marks
Level Outcome

Section – 1
a. What are the five stages of design thinking? Briefly describe
each stage with examples. - 10
2,3 1 25
1 b. Create a simple wireframe for a participation registration
form for a seminar. -10
 c. Describe core UI/UX design principles. - 5

a. How does empathy play a critical role in UI/UX design?

Provide an example of how empathy can influence design
decisions. - 5
b. Explain the difference between UI (User Interface) and UX
(User Experience) with examples. Design a wireframe for a 2,3 1
2
login page, including features like “Remember Me” and
“Forgot Password” links. - 10
c. Explain the concept of progressive disclosure in UI/UX design.
How can it be represented in a wireframe? - 10

Section – 2
a. Explain the difference between block-level and inline
elements with examples.
b. How does the alt attribute in the <img> tag enhance
accessibility?
c. How would you create a form with the following fields:
Name, Email, Password, Gender, and Submit? Write the
HTML code. – 10
d. Write HTML code to create following table - 10
3 2 2

a. How can you set a default value for a text input field in
HTML? 25
b. Create a form to capture patient details during registration. -
10
c. What is the difference between checkboxes and radio
buttons in forms? Provide examples.
d. Write HTML code to create following form – 10

4 2 2

e.
 Note for the Course coordinator: Each question may have one, two or three subdivisions. Optional
questions in each section carry the same weightage of marks, cognitive level and course outcomes.

Sign of the Course Coordinator Signature of the HOD Signature of the IQAC Chairman

9. CIE Practice Test model question paper

Program Computer Science and Engineering Semester 4

Course Name Web Development Test
Course Code 25CS44I Duration 180 min Marks 50
Name of the Course Coordinator:
Questions CO Marks

Create a Currency Converter 50

Design and build a simple web-based currency converter that allows users to:
 Input an amount in one currency.
 Select the currencies for conversion (e.g., USD to EUR).
 Display the converted amount dynamically based on a fixed exchange rate.
HTML
Create a form with:
 An input field for the amount.
 Two dropdown menus to select the source currency and target currency.
 A button to perform the conversion.
 Add a section to display the converted amount.
CSS
 Style the form and result section for a professional look.
 Add a consistent color scheme and spacing.
 Use hover effects for the button and smooth transitions for dynamic updates.
JavaScript
Add functionality to:
 Validate the input to ensure it is a positive number.
 Use predefined exchange rates to calculate the conversion. For example:
 USD to EUR: 1 USD = 0.85 EUR
 EUR to USD: 1 EUR = 1.18 USD
 USD to INR: 1 USD = 74.50 INR
 Add more currencies as needed.
dynamically display the converted amount.

Scheme of assessment
Wireframing - 15
 Clarity and Structure - 05
 Consistency and Visual Appeal - 05
 Interactivity Representation - 05
Implementation – 30
 Use of correct HTML elements – 10
 CSS styling and responsiveness – 10
 JavaScript functionality – 10
Presentation -05
 Total Marks 50

Signature of the Course Coordinator Signature of the HOD

10. SEE- Model Practice Question Paper

Program Computer Science and Engineering Semester

Course Web Development Test II/IV

Name
Course 25CS44I Duration 180 Marks 50
Code min
Name of the Course Coordinator:

Questions CO Marks

50
Design and build a Single Page Application (SPA) using React to manage a To-Do
List. The application should allow users to add, edit, delete, and mark tasks as
completed. The tasks should be stored temporarily (using local state or a
temporary storage solution) and should be dynamically updated on the page
without requiring a page reload. The application should have a clean, user-
friendly interface and should demonstrate key features of React such as state
management, event handling, and component reusability.
Requirements
 Allow users to add tasks with validation.
 Enable task name editing.
 Allow users to remove tasks from the list.
 Toggle completion status.
 Filter tasks by completion status.
 Sort tasks by name or completion status.
 Add and display due dates for tasks.
Scheme of assessment
Wireframing and Design - 10
 Clarity and Structure - 05
 Consistency and Visual Appeal - 05
Implementation and Functionality– 30
 Event Handling - 10
 React Component Design and Creation- 10
 State Management and Routing – 10
Code Quality and Best Practices - 05
Presentation and Demo -05
Total Marks 50

Signature of the Examiner 2) Signature of the Examiner

11 . Rubrics for Assessment of Activity(Qualitative Assessment)

Sl. Dimension Excellent Good Satisfactory Needs Improvement Score
No. (4 or below)
9-10 7-8 5-6 <=4
1 Understanding of Demonstrates thorough Shows good Demonstrates basic Lacks understanding 8
 Concepts understanding of understanding of understanding but of concepts or is
underlying concepts and concepts with minor struggles with deeper unable to explain
explains them gaps. applications. them clearly.
confidently.
Writes basic code 6
Writes efficient, well- Writes functional Writes poor or non-
with some
Implementation structured, and and mostly clean functional code with
2 inefficiencies and lack
Skills commented code with code with minor little to no structure
of comments or
appropriate logic. inefficiencies. or comments.
structure.
Actively collaborates, Participates well, Does not participate 7
Participates minimally
Teamwork/Collabo contributes ideas, and shares ideas, and in teamwork or
3 and may not engage
ration supports peers collaborates with creates disruptions
fully with peers.
effectively. minor lapses. within the team.
Fails to present 9
Presents results Struggles to explain
Explains the results and results clearly or
Presentation of with minor results clearly or
4 process clearly with shows lack of
Results inaccuracies or gaps makes incorrect
accurate conclusions. understanding of the
in explanation. conclusions.
process.
Fails to complete the 10
Completes the task well Completes the task Completes the task
task within the
within the allotted time on time with minor with significant delay
5 Adherence to Time allotted time or
with no compromise on compromises in or compromises in
quality is highly
quality. quality. quality.
compromised.
TOTAL 40
Note: Dimension and Descriptor shall be defined by the respective course coordinator as per the activities

12. Equipment/software list with Specification for a batch of 30 students

Sl.No. Particulars Specification Quantity

01 Computers i3/i5 30
02 Internet Connection 100mbs