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:
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]
Your developed VBA code would undertake the following tasks after the customer clicks the ‘Purchase a product’ button located on the customer’s worksheet:
R1
[i + ii + iii = 3 marks]
iv. Flag any processing error.
[iv + vi + vii + viii+ ix = 6 marks]
b. Worksheet for the Owner of the vending machine: [x + xi + xii = 3 marks]
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 |
To export a reference to this article please select a referencing stye below.
Assignment Hippo (2022) . Retrive from https://assignmenthippo.com/sample-assignment/civn2014a-project-part-a
"." Assignment Hippo ,2022, https://assignmenthippo.com/sample-assignment/civn2014a-project-part-a
Assignment Hippo (2022) . Available from: https://assignmenthippo.com/sample-assignment/civn2014a-project-part-a
[Accessed 15/08/2022].
Assignment Hippo . ''(Assignment Hippo,2022) https://assignmenthippo.com/sample-assignment/civn2014a-project-part-a accessed 15/08/2022.
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.
Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.
Get reliable and unique assignments by using our 100% plagiarism-free.
Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.
Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.
Get premium service at a pocket-friendly rate at AssignmentHippo
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.
Get instant assignment help