Office Application Tools PDF

Chapter 3 1.OFFICE APPLICATION TOOLS The most commonly used...

Chapter 3 1.OFFICE APPLICATION TOOLS The most commonly used application tools in a business Emerging Technologies for organization. Application software that Business Processes assist users in regular office jobs like creating, updating and maintaining documents, handling large amounts of data, creating presentations, scheduling, etc. (tutorials.com) https://gadgetsrealm.com/wp-content/uploads/2022/02/Best-Free-Alternatives-to-Microsoft-Office-2022- Edition.jpg Office Application Tools Microsoft Word Microsoft Office A word processing program that is designed for both Windows A powerful office applications and Mac operating system. that support various business process. https://blog.discount-licensing.com/hubfs/ms-office-perpetual.jpg https://www.versionmuseum.com/images/applications/microsoft-word/microsoft-word%5E2015%5Ems-word-logo-new.png Parts of Microsoft Word 2013 ACCESS ACCOUNT – from here, you can access your Microsoft Account information, view your profile and switch account. Parts of Microsoft Word 2013 Parts of Microsoft Word 2013 DOCUMENT VIEWS – there are three ways to view a PAGE NUMBER INDICATOR - helps you keep track of document. Simply click the desired view: the number of pages your document contains. o READ MODE – displays your document in full QUICK ACCESS TOOLBAR – lets you access common screen mode. commands no matter which tab is selected. By o PRINT LAYOUT – selected by default. It shows the default, it includes the SAVE, UNDO, and REDO document as it would appear if it were printed. commands. You can add other commands o WEBPAGE LAYOUT – shows how your document depending on your preference. would look as a webpage. Parts of Microsoft Word 2013 Parts of Microsoft Word 2013 RIBBON – contains all the commands you will need to STATUS BAR – it appears at the bottom of the window perform common tasks in WORD. It has multiple tabs, and provides information as the current page and the each with several groups of commands. number of words in your documents. The check mark RULER – is located at the top and to the left of your next to an item means it is selected. document. TEXT AREA – a large area below the ruler. You can SCROLL BAR - a horizontal and vertical bar with arrows type your document in the text area. used to scroll the document using the mouse. TITLE BAR – it displays the title of your document on which you are currently working. Parts of Microsoft Word 2013 Microsoft Excel TITLE BAR – it displays the title of your document on It is a spreadsheet program that includes features such as which you are currently working. calculation, macro programming, and graphic tools. Most of the WORD COUNT – displays the number of words in your functions found in Microsoft Word are also available in Microsoft Excel. document ZOOM CONTROL – click, hold, and drag the slider to use the zoom control. The number to the right of the slider bar reflects the zoom percentage. https://images.ctfassets.net/lzny33ho1g45/excel-online-guide-p- img/b800bd34c077003197f95b1bac3b2a73/file.png?w=1520&fm=jpg&q=30&fit=thumb&h=760  Parts of Microsoft Excel 2013 Quick Access Toolbar – lets you access to common commands no matter which tab is selected. By default, it includes Save, Undo and Redo commands. You can add other commands depending on your preference. The Ribbon – contains all the commands you will need to perform common task in Excel. It has multiple tabs, each with several groups of commands. Parts of Microsoft Excel 2013 Parts of Microsoft Excel 2013 Microsoft Account – from here, you can access your Name Box – displays the location or name of a Microsoft account information, view your profile, and selected cell. switch accounts. Formula bar – you can enter or edit data, or a Command Group – each group contains a series of formula, or a function that will appear in a specific different commands. Simply click any command to cell. apply it. Some groups also have an arrow in the Cell – each rectangle in a workbook is called a cell. A bottom right corner, which you can click to see even cell is the intersection of row and column. more commands. Parts of Microsoft Excel 2013 Parts of Microsoft Excel 2013 Worksheet View Options – there are three ways to Row – is a group of cells that runs from the left of the view a worksheet. Simply click to select the desired page to the right. In Excel, rows are identified by view: numbers. o Normal view is selected by default, and shows you Worksheets – Excel files are called workbooks. Each an unlimited number of cells and columns. workbook holds one or more worksheets (also known o Page Layout view divides your spreadsheet into as “spreadsheets”). One worksheet will appear by pages. default when you open an Excel workbook. It’s easy o Page Break view lets you see an overview of your to rename, add, and delete worksheets. worksheet, which is especially helpful when adding page breaks. Parts of Microsoft Excel 2013 Parts of Microsoft Excel 2013 Zoom control – click and drag the slider to use the Column – is a group of cells that runs from the top of zoom control. The number to the right of the slier the page to the bottom. In Excel, column is identified reflects the zoom percentage. by letters. Vertical and Horizontal scroll bars – your spreadsheet may frequently have more data than you see on the screen at once. Click, hold and drag the vertical or horizontal scroll bar depending on what part of the page you want to see. QUICK ACCESS TOOLBAR Microsoft PowerPoint RIBBON MICROSOFT ACCOUNT It is a presentation program available in both Windows and MAC OS. This program is widely used by employees, staff, and top management in business organizations for business RULER presentations. SLIDE PANE SLIDE NAVIGATION PANE VERTICAL AND HORIZONTAL SCROLL BAR NOTES COMMENTS SLIDE VIEW OPTIONS https://computersolve.com/wp-content/uploads/2022/05/Screenshot_5-1.png ZOOM CONTROL Microsoft Note It is a free – form information gathering program that allows a user to collaborate with other OneNote users. The functions of this program include creating noted in both typewritten and handwritten forms, clipping and adding audio commentaries. https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR_3ZCOCJGA0ngirJD6Qx4ypH2kvNmDZNROZQ&usqp=CAU Microsoft Outlook This computer program included in a Microsoft Office suite package. It allows users to share information in the form of folders, forms and so on. https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQem5gwCUPJCx2I7F9zC- z6VWhXxAV8P1AxtQK_78qZvU4K8oKHJKjj4F2THQCnc9bZt8w&usqp=CAU Microsoft Publisher This computer program is specifically designed for entry – level desktop publishing. It focuses on page layout rather than text composition. It widely used for designing banners, invitations, advertisements, award certificates, brochures, business cards, business forms, calendars, catalogs, emails, envelopes, flyers. Letterheads, newsletter and resume. https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQ7ip7VqVw5pDAnxftVSJjer5awVHAqh_-D8g&usqp=CAU Microsoft Access This software is used to create a database whose main purpose is to organize, store, maintain, and manage data and information for reporting and analysis. It helps store, analyze, and manage large amounts of information effectively. Many business organizations use Access because it is free of charge and can effectively manage information within the organization. The following are the benefits of Microsoft Access and other databases. Reduce redundancy and inconsistencies. Increase productivity Secure databases Make better decisions. https://encrypted- tbn0.gstatic.com/images?q=tbn:ANd9GcQbqHAj SFxHMfasX6DIS2GFLTQs2U1Zt4Jd6w&usqp=CAU Office Mobile 2.COMPUTING TECHNOLOGIES Mobile technologies are popular in today’s generation. A few Computing is defined as the process of utilizing computer years ago, Microsoft office can only be accessed using personal technology to complete a certain task (Techopedia, n.d) computers. With the advent of technologies, it can now be Computer technologies involves computer hardware, software, accessed using mobile phones through a software called an data and procedures that would perform a certain tasks or application. Various operating systems control the overall functions. operation of the mobile app such as Android and iOS. Computer technology is associated with activities of designing, constructing, and programming computers. (dictionary.net). https://m-cdn.phonearena.com/images/article/116474-wide-two_940/Microsoft-to-end-Office-mobile-apps-support-for-older-Android-devices 2.1 Teleconferencing 2.2 Computerized Teleconferencing It is used by companies to conduct meetings with multiple people Known as computer teleconferencing. from different geographical locations. The system can be used by people from various geographical areas. Benefits of Teleconferencing Each participant may access the computer terminal that is connected to Reduce cost of travel and accommodation expenses a specific conference network. Save time Advantage of computerized teleconferencing: Conserve energy A user can save on time and resources as he/she can participate in multiple Avoid travel risks conferences at a time without travelling away for face to face meetings. A user could read, write, or respond to messages at his/her convenience If a problem occurs, a user can get comments and suggestions from bigger groups of people and consolidate their inputs for decision making. 2.3 Video Conferencing 3. CLOUD COMPUTING Conferencing that requires people participate from various The cloud refers to the locations and time zones transmitting audio and video data to Internet. achieve their purpose and objectives is called videoconferencing. It refers to a user's own methods or ways of storing or accessing data using an Internet connection. In business perspective, cloud computing allows a business organization's data and information to be stored and accessed virtually. https://miro.medium.com/max/640/1*ngkHgQq7ij1NBNr62er3zA.png Cloud Computing and the Internet Service Model of Cloud Computing With the help of the Internet, cloud computing was introduced. Software as a Service (SaaS) Platform as a Service (PaaS) In contrast to standalone computers, cloud computing allows It refers to the ability to use It refers to the ability to deploy applications running on the cloud applications to the cloud users to store and access data, programs (applications), infrastructure made available by a infrastructure. This deployment could databases, emails, and file services in the cloud. service provider. be customer-related and involve These applications can be acquired applications that are Cloud computing refers to the use of technology that uses the accessed from different client designed through programming devices through a client interface language or software tools that are Internet and remote servers to maintain data and applications. supported by the provider. Types of SaaS Cloud computing can also refer to the shared computing Business utility SaaS Types of PaaS Social Application Platform resources that are accessed virtually as a service through an Social Networking SaaS Business Application Platform application program interface (API) Computing Platform Web Application Platform Service Model of Cloud Computing Service Model of Cloud Computing Types of PaaS Infrastructure as a Service Social Application Platform - This refers to a platform that provides third (IaaS) parties with full access and gives the opportunity to access and write functionalities that are available for all users. This refers to the ability to Business Application Platform - This refers to higher technical provide processing, networks, complexities that lead to transaction-based business applications. This storage, and other primary refers to higher technical complexities that lead to transaction-based resources related to business applications computing. Computing Platform - This refers to a service that provides processors, storage, and bandwidth Web Application Platform - This refers to an application that provides API and other functionalities to developers to build web applications https://www.finoit.com/wp-content/uploads/2013/06/cloud-computing-outlook-iaas-paas-and-saas-1.jpg that leverage their mapping or calendar Classifications of the Cloud Deployment Model 4. MOBILE COMPUTING Private Cloud Public Cloud Mobile computing is a term Benefits of Mobile Computing in This type of deployment model This type of deployment model refers used to describe various devices Business refers to the cloud infrastructure t the cloud infrastructure that is made that allow people to access, that is used and operated by only available to a large industry group or retrieve, delete, and view data Increase in productivity one organization. to the general public. or information wherever they Improvement in flexibility are in the world. Community Cloud Hybrid Cloud Better cost control This type of deployment model This type of deployment model refers Mobile devices such as smart Better communication refers to the cloud infrastructure to the cloud infrastructure that is phones, tablets, or wearable that is shared by many business combined with two or more clouds computers like the Apple watch organizations and supports certain (private, community, or public) that can be connected to various https://blogger.googleusercontent.com/img/a /AVvXsEiSviXo4gZYrs- communities that share the same are bound by standardized or types of networks including 0fxMC4zna6aTbfdqi4YyItYnbgnIgD1fX_lbZ7Kjtg Tl- 3Sz6f7muEPo4xbuOFC8jwYMcqkTt3oZIiB2P9u sentiments and concerns. proprietary technology. LAN, wireless local area 0lb737txOtkZkCGtXCc9v_jt7uSuI7sD7mTRywna OGZoUVDQrvU3lQ52YzAn- network, or the internet. hyS3gaRiuuTxLix8DBsJx3PSe0q_h=w1200- h630-p-k-no-nu Mobile Computing Security Mobile Computing Security Mobile computing has also Risk of Mobile Computing Mobile computing has also designed a mechanism for its security. designed a mechanism for its Connectivity Issues Increased mobile computing security means businesses can provide employees security. Security Issues and Concerns with mobile devices or technology and be confident that business network, Increased mobile computing data, information, and even devices are equally protected. security means businesses It allows users to transfer data, videos, photos, and audio over a specific can provide employees with network through a mobile device mobile devices or technology It allows users to transmit data from one remote location to another and be confident that business network, data, information, and even devices are equally protected. 5. GREEN COMPUTING 5. GREEN COMPUTING Green computing is popularly Green IT practices include: It is considered the environmentally responsible method used by known as Green IT. business organizations to reduce, reuse, recycle, as well as dispose An approach that can be Environmentally sustainable of technological resources. applied by business production practices It is the study of designing, engineering, manufacturing, using, and organizations to their Energy-efficient computing disposing of competing devices in a way that reduces environmental computer and communication devices or computers impact (Techopedia, 2017). systems is to reduce, reuse, Improving disposal procedures and recycle to save the Improving recycling procedures environment Green Computing Approaches 5. GREEN COMPUTING that Can Benefit Businesses US Environmental Protection Stages of Green Computing Virtualization Agency (EPA) Design Use of Multifunction Devices Introduced the Energy Star Manufacture Program. Use Use of Cloud Applications This program aims to reduce Disposal Disposal and Replacement of the cost spent by business Old Devices or Equipment organizations. Introduction to Telecommuting https://t4.ftcdn.net/jpg/03/06/67/33/360_F_306673303_kJSudsmjM3LtumbT4WQq20CaoB8C5gyf.jpg 6. GRID COMPUTING 6. GRID COMPUTING It offers a high degree of resource sharing and proper collaboration Grid computing is the practice of leveraging multiple computers, on a scale that would exceed even the power of the World Wide often geographically distributed but connected by networks, to work Web (WWW) and the currently available distributed computing. together to accomplish joint tasks. It is typically run on a “data grid,” It is important that business developers, designers, and a set of computers that directly interact with each other to administrators fully understand the concepts of grid computing coordinate jobs. and how to make it work successfully. The main objective is to make all computing resources available all day every day 6. GRID COMPUTING Benefits of Grid Computing It allows detached departments to be part of a virtual organization that allows the sharing of data and resources. It improves business productivity and collaboration within virtual organizations. It supports the creation of robust, flexible, and resilient operational business infrastructures. It provides immediate access to enormous computing and data resources. It leverages existing capital expenditures (CAPER} and operational expenditures (OPEX), which would help ensure the optimal utilization and costs of computing resources and capabilities. It keeps businesses from incurring expensive operating costs or excess costs. Grid Computing in Major Business Areas 7. INTERNET OF THINGS (loT) Organizations have identified the major business areas where grid loT is a network of physical devices that are connecter embedded, computing could be implemented, such as: or equipped with sensors, electronics and other transfer Higher education mechanisms that enable them to connect through wired or Financial services wireless networks. Life sciences The loT brings huge changes in methods, procedures operations of Government services business. It improves the way businesses gather, store, exchange, Engineering services and retrieve data and information. Collaborative games These technologies are purposely designed to change lives, business, and reality  Real – World Example of the 7. INTERNET OF THINGS (loT) IoT of the Future Common IoT Application IoT in Business Smart home devices Equipment maintenance Wearable Technology prognostics Iot healthcare devices Shelf and warehouse Connected Cars Warehouse automation and Smart transportation Smart Store Data analytics The smart store components: 8. ARTIFICIAL INTELLIGENCE Real-time shopping — A smart store allows customers to view Al is the ability of a certain The following are some product details and purchase goods at their convenience using machine to use algorithms to applications of Al that are their mobile phones. interpret, learn, and use data reshaping the world of business: Customer feedback — With a smart store, it is easier to collect to make decisions. It also Robotics feedback from customers about their shopping experience right refers to a machine's Speech Recognition after their purchase through their mobile devices. capability to analyze Cybersecurity protection against enormous amounts of threats. information at a time. 8. ARTIFICIAL INTELLIGENCE - 8. ARTIFICIAL INTELLIGENCE – Robotics Speech Recognition 9. MACHINE LEARNING 9. MACHINE LEARNING One of the main applications of Al is machine learning. In computer science, it is the field that focuses on program development that allows computers to learn automatically without human assistance and intervention. In contrast to traditional programming, which requires a manually created program that uses input data run on a computer to produce an output, machine learning is a fully automated process. It employs algorithms to detect patterns on the input to create a program. Computers that are equipped with the capability to make models for businesses according to their organizations' input data and goal. BI Applications in an 10.BUSINESS INTELLIGENCE Organization or Enterprise According to The Data Warehouse Institute (2002), business intelligence (BI) Analytics. refers to the processes, technologies, and tools required to convert data into information, information into knowledge, and knowledge into plans that Enterprise reporting. derive profitable business actions. Measurement. It encompasses data warehousing, business analytics, and knowledge Collaboration platform. management. It allows business organizations to use and manage data strategically in Knowledge management. response to challenges and issues that would drive profitable business actions BI is the union of business, IT and business management. Thank You! Prepared by: Jane Ann P. Austria