CGS 2060
How does Access store a "Yes" response for the Yes/No data type?
-1
A common file format that can be opened by many applications is
.csv
To be compatible with Microsoft Word 2003, a Word 2016 document should be saved with this extension
.doc
The file extension for an Office 2016 Word Template is
.dotx
Full HD resolution is expressed as
1920 x 1080
The maximum size of a Short Text field is
255 characters
To reference cells in another worksheet, but in the same workbook, use a
3D cell reference
PMT Function
=PMT(rate, nper, pv, [fv], [type] • rate: interest rate • nper: total number of periods for repayment • pv: present value • fv: future value • type: when payments are being made
PaaS
A programming environment used to develop, test, and disseminate web apps via the Internet
A round button that you click to select one option from a list of options is called
A radio button
In this Office application, you name a file at the same time you create it
Access
A set of steps that describe exactly what the computer program must do to complete the work
Algorithm
Written in natural language and in the form of a flowchart, a programmer uses a _________________ to describe the problem the program will solve.
Algorithm
Ctrl+E
Align center
Ctrl+L
Align left
Ctrl+R
Align right
What is a binary decision?
An either/or point in a flowchart
IaaS
An organization uses servers in the cloud instead of buying and maintaining storage servers for their day-to-day business operations
AJAX stands for ____________________ JavaScript and XML.
Asynchronous
This Excel feature allows you to view totals, averages, or other statistical information without creating a formula
AutoCalculate
This feature recognizes and corrects commonly misspelled words
AutoCorrect
This button opens a list of commonly used statistical functions
AutoSum
The 3rd-generation programming language that most students learned when most computers used MS DOS was _________________. It remains a safe programming language for using 3rd-party code and provides a coding standard that integrates easily with other programming languages.
BASIC
Ctrl+B
Bold
The default font for Microsoft Word is
Calibri
Converses source code (C++, Java, etc.) of entire program into machine language
Compiler
Ctrl+C
Copy
To use an Advanced Filter in Excel, you first need to create a
Criteria range
To select multiple non-contiguous folders or files to copy or move them, use this key
Ctrl
A quick way to insert a new column or row is to select a column or row and press
Ctrl+
This shortcut will create a new folder in a Windows folder
Ctrl+Shift+N
Ctrl+X
Cut
examples of storage media
DVDs, Blu-Ray discs
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the
Data Administration subsystem
An integral part of a database's management system (DBMS) is the Data Definition subsection. This subsection uses a data scheme, also called a
Data Dictionary
When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides data maintenance, analysis, and the generation of reports is called the
Data Manipulation subsystem
The term for specialized Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is
Data visualization
When you need to create a new table from scratch in your database, use
Design view
Purchasing the necessary software for the system is part of the system ________________ step of the SDLC process.
Development
The decision point of a flowchart is represented by a
Diamond
Title, Author, Comments, Subject, Company, Created, and Last Modified are examples of
Document properties
Ctrl+2
Double Space
There are two methods you can use to move text—cut and paste or
Drag and drop
Routers that can send internet signals over 2 distinct frequencies are called ________________ routers.
Dual band
Business management software that encompasses nearly all business activities in a corporation is called
ERP software
The Excel tool button that allows you to step through each part of the formula is called
Evaluate Formula
This common Backstage view task creates a PDF file from an existing file
Export
One way to open the Help dialog box quickly is to press this shortcut key
F1
Enables the current cell's edit mode
F2
A keyboard shortcut that turns a cell address entered into a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses is
F4
A URL identifies a particular ________ address on the World Wide Web
File
To open an existing document, what tab should you click to open the Backstage view?
File
The Windows 10 feature that opens a window on your desktop where you can browse for files stored on your computer is called
File Explorer
The chart feature that allows you to specify which data is shown and which is hidden is the
Filter
After the problem has been clearly defined, the next step in the PDLC is to create a plan or algorithm. This plan is usually written as a _________________ and is written in an ordinary language, such as English.
Flowchart
Uses common arithmetic operations to perform calculations
Formula
Which is not an e-commerce transaction?
G2B
Information Technology system
Hardware and software that allows organizations to perform IT tasks
F1
Help (dialog box)
The Font group is found on this tab on the Ribbon
Home
Where can you add shading to an important paragraph?
Home tab > Paragraph group
Program that converts single lines of higher programming language into machine language, especially when making small changes to a program
Interpreter
Ctrl+I
Italic
The program that uses small programs called scripts to speed the programming process while creating dynamic Web pages is called
JavaScript
A process that has an initial value, a process, and a test condition that can potentially return the program to the initial value is called a
Loop
This technology allows musicians to create written sheet music simply by playing an instrument
MIDI
What is the Program Development Life Cycle (PDLC)?
Method of creating a new software
The word modem stands for
Modulator-demodulator
Which is a strength about the Android platform?
Most widely used OS for smartphones and tablets
Which is a strength of the Windows platform?
Most widely used OS in laptops, desktops, usually leading to lower prices
Ctrl+Home
Move to the beginning
Ctrl+End
Move to the end
Ctrl+N
New Blank File
When Word breaks up words that you want to keep together, fix this by using a
Non-breaking space
A new Excel workbook uses the default theme
Office
Access this free online, scaled-down version of Office 2016/365, from your OneDrive webpage
Office Online
This feature provides a cloud storage area where you can store files in a private and secure online location that you can access from any computer
OneDrive
Ctrl+O
Open
Shift+F12
Open (dialog box)
Which is not protected against by intellectual property laws?
Open educational resources
What manages hardware and software, supports the computer's basic functions, and runs programs?
Operating system
The starting or finishing point of a flowchart is represented by an
Oval
Paul Baran developed a technology called ______________ switching that made the Internet possible and reliable.
Packet
You can modify alignment, line spacing, and paragraph spacing in the
Paragraph dialog box
The input or output point of a flowchart is represented by a
Parallelogram
Ctrl+V
Paste
Which of the following contains a unique value for each record?
Primary key
Ctrl+P
What is the System Development Life Cycle (SDLC)?
Process used to develop and maintain system software
The process of converting a task into commands (software) that a computer (hardware) can use to perform a task is called
Programming
Which type of touchscreen uses a single metallic-coated panel and uses electricity to calculate touch points?
Projective capacitive
Shorthand used by programmers when creating a program
Pseudocode
Because of their capability of storing data in multiple hard drives, data warehouses use ____________________ technology to ensure redundant data storage.
RAID
RFID stands for
Radio-Frequency Identification
The process or procedure of a flowchart is represented by a
Rectangle
Ctrl+Y
Redo
The Spelling and Grammar checking tool is found in this tab on the Ribbon
Review
Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?
Rich Text
This action displays the context menu and the mini toolbar
Right-click
A signal transmitted every few seconds by a wireless router so that users' computers can find the Wi-Fi hotspot is called
SSID
Ctrl+S
Save
F12
Save As (dialog box)
Small programs that perform specific tasks
Scripts
Ctrl+A
Select All
When you want to invite people to view a document online, email it to someone, or publish it as a blog post, use this option in the Backstage view
Share
What feature must be turned on for you to see paragraph breaks, line breaks, spaces, tabs, and other formatting symbols?
Show/Hide
Ctrl+1
Single Space
This Windows feature allows you to quickly position an open window to the left or right side of your computer screen, filling half the screen
Snap Assist
F7
Spelling pane
In Office 2016, you can create a new blank file such as a Word document from the app's
Start page
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
Superscript
A group of related elements that work together to achieve a common goal
System
examples of management information systems (MIS)
TPS, DSS, ESS
This new feature in Office 2016/365 is a specialized search box that displays commands in the Office app related to your search
Tell Me
Which group determines the standards for the World Wide Web?
The World Wide Web Consortium (W3C)
SaaS
The distribution of computer applications over the Internet. Commonly referred to as web apps
When importing data records from Excel, which must be true?
The first row of the Excel file must contain the field names from the Access table
To find a synonym for a word in your document, Word provides a
Thesaurus
The World Wide Web was created through a collaboration led by
Tim Berners-Lee
What are the parts of an RFID system?
Transceiver, transponder, antenna
A computer platform is commonly referred to as an operating system or OS.
True
The platform or operating system of a computer controls all of the functions of a computer.
True
Spam messages are sometimes referred to as
UBE
What type of port do most digital devices use to attach to peripherals?
USB port
Ctrl+U
Underline
Ctrl+Z
Undo
An example of an operating system that makes your computer function and controls the working environment is
Windows 10
database
a collection of integrated/related tables • all student, faculty, and course information for entire school
record
a collection of related fields • all student information stored together
table
a collection of related records • all student information for entire school
Text in a worksheet that displays a name, main title, row or column titles, and other information is called
a label
field
a single unit of data • ex. student name, student ID
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns
an error message that beings with a number sign (#)
When you want to delete characters in a cell to the left of the insertion point, press
backspace
The thin black plus sign pointer is used to
copy cell contents or complete a series
The small computer within your phone that enhances the sound quality of your call is called the
digital signal processor
The art and science of creating output that provides information in the most useful manner is called
ergonomics
When you set field properties, the available properties vary based on the
field data type
When you need to create an interface to view, add, update, and delete data in Access, you should use a
form
When you want column and row headings displayed whether you are at the top or bottom of the spreadsheet, select
freeze panes
You want page numbers to be displayed as "1 of 4," etc. You do this by
going to the Quick Parts button
Arranges a block of text to the inside of the main margin
hanging indent
You need to design a new Access database. The first step is to organize the smallest to largest data, also called
hierarchy of data
Using refracted laser light to store data on a photoreceptive substrate is essentially how ____________________ storage works. Theoretically, this could store gigabytes of data within a cubic millimeter.
holographic
A game controller is an example of
input
Entering text in a Word document is an example of
input
When you select this vertical alignment option, space is automatically added between lines to fill up the entire vertical space between the top and bottom margins
justified
Website data can be imported into Excel if the data is
list-type
Tables and forms are examples of
objects
A projector is an example of
output
Playing a song from Spotify is an example of
output
A type of printer that is used to print large images such as architectural drawings by mechanically moving a pen over a large sheet of paper is known as a
plotter
In a database, the special field that contains a unique value for each record is the
primary key
A rectangular group of cells is called a
range
The color-coded editing tool that applies different colors to each cell or cell range included within a formula is called the
range finder
To display or distribute information from a database, programmers or database administrators create
reports
A hard drive is an example of
storage
Putting a photo on a UDB drive is an example of
storage
To change letters that are uppercase to lowercase and lowercase letters to uppercase, use the
tOGGLE cASE
Access is a relational database, meaning that the data are organized into a collection of related
tables
When you click on a cell to activate it, the cell address appears in
the name box
The most common printers for printing receipts are
thermal printers
Using information systems to help foresee corporate business opportunities and threats might be done by
top-level managers
In an Excel worksheet dates and times are
values
With _______ recognition technologies, frequency, pitch, speech rhythms and other characteristics are charted and compared to existing records
voice
Absolute cell reference
• $B$2 • cell address does not change
Mixed cell reference
• $B2 • column does not change; row updates to new location • B$2 • row does not change; column updates to new location
What are the different programming language generations?
• 1GL: machine language (1s and 0s) • 2GL: assembly language (converts 2GL into 1GL) • 3GL: high-level programming language (uses compiler to convert to 1GL) • 4GL: database management • 5GL: uses statements rather than algorithms
Describe AJAX
• Asynchronous JavaScript and XML • allow data to be exchanged on web without changing display • makes webpages faster
Relative cell reference
• B2 • cell address updates to new location
BASIC v. Visual BASIC
• BASIC: Beginner's All-Purpose Instructional Code • Visual BASIC: GUI version
C v. C++
• C: most popular programming language; structured; easily converts to 1GL; Unix OS • C++: object-oriented version of C; developed for GUI
Excel Extensions
• Excel 2016 (.xlsx) • Excel Macro Workbook (.xlsm) • Excel 1997-2003 (.xls) • Excel Template (.xltx) • Excel Macro Template (.xltm) • Text (.txt) - columns separated by tab • Comma Separated Values (.csv) - columns separated by comma • Document Spreadsheet (.ods) - Open Office and Google Docs • Web Page (.htm, .html)
HTML and HTML5
• Hypertext Markup Language (HTML): allows content to be seen on the web using tags • HTML5: designed for use with tablets, smartphones, laptops, desktops; allows JavaScript and CSS
JAVA and C#
• JAVA: popular for web-based and smartphone apps • C#: popular for Windows phones and Microsoft
Describe JSON
• JavaScript Object Notation • makes data readable by programmers • parsing (changing symbols into their descriptions with words) • parses XML files so they're easier to use
JavaScript and VBScript
• JavaScript: HTML script used to make web pages faster • VBScript: uses Visual BASIC to create Windows apps
Objective-C, Swift, and Cocoa
• Objective-C: object-oriented programming based on C; very difficult to learn/write • Swift: designed by Apple to be easier than Objective-C • Cocoa: used with Swift to allow touch motions on iPhones
3D relative cell reference
• Sheet2!B2 • Cell address updates to new location
What is true about database fields?
• a group of related characters in a database • represents a characteristic of someone or something • primary key is a field designation
What are the functions of a Digital Signal Processor?
• analyzes signals received from the analog-digital converter to enhance audio quality • reduces unwanted noise • moderates call volume
Describe top-down programming design
• breaks a problem down to a series of tasks • each task broken down to binary questions • binary questions solved by the program
What's true about dual band routers?
• can transmit Wi-Fi signals in the 2.4-GHz range • can transmit Wi-Fi signals in the 5.0-GHz range • minimizes the impact of interference from microwave ovens and car alarms
Programming involves
• categorizing which parts of a task a digital device can perform • describing the tasks in a precise manner • translating into the language the computer's CPU can use
What are the characteristics of a router?
• connects networks • provides hardware firewall protection • usually incorporates a switch
What are the steps of PDLC?
• define problem (what should it do?) • create plan (algorithm designed to solve the problem) • write code (converting algorithm into programming language) • debug code • test code
What are the 4 conversion methods of system implementation?
• direct (shuts down old system and starts the new one) • parallel (old and new run simultaneously for a while) • pilot (starts in one area then goes to rest) • phased (implements areas of new system at determined time)
Describe XML
• eXtensible Markup Language • provides smooth interface between natural language and machine language • easier with HTML5 • simplifies transport/display of documents on web
characteristics of Blu-Ray discs
• holds approximately 25 GB of data • uses pits and lands to store data
What 3 steps must be part of a loop?
• initial state • process • test condition
What are the steps of the SDLC?
• investigation (define problem, examine alternatives, report findings) • analysis (data collection, analyze data, prepare system) • design (develop system proposals, select most feasible, report on selected system) • development (procure/develop needed software, obtain hardware, set up/test system) • implementation (converting old system into new system) • maintenance (system audit and routine evaluation)
Word Tab Stops
• left: text is left aligned at tab stop • center: text is centered on the tab stop • right: text is right aligned at the tab stop • decimal: decimal point is aligned at the tab stop • bar: a vertical bar is inserted at the tab stop
Elements of a flowchart
• oval (beginning or end of process) • diamond (decision point) • parallelogram (input/output point) • rectangle (procedure) • arrow (flow direction)
Excel Paste Options
• paste: copies all data/formatting • formulas: copies all data/formulas, but not formatting • formulas & number formatting: copies all data/formulas with formatting • no borders: copies all data/formulas/formatting without borders • transpose: copies data/formatting and reverses data orientation (columns as rows and rows as columns) • merge conditional formatting: copies data and conditional formatting rules (if applied) • formatting: copies only formatting, no data • picture: pastes selectable picture object of the data (static) • linked picture: pastes selectable picture of object (dynamic; reflects edits made in source data)
What is true about utility programs?
• performs a specific maintenance task • included in both Windows and Mac OS • common examples include disk formatting, disk cleanup, and disk defragmenting
The software development process includes
• planning (goals and feasibility) • programming (select language and write the program) • debugging (fix and remove errors) • beta review (send to beta testers)
Describe object-oriented analysis
• programmers focus on inputs to the program • inputs are divided into categories • examples given for each category, called objects
What is true about object-oriented databases?
• store instructions for how to compute the data as well as the data to be processed • equipped to handle unstructured data such as MP4 files, video, images, and extremely large files • uses Object Query Language to construct queries that extract data from the database
What qualities make a trait useful for biometric recognition?
• the trait must not change over time • the trait must be measurably different with each person • everyone must have the trait
Which statements are true regarding Satellite Internet Service?
• uses microwaves • provides broadband service virtually anywhere • customers usually purchase a data plan that limits uploading and downloading
What are the characteristics of a modem?
• usually provided by the ISP • converts analog signals into digital signals • converts digital signals into analog signals
Excel Paste Values
• values: copies only formula results (not formulas) without formatting • values & number formatting: copies only formula results (not formulas) with formatting
