Computer Components (4) The System Case he motherboard (and other internal T components) is housed within a protective case, usually made of metal and plastic and often referred to as the "box." he design of the case can affect how T many expansion cards and components can be added to the computer ome cases are designed to be easy to S open and access to make maintenance of the computer simpler ©Digital Bridge Institute, Abuja Page 9
Starting Windows ... (7) 6. Using Windows Explorer Windows Explorer is a tool used to browse the files and folders on the computer. It opens a 2-pane window. Right click on the Start Icon select Explore It can be evoked by a swift combination of [x] and E keys 8. Using the Run Command The Run Command is a very handy tool in running applications Click on the Start Icon Run, and type name of a program E.g., mspaint (Microsoft Paint), calc (calculator), winword, powerpnt, excel, etc ©Digital Bridge Institute, Abuja Page 30
Objectives Introduction & Basic Definitions Starting Up Microsoft Word Screen Layout Menu Microsoft Office Button Quick Access Toolbar Ribbon Mini Toolbar Working with Documents Opening an Existing Document Saving a Document Document Views Using the Zoom Option Closing a Document Editing a Document Formatting Text ©Digital Bridge Institute, Abuja Formatting Paragraphs Setting Tab stops Styles Adding Tables Graphics Proofreading a Document Page Formatting Page Formatting Table of Contents Lists References and Citations Track Changes Mail Merge Managing Page Layout Printing Documents Page 33
Document Views There are many ways to view a document in Word. Print Layout: This is a view of the document, as it would appear when printed. It includes all tables, text, graphics, and images. Full Screen Reading: This is a full view length view of a document. Good for viewing two pages at a time. Web Layout: This is a view of the document, as it would appear in a web browser. Outline: This is an outline form of the document in the form of bullets. Draft: This view does not display pictures or layouts, just text. To view a document in different forms, click the document views shortcuts at the bottom of the screen or: Click the View Tab on the Ribbon Click on the appropriate document view. ©Digital Bridge Institute, Abuja Page 47
Formatting Text (2) Change Font Typeface and Size To change the font typeface: Click the arrow next to the font name and choose a font. Remember that you can preview how the new font will look by highlighting the text, and hovering over the new font typeface. ©Digital Bridge Institute, Abuja Page 56
Table of Contents (4) Create a Table of Contents To create the table of contents: Put your cursor in the document where you want the Table of Contents Click the References Tab Click the Table of Contents button ©Digital Bridge Institute, Abuja Page 107
Track Changes (3) Document Views There are four ways to view a document after you have tracked changes: Final Showing Markup: This shows the document with the changes displayed Final: This shows the changed document, without the changes displayed Original Showing Markup: The original document with the changes displayed Original: The original document without any changes. To change the view, click the appropriate choice in the Tracking Group of the Review Tab on the Ribbon. To change the view, click the appropriate choice in the Tracking Group of the Review Tab on the Ribbon. ©Digital Bridge Institute, Abuja Page 121
Objectives Introduction to Excel Definition of a Spreadsheet Advantages of a Spreadsheet Components of Excel Window Create a new workbook Opening, creating, and saving a workbook Enter and Edit data in a worksheet Edit and format cells, rows and columns Format numbers and apply style Link data in the worksheet Refer to cells in a formula Importing and exporting data Creating a web page Placing interactive data on the web View different sections of a worksheet Insert a picture Preview and print workbook/sheet Creating and modifying graphics (charts) Set a validation rule to enter data in a worksheet Set a validation rule to enter data in a worksheet Import data Apply number formats Apply a condition for formatting Create names for ranges of cells Apply the names in formulas Locate the required data Sort data Filter data Calculate subtotals Audit a worksheet Secure the contents of a workbook Create a macro Execute a macro Change the print settings of a workbook Print a workbook Perform what-if analysis Create dynamic tables and charts to analyze data Publish dynamic tables and charts in an interactive Web page Page 141
Conditional Formatting (4) Manage conditional formatting One can create, edit, delete, and view all conditional formatting rules in the workbook by using the Conditional Formatting Rules Manager dialog box. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules. Against Show Formatting rule for, choose the worksheet whose rules you want to manipulate. All relevant rules for the worksheet are lists. These rules are evaluated in order of precedence by how they are listed in this dialog box ©Digital Bridge Institute, Abuja Page 179 Charts Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more. To view the charts available click the Insert Tab on the Ribbon. Create a Chart To create a chart: Select the cells that contain the data you want to use in the chart Click the Insert tab on the Ribbon Click the type of Chart you want to create ©Digital Bridge Institute, Abuja Page 180
Page Properties and Printing (3) Set Page Margins To set the page margins: Click the Margins button on the Page Layout tab Select one of the give choices, or Click Custom Margins Complete the boxes to set margins Click Ok ©Digital Bridge Institute, Abuja Page 201
Objectives Components of PowerPoint Basic Concepts & Definition Working with Presentation Views in PowerPoint File Operations Opening an Existing Presentation Opening Multiple Presentations Creating New Presentations Using the Blank Presentation Option Using Templates Saving a Presentation Closing a Presentation Modify text ©Digital Bridge Institute, Abuja Modify the Appearance of Text Modify the Slide Structure Modify the Layout of a Slide Save a Presentation Apply Templates Add tables and Comments to a Presentation Insert a Picture Insert a Document Animate Text and Pictures in a Presentation Add Transition Effects to Slides in a Presentation Deliver a Presentation Print a Presentation Page 208
Adding Content (5) Adding Audio Audio clips can be added to the presentation. o add an audio clip: T Click the Audio button on the Insert tab Choose Sound from File, Sound from Clip Organizer, Play CD Audio Track, or Record Sound To edit the audio options: Click the audio icon Click the Format tab ©Digital Bridge Institute, Abuja Page 237
Applications on the Internet (2) 2. Search Engines A search engine is a program that allows you to search for a particular set of words specified by you, on the Internet A user interface is provided where a user can enter the word or the phrase that has to be searched The search engine tries to locate the keyword in a large data source and returns the result of the search Google , Yahoo, MSN and Altavista are commonly used search engines ©Digital Bridge Institute, Abuja Page 275
Working with the Internet Explorer (1) To open the Internet Explorer, perform the following steps: 1. Select the Programs Internet Explorer command. The Internet Explorer window is displayed 2. In the Address bar, specify the address or URL of the Web site that you want to visit When specifying the Web address, you don’t need to specify the protocol, such as http or ftp. The protocol appears automatically 5. Click the Go button or press the Enter key. The home page of the Web site appears. The figure in the next slide is displays (the home page of the MSN site) ©Digital Bridge Institute, Abuja Page 285
Implementing Security (2) Once you start using the Internet for accessing information, you connect to different computers on the network Security on the Web refers to techniques for ensuring that data in transit is safe from unauthorized access Security measures involve Data encryption: Involves the translation of data into a form that is illegible without a deciphering mechanism Passwords: Is a secret word or phrase that gives authorized users access to a particular program or system A digital certificate is used to identify the person sending the message over the network A Certificate Authority (CA) issues the digital certificate. The digital certificate contains the applicant's public key and a variety of other identification information The applicant uses the public key to encrypt the message Recipient of an encrypted message uses the CA's public key to decode the digital certificate attached to the message, and verifies it as issued by the CA ©Digital Bridge Institute, Abuja Page 307