A local supermarket is open seven days a week and employs 21 people on a full-time or part-time basis. It has a POS system and EFTPOS facilities. The supermarket is having problems with stock records and needs a new information system. The supermarket maintains its prices are lower than the competitors’. Develop a solution for the supermarket.
It must store fictitious data for each item, such as name, product description, price, brand, quantity and universal product code.
- Create a logo, slogan and banner for the supermarket.
- Set up a database for the employees, suppliers and products using DBMS.
- Create relevant queries, forms, reports and switchboard for the database.
- Investigate the prices of a range of goods in your local community.
- Create a flyer for the local supermarket to promote its lower prices.
|1. Understanding the Problem
3. Designing solutions
5. Testing Evaluating and Maintaining
|6. Social and Ethical Issues
7. Log Book / Journal
8. Files saved correctly using correct software.
9. Group Dynamics
H2.2 Develops solutions for an identified need which address all of the information
H6.1 Analyses situations, identifies a need and develops solutions.
H6.2 Selects and applies a methodical approach to planning, designing or implementing a
H7.2 Uses methods to thoroughly document the development of individual and/or group
Year 12 IPT Group Project
The following is to be used as a GUIDE in order to appropriately and/or correctly complete the Group Project.
Understanding the problem
|· One (1) A4 page on what the problem is, who are the participants, data, requirements.
· One (1) A4 page on what P.O.S and EFTPOS systems are.
· Project plan outlining the overall schedule, subprojects (inc. schedules), people involved, information technology and data/information required by the system. Minimum two (2) A4 pages.
· Conduct some preliminary investigation on at least 3 different supermarkets to ascertain the following:
– Current Information System in use
– Products sold (Do they only stock brand names?)
– Prices (Are their prices competitive? Who do they cater for?)
– Marketing (How do they get customers into their store?)
– Layout of the store(s).
· A one (1) A4 page requirements report that outlines the aims and objectives of the new system and how it will help the organization.
|· Suggest three (3) or more possible solutions to the problem. Include for each:
i) Constraints (factors that affects the system and prevents it from achieving the desired objectives) on the system. These could be financial, technical, environmental or personal.
ii) Advantages and disadvantages of each solution.
· A feasibility study to be carried out on the most appropriate of the proposed solutions. The feasibility study is to include:
i) Economic feasibility
ii) Technical feasibility
iii) Schedule feasibility
iv) Operational feasibility
· A revised project plan based on the feasibility study.
· An analysis report investigates the existing system in greater depth to ensure all current operations and problems are understood. This analysis report must include:
i) Needs of the new system
ii) Data to be gathered (via interviews, surveys, observations and measurements)
iii) Recommendations for design, implementation and maintenance.
iv) Design specifications such as hardware configuration of the new system and designs for both input and output.
· Recommend and justify a suitable system development approach.
|This stage is the transformation of the specifications into appropriate hardware, software and information processes. It involves purchasing hardware, writing or purchasing software, and specifying information processes to make the system operational. In this section you must include:
· A spreadsheet file that includes the following:
i) Cost of proposed hardware to be used
ii) Cost of proposed software to be used.
iii) General expenditure of the supermarket
iv) Payroll for all of the employees
· A database file that includes the following:
i) A form for stock that includes 100 fictitious records (Name, product description, price, brand, quantity and universal product code)
ii) A form for employee information (Name, address, post code, phone number, position and employment status)
iii) A form for supplier’s information (Name, address, post code, phone number, and product supplied)
iv) Relevant Queries and Reports
v) Switchboard to open forms, reports and exit application.
· Two (2) context diagrams on various aspects of the system (Ordering products, Sales at the check-out)
· One (1) Data Flow Diagram (DFD) on the sales at the check-out system.
· Two (2) decision trees on various aspects of the system (Ordering products, EFTPOS purchasing)
· One (1) data dictionary based on the database.
|· An implementation plan (one A4 page minimum) detailing the following aspects:
i) Method of participant training and why.
ii) The conversion method and why.
iii) System testing (Hardware, software and information processes)
· Create a flyer for the local supermarket to promote its lower prices using Microsoft Word.
Testing, evaluating and maintaining
|In this stage, the performance of the system is tested and then evaluated. You must include:
· Methods of testing conducted and reason why.
· Evaluation of the new system by comparing it to the initial aims and objectives outlined in the requirement report.
· Methods of maintaining the system.
Social and ethical issues
|· One (1) A4 page that includes information about the type of system, work environment and systems and ethics.
Logbook / Journal
|Each group member is to contribute to a logbook/journal (Who is doing what, when they did it, time taken, how it was done, and problems encountered). This is to be done on a weekly basis.
|Each group will be called upon at random over the course of the project to show/discuss aspects of the project.