Statistics

What you need to know to become an expert in analysing your data- ||
 * =**Statistics**= |||| Continuous Assessment in a UAE setting should inform all relevant parties from students and parents through to ADEC. It should advise all stakeholders of progress and achievement in all areas of learning, teaching, advising and project management in order to identify successes, areas for improvement and future planning to ensure progress is ongoing and can be sustained in the long term.
 * ==**What do you need to know?**== || ====__Types of information you will need to know__====

Information that shows-
Stat Trek - teach yourself statistics - a useful website that teaches you how to create and analyse your Box and Whisker Plot. Also contains activities and lessons for testing.
 * 1) Shift in student results
 * 2) Areas for change || ====__Data__====
 * 3) ====Sorting your data====
 * 4) Selecting your data
 * 5) Manipulating your data
 * 6) Identify the data required in order to answer your query || ====__Tips for organising data__====
 * 7) ====Keep your original data in one folder, copy your files into another folder for manipulating your data.====
 * 8) Worksheets are the pages in your book. Rename the worksheets as you go. You can have a number of worksheets in your book ||
 * ===Box and whisker=== || A box and whisker plot is a type of graph used to display patterns of quantitive data. || Resources:

[|Box and Whisker Download]- download the programme from here. (Cognition) Reading box plotsA site that informs you on how to read and interpret box plots Box and whisker - a simple explanation ( you tube ) excel can work it out for you but how is it done in simple terms || We use Box and Whisker graphs to analyse data. A Box and Whisker Plot shows the average and median scores of your data.It will also divide the data into four quartiles. || Standard or Z scores- a classroom scenario || If we need to do more than summarize data but want to talk about particular scores within the data. We may want to discuss whether or not a score is above or below average. We may want to know how far away a particular score is from average. We might also want to compare scores from different bunches of data. We will want to know which score is better. Z-scores can help with all of this. ||
 * ===Basic calculations in Excel=== || How to perform basic calculations in excel through pictures || Excel in pictures || Learn the basics with simple pictures to guide you ||
 * ===Data analysis task=== || Practice your skills in data analysis || MOSS || A task designed by Cognition as a basic reuirement for understanding data analysis requirements for the advisor role. ||
 * ===Using excel to calculate standard deviation=== || A webbsite that teaches how to calculate standard deviation - uses screen shots || Standard deviation how to calculate in excel || **Standard deviation** is a statistic that tells you how closely all the various examples are clustered around the mean/average in a set of data. When the examples are pretty tightly bunched together and the bell-shaped curve is steep, the standard deviation is small. When the examples are spread apart and the bell curve is relatively flat, that tells you you have a relatively large standard deviation. ||
 * ===Z Scores=== || An explanation of Z scores (standard score) || Z scores explained statistics
 * ===Pie Charts=== || Should I use them? ||  || Pie charts are used to compare different parts of a whole. Statisticians feel that pie charts are a poor way of displaying information. Ask yourself is this the best way to display the information I want to share. ||
 * ===Pivot Tables=== || What are they and how to use them || Pivot charts in excel

Introduction to pivot tables

Pivot charts for teachers Census at school pivot charts || An extensive site looking at many different ways of using pivot tables A simple guide to pivot tables

Great video on using Pivot Tables - slow and simpleAnother simple video on pivot charts using school data ||


 * = Statistical Vocabulary﻿ = ||
 * Graph/chart ||  A diagram showing the relation between variable quantities   ||
 * Mean || The average ||
 * Mode ||  The value that occurs most frequently in a given set of data   ||
 * Standard deviation ||  A quantity expressing by how much the members of a group differ from the mean, (average),value for the group   ||
 * Quartile ||  Each of four equal groups into which a population can be divided according to the distribution of values of a particular variable   ||
 * Variable || Able to assume different numerical values  ||
 * Pivot table || You might think of a pivot table as a user created summary table of your original spreadsheet. You create the table by defining which fields to view and how the information should be displayed. Based on your field selections, Excel organizes the data so you see a different view of your data. ||