{"id":25999,"date":"2020-02-25T23:19:58","date_gmt":"2020-02-25T23:19:58","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/38117-office-automation-lab-i-office-practice-1st-sem-syllabus-for-diploma-tndte-m-scheme\/"},"modified":"2020-02-25T23:19:58","modified_gmt":"2020-02-25T23:19:58","slug":"38117-office-automation-lab-i-office-practice-1st-sem-syllabus-for-diploma-tndte-m-scheme","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/38117-office-automation-lab-i-office-practice-1st-sem-syllabus-for-diploma-tndte-m-scheme\/","title":{"rendered":"38117: Office Automation Lab &#8211; I Office Practice 1st Sem Syllabus for Diploma TNDTE M Scheme"},"content":{"rendered":"<p>Office Automation Lab &#8211; I detail TNDTE Diploma syllabus for Modern Office Practice (MOP1Yr), M scheme is extracted from <a href=\"http:\/\/www.tndte.gov.in\/site\/syllabus\/\" target=\"_blank\" rel=\"noopener\">TNDTE<\/a> 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.<\/p>\n<p>For all other office practice 1st sem syllabus for diploma m scheme tndte you can visit <a href=\"..\/office-practice-1st-sem-syllabus-for-diploma-m-scheme-tndte\">Office Practice 1st Sem Syllabus for Diploma M Scheme TNDTE Subjects<\/a>. The detail syllabus for office automation lab &#8211; i is as follows.<\/p>\n<p><h4>Rationale:<\/h4>\n<p>The subjectOffice automation &#8211; I helps the students to understand the concepts of Operating System, Windows, MS-Word and MS-Excel.\n<\/p>\n<p><h4>Objectives:<\/h4>\n<p>This subject helps to student to understand about<br \/>\n<\/p>\n<ul>\n<li>Windows Operating System<\/li>\n<li>Ms Word Documents<\/li>\n<li>Preparation Tables Mail Merge, Labels, Envelops<\/li>\n<li>Various Calculations, functions, Pivot Tables<\/li>\n<li>Preparing Paybill,Charts,etc.<\/li>\n<\/ul>\n<p><strong><br \/>\nDetailed Content:<\/strong>\n<\/ul>\n<\/p>\n<p><h4>Unit I<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> It&#8217;s a lightweight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Unit II<\/h4>\n<p><strong>Ms Word &#8211; I :<\/strong><\/p>\n<p>Starting MS Word &#8211; Creating document -Parts of Word Window -Mouse operations -Keyboard operations -Individual keys &#8211; Entering or typing text- Select- Undo, Redo &#8211; cut, delete ,copy, paste, move, paste special -Select all &#8211; Find and Replace &#8211; Bold, Italic, Underline, Strikethrough, subscript, superscript.  Text effects &#8211; font colour, font size, style &#8211; text highlight &#8211; format painter, clear format -bullets, numbering &#8211; align text, sorting, styles- Insert Page break &#8211; Page number, Date &amp; Time &#8211; Auto Text &#8211; Picture, clip art &#8211; Shapes, Smart Art &#8211; Chart, screen shot &#8211; Header &amp; footer &#8211; text box &#8211; Word Art, Drop cap, Equation, symbol.\n<\/p>\n<p><h4>Unit III<\/h4>\n<p><strong>Ms Word &#8211; II :<\/strong><\/p>\n<p>Table and table properties- Draw Table, Eraser &#8211; View gridlines &#8211; Merge Cells &#8211; Split Cells &#8211; split Table &#8211; Auto fit &#8211; Height and Width &#8211; Text Directions &#8211; Convert &#8211; Formula -Page Layout &#8211; size, Orientation, Margins, Columns, Hyphenation &#8211; watermark, Page color, Page Border, Indent, Spacing, Wrap Text Bring Forward &amp; Send Backward.  Mailings &#8211; Mail Merge &#8211; Envelopes &#8211; Labels &#8211; spelling &#8211; Thesaurus &#8211; Word count -Translate &#8211; Designing &#8211; Shading &#8211; save the document &#8211; printing &#8211; save and send.\n<\/p>\n<p><h4>Unit IV<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> It&#8217;s a lightweight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Unit IV<\/h4>\n<p><strong>Ms Excel- II :<\/strong><\/p>\n<p>Copying text between worksheets &#8211; Deleting &#8211; Creating Charts &#8211; types &#8211; Data filters -Auto Filters &#8211; Criteria &#8211; Functions &#8211; Round, sqrt, average etc.  Pivot table &#8211; picture &#8211; clip art &#8211; shapes &#8211; what if analysis &#8211; spelling &#8211; treasures &#8211; protect sheet, work book- save and save as &#8211; print.\n<\/p>\n<p><h4>Exercises<\/h4>\n<p><strong>Ex.No.\tLab Exercises<\/strong><br \/>\n<\/p>\n<ol>\n<li>Operating System :<\/li>\n<ol type=\"i\">\n<li>Install screen saver and change the monitor resolution by 1280X960.<\/li>\n<li>Set a new wall paper.<\/li>\n<li>Create, move, delete and rename a folder.<\/li>\n<li>Copy, paste and cut a folder\/file .<\/li>\n<li>Display the properties for a file or folder.<\/li>\n<\/ol>\n<li><\/li>\n<ol type=\"i\">\n<li>Restore files and folders from Recycle bin.<\/li>\n<li>Create short cuts for folder\/file.<\/li>\n<li>Find a file or folder by name.<\/li>\n<li>Select and move two or more files\/folders using mouse .<\/li>\n<li>Sort folders\/files.<\/li>\n<\/ol>\n<li><\/li>\n<ol type=\"i\">\n<li>Copy files into CD\/DVD.<\/li>\n<li>Switch between applications .<\/li>\n<li>Make the taskbar wider and hide the taskbar .<\/li>\n<li>Record and save an audio file.<\/li>\n<li>Set\/Change the date and time.<\/li>\n<\/ol>\n<li><B>Ms.Word:  <\/B><\/li>\n<p>\n<strong>Creating a Document:<\/strong><br \/>\n<\/p>\n<ul>\n<li>Enter a text about your Institution with two Titles.<\/li>\n<li>Set the paper size A4 and orientation of the paper to Portrait.<\/li>\n<li>Make the titles to Center, Bold, Font size 20 and style in Areal.<\/li>\n<li>Justify the entire Text. Set the margin left 1 . 5, Right 1 . 5, Top and Bottom5<\/li>\n<li>Use Drop Cap in 1st paragraph 1st character for 3 lines.<\/li>\n<li>Change the font size of the text to 12 size.<\/li>\n<li>Use bulleted list and Highlight the important sentences.<\/li>\n<li>Insert a picture, word art, Header and Footer.<\/li>\n<li>Save the file.<\/li>\n<\/ul>\n<li><B>Prepare a resume for a suitable job in MS. Word.  <\/B><\/li>\n<ul>\n<li>Paper Size A4.<\/li>\n<li>Orientation &#8211; Portrait<\/li>\n<li>Margin &#8211; left 1 . 5, Right 1 . 5, Top and Bottom 1 . 5 .<\/li>\n<li>Justify the entire Text.<\/li>\n<li>Font size &#8211; 12<\/li>\n<li>Change the line spacing to 1 . 5 .<\/li>\n<li>Save Document to Resume.<\/li>\n<li>Take print.<\/li>\n<\/ul>\n<li><B>Mail Merge<\/B> &#8211; 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).<\/li>\n<li>Creating And Editing The Table :<\/li>\n<p>Create a student details in Ms-Word table format which has details of ROLLNo., NAME, CLASS, MARK 1, MARK 2, MARK 3 and find<br \/>\nTOTAL and Average of the marks.  (Things to be covered)<\/p>\n<ul>\n<li>Enter three titles<\/li>\n<li>Enter all data with minimum 8 rows<\/li>\n<li>Insert a New Row Between 3rd and 4th row and enter a new row and give the  data.<\/li>\n<li>Get the Total. Give double line borders and shadows 12 . 5% Grey<\/li>\n<li>Change the font size 12 the data available in the Table.<\/li>\n<li>Sort the name in ascending order.<\/li>\n<li>Centre the title lines with Font style Garamond size 16 .<\/li>\n<li>Aline all lines and Centre the Table.<\/li>\n<li>Save the file.<\/li>\n<\/ul>\n<li>Create an Advertisement in MS. Word aboutyour Institution, regarding the Diploma courses offered and facilities available.<\/li>\n<li>Prepare a table of contents for a document.  Prepare index for a document.<\/li>\n<li>EXCEL .  Create a Statement in MS. Excel regarding particulars of  10 students of I Year MOP of your College .<\/li>\n<p>( Fields : Roll No. , Name, Community, DOB, Age, Address,&amp; 10th Mark.  (Things to be Covered)<\/p>\n<ul>\n<li>Enter Two Titles<\/li>\n<li>Enter the 1st and 2ndTitles in first and second rows with different font size and styles.<\/li>\n<li>Enter Roll No.,Name, etc as Field names.<\/li>\n<li>Enter the Roll Number using Fill Handle.<\/li>\n<li>Enter 10 students particulars.<\/li>\n<li>Centre the Titles.<\/li>\n<li>Insert a New Row between 5th and 6thRow .<\/li>\n<li>Enter a New Student&#8217;s particulars in the new Row.<\/li>\n<li>Delete the Last row.<\/li>\n<li>Insert a New Column between 3rdt and 4th Column for Sex.<\/li>\n<li>In the Sex column enter Sex = &#8220;M&#8221; or &#8220;F&#8221;<\/li>\n<li>Align all the Data in Centre.<\/li>\n<li>Save the File.<\/li>\n<\/ul>\n<li>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 .<\/li>\n<p>Fill the S . No . column with Autoseries.<\/p>\n<ol type=\"i\">\n<li>Calculate DA = 90% of Basic Pay, HRA = 5% of Basic Pay<\/li>\n<li>Calculate Gross Pay = Basic Pay + DA + HRA<\/li>\n<li>Calculate PF = 6% of Basic Pay, IT = 10% of Gross Pay<\/li>\n<li>Calculate deductions = PF + IT.<\/li>\n<li>Calculate Net Pay = Gross Pay &#8211; Deductions.<\/li>\n<\/ol>\n<li>Create a result sheet containing Candidate&#8217;s Register No., Name, Marks for five subjects<\/li>\n<ol type=\"i\">\n<li>Calculate Total Marks &amp; Average Marks of 5 subjects ( Use Fill handle)<\/li>\n<li>Calculate Average Marks of each student<\/li>\n<li>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.<\/li>\n<li>Fill the Grade Column by using the following condition:  If a student&#8217;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<\/li>\n<li>Highlight the marks who secures less than 40, by using different colour.<\/li>\n<\/ol>\n<li>Prepare line, bar and pie chart to illustrate the subject wise performance of the class for any one semester with the following data.<\/li>\n<ul>\n<li>English\t&#8211;\t55%<\/li>\n<li>Commerce\t&#8211;\t75%<\/li>\n<li>Accountancy\t&#8211;\t80%<\/li>\n<li>Computer\t&#8211;\t70%<\/li>\n<li>Typewriting\t&#8211;\t90%<\/li>\n<li>Economics\t&#8211;\t95%<\/li>\n<\/ul>\n<li>Prepare consolidation of work sheets in MS. Excel.  Prepare consolidation of I Qtr, II Qtr, III Qtr&amp; IV Qtr sales Turnover of different Branches of a Company.<\/li>\n<li>Create Pivot Table Report in MS Excel.<\/li>\n<\/ol>\n<p><h4>Reference Books:<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> It&#8217;s a lightweight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Allocation Of Marks<\/h4>\n<ul>\n<li>Content\tMax Marks<\/li>\n<li>Procedure\t30<\/li>\n<li>Execution\t40<\/li>\n<li>Viva voce\t5<\/li>\n<\/ul>\n<p><strong>Total\t75<\/strong><br \/>\n\n<\/ul>\n<\/p>\n<p>For detail syllabus of all other subjects of BE Office Practice, M scheme do visit <a href=\"..\/category\/office-practice-diploma+1st-sem\">Office Practice 1st Sem syllabus for M scheme<\/a>.<\/p>\n<p>Dont forget to <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a> for latest syllabus and results, class timetable and more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Office Automation Lab &#8211; 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 [&hellip;]<\/p>\n","protected":false},"author":2297,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[44,131],"tags":[],"class_list":["post-25999","post","type-post","status-publish","format-standard","hentry","category-1st-sem","category-office-practice-diploma"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/25999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/users\/2297"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=25999"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/25999\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=25999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=25999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=25999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}