Information Technology 9626/2 October/November 2019: question paper and mark scheme

Question

Create a new video and set the image ratio to 16:9 Create title frames with a white background and a copy of the image Ski1.png down each side of each frame. Add the text Ellmau Kinder-Skischule in a red, 60 point, sans-serif font, like this: Add an appropriate effect to place this text. Display this title for 7 seconds. [13]

Question

Open and examine the file Skischule1.mp4 Trim the clip so that only the first 8 seconds remain. Remove the soundtrack from the clip. Place the clip after the title frames. [4]

Question

Open and examine the file Skischule2.mp4 Trim the clip so that only the first 13 seconds remain. Remove the soundtrack from the clip. Place the clip at the end of the video. Add a 3-second transition effect between the two video clips. [4]

Question

Take a snapshot of the last frame of the video clip to create a background image for both the caption and the credits. Place this at the end of the video and display this for the final 14 seconds (7 seconds for the caption and 7 seconds for the credits). Create the caption and ensure that the caption text is easy to read with three lines of text identifying: • who the ski school is for • what is its purpose • the location of the ski school. Add appropriate credits to match the brief. Include your name, centre number and candidate number. [14]

Question

Evidence 1 Export your video in mp4 format with the filename SkiSchool_1_followed by your centre number_candidate number. For example: SkiSchool_1_ZZ999_9999 [2]

Question

Describe five benefits of normalisation. Evidence 2 Place your answer in your Evidence Document. [5]

Question

A query has been designed to help a company, which sells cars, to search their database. Analyse and evaluate this query: Field: RegistrationPlate Make Model Fuel Colour Engine size Table: Cars Cars Cars Cars Cars Cars Sort: Show: Criteria: [Enter vehicle make] [Enter vehicle model] [Enter code for fuel type] or: [6] Evidence 3 Place your analysis and evaluation in your Evidence Document. Employees in Ellmau who work with tourists have to be registered. This data will be stored in a database. All reports must be designed to fit on an A4 page in portrait orientation and be a single page wide. All text must be at least 12 points high. All reports produced must be of a professional standard. The client has decided that all database field names must be short, meaningful and consistent in style. Field names may contain underscores but not spaces.

Question

Using suitable software, open and examine the data in the file: Employees.txt Use this data to create a relational database normalised to third normal form (3NF). [39]

Question

A local business wants to present awards on 1 December 2019 to younger employees, who, on this date, will have been in the same employment for over 10 years. Create a report with an appropriate title, containing details of employees born after 1990 so that it is grouped and formatted like this: [15] Report prepared by A Candidate ZZ999 9999 Administration/Office Skischule Skiverleih Kinderpiste Kapellenweg 8 6352 Ellmau Vanessa Schweiger 25/04/1991 20/04/2009 Snowboard Instructor Skischule Skiverleih Kinderpiste Kapellenweg 8 6352 Ellmau Marlene Hofmann 27/03/1991 12/12/2008 Chambermaid AktivHotel Hochfilzer Dorf 34 6352 Ellmau Konstantin Hofbauer 27/06/1991 21/01/2007

Question

Create a report to display only the employees who are trainees. Identify, for each job described, how many trainees work in each place of employment. The report must have an appropriate title, display gridlines, be in a tabular format and display the place of employment as row headings. Do not include totals for each place of employment. [8] Evidence 4 Export this report in portable document format (pdf) as Trainee_followed by your centre number_candidate number. For example: Trainee_ZZ999_9999 Evidence 5 Save your database as Nov19_followed by your centre number_candidate number. For example: Nov19_ZZ999_9999 Save your Evidence Document.