Assessment of Fundamental Competencies Introduction to Information Technology

I T

Supplements

Syllabus

Ref Contents Level Learning Outcome

B 7 Creating and editing charts and

templates

2 LO2.7.1: Show how to insert/create,

move and resize charts

LO2.7.2: Demonstrate command on

formatting and changing chart types

LO2.7.3: Demonstrate adequate

knowledge in creating and editing

Excel templates.

D 4 Running and printing presentations 2 LO4.4.1: Demonstrate performance-

level knowledge whilst applying

meaningful slide transitions

LO4.4.2: Demonstrate performance-

level knowledge whilst setting up

slide shows, recording slide shows,

starting slide show from beginning or

from current slide, broadcasting slide

show and creating custom slide

shows

LO4.4.3: Demonstrate performance-

level knowledge whilst printing Notes

Pages, Hand-outs and Slides.

2 1 3

7

Charts in MS Excel

Use of Charts: Data can be presented in form of Charts which makes it easier to understand the relationship between series of data.

Steps for Drawing up Charts:

1) Enter numeric data in Excel 2) Go to Insert Menu, you will find options for different type of charts there. 3) Select the most appropriate form in which you want to present the data. Different types of Charts are

mentioned below

Types of charts: Column Charts: are used to compare values across categories. Line Charts: are used to display trends over time. Pie Charts: display the contribution of each value to a total. Bar Charts: are the best chart types for comparing multiple values. Area Charts: emphasize differences between several sets of data over a period of time. Scatter Charts: compares pairs of values. Other Charts: Stock chart, Surface chart, doughnut chart, Bubble or Radar chart.

Elements of a Chart: A chart has many elements, some of which are displayed by default and some of them can be added or deleted as per the requirement of the work. The display of the chart elements can be changed, resized and formatted.

1. The chart area of the chart. 2. The plot area of the chart. 3. The data points of the data series that are plotted in the chart. 4. The horizontal (category) and vertical (value) axis along which the data is plotted in the chart.

Highest

0

2

4

6

8

10

12

14

16

18

1 2 3 4 5 6 7 8 9 10

Sco

res

Overs

Score Board

Pak

Ind

6

6

6

4

4

5

5. The legend of the chart. 6. A chart and axis title that you can use in the chart. 7. A data label that you can use to identify the details of a data point in a data series.

Modifying Chart as per requirements: For any type of changing, first you select the chart, then Chart Tools activated.

Chart Tools Contains: 1. Chart Design 2. Chart Layout 3. Chart Formatting

Understanding Chart Design: Change chart type: It consists of multiple option like change chart type which means if u selected e.g. Bar chart then you want to change it to Column chart then it could be done by using ‘change chart type’ option. Chart layout: Another option in Chart design is that you can save the layout of a chart as a template; hence you can apply same as for the other charts in future. Switching data: Data being charted on the X-axis will move to Y-axis and vice versa. Select data: Data being used in the chart can be changed by using Select data option. Chart styles: For a selected chart type there are multiple styles available with different look and formatting. Move chart: Option moves your chart as an object or in another sheet which is a powerful option to place a chart in another sheet. Resize Chart: A chart can be resized by selecting it and then from all four corners cursors will show and drag it to the desired size.

Understanding Chart Layout: Pictures, shapes and text box: You can insert pictures from your computer and readymade shapes like arrows, lines, rectangular and oval shapes. Text box is used to demonstrate some elements on the chart and is used by clicking inside and type word, number or symbol for demonstration. Chart title: To apply a title to the chart and it can be changed, removed and repositioned at right or left side.

Axis title: To apply a title to X-axis and Y-axis, it is actually used to label each axis. Legend: Legend contains the names of data series with their actual data values. Data Table: Same data (as in the sheet) will be shown in tabular form with the chart. Axes: Option is used to change layout and formatting of each axes. Grid lines: Option is being used to show and hide the grid lines in the chart on horizontal and vertical axes. Plot Area: Option is being used to change the background of the chart with gradient and solid colors etc. Trend line: Shows the trends between data series from beginning to end.

Understanding Chart Formatting: Shape styles: To apply a style to overall chart inserted. Fill shape, Shape outline and Shape effects: are used to apply colors to the chart area, bordered lines to the chart and glow effects respectively. Word art styles: are used to change the format of the elements of charts.

Presentations in MS PowerPoint Slide show setup options: PowerPoint has various options for setting up and playing a slide show. Slide show means to show a full-screen presentation. To access slide show setup options: Got to Slide Show tab and click the Set Up Slide Show command. The Set Up Show dialog box will appear. Click the buttons in the interactive below to learn about the various options available for setting up and playing a slide show. Click OK to apply the settings. Rehearse Timings: This option launches a full-screen size slide show in which you can rehearse you presentation and the amount of time you spend on each slide is recorded and you can save those timings to run the show automatically in the future. It is used where if you are unable to present your slide show, PowerPoint's Record Slide Show feature allows you to record narration. Click the Rehearse Timings command. You will be taken to a full-screen view of your presentation. Practice presenting your slide show. When you're ready to move to the next slide, click the Next button on the Recording toolbar in the top-left corner. If you prefer, you can also use the right arrow key.

When you've reached the end of the show, press the Esc key to end your slide show. A dialog box will appear with the total time of your presentation.

If you are ok with your timings, click Yes.

If you need more than one try to get the timings just right, the Recording toolbar has options to let you take a break or start over on a slide. To pause the timer, click the pause button on the toolbar. No actions taken while the timer is paused will be included in the timings. To re-record the timings on the current slide, click the repeat button.

Recording your slide show: The Record Slide Show feature is similar to the Rehearse Timings feature, but it's more comprehensive. If you have a microphone for your computer, you can even record voiceover narration for the entire presentation. This is useful if you plan on using your slide show for a self-running presentation or a video. Your mouse won't show up on screen in recorded slide shows, so if you want to point out details on screen, you can use PowerPoint's laser pointer option. To record a slide show: Click the Slide Show tab, and locate the Set Up group. Click the Record Slide Show drop-down arrow. Select either Start Recording from Beginning or Start Recording from Current Slide. The Record Slide Show dialog box will appear. Select the desired options. Remember, you can only record narration if you have a microphone attached to your computer. Click Start Recording. Your presentation will open up to a full-screen view. Perform your slide show. Make sure to speak clearly into the microphone if you are recording narration. When you are ready to move to the next slide, click the Next button on the Recording toolbar in the top-left corner, or use the right arrow key.

When you reach the end of the show, press the Esc key to exit. Your slide show timings and narration are now included in your presentation. The slides with narration will be marked with a speaker icon in the bottom-right corner. Customizing your slide show: Sometimes you might want to hide a slide while still keeping it in your presentation. For instance, if you are presenting a slide show to more than one group of people, hiding or even rearranging certain slides can help you tailor your slide show to each group you present it to. You could also choose to create a shortened version of your slide show to present when you're short on time. The Custom Slide Show feature allows you to create and name different versions of your slide show with hidden or rearranged slides. To create a custom show: Select the Slide Show tab, and locate the Start Slide Show group. Click the Custom Slide Show command. Select Custom Shows. The Custom Shows dialog box will appear. Click New. The Define Custom Show dialog box will appear. Locate the Slide show name box, and type a name for your custom show. Select the slides in the Slides in presentation: box that you want to include in your custom show, then click Add to add them to the Slides in custom show: box. If necessary, use the up and down arrows to reorder the added slides.