Skip to content

Computer Applications Technology Grade 12 P1 2021 QP (Eng)

Question paperComputer Applications TechnologyGrade 12202116 pages

Grade 12 Computer Applications Technology Paper 1 question paper from the Eastern Cape Mock Exam 2021 (English), 16 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2021 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKS: 150 TIME: 3 hours This question paper consists of 16 pages, an HTML tag sheet and an input mask character sheet and an information sheet.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) INSTRUCTIONS AND INFORMATION 1. Owing to the nature of this practical examination, it is important to note that, even if you complete the examination early, you will NOT be permitted to leave the examination room until all the administrative functions associated with the examination have been finalised. During the examination, the normal rules regarding leaving the examination room apply. 2. If you are working on the network, or the data files have been preloaded, you must follow the instructions provided by the invigilator/teacher. Alternatively, the invigilator will give you a CD/DVD/flash drive containing all the files needed for the examination. If a CD/DVD/flash drive has been issued to you, you must write your examination number and centre number on the CD/DVD/flash drive. 3. At the end of the examination, you must hand in the CD/DVD/flash drive given to you by the invigilator with ALL your answer files saved onto the CD/DVD/flash drive, OR you should make sure that ALL the answer files are saved on the network/computer as explained to you by the invigilator/teacher. 4. Make absolutely sure that ALL files can be read. Do NOT save unnecessary files/folders and do NOT hand in duplicate answer files/folders. Do NOT delete any original files that you did not work on. 5. The information sheet that has been provided with the question paper MUST BE COMPLETED AFTER THE THREE-HOUR EXAMINATION SESSION. Hand it to the invigilator at the end of the examination. 6. A copy of the master files will be available from the invigilator. Should there be any problems with a file, you may request another copy from the invigilator. 7. This question paper consists of SIX questions. Answer ALL the questions. 8. Read through each question before answering or solving the problem. Do NOT do more than is required by the question. 9. Ensure that you save each document using the file name given in the question paper. Save your work at regular intervals as a precaution against possible power failures. 10. You may NOT use any resource material. 11. Accuracy will be taken into account, e.g. if a question requires the answer to be in cell F3 in a spreadsheet, and you enter the answer in cell G4, it will NOT be marked. Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 3 12. Ensure that the regional settings are set to South Africa and date and time settings, number settings and currency settings are correctly set. 13. In all questions involving word processing, you should set the language to English (South Africa). The paper size is assumed to be A4 Portrait, unless instructed otherwise. Use centimetres as the unit of measurement. 14. Formulae and/or functions must be used for ALL calculations in questions involving spreadsheets. Use absolute cell references only where necessary to ensure that formulae are correct when you copy them to other cells in a spreadsheet. NOTE: All formulae and/or functions should be inserted in such a manner that the correct results will still be obtained even if changes are made to the existing data. 15. You may NOT use a word processing program such as Word to answer the HTML question. 16. The examination folder/CD/DVD/flash drive that you receive with this question paper contains the files listed below. Ensure that you have all the files before you begin this examination. Copyright reserved Please turn over
Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) SCENARIO Each year on the 8th of September the world celebrates World Literacy Day. The purpose of this day is to make people aware of the high illiteracy rate in the world and use measures to decrease it. Your school took a decision to use the Grade 12 CAT learners to promote digital literacy among members of the community. Various courses will be done to educate people on Digital Literacy. QUESTION 1: WORD PROCESSING A document was created to give more information about the World Literacy Day. Open and edit the 1_World Literacy Day word processing document. 1.1 Insert a cover page in the document. The cover page must display the following: 1.1.1 Select the Filigree Cover page. (1) 1.1.2 Type the document name and date in the required field. Delete all other fields. (2) 1.2 The table of content has been inserted. Please do the following:  Modify the table of contents so that the headings of Heading 2 appear. (2) 1.3 Edit the page numbering so that number 1 appears on the page after the table of contents. (3) 1.4 Locate the paragraph under the heading ‘What is World Literacy Day?’ and apply a Green Accent 6 shading to the whole paragraph. (2) 1.5 Find the text Miriam Webster Dictionary marked in yellow under the heading History of International Literacy Day.  Insert a footnote with the following explanation: America's most trusted online dictionary for English word definitions, meanings and pronunciation.  Ensure that the footnote is below the text. (3) Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 5 1.6 Find the picture Figure 1 and move it to the right of the paragraph as shown below. Set the size of the picture to height 3.5 cm and width 7.5 cm. (3) 1.7 Locate the Placeholder 1 marked in blue. Edit the placeholder by inserting the following source:  Book title: Practical guide to functional literacy: a method of training for development.  Published in 1973. (3) 1.8 Emphasise all the occurrences of the word ‘literacy’ by making the words bold. Only ‘literacy’ in lowercase must be changed. (2) 1.9 Set the orientation of ONLY the second last page to landscape. (2) 1.10 Locate the table under the heading International Literacy Day Dates and modify as follows:  Apply a Grid Table 4 Accent 6 style.  Edit the style to align text horizontally and vertically. (3) 1.11 Use a word processing feature to count the number of words in the document starting from the heading, ‘What is World Literacy Day?’ up to the end of paragraph 4.5. (1) [27] Copyright reserved Please turn over
Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 2: WORD PROCESSING A registration form has been created for the attendees to fill in and e-mail to the registration office. Open the 2_Registration Form word processing document and modify the document as follows. 2.1 Set the top and the bottom page margins to 1 cm. (1) 2.2 Insert a double line page border for the page. (1) 2.3 Centre the picture and apply a soft edge oval picture style. (2) 2.4 Set the text form field for the title to:  Maximum length to 4  Text format to uppercase (2) 2.5 Modify the dropdown form field for Gender field to include:  Male and Female as choice options.  Add a help message ‘For accommodation purposes’ on help text. (3) 2.6 Modify the horizontal hierarchy for the courses to resemble the image below. (3) 2.7 Locate the text, ‘Insert here’ and insert the pdf file ‘Benefits-digital- literacy.pdf’ as an embedded file. The file must show as an icon. (3) 2.8 Add the text, ‘Registration Form’ in the footer of the document. Right align the text. (2) [17] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 3: SPREADSHEET Various courses will be offered to the community members and they have to register for them. A spreadsheet 3_Attendees has been created to record all the attendees. Open the 3_Attendees spreadsheet and work in the Attendee_Info worksheet. 3.1 Improve the readability of the spreadsheet by applying the following formatting features to the worksheet. 3.1.1 Merge and centre rows A1 to X2. (1) 3.1.2 Align the headings in A8 to G8 horizontally and vertically. (1) 3.1.3 Use the word processing feature to ensure that the contents in rows 1 to 8 remain on the screen when the user scrolls down. (1) 3.2 Use a function in cell G7 to add today’s date in the format yyyy-mmmm-dd. (2) 3.3 Use a suitable function in cell B9 to add a suitable title for the attendee. The male attendees must have ‘Mr’ as their title and female attendees must have ‘Ms’. (3) 3.4 Add a function in cell S10 to calculate the number of courses Ewie Langhon will attend. (3) 3.5 The amount for each course is in cell V7. In cell U11 calculate the total amount Bambie Mulles will pay for his courses. Make sure that the formula will work correctly when copied down. (3) 3.6 Barnabas decided to do all 11 courses and has paid 75% of the total amount. In cell V13 calculate the amount paid by Barnabas. (2) 3.7 Use a word processing feature in column D (Last Name) to automatically highlight with the colour of your choice any person who does not have a laptop. (3) 3.8 The attendees are grouped into four teams depending on how many courses they do.  5 courses and less are Greens.  8 courses and less are Blues.  10 courses and less are Reds.  More than 10 courses are Yellows. Insert a function in cell W9 to determine in which team Ogdon Polly is. Copy the formula to the other cells. (4) Copyright reserved Please turn over
Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) 3.9 The organisers decided to give a discount to attendees who own a laptop and have already paid R50,00 deposit. Insert a function in cell X9 to display the text ‘Discount’ for those people who do qualify for a discount and leave the cell blank for those who do not qualify. (4) 3.10 Insert a function or a formula in cell G111 to determine and display the current age of the last person, Nichole. This function or formula must give the correct age even if the current date changes. (3) 3.11 Insert a LOOKUP function in cell G113 to determine how many attendees attended the Budget Intermediate Course. Use the information in the Statistics worksheet. (5) 3.12 Insert a function in cell G115 to calculate the total amount that will be paid by attendees who own a laptop. (4) 3.13 A graph has been created in the Statistics worksheet. Modify the graph as follows:  Format the chart area of the graph by adding the picture, 3Digital Literacy, found in your data folder, as a background picture.  Set the transparency of the picture to 50%.  Use a filter option to remove the two courses, Typing a letter and Budget.  Add a data callout label to the most popular course.  Use a spreadsheet feature to move the graph to a new worksheet called Graph. (7) [46] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 4: DATABASE The information of the attendees needs to be stored in a database. Modify the database provided and work in the design view, except when requested otherwise. Open 4_Digital Literacy database and do the following: 4.1 Table: Personal Information 4.1.1 Add a validation rule to the Date of Birth field to prevent the user from entering a date later than the current date. (3) 4.1.2 Each course is assigned with a code. Add an input mask to the Course Code field to only accept a code in the following format:  Three optional digits,  followed by a hyphen,  followed by three compulsory uppercase letters, eg. 22-DLC, 1-SBE or 398-KPP. (4) 4.1.3 Insert a combo box for the Course field so that the list of courses can be selected. The courses are stored in the table Course Information. (3) 4.2 Open the form Attendee Information. Add a function to the details tab to:  Calculate the age of the attendee in years.  Format the function to display the age as a whole number.  Display a suitable label for the calculated age. (6) 4.3 Queries 4.3.1 Modify Qry4_3_1 to:  Display all attendees who are 18 years and younger.  Sort the attendees according to the Level of Literacy in descending order. (3) 4.3.2 The organisers want to give the attendees Internet data. Only Vodacom vouchers are available. They decided to give money to other attendees. Modify Qry4_3_2 as follows:  Show all users who do not use Vodacom.  Create a calculated field called Data to calculate the money that each person will receive. Each person will be given an allowance of R30 per day.  Calculate in datasheet view the total amount that will be spend on the attendees. (6) Copyright reserved Please turn over
Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) 4.4 Report Create a report called rpt4_4 based on the Attendee Information table.  Show only the following fields: Last Name, Date of Birth, Gender, No of Courses, Level of Literacy and No of days to attend.  Group the records according to the Gender.  Then sort according to Level of Literacy.  Display the report in landscape format.  Insert a function in the group footer to calculate the number of female and male attendees.  Add a descriptive label to the calculation.  Ensure that all the data displays fully. Save and close the rpt4_4. (10) [35] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 11 QUESTION 5: WEB DESIGN (HTML) Open the incomplete 5_Digital Literacy.html web page in a web browser and also in a text editor. You may NOT use a word processing program such as Word to answer the HTML question. NOTE:  Question numbers are inserted as comments in the coding as guidelines to show approximately where the answer(s) should be inserted. Do NOT delete the comments.  A HTML tag sheet has been attached for reference. Your final web page should look like the example below. 5.1 Set the website page colour to Cream. (2) 5.2 Rectify the error that occurred when the webmaster was inserting a picture. Centre the picture. (3) 5.3 Fix the error under the heading ‘What are the challenges to digital literacy?’ to be bulleted, using square bullets. (2) Copyright reserved Please turn over
Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) 5.4 Modify the table as follows:  Change the colour of the table to pink.  The border must be 5 pt and width 70%.  Row 7 must be merged across the three columns; the text must be centred and in bold. (6) 5.5 Create a link on the text below the table to open the Brochure file in your data folder. (3) [17] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 13 QUESTION 6: GENERAL Open 6_Digital Technology in SA and modify the document as follows: 6.1 Locate the two words, ‘South Africa’ in the first paragraph. Use a word processing feature to ensure that the two words remain together even if they are pushed to the next line. (1) 6.2 Find the paragraph that is bordered and filled with an orange fill on the first page. Move it and paste it at the end of the document without keeping the current formatting. (2) 6.3 The author of the document has made two changes in the document. Find the two changes and accept them. (1) Open 6_Compare 6.4 Use a word processing feature to compare the two documents: 6_Compare and 6_Compare 1. Make a screenshot of the results and paste it at the end of the 6_Compare document. (4) [8] TOTAL: 150 Copyright reserved Please turn over
Downloaded from hlayiso.com 14 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) ANNEXURE A – HTML TAG SHEET Basic Tags Formatting Tags continued Tag Description Tag Description <body></body> Defines the body of the web <li></li> Inserted before each list Page item, and adds a number or <body Sets the background colour of symbol depending upon the bg color="pink"> the web page type of list selected <body text="black"> Sets the colour of the body <img src="name"> Adds an image text <head></head> Contains information about the <img src="name" Aligns an image: can also be document align="left"> "right", "center"; "bottom", "top", "middle" <html></html> Creates an HTML document – <img src="name" Sets size of border around starts and ends a web page border="1"> an image <title></title> Defines a title for the <img src="name" Sets the height and width of document width="200" height an image <!-- --> Comment ="200"> Text Tags <img src="name" Displays alternative text alt="alternative when the mouse hovers over Tag Description text"> the image or when the image <hl></hl> Creates the largest heading is not found <h6></h6> Creates the smallest heading <hr/> Inserts a horizontal line <b></b> Creates bold text <hr size="3"/> Sets size (height) of line <i></i> Creates italic text <hr width="80%"/> Sets width of line, in percentage or absolute value <font Sets size of font, from "1" to <hr Sets the colour of the line size="3"></font> "7" color="ff0000"/> <font Sets font colour Table Tags color="green"></font> <font face="Times Sets font type Tag Description New Roman"></font> Link Tags <table></table> Creates a table Tag Description <tr></tr> Creates a row in a table <a href="URL"></a> Creates a hyperlink <td></td> Creates a cell in a table <a href="URL"><img Creates an image link <th></th> Creates a table header (a src="URL"></a> cell with bold, centered text) <a name="NAME"></a> Creates a target location <table width="50"> Sets the width of the table <a href="#NAME"></a> Links to a target location <table border="1"> Sets the width of the border created somewhere else in the around the table cells document Formatting Tags <table Sets the space between the cellspacing="1"> table cells Tag Description <table Sets the space between a cellpadding="1"> cell border and its contents <p></p> Creates a new paragraph <tr align="left"> Sets the alignment for cell(s) (can also be "center" or "right") <p align="left"> Aligns a paragraph to the "left" <tr valign="top"> Sets the vertical alignment (default), can also be "right", or for cell(s) (can also be "center" "middle" or "bottom") <br/> Inserts a line break <td colspan="2"> Sets the number of columns a cell should span <ol></ol> Creates a numbered list <td rowspan="4"> Sets the number of rows a cell should span <ol type="A","a", Defines the type of numbering "I","i","1"></ol> used <ul></ul> Creates a bulleted list <ul type="disc", Defines the type of bullets "square","circle"></ used ul> Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 15 INPUT MASK CHARACTER SHEET CHARACTER DESCRIPTION 0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed) Digit or space (entry not required, plus [+] and minus [–] signs not 9 allowed) Digit or space (entry not required; spaces are displayed as blanks while # in Edit mode, but blanks are removed when data is saved; plus [+] and minus [–] signs allowed) L Letter (A to Z, entry required) ? Letter (A to Z, entry optional) A Letter or digit (entry required) a Letter or digit (entry optional) & Any character or a space (entry required) C Any character or a space (entry optional) Decimal placeholder and thousand, date and time separators (The actual .,:;-/ character used depends on the settings in the Regional Settings Properties dialog box in the Windows Control Panel.) < Causes all characters to be converted to lower case Causes all characters to be converted to upper case to right. You can > include the exclamation point anywhere in the input mask. Causes the input mask to display from right to left, rather than from left to ! right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask. Causes the character that follows to be displayed as the literal character \ (for example, \A is displayed as just A) Copyright reserved Please turn over
Downloaded from hlayiso.com 16 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 – SEPTEMBER 2021 INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour session) SCHOOL: NAME: WORK STATION NUMBER: _______________________________ SUITE USED Microsoft Office Microsoft Office Microsoft Office Office 365 (Mark appropriate box 2010 2013 2016 with a cross (X)) WEB BROWSER USED Other (Specify) (QUESTION 6) Mozilla Firefox Google Chrome Internet Explorer (Mark appropriate box with a cross (X)) FOLDER NAME: Tick if saved and/or attempted. Question File name Saved Attempted Maximum Maximum Marker HOD Cluster EM Number (√) (√) mark achieved 1 1_World Literacy Day 27 2 2_Registration Form 17 3 3_Attendees 46 4 4_Digital Literacy 35 5 5_Digital Literacy 17 6 6_Digital 8 Technology in SA 6_Compare 6_Compare 1 TOTAL: 150 Comment (for marker use only) Copyright reserved Please turn over

Study this subject

More from Grade 12 Computer Applications Technology

View all