Information Technology 9626/2 May/June 2019: question paper and mark scheme

Question

Open and examine the file Ellmau1.mp4 and set the image ratio to 16:9. Remove the first 4.8 seconds of the clip. Trim the clip so that only 10 seconds remain. [4]

Question

Take a snapshot of the first frame from the video clip. Add the file EllmauArms.png in the top right corner to create a background image for a title sequence, like this: [5]

Question

Place this title background at the start of your video and display it for 10 seconds. [2]

Question

Add the text Celebrate the New Year with us to the title in a white sans serif font like this: Add an appropriate animation to place this text. [5]

Question

Take a snapshot of the last frame of the video clip to create a background image for a caption. Create a caption and display it for 7 seconds. Place this at the end of the video. Ensure that the caption text is easy to read with three lines of text identifying the: • location • fireworks at midnight • date of the event. Add a different, appropriate effect to place the caption. [9]

Question

Place the video clip Ellmau2.mp4 after the caption. Use a 2-second transition to change from the caption background to the video clip. [2]

Question

Select an appropriate background and transition for the credits. Place this at the end of the video and display it for 7 seconds. Add appropriate credits to match the brief. Include your name, centre number and candidate number. [10]

Question

Evidence 1 Export your video in mp4 format with the filename Ellmau_1_ followed by your centre number_ candidate number, for example: Ellmau_1_ZZ999_9999 [2]

Question

Open and examine the file Opera.mp3 in appropriate editing software. Remove the end of the clip so that only 43 seconds remain. [2]

Question

Edit this file so that it has an appropriate fade in and fade out. [4]

Question

Evidence 2 Save this audio clip in mp3 format with the filename Opera2_ followed by your centre number_ candidate number, for example: Opera2_ZZ999_9999 [1]

Question

Add this soundtrack to your video so that they start and finish at the same time. [1]

Question

Evidence 3 Export your video in wmv format with the filename Ellmau_2_ followed by your centre number_ candidate number, for example: Ellmau_2_ZZ999_9999 [1]

Question

Evidence 4 Export or convert your video into avi format with the filename Ellmau_3_ followed by your centre number_candidate number, for example: Ellmau_3_ZZ999_9999 [2] Employees in Ellmau who work with tourists have to be registered. The types of venue that need to register are hotels, restaurants and ski schools. The data is held in two data files which are stored in different formats. All reports must fit on a single portrait page wide when printed on A4 paper with text at least 12 points high. All files produced must be of a professional standard. The client has decided that all database field names must be short, meaningful, consistent in style and contain no spaces or underscores.

Question

Using suitable software, open and examine the data in the files: EllmauEmployees1.csv EllmauEmployees2.txt These files need to be merged together so that they can be used to develop a database. Evaluate, using less than 100 words, the suitability of these data files for this purpose. [6] Evidence 5 Place your evaluation in your Evidence Document.

Question

Manipulate and merge the two files examined in step 15. Examine the Venue type data and use this to create the Venue type code for each employee using: • H for Hotel • R for Restaurant • S for Ski school. The age and date of birth of the employees will not be used in the database. Save the new file in comma separated value format, with the file name Employees followed by your candidate number, for example: Employees9999 [3]

Question

Using suitable software, open and examine the data in the file: EllmauJobs.csv Use this and the file you saved in step 16 to create a relational database normalised to third normal form (3NF). [42] Evidence 6 Save your database as Ellmau_ followed by your centre number_candidate number, for example: Ellmau_ZZ999_9999

Question

Create a report to identify how many chefs and how many trainee chefs work at each venue. The report must be in a tabular format with gridlines and have the venue names and addresses as row headings. Do not include any totals. [4] Evidence 7 Save your database.

Question

Name another IT application that could store the original data without using a database. Explain the advantages of a relational database for this solution, compared to this other method you have named. [5] Evidence 8 Place your answers in your Evidence Document. Save your Evidence Document.