I.T. RelatedCourses
Please note that I am currently offering any of my Face to Face Courses as an online course, delivered through Microsoft Teams (or similar tool of your choice). The content will remain the same, although the way the material is presented, and how activities are completed, may change.
Quantitative analysis using SPSS
Aims:
To enable participants to utilise SPSS in simple database setup and manipulation
To understand how SPSS can be utilised in analysing quantitative research data.
Content:
Workshop containing all basic elements of using the SPSS package effectively.
Duration:
3 hours
Prerequisites:
Completion of Introduction to Descriptive Statistics session, or similar understanding
Completion of Introduction to Inferential Statistics session, or similar understanding
Completion of Analysing Your Data session, or similar understanding
PC Skills – Keyboard and mouse skills
Quantitative Analysis using SPSS - part 2
Aims:
To enable participants to utilise SPSS for more complex data manipulation
To understand how to write replicable code
To understand how to perform more complex analysis
Content:
Workshop containing more advanced features of SPSS, including executing syntax.
Duration:
3 hours
Pre-requisites:
Completion of "Introduction to Descriptive Statistics" session, or similar understanding
Completion of "Introduction to Inferential Statistics" session, or similar understanding
Completion of "Analysing Data" session, or similar understanding
Completion of "Quantitative Analysis using SPSS - part 1" or similar understanding
PC Skills – Keyboard and mouse skills
An Introduction to MS Excel Macros
Aims:
To introduce participants to Macros from the in-built menus
To be able to enable macros within a worksheet
To understand where different macros can be stored, and the implications for sharing with others
To understand how to record macros
To understand the value of absolute and relative references, and how combining them gives more powerful macros
To understand how to use keyboard shortcuts in macros, and the advantage of this
To understand how to look at, and resolve errors
To introduce participants to macros using VBA
To understand how macros are structured
To introduce participants to macros and VBA on the web
To introduce the concept of looping code
To be able to add control buttons to recorded macros
Content:
Workshop containing all major elements of using macros within Microsoft Excel effectively.
Duration:
½ Day
Prerequisites:
Knowledge of Microsoft Excel
Microsoft Excel installed on client machine
PC Skills – Keyboard and mouse skills
Power Pivot and Power Query in MS Excel / Power BI
Aims:
To understand how to import different data types into Power Query, including SQL
To introduce the concept of MCODE
To understand how to use multiple files in Power Query
To be able to filter data
To be able to append data
To understand automatic updates within Power Query
To understand the key Power Query functions
To understand the different ways of “loading data”, including pivot table cache
To understand the concept of recurrency and how to deal with it
To understand operators (lookup and positional)
To understand how to merge file (replacing vlookup in Excel)
To understand how to append different file formats
To understand the concept of unpivoting data
To introduce the concepts of joins and merges
To understand grouping functions
To understand the “data model” and how to build relationships
To introduce the concept of DAX formulae
Content:
Workshop containing all major elements of using Power Query and Power Pivot with Microsoft Excel. Please note that this course does not look at DAX functions in detail.
Please Note: The principles taught in this session can be applied to both Microsoft Excel or Microsoft PowerBI
Duration:
2 Days
Prerequisites:
Knowledge of Microsoft Excel
Microsoft Excel / Microsoft Power BI installed on client machine
PC Skills – Keyboard and mouse skills
Quantitative Analysis using Jamovi fronted R (Open Source)
Aims:
To enable participants to utilise JAMOVI in simple database / spreadsheet setup and manipulation
To understand how JAMOVI can be utilised in analysing quantitative research data.
To apply statistical principle to data, and perform statistical tests on two groups
To enable participants to utilise add on modules to add functionality to JAMOVI
To understand how to write replicable code that can be used in R
To apply statistical principle to data, and perform statistical tests on three or more groups
To understand how to perform more complex analysis, including regression methods and time series
To understand how JAMOVI output can be shared with others
Content:
Jamovi is a “3rd generation” statistical spreadsheet. designed to be easy to use, It is a good alternative to costly statistical products such as SPSS and SAS. It is built on top of the R statistical language, giving access to the best the statistics community has to offer. It is ideal for those trying to learn R but who still like graphical menus and interactions. This workshop covers all the major elements of using the open source Jamovi package effectively.
Duration:
1 Day
Prerequisites:
Completion of Key Statistical Concepts, or similar understanding
Completion of Regression Methods or similar understanding
Completion of Time Series and Forecasting, or similar understanding
Jamovi, R and R Studio installed on client machine
PC Skills – Keyboard and mouse skills