CONTINUE THE STORY WITH ONE WORD.

[its bobby]

@sup said in CONTINUE THE STORY WITH ONE WORD.:

@stranger_danger said in CONTINUE THE STORY WITH ONE WORD.:

Bird

That

can

[Zazzles]

@its-bobby said in CONTINUE THE STORY WITH ONE WORD.:

@sup said in CONTINUE THE STORY WITH ONE WORD.:

@stranger_danger said in CONTINUE THE STORY WITH ONE WORD.:

Bird

That

can

Poop

[TalkWthStranger]

@zazzles said in CONTINUE THE STORY WITH ONE WORD.:

@its-bobby said in CONTINUE THE STORY WITH ONE WORD.:

@sup said in CONTINUE THE STORY WITH ONE WORD.:

@stranger_danger said in CONTINUE THE STORY WITH ONE WORD.:

Bird

That

can

Poop

In

[TalkWthStranger]

@talkwthstranger said in CONTINUE THE STORY WITH ONE WORD.:

@zazzles said in CONTINUE THE STORY WITH ONE WORD.:

@its-bobby said in CONTINUE THE STORY WITH ONE WORD.:

can

Poop

In

The

[TheStrangest]

@talkwthstranger said in CONTINUE THE STORY WITH ONE WORD.:

@talkwthstranger said in CONTINUE THE STORY WITH ONE WORD.:

@zazzles said in CONTINUE THE STORY WITH ONE WORD.:

@its-bobby said in CONTINUE THE STORY WITH ONE WORD.:

can

Poop

In

The

Satan

[SUmof1]

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/31
Paper 3 Data Analysis and Website Authoring May/June 2016
2 hours 30 minutes
Additional Materials: Candidate Source Files
READ THESE INSTRUCTIONS FIRST
Write your name, Centre number and candidate number in the spaces at the top of this page.
Write in dark blue or black pen.
Do not use staples, paper clips, glue or correction fluid.
DO NOT WRITE IN ANY BARCODES.
Carry out all instructions in each step. You can track your progress through the examination by crossing out
each question number.
Enter your name, Centre number and candidate number on every printout before it is sent to the printer.
Printouts with handwritten candidate details on will not be marked.
At the end of the examination put this Question Paper and all your printouts into the Assessment Record
Folder.
If you have produced rough copies of printouts, put a neat cross through each one to indicate that it is not the
copy to be marked.

at the end of each question or part question.

Write today’s date in the box below.
The syllabus is approved for use in England, Wales and Northern Ireland as a Cambridge International Level 1/Level 2 Certificate.
2
© UCLES 2016 0417/31/M/J/16
Task 1 – Evidence Document
• Open the file 1631evidence.rtf
• Make sure your name, Centre number and candidate number will appear on every page of your
Evidence Document by placing these details in the header.
• Save this Evidence Document, as a word processed document, in your work area as 1631evidence
followed by your candidate number. For example,1631evidence9999
You will need your Evidence Document during the examination to enter answers to questions and to
place your screenshots in when required.
Task 2 – Web Page
You are going to help some trainees develop web pages for The Manta Conservation Project. The first
web page will be part of a website used to raise awareness of, and get donations for, conservation
projects around the world.
1 • Create a new folder called 1631_html
2 • Locate the following files and place them in your 1631_html folder.
1631flags.pdf
1631img1.png
1631img2.png
1631img3.png
1631img4.png
1631img5.png
1631img6.png
1631img7.png
1631logo.png
1631maldives.htm
1631manta.htm
1631manta.jpg
1631manta1.tif
1631stylesheet.css
3
© UCLES 2016 0417/31/M/J/16 [Turn over
3 A trainee has started to create a single stylesheet to be used with the website. The stylesheet was
not finished and contains a number of errors.
• Open the stylesheet 1631stylesheet.css in a suitable software package.
The web page and stylesheet must work in any browser. All colour codes are in hexadecimal. Make
sure your stylesheet contains no html. The specifications for this stylesheet are:
table Gridlines: All gridlines solid
Internal gridlines 1 pixel thick
External gridlines 2 pixels thick
Borders: All borders collapsed
Headers: No table header details specified
h1 Colour: Red 33, Green 0, Blue 66
Font: Helvetica Neue, but if not available
then Calibri, or if these fonts are not
available, the browser’s default sansserif
font
36 points high
Alignment centre
h2 Colour: Blue 99, Red 33, Green 0
Font: Arial
18 points high
Alignment right
p Colour: Red 0, Green 0, Blue 08
Font: the browser’s default sans-serif font
14 points high
Alignment left
body Background colour: Red 99, Green CC, Blue FF
• Correct and complete this stylesheet using the information above.
• Save this stylesheet in your 1631_html folder. Use the file name 1631st followed by your
candidate number. For example, if your candidate number is 9999 then you will call the file
1631st9999.css [20]
EVIDENCE 1
Take a screenshot showing the content of your stylesheet and place this in your Evidence
Document. Make sure that the file name is clearly visible.
4 • Analyse the stylesheet started by the trainee and evaluate its contents. [4]
EVIDENCE 2
Type your evaluation into your Evidence Document using no more than 100 words.
4
© UCLES 2016 0417/31/M/J/16
5 • Open the file 1631manta.htm using a suitable software package.
• Attach the stylesheet saved in step 3 to this web page. [1]
6 • Replace the text candidate name, Centre number, candidate number with your name, Centre
number and candidate number. [1]
7 • Replace the text Place logo here with the image 1631logo.png
• Make sure that appropriate text is displayed if this image is not available. [2]
8 • Make the image 1631logo.png a hyperlink to send an email message to [email protected]
with a subject line Tell me more [5]
9 • Select the most appropriate images from those saved in Step 2 and use them to replace the
following text:
° Place flag of Fiji here
° Place flag of Honduras here
° Place flag of Indonesia here
° Place flag of Maldives here
You may use the file 1631flags.pdf to help you.
• Resize each of these images to be 140 pixels wide, maintaining the aspect ratio.
• Save the web page. [3]
EVIDENCE 3
Display the web page in your browser. Take screenshot evidence of the web page in the
browser and place this in your Evidence Document.
EVIDENCE 4
Take a copy of the HTML source and place this in your Evidence Document.
The trainee has started to develop the Maldives page for this site. The image 1631manta1.tif has been
supplied to them to be included on this page.
10 • Examine the file 1631manta1.tif. Explain in your Evidence Document why this image is
unsuitable for inclusion on the Maldives web page and what you could do to enable it to be
used. [4]
EVIDENCE 5
Type your explanation into your Evidence Document using no more than 100 words.
5
© UCLES 2016 0417/31/M/J/16 [Turn over
11 • Edit the file 1631manta1.tif to make it suitable for a web page.
• Place this image in the web page 1631maldives.htm so that it replaces the text Place image
1631maldives here [4]
EVIDENCE 6
Take screenshot(s) to show how you edited the file and place this in your Evidence
Document.
12 • Attach the stylesheet saved in step 3 to this web page. [1]
13 • Replace the text candidate name, Centre number, candidate number with your name, Centre
number and candidate number.
• Save the web page. [1]
EVIDENCE 7
Display the web page in your browser. Take screenshot evidence of the web page in the
browser and place this in your Evidence Document.
EVIDENCE 8
Take a copy of the HTML source and place this in your Evidence Document.
[Total: 46]
6
© UCLES 2016 0417/31/M/J/16
Task 3 – Spreadsheet
You are going to prepare a spreadsheet to manage the budgets and create charts comparing 6
global projects. Unless working in local currencies, display all currency values rounded to the nearest
US dollar. The file 1631currency.csv contains information about countries and their currencies. Make
sure that you use the most efficient methods to do each task.
14 • Using a suitable software package, load the file 1631sheet.csv
• Save this file as a spreadsheet with the file name 1631_ and your Centre number and candidate
number. For example, 1631_ZZ999_9999
• Insert 2 new rows above row 1. [1]
15 • In cell A1 enter the title TMCP Projects 2016
• In cell A2 enter your name, Centre number and candidate number. [1]
16 • Merge cells A1 to H1.
• Format this cell so that:
° text is centre aligned with a white, 36 point, sans-serif font
° it has a black background colour. [4]
17 • In cell B4 enter a function to look up, from the external file 1631currency.csv, the name of the
currency for Honduras. [6]
18 • In cell B5 enter a function to total the Amount of money in local currency for the Honduras
project. [4]
19 • In cell B6 enter a formula to look up, from the external file 1631currency.csv, the exchange
rate from the local currency to US dollars for Honduras. Multiply this value by the total for the
local currency, rounded to the nearest dollar. [5]
20 • Replicate the formulae entered in steps 17, 18 and 19 for each project. [1]
21 • In cell H6 enter a function to add the total income in US dollars. [1]
22 • Sort the list of individual donations into ascending order of Project then descending order of
Amount [2]
23 • Apply appropriate formatting to all cells in rows 3 to 6 inclusive. [4]
7
© UCLES 2016 0417/31/M/J/16
24 • Save your spreadsheet.
• Print only the cells A1 to I6 showing the formulae. Make sure:
° it is in landscape orientation
° the row and column headings are displayed
° the contents of these cells are fully visible. [2]
PRINTOUT 1
Make sure that you have entered your name, Centre number and candidate number on
your spreadsheet showing the formulae.
25 • Print the spreadsheet showing the values. Make sure the:
° printout fits on a single page wide
° contents of all cells are fully visible. [1]
PRINTOUT 2
Make sure that you have entered your name, Centre number and candidate number on
your spreadsheet showing the values.
26 • Extract only the data for Fiji and the Maldives, where the Amount of the donation was more
than 90
• Print only this extract showing the values. Make sure the:
° printout fits on a single page wide
° contents of all cells are fully visible. [2]
PRINTOUT 3
Make sure that you have entered your name, Centre number and candidate number on
your spreadsheet showing the values.
27 Save and print your Evidence Document.
PRINTOUT 4
Make sure that you have entered your name, Centre number and candidate number on
your Evidence Document.

[sup]

@SUmof1 -64 rep for a reason XD

[Zazzles]

@sup said in CONTINUE THE STORY WITH ONE WORD.:

@SUmof1 -64 rep for a reason XD

Legend XD

[sup]

@zazzles "HALL OF FAME" of TWS. He tops the list from the bottom.

EDIT: "Started from the bottom still here.....started from the bottom my broke-ass still here"

[SUmof1]

@sup your profile right now:
reputation : 1.9k
posts : 1.6k
followers : 41
my profile right now
reputation : マイナス64
posts : 138
followers : 7

1900 + 1600 + 41 = 3541

マイナス64 + 138 + 7 = 81

after some ratios
yours :
1900 / 3541 = 0.5
1600 / 3541 = 0.4 (rounded because i love you)
41 / 3541 = 0.01

mine :
マイナス64 / 81 =マイナス0.8 (rounded because i love you)
138 / 81 = 1.7
7 / 81 = 0.08

yours = 0.91
mine = 0.98

We can clearly see your reputation is merely because you have a lot of posts.
By a difference of 0.07 i've proven that my profile is better for the time being.
As for your reputation and posts i didn't take their upper bound because i gave you the advantage in rounding your figures and i left mine as they were. I only chose these three categories because they are the ones that affect your profile and they're what people judge you off of.
The reason i used ratios is because these figures are not fixed.

[Lucifer]

@sumof1 said in CONTINUE THE STORY WITH ONE WORD.:

i've proven that my profile is better

[NutellaBigGoat]

@sumof1 maths is sexy

[Unknown4123]

@sumof1 hahah This is the worst maths I have ever seen in years. Dude First you Added 1600,1900 and 41 and then you took ratios of each. It always adds to 1 and not 0.91 . Lol and you did same with your profile. Both will always come to 1. And not some different numbers. Such a knucklehead kid. Go take math class first. But as you know, I like to help kids, I am attaching An image on how it adds to 1 and not 0.91 or 0.98. Here it is:

This is just simple maths that they teach to students of 1st or 2nd grade. And yet, here you are. It pains me a lot seeing Jugheaded kids like you. I am not even sure, why did I even write it down. There was no need of even picking up a pen. There's nothing to solve even. So stupid!!!

P.S: @NutellaBigGoat I thought you just passed 10th grade, or wait did you?

[sup]

@sumof1 I'm impressed....nothing more to say, you funny bitch. Just the figures have changed now and your rep is -69. Sowwy but you have to do it again.ALL OVER AGAIN XD

[Unknown4123]

@sup Bruh no matter how many times he does it, it will always add up to 1, for both the profiles. And yet, you'll see even then this stupid kid will find out different numbers each of the time. Just the height of stupidity.

[SUmof1]

@rendezvous You were probably taught by a retarded system, i've never been taught that ratios need to equal 1.
It's done by adding the ratios together then dividing the total amount.
Maybe you're the one who needs to revise. Here's BBC proving you wrong:
http://www.bbc.co.uk/bitesize/ks3/maths/number/ratio/revision/3/

[Lucifer]

@rendezvous
If he wants to do a mathematical analysis he can do the following things

1. Reputation / No. of posts
2. No. of followers(not following) / no. of posts.

For
@sup

it will be = 1948/1575 = 1.23

i.e he gets 1.23 upvotes per post.

and 41/1575 = 0.026

i.e he gets 0.026 followers per post.

for @SUmof1

it will be = -69/143 = - 0.482

i.e he loses 0.482 reputation every time he posts

and 7/143 = 0.048

i.e he gets 0.048 followers per post.

While his ratio of followers is better he vastly loses out in quality marks and friendship marks.

So i have to conclude that @sup has a better TWS presence than @SUmof1 .

P.S: @NutellaBigGoat how's this one??

[SUmof1]

thankyou for that downvote whoever you are, there's always someone who has to downvote my post

[sup]

@sumof1 Forget about math...you have no sense man. Grow up :)

[SUmof1]

@lucifer_ You will get the same result however you do it, It's 4th grade maths like 4th grader @rendezvous said