Register training material
6 materials found

Keywords: Data visualisation  or Excel 


WORKSHOP: R: fundamental skills for biologists

This record includes training materials associated with the Australian BioCommons workshop ‘R: fundamental skills for biologists’. This workshop took place over four, three-hour sessions on 1, 8, 15 and 22 June 2022.

 

Event description

Biologists need data analysis skills to be able to...

Keywords: Bioinformatics, Analysis, Statistics, R software, RStudio, Data visualisation

WORKSHOP: R: fundamental skills for biologists https://dresa.org.au/materials/workshop-r-fundamental-skills-for-biologists-81aa00db-63ad-4962-a7ac-b885bf9f676b This record includes training materials associated with the Australian BioCommons workshop ‘R: fundamental skills for biologists’. This workshop took place over four, three-hour sessions on 1, 8, 15 and 22 June 2022.   Event description Biologists need data analysis skills to be able to interpret, visualise and communicate their research results. While Excel can cover some data analysis needs, there is a better choice, particularly for large and complex datasets.  R is a free, open-source software and programming language that enables data exploration, statistical analysis, visualisation and more. The large variety of R packages available for analysing biological data make it a robust and flexible option for data of all shapes and sizes.  Getting started can be a little daunting for those without a background in statistics and programming. In this workshop we will equip you with the foundations for getting the most out of R and RStudio, an interactive way of structuring and keeping track of your work in R. Using biological data from a model of influenza infection, you will learn how to efficiently and reproducibly organise, read, wrangle, analyse, visualise and generate reports from your data in R. Topics covered in this workshop include: Spreadsheets, organising data and first steps with R Manipulating and analysing data with dplyr Data visualisation Summarized experiments and getting started with Bioconductor   This workshop is presented by the Australian BioCommons and Saskia Freytag from WEHI  with the assistance of a network of facilitators from the national Bioinformatics Training Cooperative. Materials are shared under a Creative Commons Attribution 4.0 International agreement unless otherwise specified and were current at the time of the event. Files and materials included in this record: Event metadata (PDF): Information about the event including, description, event URL, learning objectives, prerequisites, technical requirements etc. Index of training materials (PDF): List and description of all materials associated with this event including the name, format, location and a brief description of each file. Schedule (PDF): A breakdown of the topics and timings for the workshop Recommended resources (PDF): A list of resources recommended by trainers and participants Q_and_A(PDF): Archive of questions and their answers from the workshop Slack Channel. Materials shared elsewhere:   This workshop follows the tutorial ‘Introduction to data analysis with R and Bioconductor’ which is publicly available. https://saskiafreytag.github.io/biocommons-r-intro/ This is derived from material produced as part of The Carpentries Incubator project https://carpentries-incubator.github.io/bioc-intro/ Melissa Burke (melissa@biocommons.org.au) Bioinformatics, Analysis, Statistics, R software, RStudio, Data visualisation
WORKSHOP: R: fundamental skills for biologists

This record includes training materials associated with the Australian BioCommons workshop ‘R: fundamental skills for biologists’. This workshop took place over four, three-hour sessions on 1, 8, 15 and 22 June 2022.

Event description

Biologists need data analysis skills to be able to...

Keywords: Bioinformatics, Analysis, Statistics, R software, RStudio, Data visualisation

WORKSHOP: R: fundamental skills for biologists https://dresa.org.au/materials/workshop-r-fundamental-skills-for-biologists This record includes training materials associated with the Australian BioCommons workshop ‘R: fundamental skills for biologists’. This workshop took place over four, three-hour sessions on 1, 8, 15 and 22 June 2022. **Event description** Biologists need data analysis skills to be able to interpret, visualise and communicate their research results. While Excel can cover some data analysis needs, there is a better choice, particularly for large and complex datasets.  R is a free, open-source software and programming language that enables data exploration, statistical analysis, visualisation and more. The large variety of R packages available for analysing biological data make it a robust and flexible option for data of all shapes and sizes.  Getting started can be a little daunting for those without a background in statistics and programming. In this workshop we will equip you with the foundations for getting the most out of R and RStudio, an interactive way of structuring and keeping track of your work in R. Using biological data from a model of influenza infection, you will learn how to efficiently and reproducibly organise, read, wrangle, analyse, visualise and generate reports from your data in R. Topics covered in this workshop include: - Spreadsheets, organising data and first steps with R - Manipulating and analysing data with dplyr - Data visualisation - Summarized experiments and getting started with Bioconductor This workshop is presented by the Australian BioCommons and Saskia Freytag from WEHI  with the assistance of a network of facilitators from the national Bioinformatics Training Cooperative. Materials are shared under a Creative Commons Attribution 4.0 International agreement unless otherwise specified and were current at the time of the event. **Files and materials included in this record:** - Event metadata (PDF): Information about the event including, description, event URL, learning objectives, prerequisites, technical requirements etc. - Index of training materials (PDF): List and description of all materials associated with this event including the name, format, location and a brief description of each file. - Schedule (PDF): A breakdown of the topics and timings for the workshop - Recommended resources (PDF): A list of resources recommended by trainers and participants - Q_and_A(PDF): Archive of questions and their answers from the workshop Slack Channel. **Materials shared elsewhere:** This workshop follows the tutorial ‘Introduction to data analysis with R and Bioconductor’ which is publicly available. https://saskiafreytag.github.io/biocommons-r-intro/ This is derived from material produced as part of The Carpentries Incubator project https://carpentries-incubator.github.io/bioc-intro/ Melissa Burke (melissa@biocommons.org.au) Bioinformatics, Analysis, Statistics, R software, RStudio, Data visualisation
Beyond Basics: Conditionals and Visualisation in Excel

After cleaning your database, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. This course will cover conditional syntax, nested...

Keywords: Data Analysis, Excel

Beyond Basics: Conditionals and Visualisation in Excel https://dresa.org.au/materials/beyond-basics-conditionals-and-visualisation-in-excel After cleaning your database, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. This course will cover conditional syntax, nested functions, statistical charting and outlier identification. Armed with the tips and tricks from our introductory Excel for Researchers course, you will be able to tap into even more of Excel's diverse functionality and apply it to your research project. #### You'll learn: - Cell syntax and conditional formatting - IF functions - Pivot Table summaries - Nesting multiple AND/IF/OR calculations - Combining nested calculations with conditional formatting to bring out important elements of the dataset - MINIFS function - Box plot creation and outlier identification - Trendline and error bar chart enhancements #### Prerequisites: Familiarity with the content of Excel for Researchers, specifically: the general Office/Excel interface (menus, ribbons/toolbars, etc.) workbooks and worksheets absolute and relative references, e.g. $A$1, A1. simple ranges, e.g. A1:B5 **For more information, please click [here](https://intersect.org.au/training/course/excel201).** training@intersect.org.au Data Analysis, Excel
Getting Started with Excel

We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors.

This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool,...

Keywords: Data Analysis, Excel

Getting Started with Excel https://dresa.org.au/materials/getting-started-with-excel We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool, Microsoft Excel, to sort, filter, copy, protect, transform, aggregate, summarise, and visualise research data. #### You'll learn: - Introduction to Microsoft Excel user interface - Interpret data using sorting, filtering, and conditional formatting - Summarise data using functions - Analyse data using pivot tables - Manipulate and visualise data - Handy tips to speed up your work #### Prerequisites: The webinar has no prerequisites. **For more information, please click [here](https://intersect.org.au/training/course/excel001).** training@intersect.org.au Data Analysis, Excel
Excel for Researchers

Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. We'll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise,...

Keywords: Data Analysis, Excel

Excel for Researchers https://dresa.org.au/materials/excel-for-researchers Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. We'll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data. While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data. #### You'll learn: - 'Clean up’ messy research data - Organise, format and name your data - Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING) - Perform calculations on your data using functions (MAX, MIN, AVERAGE) - Extract significant findings from your data (PIVOT TABLE, VLOOKUP) - Manipulate your data (convert data format, work with DATES and TIMES) - Create graphs and charts to visualise your data (CHARTS) - Handy tips to speed up your work #### Prerequisites: In order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. **For more information, please click [here](https://intersect.org.au/training/course/excel101).** training@intersect.org.au Data Analysis, Excel
Heurist Tutorials

A set of video tutorials with accompanying walkthroughs for building your first Heurist database and website. The first three tutorials show you how to get started in Heurist. The five subsequent tutorials introduce you to the five main menus in the Heurist interface.

Keywords: Heurist, Data management, Data visualisation, Digital Humanities, Databasing, website

Resource type: tutorial

Heurist Tutorials https://dresa.org.au/materials/heurist-tutorials A set of video tutorials with accompanying walkthroughs for building your first Heurist database and website. The first three tutorials show you how to get started in Heurist. The five subsequent tutorials introduce you to the five main menus in the Heurist interface. michael.falk@sydney.edu.au Johnson, Ian Osmakov, Artem Heurist, Data management, Data visualisation, Digital Humanities, Databasing, website mbr phd ecr researcher support