# Computer Applications Technology Grade 12 P1 2016 Memo (Eng)

> Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC June Exam 2016 (English), 14 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-memo-eng/fb474999-ae1e-4cfe-b1bd-c4aac95bb1b8
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2016
- Exam period: NSC June Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 14

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2016 Memo (Eng)](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-memo-eng/fb474999-ae1e-4cfe-b1bd-c4aac95bb1b8)

## About this document

Computer Applications Technology · Grade 12 · NSC June Exam · 2016. Memorandum, 14 pages. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

Downloaded from hlayiso.com

                     SENIOR CERTIFICATE EXAMINATIONS

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                          2016

                        MEMORANDUM/MARKING GUIDELINE

MARKS: 180

CENTRE                                                FINAL MARK
NUMBER

EXAMINATION
NUMBER

QUESTION                 1     2      3          4    5      6      7         TOTAL

POSSIBLE MARK           24    26      25         25   42     19     19          180

CANDIDATE'S
MARK

MARKER CODE/
SIGNATURE

MODERATED
MARK

              This memorandum/marking guideline consists of 14 pages.

Copyright reserved                                                      Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1              2                                    DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

IGNORE SPELLING IN CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE
ANSWER.

QUESTION 1                         File name: 1Effect_Effek                             Total Q1: 24

                                                                                         Candidate
 No                               Criteria                                 Max Mark
                                                                                           Mark
1.1.1   First Page                                                                3
        • (Any) picture added to first page                           1
        • Correct picture 1Music_Musiek added                         1
        • Picture wrapping/alignment changed to appear at top
           right-hand corner of page                                  1
1.1.2   First Page                                                                2
        • Text box added (anywhere) to the first page                 1
        • 'Elvis High School' added as text to the text box           1
1.2     Styles                                                                    3
        • New style 'Music' created                                   1
        • Font size formatted to 48 pt                                1
        • Text centred                                                1
1.3     Page Border                                                               2
        • Any page border added                                       1
        • First page only                                             1
1.4     Watermark                                                                 2
        • Watermark text: 'First Draft' added                         1
        • Watermark text added only to first page                     1
        (Note to marker: Do not accept if 'Different First Page' has
        been selected and watermark has not been deleted from
        second page.)
1.5     Comment                                                                   1
        • Comment deleted                                             1
1.6     Text Effect                                                               2
        • Font colour orange  gradient text fill effect  applied     2
           to heading 'The Effect Music Has On Me'
        (Notes to marker:
        • Allocate first mark if font colour was changed.
        • Mark from dialogue box.)
1.7     Dropped Cap                                                               3
        • Dropped cap effect applied to the 'M' of 'Music'            1
        • Over 2 lines                                                1
        • 0.6 cm/16 pt away from text                                 1

1.8     Line Spacing                                                              1
        • Second paragraph line spacing set to 'Multiple 1.15'        1

Copyright reserved                                                              Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P1              3                               DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

1.9     Endnote                                                              3
        • Endnote inserted  on text 'Rap and Rock'                    1
        • Appears in capital Roman number format 'I'                  1
        • Text entered in endnote  ('Adapted from an article by       1
          S Mariam')
1.10    Find and Replace                                                     2
        • 2 occurrences  of manual line break (soft enter)            1
        • Replaced with hard enters/paragraph marks                   1

        (Note to marker: Located at the end of the second and
        third paragraphs under the heading 'The Effect Music Has
        On Me'.)
        Total for QUESTION 1                                                [24]

Copyright reserved                                                         Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1              4                                    DBE/2016
                                  SCE – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

QUESTION 2                          File name: 2Facts_Feite                             Total Q2: 26
                                                                                         Candidate
No                                 Criteria                                Max Mark
                                                                                            Mark
2.1    Page numbering                                                              5
       • Page numbering (any style) inserted in the footer            1
       • Automatic page numbering inserted (as a field)               1
       • Page numbers are centred                                     1
       • First page is not numbered                                   1
       • Numbering starts as page 1 on the second page
          (after the table of contents page)                          1
       (Note to marker: Ignore if the numbering on the landscape
       pages from Question 2.6 onwards differs.)
2.2    Table of Contents                                                           4
       • Automatic table of contents inserted                         1
       • Fancy style used (Small caps)                                1
       • Two levels of headings appear                                1
       • Solid line leader tab appears for page numbers               1
       (Note to marker: Ignore if ToC appears twice.)
2.3    Styles and Table of Contents                                                2
       • 'Heading 1' style applied to the heading                     1
       • Table of contents reflects new entry (any style)             1
2.4    Citations                                                                   3
       • New interview source added                                   1
       • 'Steve Johnson' inserted  as interviewee                     1
       • Text 'Placeholder1' replaced with automatic citation         1
2.5    Columns                                                                     4
       • Text appears in 3 columns                                    1
       • Spacing between columns is set at 1.1 cm                     1
       • Column break  applied to each sub-heading                    1
       • Text justified                                               1
       (Note to marker: Award third mark for any column break.)
2.6    Page Orientation                                                            2
       • Page containing text in landscape orientation                1
       • All other pages remain portrait orientation                  1
2.7    Numbered and Bulleted List                                                  5
       • Level 1 numbering set to 1. 2. 3.                            1
       • Level 1 numbering aligned to 1 cm                            1
       • Level 1 text relatively aligned/indented to 2 cm             1
       • Level 2 set to                                              1
       • Level 2 bullet relatively aligned/indented to 2 cm           1
       (Note to marker: Ignore if 1., 1 or 1) and type of  bullet.)
2.8    Table                                                                       1
       • Function inserted =AVERAGE(Above)                            1
       Total for QUESTION 2                                                      [26]

Copyright reserved                                                             Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1              5                                    DBE/2016
                                  SCE – Memorandum/Marking Guideline
                            EXAMINATION
                            NUMBER

QUESTION 3                      File name: 3Learners_Leerders                           Total Q3: 25
•     Mark the questions from the formulae and not the values/answers in the cell.
•     Check against candidates' actual work (Cell references may differ, depending on the
      candidates' response).
•     Candidates may use multiple formulae or cells as 'building blocks' to answers.
•     Named ranges can be used instead of cell references.

                                                                                         Candidate
    No                             Criteria                                Max Mark
                                                                                           Mark
Member_Lid worksheet
3.1       Range A1:M1:                                                            1
          • Merge and centre  applied to text in range A1:M1          1
3.2       Cell G2:                                                                1
          • =TODAY()  OR NOW()                                        1
3.3       Cell B3:                                                                2
          =COUNTA(B5:B103)
          OR =COUNTIF(B5:B103,"*")
          •   COUNTA/COUNTIF function                                 1
          •   Range: (B5:B103)                                        1
          (Note to marker: Accept COUNTA function on columns C,
          D, E, F, G, I or L OR COUNT function on columns D, E,
          F, G or I.)
3.4       Cell A5:                                                                2
          =UPPER(B5)
          • UPPER function                                            1
          • Cell (B5)                                                 1
3.5       Print setting:                                                          2
          • Print area set  to range B4:D103                          1
          • Print gridlines set to show                               1

          (Notes to marker:
          • Accept if column A has been included.
          • Accept if 'Headings – Print' were selected in 'Sheet
             Options' and range is B5:D103.)
3.6       Column G:                                                               1
          • Format changed to yyyy-mm-dd                              1

          (Note to marker: Accept if just cell G5 formatted.)
3.7       Cell H5:                                                                3
          =CONCATENATE("011",I5) OR ="011"& I5
          • CONCATENATE function OR &                                 1
          • "011"                                                     1
          • I5                                                        1

Copyright reserved                                                              Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1              6                                DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

3.8     Cell K5:                                                              4
        =IF(J5="","Yes","No")

        OR =IF(ISBLANK(J5),"Yes","No")

        OR =IF(J5<>"","No","Yes")

        OR =IF(COUNTA(J5)=0,"Yes","No")

        OR =IF(LEN(J5)=0,"Yes","No")

        •   Testing if J5 is "blank"                                  1
        •   If cellphone is not available: "Yes"                      1
        •   If cellphone is available: "No"                           1
        •   Function copied to cells K6:K103                          1

        (Note to marker: Accept any suitable variations and if "Y"
        and "N" used instead of "Yes" or "No".)
3.9     Cell M5:                                                              7
        =MID(L5,FIND("@",L5,1)+1,LEN(L5))

        OR =RIGHT(L5,LEN(L5)-FIND("@",L5))

        •   To determine the position of the '@':
            o FIND function                                           1
            o '@' character                                           1
            o In the correct cell: L5                                 1
        •   Extracting the domain:
            o Function to extract (MID or RIGHT)                      1
            o Correct cell used to extract from: L5                   1
            o From after the position of the '@' sign                 1
            o To the end of the text/domain: LEN(L5), etc.            1

        (Note to marker: Check for 'building blocks' in other
        columns.)
Dec_Des worksheet
3.10    Extract and copy:                                                     2
        • Two members born in the month of December                   1
        • Copied to the Dec_Des worksheet                             1

        (Notes to marker:
        • 2 members expected (Killian R and Hassim T).
        • Accept if not all the information was copied.)
        Total for QUESTION 3                                                [25]

Copyright reserved                                                         Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1              7                                DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

QUESTION 4                       File name: 4Club_Klub                           Total Q4: 25
• Mark the questions from the formulae and not the values/answers in the cell.
• Check against candidates' actual work (Cell references may differ, depending on the
  candidates' response).
• Candidates may use multiple formulae or cells as 'building blocks' to answers.
• Named ranges can be used instead of cell references.
                                                                                 Candidate
 No                            Criteria                               Max Mark
                                                                                    Mark
Music_Musiek worksheet
4.1     Column B:                                                             1
        • All data is visible in column B                             1
4.2     Column G:                                                             1
        • Data in column G formatted to 2 decimal places              1
        (Note to marker: Accept if only part of the column has
        been changed or if formatted as a currency format.)
4.3     Cell F2:                                                              5
        =VLOOKUP(A2,Code!$C$2:$D$4,2)
        • Lookup value: A2                                            1
        • Table array: Code_Kode!C2:D4                                1
        • Reference column: 2  or use of LOOKUP function              1
        • Absolute cell reference: Code_Kode!C$2:D$4                  1
        • Copied to remaining cells                                   1
        (Notes to marker:
        • Ignore 'True' or 'False'.
        • Also accept absolute cell reference $C$2:$D$4.)
4.4     Cell H2:                                                              4
        =IF(A2=1,G2*1.2,IF(A2=2,G2*1.25,G2*1.15))

        OR
        =IF(A2=1,G2+G2*20/100,IF(A2=2,G2+G2*25/100,G2+
        G2*15/100))

        OR
        =IF(A2=1,G2*120/100,IF(A2=2,G2*125/100,
        G2*115/100))

        OR
        =IF(F2="CD",G2*120/100,IF(F2="DVD",G2*125/100,
        G2*115/100))
        • Nested IF/Function-construct is correctly used              1
                                                                       1
        • Condition CD OR Code 1 and value G2*1.2 
                                                                       1
        • Condition DVD OR Code 2 and value G2*1.25 
                                                                       1
        • Condition MP3 OR Code 3 and value G2*1.15 
        (Note to marker: Accept if column F was used with 'MP3',
        etc. If the percentage was calculated without the
        increase, penalise conditions by one mark.)

Copyright reserved                                                         Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1              8                                                                                   DBE/2016
                                  SCE – Memorandum/Marking Guideline
                                           EXAMINATION
                                           NUMBER

4.5     Cell L2:                                                                                                                 2
        =COUNTIF($D$2:$D$612,K2)
        • Absolute cell reference D$2:D$612                                                                              1
        • '1990' replaced with cell reference K2                                                                         1

        (Note to marker: Accept ($D$2:$D$612) as range.)
4.6     Cell L21:                                                                                                                4
        =SUMIF(E2:E612,"POP",G2:G612)
        • SUMIF function                                                                                                 1
        • Criteria range: (E2:E612)                                                                                      1
        • Criteria: "POP" OR K21                                                                                         1
        • Sum range: (G2:G612)                                                                                           1

Copy_Kopieer worksheet
4.7     Cell J2:                                                                                                                 3
        • Expected answer: 101                                                                                           1
        Method J3:
        • Removed duplicate  owners                                                                                     2

        ---------------------------------------------------------------------------------------------------------------
        OR
        • Sorted, deleted duplicate owners  and counted 

        --------------------------------------------------------------------------
        OR
        • Sorted owners  and counted unique owners 

        (Notes to marker:
        • Accept any other correct method e.g.
           =SUMPRODUCT((G2:G636<>"")/COUNTIF(G2:G636,
           G2:G636)).
        • Allocate all three marks if the correct answer
           displays.)
Graph_Grafiek worksheet
4.8     Chart:                                                                                                                   5
        • Horizontal axis title ('Years') inserted                                                                       1
        • Horizontal axis labels changed to display years 2000 -
          2005                                                                                                           1
        • Legend changed to 'Number of songs'                                                                            1
        • Vertical axis label major unit set to fixed 50                                                                 1
        • Data labels set (any position) to show values                                                                  1
        Total for QUESTION 4                                                                                                   [25]

Copyright reserved                                                                                                            Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1              9                                    DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

QUESTION 5                        File name: 5Music_Musiek                              Total Q5: 42

                                                                                         Candidate
 No                               Criteria                                 Max Mark
                                                                                           Mark
Table: Learners_Leerders
5.1.1   Field: Gender_Geslag                                                      1
        • Default value set to 'M'                                    1
5.1.2   Field: Grade_Graad                                                        1
        • Set as required field                                       1
5.1.3   Field: Class_Klas                                                         3
        • Display control: List box/Combo box                         1
        • Row source type: Value list                                 1
        • Row source: A, B, C, D OR a, b, c, d                        1
        (Notes to marker:
        • Allocate third mark if one option added.
        • Also accept if separate table created and used with
           rows/source type set to Table/Query.)
5.1.4   Field: DOB_Geboortedatum                                                  2
        • Format
           Set to Medium Date                                         1
        • Input Mask symbol
           Placeholder changed to # via wizard:
           00\->L<LL\-00;0;#                                          1
5.1.5   Field: Cell_Sel                                                           4
        • Validation rule: Len  ([Cell_Sel])  =10                   3
        • Validation text: Refers to 10 characters                    1

Form: frm5_2
5.2     •   Displays all 12 fields from Learners_Leerders table       1          7
        •   Font colour of the data in the Owner_Eienaar field
            appears as reddish                                        1
        •   Combo box/List box added in details section               1
        •   Row source based on Owner_Eienaar field                   1
        •   Row source: SELECT
            [Learners_Leerders].[Owner_Eienaar] FROM
            Learners_Leerders;                                        1
        •   Label 'Find what' added                                   1
        •   Horizontal line added to form footer                      1
        (Notes to marker:
        • Mark from Form view.
        • Do not allocate fifth mark if selected record does not
           display.
        • Accept any line inserted anywhere in form footer.)

Copyright reserved                                                              Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1              10                               DBE/2016
                                  SCE – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

Query: qry5_3
5.3     •   Fields displayed: Title_Titel, Artist_Kunstenaar,                 4
            Year_Jaar and Genre                                       1
        •   Year_Jaar criteria: 1996                                  1
        •   Genre criteria: 'DANCE'                                   1
        •   Title_Titel field sorted ascending                        1

        (Note to marker: 1 record expected.)
Query: qry5_4
5.4     •   Cost_Koste field added                                    1      5
            and format set to any currency                            1
        •    Calculated field added: Inc:  [Cost_Koste]              2
            * 2  award two marks if *2 is omitted                     1
            OR Inc: [Cost_Koste]+[Cost_Koste]

Query: qry5_5
5.5     •   Total row displayed                                       1      3
        •   Grouped by Genre                                          1
        •   Cost_Koste field: Total property set to Sum               1

        (Note to marker: 3 records for three genres expected.)
Query: qry5_6
5.6     Address_Adres field criteria: Like "13 *Crescent"                     3
        • 13 
        • Compulsory space after 13                                   1
        • *Crescent/*Cre*                                             1
                                                                       1
        (Note to marker: 3 records expected. Accept any
        alternative method.)
Report: rpt5_7
5.7     •   Report display fields: Artist_Kunstenaar, Title_Titel,            9
            Year_Jaar, Cost_Koste and Genre                           1
        •   Report grouped according to Year_Jaar field               1
        •   Sorted on Artist_Kunstenaar field                         1
        •   Report heading changed to 'Year released'                 1
        •   Function in Year_Jaar footer/header :                     1
            =SUM([Cost_Koste])  and suitable label added             2
        •   Function in report footer/header :                        1
            =MAX([Cost_Koste])                                        1
        (Note to marker: Do not penalise if label in the report
        footer is not given or not suitable.)

        Total for QUESTION 5                                                [42]

Copyright reserved                                                         Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1              11                                   DBE/2016
                                  SCE – Memorandum/Marking Guideline
                            EXAMINATION
                            NUMBER

QUESTION 6                         File name: 6Poster_Plakkaat                          Total Q6: 19

•     This question should be marked from the web browser as far as possible unless
      otherwise indicated or it cannot be seen in the web browser.
•     A maximum of 1 mark will be deducted if one or more closing tags are omitted.
•     The code of the candidates that use a word processor will contain additional
      unnecessary tags. Markers will need to work through the code to check for the
      answers provided below.

                                                                                         Candidate
    No                             Criteria                                Max Mark
                                                                                           Mark
6.1      Title                                                                    1
         <head>
          <title>'60s Music</title>
         </head>

         •   Title with title tags moved to head section of
             web page                                                 1
6.2      Image                                                                    2
         <img src ="6Sixty_Sestig.jpg"….>

         •   Tags added for image source                              1
         •   Image 6Sixty_Sestig.jpg named/used correctly             1
6.3      Alignment                                                                1
         <h1 align="center">Music</h1>

         •   'Music' heading centred                                  1
6.4      Horizontal line                                                          2
         <hr size="3" width = "70%"/>

         •   Size of horizontal line set to 3                         1
         •   Width of horizontal line set to 70%                      1
6.5      Heading style                                                            1
         <h2>Before 1963</h2>

         •   Heading 2 style applied to text                          1
6.6      Bold                                                                     1
         <b>The Beatles</b>

         •   Bold applied to text 'The Beatles'                       1
6.7      Italics                                                                  2
         <p><i>To mention a few ...</i></p>

         •   Text 'To mention a few …' appears in italics             1
         •   In a separate paragraph                                  1

Copyright reserved                                                              Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1              12                                 DBE/2016
                                  SCE – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

6.8     Table                                                                   4
        <table bgcolor="orange" align="center" border="3">
        <tr>
               <th>Artist</th>
               <th>Hits</th>
        </tr>

        •   Table's background colour changed to orange                1
        •   Row added at the top of the table                          1
        •   Two cell heading tags added                                1
        •   Cells contain headings 'Artist' and 'Hits' respectively    1

        (Notes to marker:
        • Allocate last mark if only one heading appears.
        • Do not accept <td> instead of <th>.)

6.9     Numbered list                                                           2
        <ol>
              <li>Surfin' USA</li>
              <li>Good Vibrations</li>
        </ol>

        •   The text 'Surfin' USA' and 'Good Vibrations' appear in
            a numbered list                                            1
        •   Two list tags/items                                        1

        (Note to marker: Allocate mark if only one list item
        appears. Accept ordered or unordered list.)
6.10    Link                                                                    3
        <a href="#Top">Back to top</a>

        •   Text inserted 'Back to top'                                1
        •   Link created on the text 'Back to top'                     1
        •   Link moves to 'Top'                                        1
        Closing tag(s) or triangular brackets omitted                   -1
        Total for QUESTION 6                                                  [19]

Copyright reserved                                                           Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P1              13                                    DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

QUESTION 7                                                              Total Q7: 19
    File names: 7Form_Vorm, 7Compet_Kompet, 7Sixties_Sestigs, 7Data and
                               7Answ_Antw.
                                                                                         Candidate
 No                               Criteria                                 Max Mark
                                                                                           Mark
7Form_Vorm
7.1     Document properties                                                        1
        • Comment property reads 'CAT Exam'                           1
7.2.1   Name: Form field control                                                   1
        • Text form field inserted next to text 'Name'                1
7.2.2   Surname: Text form field                                                   1
        • Text form field property set to display in uppercase        1
7.2.3   Drop down list                                                             2
        • Drop down form field inserted                               1
        • Options: Beatles, Elvis Presley, The Beach Boys             1

        (Note to marker: Accept at least two options to allocate
        the second mark.)
7Compet_Kompet, 7Data
7.3     Mail Merge                                                                 3
        • 7Data used as the data source for the mail merge            1
        • Name_Naam and DOB_Geboortedatum fields inserted
          in correct positions                                        1
        • Merge completed  (7Data)                                    1

        (Note to marker: 99 letters expected.)
7Sixties_Sestigs
7.4     Tables                                                                     3
        • New table  created called 7Comb                             1
        • Records from both tables combined (33 records)              1
        • Records sorted in descending order according to
           Name_Naam field                                            1

        (Note to marker: Do not penalise if data in Code_Kode
        field has changed.)

Copyright reserved                                                              Please turn over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P1              14                                DBE/2016
                                  SCE – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

•   Accept any method that will yield the correct answer.
•   One mark for the answer and one mark for the method. If there is only an answer and
    no method, allocate two marks if the answer is correct.

7Answ_Antw
7.5.1   Which song charted in both the American and British                    2
        charts on 1 August 1964?
        • A Hard Day's Night                                          1

        Method:                                                       1
        • Filter on Date and Year
        • Filter search 1964-08-01
        • Sort on Date, Year, Chart
7.5.2   How many different or unique titles by Elvis Presley                   2
        reached the charts?                                            1
        • 9
                                                                       1
        Method: 
        • Filter on Artist, count only unique values
        • Remove duplicate songs, count on Artist
        • COUNTIF and count unique values
7.5.3   Which chart featured the most titles?                                  2
        • American  (178)                                             1
        Method:                                                       1
        • COUNTIF British and American charts and compare
        • Filter both and compare total on scroll bar
        • Sort and count
7.5.4   Which year featured the most titles on the charts?                     2
        • 1964  (100)                                                 1

        Method:                                                       1
        • Filter each and see count on scroll bar
        • Filter, copy and count
        • COUNTIF
        • Sort, select years and see count on scroll bar
        • Use SUBTOTAL function
        Total for QUESTION 7                                                  [19]
        TOTAL                                                                             180

Copyright reserved

## Related documents

- [Computer Application Technology P1 May June 2016 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-eng/da15995d-25c5-4cb8-a14a-08bf723c628c) — Computer Applications Technology · QP · 2016 · Eng
- [Computer Application Technology P2 May June 2016 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p2-may-june-2016-memo-afr/7216afa6-018e-4e0b-beae-69fc2a549639) — Computer Applications Technology · Memo · 2016 · Afr
- [Gr12 CATN P1 S16 MEMO Eng](https://www.hlayiso.com/library/gr12-catn-p1-s16-memo-eng/999cfe79-26cb-4e2f-a155-caf3f7f7ae70) — Computer Applications Technology · Memo · 2016 · Eng
- [Computer Application Technology P1 Nov 2016 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2016-memo-afr/bae774d9-2998-4624-894c-ed6d9704d0d1) — Computer Applications Technology · Memo · 2016 · Afr
- [Computer Application Technology P1 Nov 2016 Memo Eng Backup](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2016-memo-eng-backup/cf150881-0fe7-4a1c-b832-22729d7b3d99) — Computer Applications Technology · Memo · 2016 · Eng
- [CAT P1 Feb March 2016 Memo Afr](https://www.hlayiso.com/library/cat-p1-feb-march-2016-memo-afr/d4ce7e0c-1a86-4a4f-8d1c-e16ade0bc386) — Computer Applications Technology · Memo · 2016 · Afr

## More from Grade 12 Computer Applications Technology

- [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr
- [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng
- [CAT P1 QP GR12 SEPT 2024 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng
- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng
- [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
