MCC - CIS105 - Study Guide for Test 3
Completion of the study guide is NOT required, so it will not be turned in or submitted electronically. However, completing the study guide will help students prepare for the exam. In addition, the completed study guide may be used on the actual exam, because exams are open book and notes. If you can't find the answer to any of the questions, please feel free to ask your classmates and/or instructor.
Chapter 10
System
Analysis
Design
User
Systems Analyst:
The role and skills required to be effective
The number of and names of each SDLC phase may
vary by author and software development company.
Alternative names are shown in parenthesis.
1. Preliminary Investigation Phase (Planning Phase)
Feasibility study (Assessment study)
List the sections of a feasibility study report
2. Analysis Phase (Detailed Analysis Phase)
Data gathering techniques
Data analysis
System Requirements
Report to management
3. Design Phase
Preliminary Design
Build-or-buy decision
Detailed Design
Computer-aided software engineering (CASE)
4. Development phase
Scheduling
Programming
Project Management
Testing types
5. Implementation phase
Training
Evaluation
Maintenance
Conversion Methods (list and define)
Chapter 11
File Management System
Sequential file organization
Random access
Direct file organization
Indexed file organization
DBMS
RDBMS
Database
Table
Query
Form
Report
Hierarchy of data
File
Table
Record
Field
Character
ERD
Primary key
Foreign key
Index
Data redundancy
Data management
Data integrity
Data validation
Data maintenance
SQL
Database Query
Wildcard
Mail Merge
DBMS key features
Data dictionary
What is it and what is stored in it?
Database Administrator (DBA) roles
Operational System / Transaction Processing System
Management Information System
Decision Support System
Executive Information System
Chapter 10
Program
Programming
Programming Language
Programmer's responsibilities
Program Development Life Cycle (PDLC) Phases
Algorithm
Flowchart
List four flow control structures
Pseudocode
Desk-checking
Syntax error
Logic error
Debugging
Debug utility
Quality Assurance
Procedural Programming
Event Programming
Object-Oriented Programming
Class
Property
Method
Object
Inheritance
Interpreter
Compiler
Client-side web scripts
Server-side web scripts
Various Chapters (See course schedule for assigned reading)
Digital Divide
Green computing
Methods of managing power consumption
Ergonomics
RSI
Carpal Tunnel Syndrome
Ethics
Computer ethics
ACM
Ten Commandments of Computer Ethics
Intellectual Property rights
Copyright
Fair use provision
Encryption
Plagiarism
Patents
Trademarks
Virus
Worm
Trojan horse
Spyware
Adware
Virus Protection
Virus Definition (signature)
Spyware and adware removal programs
Firewall
Surge protector
Uninterruptible power supply (UPS)
Computer forensics
The four major components of a disaster recovery plan
Full backup
Differential backup
Incremental backup
Restoration
List ways of controlling access
Biometrics
Access
Difference between AND and OR in a query
Difference between a table's design view and datasheet view
Difference between a datasheet view and form view
Revised: 09/30/2009 - www.mc.maricopa.edu/~marquez/cis105/study_guide03.html