890376 Ans Igcse ICT PWB 001-032 PDF

Preview

Summary

Download 890376 Ans Igcse ICT PWB 001-032 PDF

Description

Cambridge IGCSE ICT Practical Workbook Answers ● 11 ● File management 1 Generic file types can be used on any platform.

[1 mark]

2 a Rich text format b Comma separated values c Text d Graphics interchange format e Joint photographic expert group f

Portable network graphics

g Portable document format h Moving picture experts group layer 3 i

Moving picture experts group layer 4

j

Cascading stylesheet

k Hypertext markup language l

Zip

m Roshal archive

[13 marks]

3 .rtf, .txt and .csv

[1 mark]

4 .mp3, .mp4, .zip and .rar

[1 mark]

5 2 from: So that you can always return to a previous version … … in case of file loss/corruption … if you need to refer back to the work at a particular point in time To reduce the chance of overwriting the file and losing the data

[2 marks]

6 To reduce transmission times between devices To reduce storage space used for the file 7 File C, File A, File B

Photocopying prohibited

[2 marks] [2 marks]

Cambridge IGCSE ICT Practical Workbook

1

Answers

8 Changing the quality of … … an image file

[2 marks]

9 Downsampling, which is the reduction of picture quality so as to reduce the file size Upsampling, which is to increase the number of pixels used to store the image

[4 marks]

10 4 from: To reduce the size of an image/document containing a number of images It is designed to be used where the file is not to be edited. Sometimes the file may be placed in a container in .zip or .rar format. This is used for reducing transmission time … … storage capacity required. It is especially useful for archiving documents.

[4 marks]

● 12 ● Images 1 Clip art is a collection of simple pictures and symbols made available for computer users to add to their documents.

[1 mark]

2 The aspect ratio of an image is the ratio of the width to the height.

[1 mark]

3 Width 3 cm Height 2 cm

[2 marks]

4 a In Line with Text This places the image as an in-line graphic and is treated as a text character within a line of text. b Square This places the image on the page and the text wraps (flows) around it. c Tight This places the image on the page and the text wraps (flows) around it, like Square, but you cannot control the distance of the text from the image for the top and bottom settings. d Through This places the image on the page and the text wraps around the image with pre-set values. e Top and Bottom This places the image with the text above and below the image, but not wrapped to the side. f

Behind Text This places the image behind the text.

g In Front of Text This places an image over the top of the text.

2

Cambridge IGCSE ICT Practical Workbook

[7 marks]

Photocopying prohibited

Answers

5 4 from: Click on image to select it Select the Format tab Open Format Picture pane (using Picture styles section) Select the paint bucket tab Select Line Select the line type and thickness

[4 marks]

6 a Type of transformation: Rotation b Feature used: 3-D Rotation

[2 marks]

7 Cropping

[1 mark]

8 a Type of transformation: Reflection b Feature used: 3-D Rotation

[2 marks]

9 a 24 b 8

[2 marks]

10 Bits per channel refers to the number of bits allocated to each of the three primary colours used with light; Red, Green and Blue / RGB.

[1 mark]

11 .png files can store 48 bit images (16 bits per channel) … and even 96 bit images. jpg files are restricted to 24 bits images.

[3]

12 a) A file with 16 bits per channel

[1]

● 13 ● Layout 1 What is the purpose of the document? Who is the target audience? How will I make it suitable for this audience? What is the appropriate medium? What is the appropriate package?

[5 marks]

2 a Ctrl X b Ctrl C OR Ctrl Insert c Ctrl V OR Shift Insert d Ctrl A e Ctrl Z

Photocopying prohibited

Cambridge IGCSE ICT Practical Workbook

3

Answers

f

Ctrl Y

g Prt Scr h Alt Prt Scr

[8 marks]

3 To drag and drop is to move a selected object … … like an image or highlight text … … to another part of the screen … … using a mouse or similar pointing device.

[4 marks]

4 a Left aligned b Centre aligned c Right aligned d Fully justified

[4 marks]

5 a Top b Centre c Bottom d Used for vertical alignment within a table.

[4 marks]

6 a Borders are the outside boundaries/edges … … of a cell/table/image etc. b Gridlines are the internal lines within a table.

[3 marks]

7 a is the area of a document between the top of the page and the top margin. b is the area of a document between the bottom of the page and the bottom margin.

[2 marks]

8 2 from: Left page – Name of the chapter Right page – Subsection name within the chapter Horizontal line

[2 marks]

9 Page numbering

[1 mark]

10 Information only has to be added/edited once and it appears on all pages … … therefore less work required … … therefore less chance of errors. Automated fields can be used to place page numbering … … these will change without manual updating. Automated file names and paths can be shown.

4

Cambridge IGCSE ICT Practical Workbook

[4 marks]

Photocopying prohibited

Answers

11 INSERT tab

[1 mark]

12 a Right tab b Left tab c Centre tab

[3 marks]

13 Select the INSERT tab. Choose the Footer option.

[2 marks]

14 To identify the date and time that a document was printed (not created) To make it easier to identify which is the latest version of a document

[2 marks]

15 To enable the reader of a document to locate the file easily on a storage system To verify that it originated in a student’s own user area on a networked system It enables the reader to see the file type used [no marks for name or path as they are in the question]

[3 marks]

16 You only have to enter the page numbers once (or twice on facing pages) with automated page numbering/Page numbers have to be entered on every page if done manually. Automatic page numbers calculate the page numbers/Manual page numbers have to be edited if pages are inserted or removed.

[2 marks]

● 14 ● Styles 1 Corporate branding/a method of recognising a company through elements like its logo/colour scheme etc.

[1 mark]

2 4 from: Colour schemes Font style Point sizes Logo Styles for bullets/numbering Paragraph style Page layout/page formatting

[4 marks]

3 4 from: Business cards Websites TV advertisements Bill boards/advertising hoardings Company vehicles Photocopying prohibited

[4 marks] Cambridge IGCSE ICT Practical Workbook

5

Answers

4 To give consistency to documents and other materials To save time in planning/setting up/creating/formatting documents Creates brand recognition Reduces the risks of mistakes in documents

[4 marks]

5 Styles would be defined in a cascading stylesheet(s). The external stylesheet(s) would be attached … … to all web pages in the website. They would be placed so the last stylesheet attached has priority.

[4 marks]

6 A serif font has small strokes called serifs at the end of individual letters.

[1 mark]

7 A sans-serif font does not have serifs at the end of individual letters.

[1 mark]

8 Points

[1 mark]

9 Font face

[1 mark]

10 ascender, descender

[2 marks]

11 In a document template file/in a file with a .dot file extension

[1 mark]

12 To display hidden characters to the user

[1 mark]

13 2 from: Tab key Return key/Enter key Space bar

[2 marks]

14 4 from: Select/highlight the text/numbers/cell … … that contains the style that you wish to copy. Select the format painter button … … from the Home tab. Drag the mouse over the text/numbers/cell that you wish to apply the style to.

6

Cambridge IGCSE ICT Practical Workbook

[4 marks]

Photocopying prohibited

Answers

● 15 ● Proofing 1 A spell check searches through its dictionary … … and tries to find a match with the word in the document. If a match is not found it indicates a potential error … … usually by underlining the word with a red wavy line.

[4 marks]

2 4 from: A spell check searches through a dictionary to find a match with the word in the document. If a match is not found it is displayed as a potential error. Names of people/places may not be in the dictionary. Highly technical/specialist terms may not be in the dictionary. Newly accepted words may not be in the dictionary if it has not been recently updated.

[4 marks]

3 b a blue wavy underline

[1 mark]

4 Validation is checking that data entered is reasonable.

[1 mark]

5 [1 mark for true or false and one for each reason:] True A range check could be used to validate the title of the book A length check could be used to check the number of characters entered in the ISBN

✔

A consistency check could be used with the Price and Author fields A check digit could be added to the ISBN field

A length check could be used with the Price field

Photocopying prohibited

Reason A range check can only be used on a numeric data type and the title of the book has an alphanumeric data type. All modern ISBNs have 13 digits (ignoring the 4 – symbols) so a maximum field length of 17 characters would reduce the storage capacity required for the database.

✔

A limit check could be used for the Price field

A format check could be used with the ISBN field

False

[14 marks]

✔

The price field will have 2 limits, one being >=0 and a maximum price for a book, therefore a range check would test this whereas a limit check would only change 1 of the 2 ends of the range.

✔

There is no direct relationship between the Price and Author fields so consistency check would be inappropriate.

✔

The ISBN field already contains a check digit so this would not be required. This field contains 13 numeric characters spaced with 4 hyphens and these are consistent through most ISBNs (older ones have 10 numeric characters) so a format check is appropriate.

✔

✔

The book price field has a numeric data type (probably with a currency sub-type) and length checks are only applied to alphanumeric fields.

Cambridge IGCSE ICT Practical Workbook

7

Answers

6 6 from: The correct application of styles The correct margin settings Images placed as specified Text wraps as specified Images are not distorted Objects fit within the page/column margin Objects not overlapping No lists split over 2 pages/columns No tables split over 2 pages/columns No blank columns/pages No widows/orphans

[6 marks]

7 A widow is the last line of a paragraph … … that appears alone at the top of a new page or column.

[2 marks]

An orphan is the first line of a paragraph or a heading … …that appears as the last line of a page.

[2 marks]

8 Problems with gender, Mr in first sentence and She in 2nd sentence FROM is upper case Age of Mr Tanton has been transposed from 71 to 17

[3 marks]

9 Verification is a way of reducing errors … … when data is copied from one medium to another.

[2 marks]

10 Visual checking/verification Checking for data entry errors by manually comparing … … the original documents … … with data entered on the computer. Double data entry Data is entered into the system twice … … where the computer compares the two versions … … and differences in the data are flagged as an error.

[8 marks]

11 [3 marks for explanation and 1 mark for suitable example] If there is an error in the original source document … … and the data is reasonable … … then the data entered may be incorrect/inaccurate. e.g. Data expected is 1st April 2019 and data is recorded and entered as 4/1/2019 then this would be a data entry error if UK settings used but not if US settings are used. 8

Cambridge IGCSE ICT Practical Workbook

[4 marks]

Photocopying prohibited

Answers

● 16 ● Graphs and charts 1 a G b B, F c B, F, A, C, D Please note: with data like this and only 3 different data items, either a bar chart or pie chart would be suitable d A, C, D e A, C, D f

A, C, D

g E

[7 marks]

2 a Pie chart b Bar chart c Pie chart d Line graph

[4 marks]

3 a Line graph

[1 mark]

b It is a line graph because the time intervals along are all the same/10 seconds … … by using a line graph it will allow is to see the exact distance travelled at other times (like after 17 seconds)

[2 marks]

c Time in seconds would be plotted on the X-axis Distance would be plotted on the Y-axis.

[2 marks]

4 a A2:B2 or B2:C2 or A2:C2 b A2 and C2 5 CTRL key

[4 marks] [1 mark]

6 b Legend (showing data series) c Primary value axis title d Secondary value axis title e Primary value axis labels f

Category axis labels

g Secondary value axis labels h Category axis title

[7 marks]

7 a Chart title b Legend c Segment label /segment value

Photocopying prohibited

[3 marks]

Cambridge IGCSE ICT Practical Workbook

9

Answers

8 If graph is a comparative bar/line/combo chart … …it may have 2 data series which hold different types of data. Value axis only shows one of these values. So secondary axis is required to allow comparisons to be easily seen/understood.

[4 marks]

9 Maximum axis value Minimum axis value Axis Unit value (may be called Major Unit or Minor Unit)

[3 marks]

● 17 ● Document production 1 All 4 extensions are formats for text files/documents. .txt and .rtf are generic file formats .odt is a package-specific file format for Open Office. .docx is a package-specific file format for Microsoft Office.

[4 marks]

2 Suitable description for your word processor like: 4 from: Select the PAGE LAYOUT tab … … in the Page Layout section … … click on the drop-down control on the bottom right-hand side … … to Open the Page Setup window. Change the Paper size using the drop-down menu.

[4 marks]

3 Answers in any order: Margins Paper Layout

[3 marks]

4 An area outside the margins of a document … … that is used to bind a book together.

[2 marks]

5 Widows and orphans are both a single (or partial) line of text … … that are not kept with the rest of the paragraph … … as the text flows into a new page or column. The single line of text at the top of the next page or column is called a widow. The first line of a paragraph at the bottom of a page is called an orphan.

10

Cambridge IGCSE ICT Practical Workbook

[4 marks]

Photocopying prohibited

Answers

6 a A page break forces the text onto the start of a new page … … leaving white space at the end of the previous page. b A section break is used to split areas of a document into different layouts … … these can be continuous on the same page or force a page break as well. c A column break forces the text into the top of the next column … … leaving white space at the end of the previous column.

[6 marks]

7 a An orphan b Move the cursor before the S in School closures. Insert a column break.

[3 marks]

8 In the HOME tab In the paragraph section

[2 marks]

9 It aligns text to: a the left margin … … with a ragged right margin b the centre of the page … … with ragged left and right margins c the right margin … … with a ragged left margin d both margins … … leaving two straight margins and no ragged margins. 10 Single line spacing

[8 marks] [1 mark]

11 a 1.5 line spacing b single c double d multiple (or 3x line spacing)

[4 marks]

12 ruler

[1 mark]

13 a Sets the left alignment … … of the first line of a paragraph. b

Sets the left alignment … … of all lines in a paragraph except for the first line.

Photocopying prohibited

Cambridge IGCSE ICT Practical Workbook

11

Answers

c

Sets a left tab stop … … which left aligns all text/numbers to it when the tab key is pressed.

d

Sets a decimal tab stop … … which aligns numbers using the position of the decimal point when the tab key is pressed.

e Sets a right tab stop … … which right aligns all text/numbers to it when the tab key is pressed.

[10 marks]

14 a Hanging paragraph b Indented paragraph c Normal paragraph

[3 marks]

15 4 from: Click the right mouse button … … in a cell within the column to be deleted. Select the Delete Cells … … option from the menu. Select the radio button for Delete entire column … … then click on the OK button. 16 Merge cells

[4 marks] [1 mark]

17 4 from: Click the right mouse button … … in a cell within the column to be deleted. Select the Table Properties … … option from the menu. Select the Cell tab. Select the Center icon followed by the OK button.

[4 marks]

18 To save repeated typing/editing of similar material To reduce the potential for typing errors

[2 marks]

19 To generate personalised letters … … to a number of people.

[2 marks]

20 a Monday, 09 May 2016 b 01/08/16 c 2016-05-09 d 01/08/2016 12

Cambridge IGCSE ICT Practical Workbook

Photocopying prohibited

Answers

e 09.05.2016 f

August 16

g 1-Aug-16

[7 marks]

21 Right mouse click … … on the date field. Select Toggle Field Codes … … from the drop-down menu.

[4 marks]

22 Right mouse click on the placeholder. Select Toggle Field Codes from the drop-down menu.

[2 marks]

● 18 ● Data manipulation 1 A database is an organised collection of data. A database program is software. It stores the data and the links between the data items. It stores data using files, records and fields.

[4 marks]

2 a A flat-file database stores its data in one table, which is organised by rows and columns. b A relational database stores the data in more than one linked table, stored in the file. c A record contains data about one person or item. d Each column in a database table contains a field which has been given a field nam...