JSS 3 FIRST TERM 2023 WEEK EIGHT LESSON NOTE

 

Jss 3

TOPIC: Charts and Graphs  

OBJECTIVE:

At the end of this topic, you should be able to:

1. Insert a chart on excel spreadsheet.

2. State the types of charts                 

Introduction

A chart, also called graph is a graphical representation of data, in which the data is represented by symbols such as lines in a line chart, or slices in a pie chart.

A chart can represent tabular numeric data, functions or some kind of qualitative structure and provides different information.

 

How to insert a Chart

1.     Select the cells with data you want to include in your chart. Note: to make labels on your chart, remember to add a header row or column to your data.

2.     Click on “insert” on the menu bar

3.     Choose the chart type from the chart section

 

Types of Chart

1.     Pie chart: they are used to show percentages

 

2.     Column chart: they are also known as bar graphs, used to show comparisons between items of data.

 

3.     Bar chart: they are suitable charts types for comparing multiple values. Unlike column chart the bars or column run horizontally along the page rather than vertically.

 

4.     Line chart: they are also called line graphs, they are used to show trends over time. Each line in the graph shows the changes in the value of one item of data. 





COLUMN CHART


BAR CHART







Comments

Post a Comment

Popular posts from this blog

JSS 2 WEEK TWO LESSON NOTE_FIRST TERM 2023

Image
  Jss2 TOPIC: CLASSIFICATION OF COMPUTER BY GENERATION OBJECTIVE At the end of this topic you should be able to:  1. List the criteria for classifying computers.          I.                   2. State the features of computers classified based on technological age. Introduction Computers can be classified into different categories based on different criteria. Basically, computers can be classified based on the following criteria: 1.      Size. 2.      Types 3.      Generation 4.      Purpose or versatility Based on the technological Age of the computer, computers can be classified into: ·         First generation ·         Second generation ·         Th...
Read more

SSS TWO WEEK TWO LESSON NOTE (ICT_223)

Image
  Ss2 TOPIC:   HANDLING COMPUTER FILES Introduction File operation deals with the physical movement of data in and out of files. User programs effectively use file operations through appropriate programming language syntax. The file management system manages the independent files and acts as the software interfaces between the user programs and file operations. Basic Operations of Computer Files 1.     Insertion: records must be inserted at the place dictated by the sequence of the keys. As   obvious, direct insertion into the main data file would   lead to frequent rebuilding of the file. This problem could be mitigated by reserving overflow areas in the file for insertions. But this leads to wastage of space and also the overflow areas may also be filled. 2.     Deletion: deletion is the reverse of insertion. The space occupied by the record should be free for use. 3.     Updating: updating is a combinat...
Read more

JSS ONE WEEK THREE LESSON NOTE (ICT_223)

Image
  Jss1 TOPIC:   MASTERY OF THE KEYBOARD Introduction A computer keyboard is the most commonly used input device. It is defined as the set of typewriter-like keys that enables you to enter data into a computer or other devices. Computer keyboard are similar to electric-typewriters but contain additional typing keys. The standard arrangement of alphabetic keys on the keyboard is known as the QWERTY. The computer keyboard could be wired or wireless. Types of keyboard There are different types of keyboard depending on what they are used for. Some have more keys than the others. Keyboards also come in different shapes but basically a keyboard has regular shape. The types of keyboards are: a)      Enhanced keyboard b)     Standard keyboard   c)      Windows keyboard d)     AT keyboard   Sections of the Keyboard The keyboard is divided into the following sections: ...
Read more