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

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

- Page: https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng/e08c3996-9c1b-4cac-ba21-51c38b866294
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2017
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 15

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 2017 Memo (Eng)](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng/e08c3996-9c1b-4cac-ba21-51c38b866294)

## About this document

Computer Applications Technology · Grade 12 · NSC November Exam · 2017. Memorandum, 15 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

                                   NATIONAL
                              SENIOR CERTIFICATE

                                       GRADE 12

                 COMPUTER APPLICATIONS TECHNOLOGY P1

                                  NOVEMBER 2017

                               MARKING GUIDELINES

MARKS: 180

CENTRE                                                   FINAL MARK
NUMBER

EXAMINATION
NUMBER

QUESTION                 1       2       3       4       5       6    7     TOTAL

POSSIBLE MARK            34      16      31     19      40      20    20       180

MARKER

SM

CM

IM/EM

                      These marking guidelines consist of 15 pages.

Copyright reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1              2                      DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON
THE ANSWER.
QUESTION 1                             File name: 1Harvest                          Total Q1: 34

                                                                        Maximum       Candidate
 No.                                  Criteria
                                                                          Mark          Mark
1.1.1   Heading (HARVEST FOOD FESTIVAL)                                         2
        • Any WordArt applied to heading                           1
        • WordArt rotated by 90° or 270°                           1
1.1.2   Picture                                                                 4
        • Picture cropped to display only the basket and grapes    1
        • Height set to 10 cm                                      1
        • Width set to 12 cm                                       1
        • Any oval-like picture style or shape applied             1
1.1.3   Table                                                                   2
        • Default top cell margin set to 0.1 cm  (check table or   1
           cell options)
        • No borders display                                       1
1.2     Page break                                                              1
        • Page break or section break (next page) inserted         1
1.3.1   Styles (Mark from Styles Gallery)                                       1
        • Display1 style removed                                   1
1.3.2   Display2 style modified                                                 4
        • Numbering added in format 1., 2.,  (Accept 1), 2),)      1
        • Any border added                                         1
        • Left indent set to 0 cm                                  1
        • All occurrences of the style updated                     1
1.4     Cross reference (Figure 3: Gourmet Meals)                               2
        • Cross reference inserted within brackets  (Accept        1
           hyperlink/ bookmark)
        • Reference to label 'Figure 3: Gourmet Meals'             1
1.5     Language                                                                1
        • Word 'explore' language changed to English (South
           Africa)  (mark from task bar)                           1

Copyright reserved                                                         Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P1                3                                   DBE/November 2017
                                        NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

1.6     Tabs                                                                                   6
        • Tab set at 2 cm                                                         1
        • Left aligned                                                            1
        • Tab set at 10 cm                                                        1
        • Right aligned                                                           1
        • Solid leader tab set                                                    1
        • Tab settings applied to all lines                                       1
1.7     Citation (Ward)                                                                        2
        • Citation to 'Jean Ward' source inserted                                 1
        • Year does not display                                                   1
1.8.1   Caption (Figure 6: Jumping Castle) (Alt + F9)                                          2
        • Automatic figure caption added  to correct picture                      1
        • Text 'Jumping Castles' inserted  for caption                            1
1.8.2   Table of figures                                                                       1
        • Table of figures updated  (see 'Figure 5: Wine Shop')                   1
1.9     Bibliography                                                                           2
         Book, A. (2015). Too little too late. Entertainment All.
         Business To All. (2016, July). Retrieved from Biz Communities:
               www.biz_com.com
         Sousher, P. L. (2014). Marketing South Africa. Business Journal, 61-62.
         Ward, J. (2005). Coetzenburg: A Tourist Site.

        •   Automatic bibliography inserted                                       1
        •   Appears in APA style                                                  1
1.10    Page numbering and section numbering                                                   4
        • Page number does not appear on first page                               1
        • Section 2/Last page formatted with i, ii, iii, … format                 1
          starts from i                                                           1
        • Style of page number with 'i' not changed                               1

        Total for QUESTION 1                                                                 [34]

Copyright reserved                                                                        Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1               4                     DBE/November 2017
                                       NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 2                               File name: 2Stay                  Total Q2: 16

                                                                      Maximum       Candidate
 No.                                  Criteria
                                                                        Mark          Mark
2.1     Page layout                                                           2
        • Page size set to 'Legal' (21.59 cm x 35.56 cm)         1
        • Multiple pages set to 'Book fold'                      1
2.2     Comment                                                               2
        • Any comment added ('New'/'Reply'/Edited)               1
        • Any relevant response added                            1
2.3     Watermark                                                             3
        • Any watermark added                                    1
        • Image '2Pic.jpg' used                                  1
        • Scale set to 200%                                      1
2.4     Check box: Special Shopper                                            7
        • Default value set to checked                           1
        Combo box: Type of Accommodation
        • Option 'B and B' added to combo box                    1
        • 'B and B' appears first                                1

        Text form field: Total
        • Type: Number                                           1
        • Number format: R# ##0.00;(R# ##0.00)                   1
        • Help text inserted on F1 key                           1
        • Any text entered  (Days*Rate) (Allocate this mark if   1
           text is in status bar)
2.5     SaveDate field (Alt + F9)                                             2
        • Any date field added  (Accept any date field in any    1
           format)
        • SaveDate field added                                   1
        Total for QUESTION 2                                                 [16]

Copyright reserved                                                         Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1               5                         DBE/November 2017
                                       NSC – Marking Guidelines
                  EXAMINATION
                  NUMBER

QUESTION 3                                 File name: 3Acc                             Total Q3: 31

•     Mark the questions from the formulae and not the values/answers in the cell.
•     Check against candidate's actual work (Cell references may differ, depending on the
      candidate's response).
•     Candidate may use multiple formulae or cells as 'building blocks' to reach answers.
•     Named ranges can be used instead of cell references.
•     The answers must still be correct even if changes are made to the existing data.

                                                                          Maximum       Candidate
 No.                                  Criteria
                                                                            Mark          Mark
Accom_Verblyf worksheet
3.1       Row 6:                                                                  2
          • Row 6 height changed to exactly 45 pt                    1
          • Row 6 headings wrapped                                   1
3.2       Cell H7:                                                                2
          =G7-F7
          OR
          =DAYS(G7,F7)
          OR
          =DAY(G7)-DAY(F7)

          •   Correct cells used                                     1
          •   To determine difference correctly                      1
3.3       Cell I8:                                                                4
          VLOOKUP(D8,Rate_Tarief!$B$3:$C$23,2)
          OR
          =VLOOKUP(D8,Rate_Tarief!$B$4:$C$23,2)
          •   Lookup value: D8                                       1
          •   Lookup range: Rate_Tarief!$B$3:$C$23 OR
              Rate_Tarief!$B$4:$C$23  (accept named range)           1
          •   Absolute cell references correctly used  (allocate     1
              mark if named range was used)
          •   Correct column: 2                                      1
3.4       Cell J9:                                                                3
          =H9*I9 OR =PRODUCT(H9,I9) OR =(G9-F9)*I9

          •   Correct cells used                                     1
          •   Multiplication                                         1
          •   Format changed to any currency format                  1

Copyright reserved                                                             Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1              6                          DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

3.5     Cell L10: (Check for building blocks)                                     4
        =LEN(K10)/100*J10
        OR
        =J10*LEN(K10)/100
        OR
        =J10*LEN(K10)%
        OR
        =LEN(K10)*1%*J10
        OR
        =J10*("0.0"&LEN(K10))

        •   LEN  (K10)                                                2
        •   /100  (Accept decimals instead of percentages)             1
        •   * J10                                                      1

        (Notes to marker:
        • Accept any method that will yield the correct answer.
        • =IF(LEN(K10)=5,J10*5%,IF(LEN(K10)=4,J10*4%,
           IF(LEN(K10)=3,J10*3%,IF(LEN(K10)=2,J10*2%,
           J10*1%))))
        • =IF(K10="*****",J10*5%,IF(K10="****",J10*4%,
           IF(K10="***",J10*3%,IF(K10="**",J10*2%,J10*1%))).
        • Mark allocation for nested if: test K10 for correct
           number of stars, J10 used to calculate discount,
           identified correct %, nested if correctly applied for all
           options.)
3.6     Cell M7: (Check for building blocks)                                      6
        =IF(VALUE(MID(C7,7,1))>=5,"Male","Female")

        OR
        =IF(VALUE(MID(C7,7,1))<5,"Female","Male")

        •   IF function                                                1
        •   Criteria: VALUE OR NUMBERVALUE function                    1
            ((MID(C7,7,1 ))                                            1
            >=5  OR >4 (OR >="5" if VALUE was not used)                1
        •   Value if true: "Male" OR "M"                               1
        •   Value if false: "Female" OR "F"                            1

        (Notes to marker:
        • Evaluate the candidates answer against the bulleted
           options e.g. CODE function.
        • Penalise only the second mark if VALUE was not used.)

Copyright reserved                                                             Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1              7                    DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

3.7     Cell G2:                                                            3
        =SMALL(I7:I66,3) OR =SMALL(I:I,3)

        •   SMALL function                                       1
        •   Range: I7:I66                                        1
        •   Third smallest: 3                                    1
3.8     Cell G3:                                                            2
        =MODE(I7:I66) OR =MODE(I:I)
        •   MODE function OR MODE.MULT OR MODE.SNGL
            function                                             1
        •   Range: I7:I66                                        1
3.9     Cell G4:                                                            5
        =SUMIF(E7:E66,"Country*",J7:J66)

        OR
        =SUMIF(E7:E66,"*Country*",J7:J66)

        OR
        =SUMIF(E7:E66,"Country House",J7:J66)+SUMIF
        (E7:E66,"Country Inn",J7:J66)

        •   SUMIF(S) function                                    1
        •   Criteria range: E7:E66                               1
        •   Criteria: Country OR C  *  (accept * in front,      2
            allocate both marks if "Country House" and "Country
            Inn" was used)
        •   Sum range: J7:J66                                    1

        (Note to marker: =SUMIFS(J7:J66,E7:E66,"Country*")
        Total for QUESTION 3                                               [31]

Copyright reserved                                                       Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1               8                         DBE/November 2017
                                       NSC – Marking Guidelines
                  EXAMINATION
                  NUMBER

QUESTION 4                                 File name: 4Quest                          Total Q4: 19

•     Mark the questions from the formulae and not the values/answers in the cell.
•     Check against candidate's actual work (Cell references may differ, depending on the
      candidate's response).
•     Candidate may use multiple formulae or cells as 'building blocks' to reach answers.
•     Named ranges can be used instead of cell references.
•     The answers must still be correct even if changes are made to the existing data.

                                                                          Maximum       Candidate
 No.                                  Criteria
                                                                            Mark          Mark
Respons worksheet
4.1       Cell H3:                                                                2
          =COUNTBLANK(H6:H115)

          OR
          =COUNTIF(H6:H115,"")
          •   COUNTBLANK function                                    1
          •   Range: (H6:H115)                                       1
4.2       Cell K6:                                                                4
          =TIME(HOUR(J6),MINUTE(J6)+20,0)

          OR
          =J6+TIME(0,20,0)

          OR
          =SUM(TIME(0,20,0),J6)

          OR
          =J6+TIMEVALUE("0:20")
          •   J6                                                     1
          •   Any time function                                      1
          •   20 minutes                                             1
          •   Added                                                  1

Copyright reserved                                                             Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1              9                     DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

4.3     Cell K3:                                                             4
        =COUNTA(H6:H115)/K2*100
        OR
        =COUNTA(H6:H115)/K2
        OR
        =COUNTIF(H6:H115,"*")/K2
        OR
        =(K2-H3)/K2*100
        OR
        =(K2-H3)/K2
        OR
        =100*(1-H3/K2)
        OR
        =((K2-COUNTBLANK(H6:H115))/K2*100)/100

        • COUNTA function OR K2-H3                                1
        • Range: (H6:H115) OR Correct use of brackets             1
        • /K2  (Accept COUNTA of columns A, B, C, D or G)         1
        • *100 OR format changed to percentage                    1
4.4      Columns A and B: Conditional formatting                             4

        •   Conditional formatting applied to A6:B115             1
        •   =$B$3=$G6  OR =$B$3=$G6:$G115 (Ignore                 1
            absolute cell reference)
        •   Absolute cell reference correctly applied ($G6 OR G6
            OR $G6:$G115 OR G6:G115)                              1
        •   Format style: Any fill colour                         1
Earn_Verdien worksheet
4.5     Chart/Graph:                                                         5
        • Vertical axis title inserted 'Amount'                   1
        • 4Coin image inserted  and stacked and scaled in         1
          units of 100 000  (8 coins display)                     1
        • Horizontal axis labels:
          o Alignment set to: Rotate all text 270° or 90°         1
          o Major units set to 2 days                             1
        Total for QUESTION 4                                                [19]

Copyright reserved                                                        Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1              10                          DBE/November 2017
                                       NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 5                                  File name: 5Visit                          Total Q5: 40

                                                                           Maximum       Candidate
 No.                                  Criteria
                                                                             Mark          Mark
Table: tbAccom
5.1.1   Field: Name                                                                1
        • Field size changed to 30                                    1
5.1.2   Field: Surname                                                             1
        • Set as required field                                       1
5.1.3   Field: IdentityNumber                                                      2
        Input Mask: 0000000000000
        • Compulsory digit used: 0                                    1
        • 13 characters                                               1
5.1.4   Field: Province                                                            2
        • Option 'EC' added to drop down list                         1
        • Added as first option in drop down list                     1
5.1.5   Field: DateIn                                                              4
        • Validation Rule:
           >= #2017/11/18#  AND <= #2017/11/28 #                    3
            OR >#2017/11/17# AND <#2017/11/29#
            OR Between #2017/11/18# AND #2017/11/28#
            OR Between "2017/11/18" AND "2017/11/28"

        •   Validation text
            Any appropriate validation text that refers to the range
            of dates                                                  1
5.1.6   Field: Code                                                                2
        • Expression modified as: LEFT([Surname]                      1
        • ,3 )                                                        1
Form: frm5_2
5.2     •   Form header text changed  to examination number           1           6
            (accept if examination number was added)
        •   Show date picker for DateIn field set to never            1
        •   Format of Rate field changed to any currency              1
        •   Date field inserted OR DATE()                             1
        •   Time field inserted OR TIME()                             1
        •   In the form footer                                        1

        (Note to marker: Allocate Date and Time mark if =NOW()
        was used.)

Copyright reserved                                                              Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1             11                        DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

Query: qry5_3
5.3     •    Province criteria: LP  OR  MP  OR In("LP","MP")       3         4
        •    Data sorted ascending by Surname                        1

        (Note to marker: 11 records expected.)
Query: qry5_4
5.4     •    Total (Group by) row displayed                          1         2
        •    SUM selected for NumberOfNights field in Total row      1
Query: qry5_5
5.5      •   Only Name and Surname fields are displayed              1         7
         •   NumberOfNights criteria: <=5  (OR <6)                   1
         •   Amount field criteria: <800  OR  >2000                3
         •   DOB criteria: IS NULL OR Not Like "*"                   1
         •   AND operator for all field criteria                     1

        (Note to marker: 2 records expected.)
Query: qry5_6
5.6     Calculated field:                                                       4
        Discount:[Amount]-[Amount]*10/100 OR
        Discount:[Amount]-[Amount]*0.1 OR
        Discount:[Amount]*0.9 OR
        Discount:[Amount]*90/100
        •    New calculated field Discount added                     1
        •    10% calculated                                          1
        •    On the original Amount                                  1
        •    Subtract to get the difference                          1
Report: rpt5_7
5.7     •    Shading applied to Province field  (in Province group   1         5
             header)
        •    Amount field sorted  in descending (largest to          1
             smallest) order
        •    Function in Accommodation group footer/header           1
             =SUM  ([Amount])                                       2

        (Note to marker: Allocate the marks for the function even
        if it appears in the wrong place.)
        Total for QUESTION 5                                                  [40]

Copyright reserved                                                           Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1              12                               DBE/November 2017
                                       NSC – Marking Guidelines
                  EXAMINATION
                  NUMBER

QUESTION 6                                   File name: 6Viti                               Total Q6: 20

•     NO marks should be allocated for answering this question using Word.
•     This question should be marked from the HTML code.
•     Numerical attribute values do not need to be in inverted commas.
•     A maximum of 1 mark will be deducted if one or more closing tags are omitted.

                                                                                Maximum       Candidate
 No.                                  Criteria
                                                                                  Mark          Mark
6.1       Font Type                                                                     1
          <font face="Arial">

          •   Font type set to 'Arial'                                     1
6.2       Heading 1: 'Growing Grapes'                                                   2
          <h1 align="center"><font color="blue">Growing
          Grapes</font></h1>

          OR
          <h1><center><font color="Blue">Growing
          Grapes</font></center></h1>

          •   Text 'Growing Grapes' alignment set to centre                1
              align="center" OR <center></center>
          •   Text 'Growing Grapes' font colour set to blue                1
              <font color="blue">
6.3       Horizontal line                                                               2
          <hr size="3"> OR <hr size="3"/>
          •   Horizontal line inserted                                     1
          •   Size set to 3                                                1
6.4       Bulleted list                                                                 3
          <ul type="circle">
             <li>the composition of the soil</li>
             <li>the climate</li>
             <li>situation of vineyard</li>
          </ul>

          •   Unordered list                                               1
          •   Bullet circle type: type="circle" applied to all list
              items                                                        1
          •   List item applied to at least one item  (if list items are   1
              not closed, check line 1 for <<!DOCTYPE html>>)

Copyright reserved                                                                   Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P1             13                    DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

6.5     Image: Height and width                                             4
        <img src="6Hectare.png" height="250" width="350">

        •   Img tag                                             1
        •   Correct source file: src = "6Hectare.png"           1
        •   Height set to 250                                   1
            height="250"
        •   Width set to 350                                    1
            width="350"
6.6     Table                                                               5
        <table border="5" width="60%">
           <tr>
               <td colspan="2"><font color="blue">
               <b>Variety of grapes</b></font></td>
           </tr>
            …
           <tr>
               <td>Currants*</td>
               <td>987 125</td>
           </tr>
           <tr>
               <td>Sultana</td>
               <td>148 759 871</td>
           </tr>
        </table>

        •   Table border changed to 5: border="5"               1
        •   Spans two columns: colspan="2"                      1
        •   Last row added to table: <tr> … </tr>               1
        •   Two cells added to last row: <td> … </td>           1
        •   Any required text added in at least one cell        1
6.7     Hyperlink                                                           3
        <a href="6SAStats.docx"><img src=6More.jpg></a>

        •   Hyperlink created: <a href></a>                     1
        •   On image                                            1
        •   To correct file: "6SAStats.docx">                   1
        Closing tag(s) or triangular brackets omitted or
                                                                 -1
        incorrect nesting
        Total for QUESTION 6                                               [20]

Copyright reserved                                                       Please turn over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P1              14                     DBE/November 2017
                                       NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 7                            File names: 7Calc, 7Rep              Total Q7: 20

                                                                      Maximum       Candidate
 No.                                  Criteria
                                                                        Mark          Mark
7Calc: Num_Nom worksheet
7.1     Cell A3:                                                             10
        RANDBETWEEN (100,999)
        OR
        =RAND()*(999-100)+100
        OR
        =RANDBETWEEN(1,9)&RANDBETWEEN(0,9)&
        RANDBETWEEN(0,9)
        • RANDBETWEEN OR RAND function                           1
        • Lower boundary (Any 3-digit number)                    1
        • Upper boundary (Any 3-digit number)  (Should be
           larger than lower boundary)                            1

        Cell B3:
        =LEFT(A3,1) OR TRUNC(A3/100) OR MID(A3,1,1) OR
        INT(A3/100) OR LEFT(A3)
        • LEFT function  (OR TRUNC OR MID)                       1
        • Extract one character from cell A3                     1
        Cell C3:
        =RIGHT(A3,1) OR MID(A3,3,1) OR MID(A3,LEN(A3),1)
        OR A3-INT(A3/10)*10 OR RIGHT(A3)
        • RIGHT function  (OR MID)                               1
        • Extract one character from cell A3                     1

        Cell D3:
        =IF(B3=C3,"YES","NO") OR
        =IF(EXACT(B3,C3),"YES","NO")
        • Check that B3=C3  (OR (B3<>C3))                        1
        • Value if true: "YES"                                   1
        • Value if false: "NO"                                   1

Copyright reserved                                                         Please turn over

### Page 15

Downloaded from hlayiso.com
Computer Applications Technology/P1             15                           DBE/November 2017
                                      NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

7Calc: Vouch_Bewys worksheet
7.2.1   Cell E2: (Check for building blocks)                                       7
        =TODAY()<=DATE(YEAR(NOW()),MONTH(D2),DAY(D2))
        OR
        =IF(TODAY()>=DATE(2017,MONTH(D2),DAY(D2)),
        "FALSE","TRUE")
        OR
        =IF(TODAY()<DATE(YEAR(TODAY()),MONTH(D2),DAY(D
        2)), "TRUE","FALSE")
        OR
        =IF(DATE(YEAR(TODAY()),MONTH(D2),DAY(D2))>=TOD
        AY(),"TRUE", "FALSE")
        OR
        =OR(AND(MONTH(D2)=MONTH(TODAY()),DAY(D2)
        >=DAY(TODAY())),MONTH(D2)>MONTH(TODAY()))
        OR
        =OR(IF(MONTH(D2)>MONTH(TODAY()),TRUE),
        AND(MONTH(D2)=MONTH(TODAY()),DAY(D2)
        >=DAY(TODAY())))
        OR
        =IF(MONTH(D2)>MONTH(TODAY()),"TRUE",
        IF(MONTH(D2)=MONTH(TODAY()),IF(DAY(D2)
        >=DAY(TODAY()),"TRUE","FALSE"),"FALSE"))

        •   Criteria 1: Check if birth month is greater than current
            month                                                       1
        •   Correct output (TRUE) if birth month/date is greater
            than current month/date                                     1
        •   Criteria 2: Check if current month is equal to birth
            month  AND current day is greater or equal to birth         1
            day                                                         1
        •   Correct output (TRUE) if both aspects in criteria 2 are
            true                                                        1
        •   Correct output (FALSE) if criteria 2 is false               1
        •   Function copied to cells E3:E111                            1
        (Note to marker: Award the output mark if the second
        criteria is wrong but the output is correct.)
7.2.2   rpt7_2 report in 7Rep database                                             3
        • 7Calc data imported to 7Rep  (110 records)                    1
        • Any report created  with 4 or 5 correct fields               2

        Total for QUESTION 7                                                      [20]

                                                                 TOTAL            180

Copyright reserved

## Related documents

- [Computer Application Technology P1 Nov 2017 Memo Afr Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-afr-rewrite/4c3ced4d-1987-42e1-85c6-38ce6cec21d3) — Computer Applications Technology · Memo · 2017 · Afr
- [Computer Application Technology P1 Nov 2017 Memo Eng Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng-rewrite/f3f97e51-029e-44ca-83f9-dff3eec080ff) — Computer Applications Technology · Memo · 2017 · Eng
- [GR12 CATN P1 Sept2017 MEMO Afr 2](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-memo-afr-2/b5a0c65b-f27d-4e3e-85bd-cf66c1dcadc6) — Computer Applications Technology · Memo · 2017 · Afr
- [GR12 CATN P1 Sept2017 MEMO Eng 2](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-memo-eng-2/b5c28ac2-09a3-4703-849c-349924c32018) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P1 May June 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2017-memo-eng/7e7366e7-46e1-4300-a0da-3e88eb4b2ece) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P1 Feb March 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-feb-march-2017-memo-eng/c5772d58-f5d8-41dd-ae97-a9165f0f9a78) — Computer Applications Technology · Memo · 2017 · Eng

## 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.
