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

Question

Using a suitable software package, open the file j2421childcare.rtf The page setup is set to A4, portrait orientation with two-centimetre margins. Do not make any changes to these settings. Three paragraph styles have already been created. Do not make any changes to these unless instructed. Save the document in your work area with the file name NURSERY Make sure it is saved in the format of the software you are using. Place in your Evidence Document a screenshot to show this file has been saved. Make sure that there is evidence of the file type. [1]

Question

Place in the NURSERY document: • a right-aligned header on a single line: Prospectus produced by: followed by a space then your name, centre number and candidate number • a left-aligned footer with automated page numbers. Make sure that: • all the header details are on a single line • all the alignments match the page margins • no other text or placeholders are included in the header or footer areas • the headers and footers are displayed on all pages. [3]

Question

Create and store the following style, basing it on the default/normal paragraph style: Enhancement Space before Line spacing Space after Style name Alignment Font style Font size (points) (points) (points) TC‑title serif 32 centre bold, italic single 0 6 Take a screenshot to show that you have defined the settings for the TC-title style. Make sure that there is evidence that you have based this on the default/normal paragraph style. Place this in your Evidence Document. [2]

Question

Apply the TC-title style to the title text Tawara Tots Childcare [1]

Question

Select the subheading Staff and the following text up to and including the paragraph ending … enjoy their new surroundings. Change the page layout so that only this text is displayed in two columns of equal width with a one-centimetre space between the columns. [2]

Question

The style named TC-subhead has already been created, stored and applied to the five subheadings. Modify the TC-subhead style so that only the following formatting is applied: Enhancement Space before Line spacing Space after Style name Alignment Font style Font size (points) (points) (points) italic, bold, TC-subhead sans-serif 14 centre single 0 7 all capitals Take screenshot evidence to show you have modified the TC-subhead style and the settings applied. Place this in your Evidence Document. [2]

Question

Apply a numbered list, formatted as 1 to 7, to the text from: communication and language … to … arts and design Make sure that: • the numbers are aligned to the left margin of the column • the list is in single line spacing with no space before or after each line • there is a seven-point space after the last item in the list. [3]

Question

Import the image j2421logo.jpg and place it in the paragraph beginning We have eight spacious playrooms … Rotate the image 180 degrees with the image size and aspect ratio maintained. Format the image so that: • it is aligned to the right margin and the top of the paragraph starting We have eight spacious playrooms … • the text wraps around the image. [3]

Question

Locate the table in the document. Format the table so that: • the table width is set to 13 centimetres • all the rows are set to one-centimetre high • the data is centre aligned vertically in each row • the table is centred within the page margins. [4]

Question

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 original styles are maintained except the TC-subhead style changed in Step 6 • all 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. [1] [Total: 22] Task 3 – Database You are now going to prepare a report. Dates are to be imported in the format day month year (DMY).

Question

Use database software to import the file j2421child.csv as a new table. Use these field names and data types: Field name Data type Display Last_Name Text First_Name Text Child_ID Text Gender Text DOB Date/Time Day month year Reg_Date Date/Time Day month year Food_Allergy Boolean/Logical To display as Yes/No Contact_Name Text Relationship Text Contact_Number Text Set Child_ID as the primary key. Save the data. Place in your Evidence Document a screenshot showing the field names, data types and primary key. Import the file j2421bookings.csv as a new table in your database. Use these field names and data types and create a primary key field called ID: Field name Data type Display Session_ID Text Child_ID Text Day Text Start_Time Date/Time hh:mm End_Time Date/Time hh:mm Session Text Place in your Evidence Document a screenshot showing the field names, data types and primary key. [5]

Question

Create a one-to-many relationship between the Child_ID fields in the child and bookings tables. Place in your Evidence Document a screenshot showing the one-to-many relationship between the tables. [1]

Question

Using fields from the child and bookings tables produce a tabular report that: • selects the records where: – Day is Monday – Session is Morning or Sunrise Club • contains a new field called Total_Time which is calculated at run time Total_Time = (End_Time – Start_Time) × 24 Format this field to display as a numeric value to 1 decimal place • shows only the fields Child_ID, First_Name, Last_Name, DOB, Day, Session, Start_Time, End_Time, Total_Time and Food_Allergy in this order, with data and labels displayed in full. Do not group the data • sorts the data into descending order of Session and ascending order of DOB • has a page orientation of landscape • fits on a single page width • includes only the title Monday Morning Groups displayed in a larger font size, fully visible and centre aligned at the top of the page • has your name, centre number and candidate number in the footer of the report so that it appears in the same position on every page. Save and print your report. [11] You are now going to create a data entry form. The form will contain radio buttons for the user to select one option. Data from the selected option must be stored in a new field that you will create in the child table.

Question

Insert a new field in the child table named Ailment_ID which will be used to store data from radio buttons. Set the most appropriate data type. Place in your Evidence Document a screenshot showing the field names and data types used in the child table. Save and close the table. [1]

Question

Create a columnar data entry form, using selected fields from the child table, that: • includes only the fields Last_Name, First_Name, Child_ID, Gender, DOB, Reg_Date and Food_Allergy • displays one record at a time. Place in your Evidence Document a screenshot showing your form with a record from the database displayed. [2]

Question

In the form created in Step 15, create five grouped radio buttons. The user must be able to select one of the following options: – Asthma – Diabetes – Eczema – Epilepsy – None The option selected must be stored and displayed in the Ailment_ID field of the child table. Label this option group Ailment Make sure that: • the radio buttons are grouped as one option group with the label Ailment • the option selected is stored in the Ailment_ID field of the child table • all labels in the form are aligned to the left consistently and do not overlap other data in the form. Place in your Evidence Document screenshots showing: • the radio buttons grouped as one option group with the label Ailment • evidence of your method of linking this group to the Ailment_ID field. [6]

Question

Use the form modified in Step 16 to add the following data as a new record in the child table: Last_Name Lambert First_Name Jakara Child_ID 3YR27 Gender Female DOB 04/12/2022 Reg_Date 18/10/2023 Food_Allergy Yes Ailment Eczema Check your data entry for errors. Save the data. Place in your Evidence Document a screenshot of the form with the new record displayed in full. [1]

Question

Open the child table. Use an automated selection method to locate the new record you entered in Step 17 with the Child_ID 3YR27 Place in your Evidence Document screenshots showing: • the use of an automated selection method to find the record • the new record stored in the child table with all 11 fields displayed in full. [2] [Total: 29] Task 4 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting.

Question

Create a presentation of eight slides using the file j2421playgroup.rtf Unless otherwise instructed, the slides must display a title and a bulleted list. [1]

Question

Place at the top right of the slide a header with your name, centre number and candidate number. Place in the footer automated slide numbers left aligned. Make sure that: • the header and footer appear in the same position on every slide • no items overlap on any slide. [2]

Question

Locate the slide with the title Our staff Select the three bulleted items after the text …centre manager who: and format them to look like this: Our staff a dedicated centre manager who: all staff hold at least an approved Level 3 qualification trainee staff are supervised at all times all staff are qualified in Paediatric First Aid which is regularly updated staff ratio of at least one member of staff for every three children [3]

Question

Delete the slides with the titles Our guiding principles and Areas of learning and development [1]

Question

Use the data in the file j2421test_scores.csv to create a vertical bar chart to compare achievement for only the subjects literacy and mathematics. Display the subjects as labels on the category axis. [1]

Question

Label the chart with the title Impact of early childcare on test results [1]

Question

Display the following: • values only as data labels along the top of each bar • a legend showing Pre-school and No Pre-school [2]

Question

Format the value axis scale to display: • a minimum value of 0 • a maximum value of 56 • increments of 8 [2]

Question

Place the chart to the left of the bullets on the slide with the title Academic performance Make sure that: • no words are split • all data and labels are fully visible • the chart and its contents do not overlap any slide items. [1]

Question

On the slide with the title Long term benefits create an arrow-shaped action button that looks like this: Position this in the bottom-right corner. Format the action button so that when clicked it opens the document with the file name j2421lifelong.csv Enter the text Lifelong Gains in a black font on the action button. Make sure that: • the text displays on one line • the text fits within the shape and does not overlap the border. Take screenshot evidence showing the action button links to the correct file. Place this in your Evidence Document. Make sure that the file name is fully visible. [4]

Question

Save the presentation. Print the full presentation as handouts in portrait orientation with two slides to the page, each filling half the page. [1] [Total: 19] Task 5 – Printing the Evidence Document Make sure that your name, centre number and candidate number appear on every page of your Evidence Document. Save your Evidence Document. Print your Evidence Document.