ET-Q1-L4.pdfEmpowerment Technology is a subject in grade 12 STEM education that focuses on integrating technology into the teaching and learning processes.

Empowerment Technology is a subject in grade 12 STEM education that focuses on integrating technology into the teaching and learning processes.

1. Common
Productivity
Tools
Empowerment Technology: Lesson 4

2. Objectives:
1. Understand the common productivity tools such as
Word Processor, Slideshow Presentation, and
Spreadsheet;
2. Practice the different advanced techniques on Word
Processor, Slideshow Presentation, and Spreadsheet;
and
3. Create an advance document on Word Processor,
Slideshow Presentation, and Spreadsheet using the
prepared materials.
2

3. TASK 1
Direction: Name the logo of common productivity
tools.
3
1.

4. 2.
TASK 1
Direction: Name the logo of common productivity
tools.
4

5. 3.
TASK 1
Direction: Name the logo of common productivity
tools.
5

6. 4.
TASK 1
Direction: Name the logo of common productivity
tools.
6

7. 5.
What’s New
Direction: Name the logo of common productivity
tools.
7

8. 1.
Productivity
Tools

9. Productivity Tools
▸software that people use to create and produce
documents, presentations, databases, charts,
and graphs.
▸help you to create professional-quality
documents, presentations, graphics, and more.
9

10. “
Why should you learn
productivity tools?
10

11. 2.
Common
Productivity
Tools

12. Common Productivity Tools
▸Word Processor/ Word Processing Software
▸Slideshow Presentation
▸Spreadsheet Software
12

13. Common Productivity Tools
▸Word Processor/ Word Processing Software
▸Slideshow Presentation
▸Spreadsheet Software
13

14. Word Processor/ Word Processing
Software
▸Used to manipulate a text document, such as a
resume or a report
▸enter text by typing, and the software provides
tools for copying, deleting, and various types of
formatting.
14

15. Word Processor/ Word Processing
Software
15
MS Word WPS Writer Google
Docs
Libre
Writer

16. Word Processor/ Word Processing
Software
16

17. Slideshow Presentation
Software
▸computer program that allows the user to
create slide shows featuring text, images,
sound, and any other information, for the
purpose of presenting it to a person or group.
17

18. Slideshow Presentation
Software
18
MS
Powerpoint
WPS
Presentation
Google
Slides
Libre
Impress

19. Slideshow Presentation
Software
19

20. Spreadsheet Software
▸software application capable of organizing,
storing, and analyzing data in tabular form.
▸provide a digital simulation of paper accounting
worksheets.
20

21. Slideshow Presentation
Software
21
MS Excel
WPS
Speadsheet
Google
Sheets
Libre Calc

22. Slideshow Presentation
Software
22

23. 2.
Most use suite
productivity
tools

24. Common Productivity Tools
▸Microsoft Office
▸WPS Office
▸Libre Office
▸G Suite
24

25. Microsoft Office
▸desktop productivity applications that is
designed specifically by Microsoft for business
use.
▸released in 1990
▸a dominant model in delivering modern office-
related document-handling software
environments.
25

26. Microsoft Office
26

27. WPS Office
▸Writer Presentation Spreadsheet Office
▸office suite from China-based Kingsoft
Corporation
▸Windows, Mac, Linux, iOS, and Android.
27

28. WPS Office
28

29. Libre Office
▸free, open-source suite of office productivity
software.
▸word processing, spreadsheets, presentations,
database management, and graphics editing
▸Microsoft Windows, macOS, and Linux.
29

30. Libre Office
30

31. G Suite/ Google Suite
▸collaborative productivity apps that offers your
business professional email, shared calendars,
online document editing and storage, video
meetings, and much more.
31

32. G Suite/ Google Suite
32

33. 2.
Common
Productivity
Tools’
Techniques

34. Common Productivity Tools’ Techniques
34

35. 1. Word Processor: Mail Merge
▸Word’s way of generating mass mailings.
▸combining a list of names and addresses to
individually address each person/receiver of
the list.
▸create envelopes or address labels, as well as
form letters.
35

36. 1. Word Processor: Mail Merge
Mail Merged involved the following documents
▸The Main document
▸Mailing list
▸Merged Document
36

37. 1. Word Processor: Mail Merge
Mail Merged involved the following documents
▸The Main document
▹document contains text and
graphics. Example body of the
letter.
37

38. 1. Word Processor: Mail Merge
Mail Merged involved the following documents
▸Mailing List
▹data source that is used to
populate information in the letter.
▹It contains the names and
addresses of the recipients.
38

39. 1. Word Processor: Mail Merge
Mail Merged involved the following documents
▸Merged Document
▹combination of the main
document and mailing list
39

40. 2. Slideshow Presentation: Custom
Animation
▸Animation is a simulation of movement created
by displaying a series of pictures, or frames.
▸chief ingredients of multimedia presentations.
▸enable you to create animations that you can
display on a computer monitor.
40

41. 3. Slideshow Presentation: Hyperlinks
▸Link is reference data that the reader can
directly follow either by clicking or tapping.
▸nearly on all Web pages, allowing users to click
their way from one page to another.
▸color blue and underlined
41

42. 3. Slideshow Presentation: Hyperlinks
▸When you move the cursor over a hyperlink,
whether it is text, a button, or an image, the
arrow cursor should be changed to a small
hand pointing to the link.
42

43. 3. Slideshow Presentation: Hyperlinks
Hyperlinks have two basic parts:
▸The Address –can be a webpage, email
address, or other location they are linking.
▸The Display –can be a picture or shape.
43

44. 3. Slideshow Presentation: Hyperlinks
Hyperlinks have two basic parts:
Example
▸https://www.microsoft.com–address
Microsoft -display text
▸https://www.microsoft.com-address at the
same time display text.
44

45. 4. Word Processor: Integrating Images
▸Images make your documents look good and
presentable.
▸Crop, Resize, Enhance and Correct
45

46. 5. Spreadsheet: Function and Formula
▸database systems and graphic capabilities.
▸refers to a collection of text and numbers laid
out in a rectangular grid.
▸commonly used for budgeting, inventory
management, decision-making, forecasting, and
other finance-related tasks.
46

47. 5. Spreadsheet: Function and Formula
▸replaces the traditional financial modeling tools,
the accountant’s columnar pad, pencil, and
calculator.
47

48. 5. Spreadsheet: Function and Formula
▸Formula–an equation designed by a user in
Excel and this is an expression that calculates
values in a cell or in a range of cells.
For example, =A2+A2+A3+A4 is a formula that
adds up the values in cells A2 through A4.
48

49. 5. Spreadsheet: Function and Formula
▸Function-is a predefined formula already
available in Excel. Functions perform specific
calculations in a particular order based on the
specified values, called arguments, or
parameters.
For example, instead of specifying each
value to be summed like in the above formula, you
can use the SUM function to add up a range of
cells: =SUM(A2:A4)
49

50. TASK 2
our office
50
Direction: Answer the following questions.
1. Based on your reading of the discussion, give at least
three (3) types of productivity tools.
a. ____________________________
b. ____________________________
c. ____________________________
2. In the list that you provide in number 1, Which
productivity tool you used frequently? Why?

51. TASK 3
our office
51
Direction: Each group of students will do one of the
following tasks below
GROUP 1: Word Processor: Mail Merge
GROUP 2: Slideshow Presentation: Animation and
Applying Hyperlink
GROUP 3: Word Processor: Integrating Image
GROUP 4: Spreadsheet activity: Formula and
Function

52. TASK 3
our office
52
Mechanics:
•Read the additional material assigned to your group that it sends on our GC.
•Accomplish Challenge Part you will see in the last part of the activity that is
in the ppt.
•Group will follow the guide in the provided material to accomplish their task.
•Pointing system will be based on the provided rubrics.
•Group will present their work in class and share their experience in using
productivity tools.

53. TASK 3
our office
53
POINTING SYSTEM