ÁªÏµ·½Ê½

• QQ£º99515681
• ÓÊÏä£º99515681@qq.com
• ¹¤×÷Ê±¼ä£º8:00-23:00
• Î¢ÐÅ£ºcodinghelp2

Äúµ±Ç°Î»ÖÃ£ºÊ×Ò³ >> CS×÷ÒµCS×÷Òµ

ÈÕÆÚ£º2021-02-16 11:35

THE UNIVERSITY OF AUCKLAND

SECOND SEMESTER, 2020

Campus: City

COMPUTER SCIENCE

An Introduction to Practical Computing

(Time Allowed: TWO hours)

NOTE:

Calculators are NOT permitted.

There is space at the back for answers that overflow the allotted space.

Surname Model

Preferred Name

Student ID

Question Mark Out Of

1 - 10 Short Answers 30

11 Programming using Python 15

13 HTML5/CSS 20

14 LaTeX 20

TOTAL 100

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 2 of 21

Answer all questions in this section in the space provided. If you run out of space, please use

the Overflow Sheet and indicate in the allotted space that you have used the Overflow Sheet.

1. Artificial Intelligence (3 marks)

What argument is Searle making in his Chinese Room discussion about the nature of

intelligence and how it applies to Artificial Intelligence programs?

Searle is making the argument that simple symbol manipulation, e.g.

looking up a symbol in a table and copying over its entry, such as is

done in the Chinese Room discussion, does not represent understanding

the meaning of the symbol. Searle¡¯s argument is that this is what AI

programs do. The crux of the argument is to counter Turing¡¯s position

that if that we need to look at the entity as a black box and if its

performance seems intelligent, that for our purposes, we can call it

intelligent. However, Searle is saying that we cannot simply go by its

performance, we have to go inside the black box and see if its

performance goes beyond mere syntactic symbol manipulation.

(3 marks)

2. Software Licences (3 marks)

What is the main difference between software that is freeware and open source software?

The main difference between freeware and open source software is

that freeware¡¯s source code is proprietary and not publicly available

whereas open source software¡¯s source code is publicly available and

can be used to create new software.

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 3 of 21

3. Digital Games (3 marks)

Give an example of a stochastic board game and of a non-stochastic board game, and

discuss how they exemplify their type of board game.

An example of a stochastic board game is stratego and an example of a

non-stochastic board game is chess. In non-stochastic board games, all

board information is known by both players and the immediate result

of an action can be correctly predicted by both players. In stochastic

board games, some board information is not known by both players and

this usually means that the immediate result of an action cannot be

correctly predicted by both players.

In stratego, there is some board information that is only known by one

player, e.g., the identity of his pieces when they have not attacked or

been attacked, while there is also information that is known to both,

e.g., the location and ownership of pieces. This means that an attacker

does not always know what the outcome of an attack will be before he

executes the attack.

In chess, all board information is known by both players, so each player

knows exactly the immediate result of their action, e.g., if they move a

piece to a specific location containing an enemy piece, then they

capture that piece.

3 marks)

4. Computer Hardware (3 marks)

Which component within a computer (desktop or laptop) are almost all of the computer¡¯s

other components connected to? Describe this component¡¯s purpose.

The Motherboard. It provides communication between the computer¡¯s

components.

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 4 of 21

5. History of Computing (3 marks)

Describe the roles of the four people involved in preparing scientific tables before the

Two computers who do the calculations, one comparator who checks

their results agree and a printer who prints the results.

(3 marks)

6. Computer Networks (3 marks)

Describe the difference between circuit switching and packet switching on a network.

In circuit switching the nodes/computers are directly connected endto-end,

and data is sent along this connection. In packet switching, the

data is broken into packets that are routed independently across the

network.

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 5 of 21

7. WWW (3 marks)

On the WWW, what is the difference between the HTTP and HTTPS protocols?

HTTPS encrypts an HTTP connection using TLS (Transport Layer

Security). HTTP is unecrypted.

(3 marks)

8. Malware (3 marks)

What is the difference between a computer virus and a computer worm?

A virus needs a host program to spread it. A worm can spread itself.

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 6 of 21

9. Bits and Bytes (3 marks)

How much memory would be required to represent 248 different values?

1 byte (8 bits)

(3 marks)

10. Digital Images (3 marks)

How much memory would be required to store a 32-colour bitmap image that is 100

pixels wide and is 16 pixels high? Show all your working.

32 colours requires 5 bits per pixel (2 ^ 5 = 32)

Number of pixels = 100 * 16

= 1600 pixels

Number of bits required = 5 * 1600

= 8000 bits ( 1000 bytes)

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 7 of 21

SECTION B

Answer all questions in this section in the space provided. If you run out of space, please use

the Overflow Sheet and indicate in the allotted space that you have used the Overflow Sheet.

11. Programming Using Python (15 marks)

(a) The following exponential function can be used to predict the spread of flu-like

diseases:

???????????????????????? ???????? ???????????????????? = 2(?????1)

where d is the day number. The value for Day 0 is defined to be 1.

Write a Python program that calculates and displays the number of flu infections after

a certain number of days. The number of days to predict is entered by the user. You

can assume that the user will always enter an integer value greater than or equal to 1.

Here are two examples of the program running with different values entered by the user.

User input is indicated in the examples with bold and italicized font.

Example 1:

Enter the number of days to predict: 5

The number of cases at day 1 is 1

The number of cases at day 2 is 2

The number of cases at day 3 is 4

The number of cases at day 4 is 8

The number of cases at day 5 is 16

Example 2:

Enter the number of days to predict: 1

The number of cases at day 1 is 1

days = int(input("Enter the number of days to predict: "))

day = 1

while day <= days:

cases = 2 ** (day - 1)

print("The number of cases at day ", day, "is", cases)

day = day + 1

(5 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 8 of 21

(b) Write a piece of code that prints the visibility rating for the visibility distance entered

by the user at the prompt "Enter the Visibility Distance: ". Use the table

below to determine the visibility rating. You can assume that the user will always

enter a floating-point number (i.e. a float). Two examples are given below.

Visibility Rating Visibility Distance

Good > 6

Fair 3 ¨C 6 (including 3 and 6)

Poor 1 ¨C 3 (including 1 but not 3)

Fog < 1

Example 1:

Enter the Visibility Distance: 0.2

Example 2:

Enter the Visibility Distance: 6.0

distance = float(input("Enter the Visibility Distance: "))

if distance > 6:

visibility = "Good"

elif distance >= 3:

visibility = "Fair"

elif distance >= 1:

visibility = "Poor"

else:

visibility = "Fog"

(5 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 9 of 21

(c) In the box below, complete the code that will make the following picture. Assume

that the turtle begins in the middle of the window facing right and that the window is

approximately 500 steps wide. NOTE: You must use a while loop.

import turtle

steps = 100

angle1 = 45

angle2 = 90

number_of_repetitions = 10

step_increment = 10

repeat_number = 0

while repeat_number < number_of_repetitions:

turtle.forward(steps)

turtle.left(angle1)

turtle.forward(steps)

turtle.left(angle1)

turtle.forward(steps)

turtle.left(angle2)

repeat_number = repeat_number + 1

steps = steps + step_increment

(5 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 10 of 21

week.

(a) Columns C to G of Rows 4 to 10 contain information about the lunch that the person

had on the day specified in Column B. What is the best formula to use in Cell E4 to

find the total number of calories the person consumed for lunch on the day specified

in Cell B4? The calorie table is located in Cells C17 : D23. Your answer must use a

VLOOKUP function.

Note: Your formula must be able to be filled down from E4 to E10 correctly.

=VLOOKUP(C4,$C$17:$D$23,2,FALSE)*D4

(6 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 11 of 21

(b) Cell G4 indicates the number of calories consumed for lunch on the day specified in

Cell B4 that are under or over the goal number of calories specified in Cell E14.

What is the best formula to use in Cell G4?

Note: Your formula must be able to be filled down from G4 to G10 correctly.

= E4 - $E$14

(2 marks)

(c) Cell E11 shows the total number of calories consumed for lunch for the week. What

is the best formula to use in Cell E11?

= SUM(E4:E10)

(2 marks)

(d) Cell E13 shows the average (mean) number of calories consumed for lunch each day.

What is the best formula to use in Cell E13?

= AVERAGE(E4:E10)

(2 marks)

(e) Cell G13 indicates whether the average number of calories in Cell E13 is under or

over the goal number of calories specified in Cell E14. If the average is less than the

goal value, G13 should show ¡°Under¡±. If the average is higher than the goal, then

Cell G13 should show ¡°Over¡±. If the average is equal to the goal then Cell G13 is left

blank. What is the best formula to use in Cell G13?

Note: Your formula must use an IF function.

=IF(E13<E14,"Under",IF(E13>E14,"Over",""))

(3 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 12 of 21

Question 13. HTML5 and CSS (20 marks)

The following screenshot shows the body of a web page created using HTML5 and CSS:

Complete the HTML5 code on the following pages so that it produces the output shown

above.

You must use the styles defined in the internal style sheet in the head section on the

following page, and must not define any new styles.

Note:

(1) The URL for the University of Auckland Online Learning Resources is:

¡°https://www.online.auckland.ac.nz/¡±.

(2) The image is stored in a file called "AucklandOnlineImage.png" in the same

folder as the HTML file.

(3) There are two sections (the ¡°Statistics¡± section and the ¡°Slang Glossary¡± section).

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 13 of 21

<!DOCTYPE html>

<html lang="en">

<meta charset="UTF-8">

<title>HTML/CSS Exam Question</title>

<style>

body {background-color: pink;

font-family: "Arial", "Calibri", Sans-Serif}

h1 {background-color:rgb(0,0,0); color:#E6FFE6;

text-transform:uppercase; text-align:center}

h2 {background-color:rgb(0,0,0); color:#E6FFE6;

font-variant:small-caps}

table, tr, td { border: 2px solid black;}

#emphasis{font-size:large; color:red}

#center {text-align:center}

font-weight:bold; text-align:center}

.glossary{font-style:italic; font-weight:bold}

.stat{text-align:right; font-weight:bold}

</style>

<body>

(1 mark)

<!-- Image -->

(2 marks)

<!-- First Paragraph -->

(2 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 14 of 21

<!-- "Student Statistics" Section -->

(7 marks)

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 15 of 21

<!-- "Slang Glossary" Section -->

(8 marks)

</body>

</html>

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 16 of 21

14. LaTeX (20 marks)

On the following pages, complete the LaTeX code that will produce the output below:

The image is stored in a file called Covid.png and is in the same folder as the LaTeX

code. When inserted into the document, the image should be centred and 6 cm wide.

The following LaTeX commands have been included as a reference. You will not need to

use all of these commands.

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 17 of 21

Normal commands Environments Math mode commands

\usepackage{graphicx}

\section{}

\subsection{}

\title{}

\author{}

\date{}

\maketitle

\item

\textbf{}

\emph{}

\includegraphics{}

\footnote{}

itemize

enumerate

verbatim

flushright

center

quote

displaymath

equation

quotation

\$

\sqrt{}

\frac{}{}

\leq

\sum_{}^{}

\infty

\sigma

^

_

\left(

\right)

(20 marks)

\documentclass[a4paper]{article}

\begin{document}

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 18 of 21

- Overflow Sheet 1 -

Write the question number and letter next to your answer. You must ALSO indicate in

the allotted space that you have used the overflow sheet.

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 19 of 21

- Overflow Sheet 2 -

Write the question number and letter next to your answer. You must ALSO indicate in

the allotted space that you have used the overflow sheet.

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 20 of 21

ID ¡­¡­¡­.¡­¡­¡­¡­

Page 21 of 21

________________________________________