Font size
WorksheetsModule 1: Introduction to Information Systems
Total questions: 90
Worksheet time: 45mins
The raw facts and figures which are processed into information are called:
Information
Knowledge
Data
System
Which of the following best describes an Information System?
Collection of people only
Collection of data only
Combination of people, processes, hardware, software, and data
Only software and hardware
Which is NOT an element of a system?
Input
Output
Environment
Feedback
A closed system is characterized by:
Continuous interaction with environment
No interaction with the environment
Being an open system
Adaptive behavior
Conversion mode where both old and new systems run in parallel is:
Direct
Phased
Parallel
Pilot
Which system supports day-to-day routine transactions?
DSS
MIS
TPS
KMS
A Decision Support System (DSS) is used for:
Routine processing
Semi-structured decision making
Document storage
Employee attendance
Knowledge Management Systems (KMS) mainly focus on:
Capturing, storing, and sharing organizational knowledge
Transaction records
Accounting data
Hardware management
A system that supports plant operations and process automation is:
(a)
Which IS helps in group collaboration and communication?
TPS
MIS
ECS
DSS
The AI system that mimics human brain functions is:
Fuzzy logic
Neural networks
Expert system
Virtual reality
Which AI technology deals with uncertainty?
Neural networks
Fuzzy logic
Virtual reality
EIS
Which is an example of an expert system?
Google Docs
MYCIN (medical diagnosis system)
MIS
An EIS (Executive Information System) is designed for:
Routine operations
Middle managers
Top-level executives
Clerks
Strategic Information Systems (SIS) are designed to:
Process transactions
Store data only
Provide competitive advantage
Generate bills
MIS primarily supports:
Clerical work
Managerial decision-making
Only routine tasks
Data storage
MIS is characterized by:
Which is a component of MIS?
Hardware
Software
Database
All of the above
Which is not a function of MIS?
Planning
Organizing
Recruitment
Control
MIS implementation begins with:
System testing
Need analysis and planning
Report generation
Documentation
Which is an application of MIS?
Payroll systems
Inventory control
Sales analysis
All of the above
MIS within an organization evolves as:
One-time project
Continuous process
Manual system only
Single report
A system approach in MIS includes:
Input, process, output
Feedback
Control mechanism
All of the above
Which is NOT a reason for MIS failure?
Poor planning
Lack of user training
Inadequate resources
Proper user involvement
DBMS stands for:
Database Monitoring System
Database Management System
Data Business Management Software
None
A key component of DBMS is:
Tables
Queries
Reports
All of the above
One major objective of DBMS is:
Data duplication
Data redundancy
Data integrity
Data deletion
RDBMS stands for:
Relational Database Management System
Relational Database Management System
Regional Data Model System
None
A trend in DBMS is:
Cloud databases
Big Data analytics
NoSQL systems
All of the above
A transaction in DBMS should follow:
BCP rules
ACID properties
MIS rules
SIS rules
Module 3: IS Analysis & Design 1. BPR stands for:
Business Process Reporting
Business Process Reengineering
Business Product Research
Business Planning Resource
An IS that breaks business barriers is used for:
Integration of processes
Limiting access
Only sales data
Financial audits
SDLC stands for:
System Document Life Cycle
System Development Life Cycle
Software Data Life Cycle
None
First stage of SDLC is:
Design
Testing
Planning/Requirement Analysis
Implementation
A structured SAD tool is:
Bar chart
DFD (Data Flow Diagram)
Histogram
Scatter plot
A context diagram shows:
Process details
System scope and external entities
Testing results
Conversion methods
A decision table is used for:
Storing data
Representing conditional logic
Ranking tasks
Documentation
The waterfall model is:
Iterative
Sequential
Spiral
Prototype
Prototype model is best for:
User feedback and evolving requirements
Stable requirements
Long-term fixed design
Legacy systems
Spiral model combines:
Agile + Waterfall
Iterative development + Risk analysis
Testing + Coding
Data + Documentation
System testing is performed to:
Debug code only
Check overall system performance
Install hardware
Maintain documentation
Documentation tools are mainly for:
System security
User understanding and maintenance
Conversion method where the old system is completely stopped and new one is started:
Direct cut-over
Parallel
Phased
Pilot
ERP integrates:
Finance
HR
Supply chain
All of the above
Data mining is mainly used for:
Data redundancy
Data deletion
Discovering hidden patterns in data
Data compression
Which is a feature of E-commerce?
Face-to-face trading
Buying and selling over internet
Manual billing
Offline networking
Which is not an advantage of E-commerce?
24/7 availability
Wider reach
High initial infrastructure cost
Convenience
E-commerce compared to traditional commerce is:
Slower
Faster and more flexible
Manual
Regional only
A major disadvantage of E-commerce is:
Convenience
Security risks
Global access
Cost reduction
Technology adoption refers to:
Old systems only
Acceptance and use of new technologies
Diffusion of innovation explains:
How innovations spread among users
Internet speed
Server downtime
None
A factor in technology absorption is:
Training
Infrastructure
User support
All of the above
An example of an electronic payment system is:
Cheques
UPI
Cash on delivery
Physical vouchers
An issue in implementing E-commerce is:
Customer trust
Logistics
Security
All of the above
E-security refers to:
Protecting online transactions and data
Manual locks
Physical files
None
Government initiative supporting digital commerce:
Digital India
Green India
Swachh Bharat
None
A key challenge in e-banking is:
Customer trust
Fraudulent transactions
Server speed
All of the above
Which is a benefit of E-commerce for businesses?
Limited reach
Lower operational costs
Higher manual effort
Reduced sales
M-Commerce means:
Manual commerce
Mobile commerce
Modern commerce
None
A buyer-seller online platform is:
MIS
ERP
E-marketplace
TPS
Module 5: Ethics in IT 1. Business ethics relates to:
Hardware only
Moral principles in business activities
Legal contracts only
Financial planning
Technology ethics focuses on:
Machine speed
Responsible use of technology
Profit-making
Employee salary
Environmental impact analysis includes:
Pollution
E-waste
Energy use
All of the above
Cybercrime includes:
Hacking
Identity theft
Unauthorized access
All of the above
Module 5: Ethics in IT 5. Unauthorized use of office internet is an example of:
Business ethics
Technology misuse
ERP issue
None
Module 5: Ethics in IT 6. Intellectual property includes:
Patents
Trademarks
Software licenses
All of the above
Internet privacy issues are related to:
Cookies
Data harvesting
User consent
All of the above
Cloud computing ethics involves:
Data ownership, privacy, and security
Offline work
Physical servers only
None
IoT raises ethical concerns about:
Device costs
Surveillance and data privacy
Manual operations
None
M-Commerce challenges include:
Payment security
Privacy issues
Fraud risk
All of the above
Ergonomics in IT is concerned with:
Office furniture only
Human comfort and health in using IT systems
Cloud computing
None
Cyber terrorism targets:
Individuals only
Critical infrastructures and organizations
Entertainment industry
None
Software piracy is an example of:
Innovation
Intellectual property violation
ERP issue
MIS
Which act governs IT law in India?
Companies Act
IT Act 2000
Contract Act
None
Which is an ethical responsibility of IT professionals?
Misusing data
Protecting confidentiality of information
MS Word is used for:
Calculations
Word processing
Presentations
Databases
Shortcut for copy in Word:
Ctrl+Z
Ctrl+X
Ctrl+C
Ctrl+V
In MS Excel, a cell reference A1 is:
Relative
Absolute
Relative
Mixed
The symbol for formulas in Excel starts with:
-
/
=
+
Which is not a chart type in Excel?
Pie
Column
Cylinder (non-standard)
Bar
In PowerPoint, slide sorter view is used for:
Editing text
Managing slide order
Printing slides
Adding notes
MS Access is used for:
Word processing
Presentations
Database management
Graphic design
To create a questionnaire in Word, you mainly use:
Headers
Forms and tables
Google Docs is an example of:
Offline software
Cloud-based word processor
DBMS
ERP
Google Sheets is equivalent to:
Word
PowerPoint
Excel
Access
In Excel, AutoSum is used for:
Formatting text
Adding a range quickly
Spell check
Sorting
In Access, a query is used to:
Enter data
Retrieve and filter data
Design reports
None
IP Address is:
Internet Program
Unique identifier for a device on a network
Web protocol
Password
MS PowerPoint allows inserting:
Tables
Charts
Audio/Video
All of the above
Which function in Excel finds the average?
MAX()
SUM()
AVERAGE()
COUNT()
