Information Technology Flashcards
Which IT personnel roles should always be segregated?
Operators
Programmers
Librarians
What does an Information System do within an Business?
Information systems process data and transactions to provide users with the information they need to plan, control and operate an organization
What are the duties of a systems analyst?
Designs or purchases IT system
Responsible for flowcharts
Liaison between Users and Programmers
Note: Think IT Manager
What is the primary duty of a Systems Administrator?
A Systems Administrator controls database access.
What are the duties of a Systems Programmer?
Writes- Updates- Maintains- & Tests software- systems- and compilers
What are the functions of an Information System?
- Collecting transaction and other data
- Entering it into the information system
- Processing the data
- Providing users with the information needed
- Controlling the process
Which duties should a Systems Programmer NOT have?
In order to maximize internal control- a Systems Programmer should NOT have application programming duties/abilities or be an Operator on the system.
What are the general types of IT Systems?
- Office automation systems - designed to improve productivity by supporting daily work of employees
- Transaction processing systems - involve the daily processing of transactions
- Management reporting systems - designed to help with the decision making process by providing access to computer data
- Executive information systems - computerized systems that are specifically designed to support executive work
What are the duties of a Systems Operator?
Schedules and Monitors Jobs
Runs IT Help Desk
What duties should a System Operator NOT have?
For internal control purposes- they should not be a Programmer on the system.
If it is not possible to segregate duties in an IT System- what actions should be taken to compensate for internal control purposes?
Include Computer Logs.
Control Group should review the logs.
What are the different Management reporting systems?
- Management information systems - systems designed to provide past, present and future information for planning, organizing and controlling the operations of the organization
- Decision support systems - computer-based information systems that combine models and data to resolve non-structured problems with extensive user involvement
- Expert systems - computer systems that apply reasoning methods to data in a specific relatively structured area to render advice or recommendations (like a human expert)
What is the purpose of a Management Information System (MIS)?
To assist with decision making.
What are the phases included in the Systems Design and Process Improvement?
- Planning phase
- Analysis phase
- Design phase
- Development phase
- Testing phase
- Implementation phase
- Maintenance phase
What is an Accounting Information System (AIS)?
A type of Management Information System (MIS) that processes accounting transactions.
What are the characteristics of an Executive Information System (EIS)?
Specialized for Company Executive needs
Assists with Strategy Only
No Decision-Making Capabilities
What are the characteristics of an Expert System (ES)?
Computer uses reasoning
Structured
No human interpretation needed
What are the characteristics of a Decision Support System (DSS)?
Computer provides data
Gives Interactive Support
Human interpretation needed
What are the characteristics of an Ad Hoc computer report?
User initiates the report.
The report is created upon demand.
When are Exception reports generated?
Exception reports are produced when Edit Tests- Check Digits- or Self-Checking Digits identify a problem
What is a query?
A type of Ad Hoc report- initiated by a user.
What is End-User Computing?
The User develops and executes their own application.
What is a Supercomputer?
A supercomputer is an extremely powerful, high-speed computer used for extremely high-volume and/or complex processing needs
What is the primary benefit of E-commerce?
E-commerce makes business transactions easier.
What are the risks of E-commerce?
Compromised data or theft.
Less paper trail for auditors.
What are the benefits of Electronic Data Interchange?
Uses globally-accepted standards
Efficient
What is a File Server?
A file server stores shared programs and documents.
What is the purpose of a Database?
Located on a File Server- a Database allows users to share documents.
What are the characteristics of the Planning phase?
Systems Design & Process Improvement
a. Identify the problem
b. Design the system to be developed
c. Determine project scoped. Develop a project plan. Evaluate the initial feasibility of the project
What is the purpose of a LAN (Local Area Network)?
It connects computers in close proximity.
What is the purpose of a WAN (Wide Area Network)?
It connects computers that are far apart.
What are the characteristics of a VAN (Value-Added Network)?
Privately-owned Network
Serves as 3rd Party Between 2 Companies
Routes EDI Transactions
Accepts wide range of Protocols
Very Costly
What is the purpose of a Firewall?
Prevents unauthorized access to a network.
What are the characteristics of a virus?
Takes over a computer
Needs a host program to run
What are the characteristics of a computer worm?
Takes over multiple computers
Doesn’t need a host program to run
What is the purpose of Automated Equipment Controls?
They prevent and detect hardware errors.
What are the characteristics of the Design phase?
Systems Design & Process Improvement
The primary goal of the design phase is to build a technical blueprint of how the proposed system will work.
Components of this phase include:
- Databases
- User interfaces for input & output
- Required reports
- Programs
- Infrastructure & controls
What is RAM?
Random Access Memory.
Internal memory in the computer used during immediate processing.
What is a CPU?
Computer Processing Unit
It processes commands within a computer.
What are the characteristics of the Development phase?
Systems Design & Process Improvement
During the development phase the documents from the design phase are transformed into the actual system. In the design phase the platform on which the system is to operate is built or purchased off-the-shelf and customized and databases are developed
What is Job Control Language?
It schedules and allocates system resources.
What are examples of input devices?
Keyboard Mouse Scanner Magnetic Ink Reader Magnetic Tape Reader EDI Point of Sale Scanner
What are examples of Output Devices?
Speakers
Monitors
Printers
What are the characteristics of Magnetic Tape storage?
Sequential Access – Sorts data in order
Slower data retrieval
Header Label prevents Operator error by loading wrong tape
External Labels prevent accidental destruction by operator
What is a Console used for?
A console is a terminal used for communication between the operator and the computer (i.e. the operator of a mainframe computer)
What are the characteristics of Magnetic Disks?
Random Access - Finds data in random spots
Faster data retrieval
Uses Boundary Protection for data
What is a Gateway?
Connects one network to another
Note: the Internet is connected by Gateways
What are Parity Checks?
A control that detects internal data errors.
A bit is added to each character- it checks to see if a bit was lost.
What is an Echo Check?
Transmitted data is returned to the sender for verification (it echoes back to the sender)
What is a Change Control?
It authorizes program changes and approves program test results.
What is security software?
Software that controls access to IT systems.
Note: Don’t confuse this with anti-virus software
What are the characteristics of the Testing phase?
Systems Design & Process Improvement
The testing phase involves verifying that the system works and meets the business requirements as set forth in the analysis phase.
The following types of tests should be performed:
- Unit testing - involves testing the units or pieces of code
- System testing - involves testing of the integration of the units or pieces of code into a system
- Integration testing - involves testing whether separate systems can work together
- User acceptance testing - determines whether the system meets the business requirements & enables users to perform their jobs efficiently & effectively
What is a Server?
A server is a high-powered micro-computer that “serve” applications and data to clients that are connected via a network
Servers typically have greater capacity than their clients (micro-computers) and often act as a central repository for organizational data
Servers today are often configured as a “virtual machine” meaning multiple operating systems can coexist and operate simultaneously on the same machineVirtual machines are appealing because they lower hardware costs and they create energy savings
What is a microcomputer?
A microcomputer (desktop computer and labtop computer) is designed to be used by one person at a time
They are often called personal computers, which are typically used for word processing, e-mail, spreadsheets, surfing the web, creating and editing graphics, playing music and gaiming
What are Controllers?
Controllers are hardware units designed to operate specific input-output units
What is a Buffer?
A buffer is a temporary storage unit used to hold data during computer operations
What does “MIPS” mean?
MIPS is characterized as millions of instructions per second, which is a unit for measuring the execution speed of computers
What is a Tablet or Smart Phone or Personal Digital Assistant?
Tablets, Smartphone, or Personal Digital assistants are typically smaller, handheld wireless devices that depend or WiFi and/or cellular technology for communication
Examples of these are: iPad, iPhone, Android, Blackberry
What is the purpose of a Digital Signature?
It confirms a message has not been altered.
What are the characteristics of the Implementation phase?
Systems Design & Process Improvement
The implementation phase involves putting the system in operations by the users. An organization may choose from a number of implementation methods including:
- Parallel implementation
- Plunge implementation
- Pilot implementation
- Phased implementation
What is a Mainframe computer?
Mainframe computers are large, powerful, high-speed computers
While these are less powerful than supercomputers, they have traditionally been used for high-volume transaction processing
List the types of computers from smallest to largest
PDA/Smartphone/Tablet
Microcomputer - PC- Laptop (cost-effective)
Minicomputer - Like a Mainframe- but smaller
Mainframe - Large computer with terminals attached
Supercomputer - Very powerful and very big
What is a Central Processing Unit (CPU)?
A central processing unit (CPU) is the principal hardware components of a computer. It contains an arithmetic/logic unit, primary memory, and a control unit
The major function of the CPU is to fetch stored instructions and data, decode the instructions, and carry out the instructions
What is the duty of a design engineer?
Determine language used for a specific computer- on a computer-to-computer basis
What are object programs?
Programs written in base computer language- not similar to English.
What is Parallel implementation?
Implementation Phase - Systems Design & Process Improvement
The parallel implementation method uses both systems until it is determined that the new system is operating properly
Advantage - this method has the advantages of a full operational test of the new system with less risk of a system disaster
Disadvantage - this method has the additional work and cost during the period in which both systems are operating
What are the characteristics of the Analysis phase?
Systems Design & Process Improvement
This phase involves teams including end users, information technology specialists, systems analysts, and process design specialists to understand the requirements for the proposed system
A needs assessment may be performed, which involves determining the requirements for the system in terms of processes, data capture, information & reporting
An analysis is performed on the existing system
A gap analysis is performed to examine the differences (gaps) between the required system and the existing system
The following are analyzed in this phase for the new system:
a. Performance levels
b. Reliability
c. Quality
d. Interfaces
e. Security & privacy
f. Constraints & limitations
g. Functional capabilities
h. Data structures & elements
How can source programs be recognized?
They are written in a language close to English.
What are the various types of storage devices?
There are 6 types of storage devices:
- Magnetic tape
- Magnetic disks
- RAID (Redundant array of independent disks
- Compact discs
- Solid State Drives (SSDs)
- Cloud-Based Storage (Storage as a Services - “SaaS”
What is the purpose of a Compiler?
Takes Source language (English) and converts to Object (Computer) Language
How does Online Analytical Processing work?
It uses a Data Warehouse to support management decision making.
What is Data Mining?
Using artificial intelligence and pattern recognition to analyze data stores within a Data Warehouse.
What is Plunge implementation?
Implementation Phase - Systems Design & Process Improvement
When an organization uses the plunge implementation method, they cease using the old system and begin using the new system immediately
This method is less costly than the parallel method but it has higher risk of a system breakdown
What is the purpose of online transaction processing?
To process a company’s routine transactions.
What are the characteristics of batch processing?
Data held- updates multiple files all at once
Leaves a better audit trail
Uses Grandfather-Father-Son backup (3 levels of backup kept in 3 locations)
What does an output control check for?
Checks to see if output data is valid- distributed and used in an authorized manner.
What does a processing control check?
Checks if data processing produced proper output
What is Pilot implementation?
Implementation Phase - Systems Design & Process Improvement
The pilot implementation method involves having a small group of individuals using the new system until it is seen to be working properly
Advantage - provides a partial operational test of the new system at a lower cost than parallel implementation
What is a hash total?
An input control number- a meaningless sum of values included in the input.
Example would be summing a list of SSNs to make sure the data is the same once entered as it was prior to input into the system.
What is a validity check?
Checks to see if data in existing tables or files belongs in the set
For example- is there a # in an alpha-only field or a letter in a numeric-only field
What is a limit check?
Checks to see if numbers surpass a certain limit- i.e. in an age field is the number greater than 110.
What is a compiler?
A compiler produces a machine language object program from a source program language
What is multiprocessing?
Multiprocessing is simultaneous execution of two or more tasks, usually by two or more CPUs that are part of the same system
What is a field check?
An input check that prevents invalid characters- i.e. checks for alphabetic letters in a SSN field
What is Phased implementation?
Implementation Phase - Systems Design & Process Improvement
The phased implementation method involves installing the system in a series of phases
What is a Source program?
A source program is a program written in a language from which statements are translated into machine language; computer programming has developed in “generations”
What is a Hot Site?
A disaster recovery system where if the main system goes down- a Hot Site is ready to take over immediately.
What are the characteristics of the Maintenance phase?
Systems Design & Process Improvement
The maintenance phase involves monitoring and supporting the new system. In this phase the organization provides on-going training, help desk resources, and a system for making authorized and tested changes to the system
What is a Cold Site?
If a main system goes down- a Cold Site will take time to get set up and running.
What is the most common database language?
SQL - Standard Query Language
What is a Data Definition Language?
Defines SQL Database
Controls SQL Tables
What is a Data Manipulation Language?
Queries SQL Database tables
What is a Data Control Language?
Controls Access to SQL Database
What are the characteristics of a Relational Database?
Logical structure
Uses rows and columns similar to spreadsheet