Information Technology P1 IT Learner files

November 2009 — Grade 12 / Matric — Information Technology

Past Paper 2009 Grade 12 English

↓ Download PDF 📄 312.8 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 120 marks ⏱️ 3h 📄 23 pages 📝 60 items found 📚 6 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.

Q1— Section header —

Q2— Section header —

Q3— Section header —

Q1— Section header —

1.1Complete the code in the List button by formulating an SQL statement to display all the fields from the tblClients table sorted by Surname and then by

1.2Mr Ferreira button by creating a query that will calculate the total amount owed by Mr Ferreira ( ClientNo field entry is 1). swer. The heading must be must be formatted to display with TWO decimal places.

1.3All the bookings for the been cancelled. Complete English clients ( Nationality tblClients table.

1.4The group uses a 25% markup when calc the code for the Date and (selling price minus the 25% markup) for each item ordered by Mr Guiseppe Ferreira ( ClientNo the

1.5The Petersen Group has decided that t hey want to support all soccer fans by giving them R5,00 discount on the se lling price of every item they have ng price is R30,00 or more the button by writing a quer

1.6Complete the code for the Faltemeyer the following client data to the tblClients Mr Harald Faltemeyer , ID 7407185683074, Swedish NOTE: The content of the

Q2— Section header —

2.1Create an object cla ss (another unit) named ExtraItem_Uxxxx unit as in your Quest2_X folder (xxxx should be replaced your examination number). All fields in this class fields and methods that you need to

2.1.2Write a constructor method must be initialised in the constr uctor. (4)4

2.1.3Write an appropriately named 'get' method (accessor method) to return the guest number. (2)2

2.1.42

2.1.5Write a method named calculatePrice that calculates the final (2)2

2.1.6Write a method named with information on the item formatted as follows:

2.2.1Create an array named arrItems that holds TExtraItem Write code in the according to the following steps: Display a suitable me

2.1.1

2.2objects. OnActivate Eventhandler of the form to read information from the text file Extras.txt (a\ Test if the text file exists. NSC

Q3— Section header —

3.1Write code to convert all the alphanumeric characters in the arrPhoneNos Replace the alphabetic characters (upper case and lower case) in the

3.2Use the numerical phone num bers to check that ther e are no duplicates in the numbers. If no duplicates At the end of the list t were found (if any).

Q1— Section header —

1.1List to display all the fields from the tblClients table sorted by and then

1.2Mr Ferreira ) by creating a query that ClientNo Total Due and the lay with TWO decimal places.

1.3All the bookings for the been cancelled. Complete the code for menu option C ( English by creating a query to delete all English clients ( Nationality

1.4The group uses a 25% markup when calc the code for menu option D Date and (selling price minus the 25% markup) for each item ordered by Mr Guiseppe Ferreira (

1.5The Petersen Group has decided that t hey want to support all soccer fans by giving them R5,00 discount on the se lling price of every item they have ng price is R30,00 or more menu option E

1.6Complete the code for menu option F add the following client data to the table: Mr Harald Faltemeyer , ID 7407185683074, Swedish

Q2— Section header —

2.1Create an object class named ExtraItemxxxx.java and save this class as ExtraItemxxxx.java in your Quest2_X fields and methods that you need to create and code are described below:

2.1.1ExtraItemxxxx . Create appropriately named and typed private fields (suggested field names are given in brackets): guestNum cost

2.1.2Write a constructor method which accepts the guest number, the item description and the cost per item as parameters. All the fields must be initialised in the constructor.

2.1.3Write an appropriately named 'get' method (accessor method) to return the guest number. (2)2

2.1.42

2.1.5Write a method named calculatePrice that calculates the final st + the calculated profit). (2)2

2.1.6

2.2.1Create an array named arrItems ExtraItemxxxx . Write code to read informa tion from the text file Extras.txt according to the following steps: Display a suitable message if the file

2.2that holds objects of (a\ Test if the text file exists. NSC from the text file.

2.2.2

Q3— Section header —

3.1Write code to convert all the al phanumeric characters in the The numeric values in the telepho ne numbers remain as they are.

3.2Use the numerical telephone numbers to the array. If duplicates are found, t he program must display the duplicate At the end of the list t were found (if any). Example of the output:

Q1— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total120 marks

Sections40 + 37 + 40 + 43 + 37 = 197 marks

Per-question sum216 marks

Key Information

Contact Number0718568307 · 086 345 6546

Paper information

SubjectInformation Technology

Year2009

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages27

Downloads6

Examination context

Decade2000s

Years ago17y

SeasonSpring (SH)

Start dayThursday

Exam periodNovember 2009

Days since exam6,198

About Information Technology examination preparation

This Grade 12 examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.

How to use this resource for revision

A past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?

For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.

understanding question requirements

applying subject knowledge

working under time constraints

checking answers

identifying revision priorities

A practical revision approach

Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.

Grade 12 subject hubs

Each matric subject has its own dedicated hub on Freemode with every past paper and marking memorandum we have archived for that subject.

➗ Mathematics View papers → 📊 Mathematical Literacy View papers → ⚗️ Physical Sciences View papers → 🧬 Life Sciences View papers → 📒 Accounting View papers → 💼 Business Studies View papers → 📈 Economics View papers → 🌍 Geography View papers → 🏛️ History View papers → 📖 English View papers → 🇿🇦 Afrikaans View papers → 🗣️ IsiNdebele View papers → 🗣️ IsiXhosa View papers → 🗣️ IsiZulu View papers → 🗣️ Sepedi View papers → 🗣️ Sesotho View papers → 🗣️ Setswana View papers → 🌾 Agricultural Sciences View papers →

Corresponding marking memorandum

Marking memorandum available

Use the corresponding memorandum after completing the paper to review your answers and identify areas that require further revision. The memorandum shows the marking approach used by DBE examiners, including method-mark allocations.

Information Technology Memo 1 (English) →

File details

File size312.8 KB

Pages27

Archived on11 October 2026

File age14d

ContributorFreeMode

Fingerprint39A85D4EADA8

Questions and learner discussion

No questions or discussions have been posted yet.