EMPOWERMENT TECHNOLOGY Q1 Module-1-Week-3-Mail-Merge, High school final essays of Technology

Download EMPOWERMENT TECHNOLOGY Q1 Module-1-Week-3-Mail-Merge and more High school final essays Technology in PDF only on Docsity! Republic of the Philippines DEPARTMENT OF EDUCATION Region I Schools Division Office I Pangasinan Pangasinan National High School Lingayen, Pangasinan EMPOWERMENT TECHNOLOGY Applied Productivity Tools Quarter 1 – Week 4 – Module 1 Teacher Eidene Joy M. Lopez Overview Dear Learners: Designing a presentation is the fun part of creating a presentable report. It gives you the chance to be creative with less talk but comprehensible report. How would this be possible? It is through the Advance Technique in using MS Power Point and MS Excel. Discover how you can get in touch with your audience, who knows time challenge you to be a lecturer, guest speaker or reporter in your class. 2 A. MS PowerPoint PowerPoint is a highly innovative and versatile program that can ensure a successful communication whether you’re presenting in front of potential investors, a lecture theatre or simply in front of your colleagues. What I Need to Know Learning Objectives After going through this module you are expected to:  Present a short story through power point presentation  Derive an ICT content to effectively present data or information  Use several conditional functions available in Microsoft Excel What I Know (Pre-Test) Direction: Write True if the sentence is correct; otherwise, write False 1. Use as many slides as you can so that the audience can clearly understand your message. 2. Power point presentation is a form of visual aid? 3. Most of the content of your report is through your Power Point Presentation and not from the speaker. 4. To insert a hyperlink, go to the Home Tab then click the Hyperlink option. 5. To embed an object go to the insert tab and under the Text Group, Click object. 6. There are two options when inserting an object: create new from file and create new from existing file. 7. Action buttons are found in the Insert > SmartArt. 8. Use dark fonts on dark backgrounds to gain proper contrast. 9. Use bullets to simplify your message 10. Insert Artwork in each slide. It may not be related but at least it would draw the audience attention. What’s In  PowerPoint is a computer program that allows you to create and show slides to support a presentation.  Slide animation and transition make your presentation more dynamic and interactive  PowerPoint apps give you access to the familiar tool you already know. Quickly create and edit, view, present, or share presentation. What’s New Animation and Timing in MS PowerPoint Microsoft PowerPoint provides several animation styles in different categories, namely, Entrance, Emphasis, Exit and Motion Paths. Animations make your presentation more dynamic. 5 What I Have Learned To create an effective presentation: Minimize the content. Maintain clear message, keep things simple through the use of bullets or short sentences. Use visuals like charts and graphs. Be consistent by having uniform font, styles and be mindful of the contrast. What I Can Do (Application) Choose one of the topics listed below and create a PowerPoint presentation about it. You must follow the guidelines in creating an effective presentation. You are also required to add a Table of contents slide which contains hyperlinks to different parts of your presentation. Your presentation must have at least 10 slides. It may contain photos related to the topic you choose. You may send your soft copies through Google Classroom. Topics:  The history of the internet  Anti-Cybercrime law in thePhilippines  COVID- 19  “The Big One” Assessment A. Direction: Answer the following questions briefly? 1. Why should you minimize the number of slide in your presentation? 2. Explain the meaning of contrast. Describe its importance in the Power Point Presentation. B. Direction: If the statement is correct Write True if not Write False ______1. It is best to use random animation in creating a slide show. ______2. Slide animation and transition make your presentation more dynamic and interactive. ______3. You can add animation to any element in the slide show. ______4. Slide transition control how the presentation moves from slide to slide. ______5. Using Formulas to calculate values is the common function of Power Point B. Advance Techniques in Using MS Excel What I know (Pre-Test) Direction: Multiple Choice: Write the letter of the correct answer on the space before each number. 1. A program designed to create spreadsheets which can later be used to analyze statistical data a. Microsoft Excel b. Microsoft Word c. Microsoft Publisher d. Microsoft OneNote 2. A number format that puts a dollar symbol before each value by default 6 a. Percent b. Accounting c. Comma d. Date/time 3. A function that adds a range of cells a. ADD b. PLUS c. SUM d. TOTAL 4. This is the tab in the Format Cells dialog box where you can change the orientation of a text. a. Alignment b. Orientation c. File d. View 5. A function that gets the average of a range of cells a. AVERAGE b. SUM c. MEAN d. MEDIAN 6. Which among the following is not part of the syntax for AVERAGEIF a. Average range b. Range c. Logical test d. Criteria 7. A function used to count the number of cells that contains something in them if the criteria are met a. COUNT b. COUNTNOW c. COUNTING d. COUNTIF 8. A function used to add a certain range of cells if a condition is met a. SUMIF b. ADDIF c. TOTALIF d. PLUSIF 9. The shortcut key for the Format Cells dialog box a. Ctrl + F b. Shift + F c. Ctrl + 1 d. Alt + 1 10. A syntax in the AVERAGEIF function that includes the value or label that determines if the cell is part of the range to be averaged a. Range b. Criteria c. Average Range d. Logical Test 7 What’s In A Spreadsheet Software allows users to organize data in rows and columns and perform calculations on the data. These rows and columns collectively are called worksheet. Examples of Spreadsheet Software are LibreOffice Calc, OpenOffice.org Calc, Google Sheets, Apple iWork Numbers, Kingsoft Office Spreadsheets, StarOffice Calc, Microsoft Excel. Microsoft Excel is a spreadsheet application by Microsoft for Windows, MacOS, Android and iOS. It features graphing tools, pivot tables, and micro programming. Key Terms in MS Excel: Accounting Number Format – a number format that is used for accounting Orientation – the angle at which a text is displayed COUNTIF – a function used to count the cells with a specified content within a range SUMIF – a function used to compute for the summation of a range if a certain condition is met AVERAGEIF – a function used to compute for the average of a range if a certain condition is met Range- the range of cells where you want to look for the criteria Criteria – a value or label that determines if cells is part of the range to be averaged Average Range – the actual range of cells that will be averaged, if omitted, the range will be used instead Row – horizontal line of entries in a table Column – vertical line of entries in a table Cell – the place where info. is held in a spreadsheet Active Cell – the selected cell Column Heading – the box at the top of each column containing a letter Row Heading – the row number Cell Reference – the cell address of the cell usually combines letter and number (ex. A1, B4, C2) • Merge – combining or joining two or more cells Formula – is an expression which calculates the value of a cell. Functions – are predefined formulas and are already available in Excel Formula Bar – the bar that displays the contents of a cell. There are different formulas and function that are being used in Microsoft Excel. The following are: Basic Math Functions Sum – a function used to compute for the summation of the number of a range Average – a function used to compute for the average of the number of a range Max – Gives the maximum value in a range of cells Min – Gives the minimum value in a range of cells Count - a function used to count the cells with content in range What’s New Formulas and Functions MS Excel uses Formulas to calculate values. The equal typed in the cell signifies that a formula is created or the AutoSum function is used to build a formula. An Excel formula always begins with and equal (=) sign. 10 categorized as a Lookup/Reference Function. It can be used as a worksheet function in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet. Syntax: =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) Steps: 1. Identify a column of cells you'd like to fill with new data. In this case, that is column D entitled MRR. 2. Select 'Function' (Fx) > VLOOKUP and insert this formula into your highlighted cell. 3. Enter the lookup value for which you want to retrieve new data. The first criteria is your lookup value. This is the value of your spreadsheet that has data associated with it, which you want Excel to find and return for you. To enter it, click on the cell that carries a value you're trying to find a match for. In our example, shown above, it's in cell A2. You'll start migrating your new data into D2, since this cell represents the MRR of the 11 customer name listed in A2. 4. Enter the table array of the spreadsheet where your desired data is located. Next to the "table array" field, enter the range of cells you'd like to search and the sheet where these cells are located, using the format shown in the screenshot above. The entry above means the data we're looking for is in a spreadsheet titled "Pages" and can be found anywhere between column B and column K. 5. Enter the column number of the data you want Excel to return. Beneath the table array field, you'll enter the "column index number" of the table array you're searching through. For example, if you're focusing on columns B through K (notated "B:K" when entered in the "table array" field), but the specific values you want are in column K, you'll enter "10" in the "column index number" field, since column K is the 10th column from the left. 6. Enter your range lookup to find an exact or approximate match of your lookup value. In the given example, which concerns monthly revenue, you want to find exact matches from the table you're searching through. To do this, enter "FALSE" in the "range lookup" field. This tells Excel you want to find only the exact revenue associated with each sales contact. However, if you want Excel to look for an approximate match instead of an exact match. To do so, simply enter TRUE instead of FALSE in the fourth field shown above. 7. Click 'Done' (or 'Enter') and fill your new column. 12 What I Have Learned Microsoft Excel provides an automated way of displaying any statistical data. It can be used to automatically compute for several factors that are not easy to notice especially when face by a large data. Microsoft Excel includes several arithmetic and basic function that help you compute faster. Assessment Direction: Read each item carefully and choose the letter of the correct answer. Write your answers on a separate sheet of paper or in your notebook. 1. What do you call the cells that do not change? a. Constant cells b. Relative Reference c. Absolute Reference d. Single cells 2. What type of Excel function searches for a specific value in your data using the spreadsheet columns and a unique identifier within those columns? a. VLOOKUP b. IF Function c. COUNTIF d. Absolute Reference 3. What two Microsoft applications are used to create a mail merge? a. Word & PowerPoint b. PowerPoint & Excel c. Word & Excel d. Word & Publisher 4. You are suppose to find out the number of students with a score 85 in your class list. What function is best to use? a. COUNT b. MAX c. MIN d. PRODUCT 5. What do you call the software that people use to create and produce professional quality documents, presentations, databases, charts, and graphs? a. Production Tools b. Productivity Tools c. Professional Tools d. Advanced Application Tools