Home

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 formats. You can download the following resources from the button:         •    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             •    Animation or Game. The Website folder should contain: •   HTML pages •   an Assets folder •   an Animation or Game folder containing an executable file (only). The Evidence folder should contain: •   completed analysis log •   completed survey spreadsheet •   development log •   assets log •   a folder contaiing the files used to create the executable animation or game . This must be in a suitable format. EndFragment 

Resources

Data organisation and analytics [12 marks]

Section A: - Interrogating spreadsheet data

Data organisation The data needs to be organised and cleansed using functions.Use the analysis log to show your progress, describing which 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:  EndFragment•    that there are no duplicate records, unnecessary spaces or blank cells •    that correct data types have been used •    preferences are clearly identified in upper case 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. BeFit Cymru have some minimum requirements. They require you to: •    sort the data by age in ascending order •    use a minimum of five differnet functions to create a table analysing respondents’ age  •    show an analysis by gender •    use a different numerical representation to analyse new activity preferences •    use a different (non-number in cell) representation to analyse game player movement •    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 in the Evidence folder. EndFragment

Planning

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

Testing And Evaluating

Section B: - Data-informed digital products

Developing

•    The game should be set in a maze of your choosing that has different playable layers •    The game must include an original character •    The game must have an objective and a scoring system •    You should include sound effects in your game appropriate to the action Include detailed storyboards for each layer to outline your ideas for the game design. Remember to save your work regularly and keep your development logs up to date.

Planning - website [11 marks]

•    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 shpuld be able to navigate around these different scenes e.g. pause, rewind, forward. Include detailed storyboards with timings to outline your ideas for the animation design. Remember to save your work regularly and keep your development logs up to date.

•    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 websites 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 logs 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 logs up to date. You must also create designs for either the animation or the game.

Planning - Game [7 marks]

Section B

Planning - Animation [7 marks]

Using your designs, you can now create the website with either the game or the animation.

Developing digital products – animation or game [15 marks]Create your animation or game according to your earlier design. Ensure that you obtain feedback that you critically evaluate and act upon where necessary.Detail how your animation or game meets your design criteria and any issues that you encountered and how they were overcome in your development log. EndFragment

Remember to save your work regularly in the correct folders.  Keep your assets log and development log up to date. Developing digital products – assets [10 marks]Develop the content for your game or animation according to the designs you created earlier. Ensure that you have a variety of content that is matched to your purpose.Developing digital products – website [15 marks]Create a professional website according to your earlier design. Ensure that you obtain feedback that you critically evaluate and act upon where necessary.Detail how the website meets your design criteria and any issues that you encountered and how they were overcome in your development log.EndFragment

Before you can deliver your digital productsyou must carry out some final checks. Testing completed products [5 marks]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 products [5 marks]Obtain feedback in the context of the target audience for your digital products.Write a report detailing how your products meet your aims and objectives and how the target audience feedback supports your findings, clearly identifying the potential for further improvements.   EndFragment