Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 5 Weeks Ago, 3 Days Ago |
Questions Answered: | 7559 |
Tutorials Posted: | 7341 |
BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005
HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017
IT 1500 Unit 2 Challenges Introduction to Information Technology Sophia Course
Click below links for Answers
Challenge 1
An operating system is considered multitasking when it __________.
·a.)
utilizes multiple peripherals at once
·b.)
runs on two different computers at once
·c.)
runs multiple software programs at once
·d.)
supports multiple users at once
_________ is software whose usage is free and whose source code is public, whereas __________ is software that costs money and whose source code is private to the developing company.
·a.)
Graphical, command line
·b.)
Open source, commercialÂ
·c.)
Multiuser, multitasking
·d.)
An operating system, application software
An operating system serves as the bridge between __________ and __________, making sure the resources required to function are allocated.
·a.)
peripherals, memory
·b.)
the GUI, the user
·c.)
hardware, applications
·d.)
open source, commercial
Which of the following are the two main categories of elements within the Windows operating system?
·a.)
Device manager and Windows shell
·b.)
Multitasking and multiuser
·c.)
Productivity software and virtual memory
·d.)
System configuration and user interface
If users wanted to edit some of their basic system settings, they would use __________.
·a.)
the device manager
·b.)
the taskbar
·c.)
the control panel
·d.)
Windows Explorer
Which of the following programs would be used for creating a spreadsheet?
·a.)
Microsoft Excel
·b.)
Microsoft Word
·c.)
Microsoft Powerpoint
·d.)
Microsoft Access
If users wanted to edit some of their basic system settings, they would use __________.
·a.)
the device manager
·b.)
the taskbar
·c.)
the control panel
·d.)
Windows Explorer
Which of the following programs would be used for creating a spreadsheet?
·a.)
Microsoft Excel
·b.)
Microsoft Word
·c.)
Microsoft Powerpoint
·d.)
Microsoft Access
Simultaneously pressing the Windows key and the __________ key is a shortcut that opens Windows Explorer.
·a.)
D
·b.)
E
·c.)
A
·d.)
I
When a computer is off, pressing the power button will initiate __________.
·a.)
Windows Explorer
·b.)
the boot sequence
·c.)
the start menu
·d.)
a shut down
Windows Explorer displays information from ___________ as a hierarchy of drives, folders, and files.
·a.)
ROM
·b.)
the CPU
·c.)
RAM
·d.)
the hard disk
If you have an issue that you are unsure of how to fix, you can use __________, which is a combination of files on your computer and information from the Internet.
·a.)
the help system
·b.)
the system configuration
·c.)
Windows Explorer
·d.)
the taskbar
Challenge 2
____ and __________ software are types of productivity software.
·a.)
Presentation, utility
·b.)
Virtual memory, system configuration
·c.)
Programming, word processing
·d.)
Spreadsheet, presentation
If you wanted to create a text document with a word processor, you could use __________.
·a.)
Open Office Impress
·b.)
Google Docs
·c.)
Microsoft Access
·d.)
Microsoft Excel
Database is a type of productivity software that is used for __________.
·a.)
performing numerical calculations and analysis, as well as creating charts
·b.)
creating high-resolution illustrations
·c.)
entering, retrieving, updating, and reporting information
·d.)
typing, editing, and formatting text and images
Select the example of a software application used appropriately within a domain.
·a.)
A manager uses Microsoft Word to record inventory and make sales queries.
·b.)
A promoter uses Access to design a music poster for an upcoming concert.
·c.)
A marketing manager uses Keynote to share graphics and sales trends with her team.
·d.)
A professor uses PowerPoint to enter exam scores and calculate averages.
Apple's software application Keynote would likely be used to __________.
·a.)
write a report
·b.)
create data charts
·c.)
make a presentation
·d.)
analyze statistics
A __________ is the setting in which a software application is meant to function.
·a.)
database
·b.)
domain
·c.)
spreadsheet
·d.)
category
A __________ is typically a three or four-character suffix on a file name that gives the operating system the information it needs to identify the file.
·a.)
software file
·b.)
data file
·c.)
file manager
·d.)
file format
Which of the following file extensions would be used for a sound file?
·a.)
.aac
·b.)
.csv
·c.)
.wpd
·d.)
.bat
A file is considered to have a foreign file type when it __________.
·a.)
is sent through email before being opened
·b.)
is opened with software that was not used to create the file
·c.)
is opened with the software that was used to edit the file
·d.)
is created in a different language
Challenge 3
The following image is an example of a __________ database.
Â
·a.)
relational
·b.)
qualitative
·c.)
quantitative
·d.)
flat file
A __________ is a way to organize related data in a database using rows and columns.
·a.)
field
·b.)
table
·c.)
tuple
·d.)
record
All data within a database should be __________.
·a.)
qualitativeÂ
·b.)
related
·c.)
in a single table
·d.)
quantitative
Which of the following statements about data types is true?
·a.)
Data types are a classification of what kinds of values a field will hold.
·b.)
All of the answer choices are correct.
·c.)
Data types inform the database on how much memory to allocate for each field.
·d.)
Data types inform the database on what kinds of actions can be performed on each field.
In a table of student data, the __________ field would be used as the primary key because it is a unique identifier that will not change.
·a.)
student ID
·b.)
date of birth
·c.)
last name
·d.)
first name
The __________ is the field in a table that links to the __________ of another table.
·a.)
foreign key, primary key
·b.)
primary key, primary key
·c.)
tuple, foreign key
·d.)
primary key, title
A __________ is a subset of data in a database that answers a given question.
·a.)
query
·b.)
foreign key
·c.)
flat file
·d.)
file extension
Which of the following statements about database management is true?
·a.)
Accessing stored data is integral for business analysis and decision-making.
·b.)
Relational databases do not allow access to the stored data.
·c.)
Single-user databases can be accessed through the Internet.
·d.)
Some databases are accessed through software, while others are accessed through hardware.
If the given database of university students were queried for female students born after 1994, how many records would be returned?
Â
Â
·a.)
Three
·b.)
One
·c.)
Zero
·d.)
Two
The process of analyzing data for trends or patterns to use in decision-making is known as __________.
·a.)
business intelligence
·b.)
data mining
·c.)
business analytics
·d.)
big data
In __________, data is standardized so that all information that is stored and reported is consistent.Â
·a.)
a top-down system
·b.)
data mining
·c.)
a data warehouse
·d.)
business analyticsÂ
When creating a data warehouse, a business must decide whether to start with the creation of data marts in a __________ approach, or to start with the creation of the data warehouse itself in a __________ approach.
·a.)
time-variant, non-operational
·b.)
bottom-up, top-down
·c.)
centralized, performance
·d.)
top-down, bottom-up
Which of the following statements describes the challenge of data quality associated with data warehousing?
·a.)
Data brokers take publicly accessible data, as well as data from the government and additional sources, to create data warehouses of people and companies that they can then sell.
·b.)
Since data enters the data warehouse from multiple sources, there is a concern regarding the consistency and completeness of the data obtained, as well as a concern about duplicate data that may interfere with reporting.
·c.)
It is difficult, but essential, to know what analyses will be performed on the data obtained ahead of time for the purpose of designing a data warehouse that will perform as intended for the needs of the company.
·d.)
It is usually necessary to hire business-intelligence trained technicians who will be able to determine more effectively what the implications of the company's needs and desires are in order to design the best data warehouse.
Which of the following is NOT a feature of web-enabled data warehousing?
·a.)
Analyzing cost-effectiveness of the data warehouse
·b.)
Analyzing the effect of marketing
·c.)
Analyzing affiliated product relationships
·d.)
Analyzing user preferences
Web-enabled data warehousing captures __________ and __________ data in real time, and uses that data in tandem with traditional data to gather more information.
·a.)
publicly accessible, government
·b.)
trend, user preference
·c.)
browser history, screenshot
·d.)
screenshot, clickstream
If an application is unresponsive, you can use the __________ to check its performance and force quit the application.
·a.)
task manager
·b.)
control panel
·c.)
device manager
·d.)
file folder
If you have an issue that you are unsure of how to fix, you can use __________, which is a combination of files on your computer and information from the Internet.
·a.)
·
the help system
·b.)
·
the system configuration
·c.)
·
Windows Explorer
·d.)
·
the taskbar
When a computer is experiencing lag, it is usually a __________ problem.
·a.)
·
file management
·b.)
·
system performance
·c.)
·
software
·d.)
·
programming
Â
Â
IT -----------150-----------0 U-----------nit----------- 2 -----------Cha-----------lle-----------nge-----------s I-----------ntr-----------odu-----------cti-----------on -----------to -----------Inf-----------orm-----------ati-----------on -----------Tec-----------hno-----------log-----------y S-----------oph-----------ia -----------Cou-----------rse-----------