Font size
WorksheetsICT 11 Long Test 4
Total questions: 70
Worksheet time: 1hrs 20mins
What is an expert system?
An oracle that predicts the future.
A system that attempts to reproduce the decision-making process of an expert human being.
A person who is very smart and knows everything.
The login in system of an internet based application
What does the word 'Diagnosis' mean?
To dial a person and communicate on social media.
A process in attaining the perfect nose.
Identifying a problem by analysis of the symptoms.
Artificial intelligence.
What is Artificial Intelligence?
A non-fiction comic book.
A person that is not being very good at quizzes.
Pretending to be something that you are not.
Computer systems that perform tasks that human beings would normally do.
What is 'chaining'?
The combining together of instructions.
The art of making fences.
Putting links together to make a robust anchor system.
Dialing random numbers and speaking to strangers.
What is a 'computer transaction'?
Selling computers at the local mall.
A specialist type of computer monitor.
The exchanging of data between computers.
When computers decide to go shopping.
Expert Systems - Knowledge Base - What is it?
A top secret Rebel Base on Tatooine.
67
The answer to all the questions.
A database that allows the storage and retrieval of the knowledge provided by a collection of expert human beings.
Expert Systems - Inference Engine - What is it?
The part of an expert system that makes reasoned responses based on a set of established rules.
The power supply of a personal computer.
Thomas the tank engine's fusion drive.
Somebody who continually interferes with something.
What is forward chaining?
Creation of questions dependent upon answers.
It is the automated decision making within an inference engine. It will take known data and process it until it reaches an outcome.
Creating fencing in a clockwise direction.
Chains that think for themselves.
What is backward chaining?
Taking down barriers.
Data switching within a network.
Delivering automated shipping.
The process of establishing possible causes when an outcome is known within an inference engine.
What is a user interface for in an expert system?
It is the instruction manual.
It is the way the user interacts with the system.
It is the art of graphical communication.
It is a mode of hipster communication.
What is data processing?
Production line making of 1s and 0s.
a method to input data, a method to process data and a method to output data.
The process of consuming bits and bytes.
An alternative to organic data.
Batch Processing - What is it?
A way of creating bread rolls in certain parts of the world.
A processing method so that data is live and always up to date.
A system that processes data at set intervals. Outputs will only be produced at this time.
The making of batches...... of small alien toys.
What kind of data processing system is best suited to a 'stock control system'?
Real-time processing - delivery vans can be sent to the store everytime an item of stock is sold.
Beef cattle supplements are an ideal of example of this.
Batch Processing - days sales are recorded at the sales registers. Sales information can be batched together for upload to the warehouse at the end of each day to ensure the shops are restocked.
Online processing - all sales whether online or in store are instantly replenished.
DATA PROCESSING - What is an online processing system?
A cash register based system in a shop.
It is the sale of data on the internet.
A real-time system of updating batch data.
A system that deals with data in transactions. Once the data is collected as a transaction, it is processed and the next transaction can occur.
DATA PROCESSING - What kind of data processing system is best suited to a 'payroll system' of 1000 employees?
Online Processing - Employee data can be kept up to data and pay accrued can be shown at any time.
Batch Processing - Data is input by employees arriving at work and leaving work - The amount of hours an employees works can be calculated monthly.
Manual processing -Do not use computers!
Real-Time processing
Pay the employees every hour.
DATA PROCESSING - What processing system is suited to a flight vendor?
Real - time processing
Only process bookings on the airport
A batch processing system would be best........all sales could then be updated at the end of the week.
Manual processing - Do not use computers!
Online processing -
Transaction based processing system. Each transaction is processed in turn to ensure that the flight cannot be oversold
Real Time Processing - What is it?
Real time processing involves time transactions.
A real time processing system is used when the data being processed is vital and needs to be up to date.
Time does not really exist......clocks do however.
Real time is different to assumed time and may be skewed when the space time continuum is breached.
DATA PROCESSING - What system is best suited to 'air traffic control'?
Batch processing - all the information is recorded and updated at the end of the day. Disasters are logged and fed out to news agencies.
There isn't a need for a processing system. The pilots have their own eyes processing in real time.
Online processing - information is fed to the computer in batches one at a time and the air traffic controller deals with each plane individually before moving on to the next.
Real time processing without a doubt! It is essential that all planes have the locations and information regarding all other vehicles in the air space at all times.
What type of advice could an expert system provide in helping to distinguish items such as plants, animals, rocks, etc.?
Investment strategies
Identification based on characteristics
Medical diagnosis
Financial analysis
What is a characteristic of expert systems that distinguishes them from human experts?
Ability to easily adapt to new circumstances
Possession of common sense
Inability to make mistakes
Capability to process totally unexpected data
What is a limitation of expert systems mentioned in the notes?
They have common sense
They easily adapt to new circumstances
They cannot process totally unexpected data
They are always easy to use
Why might expert systems be used in providing financial advice?
To replace human experts
To eliminate the need for a knowledge base
The knowledge base contains data about past financial performance
They have common sense
In what application would an expert system use characteristics of likely rock formations to provide advice on locations to drill for water or oil?
Cooking
Chess strategy
Medical diagnosis
Energy / Resource exploration
In medical diagnosis using an expert system, what serves as the query for the inference engine?
Medical information
Symptoms of the patient
Diagnosis of the patient's illness
Strategies and moves
What is the purpose of the knowledge base in an expert system?
To store user queries
To provide a simple user interface
To act as a search engine
To contain facts and rules created by human experts
Why might an expert system providing financial advice be challenging for non-expert users? (2 answers)
Lack of knowledge base
Difficulty in using the system
Abundance of common sense
Presence of an inference engine
What is a potential application of expert systems in playing strategy games like chess against a computer?
You can be friends with the bot
Financial analysis
It might change your way of life
Advising on game strategies and moves
What is the role of the inference engine in an expert system?
To provide a user interface
To store the knowledge base
To process user queries and apply rules from the knowledge base
To replace human experts
How does an expert system assist in the field of medical diagnosis?
By replacing the need for doctors
By providing advice based on symptoms and medical information
By acting as a search engine
By storing patient data
What is the main application of expert systems in financial planning?
100% you get rich
Make you more addicted to playing games
Optimizing investments
Diagnosing mechanical faults
What is the advantage of using expert systems to invest in a business?
Tailored financial planning
Costly implementation
Limited knowledge base
Increased human errors
Which one is a disadvantage with expert systems?
Their jokes are not funny
Which one is an advantage of an expert system?
Which one is a disadvantage of expert systems?
Which one of these jobs would best benefit from an expert system?
Soldier
Wrestler
Which of the following is an example of an expert system?
• diagnosing a person's illness
prospecting for oil and minerals
tax and financial calculations
All of the above
Do Expert systems gather data by asking the user questions about the problem?
Yes
No
Building an expert system is known as knowledge engineering and it is composed of three main components: (3 answers)
the knowledge base
knowledge acquisition program
the user interface
the inference engine
System Shell
Expert systems can explain their reasoning to the user. (a)
The performance of an expert system depends on the quality of its knowledge base. (a)
The knowledge base contains facts and rules about a specific subject area. (a)
Expert systems work best in situations with clear, rule-based logic. (a)
The output of an expert system is always 100% reliable. (a)
Expert systems are always more accurate than human experts. (a)
An expert system can learn new knowledge automatically without human input. (a)
A feature in Excel that creates or calculates rows and columns based on values in the selected cells.
cell style
avg if function
data validation
auto fill
A function that allows the user to make a comparison between two values and then returns a true or false result.
AVG IF FUNCTION
IF FUNCTION
COMPARE FUNCTION
RESULT FUNCTION
This option allows a user to set private settings on a worksheet with a password.
workbook protection
worksheet protection
saving protection
excel savings protection
a combination of a column letter and a row number that identifies a cell on a worksheet.
CELL RELATIVE
CELL LABEL
CELL REFERENCE
CELL LOCATION
A reference that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook.
NO CHANGE REFERENCE
CELL RELATIVE REFERENCE
ABSOLUTE CELL REFERENCE
MIXED REFERENCE
A reference in Excel that adjust and change when copied or when using AutoFill.
STYLE CELL REFERENCE
RELATIVE CELL REFERENCE
ABSOLUTE CELL REFERENCE
MIXED CELL REFERENCE
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
which of the following VLOOKUP formulas should be entered in cell B2 to show the result "8.2%"
=VLOOKUP(B1,A5:C8,2,FALSE)
=VLOOKUP(B1,A5:C8,2,TRUE)
=VLOOKUP(B1,A5:C8,3,FALSE)
=VLOOKUP(B1,A5:C8,3,TRUE)
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above
When starting a formula what is the first thing you type in the cell?
&
=
%
+
When number signs (#####) are displayed in the cell, it means:
The formula in the cell is wrong
There are too many characters in the cell to be displayed with the current cell width
The decimal point placement in the cell is wrong
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
What is the result of this statement: IF(5>4 AND 4>5, 1, 2)?
TRUE
2
1
FALSE
Use CONCATENATE to combine the text strings in cells A1, B2, and C3.
CONCATENATE(A1:B2:C3)
CONCATENATE(ALL)
CONCATENATE(A1,B2,C3)
CONCATENATE(A1B2C3)
Which function returns the number of characters in cell T4?
TEXTLENGTH(T4)
EXACT(T4)
LEN(T4)
CHAR(T4)
=RIGHT("COMFORTABLE",5)
TABLE
COMFO
=LEFT("TECHNOLOGY",4)
LOGY
TECH
=CONCATENATE("ICSE", "-","CURRICULUM")
icse-curriculum
ICSE-CURRICULUM
=ROUND(7.1467,2)
7.14
7.15
A_________ is a built in mathematical formula included in excel.
Function
Cell
Formula
=COUNT("apple",100,125,150,"orange")
5
2
3
null
=INT(79.99) will return what value?
79
79.9
80
None of these
What does the function TRIM do in Excel?
Removes leading and trailing spaces from a text string
Converts text to uppercase
Counts the number of characters in a text string
None of the above
How can you freeze panes in Excel?
Go to View tab and click on Freeze Panes
Use the shortcut Alt + F4
Right-click on the cell and select Freeze Panes
Freezing panes is not possible in Excel
What is the purpose of the CONCAT function in Excel?
To concatenate two or more strings
To count the number of characters in a cell
To round off a number to the nearest integer
To find the maximum value in a range of cells
