Syllabus - CS4 – Lab-2 : Office Automation

CS4 – Lab-2 : Office Automation –

( 6 Hours – 4 Credits)

MS-WORD

1. Open a word document to prepare your Resume by performing the following operations. 

(a)    Formatting the Text- Alignment & Font style

(b)   Page setup (margin alignment,  page height & width)

2. Create a word document to prepare an application form (College,    Bank,  etc)
3. Create a student mark sheet using table,  find out the total & average marks and display the result.   
4. Design an invitation of your course inauguration function using different fonts,  font sizes,  bullets and Word Art/ Clip Art
5. Mail Merge Concept

                  (a) Prepare a business letter for more than one company using mail merge. 

                  (b) Prepare an invitation and to be sent to specific addresses in the data                              source. 

MS-Excel

6. Create suitable work sheet with necessary information and use Data sort to display results.   Also use Data Filters to answer at least five different criteria. 
7. Create suitable work sheet with necessary information and make out a suitable chart showing gridlines,  legends and titles for axes. 
8. Prepare salary bill in a worksheet showing Basic Pay,  DA,  HRA,  Gross salary,  PF,  Tax and Net salary using suitable Excel Functions. 
9. Create,  display and interact with data using Pivot Tables and Pivot Charts of Excel features. 

POWER POINT

10. Create a power point presentation to explain various aspects of your college using Autoplay
11.  Create a power point presentation to explain the sales performance of a company over a period of five years.   Include slides covering the profile of the company,  year wise sales and graph with gridlines,  legends and titles for axes.   Use Clip Art and animation features. 
12. Create a power point presentation from template. 
13. Prepare a presentation using Auto Wizard and see its various views. 
14. Create a power point presentation with audio and video effect.   

MS-Access

15. Cerate a table for storing marks of 10 students.   The fields of the table are given below: Reg.  No,  Name,  Mark1,   Mark2,  Mark3,  Test average(Best Two/2),  Assignment,  Seminar and Total marks(Test average + Assignment + Seminar) The fields ‘Mark1’,   ‘Mark2’,  ‘Mark3’ should not allow the user to enter a mark greater than 25 and should display proper message in such case.   Similar constraint for the field ‘Assignment’ is 5 marks and for the field ‘Seminar’,  it is 10 marks. 
16. Create a table showing names of authors of at least 10 different books,  title of books,  the prices of these books,  name of publishers and year of publication.   Also create Select,  Action and Cross-tab queries to display the records from this table meeting the criteria used in these queries. 
17. Create a form to enter the data directly into this form.   The fields required are: Basic Pay,  DA,  HRA,  Gross salary,  PF,  Income tax and Net salary. 
18. Create a report that displays the customer name,  address,  phone number,  Item code,  product quantity of the customers whose orders have been pending for over a month.