IT Flashcards

Question

Characteristics of Web 2.0 (8) Quiz 1

Answer 1

``` ・Continually updated services ・Consuming and remixing data ・Network effects through participation ・Ability to tap into the collective intelligence of users ・Data made in new or never-intended ways ・Relies on user-generated and user controlled data ・Lets anyone act as a website developer ・It's a work in progress ```

Answer 2

``` ・Static pages ・Author controlled content ・Computers ・Users view content ・Individual users ・Marketing goal influence ・Data from a single source ```

Answer 3

``` ・Dynamic pages ・User controlled content ・Computers, cell phones, TV, PDA, game systems, car dashboard ・Users created content ・User communities ・Marketing goal relationship ・Data from multiple sources (mashup) ```

Answer 4

・Business ・Customer ・Data

Answer 5

Different forms of applications to work together (Application Programming Interfaces – API)

Answer 6

Used as an interface by software components to communicate with each other

Answer 7

Other technologies to communicate together

Answer 8

・Dynamic | ・A collectively authored set of webpages

Answer 9

・Make communication easier | ・Manage knowledge of different people

Answer 10

・Web-based ・Interactive ・Collaboration

Answer 11

・They're collaboration tools, make sure you have well controlled and keep it updated ・They're intended to maintain a series of unique documents as their content evolves ・They have built-in version control

Answer 12

An RSS application is developed to serve a specific purpose for a specific company

Answer 13

・More channels for communication ・Personal communication and media consumption ・Social media being used for many other purposes

Answer 14

・Create and share content ・Online communication channels ・Computer-mediated technologies

Answer 15

・Create and share content or participate in social networking ・Online communication channels (community-based) ・Computer-mediated technologies (sharing of ideas and info)

Answer 16

・End-users (who are you targeting) ・Use cases (how are you going to target) ・Functionality (why are you going to target)

Answer 17

・Engage with customers, prospects, partners and your networks ・Create opportunity by communicating ・Mange your reputation

Answer 18

・Maximize the potential of social media by using across business functions ・Rather than using social media as an inside-out promotion medium, leverage ・Insights for product research, competitive analysis and prediction of customer needs ・Update corporate governance policies and guidelines

Answer 19

・Objectives ・Tactics ・Metrics

Answer 20

Plan ・Creating a social media strategy Do ・Implementing tactics and campaigns aligned with the social media strategy Check ・Regular (daily, weekly, monthly, etc.) review of metrics created as part of the strategy to determine if business return on investment in social media has been achieved or not Act ・Fine tuning the social media strategy, tactic, plan for campaigns, and even potentially refining or changing metrics or how measurements are performed

Answer 21

・Data driven management | ・Metrics

Answer 22

・Activity Metrics: Review ・Return on investment: sales and marketing, product development, HR ・Tactical Metrics ・Strategic Metrics

Answer 23

``` ・Objectives ・Customers ・Sharing ・Who ・Brand Alignment ・Monitor ```

Answer 24

``` ・Strategy ・Organization ・Criteria-Based Platform Selection ・Integration ・Awareness ・Leadership ```

Answer 25

・System development ・Computer operations ・Staffing, training, and developing ・Infrastructure, planning, development and control

Answer 26

・Install and design ・System integration ・Innovative ideas ・Alliances with other business partners

Answer 27

・Information System department ・Information Technology department ・Information services department

Answer 28

・Volume - lots of data, it is needed to make a good decision ・Variety - need data about different things ・Velocity - how updated the data is ・Veracity - accuracy of data

Answer 29

・The activity of buying and selling, especially on a large scale ・Social dealings between people ・Social computing ・Electronic commerce ・Online marketplaces and communities ・Collaborate online

Answer 30

・Strategy needs to be formulated in terms of objectives, tactics and metrics ・Corporate governance issues such as policies and guideline need to be considered

Answer 31

・A spreadsheet program ・Allows you to put a collection of data into a spreadsheet which can turn into information ・A spreadsheet is a collection of data

Answer 32

``` ・Data management features ・Automatic calculation functions ・Presentation tools ・Decision analysis function ***All excel functions fit into one of these categories*** ```

Answer 33

``` ・Excel is an application ・A worksheet is a spreadsheet ・A workbook is a collection ・A reference is what you call a cell ・A range group of cells is usually at least 2 ```

Answer 34

Perform operations and arrive at a calculated result

Answer 35

・An expression that returns a value through performed operations on literal values or referenced cell values ・Must begin with " = "

Answer 36

A named operations that returns a value

Answer 37

・Formulation ・Solution ・Interpretation

Answer 38

When you have a big list because it makes it easier to find what you are looking for

Answer 39

Maximizes the best which will give you the most best

Answer 40

Maximize the worst which will give you the best of the worst

Answer 41

・Filter unique values ・Data validation and drop-down menus ・Lookup functions

Answer 42

Are used to compare two values or statements ・Result of the functions is a logical value (true or false) Ex. AND, OR, NOT

Answer 43

Apply to anything that comes with a specific condition ・Result may be a specified value or a calculated value Ex. IF, COUNTIF, SUMIF, AVERAGEIF

Answer 44

・VLOOKUP: finds a specific value in the first column of a lookup table and returns the corresponding value in a specific table column ・HLOOKUP: same as VLOOKUP by horizontal

Answer 45

``` Calculates the sum of the products Ex. Price*Quantity 1*2 3*4 5*6 7*8 9*0 =100 ```

Answer 46

・Benefits ・Phases ・Layers

Answer 47

・Problem statement ・Assumptions and model structures ・Result and conclusions ・Solution

Answer 48

・Assumptions and model structures ・Results and conclusions ・Solutions ・Problem statement

Answer 49

Returns a value from a specified list of values on a specified position

Answer 50

・Economy: Less costly to analyze decision problems using models ・Timeliness: Models often deliver needed info more quickly than their real-world counterparts ・Feasibility: Models can be used to do things that would be impossible

Answer 51

RAD ・Reporting: Regular mass info disseminating in a standard format. Metrics and graphics typically represent a score card ・Analytics: Slicing and dicing with visual feedback and interactivity. Mainly for the middle management - for tactical decisions and to guide strategic decisions ・Dashboards: Quick distilled snapshots, highlighting the key indices from instant decision making. Typically include interactive features for end-users to customize the content or the lock and feel

Answer 52

・Strategic ・Analytical ・Operational

Answer 53

Excel is a practical and easy-to-use front-end tool for Strategic Dashboards

Answer 54

・Data Points: Numeric value that describes a single item on a cart ・Data Series: Groups of related data points ・Category Labels: Describe a group of data points in a chart

Answer 55

・Specify the data series ・Select the range to chart ・Select the chart type ・Insert the chart and designate the chart location ・Choose chart option/add graphics in charts

Answer 56

An easy way to apply dynamic formatting to cells based on the values in those or other specified cells

Answer 57

・Scenarios ・Goal Seek ・Data Tables

Answer 58

What-if-analysis the study of how the uncertainty in the output of a model can be attributed to different sources of uncertainty in the model inputs

Answer 59

a formula that is directly or indirectly based on the adjustable cell and constraints

Answer 60

Whose values are adjusted until the constrained are satisfied

Answer 61

Data typically organized to model relevant aspects of reality in a way that supports processes requiring this information

Answer 62

・Assessed ・Managed ・Updates

Answer 63

・No enterprise can be effective without high quality data that is accessible when needed ・Data that’s incomplete or out of context cannot be trusted

Answer 64

To provide the infrastructure and tools to transform raw data into usable information of high quality

Answer 65

・Volume of data is increasing exponentially ・Data is scattered throughout the organization ・Data is created and used offline without going through quality control checks ・Data may be redundant and out-of-date, creating a huge maintenance problem

Answer 66

・All the data contained within a single business process or unit of work ・Primary purpose is to support daily operational tasks ・Generated and captured by operational systems Ex. Tickets, Receipts, packing slips

Answer 67

・All organizational info ・Primary purpose is to support the performance of higher-level analysis tasks Ex.Product stats, sales projections, trends

Answer 68

・Separates the logical and physical view of the data ・Physical View: How data is organized, specified and stores ・Logical View: How data appears to the end-user

Answer 69

・Defines each data element | ・Used by programmers and database administrators in creating database

Answer 70

・Query and reporting capability in DBMS ・Used to manipulate Data (ex. Structured query language -SQL) ・Used to get data into and out of a database

Answer 71

・The structure descriptions of the stored field | ・Includes location, format, field name, data description etc.

Answer 72

・Editing and processing rules as well as automatic procedures that must be processed for accurate data

Answer 73

・Definitions of data elements and their characteristics | Ex. Input mask, validation rule, mandatory/optional inputs

Answer 74

・Select: Creates a subset of data all records that meet stated criteria ・Join: Combines relational tables to provide user with more information than available in individual tables ・Project: Creates subset of columns in table, creating tables with only the information specified

Answer 75

Consistent and uniform set of identifiers and extended attributes that describe the core entities of the enterprise Ex.customer, product, employee, vendor, geographic location etc.

Answer 76

・Improves search effectiveness ・Increases accuracy ・Streamlines new product entry into the database management system ・Facilitates processing of transactions

Answer 77

・An approach to managing information across an entire organization ・A formal set of business processes and policies that are designed to ensure that data are handled in a certain, well-defines fashion ・The organization follows unambiguous rules for creating, collecting, handling, and protecting its information ・The objective is to make information available, transparent, and useful for the people who are authorized to access it, from the moment it enters an organization until it is outdated and deleted

Answer 78

Methodology for documenting databases illustrating relationships between database entities

Answer 79

・Database object that you can use to enter, edit, or display data from a table or query ・Can be used to control access to data by limiting which fields or rows of data are displayed to users

Answer 80

・Database object that is used to organize and display data pulled from tables and queries ・Commonly used as formatted hard copies of table or query data ・You can modify a report’s design but cannot add or edit data in a report

Answer 81

・A set of instructions used for working with data | ・Creating a query is like asking the database a question

Answer 82

・The process of removing redundant data from your tables to improve storage efficiency, data integrity, and scalability ・No repetition of data ・Needs to be normalized because there’s blank spaces, you break it up into different tables (3)

Answer 83

・Select ・Join ・Project

Answer 84

・Most popular query language used for interacting with a database ・Allows people to perform complicated searched by using relatively simple statement or key words (ex. select, from, where) ・Data manipulation language used to add, change, delete and retrieve data in database

Answer 85

・User fills out a grid or template known as a form ・Drag and drop ・Best for a non-programmer (ex. you)

Answer 86

Enterprise DBMS ・Large operational and analytical databases ・Thousands of users at a time, along with multiple database applications Personal/Desktop DBMS ・Smaller, simpler database applications ・Personal or smaller workgroup applications ・Fewer than 100 users

Answer 87

support business intelligence

Answer 88

A copy of transaction data specifically structured for querying, analysis, reporting, and more rigorous data mining

Answer 89

・Low-cost, scaled-down version of a data warehouse that is designed for the end-user needs in a strategic business unit or an individual department ・Contains a subset of data warehouse information ・Contains summarized or highly focused portion of data for a specified business unit or group of users ・Contains a snapshot of operational data for specific business contexts ・Creation of a data mart is predicated on a specific predefined need for a certain grouping and configuration of select data

Answer 90

・Internal and external sources can put data in the warehouse ・ETL: Extract, Transform, Load ・Extract: taking from elsewhere ・Transform: transform data ・Load: load the data

Answer 91

``` ・Organized by business dimension or subject ・Use online analytical processing ・Integrated ・Time variant ・Non-Volatile ・Multidimensional ```

Answer 92

Database object that you can used to enter, edit, or display data from a table or query

Answer 93

・Database object that is used to organize and display data pulled from tables and queries ・You can modify a report’s design, you cannot add or edit data in a report

Answer 94

Extract Transform Load

Answer 95

Al of the data contained within a single business process or unit of work, and its primary purpose is to support performing daily operational tasks

Answer 96

all organizational information, and its primary purpose is to support the performance of higher-level analysis tasks

Answer 97

set on identifiers and extended attributes that describe the core entities of the enterprise such as customer, product, employee, vendor, geographic location, etc. ``` example: product sold vendor salesperson store part number purchase price date ```

Answer 98

describes the business's activities or transactions ``` example: 52-inch LCD TV Samsung Kyle Smith Best Buy 1234 $1,500 March 20th, 2018 ```

Answer 99

data in unit that cannot be subdivided

Answer 100

digitized image and multimedia

Answer 101

key tool employed in the design of databases methodology for documenting databased and is used to illustrate relationships between entities

Answer 102

mathematical relationships and logical assumptions implemented in a computer as an abstract representation of a real-world object or phenomenon spreadsheets provide the most convenient way for business people to build computer models

Answer 103

1. summarized highlighted text - calculated data and summary metrics - conditionally formatted data 2. icons - alerts - up/down - on/off 3. tables and charts - line charts - pie charts

Answer 104

- input mask - validation - format

IT Flashcards

learn (128 cards)