Productivity Tools PDF

 PRODUCTIVITY TOOLS OFFICE SUITE COMPUTER-BASED SUITES WEB-BASED SUITES TYPE OF PRODUCTIVITY TOOLS PRODUCTIVITY TOOLS OFFICE SUITE DATABASE COMPUTER-BASED SPREADSHEET WEB-BASED PRESENTATION...

 PRODUCTIVITY TOOLS OFFICE SUITE COMPUTER-BASED SUITES WEB-BASED SUITES TYPE OF PRODUCTIVITY TOOLS PRODUCTIVITY TOOLS OFFICE SUITE DATABASE COMPUTER-BASED SPREADSHEET WEB-BASED PRESENTATION WORD PROCESSING PRODUCTIVITY TOOLS Are computer applications that allows users to view, create, and modify office documents quickly and easily. Enable people to be more efficient, effective, and produce more satisfying results in their daily work and activities. PRODUCTIVITY TOOLS  OFFICE SUITE Refers to a collection of two or more productivity applications that are bundled and sold together. Is also known as application suite or productivity suite. Typically includes a word processor, spreadsheet creator, and presentation creator.  OFFICE SUITE Can be used singularly or collaboratively. Are created and designed to work with one another to let users share data in an easy and hassle-free manner. Office suites can be computer-based or web-based.  COMPUTER-BASED Requires the user to install the program itself on a computer using a DVD-ROM device, flash drives, or through online installation. Some computer-based suites are free while others require payment. 1 iWORK developed by Apple Inc. for computers and mobile devices running Mac OS X and IOS, and is free to anyone with an Apple ID. Page (word processor), Numbers (spreadsheet), and Keynote (presentation). 2 MICROSOFT OFFICE developed by Microsoft. most widely used office suite that it became the standard suite. Word, Excel, PowerPoint, OneNote, Access, Outlook, Publisher, SharePoint. MICROSOFT OFFICE 3 LIBREOFFICE developed by The Document Foundation. supports file formats of other well-known Office Suites, and is known as the most developed free and open- source Office Suite. Writer, Calc, Impress, Base, Draw, and Math. LIBREOFFICE 4 OPENOFFICE developed by Apache Software Foundation. free and open-source, uses a dual-licensing scheme for source code contributions. Writer, Calc, Impress, Base, Draw, and Math. OPENOFFICE 5 MICROSOFT 365 is a line of subscription services offered by Microsoft. 1TB OneDrive storage, 3D embedded images, speech- to-text and handwritten text to printed text conversion. Teams, OneDrive, Planner, Viva Goals, etc. MICROSOFT 365 MICROSOFT 365  WEB-BASED Allows user to create, modify, and store files online. Users can insert comments, share files, and invite other people to collaborate with them. Multiple users can also edit the same file simultaneously. These packages are offered in the form of web applications, any changes made in a document are saved automatically. 1 GOOGLE APPS developed by Google. widely known as Google Apps, are the rebranded version of G Suite. Offer limited features but make documents easy to share and accessible from any browser. Docs, Slides, Sheets, Hangout, Gmail, Calendar, etc. GOOGLE APPS 2 MICROSOFT ONLINE completely free, web-based version of Microsoft Office. the closest competitor of Google Apps, and it does not require any special plug-in and can be navigated in any popular browser. 3 WPS OFFICE developed by Kingsoft. can be installed on devices, but most features will be available online. Suitable for Android, Windows, macOS, iOS, and Linux operating systems. WPS Writer, WPS Spreadsheet, WPS Presentation, WPS AI, etc.  COMPUTER-BASED WEB-BASED faster collaboration non-server reliant minimal cost non-service reliant latest versions files are safer any operating system full features any browser access to databases file recovery VS 1 DATABASE SOFTWARE Also known as Database Management System (DBMS). Is made to verify, manipulate, specify, retrieve, and manage stored data. 1 DATABASE SOFTWARE Processes queries, data formats, and records and monitors entered data. Used for account handling, product information, financial records, and other business transactions. 2 SPREADSHEET SOFTWARE Are programs used to sort, compute, and organize numerical data. Is comprised of formulas, graphs, and charts for calculations and value presentations. 2 SPREADSHEET SOFTWARE Also contains a series of worksheets for easy data management. Spreadsheet software are commonly used in financial, academic, or any sector that requires calculated data. 3 PRESENTATIONSOFTWARE Is used for project presentations for both academic and business purposes. Is used to display interactive slideshows to express ideas, projections, and proposals whether for educational or business purposes. 3 PRESENTATIONSOFTWARE Presentation software are considered as an effective presentational tool for every type of audience. 4 WORD PROCESSING SOFTWARE Is used to view, edit, and create text documents. Allows users to type and format texts, insert and modify objects (images, clip arts, shapes), modify the document layout, and proofread documents. GRAPHICS/DESIGN NOTES COMMUNICATION STORAGE PRODUCTIVITY TOOLS Before, a person needs to be physically in the office to work with documents and other files. With the rise of productivity tools, people are now able to do their office tasks in a faster and more convenient way. Using these tools are more practical, efficient, and productive. PRODUCTIVITY TOOLS Here are the benefits of using productivity tools: Allows instant collaboration among people Allows quick access regardless of location Increases productivity and accuracy Lowers workload and possible errors Makes it easier to keep projects on track Offers different formats and sources Saves an ample amount of time Secures and protects information from being leaked  OFFICE SUITE WORD PROCESSING SPREADSHEET PRESENTATION WORD EXCEL POWERPOINT  WORD Is a word processing program that allows for the creation of both simple and complex documents. Mail Merge Label Generation Illustrations Group Image Placement  MAIL MERGE One of the most powerful and commonly used feature of Microsoft® Word. This feature allows you to create documents and combine or merge them with another document or data file. It is commonly used when sending out advertising materials to various recipients. MAIL MERGE  LABEL GENERATION Included in the mail merge feature on Microsoft ® Word. ILLUSTRATIONS GROUP Makes your documents richer, more impressive, and more informative. Are used to enhance or improve the effectiveness of the message you want to convey. 1 PICTURES Are electronic or digital pictures or photographs saved in any local storages. In Online Pictures, you can find and insert from a variety of online sources. 2 CLIPART/ ICONS Are line art drawings or images used as generic representations for ideas and objects. Microsoft Word has a library of clip arts that is built in or can be downloaded and used freely. 3 SHAPES Allow you to have some tools to use for composing and representing ideas or messages. Useful for layout designs especially for poster/ advertising. 4 SMART ART Are predefined sets of different shapes grouped together to form ideas that are A B organizational or structural in nature. D C If you want to graphically represent an organization, process, relationships, or A B flow for infographics documents, then D C you will find this easy and handy to use. E F 5 CHART Allows you to represent data characteristics and 6 4 2 CHART TITLE trends in your Word 0 SALES Category 1 Category 2 Category 3 Category 4 Documents. 4th Qtr Series 1 Series 2 Series 3 3rd Qtr 2nd 1st Qtr Useful when you are Qtr Chart Title preparing reports that 6 4 correlate and present data 2 0 in a graphical manner. Category 1 Category 2 Series 1 Category 3 Series 2 Category 4 Series 3 6 SCREENSHOT Microsoft Word provides snipping tool for your screenshots so you can select and display only the part that you exactly like to capture on your screen.  TEXT WRAPPING Allows you to move the image in position where you want it to appear in relation to the text on your document. 1 IN-LINE WITH TEXT is the default setting. it treats your image as a text font with the bottom side totally aligned with the text line. 2 SQUARE allows the image you inserted to be placed anywhere within the paragraph with the text going around the image in a square pattern like a frame. 3 TIGHT the text “hugs” or conforms to the general shape of the image. 4 THROUGH allows the text on your document to flow even tighter, taking the contours and shape of the image. 5 TOP & BOTTOM pushes the texts away vertically to the top and/or the bottom of the image so that the image occupies a whole text line on its own. 6 BEHIND TEXT allows your image to be dragged and placed anywhere on your document with all the text floating in front of it. effectively makes your image look like a background. 7 IN FRONT OF TEXT allows your image to be placed right on top of the text as if your image was dropped right on it.  EXCEL Is a spreadsheet editor that features calculation or computation capabilities, graphing tools, and pivot tables. Average Function CountIf Function AverageIf Function If Function 1 AVERAGE =AVERAGE(cells involved) 2 COUNTIF =COUNTIF(range, criteria) 3 AVERAGEIF =AVERAGEIF(range, criteria, average range)  POWERPOINT is a powerful slide show presentation program that uses slides to convey information rich in multimedia. Hyperlink Embedding objects Tips  HYPERLINK Creates a link that allows you to jump to a specific slide in your presentation or to a website or a local file saved in your device. Using hyperlinks in your presentation is an easy way to navigate slides during your presentation. EMBEDDING OBJECTS Creates a link to a file saved in your device. Shows the front page of the word or excel file embedded, and any changes made on the copied file won’t affect the real file.  TIPS Designing your presentation is the fun part of creating a report for it gives you a chance to be creative. Placing animations, transitions, and art. Sometimes, these things could actually distract your audience rather than help them. 1 MINIMIZE Keep slide counts to a minimum to maintain a clear message and to keep the audience attentive. Remember that the presentation is just a visual aid. Most of the information should still come from the reporter. 2 CLARIFY Avoid being fancy by using a font style that is easy to read. Make sure that it is also big enough to be read by the audience. Once you start making your presentation, consider how big the screen is during your report. 3 SIMPLIFY Use bullets or short sentences. Summarize information on the screen to make the audience focus on what the reporter is saying than on reading the slide. Limit the content to six lines and seven words per line (6 x 7 rule). 4 VISUALIZE Use graphics to help in your presentation; however, too many graphics might distract the audience. In addition, instead of using tables for data presentation, use charts and graphs. 5 CONSISTENT Make your design uniform. Avoid having different font styles and background per slide. 6 CONTRAST Use a light font on a dark background or vice versa. This will make the text easier to read. In most instances, it is easier to read on screen if the background is dark. This is due to the brightness of the screen.