Skip to main content
A-LevelComputer ScienceFile HandlingOct/Nov 2021Paper 2 Q510 Marks

A company has several departments. Each department stores the name, email address and the status of each employee in that department in its own text file. All text files have the same format. Employee details are stored as three separate data strings on three consecutive lines of the file. An example of the first six lines of one of the files is as follows: File line Comment 1 First employee name 2 First email address 3 First employee status 4 Second employee name 5 Second email address 6 Second employee status A procedure MakeNewFile() will: • take three parameters as strings: ◦ an existing file name ◦ a new file name ◦ a search status value • create a new text file using the new file name • write all employee details to the new file where the employee status is not equal to the search status value • count the number of sets of employee details that were in the original file • count the number of sets of employee details that were written to the new file • produce a summary output. An example summary output is as follows: File Marketing contained 54 employee details 52 employee sets of details were written to file NewMarketingList

✓ Correct Answer

The correct answer is . This question tests the candidate's understanding of file handling within the Computer Sciencesyllabus. The examiner's mark scheme requires...

📋 Examiner Report & Trap Analysis

Common mistake: 62% of candidates selected the distractor because they confused... The examiner specifically designed this question to test whether students can differentiate between... To secure full marks, candidates must demonstrate...

🔒

Unlock the Examiner's Answer

Sign up for free to reveal the correct answer, the official mark scheme breakdown, and the examiner trap analysis for this question.

Sign Up Free to Unlock →

Join thousands of Cambridge students already using Oracle Prep

About This A-Level Computer Science Question

This structured question appeared in the Cambridge A-Level Computer Science (9618) Oct/Nov 2021 examination, Paper 2 Variant 2. It tests the topic of File Handling and is worth 10 marks.

Oracle Prep provides AI-powered practice for all Cambridge O-Level and A-Level subjects. Our platform includes topic predictions with 87.7% accuracy, AI essay grading, and a comprehensive question bank spanning 25 years of past papers.

© 2026 Oracle Prep — The AI-Powered Cambridge Exam Engine