Information
AI Chat

Computer Application Technology P1 Feb-March 2017 Memo Eng

non as of yet

Course

Computer Science (CSC1B)

103 Documents

Students shared 103 documents in this course

University

University of Johannesburg

Academic year: 2023/2024

Uploaded by:

Anonymous Student

This document has been uploaded by a student, just like you, who decided to remain anonymous.

University of Johannesburg

Recommended for you

Comments

Please sign in or register to post comments.

Preview text

MARKS: 180

CENTRE NUMBER

EXAMINATION NUMBER

QUESTION 1 2 3 4 5 6 7 TOTAL

POSSIBLE MARK 37 17 38 17 37 19 15 180

MARKER

SM

CM

IM/EM

This memorandum/marking guideline consists of 14 pages.

GRADE 12

COMPUTER APPLICATIONS TECHNOLOGY P

FEBRUARY/MARCH 2017

MEMORANDUM/MARKING GUIDELINES

NATIONAL

SENIOR CERTIFICATE

FINAL MARK

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE AN IMPACT ON

THE ANSWER.

QUESTION 1 File name: 1Areas Total Q1: 37

No Criteria Maximum Mark

Candidate Mark

1.1 Abstract - Language set to ONLY English (South Africa)  1

1

1.1 Abstract alignment - Text of abstract justified  1

1

1 Image - Image cropped to any shape  - Sharpness set to 50% or any other % besides 0% 

1

2

1 Subtitle text control - Content control (not text) removed  1

1

1 Table of contents - Table of contents inserted  with 'Classic' style - 'Water' style used as first heading style/level  - 'Heading 1' style used as second heading style/level  (Alt F9: {TOC \h \z \t "Heading 1,2,Water,1"}) - Page numbers have solid leaders 

1

4

1 Page numbers - Automatic page numbering inserted in the footer  - Formatted as 'Page 1' OR 'page 1' style  - Numbering starts as 1 on the 'Contents' page  - Odd page numbers aligned on the left  - Even page numbers aligned on the right 

(Notes to marker:

Accept if odd and even was swopped.
Award the fourth mark if 'Different odd and even' was checked, even if no numbers were inserted.)

1

5

1 Dropped cap - Dropped cap applied on 'Our' (any number of lines)  - Spacing set to 0 cm from the text 

1

2

1 Cross-reference - Cross-reference added on text 'table 1'  (Ref475517156) - Links to table 

1

2

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

QUESTION 2 File names: 2Water, 2Done Total Q2: 17

No Criteria Maximum Mark

Candidate Mark

2 Date field - Any date added  - Field will automatically update 

1

2

2 Textbox fill - Second text box filled with 2Drops image  - All/some text bolded in any text box 

1

2

2 Drop-down field: Gender - 'Femail' spelling changed to 'Female'  1

1

2 Check box: 'Older than 60' - Any check box inserted  to the left of text (or in any other position)

1

2 Text form field: 'Number of adults ...' - Type changed to 'Number'  1

1

2 Number form field: 'How much do you pay ...' - Number format changed to value with 'R' currency format  1

1

2 Tabs - Leader tabs/tab set to approximately 6 cm, 10 cm and 15 cm  - Left tabs used in all cases  - Tab leaders added in two cases (6 cm and 15 cm)  - All tabs correctly applied 

1

4

2 Mail merge - Data source 2Det_Bes used  - Any sorting done  in ascending order  - Name and Surname fields inserted  - Merge completed  (2Done)

(Note to marker: 29 or 30 letters expected.)

1

5

Total for QUESTION 2 [17]

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

QUESTION 3 File name: 3Rain_Reën Total Q3: 38

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.

No Criteria Maximum Mark

Candidate Mark

Rain_Reën worksheet

3.1 Row 1: - Merged cell changed to A1:O1  1

1

3.1 Row 1 fill: - Any fill effect applied  - Thin diagonal stripe pattern style fill effect applied  (accept any diagonal stripes)

1

2

3 Freeze panes: - Freeze panes effect applied  - Correct columns and rows (rows 1 and 2, columns A and B) 

1

2

3 Cell D3: - =VALUE(C3) 

(Note to marker: After sorting =VALUE(C6).)

1

3 Cell G48: - =MODE  (G3:G46)  2

2

3 Cell H49: =ROUNDUP(AVERAGE(H3:H46),0)

OR =CEILING(AVERAGE(H3:H46),1)

OR =ROUND(AVERAGE(H3:H46)+0,0)

AVERAGE(H3:H46) 
ROUNDUP/CEILING/INT 
,0 for ROUND/ROUNDUP and ,1 for CEILING 

1

3

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

Durban worksheet

3 Cell C6: =SUBTOTAL($A$6,C10:C53)

OR =SUBTOTAL($A$6,C9:C53)

Cell range C10:C53 
Absolute cell reference 

1

2

3 Filter: - Filter set on Durban  1

1

Bloemfontein worksheet

3 Graph - Area chart/graph displays rainfall per month per year for Bloemfontein (range B1:O12)  - Suitable chart title inserted  - Any legend inserted  below - Horizontal axis options display years  - Data labels inserted for 'Total' series 

1

5

Total for QUESTION 3 [38]

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

QUESTION 4 File name: 4Game_Speel Total Q4: 17

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.

No Criteria Maximum Mark

Candidate Mark

Scores_Punte worksheet

4 Hyperlink: - Hyperlink removed from heading 'Water Games'  1

1

4 Cell E3: =(TODAY()-D3)/

OR =(NOW()-D3)/

OR =DAYS(NOW(),D3)/

OR =DAYS(TODAY(),D3)/

TODAY() function 
-D3 
/7 

(Notes to marker: - Accept if the current date was entered in a cell and the cell reference was used. - If the DAYS function was used allocate one mark for the function and one mark each for the correct parameters.)

1

3

4 Data validation: - 'Black' removed from the list  - Applied to the whole column G 

1

2

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

QUESTION 5 File name: 5Dam Total Q5: 37

No Criteria Maximum Mark

Candidate Mark

Table: Dam

5.1 Field: Name or Location - Set as primary key  1

1

5.1 Field: Town - > inserted in Format field property  1

1

5.1 Field: Province - Combo box created  - Row source: Province 

1

2

5.1 Field: Completed

Input Mask: 00/>LLL/ - Two compulsory digits: 00  - Uppercase: >  - Three compulsory letters: LLL  - Four compulsory digits: 0000  - Divider: / (accept '-' due to computer settings) 

1

5

5.1 Field: Capacity

Validation Rule >=0 OR NOT <0  1

1

5.1 Field: Illustration - Data type changed to OLE Object/ Hyperlink  - 5AlbertFalls image inserted for the 'Albert Falls Dam' record 

(Note to marker: Check on Hyperlink when file is transferred to another computer.)

1

2

Query: qry5_

5 • Town field inserted  - Criteria in Province field: Limpopo 

(Note to marker: 15 records expected.)

1

2

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

Query: qry5_

5 • Fields displayed: Province, Avg Of Capacity OR Capacity 

Criteria on Province: "Free State"  OR "North West" 
AVG  (ignore whether rounded or not)
Calculated on Capacity field 

(Note to marker: 2 records expected.)

1

5

Query: qry5_

5 • Only Name and Town fields display  - Criteria on Surface: IS NOT NULL OR "Like *" OR "True"  - Criteria on Completed: Between #01/01/1990#  AND #31/12/2000#  OR >=#1/1/1990# AND <=#12/31/2000#

(Notes to marker:

11 records expected.
Format of the dates may differ depending on system dates.)

1

2

4

Query: qry5_

5 • Calculated field called Volume has been created  - Calculation: [Surface]*[Height]*0  - Format changed to Fixed/Standard  and one decimal place 

1

4

Form: frm5_

5 • 5AlbertFalls image added  as form background image 

Hyperlink inserted  next to Province label
Links to the Province table NOT database 
Examination number displays in the form footer 

1

5

Report: rpt5_

5 • Illustration label AND field removed  - Report grouped according to Province  - Report sorted by Town  - Function in Province report footer/report header  =MAX([Capacity]) 

1

5

Total for QUESTION 5 [37]

NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER

6 Table columns <td colspan="2"> <font size="3"> <i>The kitchen ... Here are some suggestions:</i> </font> </td>

One table cell appears 
Closing tags for first cell and opening tags for second cell removed 
Column span set to 2 

1

3

6 Alternative text <tr> <th><img src="6House" alt = "Inside">Inside the house</th>

Alternative text 'Inside' added  on 6House image 1

1

6 Unordered list <ul type="circle"> <li>Avoid ....</li> <li>Run ....</li> <li>Keep ....</li> <li>Check your ...</li> <li>Install ...</li> <li>Take ...</li> <li>When ...</li> <li>Turn ....</li> </ul>

Type set to circle 
All list items have opening and closing tags 

1

2

6 Link <a href=mailto:"waterwize@water.co"> waterwize.co</a>

Link created on the text 'waterwize.co' (accept any text) 
Links to an e-mail address – Mailto: 
E-mail address 'waterwize@water.co' 

1

3

Closing tag(s) or triangular brackets omitted or more than one closing tag in the incorrect order - Total for QUESTION 6 [19]

NSC – Memorandum/Marking Guidelines

EXAMINATION NUMBER

QUESTION 7 Total Q7: 15 File names: 7River_Rivier, 7Rivers_Riviere, 7Answ_Antw

No Criteria Maximum Mark

Candidate Mark

7Rivers_Riviere worksheet

7.1 Header - Worksheet name added  - As field  - In the left section of the header 

1

3

7.1 Named range - Named range changed to 'Name_River' 

(Note to marker: Accept if a new named range 'Name_River' was inserted.)

1

7.1 Protection - Columns A to C locked  - Password 123 used 

1

2

7River_Rivier database

7 Import table - Data from the 7Rivers_Riviere spreadsheet imported in 7River_Rivier database  - Saved as a new database table called Rivers 

1

2

7Answ_Antw

7.3 Gutter position of the document - Top  1

1

7.3 Number of paragraphs in the document - 83  1

1

7.3 Number of occurrences of the letter 'm' in the document - 185  1

1

7.3 First word that appears on line 100 - rates OR crop  1

1

7.3 Line weight of the 'Intense Quote' style - 0 OR (½)  1

1

7.3 Word marked as an index - SHARPS  1

1

7.3 Title of the citation source that appears in the document - Water Savers  1

1

Total for QUESTION 7 [15]

TOTAL 180

Was this document helpful?