SS 2 First Term

Learning Objectives

• Use mail merge and templates in a word processor.
• Use spreadsheet formulas and functions.
• Apply advanced features in presentations.
• Combine tools to integrate and share work.

Mail Merge and Templates

Mail merge is a word processing feature that allows you to create one main document and automatically generate multiple personalised copies using data from a list or database. It is widely used in schools, offices, banks and businesses. The three components of a mail merge are a main document, a data source and merge fields. The main document is the letter or certificate template containing blank fields. The data source is a list of names, addresses and other details, often stored in a spreadsheet. The merge fields are placeholders in the main document where the data is inserted. To create a mail merge, prepare the data source, open the word processor and create the main document, insert merge fields where personalised data should appear, connect the document to the data source, preview the merged documents, and then print or save them.

A template is a pre-designed document with a fixed layout, fonts, colours and placeholder text. Templates save time and ensure consistency across documents. Common templates include school report cards, certificates, letterheads, invoice forms and newsletters. Most word processors and presentation tools come with built-in templates, and users can also create and save their own custom templates. For example, a school secretary who must send 150 appointment letters to new staff can create one template letter, set up a spreadsheet with the staff names and details, and use mail merge to produce all 150 personalised letters in minutes rather than in days.

Spreadsheet Formulas, Functions and Pivot Tables

A formula in a spreadsheet starts with an equals sign (=) and uses cell references to perform calculations. For example, =A1 + B1 adds the values in cells A1 and B1. Formulas can use the arithmetic operators for addition, subtraction, multiplication and division, and they can reference any cell on the sheet. A function is a built-in formula that performs a specific task. Common functions include SUM, which adds all the numbers in a range, AVERAGE, which finds the arithmetic mean, COUNT, which counts the cells containing numbers, MAX, which returns the largest value, MIN, which returns the smallest value, and IF, which returns one result when a condition is true and another when it is false. Cell references can be relative, so A1 changes when copied to another cell, or absolute, so $A$1 stays fixed when copied. Understanding this distinction is important when copying formulas across rows and columns.

A pivot table is a tool that summarises large amounts of data into a compact report. It can group data, calculate totals and averages, count entries and create cross-tabulations without changing the original data. For example, if a school has 500 rows of test results, a pivot table can quickly show the average score per subject or the number of students per class. To create a pivot table, select the data range, insert a pivot table, drag fields into the rows, columns and values areas, choose the summary function, and then format and filter the table as needed.

Advanced Presentations and Productivity Suites

Modern presentation software offers features beyond simply putting text on slides. A slide master controls the default layout, fonts, colours and logo placement for all slides, ensuring consistency. Transitions are the visual effects that play between slides, such as fade, wipe or push. Animations are effects applied to individual elements on a slide, such as appear, fly in or emphasis. Speaker notes are private notes visible only to the presenter during the slideshow. The golden rule of presentation design is clarity, meaning that every visual element should support the message rather than compete with it.

Google Workspace and Microsoft 365 are the two most widely used productivity suites. Google Workspace includes Google Docs for word processing, Google Sheets for spreadsheets, Google Slides for presentations and Gmail for email, all cloud-based, with free personal accounts and real-time collaboration in a browser. Microsoft 365 includes Word, Excel, PowerPoint and Outlook, and is subscription-based, with full offline access through desktop apps and more advanced features. Both suites are widely used in Nigerian schools and businesses. Google Workspace is popular in education because of its free tier and easy collaboration, while Microsoft 365 is preferred in many offices for its advanced features and offline capability. Productivity tools are used daily for school administration, such as recording learner scores, for business communication, such as writing memos, for marketing, such as creating presentations, for event planning, such as building budgets and printing personalised invitations, for data analysis with pivot tables, and for remote teamwork with real-time co-editing from different locations.

Advanced Spreadsheet Skills

Every value in a spreadsheet lives in a cell, and each cell has a unique address made from its column letter and row number, such as A1 or C5. Formulas begin with an equals sign and perform calculations using these addresses. A formula that adds the values in cells B2 and C2 produces the result automatically, and if the values change, the result updates at once. This automatic recalculation makes spreadsheets far more useful than hand-written tables.

Charts turn spreadsheet data into pictures such as bar charts, line graphs and pie charts. A pie chart shows proportions, a bar chart compares groups, and a line graph shows trends over time. Charts make it much easier for an audience to understand large sets of numbers at a glance. Choosing the right chart for the data is a key spreadsheet skill used in business reports and school projects.

Advanced Word Processing and Presentation Features

A template is a pre-designed file with a fixed layout, fonts and colours that can be reused for many documents with the same style, such as school report cards, invoices or certificates. Using a template keeps documents consistent and saves the time of rebuilding the layout each time.

In presentation software, transitions control how one slide changes into the next, for example a fade or a slide-in effect. Animations control how individual elements on a slide appear, such as text appearing one line at a time or an image flying in. A slide master sets the theme, fonts and layout for the whole presentation at once, so every slide inherits the same professional look. The golden rule is clarity, every effect should support the message rather than distract.

Integration and Collaboration Tools

Modern productivity suites integrate tools so that data flows between word processing, spreadsheets and presentations. A chart made in a spreadsheet can be placed inside a report, and a table in a slide can stay linked to its source data. Integration saves time and keeps information consistent across different documents.

Collaboration tools allow teams to share documents with chosen people, co-author in real time and keep a full history of every change. The owner sets permissions that control who can view, comment or edit a document. Real-time co-authoring shows each person working on the file, and version history lets a team restore an earlier version if a mistake is made. Cloud office suites such as Google Workspace and Microsoft 365 make this possible from any device with an internet connection.

Formulas and References

A formula begins with an equals sign and may contain values, cell addresses, operators and functions. The result is shown in the cell and the formula is shown in the formula bar, so one set of figures can produce many results without retyping.

A relative reference changes when the formula is copied, so the formula in cell D2 written as equals B2 times C2 becomes equals B3 times C3 when it is dragged down one row. An absolute reference does not change and is written with dollar signs, as in $B$2. A mixed reference fixes one part only, as in B$2 or $B2.

An absolute reference is used for a constant that every calculation shares, such as a rate of tax. If the rate changes, changing the one cell updates every calculation, which is far better than editing every formula.

Statistical Functions

SUM adds the values in a range. AVERAGE gives the mean. MAX and MIN give the highest and the lowest value. COUNT counts the cells that hold numbers and COUNTA counts all the cells that are not empty.

ROUND rounds a value to a stated number of decimal places. MEDIAN gives the middle value in a sorted list and MODE gives the value that occurs most often. These functions are used when a report needs a figure that is fair to every learner, since one very high mark can distort a mean.

SUMIF adds the values that meet a stated condition and COUNTIF counts the values that meet a condition. Together they answer questions such as how many pupils scored above 50 and what is the total of the marks of those who scored below 40.

Logical, Text and Date Functions

IF tests a condition and gives one value when it is true and another when it is false. The condition is written first, then the value for true, then the value for false. A nested IF tests a second condition when the first fails.

AND and OR test several conditions at once and return true or false. NOT reverses a single condition. These classify pupils, for example as passing when the mark is at least 50.

Text functions work with the words in a cell. LEFT and RIGHT take characters from the ends of a word, LEN counts the characters, UPPER and LOWER change the case, CONCATENATE joins values into one cell and TRIM removes extra spaces.

Date functions work with dates. TODAY gives the current date and NOW gives the date and the time. DATE builds a date from three numbers. Two date arguments can be subtracted to find the number of days between two events.

Lookup Functions

A lookup function searches a table for a value and returns something from the same row. VLOOKUP searches down the first column of a table and returns a value from a chosen column. The arguments are the value to search for, the range of the table, the column to return from, and whether the table is sorted exactly.

HLOOKUP works in the same way but searches across the first row. INDEX returns the value at a given row and column of a range, and MATCH returns the position of a value within a range. MATCH combined with INDEX is more flexible than a single lookup.

A lookup is only correct if the first column of the table is sorted. An unsorted table gives an incorrect answer with no warning, so the sort is checked before the lookup is built.

Building a Summary Worksheet

A summary worksheet collects the results from the other worksheets. The number of pupils is taken from the count function, the mean from the average function, the highest and the lowest from the maximum and minimum functions, and the number passing from a count if function.

The summary refers to the data worksheet by writing its name before the range, as in the sum of Scores from B2 to B41. This is a cell reference applied to a whole worksheet, and it is what allows the summary to be built from the data rather than from retyped figures.

A summary is only worth building if it updates. If the figures are retyped by hand each time the data changes, the summary soon disagrees with the detail worksheets.

Practical Work

1. Create a mail merge letter for five recipients.
2. Write spreadsheet formulas for sum, average and highest value.
3. Add a chart to a slide and format its title.
4. Export a document to a portable format and share it.

Scenario-Based Questions

1. A school must send the same letter to 200 parents. Explain how mail merge helps.
2. A class list of scores must be summarised. Describe the functions you would use.
3. Explain why a chart helps an audience understand data.
4. Explain one benefit of sharing a document online.