Diplomo computer for Project Work

Project

Aim:
Project Work aims at developing innovative skills in the students whereby they apply the knowledge and skills gained through the course by undertaking a project. The individual students have different aptitudes and strengths. Project work, therefore, should match the strengths of students The primary emphasis of the project work is to understand and gain the knowledge of the principles of software engineering practices, so as to participate and manage a large software engineering projects in future.
a) Internal Assessment mark for Project Work & Viva Voce:
Project Review I   6th                          Week … 10 marks
Project Review II   14th                      Week … 10 marks
Attendance                                                      05 marks
                                                                      -----------
                                                  Total …. …. … 25 marks
                                                                       -----------
b) Project Work & Viva Voce Board Examination
The allocation of Mark:
Viva Voce                                                   … 15 marks
Project Report                                           … 10 marks
Demonstration                                          … 15 marks
Applicability of the Project                         … 05 marks
                                                                   ------------
                                                         Total … 45 marks
                                                                 ------------
Written Test in 3 topics for 1 hour:
a) Entrepreneurship                   5 questions X 2 marks = 10 marks
b) Environment Management     5 questions X 2 marks = 10 marks
c) Disaster Management             5 questions X 2 marks = 10 marks
                                                                                       ------------
                                                                                          30 marks
                                                                                       ------------
Selection of Questions from Question Bank by the External Examiner, no choice need be given to the candidates.
OBJECTIVES:

• Implement the theoretical and practical knowledge gained through the curriculum into an application suitable for a real practical working environment preferably in an industrial environment
• Develop software packages or applications to implement the actual needs of the community.
• Get exposure on industrial environment and its work ethics.
• Understand what is entrepreneurship and how to become an entrepreneur.
• Learn and understand the gap between the technological knowledge acquired through curriculum and the actual industrial need and to compensate it by acquiring additional knowledge as required.
• Carry out cooperative learning through synchronous guided discussions within the class in key dates, asynchronous document sharing and discussions, as well as to prepare collaborative edition of the final project report.
• Expose students to the field of computing and to gain experience in software design.
• Understand the facts and importance of environmental management.
• Understand and gain knowledge about disaster management.

SUGGESTIVE AREAS OF PROJECT WORK:

1. Database Management Systems
2. Computer Networks
3. Software Engineering and Software Development
4. Web page Designing
5. Digital Image Processing
6. Computer Graphics and Animation
7. Multimedia Systems
8. Artificial Intelligence
9. Internet and e-commerce
10. Computer Security and Cryptography
11. Computer hardware and embedded systems
12. Computer aided engineering and design
13. Improving existing systems / equipments.
14. Any other related area found worth.

Detailed Syllabus:
ENTREPRENEURSHIP, ENVIRONMENTAL & DISASTER MANAGEMENT
ENTREPRENEURSHIP

1.1 Introduction – Entrepreneur – types -Characteristics & attributes of Entrepreneur – Expectations of entrepreneurship – Contributions of an entrepreneur - Identifying problems and opportunities. - Why do Entrepreneurs fail

1.2 Types of Industries - Importance of SSI – Assistance offered – Governmental and Non Governmental organizations – Identifying prospects of various Small scale industries in your area with resources and other infrastructural facilities available.

1.3 Starting a SSI – various stages – product – ownership – locality – points related to building, water and electricity – financial assistance – raw materials – machineries –human resource – efficient manufacturing techniques – marketing - Technical, Financial Marketing, Personnel and Management Feasibility study and report - concessions and incentives offered by agencies.

1.4 Industrial Zones – industrial Estates - Pollution Control – industries with pollution problem - Marketing assistance

1.5 Acquiring common services – repairing – testing facilities – training institutions – suppliers of applied technology.

2. ENVIRONMENTAL MANAGEMENT

2.1 Introduction – Environmental Ethics – Assessment of Socio Economic Impact – Environmental Audit – Mitigation of adverse impact on Environment – Importance of Pollution Control – Types of Industries and Industrial Pollution.

2.2 Solid waste management – Characteristics of Industrial wastes – Methods of Collection, transfer and disposal of solid wastes – Converting waste to energy – Hazardous wastemanagement Treatment technologies.

2.3 Waste water management – Characteristics of Industrial effluents – Treatment and disposal methods – Pollution of water sources and effects on human health.

2.4 Air pollution management – Sources and effects – Dispersion of air pollutants – Air pollution control methods – Air quality management.

2.5 Noise pollution management – Effects of noise on people – Noise control methods.
3. DISASTER MANAGEMENT
3.1 Introduction – Disasters due to natural calamities such as Earthquake, Rain, Flood, Hurricane, Cyclones etc – Man made Disasters – Crisis due to fires, accidents, strikes etc
– Loss of property and life..

3.2 Disaster Mitigation measures – Causes for major disasters – Risk Identification – Hazard Zones – Selection of sites for Industries and residential buildings – Minimum distances
from Sea – Orientation of Buildings – Stability of Structures – Fire escapes in buildings - Cyclone shelters – Warning systems.

3.3 Disaster Management – Preparedness, Response, Recovery – Arrangements to be made in the industries / factories and buildings – Mobilization of Emergency Services -Search and Rescue operations – First Aids – Transportation of affected people – Hospital facilities – Fire fighting arrangements – Communication systems – Restoration of Power supply – Getting assistance of neighbors / Other organizations in Recovery and Rebuilding works – Financial commitments – Compensations to be paid – Insurances – Rehabilitation.

Diplomo computer Lab syllabus for Open source software Practical

Open Source Software Laboratory

Subject Code : 15284
LIST OF EXPERIMENTS
LINUX

1. a. Set up a Local Area Network in Linux Environment
2. a. Connect Internet in Linux Environment b. Setting up a Print Server in Linux Environment
3. a.Installation of Apache Web server and configuring for PHP support. Uploading Web page in Apache.

PHP and MYSQL
4. Create a web page and execute a PHP file on submission of the HTML form and display the information using PHP.
5. a. Write a program to find the factorial of a number and display. b. Generate a PHP script that will display the grade on the basis of marks as follows :

• Distinction – 80 and above
• First Class – From 60 to below 80
• Second Class – From 45 to below 60
• Pass Class – From 35 to below 45
• Fail – Below 35 Test the above program using the following set of values stored in an array : 67,82, 23, 37, 57, and 97

6. Write a program to show that array is received on server side during multiple options in SELECT.
7. Create a PHP code, which will retrieve the data captured by the HTML form, display the name of the form and also display the message “Data Entered successfully” after performing validations.
8. Write a program to redirect the browser.
9. Write a PHP script using function call.
10. Write a program in PHP to create a file and write the data into it.
11. Create a database of an employee inMySql.
12. Write a program to connect to the database already created inMySql.
13.  Write a program to read, write, update and delete the database using PHP..
PYTHON
14 a. Take Fahrenheit temperatures from the command line, and prints their Celsius equivalents b. Use regular expressions to check whether a phone number is valid
15 Write a python program to display the content of all text files (txt) in a directory.

Diplomo computer Lab syllabus for Multimedia Practical

Multimedia Systems Laboratory

Subject Code : 25283
LAB EXERCISES

1. Use HTML multimedia support to play different audio and video formats in a browser.
2. Use a audio processing Software and perform the audio editing tasks– Import audio, Select and edit the sound, Create fade-in fade-out effects, Label audio segments, Use noise remove filter, Mix audio, Change stereo to mono tracks, Export audio to different format and save.
3. Use a video processing Software to perform – Trim video clips, crop video, rotate video, join video, add subtitles, and edit video dimension, bit rate, frame rate, sample rate, channel, and video/audioquality tasks on a video.
4. Create a Movie from video clips to demonstrate :- Audio-Video Mixing, Music, Video Effects, Video Transitions, Titles
5. Create a logo using a 3D modeling software.
6. Create a 3D animation (such as a animated eye) using a 3D modeling software.
7. Create a 2D Animation / cartoon using any 2D software.
8. Use a scanner to create two or more partial scanned images of large poster / photo. Create a panoramic view of multiple photos by stitching together them using any panorama software.
9. Create an advertisement banner for using it in a web page.
10. Use a DVD ripper for copying the audio and video content of a DVD to a file encoded in AVI, MP4, MPEG, WMV or other video formats. Use a Video converter to convert a video between different video formats, audio format, portable device formats
11. Use audio ripper tools to rip Audio-CDs, audio from video, audio from DVD. Convert the ripped audio into various formats. Burn the audio in to CDs.
12. Use a audio recording program to record audio from different sources of input such as line-in, PC speaker output etc applying different filters, encoding and compression schemes. Split the audio into pieces. Merge different pieces together. Use appropriate tools.
13. Use a photo editing tool to convert a photo into a cartoon image. Create a DVD photo slideshow and add music to slideshow using a slideshow creating tool.
14. Use a DVD authoring tool to create a Video DVD with interactive menus, multiple subtitle and audio tracks and other features.
15. Stream audio / video in different formats to systems in a LAN using a media stream player / server software.

Diplomo computer Lab syllabus for System Administration Practical

System Administration Practical

Subject Code : 25265
LAB EXERCIES
PART – A WINDOWS 2003/2008 SERVER EXPERIMENTS

1. Installation of Windows 2003 / 2008 Server .
2. Installing Hardware, Devices and Drivers using Device manager and Driver Query
3. Configure Active Directory Services, create a user and assign permissions using Logon Script and Group permissions.
4. Automated installation ofWindows Server using answer files.
5. Installing required Windows 2003 server components using Control panel.
6. Installation and configuration of DHCP server.
7. Configuring Disks and Volumes using Disk Manger and Managing disks and volumes from the command prompt.
8. Installation and Configuration of Mail Server in windows 2003/2008 server environment.
9. Establish RAID (0, 1 and 5) configuration on windows 2003/2008 server.
10. Configure a router to connect two different networks and transfer files between them.

PART - B LINUX SERVER EXPERIMENTS

1. Installation of Red Hat Linux using Graphical mode.
2. Installation of Red Hat Linux using command prompt
3. Creating a user in Linux server and assigning rights
4. a) Configuring and Troubleshooting of /etc/inittab. b) Configuring and Troubleshooting of /etc/passwd
5. Configuring and Troubleshooting of /etc/grub.conf
6. Linux TCP/IP Network Configuration
7. Installation of additional software using RPM
8. Sharing of data using Samba Server.
9. File Data Backup using tar

Diplomo computer Lab syllabus for Computer Servicing and Networking Practical

Computer Servicing and Network Practical

Subject Code : 25264
PART A – COMPUTER SERVICING PRACTICALS
1 Identification of System Layout.

• Front panel indicators & switches and Front side & rear side connectors.
• Familiarize the computer system Layout:Marking positions of SMPS, Motherboard, FDD, HDD, CD, DVD and add on cards.
• Configure bios setup program and troubleshoot the typical problems using BIOS utility.

2 HARD DISK

• Install Hard Disk.
• Configure CMOS-Setup.
• Partition and Format Hard Disk.
• Identify Master /Slave / IDE Devices.
• Practice with scan disk, disk cleanup, disk De-fragmenter, Virus Detecting and Rectifying Software.

3 a) Install and Configure a DVD Writer and a Blu-ray Disc writer. b) Recording a Blank DVD and Blu-ray Disc.

• 4 Printer Installation and Servicing:
• Head Cleaning in dot matrix printer
• Install and configure Dot matrix printer and Laser printer
• Troubleshoot the above printers.
• Check and connect the data cable connectivity

5 Install and configure Scanner, Web cam, Cell phone and bio-metric device with system. Troubleshoot the problems
6 Assemble a system with add on cards and check the working condition of the system and install OS.
7 Dual OS Installation
8 Assembling and Disassembling of Laptop to identify the parts and to install OS and configure it.
PART B – COMPUTER NETWORK PRACTICALS
9 Do the following Cabling works in a network a) Cable Crimping b) Standard Cabling c ) Cross Cabling d) IO connector crimping e) Testing the crimped cable using a cable tester
10 Configure Host IP, SubnetMask and Default Gateway in a system in LAN (TCP/IP Configuration). Configure Internet connection and use IPCONFIG, PING / Tracert and Netstat utilities to debug the
network issues
11 Interface two PCs using Peer To Peer network using connectivity devices – Switch and Router in a LAN and share the Drives and Folders.
12 Transfer files between systems in LAN using FTP Configuration, install Print server in a LAN and share the printer in a network.
13 Configure DNS to establish interconnection between systems and describe how a name is mapped  to IP Address
14 Install and configure Network Devices: HUB, Switch and Routers
15 Install and Configure Wired and Wireless NIC and transfer files between systems in LAN and Wireless LAN.
PART C - MINI PROJECT WORK
Visit Any industry/ Institute ( Engineering colleges, University campus etc., ) and study the following:

• Type and configuration of client PCs and OS
• Type and configuration of Server and Domains Used
• Type of Networking ( Topology and medium used)
• Different Network devices used ( Switches, Routers, Access points etc.,)
• Different types of peripherals used
• Applications used by the user.
• Prepare a detailed report of about 4 to 5 pages and include in the lab record.

Diplomo computer Lab syllabus for .NET Practical

.Net Laboratory

sub Code: 25257
LAB EXERCISES
PART – A VB.NET PROGRAMMING

1. Accept a character from console and check the case of the character.
2. Write a program to accept any character from keyboard and display whether it is vowel or not.
3. Write a VB.Net program to accept a string and convert the case of the characters.
4. Develop a menu based VB.Net application to implement a text editor with cut, copy, paste, save and close operations.
5. Write a program to implement a calculator with memory and recall operations.
6. Develop a form in VB.NET to pick a date from Calendar control and display the day, month, year details in separate text boxes.
7. Develop a VB.Net application to perform timer based quiz of 10 questions.
8. Develop a VB.Net application using the File and Directory controls to implement a common dialog box.
9. Develop a database application to store the details of students using ADO.NET
10. Develop a database application using ADO.NET to insert, modify, update and delete operations.
11. Develop a VB.Net application using Datagrid to display records.
12. Develop a VB.Net application using Datagrid to add, edit and modify records.

PART – B ASP.NET and XML PROGRAMMING

1. Create a simple ASP.NET page to Output Text with a form, two HTML text boxes, an HTML button, and an HTML <span> element. Create an event procedure for the button.
2. Create a web application in ASP.NET using three different controls to the ASP.NET page for reserving rooms in hotel. The three controls are a button control, a label control, and a drop-down list control.
3. Create a application for Accessing a SQL Database by Using ADO.NET by connecting to the SQL Server database and call a stored procedure. You then display the data in a Repeater control.
4. Develop a web application to read the details of the selected country stored in XML database and display back to the user usingWeb controls
5. Develop a web application to read an XML document containing subject, mark scored, year of passing into a DataSet

Diplomo computer Lab syllabus for RDBMS Practical

RDBMS Laboratory

"L" Scheme - Sub Code: 25256

LAB EXERCISES
PART - A
1 Create a table “Customer” with the following fields: Id, Company name, Last name, First name, Address, City, State, Pin code and Perform the following operations

• Find the customer who does not have last name.
• Change the pin code of any customer
• Insert new record into the table
• Update the field’s First name and Last name into Name.

2. Implement the following Transaction Control Statements a. Commit b. Rollback c. Save point
3. Create a table client master with the following fields client_no, name, address 1, address2, city, state, pincode, remarks, bal due with suitable data types. Create another table supplier table from client
master. Select all the fields and rename client no with supplier no and name with supplier name.

• Insert data into client master.
• Insert data into suppliermaster from client master.
• Delete the selected row in the client master.

4. Create a table to show the salary details of the employees and perform the following operations

• Create an updatable view to modify and display the details of the employees for the above table.
• Grant select and update privileges on above table to other users.
• Grant all the privileges to some other users.
• Revoke all the above granted permissions.

5. Create two tables “Item details” with the fields of Item id,, Order Id, Part Id, Quantity, Total and Create a another table “Order Details: with the fields of Order id, Customer id, Order Date and
Perform the following operations

• Create the view that calculates the total for all the items in each order
• Create view to join order and corresponding line item information from the above two tables.

6. Create a table student with their elective paper as one field.

• Create another table staff with the subject names they have handled and number of times handled.
• Construct a English sentence to display the rows in the staff table.
• Use sub-queries to display the information about student's name and staff names where both have same subject names.
• Display the subject name, staff names where same subject is handled by more than one staff.
• Display the student, subject name where the subject is not at all handled any staff in the staff table.

7. Create two tables ”Department” and “Staff Details”. Apply a Master Transaction relationship between them.
8. Create a table sales_order with s_order_no and product_no as primary key. Set other fields to store client number, delivery address, delivery date, order status.

• Add a new column for storing salesman number using ALTER command.
• Set the s_order_no as foreign key as column constraint
• Set the s_order_no as foreign key as table constraint
• Enforce the integrity rules using CHECK.

PART - B

1. Create a table 'master_book' to contain the information of magazine code, magazine name, publisher, Weekly/biweekly/monthly, price. Write PL/SQL block to perform insert, update, delete operations on the above table.
2. Create a table to store the salary details of the employees in a company. Declare the cursor id to contain employee number, employee name and net salary. Use cursor to update the employee
3. Create a table to store the salary details of the employees in a company. Declare the cursor to contain Employee number, Employee name and Net salary. Use cursor to update update the employee salaries.
4. Write a PL/SQL trigger to update the records while deleting the one record in another table.
5. Create a table to contain phone number, user name, address of the phone user. Write a function to search for a address using phone number.
6. Create a table 'stock' to contains the itemcode, itemname, current stock, date of last purchase. Write a stored procedure to seek for an item using itemcode and delete it, if the date of last purchase is before one year from the current date. If not, update the current stock.
7. Write a PL/SQL block to handle built-in exception like No_DATA_FOUND and TOO_MANY_ROWS.
8. Write a PL/SQL block to create and handle any two user defined exception.

PART – C - MINI PROJECT
Maximum 4 Students in a batch
Using any front end tool develop an application involving minimum 2 – 4 tables. Include the coding and output screens in the lab record.

 

"K" Scheme - LAB Manual

Sub Code: 15055
Lab exercise:

1. Execute and test all the SQL Editor commands.
2. Work with the following conditions: Column formatting, alias and Column ordering.
3. Use indexing on a table –simple and compound indexes.
4. Work with the different categories of functions such as Math, Date, Aggregate and Conversion functions.
5. a) Create a table to show the salary details of the employees.
   b) Grant select and update privileges on above table to other users.
   c) Grant all the privileges to some other users.
   d) Revoke all the above granted permissions.
6. a) Create a table student_master with the following field’s name, Regno, dept and year with suitable data types. Use Select command to do the following.
   b) Select the student's name column
   c) Display the unique rows
   d) Sort the table in alphabetical order
   c) Display the rows of the table in the sales order date wise,
   e) Select all the students of a particular department.
7. a) Create a table sales_order with s_order_no and product_no as primary key. Set other fields to store client number, delivery address, delivery date, order status.
   b) Add a new column for storing salesman number using ALTER command.
   c) Set the s_order_no as foreign key as column constraint
   d) Set the s_order_no as foreign key as table constraint
8. Develop a Visual Basic Application with suitable Labels & TextBoxes for the columns of a Table . Add Command Buttons to perform the following: Display Records, Previous, Next, First and Last. Use the ODBC driver to connect the Application with the oracle
9. Develop a Visual Basic Form with suitable Labels & TextBoxes for the columns of a Table . Add Command Buttons to perform the following: Insert record, Delete record, Update record, Locate Record
10. a) Create a table student with their elective paper as one field.
    b) create another table staff with the subject names they have handled and number of times handled.
    c) Construct a English sentence to display the rows in the staff table.
    d) Use sub-queries to display the information about student's name and staff names where both have same subject names.
    e) Display the subject name, staff names where same subject is handled by more than one staff.
    f) Display the student, subject name where the subject is not at all handled any staff in the staff table.
11. a) Create a sales_order table and client_master table with suitable fields.
    b) Find the total number of quantity ordered for a particular product.
    c) Display the rows of the table in the sales order date wise,
    d) Join the two tables and display the product number, product name, where the order_no in the sales_order table and order_no in client_master are equal.
    e) Join the sales_order table to itself and display the order number, client number and salesman number where client has been serviced by more than one salesman.
12. a) Create table sales_order_details with the s_order_no as primary key and with the profit_percent, sell_price, supplier_name
    b) Select each row and compute sell_price*.50 and sell_price *1.50 for each row selected.
    d) Select product_no, profit_percent, sell_price where profit_per is not between 10 and 20 both inclusive.
    e) Select product_no, description. profit_percent, sell_price where profit_percent is not between 20 and 30.
    f) Select the supplier_name and product_no where suppliemame has 'r' or 'h' as second character.
13. a) Create a table client_master with the following fields client_no, name, address 1 , address2,city, state, pincode, remarks, bal_due with suitable data types. Create another table supplier_table from client_master. Select all the fields andrename client_no with supplier_no and name with supplier_name.
    b) Insert data into client_master.
    c) Insert data into supplier_master from client_master.
    d) Delete the selected row in the client_master.
14. Write a PL/SQL code to display the employee details for an employee.
15. Write a PL/SQL code to calculate EB bill for the given units using if statement.
16.  Write a PL/SQL block to handle built-in exception like No_DATA_FOUND,TOO_MANY_ROWS.
17. Write a PL/SQL block to create and handle user defined exception.
18. Write a PL/SQL block to use procedure and function and get the result.
19. Write a PL/SQL trigger to update the records while deleting the one record in another table.
20. Create a table to store the salary details of the employees in a company. Declare the cursor id to contain employee ber, employee name and net salary. Use cursor to num update the employee salaries.

HARDWARE REQUIRED

1. A Server with Oracle 8i or higher (Oracle 10g is preferred)
2. 36 computers networked and configured with TCP/IP.

SOFTWARE REQUIRED

1. SQL *PLUS
2. Microsoft Visual Basic 6.0

Diplomo computer Lab syllabus for Web Programming Practical

Web Programming Practical

"L" Scheme - Sub Code: 15255

PART – A

1. Design a HTML page describing your profile in one paragraph. Design in such a way that it has a heading, a horizontal rule, three links and your photo. Also, write three HTML documents for the links.Include facilities for forward, backward and HOME.
2. Design a HTML page about computer languages. List the language. Each Language’s name is a link. Prepare separate HTML documents for each language and call them in the appropriate link.
3. Design a single page website for your polytechnic containing a description of the courses offered. It should also contain some general information about the college such as its history, the campus, its unique features and so on. The site should be colored and each section should have a different color.
4. Make out a brief bio-data of yours and code it as an HTML page. You can consider using tables to show your academic history.
5. Write a program using CSS to create a time table for the class.
6. Write a program using CSS to set the background colors, fonts and paragraphs
7. a)Write a Java script code that converts the entered text to uppercase b)Write a Javascript code to validate the username and password. The username and password are stored in variables.
8. Write a Java Script code using frames and Events ( When a cursor moves over an object it should display the specification of the object in another frame )
9. Create a site containing banner advertisement at the top of the page. The ads are changed every 10 or 15 seconds.

PART - B

1. Collect the definitions of 5 items in Open Source. These definitions are stored in two string arrays name[] and defn[]. Write a JSP which has these two arrays and supplies the definition on request.
2. Write a HTML document which gets the user input of the name of the item and sends the request to the JSP.
3. Write a JSP code to manipulate cookies.
4. Write a JSP code to upload data from client side.
5. Create a JSP application using image map to give information about the institution
6. Write a program to check how many users have visited a website. Use Application object.
7. Write a Code in Java Script to count number of times you move over a link or record.
8. Write a program to check whether a person will be permitted to open a particular page or not. Use permission checker component.
9. Develop a simple Hello World application using AJAX Develop an AJAX application to get the server date time from a JSP page using AJAX.
10. Develop a html search page using Ajax functionality and a server side script that returns results based on search criteria. Develop a html search page containing a textbox for taking search string as input from the user and get the results from the server using Ajax functionality, and display them on the page.

PART – C - MINI PROJECT
Maximum 2 Students in a batch
Design a static web site having a minimum of 6 web pages using all the html features studied. Include the coding and output of the above mini project in the lab record.

 

"K" Scheme - Lab Manual

Sub Code: 15045
Lab Exercise:

1. Design a HTML page describing your profile in one paragraph. Design in such a way that it has a heading, a horizontal rule, three links and your photo. Also, write three HTML documents for the links. Include facilities for forward, backward and HOME.
2. Design a HTML page about your friends. List your friends. Each friend’s name is a link. Prepare separate HTML documents for each friend and call them in the appropriate link.
3. Design a single page website for your polytechnic containing a description of the courses offered. It should also contain some general information about the university such as its history, the campus, its unique features and so on. The site should be colored and each section should have a different color.
4. a.) Create a web page that provides links to five different websites.
   b.) Design a web page that has 5 equal columns. The table should look the same in all screen resolutions.
5. Make out a brief bio-data of yours and code it as an HTML page. You can consider using tables to show your academic history.
6. a.) Write a Java script code that converts the entered text to uppercase
   b.) Write a Javascript code to validate the username and password. The username and password are stored in variables.
7. Write a Java Script code using frames and Events ( When a cursor moves over an object it should display the specification of the object in another frame
8. a.) Write Javascript function that finds the maximum of three given numbers.
   b.) Write HTML document with Javascript to count the number of vowels in a text typed in a TextArea..
9. Create a site containing banner ads at the top of the page. The ads are changed every 10 or 15 seconds.
10. Collect the definitions of 10 items in chemistry. These definitions are stored in two string arrays name[] and defn[]. Write a JSP which has these two arrays and supplies the definition on request. Write a HTML document which gets the user input of the name of the item and sends the request to the JSP.
11. Write a JSP code to manipulate cookies.
12. Write a JSP code to upload data from client side.
13. Create a JSP application using image map to give information about the institution.
14. Write a program to create the chatting application using Application and Session object.
15. Write a program to check how many users have visited a website. Use Application object.
16. Write a Code in Java Script to count number of times you move over a link
17. Write a program to check whether a person will be permitted to open a particular page or not. Use permission checker component.
18. Write a program for incorporating entities in to XML document using internal DTD.
19. Write a program using CSS to create a time table for the class.
20. Write a program using CSS to set the background colors, fonts and paragraphs.

REQUIREMENTS:Software: (i) Notepad or any one Editor (ii) Web Browser (Internet Explorer or any one web browser) (iii) Apache Tomcat 4.0.x or JRun 3.x
Hardware:
• Computer with Pentium IV / Dual core Processors – 36 Nos
• Printers - 6 Nos

Diplomo computer Lab syllabus for Communication Lab Practical

Communication and Life Skills Practical

Sub Code: 20002
PART A: MONODIC COMMUNICATION

1. Vocabulary enrichment: recording important words and terminology alphabetically connected to the concerned department – playing antakshari.
2. Introducing oneself: using greeting phrases – opening and closing with courteous notes – supplying personal information.
3. Introducing others: using greeting phrases – opening and closing with courteous notes – with information.
4. Welcome address, vote of thanks and compering a program: keeping notes – and personal information of the dignitaries – concerned.
5. Making an Oral Presentation: Preparing the presentation - Talking about people, animals and places – Keywords technique and the rehearsal – Presentation outline – Performing the presentation – answering the questions.
6. Oral description: a picture from an English magazine – a visual ad – a natural scene.
7. Auditory/Oral comprehension – small passage – small dialogue -very short story – note - taking skill.
8. News Caption: giving caption for a news item from an English daily.

PART B: DYADIC COMMUNICATION: COMMUNICATIVE FUNCTIONS

1. Dialogue: preparing and performing - Meeting people, exchanging greetings and taking leave – Giving instructions and seeking clarifications – Thanking someone and responding to thanks - minimum seven exchanges including the courteous openings and closings – ten common contexts.
2. Telephonic dialogue: telephonic etiquette - Answering the telephone and asking for someone – Dealing with a wrong number – Taking and leaving messages – Making enquiries on the phoneordering for supply-bookings and arrangements-handling the complaints – calling for appointment.

PART C: PROFESSIONAL COMMUNICATION

1. Group Discussion - Taking part in a Group Discussion – focus on team spirit.
2. Interview - Frequently asked questions in an interview – Mock interview - Body language.
3. Resume Writing – components.

PART D: LIFE SKILLS

1. Preparing for and dealing with change.
2. Motivation, goal-setting and self-esteem.
3. Teamwork skills.
4. Emotional intelligence skills
5. Career planning.
6. Assertive Skills.
7. Interview skills.

References :-

1. Malcolm Goodale, Professional Presentations with VCD, Cambridge University Press
2. B.Jean Naterop and Rod Revell, Telephoning in English with 2 Audio CDs Cambridge University Press
3. Priyadarshi Patnaik, Group Discussion and Interview Skills with VCD, Cambridge University Press
4. Kamalesh Sadanand and Susheela Punitha, Spoken English: A Foundation Course for Speakers of Tamil, Orient BlackSwan.
5. S. P. Dhanavel, English and Soft Skills, Orient BlackSwan
6. Robert Sherfield and et al, Developing Soft Skills, Pearson Education.
7. Poly Skills: A course in communication skills and Life skills, Cambridge University Press.
8. English and Communication Skills for Students of science and Engineering by S.P.Dhanavel , Orient BlackSwan.
9. Speak Well, edited by Kandula Nirupa Rani, Jayashree and Indira,OrientBlackSwan.
10. Fifty ways to improve your telephoning and teleconferencing Skills by Ken Taylor Time management

Diplomo computer Lab syllabus for Data structures usinng C Practical

Data Structures Using C Practical

"L" Scheme - Subject Code : 25245

Lab Exercise:

1. Write a program in ‘C’ to insert, delete an element from an array of elements. Also print the position of a particular element
2. Write a program in ‘C’ to merge two sorted array elements into a single array
3. Write a program in ‘C’ to create a two dimensional array with at least ten elements. Search for a particular element and print its position and address of the element.
4. Write a program in ‘C’ to perform operations in stack by using array.
5. Write a program in ‘C’ to convert an infix expression into postfix expression.
6. Write a program in ‘C’ to evaluate a postfix expression.
7. Write a program in ‘C’ to create a queue containing ten elements and perform delete and insert operations using array.
8. Write a program in ‘C’ to create a singly linked list containing at least five elements. Make necessary assumptions.
9. Write a program in ‘C’ to delete the first node that contains an integer data item of a single linked list.
10. Write a program in ‘C’ to create and display the contents of a doubly linked list.
11. Write a program in ‘C’ to create a binary tree.
12. Write a program in ‘C’ for pre-order traversal of a binary tree.
13. Write a program in ‘C’ for binary searching
14. Write a program in ‘C’ to sort ‘N’ Numbers using Insertion sort.
15. Write a program in ‘C’ to sort ‘N’ Numbers using bubble sort.

Diplomo computer Lab syllabus for JAVA Practical

Java Programming Practical

"L" Scheme - Sub Code: 25245
LAB EXERCISES
PART - A

1. Write a program to print the individual digits of given 3-digit number.
2. Write a program that asks the user to enter two integers, obtains the numbers from the user, and then prints the larger number followed by the words "is larger." If the numbers are equal, print the message “These numbers are equal.”
3. Write a program to find the three digit Armstrong numbers.
4. Write a program to read N numbers and find the largest and smallest numbers.
5. Write a program in Java to create a String object. Initialize this object with your name. Find the length of your name using the appropriate String method. Find whether the character ‘a’ is in your name or not; if yes find the number of times ‘a’ appears in your name. Print locations of occurrences of ‘a’.
6. Write a program to display total marks of 5 students using student class. Given the following attributes: Regno(int), Name(string), Marks in three subjects(Integer Array), Total (int).
7. Write a program to show how a class implements two interfaces.
8. Write a Java program to create your own exception subclass that throws exception if the sum of two integers is greater than 99.
9. Write a program to create a text file using Byte stream classes
10. Write a program to copy a file to another file.

PART – B
1. Write a program that accepts a shopping list of four items from the command line and stores them in a vector. Write a Menu based Program to perform the following operations using vector

• To add an item at a specific location in the list.
• To delete an item in the list.
• To print the contents of the vector.
• To delete all elements
• To add an item at the end of the vector

2. a) Create a StringBuffer object and illustrate how to append characters. Display the capacity and length of the string buffer.

    b) Create a StringBuffer object and illustrate how to insert characters at the beginning.
    c)  Create a StringBuffer object and illustrate the operations of the append() and reverse() methods.

  3. Write a program in Java with class Rectangle with the data fields width, length, area and colour. The length, width and area are of double type and colour is of string type. The methods are get_length(), get_width(), get_colour() and find_area(). Create two objects of Rectangle and compare their area and colour. If the area and colour both are the same for the objects then display “ Matching Rectangles”, otherwise display “ Non-matching Rectangle”.

  4. Create a class to represent complex numbers. A complex number has the form real part + i * imaginary part. Provide constructor to enable an object of this class to be initialized when it is declared. Provide a no-argument constructor with default value in case no initializes are provided. Provide public methods for the following:

• Addition of two complex numbers
• Subtraction of two complex numbers
• Printing complex numbers in the form (a,b) where a is the real part and b is the imaginary part. (Pass objects as arguments)

  5. Write a program to create a player class. Inherit the classes Cricket_player, Football_player and Hockey_player from player class.

  6. Write a program to create a package for Book details giving Book Name, Author Name, Price, Year of Publishing.

  7. A color can be created by specifying the red, green, blue values as integer parameters to the constructor of class Color. The values range from 0 to 255. Provide three horizontal scroll bars and ask the user to select  the values of the colors by dragging the thumb in the scroll bar. Using the color selected, draw a rectangle.

  8. Create an applet for simple calculator to perform Addition, Subtraction, Multiplication and Division using Button, label and Text field classes.

  9. Draw a bar chart for the following details using Applets.

Subject	Tamil	English	Maths	Physics
Marks	75	85	98	56

  10. Write a Java program for generating two threads, one for printing even numbers and other for printing odd numbers.

Diplomo computer Lab syllabus for Computer Applications Practical

Computer Applications Practical

Subject Code : 20001
Course Name : COMMON TO ALL BRANCHES
Lab Exercises:
SECTION – I
WINDOWS

---

Introduction- History of Windows- screen saver and monitor resolution – Wallpaper setting- Folder manipulation – properties of a folder – Recycle bin – Short cuts – Sorting Folder – Switching between Application – Copying in CD/DVD settings – Recording Audio files.

Exercises
1.a. Installing screen saver and change the monitor resolution by 1280X960
b. Setting wall papers
c. Creating, moving, deleting and renaming a folder
d. Copy, paste and cut a folder/file
e. Displaying the properties for a file or folder
2. a. Restoring files and folders from Recycle bin
b. Creating short cuts for folder/file
c. Finding a file or folder by name
d. Selecting and moving two or more files/folders using mouse
e. Sorting folders/files.
3. a. Copying files into CD/DVD
b. Switching between applications
c. Making the taskbar wider and hiding the taskbar
d. Recording and saving an audio file
e. Set/Change the date and time.
WORD PROCESSING

---

Introduction – Menus – Tool bar – Create – Edit – Save – Alignment – Font Size – Formatting – Tables – Fill Colors – Mail Merge – Page Setup - Preview –Water marking – Header – Footer – Clip art.

Exercises
4. Create the following table and perform the operations given below

ABC PVT. LTD.
Chennai
Production Summary of various Units in every Quarter

Unit	Product - ID	Jan-Mar	Apr-june	July-Sept	Oct-Dec.
Unit - I	56	234	50	74	125
Unit - II	142	236	126	175	251
Unit - III	213	541	216	60	43
Unit - IV	125	243	127	250	136
Unit - V	143	152	138	80	45

•  
• Arrange Unit name as left align and other columns as right align.
• Use doubled Border to the Summary Title and fill with 15% gray colour.
• Implement merging and splitting two or more cells
• Give alternative fore colour for columns.
• Print the above table.

5. Create a standard covering letter and use mail merge to generate the customized letters for applying to a job in various organizations. Also, create a database and generate labels for the applying organizations.

6. Create a news letter of three pages with two columns text. The first page contains some formatting bullets and numbers. Set the document background colour and add ‘confidential’ as the watermark. Give the document a title which should be displayed in the header. The header/ footer of the first page should be different from other two pages. Also, add author name and date/ time in the header. The footer should have the page number.

SPREADSHEET

---

Introduction – Menus – Tool bar – Create – Edit – Save – Formatting cells – Chart wizard – Fill Colors – Creating and using formulas – Sorting – Filtering.

Exercises

7. Create a result sheet containing Candidate's Register No., Name, Marks for six subjects. Calculate the total and result. The result must be calculated as below and failed candidates should be turned to red.

• Result is Distinction if Total >= 70 %
• First Class if Total > = 60 % and < 70 %
• Second Class if Total >= 50 % and < 60 %
• Pass if Total >= 35 % and < 50 %
• Fail otherwise
• Create a separate table based on class by using auto filter feature.

8. Create a table of records with columns as Name and Donation Amount. Donation amount should be formatted with two decimal places. There should be at least twenty records in the table. Create a conditional format to highlight the highest donation with blue colour and lowest donation with red colour. The table should have a heading.

9. Prepare line, bar and pie chart to illustrate the subject wise performance of the class for any one semester.

SECTION – II

DATABASE

---

Introduction – Menus – Tool bar – Create – Edit – Save – Data types – Insert – Delete – Update – View – Sorting and filtering – Queries – Report – Page setup – Print

Exercises

10. Create Database to maintain at least 10 addresses of your class mates with the following constraints

• Roll no. should be the primary key.
• Name should be not null

11. Prepare a payroll for employee database of an organization with the following details: Employee Id, Employee name, Date of Birth, Department and Designation, Date of appointment, Basic pay, Dearness Allowance, House Rent Allowance and other deductions if any. Perform simple queries for different categories.

12. Design a pay slip for a particular employee from the above database.

PRESENTATION

---

Introduction – Menus – Tool bar – Create – Edit – Save – Slide transition – Insert image – Hyper link – Slide numbers – View slide show with sound – Photo album – Clip art.

Exercises

13. Make a marketing presentation of any consumer product with at least 10 slides. Use different customized animation effects on pictures and clip art on any four of the ten slides.

14. Create a Presentation on “Communication Skills” with three different slide transitions with sound effect.

15. Create a photo album in PowerPoint.

INTERNET

---

Introduction – Browsers – Open a website – Email: Send, receive and delete – Email with Attachments Google docs – Search Engines – Searching topics

Exercises

16. Create an e-mail id and perform the following

• Write an e-mail inviting your friends to your Birthday Party.
• Make your own signature and add it to the e-mail message.
• Add a word attachment of the venue route
• Send the e-mail to at least 5 of your friends.

17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use  “Discussion” option for your discussions on the presentation.

18. Find out the direction and distance about road travel from Delhi to Agra using the Internet search. Also make a report of the Map and other details like place to stay and visit at Agra.

Diplomo computer Lab syllabus for C programming practical

C Programming Practical

"L" Scheme Syllabus - Sub Code: 25236
LAB EXERCISES

PART - A

1. Write a C Program to calculate Simple and Compound interest
2. Write a C Program to swap two variables using (i) third variable and (ii) without using a third variable.
3. Write a C Program to find the largest number between given three numbers.
4. Program to check whether the given string is palindrome or not.
5. Read a string, which consists of both lower case characters and  upper case characters. Convert the lowercase character into upper case and vice versa. Display the new string.
6. Program to prepare the total marks for N students by reading the Regno,, Name, Mark1 toMark6 by using array of structures. .
7. Write a function to calculate the sum and average of given three numbers. Write  a main function to call the above function
8. Using pointers, find the length of the given string.
9. Write a program to print the address of a variable and increase the content by 5 and print the new value.
10. Write a Macro in C to swap two data values.

PART – B

1. Read an integer number. Find the number of digits and sum of all individual digits and also print the above number in reverse order.
2. Using Switch… Case Statement, print the given number into equivalent Word. ( For example if the input is 3, then the output should be THREE)
3. Write a program to find the factorial of a given number (i) Without recursion (ii)With recursion
4. Write a program to arrange the given N names in alphabetical order.
5. Write a program to read a string S1 from the terminal. Again read a string S2 from the terminal and check the given string S2 in the string S1. If it does, remove string S2 from the string S1 and print the updated string S1. ( For example S1 = Concatenate and S2 = cat , then the final result should be “Conenate”
6. Program to read ten values to an array variable. Use pointers to locate and display each value.
7. Reverse the following using pointers ( i) String ( ii) N integer numbers stored in any array.

Sub Code: 14036
"K" Scheme Lab Exercise:
On completion of the experiment students should be able to write programs in C and execute it.

1. Program to calculate simple and compound instrest.
2. Solution of a Quadratic Equation.
3. Program for Pay bill calculation.
4. Program to compute sum of series using While loop.
5. Printing of multiplication table using Do…While loop.
6. Program to find whether the given number is a positive number, negative number or zero.
7. Program to sort a list of numbers
8. Program to sort the strings.
9. Preparation of the rank list of a class of students.
10. Program to implement Matrix addition & multiplication.
11. Program to implement Fibannoci series.
12. Program to find factorial of given N numbers with out recursion.
13. Program to find factorial of given N numbers with recursion.
14. Program to tabulate a survey data.
15. Program to count number of characters, words & lines in a text.
16. Program to develop a pattern (eg.: pyramid, square)
17. write a function to swap the values of to variables to illustrate the concept of pass by reference.
18. write a program to add five numbers by getting the values through command line argument .

REQUIREMENTS:
Software:
• C Compiler with editor
Hardware:
• Pentium IV Computer 20 Nos

Diplomo computer Lab syllabus for Linux practical

Linux Practical

"L" Scheme syllabus - Sub Code: 25235

 

PART – A LINUX COMMANDS

1. Write down the syntax and usage of the following exercise with all options. Check the commands with the system (a) Logon to UNIX and logoff. (b) Usage of directory management commands: ls, cd,pwd, mkdir,rmdir (c) Usage of File Management commands: cat, chmod,cp,mv,rm, more, file commands
2. Use the general purpose commnds: wc, od, lp, cal , date, who , tty ,ln
3.  Using the simple filters: pr, head, tail, cut, paste, nl, sort
4. Advanced filters : Search for a pattern using grep, egrep & fgrep
5. To know the details of process status- ps command , Process management commands: &, nohup, kill, nice
6. Communication Commands: news, write, mail, wall, calendar
7. Device pattern using meta character to match each of the following situation:-

• All two character filenames.
• All filenames consisting of two lowercase letters.
• All filenames ending with c.
• All filenames beginning with a c and ending with a digit.
• All filenames beginning with p and having at somewhere.

PART – B SHELL SCRIPTS

1. Write a shell-script that accepts a numerical value N. Then display the decrementing value of N till it reaches 0.
2. Write a shell-script that takes three command line arguments. The first argument is the name of the destination file and the other two arguments are names of files to be placed in the destination file.
3. Write a Shell script to print contents of file from given line number to next given number of lines
4. a)Shell script to say Good morning/Afternoon/Evening as you log in to system b)Write a shell-script that print out date information in this order: time, day of the week, day number, year – that is like this. 13:55:00  IST Sun 9 Jun 1996
5. Write a shell-script that tells you its name and PID
6. Develop a Basic math Calculator using case statement
7. Write a shell-script that takes a login name as a command line argument and reports to you when that person logs in. Have it sent a greeting to that person.
8. Write a shell-script that takes a command line argument and reports on whether it is a directory, a file or something else.

"K" Scheme - Operating System

Sub Code: 15036

Lab Exercise:

1. Execute the following commands and write down the results and use of each command : (i) man (ii) cd (iii) cd. (iv) cd.. (v) ls, ls – a (vi) pwd
2. a)Make your own subdirectories called uni and linu in your home directory. Then delete the sub directory called uni.
   b)Explore the file system, write what is there in /bin, /usr/bin, /sbin/tmp and /boot. Find and list the devices that are available in your system.
3. a).Create a file called intro.text that contains the word “hello I am the student of computer branch”. Now copy this file and paste to other directory.
   b) Change the permission of the above file to rwxrwxr-x. You can try different possibilities to change its permissions. Find out what are the different commands available that can be used to change the permissions of a file/files.
   c) Display the name of all files in the home directory using find. Can you display the name of all files in the home directory that are bigger than 500 KB.
4. a).Use finger or who to get a list of users on the machine
   b)Add different users, set their passwords and define permissions. Check whether you are able to change the passwords of all users or not.
   c)Delete the user, which just now you have created.
5. a).Try to access your account available at a remote machine. Download some file from that machine to your machine.
   b) Create a cron job that sends you a message after every 5 minutes.
   c) Write a message to inform all users that “ they should shut down their machine after completing the lab exercise.
6. Write and execute the following programs in Linux using Shell script :
   I. Factorial of a given number (ii) Sum of odd / even numbers from M to N
7. Write and execute the following programs in Linux using Shell script :
   I. To find the greatest of given three numbers.
   II. Find out the maximum and minimum number of the given series
8. Write and execute the following programs in Linux using Shell script :
   I. To reverse the given string and check whether it is PALINDROME or not.
   II. To find the length of the given string.
9. Develop a Calculator application using shell script
10. Implement deadlock Avoidance Algorithm using C language.
11. Implement multithreading concepts using C language.
12. Given the list of processes, their CPU burst times and arrival times, display/print the Gant chart for FCFS. Compute and print the average waiting time and average turnaround time. Write a C program for the above task

Requirements:
Software:
1. Linux operating system 2. C Compiler with editor
Hardware:
(1) Computer with Pentium IV / Dual core Processors. – 36 Nos
(2) Printer – 3 Nos.

Diplomo computer Lab syllabus for BEEE practical

Electrical And Electronics Engineering Practical

"L" Scheme Syllabus - Sub Code :25234

1. a. Measure current, voltage and resistance using various test meters Ammeter, Voltmeter and multi meter. b. Checking of Power Supply- SMPS.
2. Verify Ohm’s Law and Kirchoff’s Laws
3. To observe waveforms of A.C. Voltage and current on CRO. Determine amplitude and phase and understand the concepts of lagging and leading
4. To determine efficiency and voltage regulation of single phase transformer by direct loading method.
5. Draw the forward bias and reverse bias characteristics of a PN Junction diode and determine the forward resistance of the diode
6. Draw the forward and reverse bias characteristics of a Zener
7. Draw the characteristics of Common Emitter Configuration and determine its input impedance, output impedance and current gain.
8. Construct and test full- wave rectifier and bridge rectifier circuit.
9. Verify truth tables of logic gates using IC 7404, 7408, 7432, 7402, 7400,7486
10. Verify De-Morgan’s Theorems.
11. Construct Half adder and full adder circuits using ICs and verify their truth table
12. Construct Half subtractor and full sub tractor using ICs and verify their truth table
13. Verify the operation of a multiplexer and de-multiplexer using IC’s
14. Implement and Test RS, JK, T and D flip-flops.
15. Construct and test 4-bit ripple counter and observe the output waveform
16. Construct and test synchronous counter and observe the output waveform.
17. Construct and test 4-bit shift registers

"K" Scheme Lab Exercise:

1. Test the value of the resistance by using
   (i) Analog and Digital multimeter
   (ii) Color coding with and without tolerance value.
2. a)Measure current, voltage and resistance using Various test meters – Ammeter, Voltmeter and multi meter.
   b)Generate AC and DC signals using signal generator and power supply.
3. Verify Ohm’s law and Kirchoff’s law.
4. Draw the forward bias characteristics of a PN Junction diode and determine the forward resistance of the diode.
5. Draw the reverse bias characteristics of a Zener diode.
6. Draw the characteristics of Common Emitter Configuration and determine its input impedance, output impedance and current gain.
7. Construct the following circuits using Op-Amp IC 741
   (i) Inverting Amplifier
   (ii) Non – inverting Amplifier
   (iii) Adder
   (iv) Subtractor.
8. Construct and test half - wave and full - wave rectifier circuits.
9. Verify truth tables of logic gates using IC 7404, 7408, 7432, 7402, 7400 and 7486.
10. Realize the logic gates using Universal gates.
11. Realize the circuit to simplify the logic equation by using karnaugh map.
12. Verify De-Morgan’s Theorems.
13. Construct Half adder and full adder circuits using ICs and verify their truth table.
14. Construct Half subtractor and full subtractor circuits using ICs and verify their truth table.
15. Verify the operation of a multiplexer and de-multiplexer using IC’s
16. Verify the operation of a decoder and encoder circuits.
17. Implement and Test RS, JK, T and D flip-flops.
18. Construct and test 4-bit ripple counter and observe the output waveform.
19. Construct and test asynchronous decade counter and observe the output waveform.
20. Construct and test 4-bit shift registers.

Equipments/Components Required

Equipments:

Sno.	Name of the equipments	Range	Required Nos.
1	Digital Multimeter		6
2	Ammeter	(0-50) mA	6
3	Voltmeter	(0-20) V, 30 MHz	6 6
	Power supply	0-30V	6
5	Digital Trainer Kit		6
6	Bread Board		6
7	Fixed dual power Supply	0-15 V	2
8	Signal generator	1 MHz	2
9	CRO Dual Trace	30 MHz	6

Components:

Sno	Name of the components
1	Resistors	150Ω, 1KΩ, 2.2KΩ,10KΩ,2 20Ω
2	Capacitor	10μF, 4.7μF
3	PN Diode	IN4007
4	Zener Diode	Z11.1
5	Transistor	SL100,CL100
6	IC7400, IC7402, IC7404, IC7408, IC7432, IC7486
7	IC74161(Counter)
8	IC74153(MUX)
9	IC74139(DMUX)
10	IC7476 (Flip-Flop)
11	IC74194 (Shift Register)