Case Study

Instructions:

1. Form a group with maximum of five (5) members.

2. Submit a SOFT copy (FILE NAME: EZ Internet Café) and send it via e-mail thru: missas_casestudy@yahoo.com. The e-mail must have the following information:

-------------------------------------------------

SUBJECT: ICT 202 – Prelim Case Study | Section

-------------------------------------------------

BODY: NAME of the MEMBERS

3. Deadline of submission is on February 20, 2015 (Friday) until 5:00 PM ONLY

(NOTE: LATE submission will not be entertained and will be equivalent to 50% for Prelim Case Study)

-------------------------------------------------

You will create a workbook using MS Excel for a company, EZ Internet Café. They have a small NET café for 20 units of computer. Given that they don’t have software yet that keep track of records about the TIME-IN and TIME-OUT of each customers, they are only recording it manually using LOG-BOOK.

The computation of the amount that needs to be paid by the customer is time consuming, as well as there are errors due to confusion on computing for the time that the customer consumed. You are going to help EZ Internet Café to log their customer records using Excel that will track of TIME-IN AND OUT and the amount that the customers need to pay.

Check the attached SAMPLE file as your reference. Make sure not to copy the work of others, anyone who will be caught having the SAME SOURCE will earn 50% for their CASE STUDY.

Reminders:

* Use military time, study TIME FORMAT.

* Extra 5 points for those who will be able to use DATE function in getting the date today instead of manually typing the date, for cell G2.

* The purpose of the workbook is that when customer time is out the column for total hours will compute for the number of hours consumed.

* Total minutes column will convert the number of hours consumed into minutes, check the SAMPLE workbook.

* Amount to pay will compute for the amount that the customer...