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