Free until 14 Nov · 80% off for the first 100 · Pricing

Get started

Information and Communication Technology 0417/32 May/June 2024: question paper and mark scheme

Cambridge IGCSE Information and Communication Technology (0417), Paper 3 Spreadsheets and Website Authoring, May/June 2024. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.

0417_s24_qp_320417_s24_ms_320417/32/M/J/24

Mark my answers with AIRead the paper and scheme
Paper
Paper 3 Spreadsheets and Website Authoring
Total marks
70
Time
2 hours 15 minutes
Questions
3
Code on the paper
0417/32/M/J/24
0417_s24_ms_32.pdf

0417/32 mark scheme, question by question

Each question as it's printed, and the mark scheme's points for it, as text. Diagrams, tables and graphs are in the PDFs above.

Question 13 marks

Question

Open and examine the file j32giraffe.csv This file will be used in steps 2 and 3. Do not make any changes to this file. Open and examine the file j32sightings.csv Save the file j32sightings.csv as a spreadsheet with the filename Giraffe_ followed by your centre number_candidate number, for example Giraffe_ZZ999_9999 Rows 7 to 25 will show the number of sightings of the tagged giraffes in each country for one week in February. Rows 28 onwards show the details of all sightings for this week. Place your name, centre number and candidate number centre aligned in the header. Place the text Created on followed by a space, the automated date, a space, then the text at followed by a space, then the automated time in the footer. [3]

Mark scheme

3 Name, centre and candidate number centre aligned in header 1 Text Created on with space then with automated date in footer … 1 … with space, the text at another space and the automated time in the footer 1 For Question 2 see below for example of spreadsheet formulae.

Question 26 marks

Question

Place a replicable formula in cell D28 to look up the species, using the code and the external file j32giraffe.csv for the array. [6]

Mark scheme

6 =VLOOKUP ( … ) 1 … B29, … 1 … j32giraffe.csv! … 1 … $A$2:$C$12 … 1 … ,3 1 … ,0 1 For Question 3 see below for example of spreadsheet formulae.

Question 31 mark

Question

Place a replicable formula in cell F28 to look up the status, using the code and the external file j32giraffe.csv for the array. [1]

Mark scheme

=VLOOKUP(B29,j32giraffe.csv!$A$2:$F$12,6,0) 1 For Question 4 see below for example of spreadsheet formulae.

Question 41 mark

Question

Replicate the formulae entered in steps 2 and 3 for all sightings. [1]

Mark scheme

Cells D29 and F29 replicated to row 98 1 For Question 5 see below for example of spreadsheet formulae.

Question 52 marks

Question

Place in cell B3 a formula to count the total number of sightings for this 7 day period. [2]

Mark scheme

2 =COUNTA ( … ) 1 … A29:A98 1 PUBLISHED Question Answer Marks For Question 6 see below for example of spreadsheet formulae.

Question 65 marks

Question

Place in cell B4 a formula to count the total number of sightings for this 7 day period where a photograph of a critically endangered species was taken. [5]

Mark scheme

5 =COUNTIFS ( … ) 1 … F29:F98 … 1 … ,"Critically endangered" 1 … ,G29:G98 … 1 … ,"Yes" 1 For Question 7 see below for example of spreadsheet.

Question 72 marks

Question

Insert a new row between rows 5 and 6. Place in cell A6 the text Critically endangered [2]

Mark scheme

2 New row 6 inserted … 1 … with text Critically endangered 1 For Question 8 see below for example of spreadsheet formulae.

Question 88 marks

Question

Place a replicable formula in cell B8 to display the number of sightings of a critically endangered species in this country. Replicate this formula for each country. [8]

Mark scheme

8 =COUNTIFS ( … ) 1 … F29:F98 … 1 … as an absolute reference… 1 … ,"Critically endangered" 1 … ,E29:E98 1 … as an absolute reference 1 … ,A8 … 1 … as a relative reference 1 PUBLISHED Question Answer Marks For Question 9 see below for example of spreadsheet.

Question 97 marks

Question

Format the top of your spreadsheet so that it looks like this: A B Tagged giraffe 1 sightings 2 Number of sightings in 7 day 70 3 period Number of critically endangered sightings with 12 4 photograph 5 6 Critically endangered Number of Country 7 sightings 8 Botswana 0 9 Burundi 0 10 Cameroon 2 Make sure cells A1 to B1 and A6 to B6 are merged. Set the font size of the text in rows 1 and 6 to 20 points. Save your spreadsheet. [7]

Mark scheme

7 Cells A1:B1 and A6:B6 merged 1 20-point black text 1 Cells A1:B10 sans-serif 1 Text in A1, A3, A4, B7 wrapped as shown 1 Rows 2 and 5 half height of row 10 1 A3:A4 & A8:A10 right aligned and B1:B10 centre aligned 1 Rows 1, 3, 4 and 7 centre aligned vertically 1 For Question 10 see below for example of formulae spreadsheet.

Question 102 marks

Question

Print your spreadsheet showing the formulae. Make sure that: • it is in landscape orientation • the row and column headings are displayed • all formulae are fully visible. [2]

Mark scheme

2 Formulae printout – Formulae in cells A1 to G98 fully visible 1 Formulae printout – Landscape orientation with row and column headings 1 For Question 11 see below for example of values spreadsheet and selection method.

Question 1141 marks

Question

Select rows 1 to 7 inclusive and only the rows between 8 and 26 where a sighting took place. Take a screenshot of the method used to select these rows (between 8 and 26). Place this screenshot in your Evidence Document. Print this selection showing the values. Make sure that: • the printout fits on a single page • the printout is in portrait orientation • the row and column headings are displayed • the contents of all the cells in the selected rows are fully visible. [4] [Total: 41] Task 3 – File management

Mark scheme

4 Values printout – Rows 1 to 7 and selected rows from 8 to 26 fully visible 1 Values printout – filter used to remove countries with 0 1 Values printout – Portrait orientation, single page with row and column 1 headings Screen shot evidence of selection method 1 Total 41 PUBLISHED Task 3 – File management Task Answer Marks For Question 12 see below for example of folder screen shot.

Question 121 mark

Question

Create a new folder called j32 Locate only the following files and store them in your j32 folder. j32banner.jpg j32contact.jpg j32feed.mp4 j32logo.png j32text.txt j32web.css j32what.htm j32what.jpg Display the contents of your j32 folder, showing the folder name, all file names, file extensions, file sizes, image dimensions and the frame height and frame width for the video. Take a screenshot of this folder, making sure that the required information is clearly visible. Place this screenshot in your Evidence Document. [1] [Total: 1] Task 4 – Web page You will create a web page to help raise awareness of giraffe conservation.

Mark scheme

Screen shot includes folder name, image dimensions, video frame height and 1 width, file names, file extensions and file sizes For Question 13 see below for examples of html and browser view.

Question 137 marks

Question

Create a web page called j32web.htm and save this in your j32 folder. This web page must be created using a single table and work in all browsers. The table must fit 75% of the browser window and have a structure as shown in this diagram: A B C D E F Table borders must appear on the final web page. Each table cell is identified with a letter which must not appear on the final web page. [7]

Mark scheme

7 No letters visible 1 Table style="width:75%;" of browser window 1 Single table used 1 Table attribute border="1" 1 Row 1 – colspan="2" 1 Row 2 left – rowspan="3" 1 Row 5 – colspan="2" 1 For Question 14 see below for example of HTML.

Question 141 mark

Question

Set the title of the web page to Giraffe conservation [1]

Mark scheme

Title accurate and in head section 1 For Question 15 see below for examples of html and browser view.

Question 157 marks

Question

Place in cell: • A the image j32banner.jpg • B a video tag to display j32feed.mp4 so that it fits the width of this cell. This video must show the controls and play automatically when the web page opens. Display an automated text-based error message if the browser does not support this video type • C the image j32what.jpg • D the image j32contact.jpg [7]

Mark scheme

7 Banner image in top cell. 1 Video visible in row 2 left cell 1 video <…> tag used with … 1 … src="j32feed.mp4" … 1 … type="video/mp4"… 1 Appropriate error message between <video> and </video> tags 1 Set to autoplay 1 PUBLISHED Task Answer Marks For Question 16 see below for example of HTML.

Question 163 marks

Question

Enter in cell E the text: Web page edited by: then on a new line enter your name, centre number and candidate number Set this text as style h3. [3]

Mark scheme

3 Row 4 right cell - Web page edited by: … 1 … with new line then name, centre number and candidate number … 1 … all text set in style h3 1 For Question 17 see below for example of HTML and browser view.

Question 172 marks

Question

Place in cell F the text from the file j32text.txt Set this text in paragraph style. [2]

Mark scheme

2 Bottom row – text from source file complete 1 … set in style p 1 For Question 18 see below for example of HTML.

Question 181 mark

Question

Attach the stylesheet j32web.css to your web page. Do not edit this stylesheet. [1]

Mark scheme

Stylesheet j32web.css attached in head section 1 For Question 19 see below for example of HTML

Question 196 marks

Question

Make the image j32what.jpg a link to open the web page j32what.htm in a new window called _blank Make the image j32contact.jpg a link to an email editor to prepare an email to g.raffe@cambridge.org with the subject line Giraffe [6]

Mark scheme

6 Row 2 right cell - Anchor set around j32what.jpg 1 <a href="j32what.htm" … 1 … target="_blank"> 1 Row 3 right cell - Anchor set around j32contact.jpg 1 … ?subject=Giraffe"> 1 For Question 20 see below for example of browser view.

Question 2028 marks

Question

Save your web page. Take a copy of your HTML source and place this in your Evidence Document. Display your web page in a browser. If necessary, resize it so that: • all the page can be seen • all text can be easily read • the address bar is fully visible. Take screenshot evidence showing your web page in the browser. Place this in your Evidence Document. [1] [Total: 28] Task 5 – Printing the Evidence Document Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Save your Evidence Document. Print your Evidence Document.

Mark scheme

In browser, address visible 1 Total 28 PUBLISHED Header Name, centre & candidate no - centre aligned 1 mark Footer Created on <automated date> ... 1 mark ... at <automated time> 1 mark B3 =COUNTA ( … ) 1 mark … A29:A98 1 mark B4 =COUNTIFS ( … ) 1 mark … F29:F98 1 mark … ,"Critically endangered" 1 mark … ,G29:G98 1 mark … , "Yes" 1 mark B8 =COUNTIFS ( … ) 1 mark … F29:F98 1 mark … as an absolute reference 1 mark … ,"Critically endangered" 1 mark … ,E29:E98 1 mark … as an absolute reference 1 mark … ,A8 1 mark … as a relative reference 1 mark PUBLISHED D29 =VLOOKUP ( … ) 1 mark … B29, … 1 mark … j32giraffe.csv! … 1 mark … $A$2:$C$12 … 1 mark … ,3 1 mark … ,0 1 mark PUBLISHED F29 =VLOOKUP(B29,j32giraffe.csv!$A$2:$F$12,6,0) 1 mark D29 & F29 Replicated to row 98 1 mark Printout Formulae with cells A1 to G98 fully visible 1 mark Landscape orientation with row and column headings 1 mark PUBLISHED PUBLISHED PUBLISHED Row 6 New row inserted 1 mark Critically endangered 1 mark Cells A1:B1 and A6:B6 merged 1 mark Row 1 & 6 20-point black text 1 mark Rows 1-10 Cells A1:B10 sans-serif 1 mark Text in A1, A3, A4, B7 wrapped as shown 1 mark Rows 2 and 5 half height of row 10 1 mark A3:A4 & A8:A10 right aligned & B1:B10 centre aligned 1 mark Rows 1, 3, 4 & 7 centre aligned vertically 1 mark Printout Only rows 1 to 7 and selected rows from 8 to 26 fully visible 1 mark Filter used to remove countries with 0 1 mark Portrait, single page with row and column headings 1 mark PUBLISHED Evidence Document Filter Evidence of selection method 1 mark Screenshot includes folder name, image dimensions, video frame height and width, file names, file extensions & file sizes 1 mark PUBLISHED <!DOCTYPE html> Head section title Giraffe conservation 1 mark <html> j32web.css attached 1 mark <head> <title>Giraffe conservation</title> <link rel="stylesheet" type="text/css" href="j32web.css"> </head> <body> Table style="width:75%;" 1 mark single table used 1 mark <table style="width:75%;" border="1"> <tr> Row 1 colspan="2" 1 mark <td colspan="2"> <img src="j32banner.jpg" alt="banner for giraffe conservation" style="width:100%" > </td> Row 2 left rowspan="3" 1 mark Video video <…> tag used with… 1 mark </tr> … src="j32feed.mp4" … 1 mark <tr> … type="video/mp4" 1 mark Appropriate error message between <video> tags 1 mark Set to autoplay 1 mark <td rowspan="3"> <video controls autoplay muted > <source src="j32feed.mp4" type="video/mp4"> Your browser does not support this video format </video> Row 2 right Anchor set around j32what.jpg 1 mark </td> <a href="j32what.htm" … 1 mark … target="_blank"> 1 mark <td> <a href="j32what.htm" target="_blank"><img src="j32what.jpg"></a> </td> </tr> Row 3 right Anchor set around j32contact.jpg 1 mark <tr> … ?subject=Giraffe"> 1 mark <td> src="j32contact.jpg"></a> </td> </tr> <tr> <td> PUBLISHED <h3>Web page edited by:</h3> Row 4 right All text set in h3 1 mark <h3>A Candidate ZZ999 9999</h3> </td> </tr> Row 5 colspan="2" 1 mark <tr> <td colspan="2"> <p>With an estimated world population of 111000 giraffes many people do not see these creatures as endangered. There are four distinct species of giraffe with several sub-species. The species are the Masai giraffe, Northern giraffe, Reticulated giraffe and Southern giraffe. The Luangwa giraffe (sometimes called the Thornicroft's giraffe) have an estimated population of only 650 and are critically endangered as are the West African giraffe with an estimated population of 600. This is one of three sub-species of Northern giraffe, with each being classified as endangered or critically endangered. There are fewer than 3000 Northern giraffes remaining. We have arranged a programme to rescue injured or orphaned giraffes, feed them and provide them with medical care until they can be safely released back into the wild with others of the same sub-species. Please support us in our work.</p> </td> </tr> </table> </body> </html> PUBLISHED Browser In browser, address visible 1 mark Borders visible 1 mark No letters visible 1 mark Row 1 Banner 1 mark Row 2 left Video visible 1 mark Row 4 right Web page edited by: 1 mark New line then name and numbers 1 mark Row 5 text from source file complete 1 mark … set in style p 1 mark

Checked your answers against these? Let AI mark the whole paper, on your own working.

Mark my 0417/32

How this paper is marked

Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.

Check your answers against it

Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.

Other variants, May/June 2024

0417/32 in other series

Find another Information and Communication Technology paper

Every IGCSE Information and Communication Technology mark scheme

Question papers and mark schemes © Cambridge University Press & Assessment. CIE Buddy is independent and not connected to Cambridge.

0417/32 questions

Where can I find the 0417/32 May/June 2024 mark scheme?

On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/32, May/June 2024 (0417_s24_ms_32), and the question paper (0417_s24_qp_32), to read or download, with each question's marking points written out underneath.

How many marks is 0417/32 out of?

Information and Communication Technology 0417/32 for May/June 2024 is out of 70 marks, with 2 hours 15 minutes to answer it, across 3 questions.

Can I get my 0417/32 answers marked?

Yes. Upload your answers to 0417/32/M/J/24 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.