Module 4-6 (Microsoft Word, PPT, Excel).pdf

Lesson 4: Increasing Productivity through PREPARED BY: Ms. Lira Macias Objectives: At the end of this module, you will be able to do the following: Describe the environment of various productivity tools, particularly Microsoft Office application...

Lesson 4: Increasing Productivity through PREPARED BY: Ms. Lira Macias Objectives: At the end of this module, you will be able to do the following: Describe the environment of various productivity tools, particularly Microsoft Office applications. Use the advanced features of the productivity tools in the context of your chosen track. Create products using the advanced features of each productivity tool. Apply inserting citations and bibliography in a document. TOPIC: MICROSOFT WORD MICROSOFT WORD MICROSOFT POWERPOINT MICROSOFT POWERPOINT MICROSOFT EXCEL MICROSOFT EXCEL  Is one of the skills that are essential to the 21st century. It is the ability of an individual to complete simple to complex tasks at a given time using available resources.  VERSION: Microsoft Office 95 Microsoft Office 2010 Microsoft Office 97 Microsoft Office 2013 Microsoft Office 2000 Microsoft Office 2016 Microsoft Office XP Microsoft Office 2021 Microsoft Office 2003 Microsoft Office 365 Microsoft Office 2007  - Microsoft Word is a word processor developed by Microsoft. It was first released on October 25, 1983. It is also known as MS Word.  AutoCorrect - Corrects common spelling errors as well as capitalization mistakes AutoFormat - applies formatting to text, e.g. number listing, bullet, hyperlinks Grammar Checker - proofreads documents for grammar, writing style, sentence structure errors and reading statistics Template - a document that contains the formatting necessary for a specific document type Thesaurus - provides synonyms for a word in a document Tables - organize information into rows and columns Text Wrap - adjusts how the image behaves around other objects or text General Program Shortcuts  Ctrl + N - Create a new document Ctrl + O - Open an existing document Ctrl + S - Save a document Ctrl + W - Close a document Ctrl + Z - Undo an action Ctrl + Y - Redo an action Backspace - Delete one character to the left Ctrl + Backspace - Delete one word to the left Delete - Delete one character to the right Ctrl + Delete - Delete one word to the right Ctrl + C - Copy text or graphics to the Clipboard Ctrl + X - Cut selected text or graphics to the Clipboard Ctrl + V - Paste the Clipboard contents Applying Character Formatting  Ctrl + B - Apply bold formatting Ctrl + I - Apply italic formatting Ctrl + U - Apply underline formatting Ctrl + Shift + < or > - Decrease or increase font size one preset size at a time Ctrl + [ or ] - Decrease or increase font size one point at a time  Creating a bulk of documents, such as certificates, invitations, letters, and emails, for a number of recipients Mail Merge will help you automatically fill out information for these documents to make efficient use of your time. - a feature that allows you to create a document and merge them with another document or data file  DATA SOURCE – this is the list of recipients that you want to include in your document. You can spreadsheet, your Microsoft Outlook contact list, or the local list in your Microsoft Word for purpose. DOCUMENT – This is the file that will be sent to the recipients. The three types of documents that you need to select for distribution are (1) letters, (2) email, and (3) envelopes. PLACEHOLDERS – there are also called as ”merge fields”. Placeholders mark the place of the data from the source on the document.  Another advanced feature of Microsoft Word is that it has the capability to insert citation and bibliography into a document. You do not have to do it manually anymore in your research paper.  PERFORMANCE TASK (word) A. Create a certificate using mail merge ▪ Template may get from Canva/Word or you may create your own ▪ 10 persons from your section (list) ▪ It will be submitted to google classroom (TBA) for deadline File name ▪ (EXCEL) for list – Surname_CertificateList ▪ (WORD) – Surname_Certificate  PERFORMANCE TASK B. Create a curriculum vitae in Microsoft word ▪ It will be submitted in google classroom (TBA) for deadline ▪ Send it in PDF format. ▪ File name: - Surname_CV  Is an application software that allows users to create visual aids for presentations to communicate ideas, messages, and other info to a group. To open Microsoft PowerPoint, press “Windows Logo” + R then type “powerpnt” then enter. THE INTERFACE OF MS POWERPOINT  Ribbon The ribbon contains a series of tabs that you can switch between. Each of these have a unique set of tools to work with your presentation differently. THE FILE TAB Save, share, and export your presentation.  THE HOME TAB Use it for: a general selection of the most popular tools in PowerPoint. The Home tab has many of the most commonly used tools, all in one bar  The Insert Tab The Insert tab has the tools you need to add tables, pictures, charts, and more  THE DESIGN TAB Controls the overall look and feel of your presentation with theme and style settings. THE TRANSITIONS TAB Add animations when you switch slides. The ANIMATIONS Tab Controls the order and style that objects will enter or exit your slide with.  Animation provides visual motion to various objects in the Presentation, such as texts, pictures, shapes, smart shapes, and charts.  Entrance Emphasis Exit Motion Paths (green star icon) (yellow star icon) (red star icon) Used to specify Used to define These animation How you want the how you want the how you want the are used to object to travel object to object to appear highlight the through the area disappear from on your slide object of your slide your slide  Start – specify how the animation will start Duration – this defines how long the animation will be in effect Delay – how long the animation will be delayed before it starts.  THE SLIDE SHOW TAB Control settings related to the way your presentation appears when sharing it with an audience. THE REVIEW TAB This tab is used to check the spelling in the presentation, to add comments to different slides within the presentation  THE VIEW TAB The Views tab changes the perspective on your PowerPoint presentation. Link - Free ui icons This is an advanced feature of Microsoft PowerPoint that provides a user the ability to connect a presentation to a slide in the document, or a website. For instance, you may use it if you want to be directed to a specific slide by clicking an object.  PERFORMANCE TASK NO. 4 Create an introduction about yourself with the use of PowerPoint Presentation. Hyperlink Transition Animation Timing  PERFORMANCE TASK NO. 4 CONTENT: Name Strand and Section Age Birthday Address MIN. 10 SLIDES School How will you promote your strand Hobbies Introduce yourself Dream 1 or more facts about yourself  Microsoft Excel - Wikipedia Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. ❑ WORKBOOK - an Excel file. - All Excel files are workbooks, with one or many worksheets. ❑ WORKSHEET - A sheet, page, within an excel file.  TABS - The menu bar at the top of Excel. - Ribbon – menu inside the tabs - Group – menu inside the ribbon  CELL - A rectangular box in a worksheet that contains data. - Active Cell – selected cell NAMEBOX - Shows the cell/table selected - also used to rename cells/tables CELL REFERENCE - it is the name of the active/current cell or table.  FORMULA BAR - The Formula Bar is where the contents of the active/current cell are shown. FORMULA - allows you to do automated Calculations - A formula is typed into the formula bar and must begin with an equal (=) sign. FUNCTIONS - Functions are formulas that are built into Excel. - Think of it as an easier way to create formulas.  RANGE - A group of cells or tables denoted by a colon between the 1st and last cell.  SUM =SUM(number1, [number2], …) - allows you to add up the values of numbers in a row or column. - Example: ▪ =SUM(B2:G2) – A simple selection that sums the values of a row. ▪ =SUM(A2:A8) – A simple selection that sums the values of a column.  AVERAGE =AVERAGE(number1, [number2], …) - takes the average of numbers in a row or column. Example: ▪=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2: B11)/10  COUNT =COUNT(value1, [value2], …) - counts all cells in a given range that contains only numeric values. - Example: ▪=COUNT(A:A) – Counts all values that are numerical in A column. However, you must adjust the range inside the formula to count rows. ▪=COUNT(A1:C1) – Now it can count rows.  COUNTA =COUNTA(value1, [value2], …) - counts all cells in a given range regardless of type. - Example: ▪COUNTA(C2:C13) – Counts rows 2 to 13 in column C regardless of type.  MAX and MIN =MIN(number1, [number2], …) =MAX(number1, [number2], …) - helps in finding the maximum number and the minimum number in a pull of values. - Example: ▪ =MIN(B2:C11) – Finds the minimum number between column B from B2 and column C from C2 to row 11 in both column B and C. ▪ =MAX(B2:C11) – Similarly, it finds the maximum number between column B from B2 and column C from C2 to row 11 in both column B and C.  IF =IF(condition, value_if_true, [value_if_false]) - The IF function is often used when you want to sort your data according to a given logic Parameters or arguments Condition - The value that you want to test Value_if_true - It is the value that is returned if the condition evaluates to TRUE Value_if_false - Optional. It is the value that is returned if condition evaluates to FALSE  Microsoft Excel is a tool that can be used to calculate and organize data. Microsoft Excel has numerous functionalities that are widely used in companies and organizations. You can do various mathematical equations, statistics, charts and tables, conditional formatting, sorting and filtering, and many more.  Lookup Value – this is the value you want to look for. Table Array – this is the range to search in. Column Index Number – this is the column number of the value to return in. Range lookup – There are two options here (1) false, if you are looking for the exact match of value; (2) true, if you are looking for the approximate value.  This is used to compute the average of values with a given criteria. For example, you want to compute the average of rating given by students and teachers separately on the dish prepared by culinary students. Syntax of AVERAGEIF: =AVERAGEIF (range,criteria,[average_range]) Range– this refers to the actual group of cells where you want to apply the criteria Criteria– this identifies which cells to average. Average Range– this is the column number of the value to return in. EXERCISES THANK YOU! PREPARED BY: MS. LIRA MACIAS