| Terms |
Definitions |
|
spread
|
dispersion
|
|
variance
|
standard deviation
|
|
outlier
|
extreme value
|
|
workbooks
|
worksheets in Excel
|
|
range
|
highest value-lowest value
|
|
C++
|
Incorporates object-oriented features
|
|
Advantages:-Fast (11 Mbps)-Reliable-Long range-Integrates with existing networks
|
Backbones
|
|
boxplot
|
provides graphical representation based on s-number summary
|
|
Application sharing
|
Sharing information resources
|
|
Interact with users
|
Troubleshoot problems
|
|
All primary keys must be
|
indexed
|
|
Numerical(quantitative) Variable
|
variables that represent quantities
|
|
Programming language structure
|
Advanced computer graphics
|
|
Disadvantages:-Delays in receiving packets-Not ideal for real-time voice communication
|
Transaction Acquisition
|
|
Structure charts
|
show the top-down design
|
|
Computers transform data into information
|
RAM
|
|
Inequity –
|
examines a mathematical relationship such as:
|
|
Average
|
def - Calculates the arithmetic mean – the mean obtained by adding several quantities together and dividing the sum by the number of quantities. It ignores null values.
ex - The average cost of a three-bedroom house in Tulsa.
|
|
Design view
|
1. displays the infrastructure of a table, form, or report without displaying the data
|
|
Form
|
1. an interface that enables you to enter or modify record data
|
|
Report
|
1. a printed document that displays information professionally form a database
|
|
Summary Table
|
Indicates frequency, amount, or percentage of items in a set of categories so that you can see the difference
|
|
Qthree
|
smallest 75% from the larger 25%
|
|
topology
|
The physical layout of a LAN
|
|
Prereq for best jobs
|
A Bachelorâs degree
|
|
Loss of productivity
|
Local Area Networks (LANs)
|
|
Mainframes
|
handle gigantic processing jobs for large corporations or agencies, such as payroll.
|
|
Information Processing Cycle
|
Input, Processing, Output, Storage
|
|
Define Middleware.
|
BA interactive software tools that allow users to access the data warehouse and create on-demand (ad-hoc) reports and queries and to conduct analysis of data.
|
|
OLE
|
contains an object created by another application. Example: Excel workbook
|
|
Hyperlink
|
stores a Web address (URL). Example: www.lsu.edu
|
|
continuous variable
|
produce numerical responses that arise from a measuring process
|
|
arithmetic mean
|
most common measure of central tendency. average
|
|
variation
|
amount of dispersion away from central value
|
|
Workstations can only transmit data when they possess a token
|
Star Topology
|
|
Programming languages
|
artificial languages created to tell the computer what to do.
|
|
LAN Technologies
|
Ethernet â most popular LAN standard for large and small business
|
|
Supercomputers
|
are ultra-fast and handle huge amounts of scientific data.
|
|
Modulation protocols
|
are communications standards to which modems conform.
|
|
Systems Programmer/Administrator
|
Installs, maintains, and supports the operating system
|
|
Sort (ascending or descending)
|
1. ascending) provides an alphabetical list of text data or a small-to-large list of numeric data. (Descending) arranges the records with the highest value listed first
|
|
Autonumber
|
is a special data type that Access used to assign the next consecutive number each time you add a record. Example: customer account number
|
|
Row
|
the source field that you assign to group data horizontally in a crosstab query
|
|
Relational database software
|
1. a computer application, such as Microsoft Access, that is used to store data and convert it into information
|
|
Population is
|
all items, sample is out of population
|
|
Categorical(qualitative) Variable
|
variables that have values that can only be placed into categories ("yes/no")
|
|
inferential statistics
|
uses data collected from smaller group to draw conclusions about a larger group
|
|
secondary source
|
variables that aren't studied by data collector
|
|
Certification benefits
|
Enable employers to assess skills from a pool of applicants
|
|
A simplified version of C++
|
Hypertext markup language (HTML)
|
|
Specs define: -Input data-Processing-Output-Appearance of user interface
|
Phase 2: Designing the Program
|
|
a program that changes source code to object code.
|
interpreter
|
|
would be the ultimate nonprocedural language.
|
Object-Oriented Programming (OOP)
|
|
Describe BPM and its objective.
|
BPM- Business Performance Management uses balanced scorecard methodology to link objectives with factual measures. in the process, an enterprise must define, implement, and manage their business strategies. the objective of BPM is to optimize the overall performance of an organization.
|
|
Calculated detail field
|
the portion of a PivotTable or PivotChart that generates a new field and performs the stipulated calculation on all of the detail records
|
|
Record
|
1. a complete set of all of the data about one person, place, event, or idea; All the fields on my class roster about one student.
|
|
Drill button
|
the plus or minus sign that enables you to show or collapse details in a PivotTable
|
|
Filter by selection
|
selects only the records that match the pre-selected criteria
|
|
Bubble Charts
|
a variation of a scatter chart to show how sets of things compare according to various factors. The sizes of the bubbles show the relative size of the data being plotted.
i. Example: Salaries by job title with the size of the bubble representing the percentage of the total salary budget.
|
|
Line Charts
|
chart that plots data points which are continuously distributed data to compare trends over time. Place time measurements on the X axis.
|
|
coefficient of variation
|
relative measure of variation that is always expressed as a precentage
|
|
Sample Mean
|
sum of values diveded by number of values
.
|
|
protocol suite
|
is the total package of protocols that specify how a network functions.
|
|
Microsoft Certified Systems Engineer (MCSE) + Internet
|
Microsoft Certified Solution Developer (MCSD)
|
|
used to write short programs (scripts) that are embedded in Web pages
|
JavaScript
|
|
Asynchronous Transfer Mode (ATM)
|
New protocols designed for digital lines and faster data transfer rates
|
|
are units of information that contain data as well as methods that process and manipulate data.
|
Classes of objects
|
|
What is Data-mining?
|
A set of data analyses and statistical methodologies that look for hidden patterns in data which can be used for predicting future behavior. can handle massive amounts of data.
|
|
Define dashboard and know its purpose.
|
Dashboards provide a comprehensive, at-a-glance view of corporate perfomance/health through visualization graphics (like the instruments in your car). The dashboards contain key performance indicators, trends, and outliers for different aspects of the business operations.
|
|
1. Practicing good file management in Access:
|
a. Avoid damaging data by copying data and renaming the file.
b. Access speed –the amount of time it takes for the storage device to make the file content available for use
c. Access runs best from a hard drive or network drive because those drives have sufficient access speed to support the software.
|
|
Sample Standard Deviation
|
where are the observed values of the sample items and is the mean value of these observations. This correction (the use of N − 1 instead of N) is known as Bessel's correction. The reason for this correction is that s2 is an unbiased estimator for the variance σ2 of the underlying population, if that variance exists and the sample values are drawn independently with replacement. However, s is not an unbiased estimator for the standard deviation σ; it tends to underestimate the population standard deviation.
The term standard deviation of the sample is used for the uncorrected estimator (using N) while the term sample standard deviation is used for the corrected estimator (using N − 1). The denominator N − 1 is the number of degrees of freedom in the vector of residuals, .
|
|
Fastest growing industries in US economy:
|
-Network systems and data communications analysts (#1)-Computer software engineers (#4)-Computer systems analyst-Database administrators
|
|
Called a daisy chain
|
Every workstation is connected to a single cable
|
|
Networking â Skills related to Ethernet, TCP/IP, and LAN administration
|
Microsoft Windows XP â Integration of .NET Passport with Windows XP
|
|
high-capacity transmission lines, can be regional, continental, or transcontinental.
|
Internet backbones can carry 2.5 gigabits of data per second.
|
|
What is real-time BI? Examples?
|
Instant data lookup. Examples: Debit/credit cards being declined, checking out at a store (places order for another copy of item because inventory is subtracted by one).
|
|
Describe the responsibilities of the BICC.
|
a. Strategies and objectives are properly aligned with the reasons for DW and BI.b. IT department can implement hardware and software capable of implementing the objectives.c. User community is aware of initiatives and are motivated for operationalizing initiatives.
|
|
Because the database files tend to rather large to start with,
|
a. any growth creates problems.
|
|
Information technology (IT) professionals:
|
Work with IT in all its various formsAre needed by both small and large companiesKeep up with fast-changing technology
|
|
How did DirecTV use BI?
|
They were concerned about CHURN RATE. Which is, for any given period of time, the number of participants who discontinues their use of a service divided by the total number of participants. (Drop rate)Problem: Reduce churn rate, high volume of calls, needed a better response.Solution: Save Team contract customers who wanted to cancel within 3 hours to try to convince them to stay. Centrally managed DW updated in real time.Results: 25% of customers who called to cancel decided to keep their service.
|
|
What is a Data Warehouse (DW)?
|
A special database or repository of historical and current data that has been collected and is of potential interest to decision-makers throughout an organization. DWs are created by the technical staff.
|
|
All databases have a tendency to expand with use. This expansion will occur whenever the database is being used, such as
|
a. when new information is added, the database is being viewed, queries are created or run, or filters are applied and removed.
|
|
An appropriate programming language is chosen, and the code is typed according to its syntax rules.
|
Phase 4: Testing and Debugging the Program
|
|
Oracle â Experience in working with Oracle database and client/server applications
|
C++ â Language of choice for software development
|
|
What is a Decision Support System (DSS)?
|
A conceptual framework for a process of supporting managerial decision making usually by modeling problems and employing quantitative models for solutions analysis.
|
|
Network access is controlled by a network administrator.
|
Users can access software, data, and peripherals.
|
|
Filter field (Filter drop zone) –
|
the data field that you use to create criteria to filter data in a PivotTable
|
|
translates source code one line at a time and executes the instructions.
|
Spaghetti Code and the Great Software Crisis
|
|
Compact and Repair Database Utility
|
i. Acts like a disk defragmenter utility. It finds related file sectors and reassembles them in one location if they become scattered from database use.
ii. You should compact and repair your database each day when you close the file.
iii. This step often will decrease the file size by _50% or more_.
|
