Year 6 ICT Exam guide: In Depth

Welcome my humble Year 6 class. I hope you got your reading glasses because this one will be a doozy. This post is to help YOU score a high mark in ICT. I don’t like seeing anyone scoring low on an exam and then you get a bad mark for the whole year, even though you worked hard. So I’ll work extra hard to help you ace the exam without giving you the answers or allowing you to cheat.

Read my post on How to prepare for an exam on tips how to study and write an exam the best way I could think of.

Spreadsheet Modelling

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.

In the exam, you’ll need to complete a budget sheet without using a computer. You may use a calculator, but the math is really simple like 5 x 10 = ? You should feel proud if you don’t use a calculator. Bravo!

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…


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 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.

Presentation Software

When using Microsoft PowerPoint there is ONE thing I always notice. No one keeps track of their time. Especially if you are writing an exam, the time you spend will determine your mark. There is a lot to do on the exam so managing your time well will help you complete the exam.

When you are asked to find an image online, please DO NOT spend 10 minutes finding one picture. I will not give you a higher mark if you find a great picture. If i ask for a picture of a can. You don’t need to find the greatest picture ever. Just download whatever picture and put it in. You are not giving a presentation. You are just showing me you can insert a picture.

I tried to make the presentation as simple as I could but not so hard that you’ll hurt your heads. Basically what you’ll need to know is how to insert a picture, makes new slides, create text and move text/images on the presentation.

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 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.

You will need to write the story on the paper. Finding the information online and picking the key points is essential. You cannot copy and paste here. There is also a limit to 120 words so you’ll really need to get your facts across with not so many words. You’ll be asked to choose 2 out of 4 topics. Each topic will have a General information, History, one main and one minor fact.

General information is like what you are talking about.
History is some sort of history. Dates is a good thing to put downMain fact is the big story, this should take up most of the story
Minor fact is a little tidbit or something quirky…how do i say it? go google what those words mean if you don’t understand them.

I might change the words. Not lower though. Maybe to 200.

As I said before, pay very close attention to your time. Complete the easy questions and save the practical for the last. Look at the clock and give yourself a time limit. Start with the easy one and if you have extra time, use it for the harder question.

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.


8 thoughts on “Year 6 ICT Exam guide: In Depth

    1. When you want to download a picture. You can use a search engine like google and type in what you want. Click on Images at the top. Choose a picture and click on it. Click on view image. Once the picture has loaded, right-click on “save image as”. A window will appear, choose where you want the picture to go and save it (saving on desktop is recommended).

      Open the presentation software and click on Insert>picture. Find your picture and click insert.

      So, the steps are:
      1. find picture
      2. download picture
      3. insert picture

      Hope this helps :)


    1. To make a new slide, you click on “New slide”
      To create text, you click on Insert (at the top)>text box, then click and drag a box
      To move text/image around you move your mouse on the outside of your text/image. You mouse will turn into a four way arrow. You can click and drag your mouse to move it You can also move your mouse on the outside and use the arrow keys on your keyboard to move it.

      Thanks for the comment Ajmain


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s