Class 6th Computer

Class 6 marks an exciting step for students as they delve deeper into core subjects and broaden their understanding of the world. At DAV Academic, our curriculum is designed to foster curiosity, critical thinking, and hands-on learning experiences.

Chapter 4

Creating Professional Presentations and Presenting OO Impress (Open Source)

Question Answer

Q1) Fill in the blanks :-

1.) When the presentation is presented to the audience in full screen mode, where slides appear one after another is called Slide Show.

2.) The text that is inserted at the top of the page is called Header, whereas the text that is inserted at the bottom of the page is called Footer.

3.) Date (fixed) is used for inserting the fixed current date.

4.) Time (Variable) helps in inserting the current time.
5.) The special animation effects that occurs during the slide show when we move from one slide to another is known as Slide Transition.

6.) Loop until Next sound option will allow the selected sound to be played repeatedly till the next sound is been played.

7.) Narration is a voice over or commentary that is added to the presentation.

Q2.) Answer the following questions (short Question Answer ) :

i. What is Slide show?

Ans. When the presentation is presented to the audience in full screen mode, where slides appear one after another is called slide show.

ii. What is Hide slide?

Ans. Hiding slides is particularly useful when you have a added slides to a presentation that provide different levels of details on subject matter, then you can mark these slides as hidden so that they are not displayed in your presentation. Or; Sometimes we do not want to show a particular slide during slide show, for this purpose we can hide our slide.

iii. How many types of options we can insert in slide?

Ans. There are various types of options we can insert in slide. a. Header & footer b. Slide number c. Date and Time

iv. What are headers and footers?

Ans. Headers :- The text that is inserted on the top of each slide is called Header. Footers :-The text that is inserted at the bottom of each slide is called Footer.

v. What is Slide Transition?

Ans. Slide Transitions are the special animation like effects that occur during Slide show.

vi. Write the function of “Apply to Selected Slides” in Slide Transition.

Ans. “Apply to Selected Slides” option allows us to select any of the slide transition effects (like Wipe Up, Wipe Down, Wipe Left etc.) to the selected slides.

vii. What is the function of “Modify Transition” in Slide Transition?

Ans. Modify Transition allows us to change the Speed (slow, Medium, Fast) of slide Transition effect.

viii. What is Foot Note or Comments?

Ans. Foot Notes or comments are useful to the presenter while presenting the slides to audience. These notes are not visible to the audience during the slide show.

ix. What is Authorized User?

Ans. Authorized User is a person who has the permission to use and perform various functions on the presentation.

x. Why do we use password to the Presentation?

Ans. We can apply password to the presentation in order to prevent others from opening or modifying the presentation.

Q3.) Answer the following questions (Long Question Answer ):-

Que:(A) Write down the steps for inserting Header and Footer?

Ans :- Following are the steps which are used for inserting Header and Footer :-

Step 1 : From the Menu select and click on the View menu

Step 2. Now click on Header and Footer option and select it.

Step 3. Now as per you choice click on the checkboxes and select the fields that you wish to insert (Header and Footer, Date and Time, Slide Number) etc.

Step 4. Now click on Apply button if you wish to add these fields for the current slide or click on the Apply All if incase you wish to add the fields to all the slides in a presentation.

Que:(B) What do you understand by Slide Transition? Explain the steps for applying slide transition in the slides?

Ans :- Slide Transition : When the slideshow is been done on screen i.e. means when the slides are changing or moving from one to the other one, the occurrence of the special animation effects takes place which is to be termed as the Slide Transition. The steps for applying slide transition in the slides are as follows :-

Step 1 : Click on the Slide Show Menu

Step 2. Now go to the Slide Transition

Step 3. The Slide Transition window will appear on the right side There are various options which are available in the Slide Transition are as followed :-

(a) Apply to selected slides :-By making use of this option we can apply the selected slide transition effect of our choice (Wipe Up, Wipe Down, Wipe Left etc.) to respective selected slides only. (b)Modify Transition :- Here , in this option we can change the speed (Slow , Medium , Fast ) of the transitional effect into the slide , if we want then we can also make an addition of the sound to the sound to the slides from the sounds list available.

(c)Advance Slide :- Under this option the slides can appear in two ways

i.) On Mouse Click :- In this type of Slide Show, each slide which has this effect will appear only by clicking the mouse button.

ii.) Automatically After :- In this type of slide show, the each slide which has such effect been applied will appear automatically after the set duration of time.

Step 4. Select any on Slide Transition effect .

Step 5. Click “OK” .

Que:(C) What is a Narration? Write down the steps for adding narration in the slides.

Ans :-Narration means the recorded voice or commentary is been added to the presentation. Recording the sound by making use of the Sound Recorder The steps for adding Narration to the slides are as followed :-

Step 1 : Go to the Start Button.

Step 2. Click on All Apps

Step 3. Find Sound Recorder and Click on it

Step 4. You may find that the Sound Recorder box will open

Step 5. Now just make a click on the start recording button. After which the recording starts and for stopping it you have to click on stop recording button.

Step 6. Now you have to save the recorded sound file in the format of your wish.

Step 7 : Now Open the Appache Open Office Impress .

Step 8 : Now select the slide to which you wish to add the narration.

Step 9 : From the Menu Bar, click on the Insert Tab

Step 10 : Now click on Movie and Sound.

Step 11 : Now select the Sound File and click on Open button. You will notice the sound file inserted.

Que:(D) Explain the difference between the term Data (fixed) and Data (Variable), Time (fixed) and Time (Variable)

Ans :- The difference between the term Data (fixed) and Data (Variable), Time (fixed) and Time (Variable)

(i)Date (fixed):- It is used for inserting the current fixed date.

For ex :- if we insert the date on which we had worked on the presentation, then the following date is been gets displayed whenever we open the presentation.

(ii)Date(varible): Here, you can make the insertion of the current date which is not fixed. It gets updated automatically whenever we open the file. When ever the presentation is been reopened the current date (of the day) is been displayed on the slides.

(iii)Time (Fixed):-It only inserts the current time that is fixed.

(iv)Time (Variable):- It inserts the current time, that is not fixed. Whenever we open the file the time gets automatically updated or changed.

Que:(E) Write down the steps for opening the presentation in the slide show?

Ans :-

STEP 1. Open Apache OpenOffice Impress .

STEP 2. Open Your Presentation:  Go to the File menu in the top-left corner.  Select Open from the dropdown menu.  Browse to the location of your presentation file (typically with a .odp extension) and click Open.

STEP 3. Switch to Slide Show Mode:  Once your presentation is open, go to the Slide Show menu in the top menu bar.  Select Start From First Slide or Start From Current Slide depending on whether you want to start the slideshow from the beginning or from the slide currently selected.

Que 4: Write the steps for following options.

(i). Steps to Insert Header & Footer are:-

1. Click on View Menu

2. Select Header and Footer option.

3. The following header & Footer box appear.

4. Click on Header & Footer check box.

5. Click on “Apply to all”

ii. Steps to Insert Slide Number:-

1. Click on View Menu

2. Select Header & Footer Option

3. Select the Slide Number check box

4. Click on “Apply all”

iii. Steps to Apply Slide Transition are:-

1. Click on Slide Show Menu

2. Go to Slide Transition

3. The Slide Transition window will appear on the right side

4. Select any on Slide Transition effect.

5. Click “OK”

iv. Steps to apply password to the presentation:-

1. Click on File Menu or Press “Ctrl + S” on keyboard.

2. Click on Save As. Save As windows appears.

3. Type the name of the presentation and click the check box “Save with password”. Click “Save” button.

4. Enter the password. Enter again the confirm the password.

5. Click on “Ok Button”.

Chapter 5

Viewing Presentation

(OO Impress Open Source)

Question Answer

Que : 1st => Fill in the Blanks

1. The full-screen presentation mode can be started by pressing the __________ key.

   • Answer: F5

2. You can use the __________ option to view how the slides transition during a presentation.

   • Answer: Slide Show

3. The __________ toolbar in Impress allows you to navigate between slides during a presentation.

   • Answer: Slide Navigator

4. To view the presentation without starting the slide show, you can use the __________ option.

   • Answer: Normal View

5. The __________ view displays all the slides in a thumbnail layout, allowing you to rearrange them.

   • Answer: Slide Sorter

Match the Following

Column A Column B Answers

1. F5 Key A. Navigating between slides 5

2. Slide Sorter View B. Starts full-screen presentation 1

3. Normal View C. View slides in thumbnail format 2

4. Slide Show D. Allows rearranging of slides 6

5. Slide Navigator E. View presentation without show 3

6. Transition F. Visual effect between slides 4

True/False

1. You can view all the slides at once in the Slide Sorter view.

   • True

2. Pressing the F5 key stops the presentation.

   • False (It starts the presentation.)

3. The Slide Navigator helps in rearranging the slides.

   • False (It is used to navigate through the slides.)

4. You can apply transitions in Normal View mode.

   • False (Transitions are applied in Slide Show mode.)

5. The Slide Show option previews the transitions between slides.

   • True

One Word Answers

1. Which view allows you to see all slides as thumbnails?

   • A: Slide Sorter

2. Which key is used to start a full-screen presentation?

   • A: F5

3. Which toolbar helps in navigating through slides during a presentation?

   • A: Slide Navigator

4. What option previews how slides transition?

   • A: Slide Show

5. What visual effect can be added between slides?

   • A: Transition

6. Which view is used for editing individual slides?

   • A: Normal View

7. Which option allows viewing a presentation without starting the slideshow?

   • A: Normal View

Very Short or One Line Answers

1. What is the purpose of the Slide Sorter view in Impress?

   A: It displays all slides as thumbnails and allows you to rearrange them.

2. What does the F5 key do in Impress?

   A: It starts the presentation in full-screen mode.

3. What does the Slide Navigator help you with?

   A: It helps you navigate between slides during a presentation.

4. What is the Normal View used for?

   A: It allows editing and viewing a single slide at a time.

5. Can you rearrange slides in Slide Sorter view?

   A: Yes.

Questions with 2 or 3 Line Answers

1. What is the function of the Slide Show option in OO Impress?

   A: The Slide Show option is used to view the entire presentation in sequence, displaying each slide with transitions and animations. It helps preview the final output of the presentation.

2. How can you rearrange slides in OO Impress?

   A: You can rearrange slides using the Slide Sorter view. In this view, all slides are displayed as thumbnails, and you can drag and drop them to change their order.

3. What is the Slide Navigator, and how does it help during a presentation?

   A: The Slide Navigator is a toolbar that helps you move through different slides during a presentation. It allows quick navigation without manually scrolling through each slide.

4. What is the difference between Normal View and Slide Sorter View in Impress?

   A: Normal View displays one slide at a time and is mainly used for editing. Slide Sorter View shows all slides as thumbnails and is used to arrange and manage slides.

5. How do you start a presentation in OO Impress?
   A: You can start a presentation in OO Impress by pressing the F5 key, which launches the slideshow in full-screen mode. Alternatively, you can go to the "Slide Show" menu and select "Start from First Slide" to begin the presentation

6. What is the purpose of transitions in a presentation?
   A: Transitions are visual effects applied when moving from one slide to the next during a presentation. They help to enhance the flow of the presentation by adding smooth animations between slides, making it more engaging for the audience.

Chapter 6

ANIMATIONS IN SLIDES (Open Source)

Question Answer

Que- 1st Fill in the Blanks

1. __________ refers to the visual effect applied when moving from one slide to another in a presentation.

2. __________ animation allows you to control the entrance, exit, and emphasis effects on individual slide elements.

3. The __________ tab provides options to adjust the speed, start time, and duration of animation effects.

4. To make a slide move automatically, choose the option __________ in the slide control settings.

5. Starting options for animations include On Click, With Previous, and __________.

Answers:
1 - Slide Transition, 2 - Custom, 3 - Timing, 4 - Automatically after time, 5 - After Previous

Que 2nd Match the Following

Column A Column B

1. Slide Transition A. Customizes movement of elements

2. Custom Animation B. Automatically after time

3. Starting Options C. Controls the speed of animations

4. Timing Tab D. On Click, With Previous

5. Advanced Animation Effects E. Effects between slides

6. Controlling Slide Movement F. Entrance, Emphasis, and Exit

Answers: 1 - E, 2 - A, 3 - D, 4 - C, 5 - F, 6 - B

Question 3rd True/False

1. Slide transitions are the same as custom animations. (False)

2. You can change the speed of an animation in the Effect tab. (False)

3. The "On Click" option starts an animation effect when the slide is clicked. (True)

4. Advanced animation effects provide options like entrance, exit, and emphasis animations. (True)

5. Slide movement control options allow slides to advance only on mouse click. (False)

Question 4th One Word Answers

1. What feature is used to animate the transition between slides?

Ans : Slide Transition

2. Where can you adjust the timing of animations in a slide?

Ans : Timing Tab

3. Which option begins an animation effect automatically after a previous effect?

Ans : After Previous

4. What type of animation allows custom control over slide elements?

Ans : Custom Animation

5. What tab provides control over the effect of animations?

Ans : Effect

6. Which setting allows slides to move automatically after a set time?

Ans : Automatically

7. Name an advanced animation type that highlights slide elements.

Ans : Emphasis

Question 5th Very Short or One Line Answers

1. What is the purpose of slide transitions in a presentation?

Ans : To animate the shift from one slide to the next.

2. Name two starting options for animations in slides.

Ans : On Click, After Previous

3. What does the Timing tab control?

Ans : Animation speed, start time, and duration.

4. How can you change the order of animations on a slide?

Ans : By adjusting the sequence in the Animation Pane.

5. What does the "Effect" tab in animation control?

Ans : It controls the animation style and visual effects.

Questions 6th short Question-Answers

1. Explain the difference between slide transition and custom animation.

Ans : Slide transition applies an effect when moving from one slide to another, while custom animation controls how individual elements like text and images move within a slide. Each serves a unique purpose in enhancing presentation flow and engagement.

2. How can you adjust the speed of an animation effect in slides?

Ans : To adjust animation speed, open the Timing tab, where you can choose settings like Fast, Slow, or Medium for each animation effect. This controls how quickly the animation plays.

3. What are the options available under starting options for animation?

Ans : Starting options include On Click (starts animation when clicked), With Previous (starts simultaneously with the previous animation), and After Previous (starts after the previous animation is finished).Here are three additional questions with two or three-line answers

4. What steps are involved in adding custom animations to slide elements?

Answer: To add custom animations, select the slide element, go to the Animation pane, choose an animation type (entrance, emphasis, or exit), and customize the effect as needed. You can also adjust the start, speed, and timing options for precise control.

5. How do you change or remove an existing animation effect on a slide element?

Answer: Open the Animation pane, select the element with the existing animation, and either change the effect by choosing a new animation type or remove it by selecting the "Remove" option. This allows easy modification of animations.

6. Describe the purpose of controlling slide movement automatically after a set time.

Answer: Setting slides to advance automatically after a specified time ensures a smooth, hands-free flow during presentations. This feature is especially useful for timed presentations or kiosks where slides need to transition without user interaction.

Chapter: 7

Spreadsheet - 1 CALC (Open Source)

Question 1: Fill in the Blanks

1. A spreadsheet is a software used for organizing and analyzing data in tabular form.

2. A collection of multiple worksheets is called a workbook.

3. The intersection of a row and a column is called a cell.

4. The Formula Bar displays the active cell’s contents.

5. To save a worksheet, click on the File menu and select “Save.”

Question 2: True/False

1. A worksheet contains multiple workbooks. False

2. Rows in a spreadsheet are labeled with numbers. True

3. The Title Bar displays the name of the file. True

4. The Navigator Buttons are used to apply formulas. False

5. The Formula Bar is used to input and edit cell data. True

Question 3: Match the Following

Column A Column B

Title Bar Displays the file name

Worksheet A single sheet in a workbook

Row Labeled with numbers

Status Bar Displays the sheet's status

Formula Bar Used to edit cell contents

Sheet Tabs Switch between worksheets

Question 4: One-Word Answers

1. What is the primary purpose of a spreadsheet?

   Data organization

2. What is the intersection of a row and a column called?

   Cell

3. Which bar displays the file name?

   Title Bar

4. Which component allows switching between sheets?

   Sheet Tabs

5. Name the bar used to input and edit formulas.

   Formula Bar

6. What is the label for spreadsheet columns?

   Letters

7. Which menu is used to save a worksheet?

   File

Question 5: One-Line Answer Questions

1. What is a spreadsheet?
   A spreadsheet is a software application used to organize, analyze, and store data in a tabular format.

2. Differentiate between Workbook and Worksheet.
   A workbook is a collection of multiple worksheets, while a worksheet is a single sheet in a workbook.

3. What is a Cell in a spreadsheet?
   A cell is the intersection of a row and a column, used to store data.

4. Name the components of Calc.
   Title Bar, Menu Bar, Toolbar, Formula Bar, Navigator Buttons, Sheet Tabs, Status Bar.

5. How do you save a worksheet in Calc?
   Click on the "File" menu and select "Save."

Question 6: Short Answer Questions

1. Define a spreadsheet and explain its uses.

   • A spreadsheet is a digital tool used to organize, analyze, and store data in rows and columns.

   • Uses: Performing calculations, creating charts, managing data, and analyzing trends.

2. Explain the difference between a workbook and a worksheet.

   • A workbook is a file containing multiple worksheets.

   • A worksheet is a single sheet within a workbook, used to enter and analyze data.

3. What are rows, columns, and cells in a spreadsheet?

   • Rows: Horizontal lines labeled with numbers.

   • Columns: Vertical lines labeled with letters.

   • Cells: The intersection of a row and a column where data is entered.

4. Describe the purpose of the Formula Bar and the Status Bar.

   • Formula Bar: Displays and allows editing of the content in the active cell.

   • Status Bar: Shows the status of the worksheet, such as calculation results or selected range information.

5. List the steps to save a worksheet in Calc.

   • Click on the "File" menu.

   • Select the "Save" option.

   • Choose a location, enter a file name, and click "Save."

Chapter 8

Spreadsheets - II CALC (OpenOffice Source)

Question-Answer Set

1. Fill in the Blanks (5)

1. To sort data in ascending or descending order, use the ________ feature in CALC.
   Answer: Sort

2. The ________ function adds up all the values in a selected range.
   Answer: SUM()

3. The ________ function finds the smallest value in a range of cells.
   Answer: MIN()

4. Charts help in analyzing data by representing it ________.
   Answer: visually

5. The first step in creating a chart is to select the ________ you want to analyze.
   Answer: data

2. True/False

1. The MAX() function is used to calculate the average of a set of values.
   Answer: False

2. Sorting data in descending order places the highest value at the top.
   Answer: True

3. You cannot use formulas in OpenOffice CALC.
   Answer: False

4. A pie chart is suitable for showing proportions.
   Answer: True

5. The AVERAGE() function calculates the total sum of values.
   Answer: False

3. Match the Following

Column A Column B

1. SUM() Function a) Adds values in a range

2. AVERAGE() Function b) Calculates the mean value

3. MAX() Function c) Finds the largest value

4. MIN() Function d) Finds the smallest value

5. Bar Chart e) Compares data across categories

6. Ascending Order f) Sorts from smallest to largest

Answer:
1 - a, 2 - b, 3 - c, 4 - d, 5 - e, 6 - f

4. One-Word Answer

1. Which function is used to find the largest value in a range?
   Answer: MAX()

2. What type of chart is best for showing trends over time?
   Answer: Line chart

3. Which statistical function calculates the mean of a range of values?
   Answer: AVERAGE()

4. What do you call sorting data from largest to smallest?
   Answer: Descending

5. What is the first step in creating a chart?
   Answer: Select data

6. Which toolbar contains the option to sort data?
   Answer: Standard toolbar

5. One-Line Answer

1. How do you sort data in ascending order in CALC?
   Answer: Select the range, go to the Data menu, and choose "Sort Ascending."

2. What does the MIN() function do?
   Answer: It finds the smallest value in a range of cells.

3. How is the AVERAGE() function used in CALC?
   Answer: It calculates the mean of a range of values.

4. Why are charts used in spreadsheets?
   Answer: Charts are used to analyze and visualize data for better understanding.

5. Name a chart type suitable for comparing parts of a whole.
   Answer: Pie chart

6. What is the role of the MAX() function?
   Answer: It finds the largest value in a range of cells.

6. More-Than-Two-Line Answer

1. Explain the steps to sort data in ascending order in CALC.
   Answer:

   • Select the range of data to be sorted.

   • Go to the Data menu and choose Sort.

   • In the Sort dialog box, select Ascending Order for the column you want to sort by.

   • Click OK to apply the sorting.

2. What are mathematical formulas in CALC, and how are they used?
   Answer:
   Mathematical formulas are expressions used to perform calculations on data in cells. They begin with an = sign, followed by operators and cell references. For example, =A1+A2 adds the values in cells A1 and A2. They simplify complex calculations and update automatically when data changes.

3. List the steps to create a chart using data in CALC.
   Answer:

   • Select the data range to be visualized.

   • Click on Insert in the menu bar and choose Chart.

   • Choose the desired chart type (e.g., Bar, Pie, Line).

   • Customize the chart settings, such as labels and titles.

   • Click Finish to insert the chart into the spreadsheet.

4. What are the uses of SUM(), AVERAGE(), MAX(), and MIN() functions in CALC?
   Answer:

   • SUM(): Adds all values in a selected range.

   • AVERAGE(): Calculates the mean of a range of values.

   • MAX(): Finds the largest value in a range.

   • MIN(): Finds the smallest value in a range.

5. How does analyzing data using charts help in decision-making?
   Answer:
   Charts present data visually, making it easier to identify trends, compare values, and understand relationships. This aids in quicker and more informed decision-making, especially in business and academic scenarios.

6. Describe the difference between ascending and descending order.
   Answer:

   • Ascending Order: Arranges data from smallest to largest (e.g., 1, 2, 3).

   • Descending Order: Arranges data from largest to smallest (e.g., 3, 2, 1).
     Sorting helps organize data for better analysis and retrieval.