Data analysis. Data management.
NORTH KAZAKHSTAN STATE
UNIVERSITY NAMED
AFTER M. KOZYBAYEV
EXAM TEST
INFORMATION AND COMMUNICATION TECHNOLOGIES
For all specialties and the directions of preparation of a bachelor degree
The volume of the credits 3
Petropavlovsk
2016
Human-computer interaction.
1. Which user interface enables users to open applications by clicking on shortcut icons on the desktop?
A. Graphical User Interface
B. Menu Interface
C. Speech and Sound Interface
D. Command Line Interface
E. Gesture Interface
2. Which interface uses the least processing power?
A. Command Line Interface
B. Menu Interface
C. Graphical User Interface
D. Touch Sensitive Interface
E. Gesture Interface
3. Which user interface allows you to control things such as the lights or switching the car radio station with just your voice?
A. Speech and Sound Interface
B. Menu Interface
C. Graphical User Interface
D. Gesture Interface
E. Command Line Interface
4. Which user interface is otherwise known as a WIMP interface?
A. Graphical User Interface
B. Menu Interface
C. Gesture Interface
D. Speech and Sound Interface
E. Command Line Interface
5. Which user interface requires a detailed knowledge of the commands?
A. Command Line Interface
B. Menu Interface
C. Graphical User Interface
D. Speech and Sound Interface
E. Gesture Interface
6. Which interface uses the most processing power?
A. Graphical User Interface
B. Menu Interface
C. Speech and Sound Interface
D. Command Line Interface
E. Voice User Interface
7. Which interface provides a series of step-by step options from which the user can select their choice?
A. Menu Interface
B. Graphical User Interface
C. Speech and Sound Interface
D. Gesture Interface
E. Command Line Interface
8. Which user interface provides the benefits of WYSIWYG?
A. Graphical User Interface
B. Menu Interface
C. Speech and Sound Interface
D. Gesture Interface
E. Command Line Interface
9. Which user interface needs to be ‘trained’ so that it works more effectively?
A. Speech and Sound Interface
B. Menu Interface
C. Graphical User Interface
D. WIMP
E. Command Line Interface
10. Which user interface is often used when you make a call and are directed to a telephone queuing system?
A. Menu Interface
B. Graphical User Interface
|
|
|
C. Speech and Sound Interface
D. Gesture Interface
E. Command Line Interface
11. What is Human Computer Interaction (HCI)?
A. the study of how people interact with computers and to what extent computers are or are not developed for successful interaction with human beings.
B. Visual part of computer application or operating system through which a user interacts with a computer or software.
C. It determines how commands are given to the computer or the program and how information is displayed on the screen.
D. requests from a growing subset of users for easy-to-use devices
E. a set of criteria such as efficiency, safety, and utility, which are related mainly to computer systems.
12. What is User Interface?
A. Visual part of computer application or operating system through which a user interacts with a computer or software.
B. the study of how people interact with computers and to what extent computers are or are not developed for successful interaction with human beings.
C. MS Windows 10 Pro
D. requests from a growing subset of users for easy-to-use devices
E. a set of criteria such as efficiency, safety, and utility, which are related mainly to computer systems.
13. What is Usability?
A. the extent to which a product can be used by specified users to achieve specified goals with effectiveness, efficiency, and satisfaction in a specified context of use.
B. the study of how people interact with computers and to what extent computers are or are not developed for successful interaction with human beings.
C. Visual part of computer application or operating system through which a user interacts with a computer or software.
D. It determines how commands are given to the computer or the program and how information is displayed on the screen.
E. MS Windows 10 Pro
14. Requests from a growing subset of users for easy-to-use devices can be called
A. Usability
B. Usefulness
C. Utility
D. Helpfulness
E. Uselessness
15. Designers and developers paid attention to making hardware and software products usable or
A. User-friendly
B. Needless
C. No use
D. Unhelpful
E. Useless
|
|
|
16. Graphical user interfaces which accept input in a form of hand gestures.
A. Gesture interfaces
B. Speech and Sound Interfaces
C. Menu Interfaces
D. Command Line Interfaces
E. WIMP
17. Graphical user interfaces which monitor the user's body motions and translate them into commands.
A. Motion tracking interfaces
B. Speech and Sound Interfaces
C. Menu Interfaces
D. Command Line Interfaces
E. WIMP
18. Graphical user interfaces using a touchpad or touchscreen display as a combined input and output device.
A. Touch user interfaces
B. Speech and Sound Interfaces
C. Menu Interfaces
D. Command Line Interfaces
E. WIMP
19. The main features of such interfaces are that keyboards are used to type in a variety of different commands into a command prompt.
A. Command Line Interfaces
B. Touch user interfaces
C. Speech and Sound Interfaces
D. Menu Interfaces
E. Motion tracking interfaces
20. GUI operating systems were first created by
A. Xerox
B. Microsoft
C. Intel
D. Panasonic
E. Samsung
21. They are normally either pop-up or drop-down in style and usually disappear when not in use.
A. Menus
B. Icons
C. Pointers
D. Windows
E. Arrows
22. Their shape can sometimes change depending on the application you are using at the time.
A. Pointers
B. Menus
C. Icons
D. Windows
E. Tables
23. They divide the screen into areas so you can work on several tasks at the same time.
A. Pointers
B. Menus
C. Icons
D. Windows
E. Tables
24. Small images or symbols that represent files, folders, shortcuts, commands or windows.
A. Icons
B. Pointers
C. Menus
D. Buttons
E. Tables
25. Type of the interface that allows people to use their fingers to select icons and options straight from the device's screen.
A. Post-WIMP
B. Menu Interface
C. Speech and Sound Interface
D. Gesture Interface
E. Command Line Interface
26. This is where you pinch your fingers together across a touchscreen to zoom into an image, application or document on your device.
A. Pinching
B. Rotating
C. Swiping
D. Grabbing
E. Dragging
27. This is where you swipe your finger across the touchscreen to scroll through a document or turn the page.
|
|
|
A. Swiping
B. Pinching
C. Rotating
D. Grabbing
E. Dragging
28. This is where you use two fingers - one finger moves up while the other finger moves down the touch screen to rotate an object.
A. Rotating
B. Swiping
C. Pinching
D. Grabbing
E. Dragging
29. WIMP stands for
A. Windows, Icons, Menus, Pointers
B. Windows, Icons, Manuals, Pointers
C. Windows, Identificators, Menus, Pointers
D. Windows, Icons, Menus, Pictures
E. Windows, Icons, Mice, Pointers
30. WYSIWYG stands for
A. What you see is what you get
B. What you sing is what you get
C. What you spell is what you get
D. What you say is what you get
E. What you seek is what you get
Database Systems.
1. Database is …
A. a systematic collection of data.
B. a collection of facts, such as numbers, words, measurements, observations or even just descriptions of things.
C. A set of facts, related to any object in consideration.
D. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
E. A type of Hardware
2. DBMS is …
A. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
B. a systematic collection of data.
C. a collection of facts, such as numbers, words, measurements, observations or even just descriptions of things.
D. A set of facts, related to any object in consideration.
E. A type of Hardware
3. Data is…
1. A set of facts, related to any object in consideration.
2. a systematic collection of data.
3. A type of computer Software
4. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
5. A type of computer Hardware
4. Examples of DBMS:
A. Access, Oracle, My SQL
B. Word, Excel, Access
C. PowerPoint, Excel, Access
D. Access, Publisher, My SQL
E. Word, Oracle, My SQL
5. A tool of DBMS that allows user to extract information that meets certain criteria…
A. Query
|
|
|
B. Table
C. Form
D. Report
E. Record
6. Formatted summaries of data suitable for printing are …
A. Report
B. Query
C. Table
D. Form
E. Record
7. What objects of Access are used for entering, modifying, and viewing records?
A. Form
B. Query
C. Table
D. Report
E. Record
8. Subject-based lists that contain data arranged in records.
A. Table
B. Form
C. Query
D. Report
E. Tuple
9. Set of rows(tuples)
A. Table
B. Form
C. Query
D. Report
E. Record
10. Subject-based lists that contain data arranged in records.
A. Relation
B. Form
C. Query
D. Report
E. Tuple
11. The item labeled ‘1’ is
A. A Record
B. A Field
C. A Field value
D. A Column
E. An Attribute
12. The item labeled ‘2’ is
A. A Field
B. A Record
C. A Field value
D. A Row
E. A Tuple
13. The item labeled ‘3’ is
A. A Field value
B. A Record
C. A Field
D. A Column
E. An Attribute
16.The number of rows in DBS table
A. Cardinality
B. Record
C. Field
D. Column
E. Attribute
17.The number of columns in DBS table
A. Degree
B. Record
C. Field
D. Column
E. Attribute
18. A special relational database table field (or combination of fields) designated to uniquely identify all table records is …
A. A Primary Key
B. A Foreign Key
C. A Field Value
D. A Special Record
E. A Primary Field
19. Such key contains values that correspond to values in the primary key of another table.
A. A Foreign Key
B. A Primary Key
C. A Field Value
D. A Special Record
E. A Primary Field
20. Find degree of the relation Customers
A. 4
B. 3
C. 2
D. 12
E. 16
21. Find cardinality of the relation Customers
A. 3
B. 4
C. 2
D. 12
E. 16
22. Which record number would appear first when the data is sorted in ascending order on Last Name?
A. 3
B. 1
C. 2
D. 4
E. 5
23. Which record number would appear first when the data is sorted in descending order on Last Name?
A. 4
B. 3
C. 1
D. 2
E. 5
24. In the database some data is displayed in a different format to the rest. This is the
A. ID
B. Company
C. First Name
D. Last Name
E. First Name and Last Name
23. Details of customers called Jones can be found in the database using
A. Last Name=Jones
B. Last Name>Jones
C. Last Name<Jones
D. First Name=Jones
E. Last Name=J
24. SQL stands for
A. Structured Query Language
B. Structured Questions Language
C. Structured Queue Language
D. Student Query Language
E. School Query Language
25. A data model in which the data is organized into a tree-like structure, implying a single parent for each record.
A. Hierarchical
B. Network
C. Relational
D. Object Oriented Data
E. Document
26. In such a database the data and relations between them are organized in tables. A table is a collection of records and each record in a table contains the same fields.
A. Relational
B. Hierarchical
C. Network
D. Object Oriented Data
E. Document
27. A network database model is a database model that allows multiple records to be linked to the same owner file.
A. Network
B. Relational
C. Hierarchical
D. Object Oriented Data
E. Document
28. What data type can you use entering text information?
A. Text
B. Hyperlink
C. Number
D. Data/Time
E. AutoNumber
29. Data type that is used to let Access generate unique numeric values for you.
A. AutoNumber
B. Text
C. Hyperlink
D. Number
E. Data/Time
30. Data type is used to store date values, time values, or combined date and time values.
A. Data/Time
B. AutoNumber
C. Text
D. Hyperlink
E. Number
Data analysis. Data management.
1. Data Analysis is
A. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
B. the presentation of data in a pictorial or graphical format.
C. online data mining and data visualization solution.
D. visual reporting, tree maps, correlation analysis, decision trees, association rules, self organizing maps.
E. open-source and free visualization and exploration software for all kinds of graph and networks.
2. Data Mining is
A. A Sifting through very large amounts of data for useful information.
B. the presentation of data in a pictorial or graphical format.
C. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
D. visual reporting, tree maps, correlation analysis, decision trees, association rules, self organizing maps.
E. open-source and free visualization and exploration software for all kinds of graph and networks.
3. Data Visualization is
A. The presentation of data in a pictorial or graphical format.
B. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
C. An online data mining solution.
D. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
E. a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data.
4. A Spreadsheet refers to
A. a file made of rows and columns that helps sort data, arrange data easily, and calculate numerical data.
B. The presentation of data in a pictorial or graphical format.
C. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
D. An online data mining solution.
E. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
5. Examples of spreadsheet programs:
A. Google Sheets, LibreOffice, Lotus 1-2-3, Microsoft Excel
B. Microsoft Access, Microsoft Word, Microsoft Excel
C. Google Sheets, Microsoft Access, Microsoft Word
D. Google Sheets, Microsoft Power Point, OpenOffice -> Calc
E. OpenOffice -> Calc, Microsoft Power Point, Microsoft Word
6. A worksheet is
A. a collection of cells
B. a chart
C. a row
D. a column
E. a graph
7. A cell is
A. The point where a column and a row intersect
B. a chart
C. a row
D. a column
E. a graph
8. The Active Cell is
A. the cell which you have currently selected.
B. a chart
C. a row
D. a column
E. a graph
9. The Active Cell
A. has a darker outline around it
B. is painted gray
C. is shaded black
D. is colored yellow
E. has a green outline around it
10. Each cell has a unique address. This address is known as
A. the ‘Cell Reference’
B. The numbers
C. The letters
D. The ’Cell position’
E. The ’Cell location’
11. The Cell with a darker outline around
A. The Active Cell
B. The Dynamic Cell
C. The Inactive Cell
D. The Moving Cell
E. The Energetic Cell
12. The cell reference comes from
A. the Column Letter followed by the Row Number.
B. the Row Number followed by the Column Letter.
C. the Column Number followed by the Row Letter.
D. the Row Letter followed by the Column Number.
E. the Column Letter followed by the Row Letter.
13. An example of a cell reference:
A. H800
B. 8H
C. 800B
D. AC
E. 234N
14. Decide which sentence is true.
A. Spreadsheet programs can generate a variety of charts and graphs.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
15. Decide which sentence is true.
A. You can change the width of columns.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
16. Decide which sentence is true.
A. Spreadsheet can be used as databases.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
17. Decide which sentence is true.
A. In a spreadsheet you can enter text.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
18. Decide which sentence is true.
A. You can change the height of rows.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
19. Decide which sentence is true.
A. You can change the width of columns.
B. You cannot change the height of rows.
C. In a spreadsheet you can only enter numbers and formulae.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
20. Decide which sentence is true.
A. You can change the width of columns.
B. You cannot change the height of rows.
C. In a spreadsheet you can only enter functions that add, subtract, multiply or divide.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
21. Decide which sentence is true.
A. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
B. You cannot change the width of columns.
C. You cannot change the height of rows.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
22. Decide which sentence is true.
A. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
B. You cannot change the name of sheets.
C. You cannot change the height of rows.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
23. Decide which sentence is true.
A. Spreadsheet can be used as databases.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the number of sheets.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
24. Decide which sentence is true.
A. A formula always starts with an = sign
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the number of sheets.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
25. Decide which sentence is false.
A. In a spreadsheet you can only enter numbers and formulae.
B. A formula always starts with an = sign
C. You can change the number of sheets.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
26. Decide which sentence is false.
A. Spreadsheet programs cannot generate charts.
B. Spreadsheet programs can generate a variety of charts and graphs.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
27. Decide which sentence is false.
A. In a spreadsheet you can only enter numbers and formulae.
B. You can change the width of columns.
C. You can change the height of rows.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
28. Decide which sentence is false.
A. You cannot change the width of columns.
B. Spreadsheet can be used as databases.
C. In a spreadsheet you can enter numbers and formulae.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs cannot generate charts.
29. Decide which sentence is false.
A. Spreadsheets can be used as databases.
B. In a spreadsheet you can enter text.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheet programs can generate graphs.
30. Decide which sentence is false.
A. Spreadsheet programs cannot generate charts.
B. You can change the height of rows.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
31. Decide which sentence is false.
A. You cannot change the height of rows.
B. You can change the width of columns.
C. In a spreadsheet you can enter numbers and formulae.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
32. Decide which sentence is false.
A. In a spreadsheet you can only enter functions that add, subtract, multiply or divide.
B. You can change the width of columns.
C. You can change the height of rows.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
33. Decide which sentence is false.
A. You cannot change the number alignment.
B. Spreadsheet programs can generate a variety of charts and graphs.
C. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
34. Decide which sentence is false.
A. You cannot choose a font in a spreadsheet.
B. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
C. You can change the name of sheets.
D. Spreadsheets can be used as databases.
E. Spreadsheets programs can generate charts.
35. Decide which sentence is false.
A. The formula is always visible in the cell.
B. In a spreadsheet you can enter numbers and formulae.
C. You can change the number of sheets.
D. The formula can be seen in the formula bar.
E. Spreadsheet programs can generate charts.
Дата добавления: 2018-05-13; просмотров: 1168; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!