Information Technology
Practical Assessment Task
(PAT) Grade 12 – 2021
Documentation
Name: Hannah Moore
,Project Specification Document Page 1 of 11
PHASE 1
Project Specification Document
Graze Essentials
Developed by Hannah Moore
, Project Specification Document Page 2 of 11
Table of Contents
1.1 Summary 3
1.2 Motivation and Research 3
Features of the Program 4
1.3. Specifications of Program Function 3
1.4 Specifications of User Interface 6
1.5 Specifications of Help 8
1.6 Specifications of Data Storage 8
1.7 Hardware and Software Requirements 10
Reference List 11
, Project Specification Document Page 3 of 11
1.1 Summary
This is a program created for a person who runs a meal ordering business. This
program will be in the nature of a spreadsheet and aims to simplify the meal ordering
process, as it will be able to process each order with the customer’s details and cost of
meals (manually added to the program by the primary user). It will be able to calculate
a summary of each customer’s order according to the price of each meal and selected
portion size, which would be imputed and managed directly by the primary user. The
program will also be able to produce an invoice for a customer in pdf format with the
customer’s order summary, including the customer’s details, total cost for an order,
meal and portion sizes selected. This will enable the owner/user to keep the invoicing
process efficient and to keep their finger on the pulse of their business daily. The
primary user can also access a daily sales summary by selecting a date to view a
summary of the meals sold for that day. A daily sales summary helps the primary user
with decision making, improves future performance (which meals are popular etc) ,
and helps them understand their customers better by making accurate judgements
from the sales information. The primary user will also be able to update the menu,
including altering the meal names, prices per serving size as well as adding a new meal
to the menu.
1.2. Motivation and Research
There are many spreadsheet projects that already exist for organising and recording
data. Examples of these spreadsheet applications include : Microsoft Excel ( Microsoft
365, 2021), Google Sheets (Google Sheets, 2021), LibreOffice Calc (Calc | LibreOffice,
2021), Smartsheet (Smartsheet, 2021), and Quip. (Quip, 2021)
However, the limitation with these pre-existing spreadsheet programs is that their
format is primarily useful for large amounts of information and big businesses.
Moreover, none are very helpful when it comes to interpreting the data. In fact,
spreadsheet programs like Excel rely on visualisation tools like tables and graphs to
interpret data. Spreadsheet programs are primarily used for the organisation, analysis,
and storage of data in tabular form. The program operates on data entered in cells of a
table.
Further, Spreadsheet programs do not have easy data visualisation. While it is true that
users can create charts and graphs in spreadsheets, "create" is the keyword.
Assembling any kind of data visualization in a spreadsheet is time-consuming and
frustrating (Brudner, 2021). These spreadsheet programs also require the user to enter
their data manually, number by number, a daunting task for someone who is busy
shopping and cooking meals, with little experience in accountancy. The current
programs are generalised, time-consuming, and have the risk of human error.
Practical Assessment Task
(PAT) Grade 12 – 2021
Documentation
Name: Hannah Moore
,Project Specification Document Page 1 of 11
PHASE 1
Project Specification Document
Graze Essentials
Developed by Hannah Moore
, Project Specification Document Page 2 of 11
Table of Contents
1.1 Summary 3
1.2 Motivation and Research 3
Features of the Program 4
1.3. Specifications of Program Function 3
1.4 Specifications of User Interface 6
1.5 Specifications of Help 8
1.6 Specifications of Data Storage 8
1.7 Hardware and Software Requirements 10
Reference List 11
, Project Specification Document Page 3 of 11
1.1 Summary
This is a program created for a person who runs a meal ordering business. This
program will be in the nature of a spreadsheet and aims to simplify the meal ordering
process, as it will be able to process each order with the customer’s details and cost of
meals (manually added to the program by the primary user). It will be able to calculate
a summary of each customer’s order according to the price of each meal and selected
portion size, which would be imputed and managed directly by the primary user. The
program will also be able to produce an invoice for a customer in pdf format with the
customer’s order summary, including the customer’s details, total cost for an order,
meal and portion sizes selected. This will enable the owner/user to keep the invoicing
process efficient and to keep their finger on the pulse of their business daily. The
primary user can also access a daily sales summary by selecting a date to view a
summary of the meals sold for that day. A daily sales summary helps the primary user
with decision making, improves future performance (which meals are popular etc) ,
and helps them understand their customers better by making accurate judgements
from the sales information. The primary user will also be able to update the menu,
including altering the meal names, prices per serving size as well as adding a new meal
to the menu.
1.2. Motivation and Research
There are many spreadsheet projects that already exist for organising and recording
data. Examples of these spreadsheet applications include : Microsoft Excel ( Microsoft
365, 2021), Google Sheets (Google Sheets, 2021), LibreOffice Calc (Calc | LibreOffice,
2021), Smartsheet (Smartsheet, 2021), and Quip. (Quip, 2021)
However, the limitation with these pre-existing spreadsheet programs is that their
format is primarily useful for large amounts of information and big businesses.
Moreover, none are very helpful when it comes to interpreting the data. In fact,
spreadsheet programs like Excel rely on visualisation tools like tables and graphs to
interpret data. Spreadsheet programs are primarily used for the organisation, analysis,
and storage of data in tabular form. The program operates on data entered in cells of a
table.
Further, Spreadsheet programs do not have easy data visualisation. While it is true that
users can create charts and graphs in spreadsheets, "create" is the keyword.
Assembling any kind of data visualization in a spreadsheet is time-consuming and
frustrating (Brudner, 2021). These spreadsheet programs also require the user to enter
their data manually, number by number, a daunting task for someone who is busy
shopping and cooking meals, with little experience in accountancy. The current
programs are generalised, time-consuming, and have the risk of human error.
