Office Automation Lab – I detail TNDTE Diploma syllabus for Modern Office Practice (MOP1Yr), M scheme is extracted from TNDTE official website and presented for diploma students. The course code (38117), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.
For all other office practice 1st sem syllabus for diploma m scheme tndte you can visit Office Practice 1st Sem Syllabus for Diploma M Scheme TNDTE Subjects. The detail syllabus for office automation lab – i is as follows.
Rationale:
The subjectOffice automation – I helps the students to understand the concepts of Operating System, Windows, MS-Word and MS-Excel.
Objectives:
This subject helps to student to understand about
- Windows Operating System
- Ms Word Documents
- Preparation Tables Mail Merge, Labels, Envelops
- Various Calculations, functions, Pivot Tables
- Preparing Paybill,Charts,etc.
Detailed Content:
Unit I
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.
Unit II
Ms Word – I :
Starting MS Word – Creating document -Parts of Word Window -Mouse operations -Keyboard operations -Individual keys – Entering or typing text- Select- Undo, Redo – cut, delete ,copy, paste, move, paste special -Select all – Find and Replace – Bold, Italic, Underline, Strikethrough, subscript, superscript. Text effects – font colour, font size, style – text highlight – format painter, clear format -bullets, numbering – align text, sorting, styles- Insert Page break – Page number, Date & Time – Auto Text – Picture, clip art – Shapes, Smart Art – Chart, screen shot – Header & footer – text box – Word Art, Drop cap, Equation, symbol.
Unit III
Ms Word – II :
Table and table properties- Draw Table, Eraser – View gridlines – Merge Cells – Split Cells – split Table – Auto fit – Height and Width – Text Directions – Convert – Formula -Page Layout – size, Orientation, Margins, Columns, Hyphenation – watermark, Page color, Page Border, Indent, Spacing, Wrap Text Bring Forward & Send Backward. Mailings – Mail Merge – Envelopes – Labels – spelling – Thesaurus – Word count -Translate – Designing – Shading – save the document – printing – save and send.
Unit IV
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.
Unit IV
Ms Excel- II :
Copying text between worksheets – Deleting – Creating Charts – types – Data filters -Auto Filters – Criteria – Functions – Round, sqrt, average etc. Pivot table – picture – clip art – shapes – what if analysis – spelling – treasures – protect sheet, work book- save and save as – print.
Exercises
Ex.No. Lab Exercises
- Operating System :
- Install screen saver and change the monitor resolution by 1280X960.
- Set a new wall paper.
- Create, move, delete and rename a folder.
- Copy, paste and cut a folder/file .
- Display the properties for a file or folder.
- Restore files and folders from Recycle bin.
- Create short cuts for folder/file.
- Find a file or folder by name.
- Select and move two or more files/folders using mouse .
- Sort folders/files.
- Copy files into CD/DVD.
- Switch between applications .
- Make the taskbar wider and hide the taskbar .
- Record and save an audio file.
- Set/Change the date and time.
- Ms.Word:
- Enter a text about your Institution with two Titles.
- Set the paper size A4 and orientation of the paper to Portrait.
- Make the titles to Center, Bold, Font size 20 and style in Areal.
- Justify the entire Text. Set the margin left 1 . 5, Right 1 . 5, Top and Bottom5
- Use Drop Cap in 1st paragraph 1st character for 3 lines.
- Change the font size of the text to 12 size.
- Use bulleted list and Highlight the important sentences.
- Insert a picture, word art, Header and Footer.
- Save the file.
- Prepare a resume for a suitable job in MS. Word.
- Paper Size A4.
- Orientation – Portrait
- Margin – left 1 . 5, Right 1 . 5, Top and Bottom 1 . 5 .
- Justify the entire Text.
- Font size – 12
- Change the line spacing to 1 . 5 .
- Save Document to Resume.
- Take print.
- Mail Merge – Create an invitation to invite reporters of local Newspapers to cover functions of Annual Day Celebrations of your Polytechnic College using Mail Merge in MS. Word (4 Addresses).
- Creating And Editing The Table :
- Enter three titles
- Enter all data with minimum 8 rows
- Insert a New Row Between 3rd and 4th row and enter a new row and give the data.
- Get the Total. Give double line borders and shadows 12 . 5% Grey
- Change the font size 12 the data available in the Table.
- Sort the name in ascending order.
- Centre the title lines with Font style Garamond size 16 .
- Aline all lines and Centre the Table.
- Save the file.
- Create an Advertisement in MS. Word aboutyour Institution, regarding the Diploma courses offered and facilities available.
- Prepare a table of contents for a document. Prepare index for a document.
- EXCEL . Create a Statement in MS. Excel regarding particulars of 10 students of I Year MOP of your College .
- Enter Two Titles
- Enter the 1st and 2ndTitles in first and second rows with different font size and styles.
- Enter Roll No.,Name, etc as Field names.
- Enter the Roll Number using Fill Handle.
- Enter 10 students particulars.
- Centre the Titles.
- Insert a New Row between 5th and 6thRow .
- Enter a New Student’s particulars in the new Row.
- Delete the Last row.
- Insert a New Column between 3rdt and 4th Column for Sex.
- In the Sex column enter Sex = “M” or “F”
- Align all the Data in Centre.
- Save the File.
- From the following given particulars prepare a Salary Statement in MS . Excel Worksheet. DEVI ENTERPRISES COIMBATORE641 044 S . No .,Emp-No ., Name, Basic Pay, DA, HRA, Gross Pay, PF, IT, Deductions and Net Pay . Enter data for EMP-No ., NAME, and BASICPAY .
- Calculate DA = 90% of Basic Pay, HRA = 5% of Basic Pay
- Calculate Gross Pay = Basic Pay + DA + HRA
- Calculate PF = 6% of Basic Pay, IT = 10% of Gross Pay
- Calculate deductions = PF + IT.
- Calculate Net Pay = Gross Pay – Deductions.
- Create a result sheet containing Candidate’s Register No., Name, Marks for five subjects
- Calculate Total Marks & Average Marks of 5 subjects ( Use Fill handle)
- Calculate Average Marks of each student
- Fill the Result Column by using the following condition. If a student secures 40 or more than 40 marks in each subject will adjudged as Pass, otherwise Fail.
- Fill the Grade Column by using the following condition: If a student’s result is pass and secures Average marks more than 75, he/she gets Honours , more than 60,he/she gets I Class, otherwise II Class
- Highlight the marks who secures less than 40, by using different colour.
- Prepare line, bar and pie chart to illustrate the subject wise performance of the class for any one semester with the following data.
- English – 55%
- Commerce – 75%
- Accountancy – 80%
- Computer – 70%
- Typewriting – 90%
- Economics – 95%
- Prepare consolidation of work sheets in MS. Excel. Prepare consolidation of I Qtr, II Qtr, III Qtr& IV Qtr sales Turnover of different Branches of a Company.
- Create Pivot Table Report in MS Excel.
Creating a Document:
Create a student details in Ms-Word table format which has details of ROLLNo., NAME, CLASS, MARK 1, MARK 2, MARK 3 and find
TOTAL and Average of the marks. (Things to be covered)
( Fields : Roll No. , Name, Community, DOB, Age, Address,& 10th Mark. (Things to be Covered)
Fill the S . No . column with Autoseries.
Reference Books:
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.
Allocation Of Marks
- Content Max Marks
- Procedure 30
- Execution 40
- Viva voce 5
Total 75
For detail syllabus of all other subjects of BE Office Practice, M scheme do visit Office Practice 1st Sem syllabus for M scheme.
Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.