Photo AI

Contemporary South African artists have started using new media technologies - NSC Computer Application Technology - Question 7 - 2018 - Paper 1

Question icon

Question 7

Contemporary-South-African-artists-have-started-using-new-media-technologies-NSC Computer Application Technology-Question 7-2018-Paper 1.png

Contemporary South African artists have started using new media technologies. 7.1 Open the 7Global word processing document. 7.1.1 Fill the background of the WordA... show full transcript

Worked Solution & Example Answer:Contemporary South African artists have started using new media technologies - NSC Computer Application Technology - Question 7 - 2018 - Paper 1

Step 1

7.1.1 Fill the background of the WordArt shape with a colour pattern of your choice.

96%

114 rated

Answer

To fill the background of the WordArt shape, select the WordArt object in the document. Navigate to the 'Format' tab, then click on 'Shape Fill'. Choose a color pattern from the available options to customize the fill of the WordArt shape.

Step 2

7.1.2 Find the text 'Insert linked object'.

99%

104 rated

Answer

Locate the text 'Insert linked object' within the document. Then, go to the 'Insert' tab, choose 'Object', and select 'Create from File'. Browse for the document '7Ruga' and ensure to select the option to display it as an icon before clicking 'OK'.

Step 3

7.1.3 Modify the 'Intense Quote' style as follows: Set the numbering format to 1), 2), 3), etc. Apply the 'Intense Quote' style to all 'Heading 2' headings.

96%

101 rated

Answer

To modify the 'Intense Quote' style, go to the 'Home' tab and click on 'Styles'. Right-click on 'Intense Quote' and select 'Modify'. Under 'Numbering', set the format to 1), 2), 3), etc. Then, apply this style to all paragraphs formatted as 'Heading 2' by selecting them and clicking on the 'Intense Quote' style.

Step 4

7.1.4 Insert a comment on the text 'Resources' at the top of the last page of the document with the text 'Media resources'.

98%

120 rated

Answer

Navigate to the last page of the document and find the text 'Resources'. Highlight the text, right-click, and select 'New Comment'. In the comment box that appears, type 'Media resources' and click outside the box to save it.

Step 5

7.2.1 Add the data in the tblA table and the tblB table to the tblColours table.

97%

117 rated

Answer

Open the 7Watercolour database and locate the tblA and tblB tables. Select the data from both tables, ensuring to include all necessary columns. Then, open the tblColours table and paste the copied data into it, ensuring the data aligns correctly with the existing columns.

Step 6

7.2.2 Export the data in the tblA table to a pdf format file and save it as 7WColour in the examination folder.

97%

121 rated

Answer

Select the tblA table within the 7Watercolour database, then go to 'File' and choose 'Export'. Select 'PDF' as the format, and in the Save dialog, change the file name to '7WColour' and choose the examination folder as the destination before saving.

Step 7

7.3.1 Work in the 7.3.1 worksheet. Determine how many artworks are on the list.

96%

114 rated

Answer

In the 7.3.1 worksheet, use the COUNT function to determine the number of artworks listed. If the artworks are in column A, type =COUNTA(A:A) in cell A1 to count all entries.

Step 8

7.3.2 Work in the 7.3.2 worksheet. Determine how many artworks with lithograph as medium are on the list.

99%

104 rated

Answer

Navigate to the 7.3.2 worksheet. Use the COUNTIF function to find the number of artworks that have 'lithograph' in the medium column. If the medium is listed in column B, enter =COUNTIF(B:B, "lithograph") in cell A1.

Step 9

7.3.3 Work in the 7.3.3 worksheet. Determine how many artworks have data for BOTH the framed categories and the unframed categories.

96%

101 rated

Answer

Go to the 7.3.3 worksheet. Use the COUNTIFS function to find the number of artworks that meet both conditions. Assuming framed data is in column C and unframed data is in column D, type =COUNTIFS(C:C, "<>", D:D, "<>") in cell A1 to count artworks with data in both categories.

Step 10

7.3.4 Work in the 7.4 worksheet. Determine the number of different artists that appear on the list.

98%

120 rated

Answer

In the 7.4 worksheet, use the UNIQUE function combined with COUNTA. Assuming the artists’ names are in column A, enter =COUNTA(UNIQUE(A:A)) in cell A1 to count unique artists.

Step 11

7.3.5 Work in the 7.5 worksheet. Determine in how many different mediums the artworks of the artist 'Kentridge, William' appear on the list.

97%

117 rated

Answer

Navigate to the 7.5 worksheet. To find the number of unique mediums associated with 'Kentridge, William', apply the UNIQUE and FILTER functions. Assuming artist names are in column A and mediums in column B, use the formula =COUNTA(UNIQUE(FILTER(B:B, A:A="Kentridge, William"))) in cell A1.

Join the NSC students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;