833335974-QUARTER 4-ICT-PPT--WEEK-6.pptx

Q4 ICT WK6 PPT

1. TLE 6 – ENTREP AND ICT QUARTER 4 WEEK 6 DAY 1

2. Direction: Why is conducting an online survey important? REVIEW

3. Are you familiar with this?

4. PERFORMING ADVANCE CALCULATIONS USING ELECTRONIC SPREADSHEETS

5. SPREAD SHEETS Spread sheets are designed with functions and formulas that will make calculating numerical data easier and convenient for you. Using formulas and functions will help you increase the accuracy of your calculations while decreasing the amount of time you need to spend in Excel.

6. SPREAD SHEETS Using Spreadsheets Probably the most popular electronic spreadsheet program that we use today is Microsoft Excel. It uses columns and rows, like a table, where you enter data in each cell.

7. OPEN-SOURCE Open-source refers to the software whose source code is available for anybody to access and modify, while proprietary software refers to the software which is solely owned by the individual or publisher who developed it

8. SPREADSHEETS Spreadsheets can help you do basic mathematical operation such as addition, subtraction and multiplication, and divisions:

9. SPREADSHEETS a. Format the column titles with text b. Enter textual information in each cell aside from number; c. Delete, add, or merge columns or rows; d. Add or delete sheets; and e. Select printing options

10. SPREADSHEETS Step 1 : Copy the Raw Materials Inventory in a new spreadsheet file.

11. SPREADSHEETS Step 2 : Compute for the [Available] by deducting [Daily Usage] from the [ Start of the Week]. Step 3 : To make this inventory more useful to you as entreprenuer , it should inform you whether there is a need to buy more stocks. This information should be included under [Remarks]. To do this, you should determine the percentage of [Available] based on the [ Start of the Week]. Add a columns that will contain the information.

12. SPREADSHEETS Step 3:

13. SPREADSHEETS Step 4 : Compute for the [Percentage of Remaining Stock].

14. SPREADSHEETS Step 5 : Use the [IF Function] to generate automatic comment under [Remarks].

15. SPREADSHEETS Note : The IF function in Excel Spreadsheet returns one value if the condition is true and another value it is false. Look at the Function Argument Box Below. What logical condition is set?

16. SPREADSHEETS In our example, if the data in column K is more than or equal to 50, column L will give a result of [Adequate]. But if the data is less than 50, then the result will be [inadequate]. Step 6 : Do the IF Function for the rest of the data in column L

17. SPREADSHEETS Step 7 : Now, add another row as illustrated below.

18. SPREADSHEETS Step 8 : Use the COUNTIF function to automatically count the number of items with [inadequate] Remarks under column L.

19. SPREADSHEETS Step 9 : Analyze the entries in the Function Argument Box.

20. SPREADSHEETS Step 10 : Add another column with [Supplier] as heading.

21. SPREADSHEETS Step 11 : This time you need to set a condition that will automatically set the suppliers’ name. To do this, you need to create a separate table which will serve as reference for the condition.

22. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

23. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

24. SPREADSHEETS Step 13 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box. Step 14 : Save your work.

25. ACTIVITY 1 Directions : Write whether it is TRUE or FALSE . 1. To add a new row in a spreadsheet, click a cell in the row directly above where you want the new row.

26. ACTIVITY 1 2. A formula and function are the same thing. 3. Spreadsheet programs calculate expressions within parentheses last and follow the MDAS rule.

27. ACTIVITY 1 4. It is possible to insert an image from a file into an electronic spreadsheet. 5. An electronic spreadsheet can be used as the “data source” for a Word Mail Merge.

28. ASSESSMENT Directions : TRUE or FALSE . Write your answers in your notebook. ________1. MS Excel is one of the most commonly used computerized worksheet.

29. ASSESSMENT ________2. SUMPRODUCT is a function that returns the remainder after a number is divided by a divisor. ________3. Using the formulas and functions will help you increase the accuracy of your calculations while decreasing the amount of time you need to spend.

30. ASSESSMENT ________4. MS Excel is widely used in accounting and financial applications, statistics, engineering calculations, as well as in analyzing data. ________5. To create and enter functions without the equal (=) sign, excel will still calculate a result.

31. TLE 6 – ENTREP AND ICT QUARTER 4 WEEK 6 DAY 2

32. Directions: Encircle TRUE if the statement is correct, FALSE if not. 1. True or False : Electronic spreadsheet software can be helpful in managing and updating records such as the balance sheet and income statement. REVIEW

33. 2. True or False: Microsoft Excel is probably the most popular electronic spreadsheet program used today. 3. True or False: Open-source software allows anyone to access and modify its source code, while proprietary software is solely owned by its developer or publisher. REVIEW

34. 4. True or False: Spreadsheets can perform basic mathematical operations such as addition, subtraction, multiplication, and division. REVIEW

35. 5. True or False: You can format column titles with text, enter textual information in cells, delete, add, or merge columns or rows, add or delete sheets, and select printing options in spreadsheets. REVIEW

36. Within one minute, provide a part of the spreadsheet inside the box.

37. PERFORMING ADVANCE CALCULATIONS USING ELECTRONIC SPREADSHEETS

38. SPREAD SHEETS Spread sheets are designed with functions and formulas that will make calculating numerical data easier and convenient for you. Using formulas and functions will help you increase the accuracy of your calculations while decreasing the amount of time you need to spend in Excel.

39. SPREAD SHEETS Using Spreadsheets Probably the most popular electronic spreadsheet program that we use today is Microsoft Excel. It uses columns and rows, like a table, where you enter data in each cell.

40. OPEN-SOURCE Open-source refers to the software whose source code is available for anybody to access and modify, while proprietary software refers to the software which is solely owned by the individual or publisher who developed it

41. SPREADSHEETS Spreadsheets can help you do basic mathematical operation such as addition, subtraction and multiplication, and divisions:

42. SPREADSHEETS a. Format the column titles with text b. Enter textual information in each cell aside from number; c. Delete, add, or merge columns or rows; d. Add or delete sheets; and e. Select printing options

43. SPREADSHEETS Step 1 : Copy the Raw Materials Inventory in a new spreadsheet file.

44. SPREADSHEETS Step 2 : Compute for the [Available] by deducting [Daily Usage] from the [ Start of the Week]. Step 3 : To make this inventory more useful to you as entreprenuer , it should inform you whether there is a need to buy more stocks. This information should be included under [Remarks]. To do this, you should determine the percentage of [Available] based on the [ Start of the Week]. Add a columns that will contain the information.

45. SPREADSHEETS Step 3:

46. SPREADSHEETS Step 4 : Compute for the [Percentage of Remaining Stock].

47. SPREADSHEETS Step 5 : Use the [IF Function] to generate automatic comment under [Remarks].

48. SPREADSHEETS Note : The IF function in Excel Spreadsheet returns one value if the condition is true and another value it is false. Look at the Function Argument Box Below. What logical condition is set?

49. SPREADSHEETS In our example, if the data in column K is more than or equal to 50, column L will give a result of [Adequate]. But if the data is less than 50, then the result will be [inadequate]. Step 6 : Do the IF Function for the rest of the data in column L

50. SPREADSHEETS Step 7 : Now, add another row as illustrated below.

51. SPREADSHEETS Step 8 : Use the COUNTIF function to automatically count the number of items with [inadequate] Remarks under column L.

52. SPREADSHEETS Step 9 : Analyze the entries in the Function Argument Box.

53. SPREADSHEETS Step 10 : Add another column with [Supplier] as heading.

54. SPREADSHEETS Step 11 : This time you need to set a condition that will automatically set the suppliers’ name. To do this, you need to create a separate table which will serve as reference for the condition.

55. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

56. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

57. SPREADSHEETS Step 13 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box. Step 14 : Save your work.

58. ACTIVITY 2 Directions : To ensure the success of your business, it is important to keep track of your customers’ order so you will not miss an opportunity to earn. Create a Purchase Order Inventory using an electronic spreadsheet hat contains the data below. Make sure to use Function Arguments to help you generate information.

59. ACTIVITY 2 Table 1: Purchase Order Inventory 1. A column for Customers’ Names (at least 5 names) 2. A column for products they ordered (3 products)

60. ACTIVITY 2 3. A column for prices (to save you time for encoding, aVLOOKUP Function) 4. A column for order quantity

61. ACTIVITY 2 5. A column for total amount per order 6. A column for [remarks] which will indicate if the order is [Retail] or [Bulk] use IF Function for this. Set the number of order for Retail or Bulk)

62. ASSESSMENT Directions : Answer the Table 2 using the information in the activity. Table 2: Summary of Order 1. A column for products 2. A column for total number of order per product 3. Two columns that will generate the count [Bulk] and[Retail] orders.

63. TLE 6 – ENTREP AND ICT QUARTER 4 WEEK 6 DAY 3

64. Directions : Answer the question. How does the process of using electronic spreadsheet software to manage inventory and make informed decisions about stock procurement reflect on the interconnectedness between technological tools and entrepreneurial decision-making? REVIEW

65. Compute the following using an electronic spreadsheet. Write the answers in your notebook. 1. 12345678 + 9876543 = _______________ 2. 65476736 ÷ 123873 = ________________ 3. 64638489 x 1528483 = _______________

66. PERFORMING ADVANCE CALCULATIONS USING ELECTRONIC SPREADSHEETS

67. SPREAD SHEETS Spread sheets are designed with functions and formulas that will make calculating numerical data easier and convenient for you. Using formulas and functions will help you increase the accuracy of your calculations while decreasing the amount of time you need to spend in Excel.

68. SPREAD SHEETS Using Spreadsheets Probably the most popular electronic spreadsheet program that we use today is Microsoft Excel. It uses columns and rows, like a table, where you enter data in each cell.

69. OPEN-SOURCE Open-source refers to the software whose source code is available for anybody to access and modify, while proprietary software refers to the software which is solely owned by the individual or publisher who developed it

70. SPREADSHEETS Spreadsheets can help you do basic mathematical operation such as addition, subtraction and multiplication, and divisions:

71. SPREADSHEETS a. Format the column titles with text b. Enter textual information in each cell aside from number; c. Delete, add, or merge columns or rows; d. Add or delete sheets; and e. Select printing options

72. SPREADSHEETS Step 1 : Copy the Raw Materials Inventory in a new spreadsheet file.

73. SPREADSHEETS Step 2 : Compute for the [Available] by deducting [Daily Usage] from the [ Start of the Week]. Step 3 : To make this inventory more useful to you as entreprenuer , it should inform you whether there is a need to buy more stocks. This information should be included under [Remarks]. To do this, you should determine the percentage of [Available] based on the [ Start of the Week]. Add a columns that will contain the information.

74. SPREADSHEETS Step 3:

75. SPREADSHEETS Step 4 : Compute for the [Percentage of Remaining Stock].

76. SPREADSHEETS Step 5 : Use the [IF Function] to generate automatic comment under [Remarks].

77. SPREADSHEETS Note : The IF function in Excel Spreadsheet returns one value if the condition is true and another value it is false. Look at the Function Argument Box Below. What logical condition is set?

78. SPREADSHEETS In our example, if the data in column K is more than or equal to 50, column L will give a result of [Adequate]. But if the data is less than 50, then the result will be [inadequate]. Step 6 : Do the IF Function for the rest of the data in column L

79. SPREADSHEETS Step 7 : Now, add another row as illustrated below.

80. SPREADSHEETS Step 8 : Use the COUNTIF function to automatically count the number of items with [inadequate] Remarks under column L.

81. SPREADSHEETS Step 9 : Analyze the entries in the Function Argument Box.

82. SPREADSHEETS Step 10 : Add another column with [Supplier] as heading.

83. SPREADSHEETS Step 11 : This time you need to set a condition that will automatically set the suppliers’ name. To do this, you need to create a separate table which will serve as reference for the condition.

84. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

85. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

86. SPREADSHEETS Step 13 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box. Step 14 : Save your work.

87. ACTIVITY 3 Directions: Imagine that you are managing a simple sari-sari store. Design an inventory worksheet in Excel identifying sample items that you sell. Follow the instructions below: 1. Type the name of your sari-sari store on the first row of the worksheet.

88. ACTIVITY 3 2. Type "ITEM" on the first column of row 3. 3. Type "QUANTITY" on the second column of row 3. 4. Type "UNIT PRICE" on the third column of row 3. 5. Type 15 items that you sell in the first column starting on the 4th row.

89. ACTIVITY 3 6. Type the corresponding quantity (between 25 - 100) and realistic unit price of each of the items. 7. Type "NO. OF ITEMS SOLD" on the fourth column of row 3. 8. Type "NO. OF ITEMS LEFT" on the fifth column of row 3.

90. ACTIVITY 3 9. Type "SALES" on the sixth column of row 3. 10. Type any number under NO. OF ITEMS SOLD for each of the items. Be sure to enter a number that is less than the given number under QUANTITY.

91. ACTIVITY 3 11. Format your inventory worksheet according to your own style. 12. Save your inventory worksheet.

92. ASSESSMENT Directions : Answer the following in your notebook. 1. How can an electronic spreadsheet help an entrepreneur run a business?

93. ASSESSMENT 2. Can we rely on an electronic spreadsheet to deliver an accurate output?

94. TLE 6 – ENTREP AND ICT QUARTER 4 WEEK 6 DAY 4

95. Directions: Answer the question. In what ways does the integration of formulae, functions, and conditional formatting in spreadsheets enhance an entrepreneur's ability to analyze business data and make strategic choices for inventory management? REVIEW

96. Perform the basic formulas/computations using Excel/spreadsheet.

97. PERFORMING ADVANCE CALCULATIONS USING ELECTRONIC SPREADSHEETS

98. SPREAD SHEETS Spread sheets are designed with functions and formulas that will make calculating numerical data easier and convenient for you. Using formulas and functions will help you increase the accuracy of your calculations while decreasing the amount of time you need to spend in Excel.

99. SPREAD SHEETS Using Spreadsheets Probably the most popular electronic spreadsheet program that we use today is Microsoft Excel. It uses columns and rows, like a table, where you enter data in each cell.

100. OPEN-SOURCE Open-source refers to the software whose source code is available for anybody to access and modify, while proprietary software refers to the software which is solely owned by the individual or publisher who developed it

101. SPREADSHEETS Spreadsheets can help you do basic mathematical operation such as addition, subtraction and multiplication, and divisions:

102. SPREADSHEETS a. Format the column titles with text b. Enter textual information in each cell aside from number; c. Delete, add, or merge columns or rows; d. Add or delete sheets; and e. Select printing options

103. SPREADSHEETS Step 1 : Copy the Raw Materials Inventory in a new spreadsheet file.

104. SPREADSHEETS Step 2 : Compute for the [Available] by deducting [Daily Usage] from the [ Start of the Week]. Step 3 : To make this inventory more useful to you as entreprenuer , it should inform you whether there is a need to buy more stocks. This information should be included under [Remarks]. To do this, you should determine the percentage of [Available] based on the [ Start of the Week]. Add a columns that will contain the information.

105. SPREADSHEETS Step 3:

106. SPREADSHEETS Step 4 : Compute for the [Percentage of Remaining Stock].

107. SPREADSHEETS Step 5 : Use the [IF Function] to generate automatic comment under [Remarks].

108. SPREADSHEETS Note : The IF function in Excel Spreadsheet returns one value if the condition is true and another value it is false. Look at the Function Argument Box Below. What logical condition is set?

109. SPREADSHEETS In our example, if the data in column K is more than or equal to 50, column L will give a result of [Adequate]. But if the data is less than 50, then the result will be [inadequate]. Step 6 : Do the IF Function for the rest of the data in column L

110. SPREADSHEETS Step 7 : Now, add another row as illustrated below.

111. SPREADSHEETS Step 8 : Use the COUNTIF function to automatically count the number of items with [inadequate] Remarks under column L.

112. SPREADSHEETS Step 9 : Analyze the entries in the Function Argument Box.

113. SPREADSHEETS Step 10 : Add another column with [Supplier] as heading.

114. SPREADSHEETS Step 11 : This time you need to set a condition that will automatically set the suppliers’ name. To do this, you need to create a separate table which will serve as reference for the condition.

115. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

116. SPREADSHEETS Step 12 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box.

117. SPREADSHEETS Step 13 : The VLOOKUP function will be used for this task. Take a look at the Function Argument Box. Step 14 : Save your work.

118. ACTIVITY 4 Directions : Read and analyze the following statements or questions below. Choose the letter of the correct answer.

119. ACTIVITY 4 1. It multiplies all the numbers given as argument. a. Quotient b. Sum c. Product d. Power

120. ACTIVITY 4 2. What functions should be used when adding all the numbers in a range of cell? a. Sum b. Product c. Quotient d. MOD

121. ACTIVITY 4 3. What function should be used when adding the cells specified by the condition or criteria? a. SUMPRODUCT b. SUMIF c. SUMIFS d. SUMSQ

122. ACTIVITY 4 4. It returns the integer portion of a division. a. Quotient b. Sum c. Product d. Power

123. ACTIVITY 4 5. This function returns the remainder after a number is divided by a divisor. a. SUMPRODUCT b. MOD c. SUMIF d. SUMSQ

124. ASSESSMENT Directions: Answer the question. 1. How would you compare and differentiate the features of proprietary software and those of open source software?