OPT-Module1.docx

 1. 2. 3. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. - - - - - Microsoft has taken responsibility for keeping your data and information secure. - - - - - 1. **Microsoft Word** 2. **Microsoft Excel** 3. *...

 1. 2. 3. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. - - - - - Microsoft has taken responsibility for keeping your data and information secure. - - - - - 1. **Microsoft Word** 2. **Microsoft Excel** 3. **Microsoft PowerPoint** 4. **Microsoft OneNote** 5. **Microsoft Outlook** 6. **Microsoft Publisher** 7. **Microsoft Access** A. Encircle the letter of correct answer. a. Bill Gates c. Charles Babbage b. Gottfried Leibniz d. Steve Job a. Microsoft Excel c. Microsoft Outlook b. Microsoft Word d. Microsoft Access 3. It is a desktop publishing program for Windows operating systems. a. Microsoft Publisher c. Microsoft Access b. Microsoft Word d. Microsoft Outlook a. Microsoft OneNote c. Microsoft Access b. Microsoft Word d. Microsoft Outlook 5. It is an email program for Windows and Mac operating systems. a. Microsoft OneNote c. Microsoft Access b. Microsoft Word d. Microsoft Outlook 6. It is an instant messaging client and unified communication application. a. Microsoft OneNote c. Microsoft Access b. Skype for Business d. Microsoft Outlook 7. It is a free note -taking form for Windows and Mac operating systems. c. Microsoft OneNote c. Microsoft Publisher d. Skype for Business d. Microsoft Outlook 8. It is a presentation program for Windows and Mac operating systems. e. Microsoft OneNote c. Microsoft Access f. Microsoft Word d Microsoft PowerPoint 9. It is a spreadsheet program featuring calculation, graphic tools, pivot tables, and macro programming language support for Windows and Mac operating systems. g. Microsoft Access c. Microsoft Publisher b. Microsoft Excel d. Microsoft Word 10. The first version of Office contained? a. Microsoft Excel, Microsoft Word, Microsoft Publisher b. Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. c. Microsoft OneNote, Microsoft Word, Microsoft Access d.. Microsoft Word, Microsoft Outlook, Microsoft PowerPoint B. Write your answer to the space provides.  1. 2. 3. This is what you are typing/what will print out. Shows open programs. Allows you to increase/decrease the amount of the document you see on the screen. Allows you to view/hide the rulers. - - - - - - - - - - The binary file format for Word 97-Word 2003. Template for Word 97-Word 2003 files. When users save a document as a.txt file, the document loses all formatting. **Open Document Text** Microsoft Office Suite (2021) Computer and Microsoft Applications Learning (December 9, 2017) [[https://computer2101.wordpress.com/2017/12/09/the-parts-functions-of-microsoft-word/]](https://computer2101.wordpress.com/2017/12/09/the-parts-functions-of-microsoft-word/) B. Enumeration (10pts) a. b. b\. Give at least (10) keyboard shorcut.  1. 2. 3. - - - - - - **Normal view** - This shows the normal view of the presentation with the slide sheet to the right and slide thumbnails to the left. This view allows you to select the working slides and rearrange them. - **Slide Sorter view** - This shows all slides in a tabular form. This view allows you to arrange slides only. - **Read View** - This window will allow you to read the slide carefully. However, you will not be able to make any edits. - **Slide Show** - It shows / runs all the slides along with the animations, sounds you have given to the presentation. - PowerPoint in education - PowerPoint in business - PowerPoint for job seekers - Use PowerPoint to Make Tutorials - Use PowerPoint Presentations as a Digital Portfolio - Prepare nice Animations using PowerPoint - Use PowerPoint as a Photo Slide Show - You can use PowerPoint to teach student - Help to create reports and assignments - Videos and multimedia presentations - Quick and easy: the main features are easy to master and can show you to be well, even if you\'re not. - Simple bullet points: this can reduce complex messages to simple bullet points. Bullet points are a good basis for a presentation and remind the speaker of key points and the synthesis of the message. - Easily create colourful, attractive designs using standard templates and themes; easy to modify compared to other visual aids, such as charts, and easy to drag and drop slides to rearrange the presentation. - Easy to modify: compared to other aids such as charts, posters, or objects, it is easy to modify. - Easily rearrange the presentation: with a simple drag and drop or using key strokes, you can move the slides to rearrange the presentation. - Audience Size: PowerPoint slides are generally easier to see by a large audience when expected than other visual aids. - Easy to display: you can easily advance the slides in the presentation sequentially with a simple key stroke while maintaining eye contact with the audience. - No need for Hand outs: they look nice and are easy to read if you have a projector and screen big enough for the whole room. - The power of design is meaningless: it gives the illusion of content and coherence, when in fact there really isn't much element or connection between the different points on the slides. - Excessive PowerPoint: some speakers create presentations so they have slides to show rather than drafting, organizing, and focusing on the message. - Replacing planning and preparation: PowerPoint is a convenient prop for poor speakers, as it can reduce complex messages to simple bullet points and elevate style rather than substance. - Excessive topic elaboration: the linear nature of PowerPoint forces the presenter to reduce complex topics to a set of bullet items that are too weak to support decision making or demonstrate the complexity of an issue. - Feature abundance: while key features are easy to use and apply, a speaker can take and try to use all the features at once instead of simply supporting one message. Too many flying letters, animations, and sound effects without seeing a lot of original thinking or analysis can be a real issue. In many cases, the medium drives the message away. - Basic equipment requirements: you will need to have a computer and projection equipment to show the slides to the audience. - Focus on the medium, not the message: Too many people forget that they are making a presentation first and that PowerPoint is just a tool. 1. This is a group of commonly used commands that makes it easy to implement certain procedures. It usually contains Save, Undo, Redo, Run Slide commands, etc. a. Quick Access Toolbar c. File Tab b. Title Bar d. Slide Area 2. It displays the\_\_\_\_\_\_\_\_\_, the name of the opened file along with the program name, sign in, ribbon display, maximize, minimize, and close buttons. c. Quick Access Toolbar c. File Tab d. Title Bar d. Slide Area 3. This panel allows you to add an opinion to the slide that has been activated for the people who manage to modify the document. e. Quick Access Toolbar c. Status Bar f. Note Bar d. Slide Area 4. This shows all slides in a tabular form and this view allows you to arrange slides only. g. Quick Access Toolbar c. Slide Sorter view h. Normal view d. Slide Show 5. It allows to minimize, maximize window size, and close the current document. i. Ribbon c. File Tab j. Zoom Panel d. Control Buttons 6. It is a powerful, easy -to -use graphics presentation software program that allows you to create a professional looking electronic slide shows. k. Power Point c. Ruler l. Zoom Panel d. Control Buttons 7. It shows runs of all the slides along with the animations, sounds you have given to the presentation. m. Normal view c. Ruler n. Read View d. Slide Show 8. This panel allows you to manipulate the percentage (%) of page views currently being worked on. o. Power Point c. Ruler p. Zoom Panel d. Control Buttons 9. It allows updating, editing and adding, deleting content, inserting images, shapes to the selected sheet. q. Quick Access Toolbar c. File Tab r. Title Bar d. Slide Area  1. 2. 3. 4. 5. - - - - - - - - - - - - It is the intersection of the rows of columns. It displayed the name of the active cell. It is labeled by numbers while column is labeled by a letter. It is used to scroll the content horizontally and vertically. A. Give at least five parts of the excel B. Give at least five advantages of excel  1. To elements of excels. 2. To identify the basic shortcut of spreadsheets. 3. To learn how to use sheets tab and workspace. 4. To know how to navigate excel. - Toolbars - Ribbons - Tabs - Name and Formula boxes - Rows and Columns - Pages - Layout - Zoom - Add worksheets to a workbook using the context menu or the **New Sheet**/**Add** - Delete or [hide individual worksheets](https://www.lifewire.com/hide-and-unhide-columns-rows-and-cells-in-excel-4178638) in a workbook. - [Rename individual worksheets](https://www.lifewire.com/how-to-rename-a-worksheet-3123471) and [change worksheet tab colors](https://www.lifewire.com/change-worksheet-tab-color-in-excel-4581361) to make it easier to identify single sheets in a workbook using the context menu. - Select the sheet tab at the bottom of the screen to change to another worksheet. - **Ctrl**+**PgUp** (page up): Move to the right - **Ctrl**+**PgDn** (page down): Move to the left - **Ctrl**+**Shift**+**PgUp**: Move to the right - **Ctrl**+**Shift**+**PgDn**: Move to the left - Home: We can see clipboard, font, alignment, number, styles, cells and editing. - Insert: When you click the insert you can view the object or things that you can insert to your worksheets like tables, Illustrations, apps, charts, spark lines, filters, links, text and symbols. - Page Layout: This part will provide you the output of your files like themes, page setup, scale to fit, sheet options, and arrange. - Formulas: In this part of excel it display the content of formula like insert function, function library, defined names, formula auditing, and calculations - Data: If you have a problem about your data, you can click data to operate you data in the worksheets. It can provide you like get external data, connections, sort and filter, data tools and outline. - Review: In this part you can view the proofing, language, comments, and changes. - View: and lastly is the view, it shows workbook views, show, zoom, window and Marcos. +-----------------------------------+-----------------------------------+ | +------------------------------+ | | | | **Print** - Displays the | | | | | \"Print\" dialog box. | | | | | | | | | | **Quick Print** - Send the | | | | | active worksheet straight to | | | | | the printer using the most | | | | | recently used settings? | | | | | | | | | | **Print Preview** - Displays | | | | | the Print Preview view | | | | +------------------------------+ | | +-----------------------------------+-----------------------------------+ 1. 2. 3. 4. 5. 1. 2. 3. 1. 2. 3. 4. 5. 1. 2. 3. 1. 2. 3. 4. 5. 6. 1. 2. 3. A. B. A. Give all the shortcut menu method (6pts) B. Give all the method to create workspace (5pts) C. Give all the elements of excels (8pts) D. Give the mouse method (1pt)  1. To know the right used of tables and how it works in excel. 2. To identify how filtering used in different data that stored or input in the sheet. 3. To know how to add formulas in filtering. 4. To learn how to used pivot tables. **Lectures and Annotations:** 1. 2. - - - - - - 1. **Preparation of a good spreadsheet** 2. **Create worksheets with the future in mind** 3. **Think about the order of worksheets** 4. **Choose clarity over looks** 5. **Keep your timeline consistent** 6. **Organize the information flow** 7. **Label columns and rows** 8. **Keep formulas readable** 9. **Avoid repetitive formulas** 10. **Avoid fixed numbers in formulas** 11. **Do not merge cells** 12. **Avoid hiding data** 13. **Build in data verification** 14. **Save styling for the end** 15. **Keep styling consistent** 16. **Keep conditional formatting simple** 17. **Be clear about units and number formats** 18. **Clarify your sources** 19. **Avoid the use of macros** Always use Excel's solutions before resorting to VBA macros. VBA macros make the spreadsheet less transparent, as they abstract away logic. For some tasks, VBA macros even perform worse than Excel's default solutions. 20. **Use simple ranges** Andrew Childress (August 10,2017) How to Make and used tables, Create a simple graphical presentation using spreadsheets. The data is the following:  1. 2. 3. 4. - - - - - - Different Charts in Excel ========================= +-----------------------------------+-----------------------------------+ | - Column Chart | - XY (Scatter) Chart | | | | | - Line Chart | - Bubble Chart | | | | | - Pie Chart | - Stock Chart | | | | | - Doughnut Chart | - Surface Chart | | | | | - Bar Chart | - Radar Chart | | | | | - Area Chart | - Combo Chart | +-----------------------------------+-----------------------------------+ - 3-D Clustered Column. - Clustered Column. - Stacked Column. 3-D Stacked Column. - 100% Stacked Column. 3-D 100% Stacked Column. - 3-D Colum - Category data is disseminated evenly along the horizontal axis. - Value data is disseminated evenly along the vertical axis. +-----------------------------------+-----------------------------------+ | - Line | - Stacked Line with Markers | | | | | - Stacked Line | - 100% Stacked Line with | | | Markers | | - 100% Stacked Line | | | | - 3-D Line | | - Line with Markers | | +-----------------------------------+-----------------------------------+ - - - Clustered Bar - Stacked Bar - 100% Stacked Bar - 3-D Clustered Bar - 3-D Stacked Bar - 3-D 100% Stacked Bar +-----------------------------------------------------------------------+ | **Area Chart** | | | |  | | | | In Area Charts, it can be used to plot the change over time and draw | | attention to the total value across a trend. By showing the sum of | | the plotted values, an area chart also shows the relationship of | | parts to a complete data. To create an Area Chart, arrange the data | | in columns or rows on the worksheet. | | | | An Area Chart has the following sub-types that you can see in your | | excel. | +-----------------------------------------------------------------------+ - Area - Stacked Area - 100% Stacked Area - 3-D Area - 3-D Stacked Area - 3-D 100% Stacked Area - Horizontal (x) Value Axis - Vertical (y) Value Axis - You want to change the scale of the horizontal axis. - You want to make that axis a logarithmic scale. - Values for horizontal axis are not evenly spaced. - There are many data points on the horizontal axis. - You want to adjust the independent axis scales of a scatter chart to reveal more information about data that includes pairs or grouped sets of values. - You want to show similarities between large sets of data instead of differences between data points. - You want to compare many data points regardless of the time. - Scatter - Scatter with Smooth Lines and Markers - Scatter with Smooth Lines - Scatter with Straight Lines and Markers - Scatter with Straight Lines - Bubble - Bubble with 3-D effect - High-Low-Close - Open-High-Low-Close - Volume-High-Low-Close - Volume-Open-High-Low-Close +-----------------------------------+-----------------------------------+ | - 3-D Surface | - Contour | | | | | - Wireframe 3-D Surface | - Wireframe Contour | +-----------------------------------+-----------------------------------+ - Radar - Radar with Markers - Filled Radar - Clustered Column -- Line - Clustered Column -- Line on Secondary Axis - Stacked Area -- Clustered Column - Custom Combination 1. Select the chart. 2. On the Design tab, in the Location group, click Move Chart. 3. Click the New sheet and enter or input a name.  **References:** ArcGIS Pro, What is a chart, https://pro.arcgis.com/en/pro-