Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!







CIVN2014A Project Part A

SCHOOL OF CIVIL AND ENVIRONMENTAL ENGINEERING, WITS

CIVN 2014A (ENGINEERING COMPUTING) 2021 PROGRAMMING PROJECT

This project (20% of the course mark) synthesizes most of what has been learned in programming (e.g. algorithms, programming structures, variables, operators, functions, subroutines, comments, arrays, input, output and VBA). 

Instructions:

  • Expected individual effort = 15 hours;
  • Submit a 1 page (MAXIMUM) summary algorithm of your project (pdf, jpeg) on the Ulwazi – CIVN2014A - Project Part A
  • Submit 1 Microsoft Excel Macro-Enabled file containing your worksheets and VBA code on the Ulwazi – CIVN2014A - Project Part B link by 08h00 on Monday, 14 June 2021;
  • All late submissions would be docked 10% for each day of lateness until the fifth day. After five days, no marks will be allocated for the submission;
  • Individuals may consult one another but are forbidden from producing VBA code together and/or copying (or adapting) one another’s code. Penalty for cheating or submitting similar code = minus 50% to minus 100% of mark obtained.

Task:

Design a 1 page (maximum) algorithm (Project Part A) (pdf, jpeg) and Microsoft Excel Macro-Enabled file of the Vending Machine described below (Project Part B). The Microsoft Excel Macro-Enabled file containing worksheets and VBA code would dispense products (Table 1) whose prices are specified in Table 2. 

Table 1. Products and product codes

 

1

2

3

4

1

Simba cheese and onion Product code: 11

Simba Nik Naks Product code: 12

Fritos corn chips Product code: 13

Lays Product code: 14

2

Doritos Product code: 21

Eet sum mor Product code: 22

Diddle Daddle Product code: 23

Oreo Product code: 24

3

Snickers Product code: 31

Bar One Product code: 32

Kit Kat Product code: 33

Lunch Bar Product code: 34

4

Coca-Cola Product code: 41

BonAqua

Product code: 42

Fanta Grape Product code: 43

Twist Product code: 44

Table 2. Prices

1

2

3

4

1

R 10.00

R 10.00

R 10.00

R 10.00

2

R 10.00

R 5.00

R 5.00

R 10.00

3

R 10.00

R 10.00

R 10.00

R 10.00

4

R 15.00

R 10.00

R 15.00

R 15.00

Project Part A                                                                                                                         [Total = 5 marks]

Project Part B                                                                                                                        [Total= 15 marks]

  • Structure of VBA code                                                                                                             [1  mark]
  • Use of comments                                                                                                                         [1 mark]
  • Innovative and user-friendly                                                                                                 [1 mark]

Your developed VBA code would undertake the following tasks after the customer clicks the ‘Purchase a product’ button located on the customer’s worksheet:

  1. Worksheet for the Customer:
  2. Receive the customer’s selected product code. Confirm and display the customer’s selected product and the price of the product.
  3. Receive the customer’s money, which may be input in one or more of the denominations shown in Table 3. The vending machine will only accept the following denominations: R20, R10, R5, R2 and

R1

  • Flag any input error.

[i + ii + iii = 3 marks]

iv.    Flag any processing error.

  1. Inform the customer if the selected product is unavailable. If unavailable, another product may be selected.
  2. Inform the customer if money change for the selected product is unavailable. If unavailable, another product may be selected.
  • Monies accepted for purchases will not be added to the monies allocated for change.
  • Prevent (and inform) the customer from receiving a product if the total of the monies input by the customer is less than the selected product price.
  1. Dispense the selected product without change if the total of the monies input by the customer is equal to the product price OR dispense the product with the correct change in specified denominations should the total of the monies input by the customer be more than the product price.

[iv + vi + vii + viii+ ix = 6 marks]

b. Worksheet for the Owner of the vending machine:                                         [x + xi + xii = 3 marks]

  1. After each transaction, calculate and display the change in the different monetary denominations remaining in the machine.
  2. After each transaction, calculate and display the quantity of each product remaining in the machine.
  • Include a button on this worksheet that permits refreshing. Immediately after refreshing, there are 10 number of each product within the vending machine. Also, immediately after refreshing, the vending machine has the following quantities of each monetary denomination allocated for change (Table 3).

Table 3. Monies allocated for change in the vending machine immediately after refreshing

Denomination

R20

R 10.00

R 5.00

R 2.00

R 1.00

Total number

50

50

50

75

100

Download Sample Now

Earn back money you have spent on downloaded sample



Upload Document Document Unser Evaluion Get Money Into Your Wallet



Cite This work.

To export a reference to this article please select a referencing stye below.

Assignment Hippo (2021) . Retrive from http://assignmenthippo.com/sample-assignment/civn2014a-project-part-a

"." Assignment Hippo ,2021, http://assignmenthippo.com/sample-assignment/civn2014a-project-part-a

Assignment Hippo (2021) . Available from: http://assignmenthippo.com/sample-assignment/civn2014a-project-part-a

[Accessed 15/06/2021].

Assignment Hippo . ''(Assignment Hippo,2021) http://assignmenthippo.com/sample-assignment/civn2014a-project-part-a accessed 15/06/2021.


Want latest solution of this assignment

Want to order fresh copy of the Sample Template Answers? online or do you need the old solutions for Sample Template, contact our customer support or talk to us to get the answers of it.


Submit Your Assignment Here

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo

FREE RESOURCES

  • Assignment Writing Guide
  • Essay Writing Guide
  • Dissertation Writing Guide
  • Research Paper Writing Guide

FREE SAMPLE FILE

  • Accounts
  • Computer Science
  • Economics
  • Engineering

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help