NEW
Font size
WorksheetsRevision BIS Intake 14
Total questions: 20
Worksheet time: 10mins
i) …………… is an example of Data Cleaning and ii) …………… is a form of Data Transformation.
i) Change text to lower/upper/proper case, ii) merging rows and columns
i) Transpose, ii) spelling check
i) Remove extra spaces, ii) highlighting errors
i) Transpose, ii) splitting rows and columns
Customer Relationship Management is
Also known as Supply Chain Management (SCM)
Also known as Enterprise Resource Planning (ERP)
Part of ERP and SCM
One of the business activities
The system is called efficient when .......
The benefits surplus the costs
The system costs more than the benefits of the system
The costs and benefits are equal
The cost is more than the benefit
…………. holds business information from many sources in the enterprise, covering all company's process, products & customers
Data Mining
Data Mart
Hadoop
Data Warehouse
Management Information Systems (MISs) include:
i. Corporate MIS
ii. Manufacturing MIS
iii. Executive MIS
iv. Accounting MIS
v. Human Resource MIS
i, ii, iv and v are correct
iv and v are correct
i, iii and iv are incorrect
All are correct
Which of the following is correct?
Decision to Extract, Load and Transform
Export, Transform and Load
Transform, Load and Analyze
Extract, Transform, Load and Decision
System Design consists of three activities: Data Design, Program Design and ........
Files and Database Design
Inputs Design
Interface Design
Outputs Design
An example of an input design is (i) …………… whilst (ii)…………… is an example of an output design.
(i) sign up form; (ii) homepage
(i) sign up page; (ii) log in page
(i) order form; (ii) log in page
(i) order form; (ii) order receipt
Systems Testing is vital in any systems development because
it ensures the success of the project
it helps to spot mistakes made by the programmers
it helps to minimize bugs and errors
to ensure it processes the right data & produces correct outputs
Review procedures include i) ....... and ii) .......
i) Slipstream, ii) Release
i) New Version, ii) Slipstream & Release
i) Event Driven, ii) Time Driven
None of the above
Which of the following is incorrect?
R-Studio and Tableau are both Data Visualization tools
Power BI, Domo, Zoho Reports are examples of Data Visualization
Color Sensor and Gas Sensor are examples of data collection tools
Open Refine, Python, MS Excel are examples of Data Transformation
The following shows an example of
Data flow diagram
Data dictionary
System Coding
Structured Query Language (SQL)
Systems Analysis has two main activities which include
Requirement Determination and Fact Analysis
Interview and Question
Fact Finding and Requirement Determination
Fact Analysis and Requirement Analysis
Systems Design consists of three activities: Data Design, Program Design and
Interface Design
Files and Database Design
Inputs Design
Outputs Design
Decision Support Systems includes
SPSS, Adobe Photoshop and R-Studio
Microsoft PowerPoint, Microsoft Project, Microsoft Excel and Adobe Photoshop
SPSS, Microsoft PowerPoint, Microsoft Project and Microsoft Excel
Microsoft PowerPoint, Microsoft Project, Microsoft Access, Adobe Photoshop
Systems Design is the third stage of SDLC which is concerned with
what is required
how the requirements are satisfied
what is required and how they are satisfied
None of the above
It is essential to get organizational structure of the company before conducting SI as it allows
to know the right people to talk to and study their work
to know the right people to talk to and observe their work attitude
to know the owner and to be interviewed
to know the right people to talk to and collect the right data from
Types of information obtainable from data mining include:
Classification, Clustering and Forecasting
Associations, Sequences, Classification, Categorization and Clustering
Associations, Sequences, Classification, Clustering and Forecasting
None of the above
In relational database model, rows represent (i) ….. whilst columns represent (ii) …..
(i) attribute, (ii) tuples
(i) records, (ii) tuples
(i) tuples, (ii) attribute
(i) fields, (ii) attribute
Beta Release and Alpha Version are examples of
Maintenance and Review Activities
Review Activity
Maintenance Activity
None of the above
