Scenario - stay safe

Cycle Cymru aims to encourage people to get out on their bikes. It also aims to make sure that cyclists understand how to stay safe and has decided that it would like a three-page website to promote these aims. The website is to contain either a small video game or an animation.

You have the choice of creating either a small video game or an animation.

Cycle Cymru would like you to develop data-informed digital products and it has carried out a survey to support this. The data from the survey needs to be organised and analysed.

The analysis of the data from the survey will enable you to establish the target audience, and some of their likes, to inform the designs of the website and video game or animation.
It is important that you organise and document your work throughout this project.

You will be provided with several files, and you will be instructed on the naming of the files and folders where your work should be saved. It is essential that you keep all the logs up to date as this will be part of your assessment.

Organisation and preparation

Your work must be clearly organised to allow accurate assessment.

Throughout the project you will be instructed to save your files in certain folders, with specific names and in specific formats.

You can download the following resources:
        •    Analysis log framework
        •    Data1 file
        •    Development log framework
        •    Assets log framework

You must create:

  • a root folder:
    • Root
  • subfolders:
    • Evidence
    • Website
  • Subfolders within the Website folder
    • Assets
    • Game or Animation.
The Website folder should contain:
  • HTML pages in a folder
  • an Assets folder
  • a Game or Animation folder containing an executable file (only).
The Evidence folder should contain:
  • completed analysis log
  • completed survey spreadsheet
  • development log
  • assets log
  • a folder containing the files used to create the executable game or animation. This digital product must be in a suitable format.

Interrogating Spreadsheet Data

Data Organisation

The data needs to be organised and cleansed using functions. Use the analysis log to show your progress, explaining the functions you have used.

The data file Data1 has been delivered by the survey company. You need to import the file into a worksheet and cleanse the data, ensuring that:  
  • there are no duplicate records, unnecessary spaces or blank cells
  • age is rounded down to a whole number
  • the reason for riding a bike is in one column.   
Data Analytics

The data must now be analysed to identify trends, audience and needs.

Copy the cleansed data from the first worksheet into another worksheet.
Continue to use the analysis log to show your progress.

Cycle Cymru has some minimum requirements. It requires you to:
sort the data in ascending order by number of times spent riding a bike in the past
month
  • use a minimum of five different functions to create a table analysing respondents’ time spent riding a bike in the past month.
  • show an analysis by gender assigned at birth.
  • use a different numerical representation to analyse reasons for riding a bike.
  • use a different (non-number in cell) representation to analyse locations for the animation or game.
  • produce two suitable charts from your analysis justifying the choices you have made in your analysis log                  
Create a new worksheet:
  • carry out two further relevant investigations using the advanced techniques of what-if analysis and pivot tables
  • make a note in your analysis log explaining:
    • what you are investigating
    • what feature of the software you will use
    • what you have found.

Save the analysis log as Completed Analysis Log in the Evidence folder. Save the completed spreadsheet as Completed Survey Spreadsheet in the Evidence folder.

Data-informed Digital Products

You must complete Section A – interrogating spreadsheet data before you start developing the website. You will need to decide, based on the data analysis, whether you choose to develop either a game or an animation.

Planning - Animation

  • The animation should be between 20 and 30 seconds long.
  • The animation must include an original cartoon character.
  • You should include sound in your animation. You can choose music, voiceover, incidental noise or any combination of these. At least one sound must be original.
  • The animation must include different scenes. You should be able to navigate around these different scenes e.g. pause, forward, replay.
Include detailed storyboards with timings to outline your ideas for the animation design.

Create your animation according to your earlier design. Ensure that you obtain feedback. Critically evaluate the feedback and act upon it where necessary.

Detail how your animation meets your design criteria, any issues that you encountered and how they were overcome in your development log.

Remember to save your work regularly and keep your development log up to date.

Planning - Website

  • Your website must consist of at least three pages.
  • Any images that you include in the site must be documented in the Assets log.
  • The website should contain no horizontal scrolling and must include accessibility features.
  • The website must be organised hierarchically i.e. you must not be able to directly access every page from every other page.
  • One page must contain either the game or the animation.
  • One page must contain links to all the documents in the Evidence folder.
Website Outline Designs

Note the target audience and your choice of either game or an animation in your development log.

Produce outline designs of the website that consider the analysis of the data and feedback you have gathered from test users.

Remember to save your work regularly and keep your development log up to date.

Website Design

Produce comprehensive designs based on the chosen sketches / wireframes.

Throughout the design process you should obtain feedback from test users.

Remember to save your work regularly and keep your development log up to date.

Detail how the website meets your design criteria and any issues that you encountered and how they were overcome in your development log.

Testing completed products

Create and implement a comprehensive test plan that assesses the functionality of all the digital products you have created. Document all the testing outcomes detailing where tests have succeeded or failed. Document any changes you make to your product as a result of the testing.

Evaluating completed product

Obtain feedback in the context of the target audience for your digital products.

Write a report detailing how your digital products have met your aims and objectives and how the target audience feedback supports your findings. The report should clearly identify the potential for further improvements.