Name: [16948] Grant Paton-Simpson
Member: 58 months
Authored: 17 videos
Description: Grant is a software developer and data analyst from Auckland, New Zealand. ...

SOFA Statistics Version 1 [ID:1291]

a series of video-tutorials by Grant Paton-Simpson

How to use SOFA Statistics version 1 to produce reports, tables, and charts, and run statistical tests.

Video Tutorials

1. SOFA Statistics Quick Taster

A quick run-through of the main features of SOFA Statistics.

2. Importing CSV data into SOFA Statistics

Demonstration of importing CSV data into SOFA Statistics. Shows options for separator e.g. comma, encoding e.g. utf-8, and whether the first row is a header or not.

3. Importing Google Docs Spreadsheets into SOFA

Demonstration of how to import Google Docs spreadsheets into SOFA Statistics.

4. Connecting to SQL databases in SOFA

Demonstration of configuring multiple SQL connections for SOFA Statistics.

5. Sharing SOFA output

How to generate and share output from SOFA Statistics. Analyses are run, the report file and support folder are zipped, sent, and extracted ready to be viewed in any modern web browser.

6. Making report tables with SOFA Statistics

Demonstration of making simple frequency tables, cross tabs, row summary statistics tables (mean, median etc), and data lists using SOFA Statistics.

7. Importing Open Document Format spreadsheets into SOFA

Demonstration of how to import into SOFA Statistics Open Document Format spreadsheets e.g. OpenOffice/LibreOffice Calc, Gnumeric, downloads from Google Docs etc.

8. Making data tables and editing data in SOFA

Shows how to design and populate a new data table in SOFA Statistics. Also shows that data from multiple different SQL databases (e.g. SQLite, MySQL, and PostgreSQL) can be accessed from within the same SOFA project.

9. Making charts in SOFA Statistics

Demonstration of making different types of charts (Bar, Pie etc) in SOFA Statistics, configuring charts e.g. order of Pie Slices, changing chart styles, and making series of charts e.g. Pie Charts of Web Browser for each Country.

10. Help in SOFA Statistics for choosing tests

Demonstration of the help provided in SOFA Statistics (including integrated on-line help) for choosing appropriate statistical tests.

11. Filtering table data in SOFA Statistics

Demonstration of how to add and remove a simple data filter to a table in SOFA Statistics e.g. gender = Female.

12. Recoding data in SOFA Statistics

Demonstration of how to recode data in SOFA Statistics e.g. age to age group or likert scale values into numbers with labels.

13. Installing SOFA Statistics in Windows

Demonstration of how to install, and reinstall, SOFA Statistics on Windows.

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.



Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.