Lesson Notes By Weeks and Term v3 - Junior Secondary 3
Graphs
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Graphs
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Subject: Information Technology (IT)
Class: Junior Secondary 3
Term: 2nd Term
Week: 8
Theme: Computer Application Packages
This page supports the lesson note with a companion video and a short classroom-ready summary.
For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.
construct standard graphs and charts from given records in a worksheet; edit and for mat the graphs and charts; identify and select data range and area for graph constructing.
| JSS3A | 75 | | JSS3B | 68 | | JSS3C | 82 |
1. Identify and Select Data Range (Performance Objective 3): Open the spreadsheet containing the data. Click and drag the mouse to select all the data, including the column headers (e.g., "Class" and "Average Score (%)") and the numerical values. In this example, select cells `A1` to `B4`.
Rationale: Selecting headers ensures the chart has meaningful category and series names.
2. Insert Chart (Performance Objective 1): Go to the `Insert` tab on the Excel ribbon. In the `Charts` group, select the desired chart type. For comparing scores across classes, a `Column Chart` or `Bar Chart` is suitable. Click on `Recommended Charts` for suggestions or choose directly (e.g., `2-D Clustered Column`).
Outcome: A basic chart will appear on the worksheet, displaying the selected data.
F. Step-by-Step: Editing and Formatting a Graph (Performance Objective 2) Using the chart created above, let's enhance its appearance and clarity.
1. Changing Chart Type: Click on the chart to select it. Go to the `Chart Design` tab (appears when a chart is selected). Click `Change Chart Type`. Select a different chart type (e.g., `Pie` to show the proportion of each class's score relative to the total average score, though a column chart is better for direct comparison here). Click `OK`.
2. Adding/Modifying Chart Title: Click on the existing chart title (if present, often defaults to "Chart Title"). Type in a descriptive title (e.g., "JSS3 IT Exam Average Scores - 2nd Term").
To add a title if none exists: Click the `+` button (Chart Elements) next to the chart, then check `Chart Title`.
3. Adding/Modifying Axis Titles: Click the `+` button (Chart Elements) next to the chart. Check `Axis Titles`.
Two text boxes will appear: one for the horizontal axis and one for the vertical axis. Click on the horizontal axis title and type `Class`. Click on the vertical axis title and type `Average Score (%)`.
4. Changing Legend Position: Click the `+` button (Chart Elements) next to the chart. Hover over `Legend`, then click the arrow next to it. Choose a position (e.g., `Right`, `Top`, `Bottom`). For a single data series like this, a legend might not be strictly necessary.
5. Adding Data Labels: Click the `+` button (Chart Elements) next to the chart. Check `Data Labels`. This will display the actual average scores on top of each column.
6. Changing Colours/Styles: Select the chart. Go to the `Chart Design` tab. In the `Chart Styles` group, choose from various pre-defined styles or colour palettes.
To change individual column colours: Click on a column once to select the entire data series, then click again on a specific column to select only that column. Right-click, select `Format Data Point`, then choose `Fill & Line` to change colour.
7. Resizing and Moving the Chart: To resize: Click on the chart, then drag one of the sizing handles (circles) at the corners or sides.
To move: Click and drag the chart from its border to a new location on the worksheet or to a new sheet. This section provides a detailed explanation of graphs and charts in the context of spreadsheet applications, along with step-by-step instructions for their creation and modification. A. What are Graphs and Charts? Graphs and charts are visual representations of numerical data. They make complex data easier to understand, analyze, and compare, helping to reveal patterns, trends, and relationships that might not be obvious in raw data tables. In IT, these are typically created using spreadsheet software like Microsoft Excel, Google Sheets, or LibreOffice Calc.
B. Importance of Graphs: Clarity: Present large amounts of data in a concise and understandable format.
Impact: Make data more engaging and memorable.
Trends: Easily show trends, comparisons, and relationships over time or across categories.
Decision Making: Facilitate quick analysis and informed decision-making.
Communication: Effectively communicate findings to others.
C. Common Types of Graphs/Charts and Their Uses: The choice of chart type depends on the data and the message one wants to convey.
1. Column Chart: Use: Compares values across different categories. Ideal for showing changes over a period of time.
Example: Monthly sales figures for different locally made snacks in a Nigerian market (e.g., Puff-Puff, Akara, Chin-Chin).
2. Bar Chart: Use: Similar to column charts but categories are displayed on the vertical axis and values on the horizontal axis. Useful when category names are long.
Example: Comparing the number of students enrolled in various vocational skills programs (e.g., tailoring, carpentry, ICT, catering) in a community.
3. Line Chart: Use: Shows trends in data over a continuous period (e.g., months, years). Effective for tracking changes or progress.
Example: Tracking the average price of a bag of rice in a Nigerian city over 12 months.
4. Pie Chart: Use: Shows proportions or percentages of a whole. Each "slice" represents a category's contribution to the total.
Example: Displaying the percentage distribution of different crop types harvested on a farm (e.g., yam, cassava, maize, millet).
5. Area Chart: Use: Similar to line charts but the area between the line and the axis is filled, emphasizing the magnitude of change over time.
Example: Showing the total electricity consumption (cumulative) in a neighbourhood over a year, broken down by quarters.
D. Key Components of a Graph: Understanding these components is essential for constructing and interpreting graphs.
1. Chart Title: Describes the main topic of the graph (e.g., "Student Enrolment by Class, 2023").
2. Axis Titles: Labels for the X-axis (horizontal) and Y-axis (vertical).
X-Axis (Category Axis): Represents categories or independent variables (e.g., "Months", "Classes").
Y-Axis (Value Axis): Represents numerical values or dependent variables (e.g., "Number of Students", "Sales (₦)").
3. Data Series: The set of data points plotted in the chart. Each series is usually represented by a distinct colour, line, or bar.
4. Legend: Identifies the data series by name and their corresponding colours/patterns. Crucial when there are multiple data series.
5. Gridlines: Horizontal or vertical lines that extend from the axis values across the plot area, making it easier to read values.
6. Data Labels: Actual values displayed directly on or next to the data points, bars, or slices.
7. Plot Area: The area where the data series is plotted.
8. Chart Area: The entire area occupied by the chart, including titles, legend, and plot area.
E. Step-by-Step: Constructing a Graph (using MS Excel as an example)
Scenario: A teacher wants to visualize the performance of JSS3 students in the 2nd Term IT examination across different classes (A, B, C). | Class | Average Score (%) | | :---- | :---------------- | | JSS3A | 75 | | JSS3B | 68 | | JSS3C | 82 |
1. Identify and Select Data Range (Performance Objective 3): Open the spreadsheet containing the data. Click and drag the mouse to select all the data, including the column headers (e.g., "Class" and "Average Score (%)") and the numerical values. In this example, select cells `A1` to `B4`.
Rationale: Selecting headers ensures the chart has meaningful category and series names.
2. Insert Chart (Performance Objective 1): Go to the `Insert` tab on the Excel This section outlines the activities for both the teacher and the students to ensure an interactive and effective learning experience.
Phase 1: Introduction and Prior Knowledge Recall (10 minutes)
Teacher Activity: Begin by asking students to recall where they might have seen graphs or charts (e.g., newspapers, TV news, textbooks, school reports, market price boards). Ask them what they think the purpose of these visual representations is. Briefly introduce the topic "Graphs" in IT, explaining its relevance to understanding data easily, especially in a digital context. Display a simple data table (e.g., rainfall over months in a Nigerian state) and ask how they would visually represent it to make comparisons easier.
Student Activity: Share examples of graphs/charts they have encountered. Discuss the purpose of graphs in their own words. Participate in the discussion about data visualization.
Phase 2: Explanation of Key Concepts (20 minutes)
Teacher Activity: Explain what graphs and charts are, emphasizing their importance in simplifying complex data. Introduce common types of charts (column, bar, line, pie) with examples relevant to Nigerian contexts (e.g., student enrolment, agricultural yield, sales figures). Carefully explain the key components of a chart: chart title, axis titles, data series, legend, gridlines, data labels, plot area, chart area. Use a drawn chart on the board or a projected image to point out each component clearly. Emphasize that the choice of chart type depends on the data and the message to convey.
Student Activity: Listen attentively and take notes on the definitions and uses of different chart types and their components. Ask clarifying questions. Identify components as the teacher points them out.
Phase 3: Practical Demonstration - Constructing a Graph (25 minutes)
Teacher Activity: Demonstrate step-by-step how to identify and select data range and area for graph construction. Use a projector connected to a computer running MS Excel (or draw clear diagrams on the board if no projector). Use a realistic Nigerian dataset (e.g., "Monthly Sales of Sachet Water" or "Number of Students Participating in Inter-House Sports"). Demonstrate step-by-step how to construct a standard graph/chart from the selected data. Show how to go to the `Insert` tab, choose `Recommended Charts`, and select an appropriate chart type (e.g., Column Chart). Explain the role of the selected data range in determining the graph's content.
Student Activity: Observe the demonstration keenly, taking notes on the steps involved in selecting data and constructing a basic chart. Mentally follow along, identifying which cells are being selected and why. Ask questions about any unclear steps.
Phase 4: Practical Demonstration - Editing and Formatting a Graph (25 minutes)
Teacher Activity: Using the graph just created, demonstrate step-by-step how to edit and format the graph.
Show how to: Change the chart title. Add/modify axis titles (X and Y). Change the chart type. Add/remove/reposition the legend. Add data labels. Change colours, fonts, and chart styles. Resize and move the chart. Emphasize the importance of clear labeling and appropriate formatting for effective communication.
Student Activity: Observe the formatting demonstration, noting down the steps for each modification. Understand how different formatting options enhance readability and presentation. Recognize the `Chart Design` and `Format` tabs in Excel.
Phase 5: Guided Practice (20 minutes)
Teacher Activity: Provide a new small dataset (e.g., "Yield of different crops in a local farm"). Guide students through a structured exercise where they, as a class or in pairs (if computers are available), identify the data range, select a chart type, and then add a title and axis labels. Provide immediate feedback and clarification.
Student Activity: Work in pairs or individually to select the data, insert a chart, and perform basic editing as guided by the teacher. Discuss approaches and challenges with peers. Seek assistance from the teacher as needed.
Phase 6: Recap and Conclusion (10 minutes)
Teacher Activity: * Summarize the key learning points: how to select data, construct various chart types, and edit/format charts for are available), identify the data range, select a chart type, and then add a title and axis labels. Provide immediate feedback and clarification.
Student Activity: Work in pairs or individually to select the data, insert a chart, and perform basic editing as guided by the teacher. Discuss approaches and challenges with peers. Seek assistance from the teacher as needed.
Phase 6: Recap and Conclusion (10 minutes)
Teacher Activity: Summarize the key learning points: how to select data, construct various chart types, and edit/format charts for clarity. Reiterate the importance of graphs in various real-life scenarios in Nigeria. Assign independent practice questions.
Student Activity: Ask any remaining questions. Review their notes. * Prepare for independent practice.
Understanding and creating graphs is a highly transferable skill with numerous applications in Nigerian contexts: Economic Analysis and Business: Local Market Trends: Small businesses (e.g., a tailor, a restaurant owner, a farmer selling produce) can use graphs to track weekly or monthly sales of specific products (e.g., rice, yam, fabrics, local dishes). A line chart could show sales fluctuations, while a bar chart could compare sales of different products. This helps them identify peak seasons, manage inventory, and make pricing decisions.
Budgeting: Community development projects or local government councils can use pie charts to show how funds are allocated across different sectors (e.g., education, health, infrastructure) in a budget, promoting transparency and accountability.
Health and Community Development: Public Health Campaigns: Health workers can create line charts to show the trend of immunization rates over time in a community or compare disease prevalence across different villages using bar charts. This helps in assessing the effectiveness of health interventions and allocating resources where needed most. For example, visualizing the decline in polio cases in Nigeria over years.
Social Surveys: NGOs or community leaders conducting surveys (e.g., on access to clean water, school enrolment rates, sanitation practices) can use various charts to present their findings, making complex social data accessible to a wider audience, including policymakers and community members.
Education and Research: School Performance: Teachers and school administrators can use graphs to visualize students' academic performance over terms or compare average scores across different subjects or classes. A line chart can show a student's progress over time, while a column chart can compare class performance in specific subjects.
Academic Projects: Students, even at the JSS3 level, can apply these skills in their project work (e.g., collecting data on waste generation in their school and presenting findings with graphs to advocate for better waste management).