QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data. 8.2 What is the effect of using the spreadsheet feature 'Format as Table' on a cell range? 8.3 Give an example of a spreadsheet function that cuts off only the decimal portion of a number. 8.4 State TWO common problems when importing data from a CSV file into a database. 8.5 Which TWO automatic referencing features of a word processing application are only available if the 'Manage Sources' feature has been used? 8.6 A heading that was later added to a document does not appear in the automatic table of contents. State TWO steps to take to ensure that this new heading will appear in the automatic table of contents. 8.7 An image on a web page you created does not display fully in the browser. Suggest TWO ways to ensure that the image is fully visible. 8.8 The following HTML code was taken from a working HTML document: 8.8.1 How many cells should be displayed in the first row? 8.8.2 Why does this code not display anything in the browser?

NSC Computer Application Technology Uses of common applications: QUESTION 8: SOLUTION DEVELOPMENT

QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2

Question 8

QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data. 8.2 What is the effect of us... show full transcript

Worked Solution & Example Answer:QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2

Step 1

Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data.

96%

114 rated

Answer

Data Validation: This feature ensures that only valid data is entered into the system, reducing errors.
Data Format/Data Type: It defines the type of data that can be entered, such as text, numbers, or dates, ensuring consistency.

Step 2

What is the effect of using the spreadsheet feature 'Format as Table' on a cell range?

99%

104 rated

Answer

The 'Format as Table' feature provides a structured format which enhances readability. It applies distinct styles to the column headings and rows, and automatically creates a named range for easier reference in formulas.

Step 3

Give an example of a spreadsheet function that cuts off only the decimal portion of a number.

96%

101 rated

Answer

An example is the TRUNC function, which truncates a number to an integer by removing the decimal part without rounding.

Step 4

State TWO common problems when importing data from a CSV file into a database.

98%

120 rated

Answer

Inconsistent Data Types: When data types in the CSV do not match the database schema, it can lead to import errors.
Incorrect Delimiters: Misalignment caused by inconsistent or unexpected delimiters can lead to improper parsing of the data.

Step 5

Which TWO automatic referencing features of a word processing application are only available if the 'Manage Sources' feature has been used?

97%

117 rated

Answer

Citations: Automatic generation of citations for referenced works.
Bibliography: A comprehensive list of works cited in the document, formatted according to a specific citation style.

Step 6

State TWO steps to ensure that this new heading will appear in the automatic table of contents.

97%

121 rated

Answer

Apply a Suitable Style to the Heading: The new heading should be formatted with a heading style recognized by the table of contents.
Update the Table of Contents: After making changes, refresh the table of contents to include the new headings.

Step 7

Suggest TWO ways to ensure that the image is fully visible.

96%

114 rated

Answer

Resize the Browser: Increasing the browser window size can help display the image correctly.
Change the Display Resolution: Adjusting the screen resolution can improve visibility and allow the image to fit better.

Step 8

How many cells should be displayed in the first row?

99%

104 rated

Answer

Only one cell should be displayed in the first row, as per the HTML structure provided.

Step 9

Why does this code not display anything in the browser?

96%

101 rated

Answer

The code does not display anything because there is no content within the <td> (table data) tags. It needs text or other elements to render visible content.

QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2

Worked Solution & Example Answer:QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2

Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data.

What is the effect of using the spreadsheet feature 'Format as Table' on a cell range?

Give an example of a spreadsheet function that cuts off only the decimal portion of a number.

State TWO common problems when importing data from a CSV file into a database.

Which TWO automatic referencing features of a word processing application are only available if the 'Manage Sources' feature has been used?

State TWO steps to ensure that this new heading will appear in the automatic table of contents.

Suggest TWO ways to ensure that the image is fully visible.

How many cells should be displayed in the first row?

Why does this code not display anything in the browser?

Join the NSC students using SimpleStudy...