IGCSE Information And Communication Technology (0983) — May–June 2025, Paper 21

You are going to edit a document about exams. The school uses a corporate house style for all its documents. Paragraph styles must be created and applied as instructed. Using a…

Place in the ExamGuide document: - a centre-aligned header with automated page numbers - a right-aligned footer on a single line with the text: Produced by: followed by a space…

Select the subheading General and the following text up to and including the paragraph ending … the evidence provided. Change the page layout so that only this text is displayed…

Apply a bulleted list to the text from mobile phones … to … enabled electronic devices. Format the bullets so that: - the bullets are indented 2.5 centimetres from the left margin…

Locate the table in the document. Delete the entire row and contents for the subject Business Unit 1

Sort all the data in the table from Maths Paper 1 to Combined Science Paper 3 into ascending order of Exam Date with data integrity maintained.

Apply to the table: - 0.5-point gridlines to all cells - 3- to 4-point external black borders so that these are displayed when the table is printed.

Format the first row of the table so that: - it becomes a single cell - the text in the cell is centred vertically and horizontally - it has a light grey (20-40%) background fill.

Apply the EX-table style to rows 2 to 12 only.

Format the table so that: - all text in each row displays on one line - the table borders and all data fit within the column width - there is a 6-point space after the table.

Create and store the following style, basing it on the default/normal paragraph style: Style name Font style Font size (points) Alignment Enhancement Line spacing Space before…

Identify the four subheadings in the document and apply the EX-subhead style to each one.

In the last paragraph locate the text Results Nomination Form Format this text so that when clicked it opens the document with the file name j2521results.rtf Take screenshot…

Spell check and proofread the document. Make sure that: - the list and table are not split over columns or pages - there are no widows or orphans - there are no blank pages - the…

You are now going to prepare a report. Dates must be imported in the format day month year (DMY). Make sure all required data is fully visible. Use database software to import the…

Import the file j2521access.csv as a new table in your database. Set all data types to text. Set AAcode as the primary key. Place in your Evidence Document a screenshot showing…

Examine the file j2521class.csv and identify the most appropriate data to use as a primary key. Close this file. Import the file j2521class.csv as a new table in your database.…

Create one-to-many relationships as links between: - the AAcode field in the access table and the AAcode field in the learners' table - the primary key field in the class table…

Add the following as a new record in the learners' table: Field Value --- --- Surname Norris Forename Emma Gender Female Learnerno 10218427 DOB 10/07/2009 Telephone 0770090457…

Using fields from all the tables produce a tabular report that: - selects the records where: - Gender is Female - Accessarrangement includes the text time - shows only the fields…

Using fields from all the tables produce labels which: - select the records where: - AAcode is AA01 - Classcode includes the numbers 5 or 6 - are sorted in descending order of…

You are going to create a short presentation. All slides must have a consistent layout and formatting. Create a presentation of 6 slides using the file j2521assembly.rtf Unless…

Place in the centre of the slide header your name, centre number and candidate number. Place in the footer automated slide numbers left aligned. Make sure that: - the header and…

Format the first slide so that: - a title layout is applied with no bullets - the title and subtitle are centre aligned and in the middle of the slide.

Move the slide with the title Look after yourself so it becomes the last slide in the presentation.

Import the image j2521phone.jpg and place it to the left of the bullets on the slide with the title Prohibited items

Rotate the image 180 degrees. Make sure the aspect ratio is maintained.

Use the data in the file j2521mptrends.csv to create a vertical bar chart to show the number of offences for the category Mobile phone use. The chart must display only data from…

Label the chart with the title Increase in mobile phone offences

Display only the data values along the top of each bar.

Format the value axis scale to display: - a minimum value of 0 - a maximum value of 2100 - increments of 300

Place the chart to the right of the bullets on the slide with the title Tawara malpractice trends Make sure that: - no words are split - all data and labels are fully visible -…

Save the presentation. Print the full presentation in portrait orientation with 2 slides to the page, each filling half the page.