Fundamental Skills: Spreadsheets

Assessment Details

Overview:

This unit will be fulfilled in two parts 

Part 1

Throughout the year you will be required to record the time spent on projects on a task-by-task basis. To facilitate this you are required to produce a spreadsheet that allows you to record project information and report on the data over time.

You will need to demonstrate the ability to add data to a spreadsheet, format data, use formulae and generate a range of (useful) reports. You will also need to demonstrate, over time that you have implemented a personal system for adding data to the spreadsheet.

Part 2

Integrating the lessons on Linux shell commands, you will do an experiment to find out the compressibility and efficiency of three data compression programs used in Linux. You will be creating a spreadsheet to display and analyse results of your findings. Scroll down to the end of the page to download the experiment sheet.

Brief (Part 1):

You are required to design a template for spreadsheet that you can use throughout the year to record project data and generate reports.

Requirements (Part 1):

• Brief Documentation that includes:
  • an overview of the project
  • identification of the target audience and brief descriptions of each
  • a list of deliverables
  • a breakdown of the tasks required at each stage of the design process to complete this project
  • a budget that estimates times for each of the stages
  • a list of modifications made over time. Each entry should include: a date, the issue, the solution
• Concept Notes:
  • identify fonts and colours for use in the spreadsheet
  • notes should justify your choices
• Content:
  • Your spreadsheet will need to allow for the following information: Date, Project, Stage (Design Process), Task, Start Time, End Time, Total Time (formula)
  • all data needs to be formatted correctly
• Reports:
  • Sort data
  • Use filters for easy access to specific information
  • Use a datapilot to customise data for reporting purposes
  • Graph data to provide a relevant report
• Evaluation:
  • write a simple evaluation that demonstrates how your spreadsheet fulfills the requirements of the brief.