# Year 5 ICT exam guide: In depth

Ever wanted to score a high mark on your exam?

In sha Allah, with the help in this post, I can increase the chances of that happening. If you haven’t already, read my post about “ICT Study Guide 2015” You’ll find tips and advice on how to get a higher mark. Let’s get into this.

### Spreadsheet Modelling – MS Excel

We need to look at formulas, how to use them and how to set them up. Any formula using MS Excel will start off with a “=” this is because if i put 2+2, that won’t give me an answer. It’s like if the Teacher put on the board 10+10. But what should I do with that? It would make more sense if the Teacher put 10+10=? That equal sign tells you that you need to figure something out. Makes sense?

We also have some mathematical symbols that we use. We got +, -, *, /. I hope you know what + and – means (add and subtract). We got * also known as multiplication and / also known as division. There is no divide symbol on the keyboard, and it also looks like a fractional number. eg. 1/2=50%. * stands for multiplication because it cannot be x. That’s because when using formulas we need to use numbers. x is not a number or symbol. It’s a letter of the alphabet. That won’t do.

When opening a spreadsheet. There are some parts of it we’ll need to know. A cell is the smallest part of it because a cell is the smallest living organism. A column, that is a collection of cells in a vertical orientation. A row which is a collection of cells in a horizontal orientation.

If we would like to represent our information. We can insert a chart or graph. We will only be looking at bar graph / line graph or pie chart. A bar graph / line graph is great to show information over a time period. Like how tall you grew over a few years. A pie chart it really good to show percentages. Like how many boys vs. girls in a class.

We have a small exercise that you’ll need to do. Read over the above paragraphs.

So far, so good? ….. Great, let’s continue in sha Allah.

### Computer Control

Everyone’s favorite topic. And NO, it’s not Flowgrid. Computer Control is the topic / unit. Flowgrid is just a program.

We have 4 types of devices. Motors, Sensors, Output and Input Devices. Let’s start with…

##### Motors

A motor is a device that can move something. The motor can move something either in a rotational or linear way. Rotational movement could be like a clock. Linear movement could be like a automatic door or a DVD player ejecting a disk. All motors spin. When you put different parts to it, it can change the movement direction.

##### Sensors

Sensors detect changes in the environment to perform an action. There are different types like sound, light, motion and temperature sensors. Each one with its own purpose.

##### Input & Output Devices

Input devices will tell a device to turn off or on. Some examples could be a lever, a switch, a knob or a button. So, if I pressed a button (input device) it could switch on a light or turn on a motor. Sensors are similar to input devices but they are automatic. While input devices like buttons or knobs will need someone or something to activate it.

Output devices are anything that outputs something. It could be a light bulb, a receipt printer, a speaker or anything else that outputs something.

When using Flowgrid or any other flowchart software. There are some shapes we’ll need to know. The square is for processes like beeps and delays. The ellipse is for start and stop. The diamond is for sensors and input devices. The Parallelogram is for output devices.

##### Computer Control – MSWLogo

We looked at this program for a short while. This is the program where you can direct a turtle (triangle) where to go. There are some basic commands we’ll go over.

• FD – Forward
• BK – Back
• LT – Left Turn
• RT – Right Turn
• CS – Clear Screen

When telling the turtle to move. We need a command and a value. A command is telling the turtle to do something. A value is telling the turtle how much to do of it. For example, FD 100. FD = command 100 = value. We’re telling the turtle to walk forward 100 steps.

When telling the turtle to turn we have to use LT or RT. There are 4 basic values for turning. 360 = circle, 180 = U turn, 90 = corner turn, 45 = diagonal. We don’t move when we turn, we just rotate.

##### Finding Information

When we want to write a story or even make a blog post like this. We need to know information. What happens if we don’t know the information? Then we’ll need to look somewhere for information. It could be anywhere. Some popular ways to find information could be the internet, books, CD/DVD, encyclopedia, magazines, newspapers, etc. Places to find information could be a Library, Police Station, School or Government Building.

Looking at information, there are 2 types. Quantitative and Qualitative. Quantitative means somethings that can be measured like the birth date of someone or a fact that is known. Qualitative mean information that is more of an opinion or favoritism towards something.

We’ll only be searching online with “quotes” and non quotes. When using quotes, whatever you type in between the quotes will show up. Exactly how you typed it. If you searched “I have a red pencil on my desk at school and looking at a screen”. Nothing will show up. Maybe one hit. If you typed it without quotes, you would get many results. So if you wanted to look up a quote of someone or something very specific you would use quotes.

Well, that’s all that’s one the ICT exam this year. I hope you enjoyed it and use it to your advantage.

If you have any questions, please, please comment down below and I’ll be sure to answer them as fast as I can.

Posted in ICT

## 4 thoughts on “Year 5 ICT exam guide: In depth”

1. hakimi says:

why is it you you?

Like