Report

=Survey Report: =

Here is the **standard** for this task:

Checklist of skills you must know BEFORE you can start the assessment:

 * 1) **Microsoft Word 2007**://(Used to format documents such as a report)//
 * Work through this tutorial that teaches you basic features
 * Demonstrate your understanding by formatting this text document so it uses ALL the features you learnt in the tutorial e.g. //wordart; tables; alignment; columns; pictures; picture effects; page borders; page background; headings;//
 * 1) **Microsoft Powerpoint 2007**: //(Used to format documents as a presentation)//
 * Work through this tutorial that teaches you the basic features for your assessment
 * Demonstrate your understanding by formatting this text document so it uses ALL the features you learnt in the tutorial //e.g. Adding slides; Animations; Background theme; Exporting as a Powerpoint Slide Show e.g. pps; 3 images; 1 movie; 1 website link; background music;//
 * Download this example of what the finished product should look like
 * 1) **Microsoft Excel 2007:** //(Used to make calculations)//
 * Download this xlsx to your H drive under the digitech folder Information or 91071. It has sample data you will use to practice basic spreadsheet features.
 * Open Tiki Café.xlsx and work through this tutorial before you begin the assessment.
 * Alternative tutorials:
 * Header and Footer in Excel or Word
 * Insert a graph in Excel
 * Work through this exercise to practice the skills we started yesterday - using the SUM and COUNTIF functions, and then creating a graph.
 * 1) **Google Forms:** //(Used to collect feedback such as a survey)//
 * Create 20 questions for a survey using a topic of your choice. Write these in google docs//(you will need a gmail email if you don't already have one)// and share with Miss.
 * Create an online survey using Google Forms
 * When you have 20 responses, follow these instructions to export your survey results to an Excel CSV file. Open the file in Excel and try and use the countif function to total your gender and yes/no questions.

Start the Assessment:

 * To get ACHIEVED you must meet the specifications
 * To get MERIT you must work independently
 * To get EXCELLENCE you must work efficiently
 * Here is the __ **assessment task** __ you need to complete to get the other 4 credits for this term: [[file:91071_Assessment v3.pdf]]