CGS Final

What is an advantage of a WI-Fi only tablet over a cellular enabled tablet

Wi-Fi only tablets do not require a data plan

What is the common image file formats?

- .jpg - .png

What are advantages of using a database instead of traditional filing system.

- A database can hold larger amounts of data - A database can provide improved data integrity

What are the usual tasks of data analysts?

- Creates reports for senior management -Collects data -Interprets information provided by the database

What are characteristics of networks?

-Allows users to share resources which saves money and time -Provide the ability to share files and information -Allow users to access other networks and the Internet

What are functions of a digital signal processor?

-Analyzes signals recieved from the analog digital converter to enhance audio quality -Moderates cell volume -Reduces unwanted noise

What are examples of a tablet computer?

-Apple iPad Pro -Samsung Galaxy Note Pro -Amazon Fire HD 8

What is an advantage of using a cellular network instead of a Wi-Fi network when connecting a smartphone to the Internet?

-Cellular networks are accessible from more places. -Can connect to internet in more places

What are characteristics of IOS?

-Comes with Siri, iTunes, iBooks, etc. -Developed by Apple for Apple products -Used on iPhones and iPods

When you need to link 2 tables in a database that don't have a field in common, one solution is to create a _____ field in one table that links to the primary key in the other table.

-Foreign Key

What extension will probably install software onto your computer when opened?

.exe

What extensions represents an executable file that is used to install programs onto your computer?

.exe

What is the typical order of size with these categorization features?

1. Directory 2. Folder 3. Subfolder 4. File

What is the correct order if you want to reply only to the sender of an Outlook message?

1. Go to the Outlook site, login in necessary 2. Click Inbox to see your messages 3. Click the message you wish to reply to 4. Click to Reply or Reply all 5. Type your response and click Send

What are the steps to upload a file to a OneDrive?

1. Open OneDrive and login if necessary 2. Click Upload at the top of the page 3. Select the file you wish to upload 4. Click Open

Creating a google drive takes _ steps.

2

How many hours of video are uploaded to YouTube every minute?

300 years (about 2.5 years of video per hour)

What is the difference between 3G phone and 4G?

3G is better if you need a phone just for calling and texting (will save you money) 4G phones are better for streaming video and audio.

A typical laptop has a storage capacity if approximately ____.

500 GB - 1 TB

What is roaming?

A setting for phones used in areas where home networks have no coverage

What is a Base Transceiver Station?

Also known as Radio Base Station. Connected to a cell tower. Broadcasts low-power microwave signals to create "cells" of coverage. Sends cell phone signals to Mobile Switching Station

If you have 2 folders open on your desktop and you want to copy a file from one folder to the other, hold down ___ and drag the file.

CTLR

When you visit a web page, your computer and web browser act as a ____ because the computer is requesting Internet access from your IPS and web browser is requesting the web pages from the web server that hosts the website.

Client

What element of database field specifies the data in a field such as text, numeric, or date/time?

Data Type

One disadvantage of cloud storage is that...

Data is only available when you're online.

When connected to a Wi-Fi signal, a cellular-enabled tablet computer ____ inur cell phone plan data usage charge.

Does not

What is the category of management information systems (MIS) focuses on corporate database drill-down capabilities?

ESS (Executive Support Systems) also known as EIS (Executive Information Systems)

What are different storage devices?

External hard drive (tetrabytes of data) Optical drives USB Drives

The ____ is used for transmitting large files from one server to another over the Internet.

File Transfer Protocol (FTP)

Use information systems for recording line employee performace

First Level managers (supervisors, floor managers)

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 _____.

Hierarchy

The role of installing, maintaining, repairing and replacing information system hardware and software typically falls to the _____. - database administrator (DBA) - data analyst - information systems (information technology) technician - information systems (information technology) program manager

Information systems (information technology) technician

Because Microsoft Access includes not only the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ______ System. Note: (DBMS)

Management

Use information system for communicating policies and performance reports up and down the corporate ladder

Middle Managers

What are some features of a DVD?

Often used for movie rental -2.5 GB

Even though it is legal, which of the following would likely be prohibited by a typical business computer-use policy?

Online personal shopping

What type of business would benefit most from having cellular enabled tablets rather than traditional tablet computers?

Package delivery service

One way to copy a folder to a new location is to right click the folder and select Copy, then move to the new location, right-click and select ______.

Paste

A programming environment used to develop, test, and disseminate web apps via the Internet is called ____-as-a-Service.

Platform

Which category of management information systems (MIS) focuses on tracking sales and inventories? -TPS -EIS -ESS -DSS

TPS

A collection of related records in a database is referred to as a ____.

Table

IP Addresses are assigned by _____.

The Internet Corporation for Assigned Names and Numbers (ICANN)

Use information systems to foresee corporate opportunities and threats

Top level management (business executives and presidents)

What is data integrity?

Used to describe the accuracy and consistency of the information in a database.

What software comes with Google Drive accounts?

Word Processing Presentation Software Spreadsheet Software

In order to change sound waves into digital signals, smartphones contain ___ digital converters. Note: DAC's

analog

Because smartphones are computers and have many of the same security risks as computers, you should have ____ software on your phone

antivirus

A whole in a punch card, a transistor on a circuit board, or the reflective element on a DVD each represents the smallest unit of data storage called a _____. -byte -bit -dot

bit

Some new laptops come with an L3 _____ with a capacity of up to 8 MB.

cache

Emailing a file to yourself is an example of using ___ storage.

cloud

Using online servers to store data is called _____ storage.

cloud

When Wyatt, Kevin, Sally, and Casey are all on the same business phone call, it's referred to as ___.

conference calling

Because it can store virtually unlimited amounts of data that can be shared across network, and because the data can be kept far more accurately, a ____ has many advantages over a traditional filing system.

database

Becky wants to organize and sort her wedding invitation list according to groom's guest, bride's guests, out-of-town guests, and estimated wedding gift value. For this reason she is using a relation

database

When you ____-click a file Windows should automatically open it. If it can't Windows will prompt you to select the correct app to open the file.

double

Most laptops have hard drive capacities measured in ___ or terabytes.

gigabytes

When programmers design a database, they start by determining what data or characters will be entered. Next, they decide what fields would best organized this data. With this, records and tables can be created, eventually building an entire database _____.

hierarchy

Network Intruder Detection System (IDS) often have areas known as "padded cells" or ________, that are easy to hack into and are used to catch hackers.

honeypots

In order to sync your iPhone to you MacBook you must first open the ____ app.

iTunes

Facebook Messenger, Viber, Kik Messenger, Snapchat, and WhatsApp are example of ___ messaging sites.

instant

DVDs have pits and lands that absorb or reflect a ____ beam. DVDs can store approximately 4.5 GBs of data (single layer).

laser

Sometimes used in smaller business networks, employee ______ software is impractical for large networks because of the number of users and the potential for misuse. -safety -security -managing -monitoring

monitoring

What is a popular audio (music) file extension.

mp3

Telephones were connected using circuit switching while Internet uses _____.

packet switching

DSL Internet Service Providers use ___ lines to bring you Internet service.

phone

When you see the extension .pptx, you know that the file is a _____ presentation.

powerpoint

In a relational database, an important field that contains a unique value that identifies each record as individual is the ____ key.

primary

One way to create a new folder is to ___ click on any area in the Contents pane, and then click the "New" and "Folder"

right

Dennis is using Microsoft Windows and needs to find a specific file. To look for a file just type the name in the ____ box.

search

If your actual Internet speed is ____ than your ISP's advertised speed, you should contact your ISP.

slower

While not a required step in sending an email, it's still wise to always ____ any message before clicking "Send".

spell check

"Thumb-sucking" refers to stealing information from a network using a _____.

thumb drive

A form of Email fraud where criminals change the account where money is being transferred is called a _____ - wire scam.

wire

If you own a small business, what can you do to ensure your computers and data is kept secure?

- Keep software update, particularly antivirus software - Backup your data regularly - Physically secure computers to minimize risk of theft

In order to ensure that employees understand what's appropriate and what's inappropriate use of company computer equipment, software and networks, employers must set ethical computer use standards. This includes

-Instructing employees on standards -Enforcing by creating firewalls, monitoring protocols, and filters -Periodically reviewing computer-use policies

You own a pet care center. What fields might you enter when you create table for the dogs that you care for?

- Owner's address - Owner's last name - Pet's name

What are some features of a CD?

-Often used in album sales - 700 MB

Sometimes called "cell phone carriers" or "mobile network operators", cell phone _____ cell subscriptions for cellular service.

providers

The roles of ensuring an organization's sensitive information is kept safe, keeping an organization's networks secure, and developing security measures for an organization's IS typically falls to the informationo system ___ manager.

security

What is measured in petabytes? a. server bak b. 40 Blu-ray movies c. single letter d. 4 books e. 20 music CDs f. short email

server bank

In general, the ____ the access time, the faster the hard drive. a. shorter b. longer

shorter

What are the following ways you can create a new folder in Windows?

-On the command bar, click *New Folder* - Right- click any blank area in the Contents pane. Click New and then click Folder -Right-click a folder in the folders list. Click New and then click Folder.

Why should someone compress a file?

-Reduce bandwith needed to transmit a file -Reduce storage space requirements

What are characteristics of SSD storage?

-Uses flash technology -Has no mechanically moving parts -Uses the same technology that is found in USB drives (thumb drives) -Uses electronic circuits (transistors and capacitors) to store data

What are reasons to purchase broadband internet service?

-You want to stream music or video -You need relatively high-speed Internet service - You have several devices online at the same time

What file extensions is commonly used for term papers and other word processing tasks?

.docx

What are the steps in order to store a file on Google Drive?

1. Open your Google Drive account (sign in if necessary) 2. Click on New to open the drop-down menu 3. Select File upload 4. Browse to the file and click Open

What is Software as a Server or SaaS?

Commonly referred to as web apps Refers to the distribution of computer applications over the internet ex. Microsoft 365 Has an advantage over installing software on each device including frequent updates and apps that are delivered on demand

In order to keep your files organized, it's a good idea to create ____ and place your files in them.

Folders

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ____.

Query

Because of their capability of storing data in multiple hard drives, data warehouses use ____ technology to ensure redundant data storage. a. CPU b. RAID c. Blu-ray d. laser

RAID

Which of the following activities would a typical accounting department need a strong information system? -Online sales and advertising -Records keeping and reporting -Determining current investment values -Accessing decision making software

Records keeping and reporting

To display or distribute information from a database, programmers or database administrators create _____.

Reports

To rename a folder in windows a person should ___ on the folder and then click "Rename"

Right Click

Examples of management information systems (MIS) include: -DSS -MBA -ESS -TPS

-DSS -ESS -TPS

Errors in data occuring while entering, reading, processing, storing, or transmitting is known as what?

-Data corruption

What are commonly used names for USB drives?

-Flash drives -Thumb drives

What are popular video compression formats?

-MPEG-2 (lossy)- used in the commercial DVDs -AVI (.avi)- Microsoft video format -MPEG-4 (.mp4)- Used by individuals to compress videos - QuickTime (.mov)- Apple video format

What are examples of a Database Management System (DBMS)?

-Microsoft Access -Oracle Database -Microsoft SQL Server

What are some features of a Blu-ray discs?

-Often used to store hi-definition movies -25 GB