For Polytechnic Admission
9444302053 & 9176633391

    Welcome to DSL Institute

    Computer on Office Automation DOTE

Faq - Computer on office Automation Training

What is the minimum qualification for appearing in Certificate course in Computer on office automation Training?
A pass in SSLC of Tamilnadu State and A pass in Typewriting(lower) English / Tamil

What is the syllabus for computer on office automation ?
Click here the link for Question Bank Question Bank 40 nos

What will be the pattern of office automation Theory Exam?
I. Fill in the Blanks (Answer all Questions) 10x1=10 marks
II. Match the following (Answer all Questions) 10x1=10 marks
III. Choose the Best Answer (Answer all Questions) 10x1=10 marks
IV. Say True or False (Answer all Questions) 10x1=10 marks V Write short answers for the follwing:(15 x 2 =30)
VI. Write answers in detail: ( 6 x 5 = 30 marks )


What will be the pattern of office automation Practical Exam?
Maximum Marks: 100
In Part-A, each question carries 10 marks (3x10=30)
In Part-B, first question carries 40 marks and second question carries 20 marks (40+20 =60)


how to get office automation Question Bank for practical examination
Click here the link for Question Bank Question Bank 40 nos

What are the duration/timings of computer on office automation ?
Paper I - Theory Examination (2 Hours)
Paper II - Practical Examination(2 Hours)
Note : Mostly saturday and sunday

How to get latest question paper for office automation?
Please visit our Institute or call us 9176633391 & 9444302053


How to get question paper for office automation practical ?
Click here the link for Question Bank Question Bank 40 nos

How will know the result of the Certificat course on Computer automation?
Result will be available our website or http://www.tndte.gov.in

Computer on Office Automation Training in Chennai

Certificate Course in Computer on Office Automation,The Directorate of Technical Education conduct “Certificate Course in Computer on Office Automation” twice in a year in the month of June & December . This course will help to handle Computers in Government / Government organizations / Business and Industry .Nearly in a year 10000+ candidates are benefited . The curriculum is framed at Directorate of Technical
Education with a team of experts in the relevant field. The Examination is conducted and qualified candidates are given Certificate by Directorate of Technical Education. Further Details Pls Contact : 9444302053 & 9176633391

1. Eligibility for Certificate Course in Computer on Office Automation:


A pass in SSLC of Tamilnadu State or Equivalent Examination thereof. and A pass in junior Grade or Senior Grade Typewriting Examination in English / Tamil of the Department of Technical Education, Tamilnadu or the Equivalent Examination thereof.

or

A pass in Higher Grade Typewriting English / Tamil of the Department of Technical Education, Tamilnadu or Equivalent Examination on thereof.

and

 

TRAINING QUALIFICATION:

 

Candidate should have undergone a minimum of 120 hours of training in a recognized Typewriting Institute or Government / Government Aided / Self – financing Polytechnic Colleges.

or

Private candidates who have qualified and undergone a minimum of 120 hours of training may also appear for the Examination as Private Candidate.

2.Certification Course in Computer on Office Automation Theory -SYLLABUS


UNIT 1: BASICS OF COMPUTER

 

Introduction to Computer: Definition - History & Generation of Computer (From First to 5th) -
Applications of Computer – Advantages of Computer – Terms related to Computer - Characteristics of Computer: Speed, Storage, Versatility and Diligence – Hardware & Software. Block Diagram and Working Principle of Computer - Types of Computer: On the Basis of Working - Analog, Digital & Hybrid, On the Basis of Size - Main frame, Mini Computer, Super Computer, Work station, Micro Computer, Desktop Computer, Laptop Computer, Palmtop Computer; On the basis of Processor – XT, AT & Pentium(i3, i5, i7); Memory: Units, Representation, Types - Primary memory: RAM, ROM, PROM, EPROM, EEPROM, DDR Secondary memory: Hard disk, CD, DVD, Blue ray Disc, Pen Drive Magnetic tape & Zip disk – CPU: Components of CPU - Mother board, Hard disk, RAM, ROM, Processor, SMPS & Connecting wire - Graphics Card, Sound Card, Network Card – Modem; Input, Output devices: Keyboard, Mouse, Scanner, Digital Camera, Joystick, Pen drive, Monitor, Printer, Plotter – Connecting port – Serial, parallel – USB port. Computer Networks: Data Communications –Types of Computer Networks – Local Area Networks& Wide Area Networks


UNIT 2: OPERATING SYSTEMS,MS-WINDOWS & LINUX

Windows: Definition of Operating System - Functions of OS - Types of OS: Single user, Multi-User, multi-task, RTOS, Single-user, Multi-tasking – Windows Desk top - GUI: Definition, Standards, Cursors/Pointers, Icons, GUI Menus, GUI-Share Data – Desktop icons and their functions: My computer, My documents, Network neighbourhood, Recycle Bin, Quick launch tool bar, System tray, Start menu, Task bar – Dialog Boxes: List Box, Spin Control Box, Slide, Drop-down list, Radio button, Check box, Text box, Task Bar - System Tray - Quick launch tool bar - Start button - Parts of Windows -Title bar-Menu bar - Scroll bar- Status bar, Maximize, Minimize, close and Resize & Moving a Window – Windows - Start Menu –Help Menu- Preview Menu; Logoff & Shutdown – Keyboard Accelerators: Key board short keys or hotkeys – Working with Notepad & Wordpad: Opening & Saving files, Formatting, Printing, Inserting objects, Finding & replacing text, Creating & Editing Images with Microsoft paint, using the Calculator – Personalising Windows.

 

Linux Programming & Administration: Introduction to Linux – Features of Linux – Components of Linux – Linux process and Thread Management – File Management System; Linux Commands and Utilities – cat, tail, cmp, diff, wc, sort, mkdir, cd, rmdir, pwd, cp, more, passwd, who, whoami, mv, chmod, kill, write, wall, merge, mail, news – pipes, filters and redirection utilities; System Administration: Installing Linux – Booting the system – Maintaining user accounts – File systems and special files – Backups and restoration.


UNIT 3: OFFICE APPLICATIONS – I,MS OFFICE: MS-WORD,OPEN OFFICE: WRITER

Introduction to MS Office - MS Word and Open Office – Writer: MS Word - Working with Documents -Opening & Saving files, Editing text documents, Inserting, Deleting, Cut, Copy, Paste, Undo, Redo, Find, Search, Replace, Formatting page & setting Margins, Converting files to different formats, Importing & Exporting documents, Sending files to others, Using Tool bars, Ruler, Using Icons, using help, Formatting Documents - Setting Font styles, Font selection- style, size, colour etc, Type face - Bold, Italic, Underline, Case settings, Highlighting, Special symbols, Setting Paragraph style, Alignments, Indents, Line Space, Margins, Bullets & Numbering. Setting Page style - Formatting Page, Page tab, Margins, Layout settings, Paper tray, Border & Shading, Columns, Header & footer, Setting Footnotes & end notes – Shortcut Keys; Inserting manual page break, Column break and line break, Creating sections & frames, Anchoring & Wrapping, Setting Document styles, Table of Contents, Index, Page Numbering, date & Time, Author etc., Creating Master Documents, Web page. Creating Tables- Table settings, Borders, Alignments, Insertion, deletion, Merging, Splitting, Sorting, and Formula, Drawing - Inserting ClipArts, Pictures/Files etc., Tools – Word Completion, Spell Checks, Mail merge, Templates, Creating contents for books, Creating Letter/Faxes, Creating Web pages, Using Wizards, Tracking Changes, Security, Digital Signature. Printing Documents – Shortcut keys. Free Open Source Software: OPEN OFFICE - WRITER: Introduction to Open Office Suite - Selecting the application package, Working with Documents- Formatting Documents - Setting Page style- Creating Tables - Drawing- Tools - Printing Documents - Operating with MS Word documents.

 

 


UNIT 4: OFFICE APPLICATIONS - II,MS OFFICE: MS-EXCEL,OPEN OFFICE: CALC & MATH

Introduction to MS Office – MS Excel and Open Office – Calc: MS Excel: Spread Sheet & its Applications, Opening Spreadsheet, Menus - main menu, Formula Editing, Formatting, Toolbars, Using Icons, Using help, Shortcuts, Spreadsheet types. Working with Spreadsheets- opening, Saving files, setting Margins, Converting files to different formats (importing, exporting, sending files to others), Spread sheet addressing - Rows, Columns & Cells, Referring Cells & Selecting Cells – Shortcut Keys. Entering & Deleting Data- Entering data, Cut, Copy, Paste, Undo, Redo, Filling Continuous rows, columns, Highlighting values, Find, Search & replace, Inserting Data, Insert Cells, Column, rows & sheets, Symbols, Data from external files, Frames, Clipart, Pictures, Files etc, Inserting Functions, Manual breaks, Setting Formula - finding total in a column or row, Mathematical operations (Addition, Subtraction, Multiplication, Division, Exponentiation), Using other Formulae. Formatting Spreadsheets- Labelling columns & rows, Formatting- Cell, row, column & Sheet, Category - Alignment, Font, Border & Shading, Hiding/ Locking Cells, Anchoring objects, Formatting layout for Graphics, Clipart etc., Worksheet Row & Column Headers, Sheet Name, Row height & Column width, Visibility - Row, Column, Sheet, Security, Sheet Formatting & style, Sheet background, Colour etc, Borders & Shading – Shortcut keys. Working with sheets – Sorting, Filtering, Validation, Consolidation, and Subtotal. Creating Charts - Drawing. Printing. Using Tools – Error checking, Spell Checks, Formula Auditing, Creating & Using Templates, Pivot Tables, Tracking Changes, Security, Customization. OpenOffice-Calc - Introduction – Introduction to Spreadsheets, Overview of a Worksheet, Creating Worksheet & Workbooks, Organizing files, Managing files & workbooks, Functions & Formulas, Working with Multiple sheets, Creating Charts & Printing Charts – Operating with MS Excel documents, which are already created and saved in MS Excel.

UNIT 5: OFFICE APPLICATIONS - III,MS OFFICE: MS-ACCESS,OPEN OFFICE: BASE

Introduction to MS Office-MS Access and Open Office-Base: MS Access: Introduction, Planning a Database, Starting Access, Access Screen, Creating a New Database, Creating Tables, Working with Forms, Creating queries, Finding Information in Databases, Creating Reports, Types of Reports, Printing & Print Preview – Importing data from other databases viz. MS Excel etc.OpenOffice-Base – Introduction- Database Concepts – Creating a New Database, Creating Tables, Working with Forms, Creating queries, Finding Information in Databases, Creating Reports, Types of Reports, Printing and Printing preview – Operating with other databases i.e. MS Access etc.


UNIT 6: OFFICE APPLICATIONS - IV,MS OFFICE: MS-POWER POINT,OPEN OFFICE: IMPRESS

Introduction to MS Office-MS Power Point and Open Office-Impress: MS Power point: Introduction to presentation – Opening new presentation, Different presentation templates, Setting backgrounds, Selecting presentation layouts. Creating a presentation - Setting Presentation style, Adding text to the Presentation. Formatting a Presentation - Adding style, Colour, gradient fills, Arranging objects, Adding Header & Footer, Slide Background, Slide layout. Adding Graphics to the Presentation- Inserting pictures, movies, tables etc into presentation, Drawing Pictures using Draw. Adding Effects to the Presentation- Setting Animation & transition effect. Printing Handouts, Generating Standalone Presentation viewer. OpenOffice-Impress - Introduction – Creating Presentation, Saving Presentation Files, Master Templates & Re-usability, Slide Transition, Making Presentation CDs, Printing Handouts – Operating with MS Power Point files / slides.


UNIT 7: INTERNET & ADVANCED COMMUNICATION

Internet and Web Browsers: Definition & History of Internet - Uses of Internet - Definition of WebAddressing-URL-Different types of Internet Connections; Dial up connection, Broad band ( ISDN, DSL, Cable), Wireless ( Wi-Fi, WiMax, Satellite, Mobile) naming convention, browsers and its types, internet browsing, searching - Search Engines - Portals - Social Networking sites- Blogs - viewing a webpage, downloading and uploading the website; Creating an email-ID, e-mail reading, saving, printing, forwarding and deleting the mails, checking the mails, viewing and running file attachments, addressing with cc and bcc. Introduction to various devices & Applications: Other than the computers, (electronic gadgets), which are widely using by executives in the Offices – Tablet, Smart Phone – concept of mobile phone and Tablet and their uses – Various applications using by Tablets and Smart Phones such as UC browser, WhatsApp, Maps, Skype.

 

 


3. Certification Course in Computer on Office Automation Practical Note EXERCISES


1.Starting the Windows Starting a program, running a program Running multiple programs and switching between windows Customizing the Task bar Recycle bin, restoring the deleted files

2. Creating and removing folders Making the taskbar wider, arranging icons on the Desktop Displaying and hiding the taskbar clock Controlling the size of start menu options Creating Shortcuts.

 

3. Installing a screen saver Assigning a wallpaper to Desktop Adding a program to the start menu Adding a program shortcut in the Desktop Customizing the mouse settings

 

4. Expanding and collapsing a folder Recognizing File types using icons Running a program from explorer Renaming a file or folder Sorting a folder

 

5. Displaying the properties for a file or folder Using cut and paste operations to move a file Using copy and paste operations to copy a file Moving and copying files with mouse Searching a file or folder by using search command

 

6. Finding a file or folder, by name Defragmenting the disk, using disk defragmenter Controlling the speaker volume Recording and saving an audio file Connecting a printer to the PC

 

7. Booting Linux, Maintaining User accounts Creating folders, renaming folders and files Copying, moving, deleting files Taking backups and restoration of files Practicing the commands like passwd, who, whoami, kill, write etc.

8. Preparing a Govt. Order / Official Letter / Business Letter / Circular Letter Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript, indenting paragraphs, spacing between lines and characters, tab settings etc.

 

9. Preparing a news letter: To prepare a newsletter with borders, two columns text, header and footer and inserting a graphic image and page layout.

 

10. Creating and using styles and templates To create a style and apply that style in a document To create a template for the styles created and assemble the styles for the template.

 

11. Creating and editing the table To create a table using table menu To create a monthly calendar using cell editing operations like inserting, joining, deleting, splitting and merging cells To create a simple statement for math calculations viz. Totalling the column.

 

12. Creating numbered lists and bulleted lists To create numbered list with different formats (with numbers, alphabets, roman letters) To create a bulleted list with different bullet characters.

 

13. Printing envelopes and mail merge. To print envelopes with from addresses and to addresses To use mail merge facility for sending a circular letter to many persons To use mail merge facility for printing mailing labels.

 

14. Using the special features of word To find and replace the text To spell check and correct. To generate table of contents for a document To prepare index for a document.

 

15. Create an advertisement Prepare a resume. Prepare a Corporate Circular letter inviting the share holders to attend the Annual Meeting

 

16. Using formulas and functions: To prepare a Worksheet showing the monthly sales of a company in different branch offices (Showing Total Sales, Average Sales). Prepare a Statement for preparing Result of 10 students in 5 subjects (using formula to get Distinction, I Class, II Class and Fail under Result column against each student).

 

17. Operating on the sheets: Finding, deleting and adding records, formatting columns, row height, merging, splitting columns etc. Connecting the Worksheets and enter the data. 18. Creating a Chart: To create a chart for comparing the monthly sales of a company in different branch offices

 

19. Using the data consolidate command: To use the data consolidate command to calculate the total amount budgeted for all departments (wages, travel and entertainment, office supplies and so on) or to calculate the average amount budgeted for – say, department office expenses.

 

20. Sorting Data, Filtering Data and creation of Pivot tables.

 

21. Creating Student’s address Database and then list the data on the screen in alphabetical order.

 

22. Performing various queries.

 

23. Generating Query in Access

 

24. Generating the Report from Database

 

25. Importing and exporting data.

 

26. Creating a new Presentation based on a template – using Auto content wizard, design template and Plain blank presentation.

 

27. Creating a Presentation with Slide Transition – Automatic and Manual with different effects.

 

28. Creating a Presentation applying Custom Animation effects – Applying multiple effects to the same object and changing to a different effect and removing effects.

 

29. Creating and Printing handouts

 

30. Searching for a web site / application / text documents viewing and downloading.

 

31. Create an E-mail account, Retrieving messages from inbox, replying, attaching files filtering and forwarding

 

32. Operating on a Tablet / Smart Phone - browsing and practising on some important applications (UcBrowser, Skype) - operating on internet – creating and sending messages / mails using the applications like WhatsApp and WeChat - downloading text and media files and video conferencing using Skype.

 

4. Computer on Office Automation Practical Question Bank

 

“Certificate Course in Computer on Office Automation” June 2018 examination, each candidate will be allotted any one question by draw by lots method from these 40 questions.

 

Part - A

1. Start a program, run a program.(10 marks)

2. Run multiple programs and switch between windows. (10 marks)

3. Boot Linux, maintain user accounts. (10 marks)

Part - B

1. Prepare a Govt. Order Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript, indenting paragraphs, spacing between lines and characters, tabs Settings in MS-Word. (40 marks)

2. Perform Finding, deleting and adding records, formatting columns, row height, merging, splitting columns etc in Open Office – Calc. (20 marks)

 

 

Part - A

1. Customize the Task bar.

2. Send a file to Recycle bin and restore.

3. Create folders, rename folders and files in Linux.

Part - B

1. Prepare a newsletter with borders, two columns text, header and footer and insert a graphic image and page layout in MS-Word.

2. Connect the Worksheets and enter the data in Open Office – Calc.

 

Part - A

1. Create and remove folders.

2. Make the taskbar wider, arrange icons on the Desktop.

3. Copy, move, delete files in Linux.

Part - B

1. Create a style and apply that style in a document. Create a template for the styles created and assemble the styles for the template in MS-Word.

2. Create a chart for comparing the monthly sales of a company in different branch offices in calc.

 

Part - A

1. Display and hide the taskbar clock.

2. Control the size of start menu options.

3. Backup and restore files in Linux.

Part - B

1. Create a monthly calendar, use cell editing operations like inserting, joining, deleting, Splitting and merging cells in MS-Word.

2. Use the data consolidate command to calculate the total amount budgeted for all departments (wages, travel and entertainment, office supplies and so on) in Open Office – Calc.

 

Part - A

1. Create and remove folders.

2. Create Shortcuts.

3. Execute the commands – passwd, who, whoami, kill, write.

Part - B

1. Create numbered lists with different formats (with numbers, alphabets, roman letters). Create a bulleted list with different bullet characters in MS-Word.

2. Use the data consolidate command to calculate the average amount budgeted for department office expenses in Open Office – Calc.

 

Part - A

1. Install a screen saver.

2. Assign a wallpaper to Desktop.

3. Set header and footer in Open office writer.

Part - B

1. Print envelopes with from addresses and to addresses using Mail-merge . Use mail merge facility for sending a circular letter to many persons. Use mail merge facility for printing mailing labels in MS-Word.

2. Sort Data and Filter Data in Open Office – Calc.

 

Part - A

1. Add a program to the start menu.

2. Add a program shortcut in the Desktop.

3. Create a style and apply that style in Open office writer.

Part - B

1. Prepare a document in MS-Word. - use find and replace text - use spell check and Auto correct - generate table of contents - index for a document

2. Create Pivot tables in Open Office – Calc.

 

Part - A

1. Add a program shortcut in the Desktop.

2. Customize the mouse settings. 3. Include a picture in a slide in open office impress.

Part - B

1. Create an advertisement. Prepare a resume. Prepare a Corporate Circular letter inviting the share holders to attend the Annual Meeting in MS-Word.

2. Create Student’s address Database and then list the data on the screen in alphabetical order in Open Office-Base.

 

Part - A

1. Expand and collapse a folder.

2. Run a program from explorer.

3. Import the data from calc in Open office base.

Part - B

1. Prepare a Worksheet showing the monthly sales of a company in different branch offices (Showing Total Sales, Average Sales) . Prepare a Statement for preparing Result of 10 students in 5 subjects (using formula to get Distinction, I Class, II Class and Fail under Result column against each student) in Excel.

2. Prepare a Govt. Order Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript in Open office – Writer.

 

Part - A

1. Rename a file or folder.

2 Sort a folder.

3.Create a table in Open office writer.

Part - B

1.Perform the operation on sheets : Finding, deleting and adding records, formatting columns, row height, merging, splitting columns etc . Connect the Worksheets and enter the data in MS-Excel.

2.Prepare a newsletter with borders, two columns text, header and footer and insert a graphic image and page layout in Open office –Writer.

 

Part - A

1. Display the properties for a file or folder.

2. Use cut and paste operations to move a file.

3. Set header and footer in Open office writer.

 

Part - B

1. Create a chart for comparing the monthly sales of a company in different branch offices in Excel.

2. Prepare a document with create a style and apply that style in a document in Open office –Writer.

 

Part - A

1. Use copy and paste operations to copy a file.

2. Move and copy files with mouse.

3. Create a bulleted list in Open office –Writer.

Part - B

1. Use the data consolidate command to calculate the total amount budgeted for all departments (wages, travel and entertainment, office supplies and so on) or to calculate the average amount budgeted for – say, department office expenses in Excel.

2. Create a table using table menu in Open office –Writer. create a simple statement for math calculations viz. totaling the column in Open office –Writer.

 

Part - A

1. Search a file or folder by using search command.

2. Display the properties for a file or folder.

3. Find and replace the text in Open office –Writer.

Part - B

1. Use Sort Data , Filter Data in a worksheet and create a Pivot table in Excel.

2.Create a monthly calendar use cell editing operations like insert, join, delete, Split and merge cells in Open office –Writer.

 

Part - A

1. Find a file or folder, by name.

2. Defragment the disk, using disk defragmenter.

3. Delete and add records in calc.

Part - B

1. Create Student’s address Database and then list the data on the screen in alphabetical order in Access.

2.Create numbered list with different formats (with numbers, alphabets, roman letters) in Open office –Writer.

 

Part - A

1. Control the speaker volume.

2. Record and save an audio file.

3.Search for a website using a browser working in Linux.

Part - B

1. Perform various queries in MS- Access.

2. Create a bulleted list with different bullet characters in Open office –Writer.

 

Part - A

1. Connect a printer to the PC.

2. Control the speaker volume.

3. Sort the data of a table in Calc.

Part - B

1. Generate Query in MS-Access.

2. Print envelopes with from addresses and to addresses using Mail merge facility in Open office –Writer.

 

Part - A

1. Run multiple programs and switch between windows.

2. Expand and collapse a folder.

3. Filter the data of a table in calc.

Part - B

1. Generate the Report from Database in MS-Access.

2. Use mail merge facility for sending a circular letter to many persons in Open office –Writer.

 

Part - A
1. Create Shortcuts.

2. Move and copy files with mouse.

3. Change the column width and row height in calc.

Part - B

1. Import and export data in MS-Access.

2. Use mail merge facility for printing mailing labels in Open office – Writer.

 

Part - A

1. Add a program to the start menu.

2. Move and copy files with mouse.

3. Import the data from calc in Open office base.

Part - B

1. Create a new Presentation based on a template – using Auto content wizard, design template and Plain blank presentation in MSPowerpoint.

2. Prepare a document, use find and replace text, spell check and correct facility in Open office –Writer.

 

Part - A

1. Find a file or folder, by name.

2. Add a program shortcut in the Desktop.

3. Sort the data of a table in calc.

Part - B

1. Create a Presentation with Slide Transition – Automatic and Manual with different effects in MS-Powerpoint.

2. Generate table of contents for a document and prepare index for a document in Open office –Writer.

 

Part - A

1. Search a file or folder by using search command.

2. Find a file or folder, by name.

3. Boot Linux, maintain user accounts.

Part - B

1. Create a Presentation applying Custom Animation effects –Apply multiple effects to the same object and change to a different effect and remove effects in MSPowerpoint.

2. Create an advertisement in Open office –Writer.

 

Part - A

1. Assign a wallpaper to Desktop.

2. Move and copy files with mouse.

3. Create folders, rename folders and files in Linux.

Part - B

1. Create and Print handouts in MS-Powerpoint.

2. Prepare a resume in Open office –Writer.

 

Part - A

1. Sort a folder.

2. Send a file to Recycle bin, and restore.

3. Copy, move, delete files in Linux.

Part - B

1. Search for a web site / application / text documents view and download.

2. Prepare a Corporate Circular letter inviting the share holders to attend the Annual Meeting in open office –Writer

.

Part - A

1. Create shortcuts.

2. Install a screen saver.

3. Send a file to Recycle bin, and restore in Linux.

Part - B

1. Create an E-mail account, Retrieve messages from inbox, reply, attach files filter and forward.

2. Prepare a Worksheet showing the monthly sales of a company in different branch offices (Showing Total Sales, Average Sales) in Open Office – Calc.

 

Part - A

1. Start a program, run a program.

2. Sort a folder.

3. Execute the commands – passwd, who, whoami, kill, write.

Part - B

1. Prepare a Official letter Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript, indenting paragraphs, spacing between lines and characters, tabs settings in MS-Word.

2. Prepare a Statement for preparing Result of 10 students in 5 subjects (use formula to get Distinction, I Class, II Class and Fail under Result column against each student) in Open Office – Calc.

 

Part - A

. 1. Start a program, run a program.

2. Recycle bin, restore the deleted files.

3.Use spell check and correct in open office writer.

Part - B

1. Prepare a business letter Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript, indenting paragraphs, spacing between lines and characters, tabs settings in MS-Word.

2. Generate Query in Open Office-Base.

 

Part - A

1. Run multiple programs and switch between windows.

2. Customize the Task bar. 3. Perform joining, splitting and merging cells in open office writer. Part - B

1. Create numbered lists with different formats (with numbers, alphabets, roman letters).Create a bulleted list with different bullet characters in MS-Word.

2. Generate the Report from Open Office-Base.

 

Part - A

1. Create and remove folders.

2. Control the size of start menu options.

3. Set the spacing between line and characters in open Office Writer.

Part - B

1. Prepare a newsletter with borders, two columns text, header and footer and insert a graphic image and page layout in MS-Word.

2. Import and export data in Open Office-Base.

 

Part - A

1. Display and hide the taskbar clock.

2. Create Shortcuts.

3. Create a style and apply that style in Open office writer

Part - B

1. Prepare a document in MS-Word - use find and replace text - use spell check and Auto correct - generate table of contents - index for a document

2. Perform various queries in Open Office-Base.

 

Part - A

1. Make the taskbar wider, arrange icons on the Desktop.

2 Display and hide the taskbar clock.

3. Set the spacing between line and characters in open Office Writer.
Part - B

1. Create an advertisement . Prepare a resume . Prepare a Corporate Circular letter inviting the share holders to attend the Annual Meeting in MS-Word.

2. Create a new Presentation based on a template – using Auto content wizard, design template and Plain blank presentation in Open Office-Impress.

 

Part - A

1. Install a screen saver.

2. Add a program shortcut in the Desktop.

3. Insert a graphic image in Open office –Writer.

Part - B

1. Prepare a Worksheet showing the monthly sales of a company in different branch offices (Showing Total Sales, Average Sales) . Prepare a Statement for preparing Result of 10 students in 5 subjects (using formula to get Distinction, I Class, II Class and Fail under Result column against each student) in MS-Excel.

2. Create a Presentation with Slide Transition – Automatic and Manual with different effects in Open Office-Impress.

 

Part - A

1. Assign a wallpaper to Desktop.

2. Add a program to the start menu.

3. Create a bulleted list in Open office –Writer.

Part - B

1. Perform the operating on sheets : Finding, deleting and adding records, formatting columns, row height, merging, splitting columns etc .Connect the Worksheets and enter the data in MS-Excel.

2. Create a Presentation applying Custom Animation effects –Apply multiple effects to the same object and change to a different effect and remove effects in Open Office-Impress.

 

Part - A

1. Add a program to the start menu.

2. Customize the mouse settings.

3. Find and replace the text in open office –Writer.

Part - B

1. Create a chart for comparing the monthly sales of a company in different branch offices in MS –Excel.

2. Create and Print handouts in Open Office-Impress.

 

Part - A

1. Expand and collapse a folder.

2. Sort a folder.

3. Create a table in Open office writer.

Part - B

1. Use the data consolidate command to calculate the total amount budgeted for all departments (wages, travel and entertainment, office supplies and so on) or to calculate the average amount budgeted for – say, department office expenses in MS-Excel.

2. Prepare a Business letter Covering formatting commands - superscript, subscript, indenting paragraphs, spacing between lines and characters, tabs Settings in open office –Writer.

 

Part - A

1. Run a program from explorer.

2. Rename a file or folder.

3. Change the column width and row height in calc.

Part - B

1. Use Sort Data , Filter Data in a worksheet and create a Pivot table in MS-Excel.

2. Prepare an official letter Covering formatting commands - font size and styles - bold, underline, upper case, lower case, superscript, subscript in Open office –Writer.

 

Part - A

1. Display the properties for a file or folder.

2. Move and copy files with mouse.

3. Filter the data of a table in calc.

Part - B

1. Create a monthly calendar, use cell editing operations like insert, join, delete, Split and merge cell in MS-Word.

2. Import and export data in Open Office-Base.

 

Part - A

1. Use cut and paste operations to move a file.

2. Use copy and paste operations to copy a file.

3. Sort the data of a table in Calc.

Part - B

1. Create Student’s address Database and then list the data on the screen in alphabetical order in MS-Access.

2. Create a chart for comparing the monthly sales of a company in different branch offices in calc.

 

Part - A

1. Display the properties for a file or folder.
2. Move and copy files with mouse.
3. Include a picture in a slide in open office impress.
Part - B
1. Perform various queries in MS- Access.
2. Perform Finding, deleting and adding records, formatting columns, row height, merging, splitting columns etc in Open Office – Calc.

 

Part - A

1. Find a file or folder, by name.

2. Control the speaker volume.

3. Search for a website using a browser working in Linux.

Part - B

1. Generate the Report from Database in MS-Access.

2. Create an advertisement in Open office –Writer.

 

Part - A

1. Rename a file or folder.

2. Display the properties for a file or folder.

3. Delete and add records in calc.

Part - B

1. Operate on a Tablet / Smart Phone – browse and practise on Some important applications (UcBrowser, Skype) - operate on internet – create and send messages / mails use the applications like WhatsApp and WeChat - download text and media files and video conferencing using Skype.

2. Prepare a resume in Open office –Writer.


5. Office Automation Application Forms and Examination Fees:


Cost of Application : Rs, 30/-
Examination Fee: Rs. 500 /-

Mode of Payment :

Application and Examination fees should be paid by Demand Draft Drawn in favour of “The Additional Director of Technical Education (Exam) ”, Chennai -25.totally for Rs 530/- (Rupees five hundred and thirty only) (To be uploaded in website and the copy to be downloaded and taken a print out.)