Basic Computer Skill II PDF

Basic Computer Skill II Module Title: Basic Computer Skill II Module code: TCBC-II (TVET, Common Course Basic Computer Skill–II) Nominal duration: 48 Hour Prepared by: Ministry of Labor and Skill...

Basic Computer Skill II Module Title: Basic Computer Skill II Module code: TCBC-II (TVET, Common Course Basic Computer Skill–II) Nominal duration: 48 Hour Prepared by: Ministry of Labor and Skill Addis Ababa, Ethiopia Table of Contents Introduction to the Module.................................................................................................................................................................................... 6 Unit One: Creating Simple Database................................................................................................................................................................... 7 1.1. Database Concepts and Terminologies.......................................................................................................................................................... 7 1.2. Database Design Principles........................................................................................................................................................................... 9 Figure 1:Blank database...................................................................................................................................................................................................... 12 1.4. Creating Table.............................................................................................................................................................................................. 13 Figure 2:.............................................................................................................................................................................................................................. 14 1.4.1. Data Type and Field Properties................................................................................................................................................................................ 14 Figure 3: Create Tab............................................................................................................................................................................................................ 15 Table 1. Data type and Field size........................................................................................................................................................................................ 19 1.4.2. Entering Field into a Table....................................................................................................................................................................................... 19 Figure 4:Field/Size property dialog box.............................................................................................................................................................................. 20 1.5. Creating Queries........................................................................................................................................................................................... 21 Figure 5:Query Design Box.................................................................................................................................................................................................. 24 1.6. Creating Report............................................................................................................................................................................................ 24 Figure 6: Report format...................................................................................................................................................................................................... 26 1.7. Printing Database......................................................................................................................................................................................... 26 1.7.1. To Adjust the Margins............................................................................................................................................................................................... 27 1.7.2. To Print the Report................................................................................................................................................................................................... 27 Unit TWO: Produce Different Publications........................................................................................................................................................ 29 1.1. Introduction to Microsoft Publisher......................................................................................................................................................... 29 1.2. Exploring the Publisher Interface............................................................................................................................................................. 30 Ministry of Labor and Version -1 Page 2 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  fig.1 create new publication............................................................................................................................................................................................... 35 Fig.2..................................................................................................................................................................................................................................... 36 Colorschema....................................................................................................................................................................................................................... 36 2.3.1. Adding Text in a Document....................................................................................................................................................................................... 37 2.3.2. Adding Text Box........................................................................................................................................................................................................ 37 2.3.3. Resizing the text box:................................................................................................................................................................................................ 38 2.3.4. Formatting Text Box.................................................................................................................................................................................................. 38 Fig 3 publisher catalog........................................................................................................................................................................................................ 39 2.4. Inserting Graphics........................................................................................................................................................................................ 44 2.4.1. Editing Graphics........................................................................................................................................................................................................ 44 2.5. Creating a Table........................................................................................................................................................................................... 46 2.6. Opening publication with template.............................................................................................................................................................. 46 2.7. Customize publication.................................................................................................................................................................................. 47 2.8. Print a publication......................................................................................................................................................................................... 48 Fig 4 print publication......................................................................................................................................................................................................... 49 Fig 5..................................................................................................................................................................................................................................... 50 Self-Check Test#1................................................................................................................................................................................................................ 54 Unit Three: Prepare Electronic Presentation................................................................................................................................................. 55 3.1. Concept and Terminologies of Microsoft Power point................................................................................................................................ 55 3.2. Opening Blank Power Point......................................................................................................................................................................... 56 3.2.1. Exploring the User Interface (power point 2010)..................................................................................................................................................... 56 Table 2: Power point program windows elements............................................................................................................................................................. 58 3.2.2. Creating, Saving, and Closing a Presentation............................................................................................................................................................ 58 3.4. Entering Text and Graphics.......................................................................................................................................................................... 59 Ministry of Labor and Version -1 Page 3 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 9: Placeholder.......................................................................................................................................................................................................... 59 3.4.1. To insert graphics..................................................................................................................................................................................................... 60 3.4.2. Inserting Images....................................................................................................................................................................................................... 60 3.4.3. Editing Text and Graphics........................................................................................................................................................................................ 61 3.5. Slide Design and Animation......................................................................................................................................................................... 67 Figure 9: Design Tab............................................................................................................................................................................................................ 68 3.5.1. Slide Transitions....................................................................................................................................................................................................... 68 Figure 10: Animation Tab.................................................................................................................................................................................................... 68 Self Check Test.................................................................................................................................................................................................................... 69 Unit four: Accessing internet.............................................................................................................................................................................. 71 4.1. Access online information............................................................................................................................................................................ 72 4.2. HOW TO USE E-MAIL............................................................................................................................................................................ 74 4.3. Create Email Account.................................................................................................................................................................................. 75 Fig. 3 sign in Hotmail........................................................................................................................................................................................................... 76 4.3.1. Implement procedures to send and receive electronic mail.................................................................................................................................... 76 fig. 4................................................................................................................................................................................................................................... 77 4.4. GMAIL BASICS....................................................................................................................................................................................... 80 Fig. 5 creating Gmail............................................................................................................................................................................................................ 80 Fig. 5.1............................................................................................................................................................................................................................. 83 4.5. Check and download information................................................................................................................................................................ 85 Ministry of Labor and Version -1 Page 4 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Acknowledgment Ministry of Labor and Skills wish to extend thanks and appreciation to the many representatives of TVET instructors and respective industry experts who donated their time and expertise to the development of this Teaching, Training and Learning Materials (TTLM). Ministry of Labor and Version -1 Page 5 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Introduction to the Module Basic computer skill II is about how computers work and how to use them. This may include creating simple database, producing publications, preparing presentation using power point and knowing how to connect and disconnect the Internet to a computer to search important information regarding their field of study. It can help you understand different operating systems and application software. In basic computer skill field, producing different types of documents and browsing Internet is very important for the overall activities related to computer usage. This module covers the units: Creating Simple Database Producing Different Publications Preparing Electronic Presentation Access Internet Training Objective of the Module Create Simple Database Produce Different Publication Prepare Electronic Presentation Module Instruction For effective use this modules trainees are expected to follow the following module instruction: 1. Read the information written in each unit 2. Accomplish the Self-checks at the end of each unit 3. Perform Operation Sheets which were provided at the end of units 4. Do the “LAP test” giver at the end of each unit and 5. Read the identified reference book for Examples and exercise Ministry of Labor and Version -1 Page 6 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Unit One: Creating Simple Database This unit is developed to provide you the necessary information regarding the following content coverage and topics: Data base concepts and definition of Terminologies Database Design Principles Create a Blank Database Create Table Create Query Create Report OHS requirements This unit will also assist you to attain the learning outcomes stated in the cover page. Specifically, upon completion of this learning guide, the trainee will be able to: Explain the Concept of database and define database Terminologies Describe Database Design Principles Create a Blank database Create Table with appropriate data type and field size Observe OHS requirements and personal protection needs 1.1. Database Concepts and Terminologies A database is a self-describing collection of integrated records. Ministry of Labor and Version -1 Page 7 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  From this definition of Database, it is important to understand each part of this definition. A database is Self-describing This implies database contains, in addition to the user source data, a description of its own structure. This description is called a Data Dictionary (also called a metadata). A database is a collection of integrated records Database is formed from the standard hierarchy of data as: Bits are aggregated into Bytes or Characters; Characters are aggregated into Fields; Fields are aggregated into Records; Records are aggregated into Files; and Finally, Files are aggregated into Database. Database includes:-Files of user data, Description of itself in the metadata, indexes that are used to represent relationships among the data and Application Metadata (the structure of data entry form, or report). Ministry of Labor and Version -1 Page 8 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  1.2. Database Design Principles In creating database, database schema defines database`s structure, its tables, relationships, domains and business rules. Database schema is a design, the foundation on which database and applications are built. Database design tools have a set of tools to facilitate the design and creation of the database and its applications. It typically includes tools for creating tables, forms, queries, and reports. Database can be modeled by Relational database model, Hierarchal Database Model, Network and Object models. In this module database design for relational database will be discussed. A relational database organizes the data in tables (or relations). A table is made up of Rows and Columns Database Design Objectives Eliminate Redundancy Ensure Data Integrity Ensure accuracy , etc Database Design is more art than science, as you have to make many decisions. The design process consists of the following steps: 1) Determine the purpose of your database This helps you to prepare the remaining steps. 2) Find and organize the information required Gather all of the types of information you might want to record in the database, such as product name and order number. Ministry of Labor and Version -1 Page 9 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  3) Divide the information into tables Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table. 4) Turn information items into columns Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date. 5) Specify primary keys Choose each table’s primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID. 6) Set up the table relationships Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables or create new tables to clarify the relationships, as necessary. 7) Refine your design Analyze your design for errors. Create the tables and add a few records of sample data. See if you can get the results you want from your tables. Make adjustments to the design, as needed. Apply the data normalization rules to see if your tables are structured correctly. Make adjustments to the tables, as needed. Ministry of Labor and Version -1 Page 10 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  1.3. Open a Blank Database Ms Access is one of the application software that allows you to manage your information in one database file. Within Access there are four major areas: Tables, Queries, Forms and Reports Operation Sheet #1. Open a Blank database Starting MS Access To start Ms Access follow the following steps Start All Programs Microsoft Office Microsoft Office Access 2007 Creating new Database When you start Office Access 2013 by clicking the Windows Start button or a desktop shortcut (but not when you click on a database), the Getting Started with Microsoft Office Access page appears. This page shows what you can do to get started in Office Access 2013. Ministry of Labor and Version -1 Page 11 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 1:Blank database For example, you can create a new blank database, create a database from a template, or open a recent database (if you have opened some databases before). You can also go directly to Microsoft Office Online to learn more about 2007 Microsoft Office system and Office Access 2007, or you can click the Microsoft Office Button and use the menu to open a existing database. Open a new blank database 1. Start Access from the Start menu or from a shortcut. Ministry of Labor and Version -1 Page 12 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  The Getting Started with Microsoft Office Access page appears. 2. On the Getting Started with Microsoft Office Access page, under New Blank Database, click Blank Database. 3. In the Blank Database pane, in the File Name box, type a file name or use the one that is provided for you. 4. Click Create. The new database is created, and a new table is opened in Datasheet view. Office Access 2007 provides a number of templates with the product, and you can download more from Microsoft Office Online. What is a template? In the context of Office Access 2007, it is a predesigned database complete with professionally designed tables, forms, and reports. Templates give you a big head start when you create a new database. 1.4. Creating Table A table contains data about a particular subject, such as employees or products. Each record in a table contains information about one item, such as a particular employee. A record is made up of fields, such as name, address and telephone number. A record is also commonly called a row, and a field is also commonly called a column. Ministry of Labor and Version -1 Page 13 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 2: 1) Record or records 2) Field or column Your database can contain many tables, each storing information about a different subject. Each table can contain many fields of different types, including text, numbers, dates, and pictures. The following list shows some common examples of tables you might create. A customers table that lists your company’s customers and their addresses A catalog of products you sell, including prices and pictures for each item A tasks table that tracks tasks and due dates An inventory of equipment or stock on hand You should plan and design your database carefully to ensure its correctness and to avoid having to make too many changes later. For information about planning and designing your database, see the article Database design basics 1.4.1. Data Type and Field Properties Operation Sheet #2. Data type with field properties Create a new table in a new database Ministry of Labor and Version -1 Page 14 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  1. Click the Microsoft Office Button , and then click New. 2. In the File Name box, type a file name. To change the location, click the folder icon to browse. 3. Click Create. The new database is opened, and a new table named Table1 is created and opened in Datasheet view. Create a new table in an existing database 1. Click the Microsoft Office Button , and then click Open. 2. In the Open dialog box, select and open the database. 3. On the Create tab, in the Tables group, click Table. Figure 3: Create Tab The following table describes the data types available for fields in Office Access 2007. Ministry of Labor and Version -1 Page 15 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Data type Stores Size Text Alphanumeric characters Up to 255 characters. Use for text, or text and numbers that are not used in calculations ( for example, a product ID). Memo Up to 1 gigabyte of Alphanumeric characters (longer than characters, or 2 gigabytes of 255 characters in length) or text with storage (2 bytes per rich text formatting. character), of which you can display 65,535 characters in Use for text greater than 255 characters a control. in length, or for text that uses rich text formatting. Notes, lengthy descriptions, and paragraphs with formatting such as bold or italics are good examples of where you would use a Memo field. Number Numeric values (integers or fractional 1, 2, 4, or 8 bytes, or 16 values). bytes when used for replication ID. Use for storing numbers to be used in calculations, except for monetary values (use the Currency for data type for monetary values). Ministry of Labor and Version -1 Page 16 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Date/Time Dates and times. 8 bytes. Use for storing date/time values. Note that each value stored includes both a Currency Monetary values. 8 bytes. Use for storing monetary values ( currency ). AutoNumber A unique numeric value that Office 4 bytes or 16 bytes when Access 2007 automatically inserts when used for replication ID. a record is added. Use for generating unique values that can be used as a primary key. Note that AutoNumber fields can be incremented sequentially, by a specified increment, or chosen randomly. Yes/No Boolean values. 1 bit (8 bits = 1 byte ). Use for True/False fields that can hold one of two possible values: Yes/No or True/False, for example. Ministry of Labor and Version -1 Page 17 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright OLE Object OLE objects or other binary data. Up to 1 gigabyte. Use for storing OLE objects from other Microsoft Windows applications. Attachment Pictures, Images, Binary files, Office For compressed attachments, 2 gigabytes. files. For uncompressed attachments, approximately This is the preferred data type for 700k, depending on the storing digital images and any type of degree to which the binary file. attachment can be compressed. Hyperlink Hyperlinks. Up to 1 gigabyte of characters, or 2 gigabytes of Use for storing hyperlinks to provide storage (2 bytes per single-click access to Web pages character), of which you can through a URL (Uniform Resource display 65,535 characters in Locator) or files through a name in UNC a control. (universal naming convention) format. You can also link to Access objects stored in a database. Ministry of Labor and Version -1 Page 18 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Lookup Wizard Not actually a data type; instead, this Table or query based: The invokes the Lookup Wizard. size of the bound column. Use to start the Lookup Wizard so you Value based: The size of the can create a field that uses a combo box Text field used to store the to look up a value in another table, query value or list of values. Table 1. Data type and Field size A new table is inserted in the database and the table is opened in Datasheet view. Office Access 2007 provides a number of templates with the product, and you can download more from Microsoft Office Online. What is a template? In the context of Office Access 2007, it is a predesigned database complete with professionally designed tables, forms, and reports. Templates give you a big head start when you create a new database. 1.4.2. Entering Field into a Table For the Text and Number data types, you can specify the field size or data type more specifically by setting the FieldSize property. Ministry of Labor and Version -1 Page 19 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 4:Field/Size property dialog box Operation sheet #3 Entering Field into a Table 1) Type a name for the first field in the table 2) Press Enter 3) Select a data type 4) Press Enter 5) Type a description for the field Ministry of Labor and Version -1 Page 20 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  6) Press Enter Continue this until all necessary fields have been entered into the table. Note: The order that you enter the field names is the order the fields will appear in the table and on a form. 1.4.3. Entering Data into a Table Once you have entered the fields and set the data types it is now time to enter the records in a table. Operation sheet #4 Entering Data into a Table View the Datasheet: Click the View button on the Ribbon To Enter Data in a Table: 1) Make sure you are in Datasheet View 2) Enter the data into the table by pressing the tab key to move from one cell to another 3) When you have completed the record ( row), press Enter Information sheet #2 Creating Query 1.5. Creating Queries A query is a request for data or information from a database table or combination of tables. A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database. You use Queries to view, change, and analyze data in different ways. You can also use them as a source of records for forms and reports. Ministry of Labor and Version -1 Page 21 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Operation sheet #5 Creating Query To Create a Query: 1) Click the Create tab on the Ribbon 2) Click Query Design icon 3) Double-click Create Query in Design View 4) Select the table that you would like to base your Query on 5) Click Add 6) Close the Show Table window The table(s) will now be displayed in the upper part of the Query Design Screen by boxes containing the tables’ fields. 7) Double click on the field names in the field list window which you would like to include in the Query Defining Criteria in the Query In order to control which records are displayed, you must define criteria in a Query. The most common type of Query is the Select Records Query which will be discussed below. Ministry of Labor and Version -1 Page 22 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  To Define Criteria for your Query: 1) Position your cursor in the criteria row in the field for which you wish to define the criteria for 2) Enter the criteria 3) Click the Run Query button Ministry of Labor and Version -1 Page 23 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 5:Query Design Box Information Sheet Creating Report 1.6. Creating Report A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage Reports can be based on tables or queries and can be made with the Report Wizard. Operation sheet #6 Creating Report To Create a Report Using the Report Wizard: Ministry of Labor and Version -1 Page 24 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  1) Click the Create tab on the Ribbon 2) Click the Report Wizard icon 3) Select the table or query upon which the report will be based 4) Select the fields that you want to include on the report by double clicking on them 5) Click Next 6) If you would like to add grouping to your report, select the field you wish to group by double clicking on it (Example: City) 7) Click Next 8) Select a style for the report 9) Click Next 10) Type a title for the report 11) Click Finish Ministry of Labor and Version -1 Page 25 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 6: Report format Information sheet Printing a Database 1.7. Printing Database After creating the table, queries, and reports, we can store and access the database as we need. Operation sheet #7 Printing a Database To Print a Report 1) Open the report by double clicking on the object in the Navigation Pane 2) By default, the report opens in Print Preview. To Adjust the Orientation: Ministry of Labor and Version -1 Page 26 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Click the portrait or landscape icon on the Print Preview Ribbon 1.7.1. To Adjust the Margins 1) Click them Margins icon on the Print Preview Ribbon 2) Select a margin size 1.7.2. To Print the Report 1) Click the Print Icon on the Print Preview Ribbon 2) Select the Printer Click Ok. self Check test one Self Check Test #1 Create Simple Database Create a table called “List” and do the following tasks EmpID Full Name Sex Age Salary Department Photo 101 Hanna Mogos F 26 8954 Finance 102 Milla Kebede F 45 8745 HRM 103 Geremew Degu M 29 9547 ICT 104 Debebe Dadi M 31 5847 HRM Ministry of Labor and Version -1 Page 27 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  105 Ambachew Kifle M 25 9587 Finance 106 Girum Tibebe M 28 8452 HRM 107 Yordanos Hailu M 36 6547 Finance 108 Frehiwot Alem F 40 4562 HRM 109 Yasin Kebede M 51 6987 Finance Instruction Set primary key to EmpID Sort by full name Filter data from the table where sex is Female only Filter data from the table where sex is Female and finance department Filter data from the table where Age is greater than and equals to 25 Filter data from the table where sex is male ,salary greater than 5000 and department is HRM Create report and print it Create report where it shows Emp ID, Full Name and their salary Create report where it shows Emp ID, Full Name and their sex Ministry of Labor and Version -1 Page 28 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Unit TWO: Produce Different Publications This unit is developed to provide you the necessary information regarding the following content coverage and topics: Introduction to Microsoft publisher Exploring the Publisher Interface Entering Text in a blank Document Inserting Graphics Creating a Table Opening Publication with Template Print Publication This unit will also assist you to attain the learning outcomes stated in the cover page. Specifically, upon completion of this learning module, you will be able to: producing different publication Identifying publication layout Customizing the View of the Publisher window 1.1. Introduction to Microsoft Publisher Publisher 2007 is a desktop publishing program that can be used to create a variety of professional publications such as flyers, newsletters, business card, brochures, etc. Ministry of Labor and Version -1 Page 29 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  1.2. Exploring the Publisher Interface 1. Open Microsoft Office Publisher 2007. 2. From the Microsoft Publisher window, click Blank Page Sizes in the Popular Publication types pane 3. The middle pane will change to reflect the blank page Click the Create button at the bottom right edge of the window Ministry of Labor and Version -1 Page 30 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Title bar - top of the window and display the program name. Menu bar - contains menu that list command organized in categories. Ministry of Labor and Version -1 Page 31 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Toolbars - contain buttons for frequently used publisher commands. Rulers - allow you to precisely measure the size of objects and place objects in exact location of a page. Status bar - location of the bottom of publisher. Task Pan - the task pane is an area of the window that is used to organize color schemes, font schemes and other layout tools in a visual gallery. Page navigation icon – navigate different pages in the layout. Ministry of Labor and Version -1 Page 32 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Operation Sheet#1 Creating a new Publications 2.3. Creating a new Publications Steps: 1. Click on File from the menu. 2. Click on New from the drop down menu. 3. Click on the Blank Publications tab. 4. Click on the style from the Blank Publication window. 5. Click on the Create button located in the bottom right corner of the Catalog window. 6. Choose Yes to automatically insert pages. 7. Add a design by Design in the Quick Publications Wizard window. 8. Scroll to the design to be used from the Design window and click on design. 9. From the Quick Publications window, click on the color scheme to select it. 10. Choose Layout from the Quick Publications window. 11. In the Layout window, choose your layout. Blank Publications The third tab is the Blank Publication. If you want to create publications from scratch, click on this tab. Blank publications allow you to create using the following style Page 33 of 84 Ministry of Labor and Version -1 Skills Basic Computer Skill II September, 2022 Author/Copyright ☑Business Card ☑Postcard ☑Poster ☑Banner And More… These pages come set with the page size, orientation, margins, and other settings you will need to create your own publication. To begin, click on the blank publication needed. Click on the Create button. You will have a Quick Publication Wizard appear on the left side of your window. This Wizard will allow you to choose the design, color scheme, and layout of your publication. Ministry of Labor and Version -1 Page 34 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Fig.1 create new publication 1) Select a Presentation Type from the left 2) Click on one of the Designs 3) Customize your presentation by selecting a color scheme, font scheme, and layout 4) Click on Create Ministry of Labor and Version -1 Page 35 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Fig.2 Color schema Ministry of Labor and Version -1 Page 36 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  2.3.1. Adding Text in a Document 1. On the Objects toolbar, click the text box icon. Your mouse will turn into a crosshair. 2. Point near the top of the page and drag down and to the right 3. A text box will appear Type your text in the text box. If you are having a hard time seeing the text, click the Zooming icon on the toolbar. 4. Drag your mouse across the text At this point you can do any of the following: Change the publication's color scheme ❖ Click Color Schemes in the task pane, and then click the color scheme that you want Change the publication's font scheme ❖ Click Font Schemes in the task pane, and then click the font scheme that you want ❖ Click Quick Publication Options in the task Pane, and then click the publication design that You want When the MS Publisher application is activated. 2.3.2. Adding Text Box Displayed this can be done by resizing the text box or moving the text to another Text Overflow Button Connect Text Frames Button. Operation Sheet#2 Adjusting Text Overflows Steps for Adjusting Text Overflows: Ministry of Labor and Version -1 Page 37 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Select the text box with the overflow (handlebars will appear when selected). 1. Click on the Connect Text Frames Button from the Standard toolbar. 2. Your pointer will change to a pitcher with an arrow on the face of it. 3. Place your pointer over the text box you wish to connect. 4. This text box can be located anywhere in your publication. 5. Once the pointer is placed over the new text box, it will turn to a pitcher pouring out. 6. Click on the text box and the overflow of text will be placed in the selected text box. After Connecting Text Boxes, Adding Text to the Original Text Box: 2.3.3. Resizing the text box: 1. Place your mouse pointer on a handlebar until it turns to a double-edged arrow with a box in the center and says resize. 2. Drag the handlebar in or out, depending if you wish to decrease or increase the box. 2.3.4. Formatting Text Box 1. Select the information by clicking once on it, and then press your delete key until the information is gone. Or, once selected, choose Edit from the menu; choose Cut from the drop down menu. Ministry of Labor and Version -1 Page 38 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Fig 3 publisher catalog This Catalog can be used to create new publications or open existing ones. There are three tabs in this Catalog: Publications by Wizard, Publications by Design, and Blank Publications. These are each described below. Publication by wizard Publications by type are displayed here. If you need to create a newsletter, simply click on the newsletter wizard on the left side of the catalog and newsletter templates will appear on the right. You can scroll through the different designs until you locate the template you would like to use. Click on the template of choice then click on the Start Wizard button. Ministry of Labor and Version -1 Page 39 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Creating your project. Options available to you using the Wizard may include: Color Scheme ☑Number of Columns Address Placeholder ☑printing lay-out choices Personal Information ☑And More depending on Publication type after making your personal choices using the Wizard, click on the Finish button. Your window is now split with a different Wizard window that will allow you to change your previous choices at any time. In addition, it may contain other options that were not available in the other Wizard window such as inserting pages. Once you have made your design choices, you are now ready to enter your data. You can hide the Wizard at any time by clicking on the Hide Wizard button at the bottom of the Wizard window. By closing the window, you will have a larger window to work on your project. Operation Sheet#3 Create a Publication by Wizard Create a Publication using Publications Ministry of Labor and Version -1 by Wizard Page 40 of 88 Skills Basic Computer Skill II September, 2022 Steps Author/Copyright  1. Click on the Publications by Wizard tab. 2. Click on the publication type in the Wizard window. 3. Scroll to locate the Design style and click to select it. 4. Click on the Start Wizard button. Using the Wizard window to change the design. In the Wizard window: 1. Click on the next button 2. Choose the color scheme 3. Choose whether to use a placeholder on your publication Add a tear-off element if necessary 4. Choose whether to add the placeholder’s address 5. Choose to add your primary business information by clicking the Update button a. Under the Name text box type, enter organization b. Under Address text box, enter mailing address Ministry of Labor and Version -1 Page 41 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  c. Type your phone #, Fax #, and e-mail address under the appropriate text box d. Enter your organization or department name 7. Type a tag line or motto in. Example: For all your computing needs! a. Type your title or job position in the appropriate text box. b. Choose a color scheme c. Click on the update button d. Click the Finish button To enlarge the view of your project: 1. Click on View from the menu. 2. Click on Zoom from the drop down menu. 3. Click on 100% from the sub-menu. 4. Click on the Hide Wizard button. Ministry of Labor and Version -1 Page 42 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Operation Sheet#4 Inserting pages Inserting additional pages: 1. Choose insert from the menu. 2. Choose page… from the drop down menu. 3. From the dialog box, choose the amount of pages to insert, the location of the page/pages to be inserted, and the type of pages to insert. 4. Click the ok button. Add Page Numbers: To add page numbers without mirrored guides 1. Click on View from the menu. 2. Click on Go to Background from the drop down menu. 3. Draw a text box where you want the page number to go. 4. Click on Insert from the menu, click on Page Numbers from the drop down menu. 5. Click on Arrange from the menu, click on layout guides from the drop down menu. Create a Publication using Publications by Design Steps: 1. Click on File from the menu, click on New from the drop down menu. 2. In the Catalog, click on the Publications by Design tab. Ministry of Labor and Version -1 Page 43 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  3. In the Design Sets box, choose your design. 4. Select the type of publication to be created. 5. Click on the Start Wizard button. 6. Use the publication Wizard. 7. Choose the color scheme. 8. Choose whether to include a Logo. 9. Choose printing instructions if available. 10. Choose which personal information to use. 11. Click on the Finish button. Operation Sheet#5 Inserting Graphics 2.4. Inserting Graphics 1. Choose Insert from the menu, choose Picture from the drop down menu, and 2. Choose Clip Art from the sub-menu. 3. In the Search for Clips textbox in the Clip Art catalog, type in your subject and press your Enter key. 4. Select by clicking on the picture. 5. Click on the Insert clip icon from the drop down box. 6. Click on the X to close the Clip Art catalog. 7. Place your picture in the proper location. 2.4.1. Editing Graphics Moving clip art 1. Place your mouse pointer over your clip art. Ministry of Labor and Version -1 Page 44 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  2. When the arrow becomes 4-way, hold your left mouse button down while dragging the picture to the appropriate position. 3. Release your mouse button. Using your Rulers The status bar provides two types of information regarding your graphics. The first figure addresses the location of your graphic horizontally and vertically. The dimensions of the graphic selected are the second figure. As you hold down the mouse pointer over your graphic, you can see markings horizontally and vertically on the ruler. Using these markings can assist you in placement of graphics and other objects in your layout. Operation Sheet#6 Creating a Text Box Creating a Text Box 1. Click on the Text Frame tool from the Objects Toolbar located on the left side of the Publisher window. Your cursor will change to a +. 2. Place the + inside the blue dotted layout guide where you wish to start your text box. 3. Hold the left mouse button down as you drag the cursor and draw the text box. 4. Release the mouse button once you have drawn your box. 5. Click inside the text box just Ministry of Labor and Version -1 made to begin typing. Page 45 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  6. To better see what you are typing, click on View from the menu, click on Zoom from the drop down. Information Sheet Creating a Table 2.5. Creating a Table 1. Click on the Table Frame Tool from the Objects Toolbar (located just under the Text Box Tool). 2. Draw a box as you did the Text Box. 3. In the Create Table dialog box, choose the number of rows needed, the number of columns needed, and Table Format. 4. Click the ok button. 5. Type the table content in each cell. Opening Existing Files Publications that you have already created and saved can be opened by clicking on the Existing Files button located on the left bottom corner of the Catalog window. If you have saved a template, click on the Templates button also located on the left bottom corner of the Catalog windows. 2.6. Opening publication with template 1. Select a Presentation Type from the left 2. Click on one of the Designs Ministry of Labor and Version -1 Page 46 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  3. Customize your presentation by selecting a color scheme, font scheme, and layout Click on Create 2.7. Customize publication The best way to start a publication is to choose a pre-designed template right when you open Publisher. Options for changing the template colors, fonts, text, and graphics are available as soon as you choose a template. You’ll find Publisher templates on the Start page that appears when you open Publisher without first picking an existing file to open. You can also get to the Start page anytime by clicking File > New. To begin, click Featured to find individual templates, Built-In to find categories of templates such as flyers, brochures, or greeting cards, or use the search box to find online templates. For example, follow these steps to make a greeting card. 1. Next to Suggested searches, 2. Click Card. 3. Click a card design such as Thank you card (Purple Ribbon Design). 4. Click Create. 5. Replace the template text or graphics by right-clicking a text box or graphic and clicking Delete Text or Change Picture. 6. To keep customizing the card, use these options on the Page Design tab: To save your publication: 1. Save your publication by clicking on File, Save, from the menu. Ministry of Labor and Version -1 Page 47 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  2. Give your publication a file name and save it to the proper drive and directory. 2.8. Print a publication The main use of Publisher is to produce high-quality print publications. These may be printed on a desktop printer or sent out to a copy shop or commercial print shop. For information to help you choose between these options see Printing: Choose between desktop, copy shop, and commercial printing. To print your publication: 1. Print your flayer publication by clicking on File, Print from the menu 2. Choose other specific printing instructions from the Print dialog box 3. Click the Ok button. PRINT SETTING AND PRINT PREVIEW The new Back stage view for printing looks like this: Ministry of Labor and Version -1 Page 48 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Fig 4 print publication On the left are the print settings and on the right the preview pane. The settings on the left will affect the printed publication, while the setting right only affect your view of the publication. Ministry of Labor and Version -1 Page 49 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Fig 5 1. Print: Enter the number of copies of the print job you want to print and press Print to send the job to your printer. 2. Printer: In addition to selecting from a list of available printers, you can also add a new printer, access the Advanced Output Settings, and print to a file. 3. Settings: The settings section gives you control over: Pages: Allows you to select specific pages or page ranges to print. Print imposition: Here you can specify where on a sheet of paper your publication will print and how the pages of your publication will be laid-out on the sheets of paper. Ministry of Labor and Version -1 Page 50 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Paper size: Select the size and style of the sheets of paper you will use to print your publication. One sided/two sided printing: Choose whether to print on one or both sides of the paper, and which edge to use in flipping the paper. Color: If your printer supports color this control will allow you to choose color or gray scale printing. Save settings with publication: If selected this check box will save your Settings selections with this Publication. PRINT YOUR PUBLICATIONS 1. Click the File button to open the Back stage view. 2. Click Print to open the print settings page. You may have to wait a moment while Publisher connects to your printer. 3. In the Print section, set the number of copies to print in Copies of print job. 4. In the Printer section, make sure that the correct printer is selected. The preview window will display in black and white, regardless of whether your publication(s) includes color, unless you have selected a color printer. Ministry of Labor and Version -1 Page 51 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  5. In the Settings section: a. Make sure that the correct set of pages or sections is selected. b. Select the format for imposing your pages on the sheet. c. Set the paper size. d. Set whether to print on one side of the sheet of paper or both, and when printing on both sides whether to flip the sheet of paper on the long or short side. e. If your printer is capable of color printing, choose if you want to print color or gray scale. f. Click the Print button to send the publication to your printer. PRINTING MORE THAN ONE COPY OF A PUBLICATION 1. Click the File button to open the Back stage view. 2. Click Print to open the print settings page. You may have to wait a moment while Publisher connects to your printer. 3. In the Print section, set the number of copies to print in Copies of print job. 4. Click the Print button to send the publication to your printer. PRINT MULTIPLE COPIES OF EACH PAGE Ministry of Labor and Version -1 Page 52 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  If you are printing labels or business cards, the default option will be multiple copies per sheet, This will print more than one copy of each page of your publication, with each set of pages on separate sheets of paper. When you choose this option, the Layout Options button becomes available allowing you to adjust the margin guides to increase or decrease the number of copies of your publication that can fit on a single sheet of paper. For example, if your business card publication contains two pages each page contains a different business card and you select multiple copies per sheet and 10 copies, then a total of 20 copies 10 copies of each of the two different business cards will be printed on two sheets of paper, one sheet for each page. 1. Click the File button to open the Back stage view. 2. Click Print to open the print settings page. You may have to wait a moment while Publisher connects to your printer. 3. In the Settings section, select multiple copies per sheet and then select the number of copies. 4. Click the Print button to send the publication to your printer. NOTES If you click one page per sheet, your publication will be printed in the center of the sheet of paper. If you want to print one page of your publication per sheet at a specific position on the sheet, click multiple copies per sheet, click Layout Options, and then change your publication's position on the sheet by adjusting the row options, column options, and horizontal and vertical gap values under more print options. This option is available for publications with page sizes that are smaller than the paper sizes, such as Advertisements, Business Cards, and With Compliments Cards. With different information on each and you select multiple Pages per sheet and one copy, then all ten pages will print on the one sheet of paper. This option is available only when the publication page size is smaller than the sheet that the publication is set to print on. 1. Click the File button to open the Back stage view. 2. Click Print to open the print settings page. Ministry of Labor and Version -1 Page 53 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  You may have to wait a moment while Publisher connects to your printer. 3. In the Settings section, select multiple pages per sheet and then select the number of copies. 4. Click the Print button to send the publication to your printer. Self-Check Test#1 Self-check Test#1 Create a flayer using Publications by Wizard Create a flayer using Publications by Wizard and design 1. Crate Publications by Wizard tab. 2. Create the Flyers publication type in the Wizard window. 3. Create the Informational flayer type. 4. Change the Wizard window to change the design. 5. Change the color scheme to Tropics 6. Create the line that will put a placeholder on the flayer Ministry of Labor and Version -1 Page 54 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Unit Three: Prepare Electronic Presentation This learning guide is developed to provide you the necessary information regarding the following content coverage and topics: Concept and Terminologies of Electronic Presentation Opening Blank PowerPoint Explore the User Interface Creating, Saving, and Closing a Presentation Entering Text and Graphics Editing Text and Graphics This guide will also assist you to attain the learning outcomes stated in the cover page. Specifically, upon completion of this learning guide, you will be able to: Define concepts and terminologies of electronic presentation Open a blank power point Explore the user interface Create, save and close presentation Enter text and graphics Edit text and graphics 3.1. Concept and Terminologies of Microsoft Power point Electronic presentations are created with software such as PowerPoint, Freelance, Co-rel presentations, and Astound, are some of the common methods of presenting information for a variety of audience in business, government, and education. The main advantage of an Ministry of Labor and Version -1 Page 55 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Online presentation is that it has a lot of visual information. With the help of an online presentation, you can demonstrate all benefits of your product or service in a convenient and attractive form, using multimedia files and narrations. Microsoft's PowerPoint is "a software package designed to create electronic presentations consisting of a series of separate pages or slides. 3.2. Opening Blank Power Point The following steps are for opening /starting/ PowerPoint 2010 using the computers in the ITS Training Program computer labs. The steps for starting the program on other computers may vary. To start PowerPoint 2010: Click the Start button, click All Programs, click Microsoft Office, and select Microsoft PowerPoint 2010. The program window opens with a new blank presentation. 3.2.1. Exploring the User Interface (power point 2010) The PowerPoint 2010 program window is easy to navigate and simple to use (see Figure 1 and Table 1 for the main elements of the program window). It is designed to help you quickly find the commands that you need to complete a task. Ministry of Labor and Version -1 Page 56 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Element Description Title bar Displays the name of the presentation and the program. Minimize, Restore Used to control the program window. Use the Minimize button to hide the Down/Maximize, window. Use the Restore Down/Maximize button to adjust the size of the Ministry of Labor and Version -1 Page 57 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright and Close buttons window. Use the Close button to close the presentation or exit PowerPoint. Quick Access Contains frequently used commands that are independent of the tab Toolbar displayed on the Ribbon. Ribbon Contains all the commands related to managing presentations and working with presentation content. Overview pane Appears on the left side of the program window and has two tabs. Clicking the Slides tab displays small thumbnails of all the slides in the active presentation. Clicking the Outline tab shows all the text on the slides displayed as an outline. Slide pane Shows the current slide as it will appear in the presentation. Notes pane Appears below the Slide pane and provides a place for entering notes about the current slide (e.g., speaker notes). Status bar Displays information about the current presentation (e.g., slide number, theme name) and provides access to certain program functions. View Shortcuts Used to display the presentation in a variety of views, each suited to a Toolbar specific purpose. Zoom Level button and Used to change the magnification of the presentation. Zoom slider Table 2: Power point program windows elements 3.2.2. Creating, Saving, and Closing a Presentation When you start PowerPoint 2010 without opening a specific presentation, a new blank presentation containing one slide is displayed, Ministry of Labor and Version -1 Page 58 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  ready for you to enter your content. You can also create a new presentation while PowerPoint 2010 is running. To create a new presentation: 1. Click the File tab on the Ribbon. The Backstage view displays. 2. Click New in the left pane. The New tab displays (see Figure 4). 3. Under Available Templates and Themes, select Blank presentation. 4. Click the Create button in the right pane. A new blank presentation opens in a new window. 3.4. Entering Text and Graphics A new blank presentation includes one slide which is based on the Title Slide layout. The slide contains two placeholders, one formatted for a title and the other formatted for a subtitle (see Figure 5). The arrangement of placeholders on a slide is called a layout. There are several other slide layouts available in PowerPoint and each provides placeholders for inserting various types of content. When you click inside a placeholder, PowerPoint switches to edit mode; the placeholder appears with dashed borders with sizing handles (white circles and squares), a rotate handle (green circle), and the insertion point appears in the placeholder. When the insertion point reaches the end of the line, the text you are typing automatically moves to the next line. Pressing the Enter key starts a new line. If you type more text than will fit in a placeholder, PowerPoint reduces the size of the text so that all the text fits. Figure 9: Placeholder To enter text: Ministry of Labor and Version -1 1. In the Slide pane, click inside the Page 59 of 88 Skills Basic Computer Skill II September, 2022 placeholder in which you want to add text. Author/Copyright 2. Type the desired text. 3. Click anywhere outside the placeholder to deselect it. 3.4.1. To insert graphics 1. Select the slide where you want to insert an image. 2. On the Insert tab, select Pictures > This Device. 3. Browse to the picture you want to insert, select it, and then click Open. After the picture is on your slide, you can resize it and move it wherever you want. 3.4.2. Inserting Images Images can enhance a PowerPoint presentation. They can be used to depict an idea that may be difficult to describe or to make the presentation more visually appealing to your intended audience. Images that can be used in a presentation include clip art and pictures. Once you insert an image into a presentation, you can move it, resize it, crop or cut away portions of the image, or change its colors. NOTE: You can add images to a slide without an available content placeholder and regardless of the slide layout. 3.5.3. Inserting Clip Art One method of adding images to a presentation is to insert clip art. PowerPoint 2010 provides access to hundreds of license-free clip art which includes illustrations, photographs, movies, and sounds. If your computer has an Internet connection, you can also access the thousands of free clip art images available on the Office.com website. To find and insert clip art: Ministry of Labor and Version -1 Page 60 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Display the slide on which you want to place the clip art. On the Insert tab, in the Images group, click the Clip Art button Or, click the Clip Art button in the content placeholder (see Figure 21). The Clip Art 3.4.3. Editing Text and Graphics Copying and Moving Text When editing a presentation, you may want to move or copy text within the same presentation or between presentations. If you want to duplicate text in another location, you can copy the text rather than retype it. When you move text, the text is removed from its original location and placed into the new location. Cut or copied text is placed on the Clipboard where it is saved until you paste it to a new location. To copy text: 1. Select the text that you want to copy. 2. On the Home tab, in the Clipboard group, click the Copy button press Ctrl+C. 3. Position the insertion point where you Ministry of Labor and Version -1 want to paste the text. Page 61 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright 4. On the Home tab, in the Clipboard group, click the Paste button To move text: 1. Select the text that you want to move. 2. On the Home tab, in the Clipboard group, click the Cut button press Ctrl+X. 3. Position the insertion point where you want to paste the text. 4. On the Home tab, in the Clipboard group, click the Paste button (see Figure 6). Or,. Or, press Ctrl+V. (see Figure 6). Or,. Or, press Ctrl+V. Using Undo and Redo The Undo command allows you to reverse the results of the previous command or action. Once the Undo command is used, the Redo command becomes available. The Redo command allows you to restore the results of the command or action you reversed with the Undo command. To undo the previous command or action: 1. Click the Undo button on the Quick Access toolbar. Or, press Ctrl+Z. To redo the undone command or action: Ministry of Labor and Version -1 1. Click the Redo button on the Page 62 of 88 Skills Basic Computer Skill II September, 2022 Quick Access toolbar. Or, press Ctrl+Y. Author/Copyright Adding and Deleting Slides By default, a slide added after the Title Slide layout has the Title and Content layout. Thereafter, each added slide has the layout of the preceding slide. If you want to add a slide with a different layout, you can select the desired layout from the New Slide gallery. If a slide is no longer needed, you can easily delete it from the presentation. To add a slide without selecting the layout first: 1. On the Home tab, in the Slides group, click the New Slide button. To add a slide with a specific layout: 1. On the Home tab, in the Slides group, click the arrow on the New Slide button and select the desired layout from the gallery ( see Figure 7). Ministry of Labor and Version -1 Figure 7 – New Slide Gallery Page 63 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  To delete a slide: 1. In the Overview pane, on the Slides tab, select the slide that you want to delete. 2. Press the Delete key. NOTE: You can also right-click the slide on the Slides tab of the Overview pane and select Delete Slide from the shortcut menu. Changing a Slide's Layout As you create a presentation, you may find it useful to change the layout of an existing slide. When you change to a different layout, you change the type and/or positioning of the placeholders on it. If the previous placeholders had content in them, that content shifts to a new location on the slide to reflect the different positioning for that placeholder type. If the new layout does not contain a placeholder appropriate for that content, the content remains on the slide, but becomes orphaned (a free-floating object outside of the layout). Ministry of Labor and Version -1 To change a slide’s layout: Page 64 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright 1. In the Slide pane, display the slide that you want to apply a new layout to. 2. On the Home tab, in the Slides group, click the Layout button and select the desired layout from the gallery (see Figure 8). Moving, Resizing, and Rotating Place holders The size and position of the placeholders on a slide are dictated by the slide’s design. You can move, resize, and rotate placeholders to suit your needs. When you click inside a placeholder, the placeholder is surrounded by a dashed border. You can then enter new text or edit existing text (see Figure 9). Clicking the dashed border changes it to a solid border. You can then manipulate the placeholder as a unit (see Figure 10). To move a placeholder: 1. In the Slide pane, position the mouse pointer over the placeholder’s border. The pointer changes to a four-headed arrow. 2. Drag the placeholder to the desired location. 3. Click anywhere outside the placeholder to deselect it. To resize a placeholder: 1. In the Slide pane, click the placeholder that you want to resize. 2. Drag any sizing handle (white circle or square) as desired to increase or decrease the size of the placeholder. 3. Click anywhere outside the placeholder Ministry of Labor and Version -1 to deselect it. Page 65 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  To rotate a placeholder: 1. In the Slide pane, click the placeholder that you want to rotate. 2. Drag the rotate handle (green circle) in the desired direction. 3. Click anywhere outside the placeholder to deselect it. Edit Graphics Moving an Image You can enhance a presentation by placing images in the best possible location on each slide. To move an image: 1. Position the mouse pointer over the image. A four-headed arrow appears next to the pointer. 2. Drag the image to the desired location on the slide. Resizing an Image You can resize an image to better fit the layout of a slide. Images can easily be resized by dragging one or more sizing handles. You can also resize an image by entering specific measurements in the height and width fields in the Size group on the Format contextual tab. To resize an image using sizing handles: Ministry of Labor and Version -1 1. Select the image that you want to resize. Sizing handles appear around the image. Page 66 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  2. Drag any sizing handle to increase or decrease the size of the image. NOTE: Dragging a corner handle shrinks or grows the image proportionally. To resize an image using specific measurements: 1. Select the image that you want to resize. The Format contextual tab appears. 2. On the Format contextual tab, in the Size group, enter the desired height and width (in inches) in the Height and Width figure 24-size, group Formaton contextual tab boxes (see Figure 24). 3.5. Slide Design and Animation Slide Design Changes to the design of you presentation can be made by opening the Design tab on the ribbon. This gives you access to a variety of preset themes, color combinations, fonts and effects. Use the drop-down menus to see all the possible choices and holding the mouse pointer over the example to preview the selection. Each theme can be modified with an assortment of color combinations, fonts and effects. Use a slide design that is appropriate for your topic and has enough contrast between the text and background to make it easy to read from the back of the room. Ministry of Labor and Version -1 Page 67 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Figure 9: Design Tab 3.5.1. Slide Transitions Transitions are the effects between slides and are located in the Animations tab in the ribbon. The transitions can be previewed by holding the mouse pointer over the transition icon in the drop-down list of transitions. The transition can be applied to the selected slide or to all slides in the presentation. It’s best to use simple transitions, like a fade or wipe, as more complicated transitions can distract your audience from your message. Figure 10: Animation Tab Animation Ministry of Labor and Version -1 Add transitions between slides Page 68 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Slide transitions are the animation-like effects that occur in Slide Show view when you move from one slide to the next. You can control the speed of each slide transition effect, and you can also add sound. Microsoft Office PowerPoint 2007 includes many different types of slide transitions, including (but not limited to) the following: 1. No transition 2. Blinds Vertical 3. Blinds Horizontal 4. Box In 5. Box Out 6. Checkerboard Across 7. Checkerboard Down 8. Comb Horizontal 9. Comb Vertical To see more transition effects, in the Quick Styles list, click the More button , as shown in the diagram above.. Self Check Test Self Check Test #3 Create Electronic Presentation 1. Prepare a document about Computer System. Ministry of Labor and Version -1 2. Prepare a document about database Page 69 of 88 Skills Basic Computer Skill II design principles. September, 2022 Author/Copyright  3. Support your document with pictures. 4. Prepare power point for the document you prepared. 5. Apply all the necessary format, design and animation for the power point you prepared Ministry of Labor and Version -1 Page 70 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Unit four: Accessing internet This unit is developed to provide you the necessary information regarding the following content coverage and topics: Accessing internet Creating Email account Searching online information Using online information Checking and downloading information This unit will also assist you to attain the learning outcomes stated in the cover page. Specifically, upon completion of this learning module, you will be able to: Identifying different sites Accessing online information Checking and downloading online information Ministry of Labor and Version -1 Page 71 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  4.1. Access online information As online technology rapidly develops, the criteria for evaluating these sources develops as well. Online sources are so new that their status as accurate sources is not fully established; therefore, you should verify online sources before you invest time in browsing the web or assessing the credibility of sources you find there. 4.1.1. Criteria for accessing online Sources Authorship Is the author identifiable? Never use a source whose author you cannot identify. Is the author a professional in the field? If the author's name is unfamiliar, is the site linked to an established authority on the subject? Has this author been referred to favorably by respected professionals in the field or by a respectable Website? Does the document contain links to these professionals or to the respected Web sites? Are there also links from these sources that go back to the site you're assessing? Does the author include his/her e-mail address or a mail-to: so that you can contact the author directly from the site? Does the author include a way to contact him/her other than e-mail? Does the Web site belong to an individual, or is it part of a site maintained by an organization, academic institution, or other All the above questions should be get an answer. Ministry of Labor and Version -1 Page 72 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright Publishing Body/Publisher Is the type of material appropriate? Professional sources from the Web include professional home pages or online professional journals. Non-professional sources include personal home pages or online general audience magazines. Is the site sponsored by a respected organization? Does the site include an official insignia of the organization sponsoring it? Are you able to contact the webmaster or sponsoring organization from within the site? Perspectives Can you identify the goals of the site? Are these goals clearly stated? Does the focus of the text relate to the graphics in the site? Is the perspective appropriate? Are all sides of the issue fairly presented? Coverage Is there an in-depth understanding of the related issues that shows the author's familiarity with the subject? Does the site include internal links that provide quick reference to the main sections of the document? Internal links show the author has given attention to the potential needs and questions a reader might have. Does the site acknowledge other sources within the text itself? Are there also links to these sources if they exist online? Are links provided to the sources that are available online? Are the appropriate theories, schools of thought, or techniques used in the discussion of the material standard in the field? Ministry of Labor and Version -1 Page 73 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  If the material is based on a new theory, is coverage of the new approach detailed? Does the site cover the advantages and disadvantages of the method compared to other current methods in the field? Accuracy or verifiability Is the material comparable to related sources? The home page of an authority in the field will provide a good base of sources to use as a comparison for other sources. Is the methodology given so that the author's work can be replicated or evaluated? Does the source include a bibliography and/or citations that can be used for comparing or verifying data and other information? Are there links from the citations or the bibliography to the original documents? Is the information in the text poorly presented compared to the graphics? Do many mechanical errors (e.g., grammatical errors, typos, etc.) appear in the text? Errors suggest the author might be careless in presenting information. Did you discover the site via a search engine? If so, how does the search engine you used look for information and, if relevant, rate the sites it retrieves? 4.2. HOW TO USE E-MAIL E-mail (short for electronic mail) is a fast and convenient way to communicate with others. You can use e-mail to: Ministry of Labor and Version -1 Page 74 of 88 Skills Basic Computer Skill II September, 2022 Author/Copyright  Send and receive messages. You can send an e-mail message to any person with an e-mail address. The message arrives in the recipient's email inbox within seconds or minutes despite whether he or she is your next-door neighbor or lives halfway around the world. You can receive messages from anyone who knows your e-mail address, and then read and reply to those messages. In addition to typical te