Lesson 5. ICT Soft Tools Presentation

Lesson 5. ICT Soft Tools Presentation

Q.1 Fill in the blanks

1. PowerPoint is a very popular …………………………. software package. Presentation

2. A …………. is a page of your presentation.  Slide

3. A PowerPoint 2007 presentation has an extension ………………… .pptx

4. In PowerPoint 2007 the new slide option is available on ……………. tab. home

5. You can use the ……………………. view in PowerPoint to view miniatures of all slides together. Slide Sorter

6. The outlined area on the slide for entering text is called a ……………………… Place Holder

7. The brief discretions of every slide of which a presenter may use during a presentation is called ………………….. Speaker Notes

8. The miniature versions of the slides in the slide sorter view are called ………………… Thumbnails

9. In PowerPoint 2007, you can choose different views of your presentation using ………………. tab. View

10. A …………………. in PowerPoint 2007 is a part of template that stores information about placements of text  and objects on a slide. theme

11. A …………………………. is a combination of various effects such as line style, level, or 3D that one can apply to shapes in smart graphic to create unique professionally designed work. Smart art Style

12. Advancing from one slide to the next is called …………. transition

13. Visual movements applied to individual elements of a slide area called …………………. animations

Q2. State True or False

1.     In PowerPoint 2007 the tabs on the ribbon are designed to be task oriented. True

2.     In PowerPoint 2007 the title bar displays the name of the presentation True

3.     In PowerPoint 2007 the status bar displays the Save, Undo, Redo button. False

4.     The notes pane in PowerPoint 2007 lets you add speaker’s notes. True

5.     We cannot hide a slide on PowerPoint 2007.False

6.     In PowerPoint 2007, the design view is used to see the consistency and flow of a presentation. False

7.     You cannot hide a slide in PowerPoint 2007 False

8.     Adding transitions, animations, generally, livens up your presentation. True

9.     Sounds and transition can be added to several slides at the same time in the slide sorter view. True

10.                        The Hide Slide button on the ribbon is toggle to hide and unhide slide. True

Q3. Rewrite the statements using single correct alternative.

1.     In PowerPoint 2007, the default extension of presentation file is………………. pptx

2.     In PowerPoint 2007, …………………………………………………………………….. to find text in the presentation. select the replace command of the editing group on the home tab of the ribbon

3.     In PowerPoint 2007, ………………………….. allows you to type speaker notes that can be printer for use during presentation. Notes Page View

4.     In PowerPoint 2007, ……………………………………. is used to see the flow of main points and organize the contents of a presentation. Normal View

5.     In PowerPoint 2007, to switch between different views  ……………………………………………….. click on a view button at the left of the zoom slider, just above the status bar.

6.     In PowerPoint 2007, pictures can be added to speaker notes on the ………………………. view. Notes Page

7.     On selecting text placeholder on a slide, …………………………. appears on the title bar to draw your attention to the fact that new tab has/have been added to the ribbon. Drawing tools

8.     To Exit the slide show view at any time, press the ………. key on the keyboard. Esc

Q4. Rewrite the following statements by selecting two correct options:

1.     The latest file formats/extensions used in PowerPoint 2007 are ……………….. , ……………………  .pptx , .pptm

2.     The Home tab on the PowerPoint 2007 has the groups …………………… , …………………………. Clipboard , Slides

3.     The views offered by PowerPoint 2007 are ………………………… , ………………………… Normal , Slide Show

4.     The slide sorter view ……………………………………………………………… , …………………………………………. shows completed slides in sequence , provides more detailed review than outline view.

5.     Notes pane in PowerPoint 2007 can be seen in ………………………… , ……………………. views. normal , notes page

6.     The subtype of relationship type smart art graphics are …………………………. , …………………  target , venn

7.     On selecting smart art graphics, the new tabs that appear on the ribbon are ……………………. ,

………………………… design , format

8.     Themes gallery can be accessed from the ……………………….. , ………………………… design tab , slide master view

9.     Types of animation effects are …………………………….. , …………………………… entrance , exit

10.            During slide show, to go to the next slide, press, the ……………………….. , ………………. key. Page down , enter

Q.5 Write short note on:

1) Templates in PowerPoint.

Ans:  A template is an outline designed to help us to easily prepare presentations. The format is preset and the user only has to fill in personal details which are relevant to the presentation being prepared. The template has placeholders which indicate to the user the details that must be given by him. PowerPoint has templates for preparing Resumes, Calendars, Project reports, Advertising, Invitations, Plans, Schedules and many more.

Whenever we want to create a New Presentation, we must click on the Office Button followed by New. A dialog box opens which asks whether we want to create a Blank Presentation or use one of the existing Templates. Additional Templates are available for download from the Microsoft Website or from several sites online

2) Using notes page view and creating notes in PowerPoint 2007

Ans: Notes Page view. The notes page view displays a small image of the active slide along with a window to enter Speaker Notes. The speaker notes can be printed if required.

Q.6 Answer the following questions:

1) What is meant by design theme in PowerPoint 2007?

Design Themes include preset fonts, color palettes, formatting effects, and backgrounds that give your presentation a professional look. PowerPoint provides a number of choices for working with slide themes. If you choose an existing theme, you can customize it to meet your needs.

2) What is mean by Smart Art Style? How will you apply Smart Art Style to an entire Smart Art graphic?

Ans:  A SmartArt Style combines several effects, such as line style or a 3D style. You can apply these effects to the shapes of your SmartArt graphic to give a professional and unique look to your graphics.

·         Click to select SmartArt graphic.

·         Go to SmartArt Tools > Design > SmartArt Styles.

·         Click on the small arrow button to view the more styles.

3) How will you add the same transition to all the slides in a presentation in PowerPoint 2007?

1.     On the left side of the slide window, in the pane that contains the Outline and Slides tabs, click the Slides tab.

2.     Select the slide thumbnails of the slides that you want to apply slide transitions to.

3.     On the Animations tab, in the Transition To This Slide group, click a slide transition effect.

To see more transition effects, in the Quick Styles list, click the more button 

4.     To set the slide transition speed between the current slide and the next slide, in the Transition To This Slide group, click the arrow next to Transition Speed, and then select the speed that you want.

5.     In the Transition To This Slide group, click Apply to All.

4) How will you a) hide one or more slides from slide show b) run a slide show?

·         To hide a slide, right-click the slide that you want to hide, and then click Hide Slide.

·         To show a slide that you previously hid, right-click the slide that you want to show, and then click Hide Slide.

• Under the View tab in the Presentation Views group, click on SLIDE SHOW .
  The slide show will start from the first slide.

• In the bottom right hand corner of the screen, next to the zoom slider, click on the small slideshow button . The show will start from the first slide.

• Press [F5]. The show will start from the first slide.

• Under the Slide Show tab, in the Start Slide Show group choose from one of the following options:
• Click FROM BEGINNING to start the show from the first slide.
• Click FROM CURRENT SLIDE to start from the slide you have active.
• Click CUSTOM SLIDE SHOW, then Custom Shows... to bring up the Custom Shows dialog. Click New and choose the slides you wish to use in your show and the order.

Q7. Answer in brief

1) List the various uses of PowerPoint 2007?

Ans: MS PowerPoint is a presentation package used mainly for preparing slide shows. Its ability to use images, graphics, smart art, slide transition effects and animations allows us to use PowerPoint in various applications. 
1. PowerPoint is used extensively in the field of Education, as the use of graphics and animations make learning fun for children. 
2. Besides Teachers, Students also use PowerPoint routinely to present their reports, assignments or projects for evaluation.
3. PowerPoint is also used in the field of Business and Commerce as it is easy to present new ideas, product information as well as performance reports both to clients as well as co-workers.
4. PowerPoint is also used in the field of Advertising since product information can be easily presented using this application.
5. Resumes, Newsletters and Invitations can also be prepared using PowerPoint.

2) Explain the components of PowerPoint 2007?

Ans:

·         Office button: Opens the Office menu, from which you can open, save, print, and start new presentations.

·         Quick Access Toolbar: A small toolbar next to the Office button contains shortcuts for some of the most common commands.

·         Title bar: Identifies the PowerPoint program running and the name of the active presentation.

·         Minimize button: Shrinks the application window to a bar on the taskbar; you click its button on the taskbar to reopen it.

·         Maximize/Restore button: If the window is maximized (full screen), click will changes it to windowed (not full screen) and vice versa.

·         Close button: Closes the application.

·         Ribbon: Functions as a combination of menu bar and toolbar, offering tabbed "pages" of buttons, lists, and commands.

·         Presentation window: Where active PowerPoint slide(s) appear where you work on the slide.

·         Status bar: Reports information about the presentation and provides shortcuts for changing the view and the zoom.

3) What is a slide master in PowerPoint 2007? Explain its importance in detail?

Ans: A Slide Master is a Slide which stores information about the Theme, Background, Color, Fonts, Effects, Placeholder sizes and position in the presentation. In addition, Slide Numbers, Slide Orientation, Headers and Footers can also be set.

Changes made in the Slide Master are applied to all the slides in the presentation and this helps us to save time. The Slide Master is especially important in long Presentations as changes will be applied to all slides quickly.

4) Explain how to create Slide Master in PowerPoint 2007 for your presentation?

Ans: To create or change the Slide Master in PowerPoint carry out the following steps:-
1. Open a blank presentation, click on View Tab and then in the Presentation View group click on Slide Master.
2. A blank Slide Master will be displayed with all the default settings. The default settings can be changed by clicking on the place and making the desired changes.
3. To add a new Slide Master, click on the desired location and then on the Slide Master Tab in the Edit Master group click on Insert Slide Master.
4. In the slide thumbnail view the Slide Master is the larger Slide while the settings of the different layouts are below this Slide Master.
5. The newly created Slide master can be saved as a Template for future use.

5) Explain different views in PowerPoint 2007 offers to look at presentation created.

An: PowerPoint 2007 provided us with four different views while working on our Presentations.
1. Normal View. This view displays all the slides as Thumbnails on the left while the Slide being edited is displayed in the center of the screen. All features of the active slide can be modified as desired. The thumbnails provide a quick way to switch between slides.
2. Slide Sorter View. The Slide Sorter View displays thumbnails of all slides in the center of the screen and allows us to change the order of the slides, simply by clicking and dragging the required slide.
3. Notes Page view. The notes page view displays a small image of the active slide along with a window to enter Speaker Notes. The speaker notes can be printed if required.
4. Reading View. This view allows us to view the slides in a Full Screen. This is a way to preview the Slide Show.

6) What is A Smart art graphic? Name and briefly explain the types of Smart Art graphics?

An: The Smart Art designs are built with this purpose in mind, and cover a number of graphical representations for our data, including organization charts, flow charts, pyramids, Venn diagrams, and more. Additionally, many of the Smart Art graphics have animation features built in, to help make your presentation visually connected. Different Smart Art designs may also include spots for pictures or movies within the graphic.

Here are seven categories of Smart Art graphics. Each category is built to be used in different situations and offers a number of graphics to from which to choose.

§  List: Shows a general list of related items.

§  Process: Shows a progression of items or data.

§  Cycle: Shows a process, especially one that is cyclical.

§  Hierarchy: Shows a ranking relationship between data.

§  Relationship: Shows a variety of relationship types (e.g. sequence, interconnected, balance, etc.)

§  Matrix: Shows how various elements relate to a central idea.

§  Pyramid: Shows a building relationship.

7) Write a note on animations in PowerPoint and its types?

Ans: PowerPoint uses the term Custom Animation for animation added to slide objects -- for most practical purposes, the terms "custom animation" and "animation" can be regarded the same.

·         Entrance animations are used to introduce a slide object within a slide.

·         Emphasis animations are used to animate slide objects that are already present on a slide.

·         Exit animations are used to animate slide objects off a slide.

·         Motion Path animations are used to move slide objects already on a slide on a set path.

Std 9 Chap 4 ICT Soft Tools : Spreadsheet

4. ICT Soft Tools: Spreadsheet

Q.1 Fill in the Blanks.

1.     …………. Is a software in the Microsoft Office Suite which is used principally for accounting. Excel

2.     Excel 2007 adds the extension …………. to every  workbook  filename. .xlsx

3.     Spreadsheets of an Excel workbook are called ………………………. Worksheets

4.     In Excel, cells are formed by the intersection of ……………… and columns. Rows

5.     A selected cell in an Excel worksheet is called a/an ________ cell. active

6.     The ______________ box in Excel displays the address of the active cell. Name

7.     To add the values in a selected row, column or cell, __________ option is used in Excel. F2

8.     In Excel, the result of the formula, =5+2^3, is _________. 13

9.     ___________ chart in Excel is (usually) used for scientific data analysis.  XY Scatter

10.                       In Excel, ________ the facility Is used to complete one entry at a time. form

Q.2 State True or False

1.     An active cell is the one in which information is being entered. True

2.     We can minimize the Ribbon in a Microsoft Office Application to display only the names of the tabs by double clicking on the name of the active tab. True.

3.     There are keyboard shortcuts for every button/icon on the Ribbon. True.

4.     The cell at the first row and first column of an excel worksheet is referred as 1A. False

5.     The address of the active cell of a worksheet can be seen in the Formula bar. False

6.     In Excel, to place the insertion point inside a selected cell, you double-click inside the cell or press the function key F2. True.

7.     In Excel, if the text is too long, it is displayed in the right side of the cell as if they are empty. True

8.     In Excel, when we select the Wrap Text option in the Alignment group of the Home tab, the cell height adjusts according to the text without any change in the cell width. True

9.     By default , Excel 2007 enters time as AM. True

10.                       Excel  2007 considers a leading plus sign as defining a formula. True

11.                       The formula in Excel, =A5+D5 returns the sum of the numbers in the cells A5 and D5. True

12.                       Suppose the cell B2 of a worksheet contains the formula, =A$1, if you copy the cell B2 to B3 , the formula changes to =B$1. False

13.                       The formula in Excel, =MEAN(A5:D5), returns the arithmetic mean of the numbers in the range A5 to D5. False

14.                       In Excel, the formulas =5+3*2 and =(5+3)*2 give the same result, viz., 16.. False.

Q.3 Rewrite the following statement by selecting the correct option.

1.     Excel  2007 adds the extension ________ to every workbook filename.  .xlsx

2.     When we open Excel 2007, the default number of worksheets present in a workbook are . 3

3.     By default , number data type in a worksheet cell is displayed horizontally . right aligned

4.     In Excel, a single click on any of the small arrows at the end of the scroll bar. Scrolls the active worksheet one cell at a time.

5.     Right- clicking on any if the tab scrolling buttons in Excel 2007 displays. The List of worksheets in the active workbook.

6.     To select all cells in a worksheet,. Click the diagonal arrow at the intersection of row and column headers.

7.     The Page Layout view in Excel 2007 is similar to the _______ view in Word 2007. Print Layout

8.     Find the valid time from the following ______  . 02:26

9.     In Excel 2007, the mathematical expressions are referred to as _________ . Formulas

10.                       The _________ operator combines a range of cells on worksheet for calculation. Union

Q.4 Rewrite the following statement by selecting two correct options.

1.     In Excel 2007, each worksheet can contain ___________, __________ . 10,48,576 rows, 16,384 columns

2.     In Excel 2007, which of the following is true about a cell? It is formed by the intersection of a row and a column, It is identified by a unique address.

3.     In Excel 2007, country specific special formats can be applied to which of the following data type? Date , Time

4.     Which of the following characters can we use while specifying a date in Excel? Forward slash, Hyphen

5.     In Excel 2007, functions are ________, _______ formulas. Built in , Predefined

Q.5 Answer the following questions:

1.     Navigation in Excel.

Answer: There are different ways to navigate or scroll through a worksheet, or between worksheets of a workbook. You can use the arrow keys , the scroll bar, sheet tabs, sheet tab scroll buttons ot the mouse.

                                i.            To move one row up or down: press the scroll lock key on the keyboard, and use the up or down arrow keys, or click the scroll arrows at the ends of the vertical scroll bar.

                             ii.            To move one window up or down: press the Page Up or Page Down key on the keyboard.

                           iii.            To scroll up or down a few rows at a time: rotate the mouse wheel button forward or back.

                           iv.            To move between cells on the worksheets , click any cell or use the arrow keys. When you move to a cell, it becomes the active cell.

2.     Changing row height and column width.

Answer:  1) Changing row height: if you increase the font size of the contents of a cell or wrap text, Excel automatically increases the height of that entire row. Also , you can customize the height of row in below ways:

      (a) click on the row header to select the row. Hold the mouse pointer over the bottom border of the row header, when the mouse pointer changes to         , drag the mouse to increase or decrease the width.

(b) You can also set the row height by clicking format icon of the cells group on the Home tab.

2)  Changing Column width: if the data entered in a cell is too long to fit in the cell, you can double click on the right border of its column header. Then , the width of the column increases to fit the data . you can customize the height of row in below ways:

(a) click on the row header to select the row. Hold the mouse pointer over the bottom border of the row header, when the mouse pointer changes to         , drag the mouse to increase or decrease the width.

(b) You can also set the row height by clicking format icon of the cells group on the Home tab.

Q.6: Answer the following in brief:

1.     Various uses of Excel 2007.

Answer: MS Excel 2007 is a spreadsheet program and any application that requires spreadsheets can be done using Excel .Applications which require handling large amounts of data, calculating, sorting, filtering and formatting of data before printing or displaying as charts or tables can be easily handled by Excel. For these reasons, applications such as Payroll, Inventory, Accounts are being routinely done on Excel.

2.     What is formula in Excel? What are different types of operators that can be used in a formula?

Answer: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. There are four different types  of calculations operator: arithmetic comparison, text concatenation, and reference. Arithmetic operators are used to perform basic mathematical operations such as addition, subtraction, multiplication, finding percentage and produce numeric results. Comparison operators are used to compare two values eg. TRUE or FALSE. A text concatenation operator joins two text strings. Reference operators are used to combine ranges of cells for calculations.

3.     What are functions? How are functions used in Excel 2007?

Answer: Excel 2007 has several Pre-written or Inbuilt formulas known as Functions. Functions simplify our work by doing complex calculations without us having to remember the formulas. Functions can be entered in Excel by following the “=” sign with the name of the function. Excel prompts you to enter the required values which are known as arguments and displays the results in the active cell.

e.g. IF(J3> 35, “PASS”, “FAIL”)

Here the IF Function has 3 arguments which are put in brackets following the IF Keyword and separated by commas.

Q.7: Answer the following :

1.     What are the advantages of an electronic spreadsheet program?

Answer:  The advantages of electronic spreadsheet program:

                    i.            An electronic spreadsheet program has the obvious advantages of processing speed and storage capacity of a computer.

                 ii.            Calculations using a spreadsheet program are almost free of errors, i.e. , if the data entered and formula used are correct, then the calculated results are definitely correct.

               iii.            It has the important facility of automatic recalculation. When one value is changed, all other values that depend on that first value change automatically as the spreadsheet is recalculated by the program.

               iv.            Tabular numerical data can be represented in easy-to-gasp pictorial from such as graph or charts.

2.     Explain the features of the Excel 2007 Window.

Answer:   The Title Bar in Excel displays the name of the Program and the Workbook. The Ribbon consists of 7 main Tabs and more may be displayed depending upon the Work being done. Each of the Tabs are divided into Groups and Commands. The Microsoft Office Button has other commands while the Quick Access Toolbar provides a quick way to carry out often repeated commands. The address of the active cell is displayed in the Name Bar while its contents are displayed in the Formula Bar. The Horizontal and Vertical Scroll Bars, the Worksheet Tabs and the Tab scrolling buttons allow a quick way to navigate around the Excel Workbook Window.

3.     What are graphs or charts? How can different types of charts or graphs be prepared with Excel?

Answer: A Graph or Chart is a pictorial representation of numerical data that is entered in Excel. Since large amounts of numerical data which is presented in a series of rows and columns is difficult to understand, a chart brings out the important points represented by these numbers in an easy-to-understand way. The Chart Group under the Insert Tab allows us to choose different types of Graphs. To insert a chart in our Worksheet we must perform the following steps.

1. Select the range of data which must be used to create the chart.

2. Click on the Insert tab and then on the type of Chart you want from the Chart Group.

3. Choose the desired type from the list of displayed options.

4. The chart as selected by you will be displayed.

5. Change the Title or Legend as desired.

6. You can choose to put the chart on the same worksheet as the Data or on an separate sheet. Click Finish when done.

7. Your chart will be displayed.