preview

2015 Pits Assignment Question Essay

Better Essays

INDIVIDUAL ASSIGNMENT

This assignment comprise of FOUR (4) questions consisting of spreadsheet, word processor, database, and slides. You may use other software aside from Ms Excel, Ms Word, Ms Access, and Ms PowerPoint. However, note that the module specifically focuses on the four mentioned software both in lecture and in labs. Each question in each section has its own software application requirements. Read all of the questions carefully to fully understand the requirements before starting the assignment. This assignment is an INDIVIDUAL Assignment.

Learning Outcomes:

In conclusion, students should be able to:
Create a professional-looking documentation with sufficient coverage.
Prepare a financial accounting spreadsheet with …show more content…

The sales sheet(s), which should consist of the following (but not limited to):
a. Product ID, product description, selling price, and the number of on hand should be displayed exactly as in the inventory (no modification of data is allowed here)
b. Number of item sold that would automatically update the inventory’s number of item sold (access given only to the employee with the corresponding brand)
**Hint: Protect all non-modified access
**Hint: Use passwords to enable access to the employees
[5 marks]

4. The employees’ salary sheet should consist of the following (but not limited to):
a. Staff’s ID that is uniquely assigned to all employees
b. Staff’s name
c. Staff’s fix monthly salary
d. Staff’s commission
i. If the target sales revenue is less than RM1500, the commission is 5% from the selling price of the item sold ii. If the target sales revenue is equal to or greater than RM 1500, the items sold after that will be counted with a commission of 15% from the selling price.
e. Staff’s performance
i. If the target sales revenue is equal to or greater than RM 1500, the performance is “Good”. ii. If the target sales revenue is less than RM1500 but greater than RM1000, the performance is “Above average”. iii. If the target sales revenue is less than RM1000 but greater than RM500, the performance is “Satisfactory”. iv. If the target sales revenue is less than RM500, the performance is “Below average”.

[4 marks]

5. The analysis sheet

Get Access