Information and Communication Technology 0417/21 May/June 2021: question paper and mark scheme

Question

Open the file J2121TRIATHLON.rtf The page setup is set to A4, portrait orientation with 2.5 centimetre margins. Do not make any changes to these settings. The TN-body style has been created, stored and applied to the body text in the document. Do not make any changes to this. Save the document in your work area, in the format of the software you are using, with the file name EVPACK EVIDENCE 1 Place in your Evidence Document a screenshot to show this file has been saved. Make sure there is evidence of the file type. [1]

Question

Remove any page breaks from the document. [1]

Question

Place in the header your name, centre number and candidate number right aligned. Place in the footer automated page numbers centre aligned. Make sure that: • the header alignment matches the page margin • no other text or placeholders are included in the header or footer areas • headers and footers are displayed on all pages. [2]

Question

At the start of the document enter the title: Triathlon Event Pack [1]

Question

Create and store the following style, basing it on the default paragraph style: Font size (points) Enhancement Space before Line spacing Space after Style name Alignment Font style (points) (points) TN-title serif 34 centre bold, italic single 0 0 Apply the TN-title style to the title text entered in step 4. EVIDENCE 2 Place in your Evidence Document a screenshot to show that the style settings have been defined for the TN-title style. Make sure this style is based on the default paragraph style. [3]

Question

Select the subheading General and the following text up to and including the paragraph ending … competitors in each category. Change the page layout so that only this text is displayed in two columns of equal width with a 1.5 centimetre space between them. [2]

Question

Apply bullets to the text from swim: 60 minutes … to … 1 hour 20 minutes Make sure that: • the bullets are indented 1.5 centimetres from the left margin • the list is in single line spacing with no space before or after each line • there is a 6 point space after the last item in the list. [2]

Question

The style name TN-subhead has already been created, stored and applied to the six subheadings. Modify the TN-subhead style so only the following formatting is applied: Font size (points) Enhancement Space before Line spacing Space after Style name Alignment Font style (points) (points) TN-subhead serif 18 centre italic, all capitals single 0 9 EVIDENCE 3 Place in your Evidence Document a screenshot of the amended settings for the TN-subhead style. [2]

Question

Format the paragraph that starts This is an important part … so that it: • is indented 1 centimetre from both the left and right hand margins • displays an external 3 to 4 point black border. [2]

Question

Locate the table in the document. Delete the entire column and contents with the heading Distance [1]

Question

Format the table so that the left column looks like this: Swim Wave Details [4]

Question

Make sure that: • the TN-table style is applied to all the data in columns 2, 3 and 4 • text in columns 2, 3 and 4 displays on one line • the table borders and all data fit within the column width • 1 point black internal and external gridlines are displayed when printed • there is a 6 point space after the table. [3]

Question

Import the image J2121SWIM.png and place it in the paragraph beginning Please follow the Race Director’s … Reflect (flip) the image so the hand is on the left. Format the image so that: • it is resized to a width of 2.5 centimetres with aspect ratio maintained • it is aligned to the right of the column and top of the paragraph starting Please follow the Race Director’s … • the text wraps around the image. [4]

Question

Spell check and proofread the document. Make sure that: • the list, table and indented paragraph with the border are not split over columns or pages • there are no widows or orphans • there are no blank pages • styles are applied consistently • spacing is consistent between all items. Save the document using the same file name and format used in step 1. Print the document. PRINTOUT 1 Make sure your name, centre number and candidate number are on your document. [2] [Total: 30] Task 3 – Database You are now going to prepare some reports. Dates are to be imported in the format of day month year.

Question

Using a suitable database package, import the file J2121ATHLETE.csv Use these field names and data types: Field name Data type Format Last_Name Text First_Name Text Athlete_ID Number Nationality Text YOB Number Gender Text Set the Athlete_ID field as a primary key. Import the file J2121EVENTS.csv as a new table in your database. Use these field names and data types: Field name Data type Format Event_ID Text Location Text Country Text Date Date/Time DMY Swim(M) Number Bike(KM) Number Run(KM) Number Water_Temp Number Air_Temp Number Wetsuit Boolean/Logical To display as Yes/No Race_Director Text IOC_Code Text Set the Event_ID field as a primary key. Import the file J2121RESULTS.csv as a new table in your database. Use these field names and data types: Field name Data type Format Event_ID Text Athlete_ID Number Start_No Number Swim Date/Time hh:mm:ss T1 Date/Time hh:mm:ss Bike Date/Time hh:mm:ss T2 Date/Time hh:mm:ss Run Date/Time hh:mm:ss Outcome Text Position Number Total_Time Date/Time hh:mm:ss Do not set a primary key. Save the data. EVIDENCE 4 Place in your Evidence Document screenshots showing the primary keys, field names and data types used in all three tables. [5]

Question

Create one-to-many relationships as links between the: • Athlete_ID field in the athlete table and the Athlete_ID field in the results table • Event_ID field in the events table and the Event_ID field in the results table. EVIDENCE 5 Place in your Evidence Document screenshots showing the type of relationships between the three tables. [2]

Question

Enter the following details as a new record in the athlete table: Last_Name Lee First_Name Sophia Athlete_ID 15310 Nationality NZL YOB 1982 Gender Female Check your data entry for errors. Save the data. [2]

Question

In the results table, locate the record with Athlete_ID 15318 and Event_ID MX321085 Amend the details as follows: Swim 00:19:38 T1 00:00:36 Position 1 Check your data entry for errors. Save the data. [1]

Question

Using fields from all tables, produce a tabular report that: • selects the records where: – Location includes the text ham – Nationality is AUS or NZL – Outcome is Complete • shows only the fields: First_Name, Last_Name, YOB, Nationality, Location, Outcome and Position in this order, with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Nationality and ascending order of Position • has a page orientation of portrait • fits on a single page • includes only the text Oceania Results as a title at the top of the page • has your name, centre number and candidate number on the report. Save and print your report. PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your report. [7]

Question

Using fields from all tables produce a tabular report that: • selects the records where: – Position is more than 0 and 5 or less – Gender is Female • contains a new field called Total_Transition which is calculated at run-time to add the contents of T1 and T2. Format this field to display time as hh:mm:ss • shows only the following fields: First_Name, Last_Name, Location, Swim, T1, Bike, T2, Run, Wetsuit, Total_Transition and Position in this order, with data and labels displayed in full. Do not group the data • sorts the data into descending order of Position • has a page orientation of landscape • fits on a single page wide • includes only the text Top Female Triathletes as a title displayed in a larger font size at the top of the page • calculates the number of database records shown in this report and places this at the end of the report, formatted as an integer • has a label Number of competitors to the left of this value • displays only your name, centre number and candidate number in the footer so it appears in the same position on every page. Make sure no other data is displayed in the footer. Save and print your report. PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on your report. EVIDENCE 6 Place in your Evidence Document a screenshot showing the database formula used to calculate the total number of competitors. [12] [Total: 29] Task 4 – Mail merge You are required to carry out a mail merge.

Question

Create a mail merge document using the file J2121CERT.rtf as the master document and J2121DATA.csv as your data source file. Enter your name, centre number and candidate number in the footer of the document. [1]

Question

Replace the text and chevrons in the master document with the merge fields from the data source file as follows: Text and chevrons to replace Replace with merge field <COMP> Name <COUN> Country <TIME> Total_Time <POS> Overall_Pos <GEN> Male_Female <G_POS> Gender_Pos <SW> Swim <TRANS1> T1 <BK> Bike <TRANS2> T2 <RN> Run Replace <DATE> with a field to display today’s date in the format dddd, dd MMMM yyyy Make sure the spacing, punctuation, alignment and enhancements in the original master document are maintained. Save and print your master document showing the merge field codes. EVIDENCE 7 Take screenshot evidence of the date field code showing the dddd, dd MMMM yyyy format used. Place this screenshot in your Evidence Document. PRINTOUT 4 Make sure you have entered your name, centre number and candidate number on your master document. [5]

Question

Set an automated filter to select competitors where: • Male_Female is Female • Gender_Pos is 3 or less EVIDENCE 8 Place in your Evidence Document a screenshot to show the use of an automated selection method. [1]

Question

Merge and print the certificates for the selected competitors only. Save and close the files. PRINTOUT 5 Print the result of the merge. Make sure you have entered your name, centre number and candidate number on your certificates. [1] [Total: 8] Task 5 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be formatted to display a title and bulleted list.

Question

Create a presentation of 8 slides using the file J2121TRI.rtf On slide 1 enter your name after the text Overview presented by: [1]

Question

Use a master slide to display the following features: • automatic slide numbers on the top right • your name, centre number and candidate number. Make sure that: • master slide items appear in the same position on every slide • there is no overlap on any slide. [1]

Question

Delete the slides with the titles History of Triathlons and Super Sprint Triathlon [1]

Question

Use the data in the file J2121PARTAKE.csv to create a pie chart to compare participation by age group for Triathlon only. [1]

Question

Label the chart with the title: Triathlon registrations by age [1]

Question

Format the chart to display only percentages and age groups as sector labels. Position these labels outside each chart sector. Do not display a legend. [3]

Question

Emphasise the age group with the largest percentage by pulling only this sector away from the other age groups. [1]

Question

Place the chart to the left of the bullets on the slide with the title Market Analysis Make sure that all data is fully visible with no overlap. [1]

Question

Apply the sound file J2121CHEER.wav to the slide with the title Ironman Triathlon so the sound plays automatically as the slide appears. EVIDENCE 9 Place in your Evidence Document screenshot(s) to show the sound is set to play automatically as the slide appears. [2]

Question

Save the presentation. Print slides 1, 2, 3 and 4 only as handouts with 2 slides to the page, each slide filling half the page. PRINTOUT 6 Print this handout. Make sure your name, centre number and candidate number are on all slides. [1] [Total: 13] Task 6 – Printing the Evidence Document

Question

Save and print your Evidence Document. PRINTOUT 7 Make sure that your name, centre number and candidate number appear on every page of your Evidence Document.