AS & A Level Information Technology (9626) — May–June 2025, Paper 02
16 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.
Start with Question 1 →You work for the Tawara Scuba School. Open and examine the file j25teacher.csv using spreadsheet application software. Name this worksheet Teacher. Open and examine the file…
Answer this question and get it marked →Place in cell B3 the date 13/03/2025. Format this date as dd mmmm yyyy.
Answer this question and get it marked →Set cell B4 so that the name of the teacher can be selected from a drop-down list. The Teacher worksheet can be edited if required.
Answer this question and get it marked →Place in cell B6 a formula to look up the code for the teacher selected in cell B4.
Answer this question and get it marked →Place in cell B7 a function to return the day code of the date entered in cell B3. For example, Sunday = 1, Monday = 2.
Answer this question and get it marked →Place in cell B8 a function to return the day of the week for the date entered in cell B3.
Answer this question and get it marked →Place in cell B9 INDEX and MATCH functions to display the string for this teacher's lessons, using the teacher code and day of the week. (a) The INDEX part of the formula…
Answer this question and get it marked →Place in cells B13 to E13 formulae to display the name of the subject for each class. The string in B9 encodes subject code, period and room for each class in sequence (e.g.…
Answer this question and get it marked →Place in cells B14 to E14 formulae to display the time of each class.
Answer this question and get it marked →Place in cells B15 to E15 formulae to display the room used for each class.
Answer this question and get it marked →Edit the formulae in cells B13 to E13 so that if there is no data for this class, it does not display an error. (Row 13 — subject name formulae)
Answer this question and get it marked →Replace the labels in cells B12 to E12 with formulae to display the labels Class 1 to Class 4 only if there is data for that class. If there is no data, the label should not be…
Answer this question and get it marked →Create a new word-processed document saved as TestPlan followed by your centre numbercandidate number. Create a test plan to test the restricted data entry in cell B3. Include the…
Answer this question and get it marked →Tawara Scuba School is developing a short video to advertise its company. Open your video-editing software and set the aspect ratio to 16:9. Open and examine the file…
Answer this question and get it marked →In your video-editing software, open and examine the file j25divers.mp4. Splice the file saved in step 14 to the end of this clip. (a) Splicing: j25divers.mp4 placed first, Clown…
Answer this question and get it marked →Use the file saved in step 15 to create a video clip to match the storyboard. All text must be displayed in a consistent sans-serif font. Do not use transitions unless instructed.…
Answer this question and get it marked →← All AS & A Level Information Technology (9626) past papers