Spreadsheet Applications II: How to Use Functions, Charts, and Data Analysis in Microsoft Excel — SSS 1 Computer Studies
INTRODUCTION
Picture this: Mr. Adeyemi runs a small shop in Oshodi Market, Lagos. Every week, he spends three hours adding up sales figures, calculating profits, and trying to figure out which product is selling the most. Then one day, his daughter — an SSS 1 student — opens Microsoft Excel on her laptop, enters the numbers, types a few formulas, and within two minutes, produces a colourful chart showing exactly which product brought in the most money that month.
That is the power of a spreadsheet application.
In today's world, data is everywhere. From school report cards to hospital records, from market sales to government budgets, numbers tell stories — but only if you know how to read them. Microsoft Excel and similar tools like Google Sheets and LibreOffice Calc give you the ability to not just store numbers, but to make sense of them.
In SSS 1 Computer Studies, Spreadsheet Applications II builds on what you already know about basic spreadsheet operations. This time, you go deeper: functions, charts, and data analysis. These are the real skills that employers look for, that JAMB and WAEC test you on, and that will genuinely help you manage information in everyday Nigerian life.
Let us get into it.
LEARNING OBJECTIVES
By the end of this lesson, students should be able to:
- Define and explain the concept of spreadsheet functions and their syntax
- Identify and use common functions such as SUM, AVERAGE, COUNT, MAX, MIN, and IF
- Create different types of charts and graphs from spreadsheet data
- Explain the steps involved in data sorting and filtering
- Demonstrate how to use basic data analysis tools in Microsoft Excel
- Apply spreadsheet skills to solve real-life problems related to Nigerian daily life
WHAT ARE SPREADSHEET FUNCTIONS?
A function in a spreadsheet is a pre-written formula that performs a specific calculation automatically. Instead of doing a long and tedious calculation by hand, you simply type the function name, tell it which cells to work on, and it gives you the result instantly.
Every function follows a basic structure called syntax:
= FUNCTION NAME (arguments)
The equals sign (=) tells Excel that you are entering a formula. The function name tells Excel what to calculate. The arguments are the values or cell references the function will use.
For example: =SUM(A1:A10) adds up all the numbers from cell A1 to A10.
Simple, right? Now let us look at the most important functions you need to know for SSS 1.
COMMON SPREADSHEET FUNCTIONS AND HOW TO USE THEM
1. SUM Function
The SUM function adds a group of numbers together.
Syntax: =SUM(number1, number2, ...) or =SUM(A1:A10)
Nigerian Example: Imagine you are the class prefect at Government Secondary School, Enugu, and you recorded the scores of 10 students in a Math test. To find the total of all scores, you type =SUM(B2:B11) and Excel adds them all instantly.
2. AVERAGE Function
This calculates the mean (average) of a group of numbers.
Syntax: =AVERAGE(A1:A10)
Nigerian Example: Your teacher wants to know the average mark of your class after a Computer Studies test. Instead of adding all the marks and dividing manually, you type =AVERAGE(C2:C31) and the answer appears in seconds.
3. COUNT Function
COUNT counts how many cells contain numbers in a selected range.
Syntax: =COUNT(A1:A10)
Nigerian Example: A school administrator at Lagos State Model College wants to count how many students submitted their first term scores. Using COUNT, the spreadsheet tells her exactly how many entries have been recorded.
4. MAX and MIN Functions
MAX finds the highest value in a range, while MIN finds the lowest.
Syntax: =MAX(A1:A10) and =MIN(A1:A10)
Nigerian Example: Your school held a inter-house sports competition across four houses — Red, Blue, Green, and Yellow. To find which house scored the highest and which scored the lowest, you use =MAX and =MIN on the score column. Done in seconds.
5. IF Function
The IF function is one of the most powerful functions in Excel. It checks whether a condition is true or false, and gives different results depending on the answer.
Syntax: =IF(condition, value_if_true, value_if_false)
Nigerian Example: After a test, you want Excel to automatically write "Pass" if a student scores 40 and above, or "Fail" if they score below 40. You type:
=IF(B2>=40, "Pass", "Fail")
Excel will check each student's score and type either Pass or Fail automatically. This is exactly how many teachers in Nigerian secondary schools now generate results quickly.
6. COUNTA Function
Unlike COUNT (which only counts numbers), COUNTA counts all non-empty cells, including text.
Syntax: =COUNTA(A1:A20)
Nigerian Example: You are tracking which students submitted a take-home assignment. Some cells have names, others are blank. COUNTA counts everyone who submitted, whether you recorded their score or just their name.
UNDERSTANDING CELL REFERENCES IN FUNCTIONS
Before going further, it is important to understand two types of cell references:
Relative Reference: When you copy a formula to another cell, the reference adjusts automatically. For example, =SUM(B2:B10) becomes =SUM(C2:C10) when copied to the next column.
Absolute Reference: When you want a cell reference to remain fixed even when the formula is copied, you add a dollar sign ($). For example, =B2*$D$1 will always refer to cell D1 no matter where you paste the formula.
This is especially useful when you are calculating something like a fixed tax rate or a school fee percentage across many rows.
CHARTS AND GRAPHS IN SPREADSHEET APPLICATIONS
Numbers alone can be hard to understand. That is why spreadsheet applications allow you to turn data into visual charts and graphs. A well-designed chart can show trends, comparisons, and patterns at a glance — something a long column of numbers cannot do easily.
Types of Charts in Excel
Bar Chart / Column Chart
Used to compare values across different categories.
Nigerian Example: Comparing the number of students enrolled in JSS, SSS 1, SSS 2, and SSS 3 at a federal government college.
Line Chart
Used to show trends over time — how something changes from one period to another.
Nigerian Example: Tracking monthly rainfall in Abuja over 12 months, or a student's performance across first, second, and third terms.
Pie Chart
Used to show how a whole is divided into parts.
Nigerian Example: Showing the percentage breakdown of a family's monthly budget — food, school fees, transport, and savings — using data from a Nigerian household.
Scatter Chart
Used to show the relationship between two sets of data.
Nigerian Example: A researcher plotting student study hours against exam scores to see if more study time leads to better results.
How to Create a Chart in Excel
Creating a chart in Excel is straightforward once you have your data ready. Here are the steps:
- Enter your data neatly into rows and columns
- Select (highlight) the data you want to include in the chart — including headings
- Click on the Insert tab at the top of the screen
- In the Charts group, choose the type of chart you want (Column, Line, Pie, etc.)
- Excel will automatically generate the chart on your spreadsheet
- Use the Chart Tools that appear to customise your chart — add a title, change colours, and adjust labels
- Move the chart to a suitable position on your sheet
Pro Tip: Always give your chart a clear title and label your axes. A chart without labels confuses readers instead of helping them.
DATA ANALYSIS IN SPREADSHEET APPLICATIONS
Data analysis simply means examining raw data to find useful information, patterns, or conclusions. In Excel, there are basic tools that make this process much easier, even for students.
Sorting Data
Sorting means arranging data in a particular order — either alphabetically (A to Z or Z to A) or numerically (smallest to largest or largest to smallest).
How to Sort in Excel:
- Click anywhere inside your data
- Go to the Data tab
- Click Sort A to Z (ascending) or Sort Z to A (descending)
- You can also sort by multiple columns using the custom Sort option
Nigerian Example: A school administrator in Kaduna wants to arrange students alphabetically for the exam timetable. Instead of doing this manually, she selects the name column and clicks Sort A to Z.
Filtering Data
Filtering allows you to display only the rows that meet a specific condition, hiding the rest temporarily.
How to Filter in Excel:
- Click anywhere in your data
- Go to the Data tab and click Filter
- Small arrows will appear at the top of each column
- Click the arrow on the column you want to filter
- Select the specific value or condition you want to display
Nigerian Example: A teacher has a spreadsheet of 200 students. She wants to see only those who scored below 40 in Mathematics. Using Filter, she selects the score column, sets a condition for values less than 40, and instantly sees only those students.
Conditional Formatting
Conditional formatting automatically changes the colour or style of a cell based on its value. This makes it very easy to spot trends and outliers at a glance.
Nigerian Example: A teacher applies conditional formatting to a result sheet so that every score below 40 appears in red and every score above 70 appears in green. Without reading individual figures, she can immediately see who needs extra attention.
How to Apply It:
- Select the range of cells you want to format
- Click Home → Conditional Formatting
- Choose a rule (e.g., Highlight Cells Rules → Less Than)
- Type the value and choose a formatting colour
- Click OK
PRACTICAL APPLICATIONS IN REAL NIGERIAN LIFE
Spreadsheet functions, charts, and data analysis are not just classroom exercises. They have direct uses in everyday Nigerian settings:
- Schools: Teachers use Excel to compute student results, generate reports, and track attendance
- Markets and Shops: Small business owners in markets like Alaba International or Onitsha Main Market use spreadsheets to track sales, expenses, and profit
- Government Offices: Civil servants in MDAs (Ministries, Departments and Agencies) use Excel to manage budgets and generate financial reports
- Hospitals: Medical staff use spreadsheets to track patient records, drug inventory, and daily admissions
- Agriculture: Farmers and cooperatives use Excel to monitor crop yield, input costs, and profits — increasingly common in states like Kano, Benue, and Cross River
- Banking and Finance: Accountants in banks like First Bank, GTBank, and Zenith Bank work with spreadsheet tools daily
ADVANTAGES AND DISADVANTAGES OF USING SPREADSHEET FUNCTIONS
Advantages
- Saves time by performing calculations automatically
- Reduces human errors in arithmetic
- Makes it easy to update data — change one figure and all formulas recalculate instantly
- Charts make complex data easy to understand visually
- Can handle large volumes of data efficiently
- Useful for planning, budgeting, and forecasting
Disadvantages
- A wrong formula can produce incorrect results without you noticing
- Requires some level of training to use correctly
- Large spreadsheet files can slow down a computer
- Spreadsheets are not ideal for very complex databases
- Formatting errors can make data misleading if charts are not properly labelled
SAFETY AND ETHICAL CONSIDERATIONS
Using spreadsheet applications responsibly matters, especially when dealing with real data.
Data Privacy: If you are managing a spreadsheet that contains people's personal information — names, scores, salaries, health records — keep that information confidential. Do not share such files carelessly or post screenshots on social media.
Data Accuracy: Always double-check the data you enter. A wrong figure in a formula can affect every result in the sheet. In real-life situations like hospital drug dosages or financial reports, an error can have serious consequences.
Avoiding Manipulation: Charts can be made to look misleading if the scale or labels are deliberately adjusted. Always present data honestly and accurately.
Copyright and Licensing: If you are using spreadsheet templates or datasets created by others, ensure you have permission to use them.
CLASSROOM AND HOME ACTIVITIES
Activity 1: The Class Result Sheet
Open Microsoft Excel or Google Sheets. Create a result sheet for a class of 10 imaginary students. Include columns for Student Name, English Score, Mathematics Score, Science Score, and Average Score. Use the AVERAGE function to calculate each student's average. Then use the IF function to write "Pass" or "Fail" beside each student's name based on whether their average is 40 or above.
Activity 2: Build a Chart
Using the result sheet from Activity 1, create a column chart comparing the Mathematics scores of all 10 students. Add a title, label the axes, and change the chart colour. Then try creating a pie chart showing the percentage of students who passed versus those who failed.
Activity 3: Sorting and Filtering
Enter the names and scores of 15 students in a new sheet. Use the Sort feature to arrange them from highest to lowest score. Then use the Filter feature to display only students who scored above 60.
Activity 4: Home Budget Simulation
Imagine you are managing your family's monthly budget of ₦150,000. Create a spreadsheet with these categories: Food, School Fees, Transport, Electricity, Airtime/Data, and Savings. Assign amounts to each. Use SUM to calculate the total and a pie chart to show the proportion of each category. Share your chart with your teacher for review.
ASSESSMENT QUESTIONS
Objective Questions
1. Which of the following functions finds the highest value in a range of cells? A. MIN B. COUNT C. MAX D. AVERAGE
Answer: C
2. What is the correct syntax for a SUM function covering cells A1 to A20?
A. =SUM{A1-A20} B. =SUM(A1:A20) C. =ADD(A1,A20) D. =TOTAL(A1 TO A20)
Answer: B
3. Which type of chart is most suitable for showing how a student's performance changed over three school terms?
A. Pie Chart B. Column Chart C. Line Chart D. Scatter Chart
Answer: C
4. The IF function returns __________ depending on whether a condition is true or false.
A. Only numbers B. Only text C. Different values based on the condition D. The average of two values
Answer: C
5. Conditional formatting is used to:
A. Change the formula in a cell B. Count the number of cells with data C. Automatically format cells based on their values D. Delete empty rows in a spreadsheet
Answer: C
Theory Questions
1. Explain the difference between the COUNT and COUNTA functions. Give one Nigerian example showing when you would use each one.
2. Describe the steps you would follow to create a pie chart in Microsoft Excel. Why is it important to label a chart properly?
3. What is meant by data filtering in a spreadsheet? Describe a real-life situation in a Nigerian school or office where filtering would be useful, and explain how you would apply it step by step.
SUMMARY
In this lesson, we covered the following key points:
- Spreadsheet functions are pre-written formulas that perform calculations automatically using a specific syntax
- Common functions include SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, and IF — each serving a different purpose
- Charts and graphs (bar, line, pie, scatter) help visualise data and identify patterns quickly
- Sorting arranges data in a specific order, while filtering displays only data that meets a set condition
- Conditional formatting highlights cells automatically based on their values
- These tools have direct real-life applications in Nigerian schools, markets, hospitals, banks, and government offices
- Responsible and ethical use of spreadsheet data is essential, especially regarding privacy and accuracy
CONCLUSION
Spreadsheet Applications II opens a new level of thinking about data. When you understand how to use functions, build charts, and analyse information, you stop being someone who just reads numbers — you become someone who understands what those numbers mean.
These skills are relevant for every Nigerian student, regardless of what career you eventually pursue. Whether you end up in medicine, agriculture, business, engineering, or public service, working with data will always be part of your life. The good news is that Excel — and tools like it — are designed to make that job easier.
Practice these functions regularly, experiment with different chart types, and always ask yourself: what story is this data telling? That question is at the heart of data analysis — and it is a habit that will serve you well beyond the classroom.
FREQUENTLY ASKED QUESTIONS (FAQ)
Q1: What is the difference between a formula and a function in Excel? A formula is any calculation you write manually, such as =A1+A2+A3. A function is a built-in shortcut that does the same kind of calculation automatically, such as =SUM(A1:A3). Functions are faster, cleaner, and less prone to errors.
Q2: Can I use spreadsheet functions on Google Sheets or only on Microsoft Excel? Most of the functions discussed in this lesson — SUM, AVERAGE, COUNT, IF, MAX, MIN — work exactly the same way in Google Sheets, LibreOffice Calc, and Microsoft Excel. The interface looks slightly different, but the syntax is the same.
Q3: Is Spreadsheet Applications included in WAEC Computer Studies topics? Yes. Spreadsheet Applications is a key topic in both WAEC and NECO Computer Studies syllabuses. Students are expected to understand functions, chart creation, and basic data operations. Practising these skills thoroughly will help you perform well in practical and theory examinations.
Q4: What is the easiest chart to create for a school project? For most school projects, a column chart or bar chart is the easiest and most effective option. It is straightforward to create, easy to read, and works well for comparing different categories — such as student scores, monthly sales, or population figures by state.
Q5: How do I avoid making mistakes when using the IF function? Make sure the condition is written clearly and that you use quotation marks around any text values in the result. For example, in =IF(B2>=40,"Pass","Fail"), both "Pass" and "Fail" must be in quotes because they are text. Also, test your formula on a few cells manually before applying it to the entire column.
Q6: Can spreadsheet skills help me get a job in Nigeria? Absolutely. Many employers in Nigeria — including banks, telecoms companies, government agencies, NGOs, and private businesses — list Microsoft Excel as a required or preferred skill. Roles in data entry, accounting, administration, teaching, logistics, and marketing all use Excel regularly. Learning it now gives you a genuine advantage.
.jpg)
0 Comments