Page 39 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes (c) Move your cursor to the Category X-axis labels box. This is an important feature;
we assign the labels or categories to the X-axis here. One way is to type in the
cells that contain our label names (or categories or numbers). Use the cells D3:D9
since they are the values of our random variables. You can use the red arrows
or simply put your cursor in the box and highlight the appropriate cells. Click
on “next” to go to Chart Wizard step 3.
4. In Chart Wizard Step 3 we continue formatting and labeling the graph. You don’t
have to get it exactly right in this step as it is easy to modify the graph later. Title
the graph “Number of Siblings”. Label the X-axis, “No. of Siblings”, and label the
Y-axis “No. of Students”. Notice the other tabs at the top of this dialog box—Axes,
Gridlines, Legend, etc. Look at each of these and experiment. Click on Next to go
to the last step.
5. Step 4 in Chart Wizard asks whether we want the chart on the worksheet we are
working with, in this case, Siblings, or put the graph on a new worksheet. Leave it
on the “Siblings” worksheet and finish.
6. Adjust the graph to a convenient size. You do that by dragging the black squares,
called sizing handles, found around the chart. If those squares aren’t there, you can
make them appear by selecting the chart with a mouse click. Then reposition the
chart to a convenient place on your worksheet.
7. You should now have a graph similar to the one below. Don’t worry too much if
yours isn’t perfect. Part of your assignment for this module is to change it anyway.

Number of Siblings
12
No. of Siblings 8 6 4 siblings
10

0 2
0 1 2 3 4 5 6
No. of Siblings

Questions:
1. Explain the concept of Histogram.
2. What is graphical representation of data?

2.3 Summary

• In octal number system their are only eight symbols or digits i.e. 0, 1, 2, 3, 4, 5, 6,
7, 8.
• In hexadecimal number system each position represent a power of the base 16.
• Graphical representation of data i.e. bar graph, excel chart wizard etc.

2.4 Keywords

Binary number system: It is like a decimal number system, except that the base is 2, instead
of 10 which use only two symbols (0 and 1).
n-bit number: An n-bit number is a binary number consisting of ‘n’ bits.
Decimal number system: In this system, base is equal to 10 because there are altogether
ten symbols or digits (0, 1, 2, 3, 4, 5, 6, 7, 8, and 9).

32 LOVELY PROFESSIONAL UNIVERSITY