CIT505 Assessment 2 – Case Study

Weighting within the course: 70%

Aim

Introduce the concepts of information systems to support business processes and create effective user-friendly digital solutions.

Learning Outcomes (LOs) covered

LO2: Use a data model to enhance business practices (4 Credits).

LO3: Apply user experience and interface design principles to create an accessible interactive digital media solution (5 Credits).

Qualification Graduate Profile Outcomes (GPOs) covered

GPO 2: Apply the fundamentals of information systems concepts and practice, including business concepts, development life cycles, data modelling and administration, to support and enhance organisational processes and systems.

 GPO 3: Apply knowledge and concepts of business analysis, user experience and interface design to create accessible interactive digital media.

Assessment Matrix

Assessment Conditions

• This is an open book assessment. To complete this assessment, utilise the course content, your personal notes, and external resources such as textbooks, online journals, or reliable sources.
• All work must be your own, any content from other sources must be cited and referenced.
• No limit on the time you can spend on assessment. However, it must be submitted by the due date.
• The purpose of this assessment is to assess your knowledge. In the event Yoobee suspects collusion or other lack of Academic Integrity, this will be addressed. For more information, please refer to the Student Handbook.
• Submit your completed assessment online in the correct space provided. Some students are eligible for a change in the assessment conditions due to learning differences. If you consider this applicable applies to you, discuss it with your tutor before starting the assessment.

Submissions can be made in English or Te Reo. Should you desire to submit in Te Reo, please make arrangements with your tutor two weeks in advance of submission.

Success Criteria

You need to receive 50% or more of the total marks available to pass this assessment. You must pass all assessments in the programme to be able to attain the Certificate in Information Technology.

Should you achieve 40 to 49% of the total marks available on the first submission of an assessment, you will have an opportunity to resubmit. This means that if you achieve at least 40% on the first submission you will have one additional opportunity to achieve 50%. Where a second submission is required, the marks available will be capped at 50%.

In addition to achieving a minimum of 50% in each assessment, ākonga must demonstrate achievement of all learning outcomes being assessed.

Grading

The final grade for the course will be determined by the weighted average of all scores in the course.

Submission Requirements

The format of the report makes up 10% of the marks in the assessment. The required details are

• To be submitted as a Word or PDF document that contains your answers to all tasks below. This is to be submitted in the assessment section of Yoobee Online (the LMS) by the due date.
• The submission must have your name and student ID number on the Title Page, together with the Assessment number and title and due date.
• All answers must be labelled with a heading indicating task and subtask number and description, for example o Task 1: ….
  • Task1-1
  • Task1-1
  • Task1-2
  • Task1-2

Under each heading the paragraph should be in the format of “SEE”.
o Statement about the topic
o Explanation of why the statement is valid (with references if using a theory) o Example relevant to the scenario 

• Submission should be using 14 pt calibre, line spacing 1.5, and adhere to APA 7 if external sources are referenced. Use of reference generators is encouraged.

Assessment 2

Scenario

Client

ARTWORKS OF ROTORUA is a tourism shop in Rotorua. It is operated by the whānau of a local marae that was looking to boost the income of some of the local artisans who had lost jobs and income during the COVID shutdown of tourism.

The shop sells Māori arts and crafts items to tourists in store as well as through a website. The shop may sell directly or sell on behalf and retain a percentage of the sale. The rate is negotiated with the seller based on the value of the item and the relationship the shop has with the seller.

The shop uses a card for each supplier, recording on it the items either purchased or being sold on behalf of the supplier. Other details on the card are:

• A name or contact for the supplier if is a collective,
• the type of products supplied (carving, weaving, etc.),
• where they are located, and – tribal affiliation.

Since the start of 2024, the tourists have returned to Rotorua, and the shop has a lot more business. It is having difficulty

• getting enough items to sell and
• keeping track of who has supplied each item.

The website is updated manually when the staff have time. As the store is getting busier, it means that they are receiving more requests for items no longer available, and items will not be loaded for several weeks till someone has time to update the website.

Those running the store are investigating what would be involved in creating a database to keep track of the information.

Your role

This project is to guide you through the steps involved in creating and using a database and enhancing the functionality designing an interface that can

• improve efficiency,
• data accuracy, and
• improve relationships with the suppliers.

Requirements

The requirements of this assessment are:

1. Using a data model, create a database (25%)
2. Given a scenario, report how the data model can enhance the business (20%)
3. Create a prototype of an interface

Within each section will be

If research is to be included in report, so must be cited and referenced.

Task 1: Create a database (25%)

In this task will be required to

1. design a data model to be used in the creation of the database,
2. populate the database with the provided data
3. retrieve data from the database for a purpose

The data that the shop is keeping track of is the items that it has for sale. It needs to know for two primary entities – the supplier and the item itself. Below is a list of information that ARTWORKS OF ROTORUA uses about each.

Suppliers

• Supplier Name
• Iwi affiliation of supplier
• Whether an individual or a group of people
• Contact name (if different from supplier name)
• Contact email address
• Contact phone number
• Type of products supplier provides

Stock Items

• Store item code (unique for each item)
• Supplier
• Description of item
• Price
• Commission Sale (Yes/No)
• Percentage markup
• Date into stock
• Date sold

The Relational database model has been selected because will minimise duplicated data within the database.

Task 1.1: Design of data model (10%)

Using a tool like dbdiagram.io create a diagram of the proposed database structure including data types of the fields.

Provide an image of the data model table structures and justification for the data types used.

Task 1.2: Database creation and population (10%)

Using a DBMS (Database Management System) of choice create the database as per the diagram and populate with the example data provided.

Provide an explanation, with examples, of the commands used and screenshots of the results.

Task 1.3: Database queries and report generation (5%)

Using database commands

1. Create a list of the items that are available for sale. This means it should not have items that have been sold. For each item show
   a. store item code
   b. Supplier name
   c. Description
   d. Stock date
   e. price
2. Create a list of items that have been sold in the last month that shows:
   a. Supplier name
   b. Contact name
   c. Contact email address
   d. Price
   e. Margin*
   f. Commission sale (yes/no)

• Margin is a calculated field. The formula is price * (markup/(1+markup)). If the price was $100 and the percentage markup was 50% then the margin is 100 * (0.5 / (1+0.5) = 100 * (0.5/1.5) = 100 * 0.33 = $33.

Explain the details of the commands used. Include screenshots of the commands and the outputs. Format the results as a table and include in the submission.

Task 2: Explain how database enhances business (20%)

Explain how databases, particularly relational databases, enhance business.

Task 2.1: Make better decisions (10%)

Using the reports created in Task 1 explain how decision making for ARTWORKS OF ROTORUA could be improved as a result of the database. Use examples of how factors such as

• Improved information accessibility
• Less prone to errors
• Search and filter functions

Can lead to better efficiency, data reliability, and reduces errors over the card-based system.

Task 2.2: Enhance relationships with the suppliers (10%)

Explain how the information available in the reports generated in Task 1 can potentially be used to build better relationships with suppliers, and why would this be important to a business such as ARTWORKS OF ROTORUA.

Task 3: Create a design for an interface (45%)

ARTWORKS OF ROTORUA want an interface for staff to use that will allow them to have the information that they require for data entry, updating sales, and querying information and an item.

Task 3.1: Create a wireframe

You are to create a wireframe design for the interface. The requirements are:

1. The name of the store centred across the top
2. A search field to locate/filter items
3. Navigation buttons to move to prior or next items
4. The information to be displayed on the page is
   a. Supplier
   b. Store item code
   c. Item description
   d. Button to play an audio from supplier about item
   e. Price
   f. If sold

For all the elements displayed on the specify

1. Text or text from database field to be display
2. Font (or font type) to use used
3. Font colour
4. Font size
5. Background colour or image

Task 3.2: Explain the principles of User Experience used

Using the principles of User experience, such as consistency layout design, feedback, and ease of use, explain the choices in terms made in terms of

1. Layout of items
2. Colours used
3. Fonts used
4. Imagery used

When choosing colours, fonts, and imagery how do they reflect the nature of ARTWORKS OF ROTORUA.

For each principle must name at least three principles, provide explanations of what the principle is, and examples of how incorporated into the design.

Task 3.3: Explain the principles of accessibility needing to be applied to interface

Many of the store workers are volunteers and will be accessing this across multiple devices. What principles of accessibility will need to be considered to ensure that all the volunteers, including those who are low-vision users or have motor-skill impairments?

Task 4: Report presentation

10% of the marks will be on the report presentation. This covers items such as report structure, spelling, grammar, and use of titles and subtitles. These are

• Citations and Referencing: Any information from external sources (e.g., research into database systems, UX principles, or accessibility guidelines) must be properly cited within the text and fully referenced in a bibliography at the end of the report. Please use APA 7th Edition.
• Formatting: The font is appropriate type and size. The line spacing aids reading.
• Writing: The paragraph and sentence structures aid understanding of the information being presented. Paragraphs are about “ideas” while the sentences convey statements.
• Spelling: Please use New Zealand English spelling conventions throughout the report (e.g., “colour” instead of “color”, “organise” instead of “organize”).
• Structure: Use clear and consistent titles and subtitles to structure your report logically and make it easy to read.
• Cover pages: The submission must have your name and student ID number on the Title Page, together with the Assessment number and title and due date. There should also be a

Table of Contents.

Student Guide

Task 1 Creating database

Preparation and planning makes the execution simple. Investing in planning often reduces the total cost of a project. Even on simple projects there is an element of planning. It will often just be in your head with “I need to do a, then b, and finally c”. Even though it is just in your head, it is still a plan based on your experience.

Task 1.1 Designing the database

Don’t forget that numbers can be either integers (whole numbers only) or real (can have parts of a number e.g. 1.5).

The tables number have a relationship between them, where a entry in a row points to a record in another table.

Task 1.2: Creating the database

You can use any database system of your choice. Options include:

• SQL in ACI CompTIA Tech+ Labs. You will need to do everything in one session, and you will need to ensure that all the relevant screenshots and files are captured in the single session.
• Install XAMPP and using MySQL on PLABDM01 or personal device

The data is provided as a CSV. This can be

• imported directly,
• or can be copied and pasted into a text file so forms the basis of a script for entering the data.

Task 1.3: Creating reports

The report has a column that is the result of the calculation provided. You will need to make sure that the calculations are done correctly and that the result makes sense.

You will also need to make sure that the produced report is understandable. Each column should be appropriately labelled, and the report should be easily readable.

The commands used are to be included together with an explanation of the commands.

Task 2: Explain benefits of databases

This section is worth 20% of the marks so need to ensure that is answered adequately.

The section will need to address how decision making will be enhanced and

• what the benefits will be
• how the database will facilitate these benefits
• provide examples of how the stock database will help deal with the issues the organisation is facing.

This will need to be done for both the decision making and making connections with the suppliers.

Task 3: Designing an interface

The point of this task is to design, not build, a suitable interface for using the database. It will need to have the appropriate fields arranged in manner that aids finding and updating information.

The purpose of the interface should be made clear by the position and size of the title.

There are required interactive elements such as a search field and navigation buttons. Standard navigation tools are first, previous, next, and last record. A field for current record number is common to provide feedback on where in the table.

A written description sometimes does not do full justice so the artist who created the item may want to add an audio to describe it in a fuller way.  If there is an audio available in the record, then there should be a “Play” button.

The wireframe should not only indicate what it will look like, but also provide to the developer the details for fonts such as typeface, font size, colour, and any other relevant details.

Task 4: Report

As with all reports, the report should have a particular structure. There are some reports that will have extra sections, but common to all reports are three sections.  There should be an introduction outlining the purpose of the presentation, the body of the presentation which is where the information is presented and a conclusion.  The conclusion is about what happens next. It may be a decision, or an action. In this case it is about the store to decide the database is useful and decide to go ahead with it.

Whether an academic or professional presentation the credibility of the information is important. This means that it needs to be clear where ethe information came from.  If from a credible source, then it can be trusted. Citation means that the source can be identified, and the trustworthiness of the information evaluated.

When presenting as a professional, want to ensure that the format of the report supports the fact that you are a professional. This is done by using:

• A professional layout (headings, font type, a font size)
• Ensuring the report is free from grammatical and spelling mistakes
• Correct citations and referencing of sources.

It is recommended that start with the titles and then the key ideas under each title. Once have the key ideas expand each paragraph to explain the ideas.

Make sure that the proofing language is set to “English (New Zealand)”. Two major spelling differences between American English and New Zealand English are:

1. Verbs that end in “-ize” in American English are spelled with “-ise” in New Zealand English — for example, summarize becomes summarise.
2. Nouns ending in “-ization” are spelled “-isation” — for example, organization becomes organisation.

Setting the proofing language correctly will help ensure that these and other regional spelling conventions are applied consistently.

The final point is to ensure that cite and reference properly. Word has a built-in citation and referencing tool. It is under References. If select “Insert Citation” it will ask if citing an existing reference or new one. If new add the details and will automatically create the citation. The references are carried over so only need to enter the details once. If that same source is used in future reports, it is available to be used again.

CIT505 Assessment 2 Rubric