Lesson 1: Introduction to Computer
Lesson Objectives
On completion of this lesson, you will understand
· The Components of Computer and its Function
· The types and classification of computers
Computer – An Introduction
A computer is defined as an electronic device that accepts input, processes it as per the given instruction and produce meaningful output. The term computer is used to describe a device which is a combination of electronic and electro mechanical device.
Date and Information
Data refers to facts that are gathered and fed to the computer. A computer stores, retrieves, sends, receives, analyses and synthesizes data to produce information. A computer organizes data from many sources and turns it into information which can be applied in making decisions and solving problems.
Organisation of Computer
A general purpose computer consists of four major, interrelated subsystems namely
o
o Memory
o Processing Unit
o Output
Computer Hardware
The physical component comprises the hardware. It is term that describes the electrical, electronic, mechanical and peripheral devices.
Hardware is classified into
o Input Device
o Output Device
o System Unit
Software
Set of instruction is called Programs. And set of Programs is called Software, which is written for common object. Example: MS Word, Tally
Software is divided into two basic categories:
· System Software/ Operating System
Operating system controls the operation and mangers the resources of a computer. This is the most important program that runs on a computer which helps in running other programs. It performs task such as recognizing input, sending outputs, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. It also takes care of the security feature of the computer.
Example: Windows 95, Windows XP, Windows Vista, Unix, Linux.
· Application Software
Application software is set of programs create to perform particular tasks. This is the area where the user actually works.
Example: MS Word, MS Excel, Tally.ERP9, Photoshop.
Types and Classification of Computers
Personal Computer
They are desktop computers which are designed for an individual’s use. They come in all Shapes and Size from tiny PDA’s (Personal Digital Assistant) to big PC (Personal Computer). They are designed is such a way that individuals can accomplish their work more effectively.
Mini Computers
These are systems that can be used by more than one user at a time and are in a range between the Main frame and Personal Computer.
Main Frame Computer
Mainframe Computer are multi user systems designed to handle data of large organisations for critical application and bulk data processing. Main Frames allow many people to work on the same data at the same time.
Super Computer
Super Computers are customized high speed computer built according to the requirement of the user. These computers are designed and manufactured by companies like Cray, IBM and Hewlett-Packard.
Points to Remember
· A Computer Consists of two basic components, Hardware and Software.
· A simple computer system consists of three major, interrelated sub-systems, namely, Input Devices, System Unit, Output Devices.
· Software is often divided into two categories, System software and Application Software.
Lesson 2: Introduction to Microsoft Word 2007
Lesson Objectives
On completion of this lesson, you will learn
· Explore the Word 2007 environment
· Create and format Word Document
· Add Picture and Object
· Print document
Introduction
Office tools are intended to automate and simplify the activities in an organization. Therefore, it refers to all software programs which make it possible to meet the needs of an office.
Usually office tools include software for word processing, accounting, presentations, mail management, activity scheduler, etc. Word processing handles desktop publishing , which includes creation of newsletters, brochures, etc. that combine text, picture, and so on.
Popular office tools are Microsoft Office, Sun Start Office, and Apple Works. Etc.
Microsoft Word
Microsoft Word, commonly known as MS Word, is an application developed by Microsoft. MS Word is available as part of Microsoft office package. MS Word is most widely used Word Processing application. Word Processors replaced the type writers to a large extent since their entry in the world of personal computers.
Word Processor is a software, which helps you to prepare documents. In general, preparing a document requires typing, editing and formatting, on your computer. Creation of documents with the help of a Word Processor is called Word Processing.
A typical Word Processor allows you to do the following in a document.
· Typing: To Write/compose a document
· Editing : To Organize/edit and already composed document
· Formatting: to set/arrange the contents of a document in a required manner
· Inserting Images and diagrams: To insert pictures/ diagrams in a document
· Cross-referencing: to link/refer to related elements internally or externally
· Mail Merging: To personalize a mass mailer
Working with a document
To create document using MS Word, you need to open MS Word.
· Choose Start > All Programs > Microsoft Office > Microsoft Word 2007
The MS Word Window is as shown
The components of all the Windows are similar
Title Bar
The name of the document is displayed on the Title Bar, for example Document 1- Microsoft Word. Where Document is the name of the document. The Title bar also contains the Quick Access Toolbar (QAT)
Quick Access Toolbar
The Quick Access Toolbar is a Customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed. You can add buttons that represent command to the Quick Access Tool Bar. For example, when you click on the MS Word Icon on the Upper-left corner of the MS Word Window a popup menu appears which allows the user to perform Move, Size, Minimize, Restore, Maximize and Close.
Tabs
Tabs displays the additional tools and text labels provided in MS Word. The Tabs assist you in giving instructions to the software (here MS Word). The Tabs available in MS Word are File, Home, Page Layout, References, Mailings, Review, view and Acrobat. Click on any Tab Option to open a Ribbon. Each Tab exposes a different ribbon. The tabs can be accessed via the mouse or hot keys.
Ribbons
The ribbon is the area above the document Workspace, as shown; the ribbon is just the area below the tabs for Home, Insert, and so on. The row containing these tabs controls which ribbon is displayed. For example, Home ribbon view shows styles from the style gallery, as well as additional tool and text labels in the Clipboard and Editing groups.
Note:
· You can hide/show the Ribbons using ctrl+F1.
· To turn the ribbon off using the mouse, double-click the current tab: click any tab to turn it back on temporarily.
Ruler
The Ruler is used to apply quick formatting like changing the default Left, Right, Top and Bottom margins of your document. Ruler is also used to define/change Tab setting.
Scroll Bar
Scroll Bar helps you move vertically/horizontally across a document.
Status Bar
Status Bar displays the details like page number, Current section number, total number of page, inches from top of the page, line number, column number and so on.
Document view
In MS Word, you can choose to display your document in any five document views, namely, Print Layout view, Full Screen Reading view, Web Layout view, outline view and Draft view. Each view can be selected from the view option on the Tab section. Alternatively, you can click the required document view button on the MS Word Window.
Note: The number of document views available may vary according to the version of MS Word installed on your computer, For example, MS Word 2010 Provides Five views.
Application Window and document Window of MS word
In the given MS Window, you can notice that two windows are displayed one within the other. Thedocument Window is displayed within the Application Window. The Document Window is used to prepare document. You can open any number of document Windows within an application Window of MS Word. You can close each document by clicking Close Window Displayed at the top right corner of the document window without closing the Application Window.
Close Window: To close the document window.
Minimise, Maximise and close Button (Application Window); The Function of these buttons are in the case of any application window and are explained in chapter2.
3.1.2 Creating a new file/document
To create a new file,
· Click File > New
Note; Click the File tab in the upper left-hand corner of Word’s Window.
· Select Blank document from the Available Templates
The new document is displayed with Document1 as the name of the document on the title bar. You can also notice that there is a banking vertical bar (called cursor) on the new file created. Cursor indicates the location where you can enter the text in the document.
Typing entering text in a file/document
To enter text in a document, you just need to start typing on your keyboard. As you type, you can see the characters being displayed from the cursor in your document. In MS Word, when you reach the end of a line, you will be automatically taken to a new line. But start a new paragraph you need to press EnterKey.
Selecting text
Selecting a portion of the text in your document is very essential to perform operation like formatting, copying, pasting and so on. On selecting a text, it gets highlighted. In general, you can any text by clicking at one of the text and dragging the mouse pointer till the point you want to select.
Alternatively, keep the cursor at one end of the text to be selected and press Shift+any of the arrow keys (Left/Right/Top/Bottom) to select the required text.
In addition to these, you may use the following.
· Word: Double click on the word
· Line: Keep the cursor at the beginning/end of the line and press Shift+End/Home respectively
· Sentence: Press Ctrl+cllck in sentence
· Paragraph: Triple click in paragraph
· Document: Press ctrl+A
To deselected a text, i.e., to come out of the selection mode of a text, you need to click anywhere.
Deleting text
If you enter a wrong character in your document, you can delete/erase it using the Delete key on the keyboard. The Delete key deletes character/ extra space/ text to the right of the cursor. To delete a text, select the same and press Delete key. Alternatively, you can use Backspace key to delete character/extra space/text to left of the cursor.
Copying and pasting text
In case you want to duplicate a portion of a document, you may copy that. Microsoft Word allows you can copy text from one document and paste it anywhere else in the same or a different document.
To copy a text,
1. Select the text to be copied using any of the selection methods
2. Choose Home tab >Copy
To paste a text,
1. Place the cursor at the location where you want to paste the text
2. Click Home tab > paste
There are alternate methods to perform copy and paste text in a document.
Alternate Methods to copy and paste a text are given:
Methods 1:
1. Select the text to be copied using any one of the selection methods
2. Press Ctrl+C
3. Place the cursor at the location where you want paste the text
4. Press Ctrl+V
Methods 2:
1. Select the text to be copied using any one of the selection methods
2. Right Click on the selected text to display the popup list
3. Select Copy from the popup list
4. Place the cursor at the location where you want to paste the text
5. Right click to display the popup list
6. Select the paste from the popup list
Methods 3:
1. Select the text to be copied using any one of the selection methods
2. Select the copy button on the Home Ribbon
3. Place the cursor at the location where you want to paste the text
4. Select the paste button on the Home Ribbon
Moving text
In case a portion of a document to be repositioned, you may move the same.
1. Select the text to be copied using any one of the selection methods
2. Click Home > Cut
3. Place the cursor at the location where you want to paste the text
4. Paste the text using any of the methods mentioned already
Note: When you copy text from one place to another, it duplicates the text retaining the same at the source location. On the other hand, Moving text removes the same source location and places it the new location.
3.1.4 Saving a file/document
The file you just created can be saved using two commands, namely, Save and Save As from the file tab.
To save a file for the first time.
1. Choose File >Save As
The Save As dialog box is displayed as shown.
· Select the folder where you want to save the document in the Navigational Pane
· Type the name you want to give the document in the file name field
The file is to be saved as the type Word document (*.docx), which is selected by default.
· Click Save
In the case of save command, the Save As dialog box is displayed only when you are saving a file for the first time.
The command Save. When you want to save a copy of the current document in a different folder/disk or with a different name, you can use Save As. The Save As command/option always display the Save As dialog box, where you can choose the name of the file and the disk as per requirement.
When you save a file using the Save As command, the newly saved copy becomes the current/active file.
Note: It is recommended to save the file often while working on a file to avoid any loss of your work.
3.1.5 Closing a file/document
To close MS Word,
· Choose File tab >Close
Another method to close a file is to click the Close button on the Title Bar. If you have not changes made, before closing a file, you will get a dialog box asking whether you want to save the changes made to the document.
3.1.6 Opening an existing file/document
To open a file,
· Choose File tab > Open the Open dialog box is displayed as shown
· Select the folder where the file you want to open is saved, in the Navigational Pane
· Select the required file from the opened folder or type in the name of the file in the file name field
· Click Open
3.1.7 Formatting text
Microsoft Word allows you to format the text in a document. You can choose formats for the document according to your requirement. In general, formatting is used in document to make it organized and more presentable.
Word has four levels of formatting is accessible from the Home ribbon’s Font group.
Before you start formatting your document, make sure that the Home Ribbon is selected in your document. The Home Ribbon contains the buttons for various frequently used formatting tools.
To display the Home Ribbon,
· Click Home tab
The commonly used formatting features of MS Word are explained hereunder.
Capitalize: To capitalize individual letters/text, unable Caps Lock while typing the same. Alternatively, press Shift key while typing the letter/text.
Bold/Italicise/Underline: You can bold/italicise/underline a text in more than one ways.
Methods: 1
· Select the text that you want to bold
· Open the Font Dialog box (Ctrl+d or Ctrl+Shift+f, of click the font dialog launcher)
· In this dialog box, Font tab is selected by default
· Select Bold under Font Style
· Click OK to accept the selection and close the dialog box
Similarly, to italicise, select Italic under Font style and to underline, select the required pattern of the line in the Underline style.
Methods: 2
· Select the text that you want to bold
· Click Bold button on the Font Group of Home Ribbon
Note: After making a text bold, if you want to remove the formatting, click boldbutton again with highlighted.
Similarly, to Italicise/Underline, select Italic/Underline button on the Home Ribbon respectively.
Methods: 3
· Select the text that you want to bold
· Press Ctrl+B on your keyboard
Note: After making a text bold using this method, if you want remove the formatting, press Ctrl+B again with highlighted.
Similarly, to italicise or Underline, Press Ctrl+l or Ctrl+U respectively on your keyboard.
Fonts/Font Size/Font Color: Different font, Sizes and colors are used in document to emphasise text or improve readability. You can apply different fonts/font sizes/font colour to a text in MS Word. Font is nothing but the family of the typesetting that you use for a text in a document. MS Word provides a wide range of fonts/font sizes/font colors.
To apply font/font sizes /font colors to a text
1. Select the text to which you want to apply a specific font/ font sizes/ font colors
2. Open the Font dialog box (Ctrl+D or Ctrl+Shift+F, or Click the Font Dialog launcher)
3. Select the required font type, font size and font color in the fields Font, Sizes And Font Color respectively
4. You can see the changes that occur to the selected text in the Previewwindow in the dialog box
5. Click OK to accept the selection and close the dialog box
You can also apply font/font sizes/font color to a highlighted text by selection the required font/font sizes/font color on the Font Group of Home Ribbon.
There are six ways of applying various kinds of character formatting:
· Using the font group on the Home ribbon
· Using the font dialog box (Ctrl+D or Ctrl+Shift+F, or click the font dialog launcher)
· Using the mini toolbar (hover the mouse over selected text)
· Using shortcut keys
· Using the Font group or components placed on the Quick Access Toolbar (QAT)
· Using the language tool on the status bar
Bullets and Numbering: If you want to list a set of items, which does not follow a hierarchy, use Bullets. To list a set of steps, which follow a sequence, useNumbered list.
Ms Word provides different bulleting and numbering styles to list items in a document.
To apply bullets/Numbering,
1. Select the items for which you want to remove bullets/numbering
2. Click the Numbering or Bullets tool in the Home Ribbon
3. Select None.
Alignment: To improve the appearance of paragraph in terms of the left and right margins, paragraph alignment can be used. You can align the contain in a document using this feature. MS Word provides four types of alignment. The alignments available are:
· Left: The contain are aligned to the left margin of the document. To apply left alignment, select the Align Left button on the Formatting Toolbar
· Right: The contents are aligned to the right margin of the document. To apply right alignment, select the Align Right button on the formatting toolbar
· Centered: The contains are aligned between the left and right margin of the document. To apply centered alignment, select the Center button on the Formatting Toolbar
· Justified: The contents are aligned to both the left and right margins. To apply justified alignment, select the justify on the Formatting Toolbar
The Paragraph sections in the Home and page Layout ribbons contain a number of paragraph-formatting controls.
To apply any of the alignment to a text,
· Select the text you want to apply alignment
· Display the Paragraph dialog box by clicking the launcher in the lower right corner of the Home or Page Layout ribbon’s Paragraph groups
· The Paragraph dialog box is displayed
· Select the Indent and Spacing tab
· Select the required alignment type in the Alignment field
· Click OK to accept the selection and apply the selected alignment to the text
To apply indentation to a text,
1. Select the text you want to indent
2. Display the paragraph dialog box by clicking the launcher in the lower right corner of the Home or Page Layout ribbon’s Paragraph groups
3. Select the indents and Spacing tab
4. Select the required left/right inches in the Left/Right field under Indentation
5. Click OK to accept the selection and apply the selected indentation to the text
Left indentation sets the space from the left margin of your document, while the right indentation sets the space from the right margin. You can increase the indentation from the left margin of the document by clicking Increase Indent button on the Formatting Toolbar. Use Decrease Indent button on the Formatting Toolbar to decrease the indent which is already applied.
Line Spacing: Line spacing is used in long running text to provide more white space to improve the readability. Line spacing in MS Word allows you to choose the space between lines within a paragraph. You can either select from the default line spacing provided or set the spacing as per your requirements.
To set line spacing in a paragraph,
1. Select the paragraph you want to apply line spacing
2. Display the Paragraph dialog box by clicking the launcher in the lower right corner of the Home or Page Layout ribbon’s Paragraph groups
3. Select the indents and spacing tab
4. Select required spacing in the Line spacing field
5. Set the appropriate value in the At field, if you have selected At least/Exactly/Multiple as the line spacing
6. Click OK to accept the selection and apply the selected line spacing to the paragraph
Undo/Redo: To ignore/remove the last changes made you can use Undo. That is, if you want to restore the document to any of the previous forms, perform Undo. You can either click the Undo button on the Home Ribbon. You need to keep clicking the button until you reach the required form. Alternatively, press Ctrl+Z repeatedly as required.
After performing Undo, if you want to reapply the removed changes, click Redo button on the Home Ribbon.
3.1.8 Printing a file/document
You can print document using Print option. Document can be printed as a whole or certain pages can be printed. Also, you can specify the number of copies to be printed.
To print a document,
· Choose File tab > Print
· Click OK
Alternatively, click the Print button on the Quick Access Toolbar or press Ctrl+P on your keyboard to print a document
Before printing the document, you can see the layout of the document by selecting File tab > Print. This enables you to adjust the layout, it required, before printing.
3.1.9 Creating Tables
Tables are used in a document to arrange details into columns and rows. You can specify the number of the rows and columns as per requirement.
To create a Table,
· Place the cursor at the location where you want to create a table
·
The Insert Table dialog box is displayed as shown.
· Select the required number of columns and rows in the Number of columns and Number of rows fields respectively. Here, the number of columns and rows selected are four and three respectively
· Select Auto in the Fixed columns width field. You can also enter the desired column width, if required
· Click OK
The Table with specified columns and rows is displayed as shown.
Lesson 3: Introduction to Microsoft Excel 2007
Lesson Objectives
On completion of this lesson, you will learn
· Explore the Excel 2007 environment
· Perform basic operations in Excel 2007
· Perform operations on data
· Modify a worksheet
· Use formulas and functions
· Print worksheets
Introduction:
· Microsoft Excel is an example of a spreadsheet program that will maintain records for you relating to finances, products, activities, events and services. It allows you to enter, organize, compare and print data including graphs.
· Spreadsheets are saved in documents called workbooks and each workbook is comprised of individual worksheets or sheets.
· Excel will also allow you to print detailed reports, charts and graphs.
Parts of Excel Window
1. Office Button: The Office button provides a list of buttons that allow you to perform common tasks (create a new spreadsheet, open an existing spreadsheet, save, save as, print, etc.). It also provides you with a list of your most recent documents, Excel options and an Exit button.
2. Quick Access Toolbar: The Quick Access toolbar also contains buttons to activate common tasks or functions such as save, undo and redo. There are other tasks that can be added to this toolbar such as open an existing presentation, spell & grammar check, print preview, etc. Click on the down arrow next to the toolbar to add or remove tasks.
3. Title Bar: This displays the name of the program and the spreadsheet file name.
4. Ribbon: The Ribbon in Excel 2007 replaces the menus and toolbars that were originally found in Excel 2003. Tasks are grouped together in a logical way to assist you with your formatting needs. You will notice tabs across the top that define each section. Once you click on a different tab, new commands appear and the tasks are further arranged into more detailed groups. The name for each group is located at the bottom of that section. The ribbon may be minimized and maximized.
5. Cell: A cell is the most basic part of an Excel document. A cell is created at the intersection of a row and a column. The cell that is currently open and ready for editing is called the active cell. You will find a darker border around the active cell.
6. Cell Reference: The cell reference identifies the exact location of the current active cell. In the Figure below, the active cell is A1. The column is always the first letter in a cell reference followed by the row number. Cell A1 is the cell located in column A and row 1. Each cell has a unique cell reference.
7. Formula Bar: The formula bar displays the contents of the active cell including any formulas. As you enter or edit data, the changes will appear in the formula bar.
8. Columns: Columns (vertical) are labeled along their column heading A thru Z, AA thru AZ, up to column IV.
9. Rows : (horizontal) are labeled by their row headings from 1 thru 65,536.
10. Name Box The name box displays the active cell reference. Below, the name box displays G1.
What are formulas and how do I create them?
Formula: A formula is an expression or cell entry that performs some sort of calculation. An equal sign = is always the first part of a formula followed by an expression that calculates a value. Always remember that if you fail to enter the equal sign, Excel will treat your expression as text.
Operator
A formula:
Ø Is a sequence of values and operators.
Ø Begins with an equal to (=) sign.
Ø Excel formulas enable you to perform calculations on numerical data.
Ø Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order.
OPERATOR
| |
Addition
|
+
|
Subtract
|
-
|
Multiply
|
*
|
Divide
|
/
|
Power
|
^
|
Ø Excel 2007 provides the following basic types of functions:
o Mathematical functions
o Statistical functions
o Date and time functions
o Logical functions
Ø The Formula Bar:
o Is a bar at the top of the Excel window that displays the formula of the active cell.
o Is divided into the following three parts:
§ Name Box
§ Insert Function
§ Formula Box
Ø The following figure shows the Formula Bar with its three components.
Auto Fill
Ø The AutoFill feature of Excel 2007 enables you to quickly copy a formula to adjacent cells by dragging the fill handle.
Ø The fill handle is a small plus sign at the lower-right corner of the active cell.
Ø You can insert the advanced functions, such as financial, information, database, and engineering functions by using the Function Library group.
Ø You can copy formulas and functions using copy or paste feature of Excel 2007.
Ø Excel 2007, a spreadsheet application, is equipped with various features and functions that can be used to:
o Organize data
o Calculate data
o Analyze data
o Generate meaningful reports
Sorting and Filter
Sorting data is an integral part of data analysis. It helps you perform the following:
o Arrange data in a particular order.
o Order rows of data with different colors or icons.
Filtering data helps you visualize and understand your data better.
The following figure shows the Sort and Filter option under the Data tab.
Lesson 4: Microsoft PowerPoint
Lesson Objectives
On completion of this lesson, you will learn
· Create Presentation Using PowerPoint
· Accessing the Internet
· WWW and its advantages and uses
Introduction:
Microsoft Power Point is a part of MS-Office suits and is a software used to create presentation by using text, images and effects.
Using PowerPoint, you can create slides, screens, and handouts that effectively incorporate colorful text and photographs, illustrations, drawings, tables, graphs, and movies and animation to create an effective slide show. You can animate text and illustration on the screen using the animation feature as well as add sound effects and narrations.
A presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. For larger audiences, the computer display is often projected using a video projector. Slides can also from the basis of webcasts.
A typical Microsoft PowerPoint allows you to do the following:
· Presentation material with drawings and pictures.
· Presentation material with text.
· Presentation material with graphs and tables
· Photo album
As this software is easy to use, you can use it as a visual aid to make presentations. This program is widely used in business and classrooms, and is an effective tool for training purpose.
It is easy to customize the presentation according to your requirement or you can use one of the several design templates that come with the application. Many more templates that come with the application. Many more templates, images, effect, add-ons etc.
To begin, Open MS PowerPoint
On the desktop go to Start à All Programs à Microsoft Office à Microsoft PowerPoint2007
Office Button
|
Quick Access Toolbar
|
Title Bar
|
TAB
|
Ribbon
|
Status Bar
|
Notes Pane
|
Notes Pane
|
Views
|
Zoom Control
|
Add text
By default, the application opens a new blank slide.
· To insert title text, point your cursor on Click to add title and click.
· To insert subtitle text, point your cursor on click on Click to add subtitile and click.
Change the font of the text
1. Select the text to which you want to apply a specific font/font size/font color.
2. Open the Font dialog box (Press Ctrl+D or click the Font Dialog launcher)
3. Select the appropriate setting for Font, Font Style and Size.
4. Select the required Effect and Font colour
5. Click OK to save the settings.
WordArt
WordArt is a text-styling feature available in PowerPoint. You can give special effects to the text such as textures, outlines, and, many other manipulations that are not available through the standard function of formatting the font.
To apply a WordArt Style, follow these steps:
1. Select the text to which you want to apply the style.
2. On the Drawing Tools Format tab, in the WordArt Styles group, open the WordArt Styles gallery.
3. Hover the mouse pointer over the styles to preview then on the text on the slide.
4. Click the desired style to apply it. To remove a previous WordArt effect, click Clear WordArt.
5. Type your text and change the font settings if required
6. Click OK
Add a Picture
1. Go to Insert tab > click Picture
2. Select the source of the picture
3. Select the required picture from the dialog box displayed
Format Picture:
The format picture dialog box provides tools used to format pictures.
To view the picture dialog box,
1. Right-click the object and choose format picture (or click the picture styles launcher), depending on the object type. The format shape dialog box opens
2.
Insert an object
Application objects can be inserted into the slides. The application object can be either linked object or embedded object
Linked object: an object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.
Embedded object: information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the object becomes part of the destination file. Change you make to the embedded object are reflected in the destination file.
Go to inset >object
The insert object screen is displayed as shown
To create a new object.
1. select create new
2. select the application from the list of object type displayed
3. to create from file, browse and selected the source file of the objet
4. Click OK
The relevant application opens for you to create your object.
Create a presentation with slides
1. Save the slides you have created by clicking File > Save As
2. Select the folder where you want to save the slides and give a name to the file.
3. Press F5 to view the presentation – slide show
Move a text or picture
You can move text or picture in a slide, if required.
o Click on the text or picture, A frame appears around it
o Place the cursor pointer on the frame and drag the text or picture to the desired position
Resize an object or picture
o Click on the object. Place the cursor pointer on the frame where it will change into a two-sided pointer
o Press the left button of the mouse and drag outward or inward to increase or decrease the size, and release the button
Position objects
o Right click on the object
o Select Order and click the option of your choice – Bring to Front, sent to Back, Bring Forward or Sent backward
Rotate an objects
o Select the object. The free rotate option. Is displayed on the frame of the object
o Place the cursor point on this
o Press the left button of the mouse.
o Rotate the object by moving the mouse in a clockwise or anti-clockwise direction and release the button, once you have attained the required position of the object
Apply transition to slides
1. Select the slide in Normal or Slide Sorter view
2. Select the required Transaction Effect from the Transitions tab
3. Click effect Option and select any options for the chosen transition effect as desired
4. Select the Duration and Sound
5. To Advance slide, select either On mouse click or After
6. Click Apply to All, to apply the same transition settings to all slides in the presentation.
Apply animation effects
Animation in Microsoft PowerPoint refer to the way that items, such as text boxes, bullets points or images move onto a slide during a slide show.
There are two type of animation available in PowerPoint.
1. Animation Schemes that affect all of the content on a slide
2. Custom animation that allows you to apply a variety of animation effects to individual items on a slide.
Animation Schemes in PowerPoint allow you to add preset visual effects to paragraphs, bulleted items and titles from a variety of animation groupings \, namely Subtle, Moderate and Exciting.
Use an animation scheme to keep your project consistent in the look and enhance your presentation.
1. Click one of the animation sample in the Animation group
2. Click the Add Animation button, and choose and effect from the menu that appears
Custom Animation contains a list of effects that you can apply to object to have them animate during the slide show.
1. Select an element of the slide and choose Effect Option in the Animation Pane
2. Set the Timing with Start (this triggers the animation), Delay and Triggers of the element, click the relevant options.
3. Use the drop –down to the right of the item to access the option for a particular effect.
4. To change the sequence of the elements appearing in the slide, click the Text Animation Tab.
Lesson 5: Internet Concepts
Lesson Objectives
On completion of this lesson, you will learn
· Internet and its advantages
· Accessing the Internet
· WWW and its advantages and uses
Introduction:
· In 1969, the Department of Defense (DOD) of US of America started a network called ARPnet (Advance Research projects Administration network). It began with one computer in California and three in Utah. To share software and hardware resources, the military allowed universities to join the network. Students using the polled resources developed software that would communication across computers, giving birth to the now so popular Internet.
· Internet is the interconnection between several computers of different types belonging to various networks all over the world so much so it is often called a network of networks.
Advantage of Internet
The Internet is an ocean of information accessible to people across the world. The internet is –
Network – Organisations can use Internet to link offices and their employees, popularly known as the Internet.
Medium – It serves as communication channel for anybody dealing with product marketing or corporate communications.
Market – It is a vast virtual market where it is possible to advertise, sell and buy products.
Transaction Platform – The Internet allows us to complete business and financial transaction online.
The World Wide Web (WWW): Navigating the Internet
You use browser software to surf the internet. Few example of browers are Internet Explorer, Mozilla Firefox, Netscape Navigator and so on. Any information on the WWW (World Wide Web) is displayed on a Web Page. The term Home Page commonly refers to the first page of the any organisation’s web site.
WWW is series of servers that are connected through hypertext. Hypertext is method of presenting information where some part of the text on a web page is highlighted. When the user clicks on the highlighted text it displays elaborate information on that particular topic. This text is called hyperlink, which allows the user to navigate from one web page to another.
Common Terms used on WWW are:
Brower – Software which allows the user to navigate the WWW
Web Server – Software on the server which respond to request from the browser to retrieve the page requested
Home Page – First page which is displayed when a Web Site is visited. It contains hyperlinks to get the relevant information
URL – Web Addressing scheme that is used to determine the exact location of a Web Page. Example: http://www.technosound.com
HTML – Scripting Language used to design and create web page
HTTP – Protocol used on Web to transfer Web pages. Protocol means a set of rules.
Useful Services on WWW
· Email
· Search Engines
· Chat Rooms
· E-learning
· E-Commerce
Microsoft Internet Explorer
With the launch of Windows 95 and a web browser of its own (Internet Explorer) in August 1995, Microsoft began an effort to challenge Netscape. For a while, Internet Explorer played catch-up to Netscape’s continual pushing of the browsing technological envelope, but with one major advantage –unlike Netscape, Internet Explorer was free of charge.
But slowly, Internet Explorer gained market share. By the fourth generation of both browser, Internet Explorer had caught up technologically with Netscape’s browser. As time went on, Netscape’s market share diminished form its once-towering percentages.
Using Microsoft Internet Explorer
Internet explorer is perhaps the most popular Web Browser available as on date..
Click on Internet explorer Icon on the desktop to start the browser
· File
o New: - Opens a new file in a new window allowing the user to view multiple Web Pages simultaneously.
o Open: - Allow the user to type or select the address a web site.
o Save As: - Allow the user to save the current pages as a file with a different name
o Send
§ Page by Email :- Sends the current page as mail to another user.
§ Link by Email:- Sends a link of the current page to another user as a message
§ Shortcut to Desktop:- Creates a shortcut to desktop for opening the current page
o Page Set Up:- Allow user to change the settings of the page
o Print:- Allows user to Change the settings of the Page
o Properties:- Display the properties of the page, including the general and security information
· Edit
o Cut, Copy and Paste: These option are used for cutting, copying and pasting text that has been marked.
o Select All: Select the content of the entire page.
· View: This provides options to control the screen display
o Toolbars:- Used to enable or disable toolbar.
o Text Size:- Allows the user to select the size of the text on Web page, which have the option Largest, Large, Medium, Small, Smallest.
o Go to:- Allow the user to go to next page, previous page or home page.
o Stop:- Stops the current Operation.
o Refresh:- Refreshing the contents of the current page by fetching a new copy.
o Source: - Displays the HTML source code for the current page.
o Full Screen:- Display the Web Page on a full screen.
· Favorites: This is used to bookmark your favorite web sites and store frequently used web sites.
o Add to Favorites: This allows the user to add the currently visited web site to the list of favorites.
o Organise Favorites: Helps to organize the web site to folders.
· Tools: This menu provides option to make the user experience easier.
o InPrivate Browsing: Allows to surf the web without leaving a trail in Internet explorer.
o Pop-up Blocker: Help to block the pop-ups that appear while using a web page.
o Internet Options: Used to change the Properties of the Browser.
· Help:
o Internet Explorer Help: Opens the help window where the user can type in the search topic and get the relevant information.
o Online Support: Links the user to the web tutorial page.
o About Internet Explorer: Gives the information about Internet Explorer.
Using the Toolbar
The toolbar contains icons for the frequently user function, so that the user may not have to search the menu option for doing so. The icons on the toolbar are as follows
Using the Address bar
The easiest way to launch a web page is to use the Address bar. Type the URL of the web site in the address box and press Enter. The Web page will be loaded.
Shortcuts
Key
|
USE
|
Ctrl + N
|
New Document
|
Ctrl + O
|
Open existing Document
|
Ctrl + S
|
Save Document
|
F12
|
Save As
|
Ctrl + P
|
Print Document
|
Ctrl + F4
|
Close Document
|
Ctrl + W
|
Close Document
|
Ctrl + C
|
Copy Selected Object
|
Ctrl + V
|
Paste Selected Document
|
Ctrl + X
|
Cut Document
|
Ctrl + Z
|
Undo
|
Ctrl + Y
|
Redo
|
Ctrl + B
|
Bold
|
Ctrl + I
|
Italic
|
Ctrl + U
|
Underline
|
Ctrl + D
|
Open font Dialog Box
|
F7
|
Check Spelling and Grammar
|
Shift+ F7
|
Thesaurus
|
Alt +F4
|
Close Word Window
|
No comments:
Post a Comment