SmartExpert
$30/per page/Negotiable
IT 1500 Final Exam Introduction to Information Technology Sophia Course
Click below Link for Answers
1
IT specialists are expected to use a set of technical and people skills to perform the tasks associated with their job.
Select the IT specialist who demonstrates a hard skill.
Katelyn provides a creative solution that satisfies everyone involved, so work on the new software can continue.
·
Using her knowledge of programming languages, Renee creates new software for her organization.
Andrew meets with his contractors regularly to make sure that their software development projects remain on schedule.
Cassidy holds meetings with company executives to determine how to meet their technology needs while staying within budget.
2
Which of the following is a best practice for maintaining a safe and healthy workstation?
·
Lifting a monitor with the back straight and knees bent
·
Bending the wrist upward in order to access the keyboard
·
Sitting in a desk chair that has been adjusted to a height that leaves the user's feet three inches above the floor
·
Placing the monitor screen 30 inches from the face
3
Which of the following is NOT an example of copyright infringement?
·
Chris posts a number of full-text articles onto his website without giving credit to the authors.
·
Katy uses Wi-Fi at Starbucks during her lunch break to check her email, and to turn in a book report.
·
Eddie likes photos that were posted on a business's website, so he downloads them to his computer.
·
Melanie finds images that are in the public domain and submits them to a photography competition as her own work.
4
Mel is a research scientist at a health sciences center. His job requires him to analyze large amounts of data in short periods of time.
Select the best computer for Mel.
·
A handheld tablet computer
·
A desktop computer with a fast processor
·
A portable laptop computer
·
A desktop computer with two screens
5
Select the true statement about the hard disk.
·
It carries out commands sent by program software and returns results for a computer to act upon.
·
It is the working memory of a computer that transfers data when the device is turned on.
·
It holds the main circuits, and connects other internal components of the computer.
·
It stores long-term memory when a computer shuts down, and memory is retrieved from it when a computer is turned on.
6
Which of the following is NOT a challenge of data warehouse design?
·
Performance requirements
·
Determining analytics and reporting
·
Internet speed
·
Data quality
7
Smartphones and tablets currently outsell laptop and desktop computers.
This statement describes the trend known as __________.
·
automation
·
mobilization
·
personalization
·
visualization
8
Select the FALSE statement about the history of the Internet.
·
The U.S. government created ARPA in response to the successful launch of a satellite by the Soviet Union.
·
The Internet means “an interconnected network of networks.”
·
ARPANET began transmission in 1969, when it connected computers at UCLA, Stanford, MIT, and the University of Utah.
·
The invention of HTML enabled computers on different networks to communicate with each other.
9
In which of the following scenarios can a trademark be applied?
·
Mark writes and records a new song for his rock band.
·
Peter names his new business “Garden Ornaments.”
·
Merle designs a web page for Peter’s business.
·
Twila paints a picture of Hawaiian scenery.
10
Jeffrey consults with company leaders to identify ways in which IT can help the organization to reach its goals.
Jeffrey is working in a/an __________ role for his company.
·
planning
·
network development and maintenance
·
information technology support
·
infrastructure and equipment management
11
Trevor knows that he must be organized if he wants to develop good software. He decides to use __________ to create a budget, manage workloads, and plan the overall development of new software.
·
MS Visual Studio
·
MS Project
·
MS Visio
·
MS Resource
12
Which of the following is an example of computer software?
·
A smartphone
·
An antivirus program
·
An audio/sound card
·
A memory storage device
13
Select the true statement about a mouse.
·
It is an input device that enables users to enter text or number sequences into a computer.
·
It is an input device that converts images or text into digital information.
·
It is an input device that enables users to use a finger to move an on-screen pointer.
·
It is an input device that enables users to point-and-click to make selections, and to start applications or open files.
14
Cristina is adding sound files to her presentation.
Select the set of file types that Christina can use to add this media to her presentation.
·
.gif and .wmv
·
.wma and .sql
·
.csv and .jpeg
·
.mp3 and .wav
15
Which of the following is the FIELD in a database table?
·
6/5/1985
·
Name
·
Emily Walker
·
beextraordinary@email.com
16
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
·
Control Panel
·
Windows Backup
·
Safe Mode
17
Alexis received an email message from an unknown sender that included an attachment.
If she opens the attachment, what kind of malicious software might be activated, and what are the consequences?
·
Opening the attachment would release a worm, which would infect her system with spyware.
·
Opening the attachment would release a worm, which would infect her system with a virus.
·
Opening the attachment would release a passive worm, which would infect her system with adware.
·
Opening the attachment would release an active worm, which would infect her system with adware.
18
Internet Big Box is a global retailer that has networked devices in many small networks in North America, Europe, and Asia. Maria, an executive who works in the United States, communicates regularly with Chen, an executive in China.
Which network type do the executives at Internet Big Box use to communicate with each other?
·
MAN
·
LAN
·
WAN
·
PAN
19
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
20
A collection of facts, such as street addresses or phone numbers, is known as which of the following?
·
Data
·
A process
·
A component
·
A system
21
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?
·
File Explorer (formerly Windows Explorer)
·
Security and Maintenance
·
Windows Shell
·
Taskbar
22
Select the true statement about HTML.
·
HTML stands for hidden transfer markup language.
·
The final product transmitted to a browser is in HTML.
·
The web consists of documents written in HTTP and transmitted by HTML.
·
An HTML tag initiates a protocol known as HTTP.
23
A large part of Kelly's job with a software development company is to monitor the servers to ensure that they are not overloaded by the computers that are connected to them.
Kelly holds the position of __________ in the organization.
·
Network Administrator
·
Infrastructure Manager
·
Database Administrator
·
Support Analyst
24
Ana no longer makes out checks to her utility company because she has arranged for her monthly utility charge to be automatically debited from her bank account on the due date.
Ana is experiencing an example of automation known as __________.
·
customer billing
·
textfill/autocorrect
·
importing/exporting data
·
online software application
25
Which external hardware component is circled in the given image?
·
Port
·
Monitor
·
Vent
·
Eject button
1
All of the following data types are classified as text, EXCEPT:
·
www.mybusiness.com
·
Royal blue
·
April 7, 1985
·
Indianapolis 46060
2
A series of steps undertaken to reach a goal is known as which of the following?
·
Data management
·
Hardware
·
A process
·
Software
3
James is a college student who is writing a research paper. Because he clicked the command to save his work, he knows that after he turns his computer off, his work will be there for when he turns it on again.
James saves his work in a type of computer storage known as the __________.
·
microchip
·
CPU
·
hard drive
·
RAM
4
Althea launches a program to remove some software she no longer uses.
Which element of the Microsoft Windows operating system is Althea using?
·
Control Panel
·
Windows Search
·
Windows Mobility
·
Start Menu
5
Carrie's computer does not recognize her zip drive when she plugs it into a USB port.
Carrie's computer is experiencing a(n) __________.
·
external error
·
system performance problem
·
application crash
·
file compatibility issue
6
Select the sign of computer addiction that indicates neglect.
·
When confronted by his parents about the excessive amount of time he spent playing video games, Tom claims that he plays for only an hour every day.
·
Fearing she would lose her place in the standings of an online game, Rachel declined to attend her cousin's wedding.
·
While waiting in the light-rail station, David became so absorbed in an online political post that he missed his train and was late for work.
·
When confronted by her employer about the amount of time she spent checking her social media account at work, Heidi claimed that she only checks it during her breaks, and at lunch.
7
Select the true statement about the history of the Internet.
·
The first four nodes of ARPANET included Harvard, MIT, Stanford, and the Department of Defense.
·
TCP/IP facilitates communication between networks running on different protocols.
·
The Internet is a global network of connected computers linked through ARPANET.
·
The creation of ARPANET enabled U.S. defense intelligence agencies to predict the Soviet launch of Sputnik.
8
Alex establishes information-security policies for his organization, and oversees the implementation of those policies.
Alex is employed as a __________.
·
Computer Operator
·
Database Administrator
·
Computer Engineer
·
Computer Programmer
9
As a member of a software development team for a national nonprofit organization, Larissa is responsible for creating an interface model for a new app.
What is Larissa's role in the organization?
·
Software Developer
·
Analyst
·
Software Designer
·
Software Project Manager
10
Haitham works for a government agency. He is in charge of a team that develops algorithms and models that guide the function of software applications.
What is Haitham's role in his organization?
·
Programming Language Specialist
·
Database Administrator
·
Network Engineer
·
Computer Scientist
11
Josephine recently bought an item online. The next time she visited the seller's website, a list of items related to her recent purchase were conspicuously displayed.
Josephine is experiencing an example of automation known as __________.
·
automated billing
·
importing/exporting data
·
online software application
·
advertising and marketing
12
Eva downloaded an audio file from a file-sharing website. The download contained a file that recorded her computer usage without her knowledge or consent.
What should Eva do to remove the offending program, and prevent future attacks?
·
Eva should upgrade her system to WPA encryption.
·
Eva should run an antivirus program.
·
Eva should run an anti-spyware program.
·
Eva should change her method of user authentication.
13
Which productivity software is used to create written memos or reports?
·
Word
·
Access
·
Excel
·
PowerPoint
14
John is using __________, a software development management tool that easily integrates into his business’s enterprise software/information system.
·
Visual Studio
·
Visio
·
Primavera
·
MS Resource
15
Genevieve is a student who attends classes at a campus downtown. She likes to study in the college's coffee shop, where she often accesses the Internet through the college's wireless network.
Which network type is Genevieve using?
·
WAN
·
PAN
·
LAN
·
MAN
16
Which of the following correctly describes a record?
·
A record contains all the qualitative data in a database.
·
A record represents a single type of information found in a database.
·
A record is an organized collection of data associated with other data in a database.
·
A record contains all the data about one instance of an item in a database.
17
Which of the following does NOT include both input and output components?
·
A printer with a scanner
·
Video card
·
Touchscreen monitor
·
A portable SSD drive
18
Which individual is performing a network development and maintenance IT role?
·
Siglinde provides technical support to employees who use the organization’s 3D printers.
·
Chelsea evaluates her company’s IT resources and makes recommendations for improvements.
·
To keep up with the latest developments, David studies new Internet protocols for his company.
·
Gretchen trains employees on the leading computer software as it becomes available.
19
Clay works for a company that has offices in major cities across the United States. His department regularly holds videoconferences with teams in the other branches.
Which type of network does Clay's business most likely use for videoconferencing?
·
WAN
·
PAN
·
MAN
·
LAN
20
Gail is examining software to determine what happens when an operator makes a mistake while in data entry mode.
Gail is addressing the dimension of usability known as __________.
·
error management
·
visibility
·
satisfaction
·
efficiency
21
Which of the following is the FIELD in a database table?
·
beextraordinary@email.com
·
Emily Walker
·
6/5/1985
·
Name
22
Select the true statement about network protocols.
·
Communication cannot take place unless the protocol is executed in the same way on all devices.
·
Using a protocol other than TCP/IP can result in data loss.
·
One function of a protocol is to decompress data when it is delivered to the receiving computer.
·
Computers that are distributed across a large geographic area need a special protocol to resolve errors.
23
Melanie wants to copy a home movie to a storage device that will enable her to play it on her television.
The best storage device for Melanie is a(n) __________.
·
internal hard drive
·
CPU
·
CD/DVD-ROM drive
·
sound card
24
Jake has a collection of 40 movies on Blu-ray discs.
How much space will he need to store them on a hard disk?
·
1 terabyte
·
100 kilobytes
·
10 gigabytes
·
40 gigabytes
25
Select the file size that is the SMALLEST.
·
3 TB
·
6,000 GB
·
90,000 KB
·
2 MB
1
All of the following are examples of integrated computer systems, EXCEPT:
·
Using a watch to get directions during a morning run
·
Taking a self-driving car to work
·
Storing a group project on "the cloud"
·
Re-setting a home security system using a tablet computer
2
Alexis received an email message from an unknown sender that included an attachment.
If she opens the attachment, what kind of malicious software might be activated, and what are the consequences?
·
Opening the attachment would release an active worm, which would infect her system with adware.
·
Opening the attachment would release a worm, which would infect her system with a virus.
·
Opening the attachment would release a passive worm, which would infect her system with adware.
·
Opening the attachment would release a worm, which would infect her system with spyware.
3
Select the true statement about the motherboard.
·
It acts as the working memory of the computer by transferring data from the hard disk for processing.
·
It acts as a storage point for read-only memory (ROM).
·
It executes the commands sent to it by the application software.
·
It provides much of the electrical connection between different computer parts.
4
A series of steps undertaken to reach a goal is known as which of the following?
·
Software
·
A process
·
Hardware
·
Data management
5
Because a computer typically runs a variety of programs simultaneously, the role of the operating system is to ensure that all programs have access to the __________.
·
CPU
·
monitor
·
keyboard
·
power supply
6
Gabriel works on a team that is developing a self-driving car.
What advance in technology best describes this project?
·
Collaborative technology
·
Visualization
·
Artificial intelligence
·
Augmented reality
7
Which statement describes an example of database software?
·
Microsoft Access enables users to create, store, and retrieve records.
·
Microsoft Excel enables users to perform calculations and statistical analyses.
·
Microsoft Word enables users to write and edit text documents.
·
Microsoft PowerPoint enables users to create animated presentations that can be projected on a screen.
8
Which of the following is NOT a challenge of data warehouse design?
·
Performance requirements
·
Internet speed
·
Data quality
·
Determining analytics and reporting
9
Select the true statement about network protocols.
·
A protocol is not required for all data transmissions.
·
A protocol determines how the sending computer notifies the receiving computer about the presence of compressed data.
·
A protocol determines how it will be executed on every networked device.
·
A protocol determines how the sending device notifies the receiving device that there is data to be sent.
10
Select the image of the CPU.
11
All of the following tasks are suitable for automated processes, EXCEPT:
·
Linda must complete several tests and has ample time in which to do so.
·
Parveen has a large budget, and he has other things to accomplish while tests run.
·
Devin wants to ensure that her test results are accurate and reliable.
·
Ranji’s tests must occur quickly, to enable scheduling in the future.
12
Marco travels often and does not have consistent wireless Internet service. He frequently uses his mobile phone service to provide Internet access to his tablet.
Which network type is Marco using?
·
WAN
·
PAN
·
MAN
·
LAN
13
Which of the following is the FIELD in a database table?
·
6/5/1985
·
beextraordinary@email.com
·
Emily Walker
·
Name
14
Victor and Ellen are software engineers working on a popular mobile app. Victor has been in his position for 10 years longer than Ellen, who is a recent graduate.
During the development of a new feature, Ellen expressed her concern that VIctor's proposed code would create instability in the app. Victor told Ellen he would address her concern with their supervisor. When Victor met privately with his supervisor, he claimed that he had discovered the problem, and that Ellen had dismissed it.
Which principle of the Software Engineering Code of Ethics has Victor violated?
·
Principle 8: Self
·
Principle 6: Profession
·
Principle 7: Colleagues
·
Principle 3: Product
15
The standard interface technology for wireless networks is __________. The hardware component necessary for computers to connect to these networks is a __________.
·
wireless-internet protocol; TCP
·
wireless-defined networking; WAP
·
wireless fidelity; WAP
·
transmission control protocol; IP
16
When she manages a software development project, Candace uses a program called __________, because it supports a number of programming languages including C, C++, C#, and Visual Basic.
·
Primavera
·
Zoho Projects
·
Microsoft Project
·
Visual Studio
17
Which of the following can be controlled by copyright?
·
The slogan for a business
·
The team logo for a minor league baseball team
·
A new type of engine for pickup trucks
·
A writer’s new murder mystery on the New York Times bestsellers list
18
Haitham works for a government agency. He is in charge of a team that develops algorithms and models that guide the function of software applications.
What is Haitham's role in his organization?
·
Programming Language Specialist
·
Network Engineer
·
Database Administrator
·
Computer Scientist
19
Select the scenario that describes a top-down approach to data warehouse design.
·
Mike's Decorating creates data marts from several departments, then combines them into a central data warehouse.
·
O'Reilly's Public House, which has locations in seven states, merges the data marts from each location into a single data warehouse.
·
Gilbert's Groceries adds all of the data from its vendor, sales, and human resources departments to the central data warehouse, and then divides it between several data marts.
·
Tyson’s Business Innovations creates data marts for its HR and Payroll departments to resolve an employee compensation dispute.
20
Game Changer Technologies has four software teams. Each of them is developing four different examples of its new game app.
Which software development methodology is used by the Game Changer teams?
·
Prototyping
·
Lean
·
Cascading/V-model
·
RAD
21
IT specialists must possess technical knowledge and work well with others if they are to be successful.
Select the IT specialist who demonstrates a hard skill.
·
Noel monitors a virtual chat program to keep in touch with other members of the IT department.
·
Elizabeth tracks her team's progress on a software development project.
·
Maggie designs a new user interface for her company's master control panel.
·
Freddy uses problem-solving expertise to resolve an issue for the software development team.
22
Select the file size that is the SMALLEST.
·
6,000 GB
·
3 TB
·
90,000 KB
·
2 MB
23
Mel is a research scientist at a health sciences center. His job requires him to analyze large amounts of data in short periods of time.
Select the best computer for Mel.
·
A handheld tablet computer
·
A desktop computer with two screens
·
A desktop computer with a fast processor
·
A portable laptop computer
24
Beth is a software developer who is focused on identifying early-stage interface problems.
Beth addresses the dimension of usability known as __________.
·
satisfaction
·
efficiency
·
error management
·
visibility
25
Sarah is creating custom reports from her company's database.
Select the set of file types that Sarah will use to create these reports.
·
.csv and .pptx
·
.sql and .xml
·
.txt and .dat
·
.tif and .db
1
To which external hardware component does the arrow point in the given image?
·
Touchpad
·
Status light
·
Keyboard
·
Power button
2
Which of the following components is used for data storage?
·
DVD
·
Monitor
·
Keyboard
·
CPU
3
To improve the operating speed of his computer, Richard can use a disk defragmentation program, which is a form of __________.
·
operating system software
·
productivity software
·
integrated development environment software
·
utility software
4
Which of the following is NOT an example of computer software?
·
Windows Media Player
·
ROM
·
Firefox
·
OS X
5
A collection of facts, such as street addresses or phone numbers, is known as which of the following?
·
A process
·
A system
·
A component
·
Data
6
Select the image of the hard disk.
7
Melanie wants to copy a home movie to a storage device that will enable her to play it on her television.
The best storage device for Melanie is a(n) __________.
·
internal hard drive
·
sound card
·
CPU
·
CD/DVD-ROM drive
8
All of the following are examples of integrated computer systems, EXCEPT:
·
Taking a self-driving car to work
·
Storing a group project on "the cloud"
·
Re-setting a home security system using a tablet computer
·
Using a watch to get directions during a morning run
9
Approximately how much storage is needed to save a single digital picture in a 4-megapixel resolution?
·
1 byte
·
1 kilobyte
·
1 gigabyte
·
1 megabyte
10
Select the statement that best describes the a mainframe computer.
·
It could run programs and store data on a single silicon chip, which increased computing speeds and efficiency.
·
It enabled users to organize information through word processing and database programs from their desktop.
·
It enabled people to connect to a central server and share data with friends, business partners, and collaborators.
·
It enabled corporations and universities to store enormous amounts of data, sometimes on devices which occupied an entire room.
11
Which of the following statements about the relationship between hardware and software is FALSE?
·
Computer hardware controls the computer's software by telling it what to do.
·
Computer hardware can be physically touched, while computer software is intangible.
·
Both hardware and software are needed for the computer to function effectively.
·
Computer hardware cannot be used without an operating system.
12
Mel is a research scientist at a health sciences center. His job requires him to analyze large amounts of data in short periods of time.
Select the best computer for Mel.
·
A handheld tablet computer
·
A desktop computer with two screens
·
A desktop computer with a fast processor
·
A portable laptop computer
13
Select the true statement about a scanner.
·
It is a device that enables users to input photographs as digital images.
·
It is a device that outputs digital images and text onto a screen.
·
It is an input device that enables users to convert hard copies to digital images or text.
·
It is a device that enables users to output digital images or text as hard copies.
14
Joan presses a button on her pointing device to select an icon to connect to the Internet.
This process describes the interaction between the __________ and __________.
·
mouse, flash drive
·
touchpad, hard drive
·
touchpad, visual card
·
mouse, ethernet card
15
Criselda is a computer operator. When she turns on her computer, it loads information from the hard disk into the computer's __________.
·
CPU
·
SSD
·
RAM
·
ROM
16
Select the true statement about the motherboard.
·
It acts as a storage point for read-only memory (ROM).
·
It provides much of the electrical connection between different computer parts.
·
It executes the commands sent to it by the application software.
·
It acts as the working memory of the computer by transferring data from the hard disk for processing.
17
Select the file size that is the LARGEST.
·
10 MB
·
1,995 GB
·
1 TB
·
20,000 KB
Which type of network is best for Shayne?
·
MAN
·
PAN
·
WAN
·
LAN
Kirby visited a sweepstakes website and agreed to download a new program. Later, when he tried to use a word processing program, his document files became corrupted.
How can Kirby try to remove the offending program and prevent future attacks?
·
Kirby should run an antivirus program.
·
Kirby should change the password on his computer.
·
Kirby should use WPA network encryption.
·
Kirby should install a biometric reader.
Select the true statement about HTML.
·
HTML is a network protocol.
·
HTML stands for hidden transfer markup language.
·
HTML defines blocks of text to receive URL instructions.
·
HTML enables users to format the components of a web page.
Katelynn and Genevieve want to make flyers to advertise their school's play. They will collaborate on the flyer document online, and remotely.
Which productivity software should they use?
·
Microsoft Access
·
Microsoft PowerPoint
·
Google Sheets
·
Google Docs
A series of steps undertaken to reach a goal is known as which of the following?
·
Hardware
·
A process
·
Data management
·
Software
A collection of facts, such as street addresses or phone numbers, is known as which of the following?
·
Data
·
A component
·
A system
·
A process
Tom surveys the users of a new software product. One of the survey questions asks users to rate their preferences on a Likert scale.
Tom addresses the dimension of usability known as __________.
·
learnability
·
visibility
·
satisfaction
·
efficiency