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.