« August 2008 »
Mon	Tue	Wed	Thu	Fri	Sat	Sun
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

VBA Homework Exercises - Week 6

This assessment task is worth 15% of the ASOC VBA Certification course.

Due Date: 31st May 2008, 5pm.

Questions can be found here .
The required spreadsheet can be found here .
N.B. Question 2d has been removed and the marks have been assigned elsewhere.

You must register and login for your submission to be valid. Only your first attempt will be counted and any subsequent attempts will be ignored.

If there are any problems, send an email to vba@asoc.unsw.edu.au

Full Name: *

Student Number: *

Email: *

Question 1a (1 mark): *

What type of iteration structure is this an example of?

Question 1b (2 marks): *

Why is this type of structure referred to as an ‘unguarded loop’?

Question 1c (2 marks): *

What is the danger of using this sort of iteration structure?

Question 2ai (2 marks): *

Fill in the cell reference.

Question 2aii (2 marks): *

Fill in the missing line of code.

Question 2aiii (2 marks): *

Fill in the missing line of code.

Question 2b (1 mark): *

How would you modify the code so that it satisfies the generally accepted programming practices?

Question 2ci (1 mark): *

How would you calculate the average of the stock prices in column C?

Question 2cii (1 mark): *

How would you calculate the average of the 3 columns of stock prices?

Are you ready to submit your answers?: *

Yes

Remember, we will only accept your first submission.

Are you ok?: *

Yes

We're not kidding. First submission only.

Upcoming Events:

Upcoming Support Sessions:

ASOC Apprentice

Download latest FAB

Our Sponsors:

VBA Homework Exercises - Week 6