Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CIS 105 > Final Exam > Flashcards

Final Exam Flashcards

1
Q

CPU

A

Central Processing Unit sometimes referred to as the brains of the computer because it controls all the functions preformed by the computers other components and process all the commands issued to it by software instructions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

System Unit:

A

The metal or plastic case that hold all the physical parts of the computer together, including the computer’s processor, memory, and multiple circuit boards that help the computer to function.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Motherboard

A

A special circuit board in the system unit that contains the central processing unit, the memory chips, and the slots available for expansion cards, in which all the other circuit boards connect to in order to receive power and communicate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Buses

A

Communication pathways that transfer data between components inside a computer OR A system of networking connections in which all connections are connected in sequence by a singular cable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Expansion Cards

A

Additional cards inserted into slots on the motherboard to enhance a computer’s capabilities. AND A circuit board with specific functions that augment the computers basic functions and provide connections to other devices.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Ports

A

Connection points on a computer for external devices like USB, HDMI, and Ethernet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Modem

A

A device that connects a network to the internet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Input Devices

A

A hardware device used to enter, or input, data and instructions into a computer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Monitors

A

Display screens using Liquid Crystal Display (LCD) or Cathode Ray Tube (CRT) technology

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Output Devices

A

A device that sends processed data and information out of a computer in the form of text, photo, sound, or video

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Moore’s Law

A

A prediction, named after Gordon Moore (the cofounder of intel) which states that the number of transistors on a central processing unit chip will double every two years

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the three types of Specialty Computers:

A
  1. Mainframe- a large, expensive computer that supports many users simultaneously.
  2. Supercomputer- a specialty designed computer that can preform complex calculations extremely rapidly
  3. Embedded Computer - a specialty designed computer chip that resides in another device
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Computer Generations

A

Programing Languages are classified in several groupings, sometimes referred to as generations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Data Measurement

A

Bit (smallest unit of data), Byte (8 bits), Kilobyte (1000 bytes), Megabyte (1000000 bytes), Gigabyte (1000000000 megabytes).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Bit

A

smallest unit of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Byte

A

8 bits

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Kilobyte

A

1000 bytes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Megabyte

A

1000000 bytes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Gigabyte

A

1000000000 megabytes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Data Transmission

A

Process of sending data electronically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Major Computer Functions

A

Input, Processing, Output, and Storage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Primary Storage

A

Also known as main memory, it holds data currently in use by the CPU

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are the types of Primary Storage

A

RAM (Random Access Memory), Cache Memory, and the internal computer hard drive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Characteristics of Primary Storage

A

active storage, temporary, volatile, faster to access, and has less capacity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Secondary Storage

A

Stores data not immediately needed for processing, providing long-term storage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What are types of secondary storage

A

Hard Disk Drives, SSD, CD-ROM, CD-R, CD-RW, DVD, Flash Drive.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Characteristics of Secondary Storage

A

passive, permanent, non-volatile, slower, more capacity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What are the two types of secondary storage

A

System Software and Application Software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What is Application Software

A

The set of programs on a computer that helps a user carry out task such as word processing, sending email, balancing a budget, creating presentations, editing photos, taking a online course, and playing games.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What is System Software?

A

The set of programs that enables a computer’s hardware devices and application software to work together. This includes both the Operating System and the Utility programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What is the User Interface?

A

Part of the operating system that enables individuals to interact with the computer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

GUI

A

Graphical User Interface unlike the command and menu-driven interfaced used in earlier software, GUI’s display graphics and use the point-and-click technology of the mouse and curser, making them much more user friendly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Operating System

A

The system software that controls the way in which a computer system functions, including the management of hardware, peripherals, and software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Utility program

A

Utility programs are small programs that preform many of the general housekeeping tasks for the computer such as system maintenance and file compression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What are standard utility programs

A

Disk Cleanup, Antivirus, File Compression, Backup Software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

What does www. mean

A

World Wide Web

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Internet

A

A network of networks that’s the largest network in the world connecting billions of computers globally

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Intranet

A

A private network set up by a business or an organization that’s used by an exclusive group.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

ISP

A

Internet Service Provider is a company that specializes in providing Internet Access. These may be specialized providers or companies that provide other services in addition to Internet access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

HTTP

A

http:// is a Hypertext Transfer Protocol which allows files to be transferred from a web server so that you can see then on your computer by using a browser

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

HTTPS

A

https:// is Hypertext Transfer Protocol Secure which is the internet protocol that ensures data is sent securely over the web

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Protocol Networks

A

Set of rules governing data exchange between devices in a network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

What are the components of a network

A

Network Adapter, Network Operating System, Network Transmission Media, Network Navigation Devices

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Firewalls

A

a software program or hardware device designed to prevent unauthorized access to computers or networks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Virus

A

a computer program that attaches itself to another computer program (known as the host program) and attempts to spread itself to other computers when files are exchanged

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

Logic Bombs

A

a computer virus that runs when a certain set of conditions is met, such as when a program is launched a specific number of times
Time Bombs: a virus that is triggered by the passage of time or on a certain date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Worms

A

A program that attempts to travel between systems through network connections to spread infections. Worms can run independently of host file execution and are active in spreading themselves

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Trojan Horses

A

A computer program that appears to be something useful or desirable but at the same time does something malicious in the background without the users knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

Spyware

A

An unwanted piggyback program that downloads with the software you want to install from the Internet then runs in the background of your system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

Zombies

A

A computer that is controlled by a hacker who uses it to launch attacks on other computer systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

Quick Access Toolbar

A

A feature that provides one-click access to commonly executed tasks. It is hidden by default but displays under the ribbon when activated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

Ribbon

A

The command center of Office applications. It is the long bar located just beneath the title bar containing tabs, groups, and commands

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

Tabs

A

Located on the ribbon, each tab is designed to appear much like a tab on a file folder, with the active tab highlighted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

Group Structure

A

The organization within the tabs that allows for locating tabs easier

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

Borders

A

A border is a line style you can apply to individual cells, to a entire table, or individual areas within a spreadsheet or table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

Shading

A

A background color that displays behind text in a paragraph, page, or table element

57
Q

Bullets

A

The command that starts a bulleted list to separate key ideas within a large text block

58
Q

Line Spacing

A

Located on the HOME tab, line spacing is the amount of space located between consecutive lines of text

59
Q

Justification

A

Located on the HOME Tab, the justification of a document is the alignment of the document which can be left aligned, middle aligned, right aligned, or justified (perfectly equal between the left and right margin)

60
Q

Hard Returns

A

A hard return is the start of a new paragraph, or whenever the ENTER Key is used.

61
Q

Soft Return

A

A soft return is the action of returning to the left of the page due to running out of space, not the use of the ENTER key

62
Q

crtl+Home

A

Moves to the Top of the Page

63
Q

ctrl+End

A

Jumps to end of the document

64
Q

Format Painter

A

A feature that enables you to quickly and easily copy all formatting from one area to another

65
Q

Headers

A

A amount of text that appears at the top of every page within a document

66
Q

Footer

A

A amount of text that appears on the bottom of every page within the document

67
Q

Cover Page

A

The first page of a report, which includes the report title, author, and other identifying information

68
Q

Page Numbers

A

Normally in a corner of a page, notates what page of the document you are located

69
Q

Selecting a word

A

Double Click on word

70
Q

Selecting a paragraph

A

Triple Click

71
Q

Select-then-Do

A

The process of selecting the text then applying the command

72
Q

Page Layout

A

The customization of the appearance of the document

73
Q

Table

A

A grid of columns and rows that organizes data

74
Q

Tab Stops

A

A marker on the horizontal ruler specifying the location where the insertion point stops after Tab is pressed to align text in a document

75
Q

Hanging Indent

A

A setting that aligns the first line of a paragraph at the left margin, indenting lines in the paragraph

76
Q

View Rulerq

A

Shows the ruler around the outside of the document

77
Q

Cell

A

The intersection of a column and row

78
Q

Formula

A

A combination of cell references, operators, values, and/or functions used to preform a calculation

79
Q

Function

A

A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments

80
Q

Auto-Sum

A

A way to quickly apply basic aggregate functions to a continuous array of values

81
Q

Auto Fill

A

A feature that completes a sequence of months, abbreviated months, quarters, weekdays, weekday abbreviations, or values. Auto Fill can be used to fill or copy a formula down a column or across a row

82
Q

Fill Handle

A

A small green square at the bottom-right corner of the active cell. You can position the pointer on the fill handle and drag it to repeat the contents of the cell to other cells or to copy a formula in the active cell to adjacent cells down the column or across the row

83
Q

Absolute References

A

A designation that indicates a constant reference to a specific cell location; the cell reference does not change when you copy the formula

84
Q

Relative Refrence

A

A designation that indicated a cell’s relative location from the original cell containing the formula; the cell reference changes when the formula is copied

85
Q

What are the three types of data entered into a spreadsheet?

A

Text, Numbers, Dates

86
Q

Name Box

A

A rectangular area that displays the address (or name) of the active cell, selected chater, or selected table. Use the name box to go to a cell or table; select a range; or assign a name to one of more cells

87
Q

Formula Bar

A

A bar that shows the contents stored in the active cell. You enter or edit the cell content here

88
Q

What does #### mean?

A

Indicates that the cell contents are too long to fit in the cell. Adjust the column width to display the full content.

89
Q

What are the different types of charts

A

Column Chart
Bar Chart
Pie Chart
Line Chart
Combo Chart

90
Q

Select Data

A

click and drag to select multiple cells

91
Q

How to Name a cell range

A

Select Range
Click Formulas
Create from Selection
Create names in Selection Box
Click Ok

92
Q

How to create a pivot table

A

Select data range, go to Insert > PivotTable, choose location and fields.

93
Q

How to select non adjacent cells?

A

Ctrl+ select cells

94
Q

How to display formula within a cell?

A

Ctrl

95
Q

How to name a database and criteria in excel?

A

Here’s how to name a database range and set criteria in Excel:
1. Name the database range
Select the range to name, including the row or column labels. Then, click Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkboxes that indicate the location of the row or column headers. For example, if the table only has a header row at the top, select Top row.
2. Set criteria
In the criteria cells, you can set criteria by typing the exact value, using cell references, or using defined names:
Exact value: Type the value directly into the criteria cell.
Cell reference: Use a formula like $D$1 to use the value of cell D1 as the criteria.
Defined name: Use a formula like =CritVar to use a defined name like “CritVar” as the criteria. You must use quotation marks to avoid Excel interpreting the information as a text string

96
Q

How to record a Macro

A

Navigate to View > Macros > Record Macro, name the macro, assign a shortcut key, perform actions, stop recording.

97
Q

How to run a macro

A

Access macros through View > Macros > View Macros, select the macro, and click ‘Run’.

98
Q

VBA

A

A programming language used in Excel for creating macros and automating tasks.

99
Q

SUM()

A

Adds a range of cells

100
Q

AVERAGE()

A

Averages a range of cells

101
Q

MAX()

A

Returns the largest value in a range of cells

102
Q

MIN()

A

Returns smallest value in a range of cells

103
Q

IF()

A

Performs a logical test and returns one value for a true result, and another for a false result

104
Q

LOOKUP()

A

Searches for a value in the first column of a table and returns a value in the same row from another column.

105
Q

PMT()

A

Calculates the payment for a loan based on constant payments and a constant interest rate.

106
Q

DSUM()

A

Adds the numbers in a column of a list or database that meets multiple criteria.

107
Q

NOW()

A

Returns the current date and time

108
Q

TODAY()

A

Returns the current date

109
Q

DSUM()

A

Takes total of a database

110
Q

DAVERAGE

A

Takes average of a database

111
Q

DMIN()

A

Takes minimum of a database

112
Q

DMAX()

A

Takes maximum of a database

113
Q

DCOUNT()

A

Counts the amount in a database

114
Q

DBMS

A

Database Management System

115
Q

Field

A

The smallest element contained in a table, such as first name, last name, address, and phone number

116
Q

Record

A

A group of related fields representing one entity such as data for one person, place event, or concept

117
Q

Database

A

A collection of data organized as meaningful information that can be accessed, managed, stores, queried, sorted, and reported

118
Q

Primary Key

A

The field that uniquely identifies each record in a table

119
Q

Foreign Key

A

A field in a related table that is the primary key of another table

120
Q

Relationships

A

The connection between categories in a database and how they connect to another database.

121
Q

Query

A

A question about the data stored in a database, with answers provided in a data sheet

122
Q

What are the types of sorts

A

Ascending or Descending

123
Q

What is filter by selection?

A

A selection filter displays in data sheet view only the record that exactly mat the criterion you select are showcased. Access uses the current selection as the criteria. Used for finding records that contain criterion

124
Q

Filter by Form

A

Filter by form is a more versatile methos as it enables you to display records based on multiple criteria. All the records are differ and access creates a blank form then you select the criteria you would want to see.

125
Q

Calculated Field

A

a field that displays the result of a calculation that is based on an existing field or fields in the database

126
Q

How to make a calculated field by function?

A

Add function into the expressions builder then fill in the arguments where a placeholder is

127
Q

How to make a calculated field in builder?

A

Open builder then type the function

128
Q

Aggregate Function

A

preforms a calculation on an entire column of data and returns a single value

129
Q

Total Row

A

enables you to use and aggregate function in one of more columns of data table or a query result without having to change the design of the query (Calculates grand totals)

130
Q

Totals Query

A

calculates subtotals for groups of records (calculates totals of groups)

131
Q

Types of Macros in Access

A

Data Macros and Embedded Macros

132
Q

Code Window

A

The area in the Visual Basic Editor where you write and edit VBA code.

133
Q

Design Time

A

The period when you are creating or editing a VBA program.

134
Q

Run Time

A

The period when a VBA program is running and executing commands.

135
Q

Procedures

A

Blocks of VBA code that perform a specific task.

136
Q

Declaring a Variable or Constant

A

Specifying the data type and name of a variable or constant in VBA.

137
Q

Comments and Keywords

A

Text in VBA code that provides information about the code and are not executed.

138
Q

Decision Structures

A

Control structures in VBA that allow you to make decisions based on conditions.

CIS 105 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions