IT 1500 Unit 2 Milestone Introduction to Information Technology Sophia Course

Click below Link for Answers

1

When Beth touches the screen of her smartphone to launch an application, the operating system's __________ enables her to access her software and files.

·

welcome screen

·

hardware

·

memory

·

user interface

2

Which of the following correctly describes a record?

·

A record is referred to as a tuple.

·

A record appears as a column in a table.

·

A record contains only quantitative information.

·

A record is a single database with a single table of information.

3

Select the scenario that describes a top-down approach to data warehouse design.

·

Cynthia’s Florals, which is dealing with debt, creates new data marts for the service, delivery, and sales departments to develop a strategy to stay in business.

·

Cathy’s Cards and Gifts, which has three stores, creates data marts for its sales, marketing, and delivery departments to study the possibility of establishing a new store.

·

Connor’s Meat Market, which just opened, creates data marts to track the sale of each of the following meats: beef, pork, lamb, and fish.

·

Crawford's Fabrics, which wants to expand its operations, combines data from the purchasing and sales departments into a central database, to be divided into new data marts as needed.

4

Luis has an organized system of icons, files, and folders on his computer's home screen.

Which element of the Microsoft Windows operating system is Luis using?

·

Start Menu

·

Control Panel

·

Device Manager

·

Desktop

5

An enrollment counselor queries the following database table to identify undergraduate accounting majors. 

How many records are displayed in the query?

Student_ID Student_Name State Birth_Year Degree Major

44352 Anderson, Tiffany IL 1994 Graduate Economics

98425 Avendano, Marco MN 1994 Graduate Accounting

67512 Barrett, Eliza IL 1992 Graduate Mathematics

97156 Brown, Amy MN 1994 Undergraduate Pre-Medicine

36401 Elissa, Jose WI 1997 Undergraduate Accounting

97315 Grey, Nicole VT 1999 Undergraduate Theatre

54074 Harris, Blake IL 1992 Undergraduate Accounting

64782 Jensen, Allan MN 1990 Graduate Economics

·

1

·

2

·

3

·

4

6

__________, developed by Apple, can be used to calculate and organize financial information.

·

Numbers

·

Keynote

·

Excel

·

Calc

7

Brian has a corrupted file that tries to load when his computer is booting up. To solve this problem, he restarts the computer, then presses F8 to display the Advanced Boot Options menu.

Which solution is Brian using?

·

Help System

·

Safe Mode

·

Control Panel

·

Windows Backup

 

8

All of the following data types are classified as text, EXCEPT:

·

April 7, 1985

·

Royal blue

·

www.mybusiness.com

·

Indianapolis 46060

9

Which statement describes an example of database software?

·

Microsoft Access enables users to create, store, and retrieve records.

·

Microsoft PowerPoint enables users to create animated presentations that can be projected on a screen.

·

Microsoft Excel enables users to perform calculations and statistical analyses. 

·

Microsoft Word enables users to write and edit text documents. 

10

Carrie's computer does not recognize her zip drive when she plugs it into a USB port.

Carrie's computer is experiencing a(n) __________.

·

application crash

·

file compatibility issue

·

external error

·

system performance problem

 

11

Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize. 

Select the set of file types that Jeremiah should look for.

·

.avi and .wmv

·

.wma and .mpg

·

.mov and .ods

·

.mpg and .key

 

12

Which of the following is NOT a challenge of data warehousing?

·

Communicating requirements

·

Cost

·

Testing

·

Scheduling data pulls

13

Identify the true statement about Windows tasks.

·

Users can only begin an application by clicking on the associated icon on the desktop.

·

Pressing the Windows key and the E key simultaneously is one way to end a program.

·

The Welcome screen lists the user accounts on the system.

·

The GUI controls the process for shutting down Windows.

14

All of the following would appear as records in a database table, EXCEPT:

·

Little Rock, AR

·

Armstrong

·

Last Name

·

Information Technology Specialist

15

Paul wants to present information about a new product at the upcoming national sales meeting.

Which productivity software should Paul use?

·

IBM DB2

·

Microsoft Excel

·

OpenOffice Impress

·

Google Docs

 

1

Which productivity software is used to create tables from statistical data?

·

Open Office Impress

·

Google Docs

·

Microsoft Excel

·

Microsoft SQL Server

 

2

Paul wants to present information about a new product at the upcoming national sales meeting.

Which productivity software should Paul use?

·

OpenOffice Impress

·

IBM DB2

·

Google Docs

·

Microsoft Excel

 

3

Carrie's computer does not recognize her zip drive when she plugs it into a USB port.

Carrie's computer is experiencing a(n) __________.

·

system performance problem

·

external error

·

file compatibility issue

·

application crash

 

4

Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize. 

Select the set of file types that Jeremiah should look for.

·

.mpg and .key

·

.wma and .mpg

·

.avi and .wmv

·

.mov and .ods

5

Which of the following correctly describes a record?

·

A record is referred to as a tuple.

·

A record appears as a column in a table.

·

A record contains only quantitative information.

·

A record is a single database with a single table of information.

6

Jeremy wants to buy a horse. He is looking for a brown Tennessee Walker that is at least five years old AND at least 15 hands tall. 

How many records will be displayed in response to his query?

COLOR BREED HANDS AGE

Brown Tennessee Walker 14.5 7

Black Tennessee Walker 16 5

Brown Thoroughbred 16.5 8

Brown Tennessee Walker 14 5

Brown Tennessee Walker 15.5 2

Black Thoroughbred 15 3

Black Tennessee Walker 15 9

·

1

·

2

·

0

·

3

7

Which of the following is the FIELD in a database table?

·

Emily Walker

·

6/5/1985

·

beextraordinary@email.com

·

Name

8

Brad launches a program in order to see all of his files, folders, and programs in one place.

Which element of the Microsoft Windows operating system is Brad using?

·

Windows Shell

·

File Explorer (formerly Windows Explorer)

·

Security and Maintenance

·

Taskbar

 

9

Which of the following is NOT a challenge of data warehouse design?

·

Internet speed

·

Data quality

·

Determining analytics and reporting

·

Performance requirements

10

Identify the true statement about Windows tasks.

·

Users can only begin an application by clicking on the associated icon on the desktop.

·

The GUI controls the process for shutting down Windows.

·

The Welcome screen lists the user accounts on the system.

·

Pressing the Windows key and the E key simultaneously is one way to end a program.

11

__________, which was created by OpenOffice, enables users to create slideshow presentations.

·

Pages

·

Impress

·

Keynote

·

Presentation

12

Which data type should be classified as a date/time?

·

04-15-12 15:25

·

0.01

·

€ 20

·

$10.59

 

13

When Charlie attaches a file to an email message, the computer's __________ is responsible for managing his access to the location where the file is stored.

·

operating system

·

hardware

·

e-mail program

·

administrator

14

Select the scenario that describes a top-down approach to data warehouse design.

·

Cathy’s Cards and Gifts, which has three stores, creates data marts for its sales, marketing, and delivery departments to study the possibility of establishing a new store.

·

Crawford's Fabrics, which wants to expand its operations, combines data from the purchasing and sales departments into a central database, to be divided into new data marts as needed.

·

Cynthia’s Florals, which is dealing with debt, creates new data marts for the service, delivery, and sales departments to develop a strategy to stay in business.

·

Connor’s Meat Market, which just opened, creates data marts to track the sale of each of the following meats: beef, pork, lamb, and fish.

15

When Marco returned from a vacation in Hawaii, he uploaded several pictures and video clips that he took at the beach. After editing some of the pictures using photo editing software, he opened a video-maker program to edit footage. Shortly after he opened the video-maker, the program stopped responding.

Which tool or method is best for Marco to use to solve this issue?

·

Help System

·

Safe Mode

·

Task Manager

·

System Restore

RATIONALE

 

Which of the following is a challenge of data warehousing?

·

Data originality

·

Cloud computing environments

·

A high reliance on data quantity

·

Privacy concerns

 

Pille runs a small business. She wants to create and send invoices to her customers.

Which productivity software should Pille use?

·

OpenOffice Calc

·

MySQL

·

Google Slides

·

Microsoft Access

 

Identify the statement about Windows tasks that is FALSE.

·

You can view all files on a computer by using File Explorer (formerly known as Windows Explorer).

·

Pressing the power button begins the boot process.

·

The most common way to open an application is by using the Start menu.

·

Clicking on the Internet Explorer icon is a shortcut way to display all Microsoft Office programs.

 

__, developed by OpenOffice, is an example of word processing software.

·

Keynote

·

Numbers

·

Impress

·

Writer

 

Dana, who lives in a Northern climate, was redesigning the landscape on her property. She queried the following database table to identify flowering plants for a shaded section of her garden. 

How many records will be displayed in her query?

AREA COMMON_NAME SUNLIGHT FLOWERING

Southern Thingrass Shade No

Northern Shasta Daisy Sun Yes

Southern Lamb's Ears Sun Yes

Northern Bleeding Heart Shade Yes

Northern Dwarf Hinoki False Cypress Shade No

Southern Lily of the Nile Sun Yes

Northern English Ivy Shade No

·

1

·

2

·

0

·

4

 

Brenda has a laptop that is more than six years old. Since she upgraded the Windows operating system to the latest version, her machine crashes when she starts it up.

To solve the issue, Brenda should try __________.

·

System Configuration

·

System Restore

·

Defragment

·

Disc Cleanup

 

Which of the following is the FIELD in a database table?

·

$2,109.49

·

$1,345.20

·

$969.78

·

Account_Balance

 

Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize. 

Select the set of file types that Jeremiah should look for.

·

.avi and .wmv

·

.mov and .ods

·

.mpg and .key

·

.wma and .mpg

 

Which of the following correctly describes a record?

·

A record is a flat file.

·

A record is a set of data organized in columns and rows.

·

A record appears as a row in a table.

·

A record consists of one field.

 

Select the data type that can only be classified as a number.

·

$1,253.12

·

13:30

·

11/10/11

·

83.152

 

Merle cannot open documents created by one program on a machine that does not have the program installed.

Merle is dealing with a __________.

·

file management issue

·

software productivity issue

·

network connectivity problem

·

hardware problem

 

 

SmartExpert

(118)

Status NEW Posted 14 Aug 2020 09:08 AM My Price 30.00

IT -----------150-----------0 U-----------nit----------- 2 -----------Mil-----------est-----------one----------- In-----------tro-----------duc-----------tio-----------n t-----------o I-----------nfo-----------rma-----------tio-----------n T-----------ech-----------nol-----------ogy----------- So-----------phi-----------a C-----------our-----------se-----------

Attachments

file 1597398920-Milestone 2.docx preview (2569 words )

1----------- W-----------hen----------- Be-----------th -----------tou-----------che-----------s t-----------he -----------scr-----------een----------- of----------- he-----------r s-----------mar-----------tph-----------one----------- to----------- la-----------unc-----------h a-----------n a-----------ppl-----------ica-----------tio-----------n, -----------the----------- op-----------era-----------tin-----------g s-----------yst-----------em'-----------s _-----------___-----------___-----------___----------- en-----------abl-----------es -----------her----------- to----------- ac-----------ces-----------s h-----------er -----------sof-----------twa-----------re -----------and----------- fi-----------les-----------. ----------- w-----------elc-----------ome----------- sc-----------ree-----------n ----------- h-----------ard-----------war-----------e ----------- m-----------emo-----------ry ----------- -----------use-----------r i-----------nte-----------rfa-----------ce ----------- RA-----------TIO-----------NAL-----------E -----------Whe-----------n B-----------eth----------- to-----------uch-----------es -----------the----------- sc-----------ree-----------n o-----------f h-----------er -----------sma-----------rtp-----------hon-----------e t-----------o l-----------aun-----------ch -----------an -----------app-----------lic-----------ati-----------on,----------- th-----------e o-----------per-----------ati-----------ng -----------sys-----------tem-----------'s -----------use-----------r i-----------nte-----------rfa-----------ce -----------ena-----------ble-----------s h-----------er -----------to -----------acc-----------ess----------- he-----------r s-----------oft-----------war-----------e a-----------nd -----------fil-----------es.----------- Us-----------er -----------int-----------erf-----------ace-----------s a-----------re -----------how----------- th-----------e u-----------ser----------- an-----------d a----------- co-----------mpu-----------ter-----------

Not Rated(0)

• Buy Answer