Digi-Navigators Sample Marking Scheme This marking scheme has been prepared as a guide only to markers. This is not a set of model answers, or the exclusive answers to the questions, and there will frequently be alternative responses which will provide a valid answer. Markers are advised that, unless a question specifies that an answer be provided in a particular form, then an answer that is correct (factually or in practical terms) must be given the available marks. If there is doubt as to the correctness of an answer, the relevant NCC Education materials should be the first authority.
Please note that marks should not be deducted for poor spelling and grammar unless this presents a significant barrier to comprehension and therefore the assessment of the quality of knowledge and thought. Throughout the marking, please credit any valid alternative point. Where markers award half marks in any part of a question, they should ensure that the total mark recorded for the question is rounded up to a whole mark.
Part A: Understanding Computing (24 marks) Circle ONE (1) correct answer from A, B, C or D for each question Each question is worth 4 marks Question 1 You can join a group of people who have the same interests. You can ask them questions and answer them too. Which ONE (1) is this? A
Forum
B
Wiki
C
Blog
D
Email 4 marks
Answer: A
Forum
Award 4 marks for the correct answer Question 2 Which ONE (1) password is the strongest? A
password
B
Fluffy101
C
123456
D
abcdefg 4 marks
Answer: B
Fluffy101
Award 4 marks for the correct answer
Page 2 of 11 Digi-Navigators
© NCC Education Limited 2014
Question 3 Which ONE (1) could place a harmful virus on your computer? A
Turning on your computer
B
Logging into your email
C
Opening attachments in an email from a stranger
D
Unplugging your keyboard
4 marks Answer: C
Opening attachments in an email from a stranger
Award 4 marks for the correct answer Question 4 Which ONE (1) of these answers about search engines is correct? A
They find results for different search terms
B
You can only use them to find pictures
C
They are expensive to use
D
Everyone must use a different search engine 4 marks
Answer: A
They find results for different search terms
Award 4 marks for the correct answer
Page 3 of 11 Digi-Navigators
© NCC Education Limited 2014
Question 5 Look at the URL: www.computer-champs.bb/computing. Which part shows the country where the website was created? A
www.
B
computer-champs
C
.bb
D
/computing 4 marks
Answer: C
.bb
Award 4 marks for the correct answer Question 6 John uses a program to join together pictures of his favourite toy. This makes the toy move. Choose ONE (1) answer to show what John has made. A
A sound file
B
A website
C
An animation
D
An email 4 marks
Answer: C
An animation
Award 4 marks for the correct answer
Page 4 of 11 Digi-Navigators
© NCC Education Limited 2014
Part B: Computing in Focus (26 marks) Write the correct answer for each question in the space provided Question 7 a) Using quotation marks (“ ”) makes the search results more useful. Why?
Using quotation marks means you will search for that exact phrase only. Without quotation marks, search engines will remove common words such as ‘who’ and ‘is’. 2 marks b) You have made a presentation based on your research. What tool would you use to put your name on the bottom of every slide or page? You would use the Header and Footer function Allow any credible terminology. 2 marks Page 5 of 11 Digi-Navigators
© NCC Education Limited 2014
Question 8 a) You have a spreadsheet. The spreadsheet has data about the people in your town. The columns are called Name, Age and Favourite Sport. How would you find the people in the spreadsheet who like football? You would highlight the column and sort or filter appropriately. 1 mark for appropriate highlighting, 1 mark for sorting appropriately 2 marks b) Jane has recorded the things on her shopping list in a spreadsheet. Write a formula to find out how much these items will cost in total.
=SUM(B1:B8) 2 marks
Page 6 of 11 Digi-Navigators
© NCC Education Limited 2014
Question 9 a) What is the difference between cropping and resizing an image?
Cropping refers to removing parts of an image completely. Resizing means to alter the size of the image without removing any part of the image. 2 marks b) Why would a company design a product (like a car) on a computer before making it?
It is cheaper for them to do it this way. This allows them to change or manipulate a design quickly and easily. 2 marks for any valid point 2 marks
Page 7 of 11 Digi-Navigators
© NCC Education Limited 2014
c) A student has made a program in Scratch. A car drives up to a crossing then waits. It then says ‘Let’s go!’ and drives away from the crossing. Here is a screenshot of the program at the beginning.
ONE (1) command below can play a sound after the car says ‘Let’s go!’. Where does the command go in the program? Draw a line from the correct command to the correct place in the program. Commands – choose ONE (1) Program code
Insert ‘play sound vroom’ after ‘say Let’s go! For 2 secs’. 1 mark for choosing the correct command, 1 mark for identifying an appropriate place to put it in the program 2 marks
Page 8 of 11 Digi-Navigators
© NCC Education Limited 2014
Question 10 v1 a) A movement sensor turns on a light for ten seconds when it is activated. Draw a flow diagram to show how it works.
Start No Movement detected? Yes Turn on light for ten seconds 1 mark for each box, 1 mark for each correct arrow and an additional 1 mark if all labels are correct. Full marks available for any correct and appropriately labelled diagram. Up to half marks are available for a diagram that is partially correct. 8 marks b) Draw and label a simple picture of a ring network.
Computer
Computer
Computer
Computer
Server
Printer
Up to 4 marks are available for an appropriately drawn and labelled diagram 4 marks
Page 9 of 11 Digi-Navigators
© NCC Education Limited 2014
Part C: Using Computers (50 marks) Question 11 Use presentation software for this question You have been asked to create a presentation about African Lions. The presentation should have THREE (3) pages. All three pages should have an orangecoloured background. The writing on every page should be coloured black. The font style should be Arial.
The first page should have a picture of a lion and the title AFRICAN LIONS at the top of the page. When you click the picture of the lion, it should go to the website http://animals.nationalgeographic.co.uk/animals/mammals/african-lion/
The presentation should move to a second page after 30 seconds. This page should have a different picture of an African Lion on it. When you click on this picture, it should make a roaring sound. You can record this sound using a microphone or choose one of the sounds that is on your computer.
You should write two points about African Lions on the third page and make it big enough so that it is easy to read.
When you finish your presentation show your teacher. Your teacher will then save your work. 2 marks for each slide (maximum of 6 marks) 3 marks for the correct background and font on each page (maximum of 9 marks) 3 marks for the title on page 1 3 marks for a picture of a African Lion on page 1, 8 marks for a correct hyperlink to http://animals.nationalgeographic.co.uk/animals/mammals/african-lion/ when the lion image is clicked (maximum of 11 marks) 6 marks for the correct 30 second pause between pages 1 and 2 3 marks for a picture of a lion on page 2, 8 marks for a sound when the lion is clicked (maximum of 11 marks) 4 marks for providing the points about lions on page 3 50 marks
End of paper Page 10 of 11 Digi-Navigators
© NCC Education Limited 2014
Learning Outcomes matrix Part A: Understanding Computing Question Learning Outcomes assessed 1 Identify and understand how to use online tools that enable us to communicate and collaborate with others. 2 Recognise the importance of keeping safe and being respectful when using technology. 3 Learn about potential dangers and how to avoid them. 4 Begin to understand how and why search engines select and rank results. 5 Understand plagiarism, validity and copyright in relation to online material. 6 Understand how to storyboard and capture video or a series of stills to make an animation. Part B: Computing in Focus Question Learning Outcomes assessed 7 Know how to use a range of search techniques to find, select and refine reliable information. Use a range of skills to present text clearly, appropriately and for a specific purpose. 8 Solve enquiries by identifying and interpreting appropriate data. Know how to develop spreadsheet models to investigate real-life problems. 9 Understand how digital images can be manipulated for a given outcome. Know how to use an object-based graphics package to design and develop a plan to meet a specific brief. Develop problem-solving and logical reasoning skills. Understand how programming code can be used to create a program for a specific purpose. 10 Understand how programs that mimic the real world are developed. Know how to program devices to control physical systems. Recognise what computer networks (including the Internet) are and how they function. Part C: Using Computers Question Learning Outcomes assessed 11 Understand how digital images can be manipulated for a given outcome. Know how to edit sound files for a purpose. Use a range of skills to present text clearly, appropriately and for a specific purpose. Know how to combine a range of digital media to create a presentation for a specific audience. Understand how to use appropriate tools, such as hyperlinks, to enhance a presentation.
Page 11 of 11 Digi-Navigators
© NCC Education Limited 2014
