Types of Errors — Cumulative exam Answers

2 verified answers
21
Free Preview

A real-world use of a word processing software template is

A
a contract for leasing an apartment.
B
a bulleted list of books that are needed for a professor’s classes.
C
a science fiction short story.
D
an accounting of how you spent your money.
22
Free Preview

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?

Question illustration
A
=IF(E3>E8, “Exceeded”)
B
=IF(E3>$E$8, "Exceeded")
C
=IF(AVERAGE(E3:E6)>E8, “Exceeded”)
D
=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)
23

Which statement is true?

A
A completed algorithm is important because it communicates the instructions of the solution.
B
Modeling a solution is important because it is the ending point for all other activities.
C
Diagramming a solution is important because it shows all solutions for the problem.
D
Pseudocode is important because it gives a graphical representation of the process.
24

A spreadsheet is the best choice to

A
keep track of employees’ work hours and salary for computing the payroll.
B
identify voters who will receive political literature for the party to which they belong.
C
keep track of the location of products in the warehouse using department and item codes.
D
keep track of customers and their product preferences to send the correct catalogues to them.
25

What does this loop that uses a range function do? for i in range(7, 15):print(“goodbye”)

A
It prints “goodbye” 8 times, numbered from 7 through 14.
B
It prints “goodbye” 9 times, numbered from 7 through 15.
C
It prints “goodbye” 9 times.
D
It prints “goodbye” 8 times.
26

Dinah is using an IDE to write, modify, and save code. Which tool should she use?

A
a source code editor
B
a build automation tool
C
a compiler
D
a debugger
27

A Products table and an Orders table have several linked records that are joined by a cross-referencing table named ProductsOrders. What kind of table relationship do these tables demonstrate?

A
one-to-one
B
one-to-many
C
many-to-many
D
many-to-none
28

What is an Integrated Development Environment (IDE)?

A
a coordinated software development effort
B
a coordinated software program writing package
C
a diverse workplace for software developers
D
a diverse workplace for all employees in a software development company
29

In computer programming, what is syntax?

A
a set of rules that helps structure a program correctly in a specific programming language
B
a set of rules that helps test a program step-by-step to identify bugs in code
C
a type of programming language
D
a type of debugging tool
30

Which of the following is a unique feature of Object-oriented programming?

A
They have syntax.
B
They are web-based.
C
They use objects that contain data and functions.
D
They are interpreted by compilers into binary machine language.
31

Use the conversion table below to help you answer the question.Which choice represents a correct conversion of the hexadecimal value “CAB”?

Question illustration
A
the decimal string 12 10 11
B
the octal string 14 13 12
C
the binary string 1100 1101 1110
D
the octal string 12 13 14
32

Mr. Stevens is the principal of a high school. Why might he want to export data from a database of students’ exam scores?

A
to create a presentation using other software on how students’ scores have changed throughout a semester
B
to view the student data in a new database
C
to query the database and sort students into groups according to their scores
D
to append additional student records to the database
33

A software development team must choose a type of programming design that will provide them with the ability to make changes to the code at any time during the development cycle. Also, the design must enable the developers to easily reuse code in other programs. What programming design should the team choose?

A
structural
B
object-oriented
C
objective
D
top-down
34

Read the Modern Language Association (MLA) citation listed on the works cited page of a research paper.Bingham, Edwin. Gardens of the East. Chicago: AgriPublishers, 2003. Print. The writer references page 19 of this book in his paper. How should the in-text citation appear?

A
(Gardens 2003)
B
(Bingham 19)
C
(Bingham 2003)
D
(Gardens 19)
35

Which function can be used to insert the current date into a spreadsheet?

A
DATE
B
TODAY
C
MM/DD/YYYY
D
DATE&TIME
36

Read the code below. What will the computer print if the input for year_variable is 1700?if year_variable == 1776: print("Your answer is correct. The Declaration of Independence was signed in “year_variable”.")elif year_variable 1776: compute_variable = year_variable - 1776 print("Subtract “compute_variable” years from your answer for the correct answer.")

A
Your answer is incorrect. The Declaration of Independence was signed in 1776.
B
Subtract 76 years from your answer for the correct answer.
C
Add compute_variable years to your answer for the correct answer.
D
Add 76 years to your answer for the correct answer.
37

Two programmers wrote very similar code. Compare the two to decide what the difference will be between them.Programmer A Programmer Bdef drawUnknown(): x = 20 pendown() forward(x) penup()def drawUnknown(): x = 50 pendown() forward(x) penup()

A
Programmer A draws a shorter line than Programmer B.
B
Programmer A draws a circle, while Programmer B draws a square.
C
Programmer A draws a longer line than Programmer B.
D
Programmer A draws an H, while Programmer B draws an E.
38

The introduction of the 8-bit computer expanded the number of bytes available for encoding. This led to the development of

A
octets.
B
Apple and Xerox.
C
ASCII.
D
Unicode.
39

Which is a real-world example of a procedure?

A
calculating the tip given the total at a restaurant
B
pressing submit and getting a new password
C
dividing to determine the number of cookies to distribute to each guest
D
getting up and dressing before school
40

The process of bringing data or a file from one program to another is called

A
exporting.
B
importing.
C
querying.
D
reporting.

Did you find these answers helpful?