From Data to Information
Networks
Issues in ICT
Spreadsheet
Unknown
100
What is data?
Unprocessed, unorganised and distinct facts or ideas.
100
What does a switch do?
It is a connecting point for cables in a LAN
100
People's need to access their favourite site, such as Facebook is a symptom of this issue.
Social Network Addiction
100
What is a spreadsheet made up of?
Worksheets (or rows and columns)
100
This chart is a way to manipulate data. It identifies a program's inputs, outputs and the processing steps required to transform the inputs into the outputs.
IPO chart
200
What are the stages of the problem-solving methodology?
Analysis, Design, Development and Evaluation.
200
This type of network is when a server controls access to the hardware and software on the network and provides a centralised storage area for programs, data and information.
Client-server network
200
What is the percent of female gamers? If you are within 5% you will get these points.
50%
200
Give an example of a spreadsheet formula:
Conditional, lookup, date and time, financial, statistical, math (including SUM and AVERAGE), counting, conversion and text.
200
What are 2 limitations of a smart phone?
Screens are small, most webpages aren't designed to be displayed on a small screen, the keyboard keys are smaller making correct data entry difficult.
300
What are the four types of data?
Integer data types, Floating point numbers, Character data types and String data types.
300
What are two forms of physical transmission?
Twisted-pair cables, coaxial cables and fibre-optic cables
300
This is an Internet-based, specialised data centre that offer offsite storage.
Cloud computing
300
Money values in a spreadsheet usually have how many decimal places.
2
300
Most operating systems require that you correctly enter one of these before you can access the data.
Username or password
400
Manual validation techniques include:
Proof reading, reasonableness.
400
This is inserted into a personal computer and enables a computer that does not have in-built network capability to communicate with a network.
An NIC (Network Interface Card)
400
What does MMORPG stand for?
Massively multiplayer online role-playing game
400
What should you do when creating a spreadsheet for colour blindness?
Make sure the colours are visible
400
This is a key word, phrase or symbol that represents a value that may change.
A variable
500
Inaccurate data will lead to:
incorrect information being produced.
500
This is a network standard that manages the transmission of data by breaking it up into packets and transmitting the packets over the Internet.
TCP/IP (or Internet Protocol Suite)
500
There are four types of issues that arise for any problem. One of these is social issues. What are the other four?
Ethical issues, legal issues, economical and environmental issues
500
What kinds of checking (validating data) do you have to do when viewing postcodes in Melbourne?
Range checking, existence checking, data-type checking
500
Organisations and individuals require information to support their decision making and problem-solving needs. These can often be expressed in terms of 4 desires. One is to inform. What are the other three?
Persuade, entertain and educate
M
e
n
u