Spreadsheets Application II SS1 Digital Technologies Lesson Note

Subject: Digital Technologies 

Class: SS1

Functions – The “Shortcuts”

In our last lesson, we learned that a Formula is math we write ourselves (like =A1+A2+A3). But what if you have 1,000 numbers to add? Writing that out would take all day!

A Function is a pre-set command that does the math for you automatically. It’s like a “shortcut” button.

Structure of a Function:

Every function has three parts:

1. The Equal Sign (=): Tells the computer to wake up.
2. The Function Name: Tells it what to do (e.g., SUM).
3. The Range: Tells it which cells to look at, inside brackets ( ).

Example: Instead of =A1+A2+A3+A4+A5, you just type: =SUM(A1:A5)

Common Functions You Must Know

You don’t need to be a math genius to use these. The computer does the work; you just give the command.

The “IF” Function (The Decision Maker)

This is the most “human” function. It allows the computer to make a choice. Example: If a student’s score is above 50, show “PASS”; otherwise, show “FAIL.” =IF(B2>=50, “PASS”, “FAIL”)

Data Analysis (Sorting and Filtering)

When you have a lot of data (like a list of 500 students), it can be messy. Data Analysis is just a fancy way of saying “organizing your data to find answers.”

1. 1. Sorting

This puts your data in order.

• A to Z (Ascending): Puts names in alphabetical order or numbers from smallest to largest.
• Z to A (Descending): Puts the highest scores at the top.

2. Filtering

Filtering hides the data you don’t want to see so you can focus on what’s important.

• Example: You have a list of the whole school, but you only want to see the names of students in SS1 Blue. You turn on the “Filter” and tick only that class. The other classes disappear (but aren’t deleted!).

Visualizing Data with Charts

Numbers can be boring and hard to read. Charts turn those numbers into pictures that tell a story at a single glance.

The Three Most Common Charts:

1. Column/Bar Chart: Best for comparing different things (e.g., comparing the height of students or sales of different soft drinks).
2. Pie Chart: Best for showing parts of a whole (e.g., what percentage of your pocket money goes to food vs. data).
3. Line Chart: Best for showing how things change over time (e.g., your test scores from 1st term to 3rd term).

How to Create a Chart

Creating a chart is like taking a photo of your data. Here are the simple steps:

1. Select the Data: Use your mouse to highlight the names and the numbers you want to see in the chart. (Don’t forget the headings!).
2. Insert: Go to the “Insert” tab at the top of the screen.
3. Choose Chart Type: Click on the chart icon you want (Column, Pie, etc.).
4. Label It: Always add a Chart Title and Axis Labels (so people know what the numbers represent).

Summary Tip: If you change a number in your spreadsheet, the chart will automatically move to match the new number. You never have to redraw it!

Class Activity

1. Practice: Look at a list of 5 scores: 40, 85, 60, 72, 55.
   1. What function would you use to find the highest score?
   2. Write out the function to find the average.
2. Discussion: If you were showing the Principal how much the school’s electricity bill has gone up every month this year, which chart would you use?
3. Challenge: Try to write an IF function that gives a “Distinction” to anyone who scores 75 or above.