Worksheets8B #SAS12
Total questions: 35
Worksheet time: 50mins
Explain the syntax of VLOOKUP function in Excel.
The syntax of VLOOKUP function in Excel is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
=LOOKUP(lookup_value, lookup_vector, result_vector)
=INDEX(array, row_num, [column_num])
When would you use VLOOKUP for data analysis in Excel?
You would use VLOOKUP in Excel for data analysis when you need to change the font style of a table.
You would use VLOOKUP in Excel for data analysis when you need to delete duplicate values in a table.
You would use VLOOKUP in Excel for data analysis when you need to search for a value in a table and return a corresponding value from another column.
You would use VLOOKUP in Excel for data analysis when you need to create a new table from scratch.
What are the different data visualization techniques available in Excel?
Data visualization techniques in Excel include sound effects, transitions, and slide backgrounds.
Data visualization techniques in Excel include word art, clip art, and smart art.
Data visualization techniques in Excel include drawing tools, 3D models, and animation effects.
Some of the data visualization techniques available in Excel include charts (such as bar charts, line charts, and pie charts), sparklines, and conditional formatting.
=C4+C5
What is the result?
32
12
17
15
According to the graph, about how many trees are between 150 and 200cm tall?
4 trees
11 trees
27 trees
30 trees
50 trees
What does ICT mean?
Information and Communication Technology
Information and Collaborative Technology
Innovative and Communicatory Technology
Information and Content Technology
The following are advantages of using ICT in education, except
Helps gain and hold the students attention
Access to limitless resources for teaching and learning
Promotes initiative and independence learning
ICT tools make it easier to cheat
Learning can be accessible anytime anywhere
How does ICT enhance student engagement in the learning process?
ICT does not enhance student engagement in the learning process.
ICT is too expensive and not worth the investment for student engagement in the learning process.
ICT enhances student engagement in the learning process through interactive and multimedia resources, collaboration and communication, personalized learning experiences, and increased access to educational materials.
ICT only provides distractions for students during the learning process.
What are the benefits of using ICT in education?
Improved access to information, enhanced learning experiences, increased student engagement, personalized learning, and improved collaboration and communication.
Decreased access to information, limited learning experiences, decreased student engagement, standardized learning, and limited collaboration and communication.
Increased access to misinformation, negative impact on learning experiences, decreased student engagement, no personalized learning, and limited collaboration and communication.
No impact on access to information, no improvement in learning experiences, no increase in student engagement, no personalized learning, and no improvement in collaboration and communication.
How does ICT support collaborative learning?
ICT supports collaborative learning by allowing students to work together on virtual projects.
ICT supports collaborative learning by providing access to online forums and discussion boards.
ICT supports collaborative learning by facilitating real-time communication and video conferencing.
ICT supports collaborative learning by providing tools and platforms for communication, resource sharing, and project collaboration.
What challenges can arise when implementing ICT in education?
Inadequate internet connectivity, privacy and security concerns, difficulty in integrating technology into existing teaching methods
Lack of infrastructure, limited access to technology, inadequate training for teachers, resistance to change, and potential for increased inequality among students.
Lack of parental involvement, limited resources, technical difficulties, lack of digital literacy skills
Insufficient funding, lack of support from administration, outdated curriculum, lack of student motivation
How does ICT promote critical thinking skills in students?
ICT promotes critical thinking skills in students by providing access to information, encouraging analysis and evaluation, and enabling collaboration and problem-solving.
ICT promotes critical thinking skills in students by limiting access to information, discouraging analysis and evaluation, and hindering collaboration and problem-solving.
ICT promotes critical thinking skills in students by providing outdated information, discouraging analysis and evaluation, and enabling competition and memorization.
ICT does not promote critical thinking skills in students, it only provides entertainment and distraction.
What is the role of ICT in distance learning?
ICT hinders communication and collaboration in distance learning.
ICT enables communication, collaboration, and access to educational resources remotely.
ICT only provides access to educational resources.
ICT has no role in distance learning.
Which the following employment area is negatively affected by ICT?
Software Industry
Manufacturing Industry
IT Security
Robotic Engineers
Which of these are advantages on employment brought forth by ICT?
More lower paying jobs
Job losses
More efficient
Cleaner
Which of these are advantages of a robot vs human? (select all the correct answers)
They are expensive
Doesn't get bored from repetitive tasks
Higher productivity
Can work long hours without rest
Which the following employment area is negatively affected by ICT?
Software Industry
Manufacturing Industry
IT Security
Robotic Engineers
Which of these are advantages on employment brought forth by ICT?
More lower paying jobs
Job losses
More efficient
Cleaner
Which of this is a disadvantage to having more microprocessor controlled devices in the home?
Free up more time
More comfortable
Unhealthy lifestyles
Increase efficiency
Microprocessor-controlled devices in the home advantage
People can become over reliant on these devices and can become lazy
Manual household skills are lost
Tasks do not need to be done manually
Can lead to unhealthy eating due to dependency on ready meals
Areas of Increased Employment due to ICT
Retail
Manufacturing
Office Work
Computer Programmers
How can a Computer be Protected from Hacking?
Place a firewall between your computer and any network
Always lock your computer when away
Use weak passwords to protect your user login account
Use strong passwords to protect your user login account
Which one is not the Advantage of ICT Effect on employment?
Workers getting replaced
Fewer manual tasks
Machines do not take holidays
Safe working enviornment
Which the following employment area is negatively affected by ICT?
Manufacturing Industry
Software Industry
IT Security
Robotic Engineers
Describe three disadvantages to the company of using robots rather than humans to manufacture cars. (Describe question)
Why do businesses use ICT?
Large data space
More workers which saves expenses in wages
Data can be stored and processed fast
Huge quantities of paperwork
A manufacturing company has decided to use robots on the production line.
By placing ticks in the boxes on the right, indicate three disadvantages to the manufacturers of using robots on the production line.
Robots are expensive to buy and maintain
Robots are unable to think for themselves and can repeat errors
Redundancy payments to dismiss workers can be expensive
Items produced are not made to a consistent standard
Remaining workers will need to be paid higher wages.
The introduction of computers into the workplace has caused some changes in employment.
Identify two different types of job where employment has decreased.
Describe three advantages to the company of using robots rather than humans to manufacture cars.
Which of the following is the advantage of ICT in distant learning?
Our economy will relatively grow due to the demand for technology and internet needs.
Education can continue at home using collaborative tools and other online applications.
There will be a reduction in physical activities that may lead to some health issues.
Social-physical interaction can be reduced
How can understanding and manipulating ICT help transform society?
ICT can be helpful for the young and old generation to survive the digital era.
To develop a more comprehensive tool or platform for everyone to use.
The proper and strategic use of ICT creates a boundless way of communication and a result of the progression of the economy.
When people choose to learn about ICT
Which part of the business does ICT play an important role?
Gambling
Barter
E-commerce
Market selling
ICT has a significant role in communication, as it accurately transmits information. Which of the following mode can be the LEAST platform to use in communication?
Text Message
Advertisement
Snail Mail Letter
Chat
Why is business called the “blood of the economy”?
It can build projects by the government using the taxes collected in every business transaction.
It is where and how people make money through selling goods or services.
It gives a livelihood for low-income earners.
It always starts with a capital.
E-library is an application of ICT in
Church
Banking
Eduaction
Gambling
