Spreadsheets
HTML & CSS
Effects of using ICT
Databases
Expert Systems
100
A vertical series of cells in a chart or spreadsheet
What is a spreadsheet column?
100
World Wide Web
What does "www" stand for?
100
They can run all day and night without needing a break
What is an advantage of using robots?
100
A collection of fields which may contain different types of data
What is a record?
100
Computer software that attempts to act like a human expert in a particular subject area.
What is an expert system?
200
An address or pointer that changes when the target item is moved or the relationship to it has changed.
What is a relative reference?
200
Creates a numbered list in a webpage
What does
    do?
    200
    Typing and using a mouse for long periods
    What are common causes of RSI?
    200
    It stores data in several tables which are linked together via certain fields
    What is a relational database?
    200
    They can be used to make diagnoses of a problem based on a patient's symptoms
    How can expert systems be used to provide medical care?
    300
    Double-click the boundary to the right of the column heading
    How do you change the column width to fit the contents?
    300
    This code shows a picture of a fluffy dog, stored in the same directory as the webpage. It doesn't need a closing tag.
    What does
    300
    Something that can copy itself from one machine to another without your knowledge
    What is a computer virus?
    300
    It is a field called Tax_Payable which calculates the product of the Cost_Price and VAT. It is only calculated at runtime and would be seen in a query, not in a table
    What does Tax_Payable:[Cost_Price]*[VAT] do and where would it be seen?
    300
    Interactive user engine, inference engine, rules base, knowledge base
    What are the 4 components of an expert system?
    400
    It looks in the first column in a table for your search value (29), then returns the relevant value from the third column. It will not work if 29 is not in the first column.
    What does vlookup(29,table_array,3,FALSE) do?
    400
    The first term gives the file location relative to your current file, the second term gives the absolute file location.
    What do "relative file path" and "absolute file path" refer to?
    400
    Having a bad posture when sitting using a computer
    What causes back and neck pain?
    400
    This is found in the Criteria option and will return all records with a "P" or a "Q" somewhere in this field when a query is run.
    What does "*P*" OR "*Q*" do?
    400
    It can make decisions based on ambiguously asked questions that humans make.
    How does fuzzy logic work?
    500
    It changes colours or other formatting, dependent on the value in the cell
    What is conditional formatting?
    500
    The first term identifies a CSS tag which affects one unique element, the second term identifies CSS that affects all HTML elements with that attribute
    What is the difference between a CSS ID and a CSS Class?
    500
    Can be used to supplement standard teaching tools
    How can ICT be used in the classroom
    500
    If you don't put your name, candidate number & centre number here, your work won't be marked. This will put these details onto every page automatically.
    What will happen if I don't put my details in the page header or footer?
    500
    They can't easily adapt to new circumstances, they can be difficult to use, and they have no "common sense"
    Why do expert systems make mistakes?