Internet research and Databases- final exam

What is the order of these operations in Microsoft Excel. lowest to highest 1) parenthesis 2) Division 3) Exponent 4) Addition

4,2,3,1

Explain Boolean Operators "NOT"

"NOT" in conjunction with "AND" if you want to exclude certain results from search, example is Notre Dame NOT football will return results relating to Notre Dame that do not include the search term football

Which key(s) should you hold down to select multiple pictures at once to insert on a slide A) Ctrl+V B) Ctrl C) Enter D) .wmv E) Pivot Table

B

Which selects the next paragraph based on the current position of the curser A) CTR+SHIFT+RIGHT ARROW B) SHIFT+ALT+DOWN-ARROW C) CTRL+H D) LEGEND E) DATA LABELS

B

Examples of management information systems (MIS)include_____ A) TPS B) DSS C) ESS D) MBA

B and C

Visibility, Usability, and Accessibility

Businesses attempt to improve a user's web experience through web mining to lead to improve website visibility, usability, and accessibility

Boolean operators are the words "AND", "OR" and _________. The use of Boolean operators can make a search more precise and return better results A) NOPE B) NEVER C) NOT D) NOTHING

C

DBMS software comprises five subsytems

DBMS engine, data definition, data manipulation, application administration data administration

Veracity

means truth, meaningful

Advance Search Tools

to be more specific when conducting search on web. tools such as parenthesizes and "AND", "OR" and quotation marks can help narrow search results; quotation marks ("") allow searchers to search for entire phrase, parentheses are used in conjunction with "AND" and "OR" to further specify a result

Explain Boolean Operators "OR"

use when your searching for documents including one or another of your search words

Databases and Web Technologies

users need to communicate with a business internal database for shopping, web browsers communicate with the web server via HTML, JavaScript, new technology like node.js, REACT, and more users are comfortable operating browsers/digital devices, using this technology through front-end interfaces requires little change to existing database structure/gives business more global web connectivity

Web Mining

uses the principles of data mining to extract information from website/social media sites, techniques used are content mining(WCM), web structured mining(WSM), web using mining(WUM)

Which Fields to include in a Table

when designing database, first determine categories of data that'll be included, characteristics of field is uniquely identify each data category you need to capture, should not contain 2 separate pieces of data

Write an excel formula to count the number of empty cells within cells A1 to A20

=COUNTBLANK(A1:A20)

A URL identifies a particular________ address on the World Wide Web A) Gettysburg B) computer C) printer D) file

D

Collecting data, interpreting information gleaned from a database and preparing reports for senior management are tasks that are typically assigned to a _________ A) information systems(information technology) technician B) information systems(information technology) program manager C) database administrator(DBA) D) data analyst

D

Advanatges of databases

allows for storage of large amounts of data efficiently/securely, enables data sharing/help to ensure data integrity, allows for centralization where data maintained only one file

Content mining(WCM)

extraction of information from web pages and document including text, images, videos, and more

Commercial Databse

large database that covers specific subjects

Data Marts

subsection of data warehouse, designed specifically for individual departments or business functions, 3 types of data marts

Keywords and hashtags

tells search engine what to display

Database Data Types and Field Properties

working in design view allows you to change field name/field properties, data type specifies data in field such as text, numeric, date/time, setting data types for each field decreases data input mistakes, as you move from 1 field to next, field properties change

Anna is creating a PowerPoint slide which requires she uses information from other existing slides. Show the right steps/order to insert parts of another slide into a current slide 1) New slide 2) Insert 3) Browse for the file location 4) Reuse slide 5) Click OK to insert the slide

2, 1,4,3,5

A link between tables in a relational database that defines how the data is related is called a ___________ A) relationship B) link C) partnership D) join

A

Business owners, copyright holders, and network administrators publish_______ so that users understand what is expected and permissible when they use the network, computer equipment, and/or software A) AUPs B) bps C) SOPs D) BTUs

A

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data_______ A) hierarchy B) company C) levels D) manger

A

In Excel, numeric values are right-aligned by default A) True B) False

A

Match extension with type of document for Spreadsheet A) .xlsx B) .html C) .pez D) .accdb

A

Paste a copied slide A) Ctrl+V B) Ctrl C) Enter D) .wmv E) Pivot Table

A

The most popular web browser shave a private browsing mode(Incognito). While browsing in Incognito mode your browser will not store____________ A) cookies B) antivirus programs C) social media D) IP adresses

A

Which selects the next word based on the current position A) CTR+SHIFT+RIGHT ARROW B) SHIFT+ALT+DOWN-ARROW C) CTRL+H D) LEGEND E) DATA LABELS

A

Which of the following should you consider when evaluating a website for research purposes? A) if you are using a website for research purposes you should research the publisher's qualifications B) check to see the author's background, who published the authors work, and what is the relationship between the author and publisher C) you can find most of the information about a publisher by visiting the AboutUs, corporate profile, and background sections of the site D)All sites on the internet have been validated and are from trusted sources

A and B

An internet search engine can perform which three basic tasks? A) search the internet for information based on the search criteria entered by the user B) indexing of keywords that are found C) display the location of the information stored in the indexes D) diagnose your system software for viruses and other malware

A and B and C

Commonly used search engines include A) google B) bing C) yahoo D) edge

A and B and C

Select the following statements that are true regarding search engine filters A) filters limit the material browsers fetch B) parents often use search engine filters to restrict offensive images from being displayed on computer monitors C) filter settings are often accessed through a browser's preferences D) filters can guarantee that nude photos will never be displayed by a search engine

A and B and C

Which of the following are examples of downloading a file? A) coping a driver from a company's website and saving it to your computer B) buying a song on iTunes so you can listen to it on your phone C) posting a video on YouTube D) copying a photo from Facebook and saving it to your desktop

A and B and D

All of the following are true about RFID except A) RFID stands for Radio Frequency identification B) RFID uses infrared transmissions C) RFID doesn't require line of sight scanning D) RFID can be used to identify a variety of objects including chip-implanted objects, and animals

B

Match extension with type of document for Web page A) .xlsx B) .html C) .pez D) .accdb

B

Search________optimization(SEO) is a set of strategies, techniques, and practices used to increase the amount of visitors to a specific website by getting a high ranking placement in the search engine A) effort B) engine C) electronic D) enhanced

B

Select the domain name A) http://www.mit.edu/computers B) www.cnet.com C) .gov D) mheducation.com

B

Websites that use cookies can collect information about A) surfing habits B) selling your collected information to third parties C) monitoring your web behavior D) tracking a user's cloud storage

B

Footnotes and endnotes use a special font style for the numbers or letters used to reference them in a document; this font style is called A) Reference view B) Italics C) Superscript D) Subscript

C

Inserts a paragraph break A) Ctrl+V B) Ctrl C) Enter D) .wmv E) Pivot Table

C

Match extension with type of document for Presentation A) .xlsx B) .html C) .pez D) .accdb

C

What does this excel formula do:=C7*Sheet2!$D$4 A) gives an error B) multiplies the value in cell C7 by the value in cell D4 on sheet 1 C) Multiplies the value in cell C7 by the value in cell D4 on sheet 2 D) Multiplies the value in cell C7 in sheet 2 by the value in cell D4 on sheet 1

C

What is the alert for a grammar error? A) Green sine underline B) Blue wavy underline C) Blue double underlines D) Red wavy underline E) Red double underline

C

What opens the Find and Replace dialog box with the Replace tab selected A) CTR+SHIFT+RIGHT ARROW B) SHIFT+ALT+DOWN-ARROW C) CTRL+H D) LEGEND E) DATA LABELS

C

When you open PowerPoint and click Blank Presentation you go directly to: A) Themes B) Online Templates C) Your first side D) Backstage view

C

Which category of management information systems(MIS) combines the forecasting capability of decision support software with the records keeping ability of transaction processing systems software to help businesses manage inventories efficiently? A) EIS B) ERP C) SCMS D) ESS

C

In Excel start, the key that identifies the data series by color A) CTR+SHIFT+RIGHT ARROW B) SHIFT+ALT+DOWN-ARROW C) CTRL+H D) LEGEND E) DATA LABELS

D

Match extension with type of document for Database A) .xlsx B) .html C) .pez D) .accdb

D

Presentation saved as a video A) Ctrl+V B) Ctrl C) Enter D) .wmv E) Pivot Table

D

Privacy and _____ are the two main factors related to your digital identity A) software B) platform C) hardware D) security

D

In excel chart, what is used to identify a data series or its individual points; may include values? A) CTR+SHIFT+RIGHT ARROW B) SHIFT+ALT+DOWN-ARROW C) CTRL+H D) LEGEND E) DATA LABELS

E

Summary reports in a separate worksheet based on list-type data A) Ctrl+V B) Ctrl C) Enter D) .wmv E) Pivot Table

E

common search engines include

Google, yahoo, bing

Common DBMS software

Microsoft access, oracle database, Microsoft structured query language(SQL) server

Database Relationships

Micrsoft access is a relaitonal databse, it organizes data into various tables based on logical grouping, in desgin view select the design tabs, then select relationships, relationships is link between tables that defines how data are related, common field between the two tables is used to create the link, takes one of three forms

Database Field

a group of related characters in database table, field is column int able that represents characteristics of someone or something, move from field to field using left?right arrows buttons on keyboard with left click on mouse, switch to design view to edit field names and field properites

Data Warehouses

a repository of data used by organizations to make informed decisions, data flows into warehouse from transactional systems databases, and other places; people who have access to data warehouses include data scientists, key decision makers(KDMs) and data specialists, output includes reports, dashboard, and queries

Database Primary Key

a special field that uniquely identifies a record in a table, a primary key must contain unique value, it cannot contain null value, common primary keys include student ID number, social security number, customer ID number

Database Table

a table in a database is a collection of associated records, can view the different tables by clicking table name in Table subgroup, you can view table in datasheet or design view, can adjust field properites for table in desgin view

What are Boolean Operators?

allows searchers to find more accurate search results, some of characters include "AND" "OR" "NOT"(all caps), connecting keywords with "AND" searches for multiple items in same web page and article. "NOT" excludes web pages or article with designated keywords; "OR" searches for multiple keywords on different pages

DBMS Database management system

allows user to create, modify, and access database

Google image searches

almost every major search engine has tools that allow users to search web for images or videos as well as articles on subject, most search engines, just type subject of image then click "images" button

Web Using Mining

also called log mining/including analysis of web access logs to determine when,how, and how often websites are accessed

Data Mining

also referred to as knowledge discovery in data(KDD) it uses mathematical algorithms that segment the data/evaluate likelihood of future events,using machine learning, statistics, AI, and database technology

Web structure mining (WSM)

analysis of hyperlinks, nodes, and related web pages

Hybrid

assimilates data from a data warehouse and from other data collection systems

How data mining works

assists in uncovering information hidden in data sets but cannot offer reasons why the information may be valuable, interpreting why certain data may be related is done by mangers/data analysis, data mining yields probabilities not exact answers

Four key properties of data mining

automatic discovery of patterns, prediction of likely outcomes, creation of actionable information, a focus on large data sets and databases

How do search engine work?

can internet search engine can perform three basic tasks, search internet for information based on search criteria by user, indexing of keywords that are found, display location of information stored in indexing.

Using HTML objects when searching-Anchor

clickable text, usually blue, that hyperlinks to another web page; image- searches web page containing images; link-displays web pages about specific topic with links included; site- display webpage about specific criteria on specific site

what is a database?1

collection of related data that can be stored, logically organized, quired and stored, used to create structure for data/allow processed data to used/interpreted, business transaction create data that beed to be managed/stored

Individual database

combined set of data files instead to be used by 1 person

Dependent

constructed from an existing data warehouse, where organizational data are stored in a central location

Company Database

created for use by an organization

Distributed Databse

data in database are stored in different physical locations/accessed via client/server network

Value

data must be useful to bring balue

Hierarchy

database are structured in a hierarchy with characters starting at lowest point/database at highest point, the standard hierarchy starts with a character, then field, records, tables, file, and finally a database

Big Data

defined by five V's: volume, variety, veracity, velocity, value

BI Systems are data

driven decision support systems used to help business make strategic decisions, BI systems provide a picture historic, current, and future views of operations

Database Forms

formas are used to control how data are entered into a database, forms structure data input to ensure data integrity, data are entered into blank areas of the forms, forms turn data into information, forms are created using DBMS software, navigate to other records that have forms using button on bottom of form windows

Site Visibility

how and when a site surfaces when queries in search engine are executed, search engine optimization(SEO) uses web mining to enhance this

Evaluating websites- validity and authenticity

if your using website for research purpose, research publisher's qualification, check to see author's background and who publish author's work, and what is the relationship between author and publisher, check to see what references are included on-site, investigating uniform resource locator(URL) can also indicate vaildity

Database Foreign Key

in a relational database a common field between table that's not the primary key

Business Intelligence

includes technologies, applications, and procedures used to collect, analyze and present business information

Accessiblity

includes the structure of websites and web pages to ensure access/scalability on multiple devices and platforms

SEC uses

indexes to speed up search process

Search engine database

information contained in search engine database is determined by how specific each company records URL information, is common practice for website owner's to submit their URL and associated information to search engine company(SEC)

Whools Lookup

is often used to determine owner and sponsor of specific website, or to determine if domain name is already being used, whools look up can provide this information

Data integrity

is the database reliable accurate, aligned to goals of organization? the way data are entered greatly impacts its integrity, data centralization(keeps data in 1 database) helps increase data integrity, having multiple lists means information can become inconsistent, this causes decreased data integrity

How to evaluate websites

it is important to evaluate website to ensure your viewing legitimate sites with good information, you should revaluate websites using a reliability, relevance, validity, authenticity, objectivity, and bias

Evaluating websites- objectivity and bias

keep eye on objectivity and biases of information on website, nearly impossible to find information without bias, but it doesn't mean sources are not credible, when viewing website investigate background of author and site, find information with little bias as possible is most constructive

Problems with lists

leads to data redundancy, lack of proper updating of information can lead to data inconstancy, lists are difficult to secure, data inconsistency occurs when different versions of same data presents in different lists

Velocity

means speed, data changes rapidly and must be updated, ex over 3.5 billion google searches are conducted worldwide each min of each day

Relational Databse

organizes data into tables, based on structured data grouping, use links called relationships between tables, information in tables is stored in rows(records) and columns(fields), a common field that's included in both tables is used to creat relationship

What is a Query?

query is a question used to request information from a database, into is generated using specific query language, such as structured query language(SQL), queries can filter based on specific criteria, calculate/summarize data, and automate data management tasks

Database Records

records is a collection of related field in data file, records are a collection of characteristics that describe identity on an entity, records is also referred to as a row in a table

Variety

refers to different forms of data, email, photos, videos

Usability

refers to how easily website users interact with the site, data gained from web mining helps web designer optimize site navigation/web structure

Volume

refers to scale of data, estimated 2.3 trillion gigabytes of information are created daily

Evaluating websites- reliability and relevance

reliability look for error in fact, spelling, or language use, if many errors are present, question validity of a site; relevance- how current information is? out of date information can be indicator that site may not be best resource

Database Reports

reports offer a way to view, format, summarize the information into a database, can be used to display or distribute a summary of data/archive snapshots of data, can also be used to provide detail about individual records/create label

Independent

stand-alone systems, separate from a data warehouse and focuses on specific organizational functions

Explain SEO

strategies, techniques, and practices used to increase amount of visitors of specific websites, helps ensure website is known and reachable by search engines, increase likelihood of more site hits