MS Excel Presentation (Advance Productivity Tool).pptx

Presentation for Emptech (MS Excel)

1. Empowerment Technology by: Roel D. Madarcos

2. What are the materials that we can integrate in MS Word? What is the importance of using mail merge? How to create mail merge? Let’s Review!

3. Scenario: Greta conducted a research about Out of School Youth in Barangay New Barbacan, Roxas, Palawan. In her research she gathered the following data. Out of School Youth Survey Result Male Female Total 65 50 115 Questions: Do you have any idea about the software or application for which Greta used to come up with the survey result?

4. Instructions: Find your partner (your seatmate). Open Microsoft excel. Explore Excel in 60 seconds. Let’s Explore!

5. 5 1 2 5 6 4 3 Name Box Formula Bar Column Heading Row Heading Cell Sheet Tab With your partner, name each part of Microsoft Excel application.

6. Advanced spreadsheet Skills ( Advance and complex formulas and computation )

7. Familiarize the basic parts of Microsoft excel Identify the most commonly used functions available in Microsoft Excel Use Microsoft excel as a viable tool in different forms of data entries and calculations. Value the importance of Spreadsheet Lesson objectives:

8. It is a program designed to create spreadsheets which can later be used to analyze statistical data. Microsoft Excel

9. How do MS Excel differ from Spreadsheet?

10. MS Excel is the Program or Software, Spreadsheet is a file. MS Word is the Program, Document is a File Photoshop is the Program, graphic is a File

11. Basic parts of Microsoft excel

12. Row Heading – rows containing numbers. MS Excel starts with row 1 up to row 1,048,576 Sheet Tabs– used to display the worksheet you are currently working Cell – this is where you type any information or text. Formula also appears in cell. Name Box – this is where the name of active cell is being displayed. Formula Bar – this is where the formula or text is entered. Always start with EQUAL (=) sign when using a formula Column Heading – column containing letters. MS Excel starts with column A and ends with column XFD Name Box Formula Bar Column Heading Row H e a d i n g Cell Sheet Tab Basic parts of Microsoft Excel

13. Microsoft excel common functions

14. COUNT – a function used to count cells with content in a range. Syntax for Count function: =Count(range) =CountA(range) Microsoft Excel Common Functions Two Formulas for Count Function: Count – used to count numbers CountA – used to count numbers/letters

15. Microsoft Excel Common Functions What is the formula to get the total number of participants? =CountA(A3:A6)

16. SUM – a function used to compute for the summation of the number of range Syntax for Sum Function: =Sum(range) Microsoft Excel Common Functions Formula: =Sum(D3:D6)

17. AVERAGE – a function used to compute for the average of the number of range. Syntax for Average Function: =Average(range) Microsoft Excel Common Functions Formula: =Average(D3:D6)

18. Instructions: Look for Excel_Activity file located in your Desktop. Read the instructions and write the formula needed to perform computation. Each task is equivalent to 5 points. Do this activity in 5 minutes. Save your activity with your name as the filename for checking of output later. You will be graded based on the rubrics presented. ACTIVITY

19. SCORE DESCRIPTION 5 Formula contain no errors. 4 Formula have one (1) error. 3 Formula have two (2) errors 2 Formula have three (3) errors 1 Formula have four or more errors. Rubric for today’s activity

20. ACTIVITY The file contains the following: Name of Grade 12 STEM students enrolled in RNCHS Student’s gender Student’s Grade 11 General Average Your task is to get the total number of grade 12 STEM enrolled in RNCHS. Count the number of Female and Male student and; Get the Average of Students Grade 11 General Average.

21. Manual Computation Manual computation vs. Computerized Computation

22. Manual computation vs. Computerized Computation Computerized Computation

23. What is the importance or advantages of using spreadsheet than in manual computation? Do you think MS Excel software will help you in your studies? Why? Generalization

24. Instructions: Open CBE app in your Desktop computer. Proceed to Quiz 5 You have 3 minutes to answer the given questions. Short Quiz (5 items)

25. Create a spreadsheet of your weekly allowance by using the functions of MS Excel. Send your output through email @ [email protected] Additional Activities for Application