The organisers of the expo will be responsible for all managerial tasks at the expo, including registrations and the voting process - NSC Computer Application Technology - Question 10 - 2017 - Paper 2
Question 10
The organisers of the expo will be responsible for all managerial tasks at the expo, including registrations and the voting process.
10.1 State ONE potential disadv... show full transcript
Worked Solution & Example Answer:The organisers of the expo will be responsible for all managerial tasks at the expo, including registrations and the voting process - NSC Computer Application Technology - Question 10 - 2017 - Paper 2
Step 1
State ONE potential disadvantage of using WhatsApp to promote the expo.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One potential disadvantage of using WhatsApp to promote the expo is that not everybody may have the WhatsApp app installed, which limits the audience that can be reached.
Step 2
What is information overload?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Information overload occurs when a person receives too much information, such as posts, emails, or notifications, to the point where they struggle to process it efficiently. This often leads to feeling overwhelmed and unable to make informed decisions.
Step 3
State TWO ways in which information overload can be reduced.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Define and use email message rules to filter important communications, thus reducing unnecessary distractions.
Limit social media interactions to avoid excessive posts and notifications that contribute to overwhelming amounts of information.
Step 4
Suggest TWO technologies that participants can use to pay the registration fee if they cannot get to the school or a bank during office hours.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Use internet banking or banking apps to make electronic payments.
Utilize mobile payment options such as e-wallet apps.
Step 5
How could the organisers of the expo confirm that the registration fee has been paid, other than phoning the bank?
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The organisers can confirm payment by sending an email notification or an electronic receipt to the participant, verifying the transaction details.
Step 6
Explain why using a table format for the user to enter the cellphone number is a good idea.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Using a table format reduces the likelihood of error by guiding the user to fill in the correct number of digits required for the cellphone number.
Step 7
Suggest TWO ways to improve the layout of the form.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Add more space for the surname to ensure it is not cramped.
Include instructions for users on how to fill out the form correctly.
Step 8
State TWO ways in which the organisers can be sure that the data on this computer cannot be stolen or accessed illegally, other than protecting it against physical theft.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Install and keep security software updated to prevent unauthorized access.
Use encryption for sensitive data to render it unreadable if stolen.
Step 9
Why is the DOB field not suitable to act as a primary key?
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The DOB field is not suitable as a primary key because it may contain duplicate values, making it impossible to uniquely identify each record.
Step 10
Which database feature can be used to ensure that a user will have to enter three letters followed by three digits?
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A validation rule can be used to enforce that the user input conforms to the specified format of three letters followed by three digits.
Step 11
Which database feature can be used to ensure that the Name and Surname fields are NOT left blank?
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A validation rule can be implemented to require that both Name and Surname fields are completed before the record can be saved.
Step 12
Which database feature can be used to ensure that typing errors do not occur when data is entered in the Favourite Project field?
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Implementing a lookup wizard can minimize typing errors by providing users with a predefined list of options to select from.
Step 13
Explain why or when one would generally try to use the 'Open With' option to open a file.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The 'Open With' option is used when a file does not automatically open with a default program, allowing the user to select an application that can handle the file type.
Step 14
Give TWO reasons for using the PDF file format.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
PDF files can be viewed without needing the specific software that created them, making them widely accessible.
PDFs maintain formatting across different devices and platforms, ensuring consistency.
Step 15
Why would one tick the check box towards the bottom left-hand corner of the dialog box?
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Checking the box ensures that the selected program will always open this type of file in the future, improving user convenience.
Step 16
Why is it better to use the cell reference B9 in the function instead of just the value of 250?
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Using the cell reference B9 allows for easier updates to the registration fee without needing to change the formula itself, promoting flexibility in calculations.
Step 17
Explain why the function is not calculating the correct amounts for some cells in column F AND rewrite the function so that it would copy down correctly.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The function may not calculate correctly if it uses absolute references that do not adjust for each row. The corrected function should be rewritten as: =IF(D2="Yes",0,C2*$B$9) to ensure that the reference to the fee in cell B9 remains fixed.
Step 18
Explain if it would be possible to create a meaningful graph from the range B2:B7.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Yes, it is possible to create a meaningful graph provided that appropriate data is selected to represent the projects along with their respective fees or counts.
