ENGG1811/COMP1081
Week-6 Lab -
Databases
In this lab you will learn how to create and use data base tables and queries using
MS Access. Most of these functions/features have been discussed in detail during
the lectures, and in this lab you need to apply t
ENGG1811
Week 1 (2/03/15)
Trajectory
To use the cos, sin and tan functions; we need to make sure that the angle (in degrees) is first converted to radians
for the program to work
60 degrees
e.g. angle =
Insert formula : =COS(RADIANS(theta)
theta in this c
Name:_ Student Number:_ Lab class:_ Terminal Number:_ Signature:_
The University of New South Wales Sample Mid Session Test
ENGG1811 Computing for Engineers
Time allowed: 45 minutes Total number of questions: 8 Total number of marks: 40 No examination mat
ENGG1811 Sample Exam Solutions
ENGG1811 Sample Exam Solutions (13s2)
Section A: Multiple Choice Questions
A1
C
Not Broadcast, not necessarily synchronous or radio
A2
B
It has odd parity, the others are true (XORing with 11111111 is a
complement operation,
ENGG1811 Sample Final Exam Solutions
Sample Exam Solutions
Part A. Multiple choice.
A1
C. Internet comms are point-to-point, all RFID devices have antennas and embedded
systems are special purpose and not easily reprogrammed.
A2
B. It uses odd parity.
A3
Family Name: _
Given Names: _
Student Number: _
Signature:_
The University of New South Wales
SAMPLE Final Examination
Semester 2, 2013
ENGG1811 Computing for Engineers
Time allowed: 2 hours
Reading time: 10 minutes
Total number of questions: 48, in 3 Sec
ENGG1811 Sample Final Exam
Section A: Multiple Choice Questions
Family Name: _
Given Names: _
B1
Answer the questions in this section on the answer sheet provided, NOT on this
paper.
Student Number: _
B9
Each question has four alternatives. Once you have
Family Name: _
Given Names: _
B
Student Number: _
Signature: _
The University of New South Wales
SAMPLE Final Examination (Solution)
Semester 2, 2015
ENGG1811 Computing for Engineers
Time allo
n
n!
n!/(n-1)!
Stop when n! exceeds:
1.00E+20
0
1
1
1
1
2
2
2
3
6
3
If your program is working OK
4
24
4
Column C will list the ratio of adjacent
5
120
5
factorial values, which should be
6
720
6
equal to n.
7
5040
7
8
40320
8
9
362880
9
10
3628800
10
11
Family Name: _
Given Names: _
B
Student Number: _
Signature: _
The University of New South Wales
SAMPLE Final Examination
Semester 1, 2016
ENGG1811 Computing for Engineers
Time allowed: 2 hou
Family Name: _
Given Names: _
B
Student Number: _
Signature: _
The University of New South Wales
SAMPLE Final Examination
Semester 2, 2014
ENGG1811 Computing for Engineers
Time allowed: 2 hou
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ante metus, luctus eget nulla quis,
tempor cursus nibh. Vestibulum ac auctor lacus. Suspendisse faucibus massa faucibus est gravida,
tempus iaculis dui vulputate. Nullam sit amet leo varius,
ENGG1811 - COMPUTING FOR ENGINEERS
ARTIFICIAL INTELLIGENCE
What is Artificial Intelligence?
The definition of artificial intelligence is a one that is constantly changing and continues to
be debated indefinitely.
The question is to have artificial intelli
ENGG1811 - COMPUTING FOR ENGINEERS
DIGITAL REVOLUTION AND NETWORK COMPUTING
Bits and Bytes
Computers work on binary (1s and 0s).
Each individual 1 or 0 is a bit.
A byte is a group of 8 bits.
Encoding Numbers, Characters and Instructions
Encoding is the co
ENGG1811 - COMPUTING FOR ENGINEERS
COMPUTER ARCHITECTURE
What is a Computer?
Computers are electronic machines that:
- Accept data (inputs)
- Manipulates data according to rules (process)
- Produces results (output)
- Stores results for future use (storag
Family Name: _
Given Names: _
B
Student Number: _
Signature: _
The University of New South Wales
SAMPLE Final Examination (Solution)
Semester 1, 2016
ENGG1811 Computing for Engineers
Time allo
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris ante metus, luctus eget nulla quis,
tempor cursus nibh. Vestibulum ac auctor lacus. Suspendisse faucibus massa faucibus est gravida,
tempus iaculis dui vulputate. Nullam sit amet leo varius,
ENGG1811
Spreadsheets: Functions and Features
In this lab you will learn how to use some of the commonly used functions and
features offered by MS Excel. Most of these functions/features have been
discussed in detail during the lectures, and in this lab y
Lab 1.1 Software and Data Storage
Even if you have used computer programs before, you probably have not stopped to consider how the computer runs programs. This lab will help you better understand the basic computing tasks of running programs and storing
ENGG1811/COMP1081 Lab 8: Functions and Selection
This is the Week 8 laboratory exercise for ENGG1811 Computing for Engineers
and COMP1081 Harnessing the Power of IT.
COMP1081 students should complete Parts A and C only.
ENGG1811 students should complete P
Lab 1.2
Internet Basics
This lab covers fundamental concepts of network organization, focusing on the clientserver model for network resources such as web pages and file storage. The procedure
includes uploading files via ftp to a web folder but does not
ENGG1811/COMP1081 Lab 7: Using The VB Editor
This is the Week 7 laboratory exercise for ENGG1811 Computing for Engineers
and COMP1081 Harnessing the Power of IT. It is the same for students in all
majors.
During the first hour of the lab class you will co
ENGG1811/COMP1081 Lab 9: Iteration and Convergence
COMP1081 students should complete Part A and attempt Part C.
ENGG1811 students should complete both Parts A and B.
Objectives
After completing this lab, students should be able to
Use iteration in VBA to
ENGG1811
Week-5 Lab
Data Analysis using Excel
In this lab you will learn how to analyse your data using some of the advance
functions and features offered by MS Excel. Most of these functions/features have
been discussed in detail during the lectures, and
More Exam Programming Questions Solved!
A bearing is an angle measured clockwise from North. A back bearing is
the bearing that is exactly opposite a given bearing. For example, if I'm
sighting a landmark that has a compass bearing of 110 degrees (slightl
COMP1081/ENGG1811 Sample Exam Solutions
COMP1081/ENGG1811 Sample Exam Solutions
Section A: Multiple Choice Questions
Section B: Short Answer Questions
A1
B1. (2 marks) Describe the two most important advantages of using a
Distributed/Grid Computing.
C
Not
TheUni
v
er
s
i
t
yofNew Sout
hWal
es
SAMPLEF
i
nalExami
nat
i
on
ENGG1811Comput
i
ngf
orEngi
neer
s
T
i
meal
l
owed:2hour
s
Readi
ngt
i
me:10mi
nut
es
T
ot
alnumberofques
t
i
ons
:38,i
n3Sect
i
ons
T
ot
alnumberofmar
ks
:100
Noexami
nat
i
onmat
er
i
al
s
function [] = BMLhtr(numRows, numCols, density, RNGseed)
% BMLHTR - (hit the road [Jack]) - initialise traffic grid pseudorandomly
%
% Parameters and return value
%
%
%
%
numRows, numCols - dimensions of the grid
density - the proportion of cells occupied
function [retval] = BMLsim(numCycles, displayRate, showBlockedCars)
% BMLSIM - simulate fixed number of cycles of the BihamMiddletonLevine
traffic model
%
% Parameters and return value
%
%
%
%
%
%
numCycles - number of full RED+BLUE car cycles to apply to
n
n!/(n-1)!
n!
Stop when n! exceeds:
0
1
1
1
1
2
2
2
3
6
3
If your program is working OK
4
24
4
Column C will list the ratio of adjacent
5
120
5
factorial values, which should be
6
720
6
equal to n.
7
5040
7
8
40320
8
9
362880
9
10
3628800
10
11
39916800