PRODUCTIVITY-TOOLS.pdf

PRODUCTIVITY TOOLS  Productivity Tools also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more. Applied Productivity Tools using: MS...

PRODUCTIVITY TOOLS  Productivity Tools also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more. Applied Productivity Tools using: MS WORD MS EXCEL MS POWERPOINT WORKING WITH WORD PROCESSOR (MICROSOFT WORD) A word processor is a computer program or device that provides for input, editing, formatting and output of text often with some additional features. Double Spacing 1. Highlight the texts that you want to double space > Home > Paragraph > Indents and Spacing > Spacing > Line Spacing > choose double > OK. (see Figure 2.1) Inserting Header and Footer 1. Open Word processor. 2. Click Insert > Header & Footer. (see Figure 2.2) Inserting a Page Number 1. In the same area of the footer and header, select the page number. 2. Choose what format and style you want to use in a page number. (see Figure 2.4)  WORKING WITH SPREADSHEET (MICROSOFT EXCEL) Spreadsheet applications like Microsoft Excel and Google Spreadsheets allow large set or group of data to be stored, organized, analyzed and interpreted automatically. Formatting the Spreadsheet 1. In your desktop, create a document named ‘My Weekly Budget’. Always Remember to save your progress by pressing Ctrl + S. 2. Create an additional tab by clicking the plus icon in the sheets tab below. (as shown by a red box in Figure 2.1) 3. Rename Sheet1 by double click its name and change it to Income. Do the same with Sheet2 and change it to Expense. (see Figure 2.2) 4. Select the Income tab and type the following data as seen in Figure 2.3. Then click the Expense tab and type the following data as seen in Figure 2.3 5. To adjust the cell width or height, click and drag the edge of the column or row heading respectively as seen in Figure 2.4 6. Go to the Income tab, then drag select cells A1 to C1. While the A1 to C3 cells are selected, in the ribbon click Home > Center then click Home > Bold as seen in Figure 2.5. Do the same for the Expense tab. 7. In the Expense tab, drag select from A1 to C15 then from the ribbon, click Home > Format as Table > Table Style Light 9 as specified in Figure 2.2. A prompt will appear as seen in Figure 2.6 that validates the selection range, then press OK. Do the same to A1 to C3 in the Income tab but use Table Style Light 10 instead. 7. In the Expense tab, drag select from A1 to C15 then from the ribbon, click Home > Format as Table > Table Style Light 9 as specified in Figure 2.2. A prompt will appear as seen in Figure 2.6 that validates the selection range, then press OK. Do the same to A1 to C3 in the Income tab but use Table Style Light 10 instead. WORKING WITH SLIDES (MICROSOFT POWERPOINT) A presentation software is an interactive and engaging slide that displays information. It also allows to create slide shows that present a topic, and a lecture to motivate, to communicate, and persuade the audience. Adding Pictures 1. In your desktop, create a PowerPoint Presentation and name it ‘My Presentation’. 2. On the first slide, click Insert > Pictures > Pictures from File. The Insert Pictures dialog box will 3. Locate the pictures in the folder where your pictures are saved. Select the file and click Insert. (see figure 2.2) ANSWER THE FOLLOWING QUESTIONS: (1 whole yellow paper) 1. How will you input a page number in the word processor? 2. How to add pictures in “It's not a faith in technology. It's faith in people.” -Steve Jobs, Co-founder of Apple.