Computer Application Lab 72v5y
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report r6l17
Overview 4q3b3c
& View Computer Application Lab as PDF for free.
More details 26j3b
- Words: 4,965
- Pages: 34
RAJAJI INSTITUTE OF TECHNOLOGY, SALEM-636308 BOARD PRACTICAL EXAMINATION, OCTOBER-2012 COMPUTER APPLICATION PRACTICAL Year/ Sem Date
: II/III : 10.10.2012
Sub Code Duration
: 20001 : 3 Hrs
SECTION-I
1. a. Installing screen saver and change the monitor resolution by 1280*960 b. Setting wall papers c. Creating, moving, deleting and removing 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/folder 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 4. a. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% 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 color and lowest donation with red color. The table should have a heading. 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. SECTION-II 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 full 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. 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 10 slides. 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects. 15. Create a photo album in power point. 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 discussion on the presentation. 18. Find 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 say and visit at Agra.
INTERNAL EXAMINER Mr.KARTHIK K LECT/COMPUTER 362,RIT,SALEM
EXTERNAL EXAMINER Mr.ASHOKKUMAR K LECT/ECE 590,TKPTC,MALLUR
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 1. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1
Section-I 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 color and lowest donation with red color. The table should have a heading.
2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 2. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and lowest donation with red color. The table should have a heading. 2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 3. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1
Section-I 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 color and lowest donation with red color. The table should have a heading.
2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE : SUBJECT : Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 4. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
RAJAJI INSTITUTE OF TECHNOLOGY, SALEM-636308 BOARD PRACTICAL EXAMINATION, OCTOBER-2012 COMPUTER APPLICATION PRACTICAL Year/ Sem Date
: II/III : 10.10.2012
Sub Code Duration
: 20001 : 3 Hrs
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE
SECTION – I
SECTION-II
5
TOTAL
INTERNAL EXAMINER Mr.KARTHIK K LECT/COMPUTER 362,RIT,SALEM
EXTERNAL EXAMINER Mr.ASHOKKUMAR K LECT/ECE 590,TKPTC,MALLUR
: II/III : 10.10.2012
Sub Code Duration
: 20001 : 3 Hrs
SECTION-I
1. a. Installing screen saver and change the monitor resolution by 1280*960 b. Setting wall papers c. Creating, moving, deleting and removing 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/folder 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 4. a. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% 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 color and lowest donation with red color. The table should have a heading. 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. SECTION-II 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 full 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. 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 10 slides. 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects. 15. Create a photo album in power point. 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 discussion on the presentation. 18. Find 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 say and visit at Agra.
INTERNAL EXAMINER Mr.KARTHIK K LECT/COMPUTER 362,RIT,SALEM
EXTERNAL EXAMINER Mr.ASHOKKUMAR K LECT/ECE 590,TKPTC,MALLUR
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 1. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1
Section-I 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 color and lowest donation with red color. The table should have a heading.
2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 2. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and lowest donation with red color. The table should have a heading. 2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 3. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 color and add confidential’ as the watermark. Give the document a little which should be displayed in the header. The header/footer of the first page should be different from other two pages. Also add the date/time in the header . The footer should be have the page number. 2
Section-II 14. Create a presentation on “Communication Skills ” with three different slide transition with sound effects.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1 Section-I 4. Create the following table and perform the operations given below ABC PVT.LTD Chennai Production summer 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-III213 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 summery title and fill with 15% gray color Implement merging and splitting two or more cells Give the alternate fore color for columns Print the above table 2 Section-II 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
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 7. Create a result sheet containing Candidate’s 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% Second class if total >=50% if total >=35% Fail otherwise Create a separate table based on class by using auto filter feature. 2 Section-II 12. Design a pay slip for a particular employee from the above database
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III
Code : 20001
Answer all the questions 1
Section-I 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 color and lowest donation with red color. The table should have a heading.
2
Section-II 15. Create a photo album in power point.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE : SUBJECT : Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 9. Prepare line, bar and pie chart to illustrate the subjects wise performance of the class for any one semester. 2
Section-II 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 10 slides.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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/folder using mouse e. Sorting folders/files 2
Section-II 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 full
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 4. a. Installing screen saver and change the monitor resolution by 1280 x 960 b. Setting wall papers c. Creating, moving, deleting and removing a folder d. Copy, paste and cut a folder/file e. Displaying the properties for a file or folder 2
Section-II 18. Find 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 say and visit at Agra.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2
Section-II 17. Create a presentation on Google docs. Ask your friend to review it and comment on it. Use “Discussion “option for your discussion on the presentation.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
NAME :
REGNO :
DATE :
SUBJECT :
Year/ Sem : II/III Code : 20001 Answer all the questions 1 Section-I 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 2 Section-II 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.
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE TOTAL
5
SECTION – I
SECTION-II
RAJAJI INSTITUTE OF TECHNOLOGY, SALEM-636308 BOARD PRACTICAL EXAMINATION, OCTOBER-2012 COMPUTER APPLICATION PRACTICAL Year/ Sem Date
: II/III : 10.10.2012
Sub Code Duration
: 20001 : 3 Hrs
MARK ALLOCATION TABLE MAXIMUM MARKS SECTION I
SECTION -II
WRITING STEPS
15
15
EXECUTION OF EXERCISE
15
15
RESULT WITH PRINTOUT
5
5
VIVA VOCE
SECTION – I
SECTION-II
5
TOTAL
INTERNAL EXAMINER Mr.KARTHIK K LECT/COMPUTER 362,RIT,SALEM
EXTERNAL EXAMINER Mr.ASHOKKUMAR K LECT/ECE 590,TKPTC,MALLUR
Related Documents 171j1w
Computer Application Lab 72v5y
November 2019 43
Application Of Computer Graphics 6n3q9
April 2021 0
Computer-appreciation And Application 4z5z8
November 2021 0
Diploma In Computer Application 5k2t6n
November 2021 0
Application Of Computer 2c1k2x
February 2022 0
Computer Graphics Lab Manual 5e2t6g
October 2019 195More Documents from "Shanthi Ramesh" 5v5w1e
Computer Application Lab 72v5y
November 2019 43
59854107-questionnaire-on-quality-of-work-life.pdf 635548
November 2022 0
Thiruvaimozhi Nootrandhadhi 6l332
November 2019 51
Sudumoninkaadhalbhuvanayaarukoyaaro 3d36p
December 2021 0
285272161-pgp-pi-module.pdf 606d1l
December 2019 31