57 Courses

Course Overview The qualification is designed for post-16 learners who want to study sports at university, or are interested in a career within the sports industry. It offers a solid foundation on the various aspects of sport that enables students to develop essential skills and knowledge for gaining employment or progressing to Higher Education. The qualification is split into two 1 year courses, and allows learners to gain up to a maximum of 168 UCAS tariff points – this Is the equivalent of three A* A levels. Level: 3 Duration: 2 year full-time Awarding Body: Pearson Fees: Free Example Units and Structure This qualification is studied across a two year programme, with full time weekly study.Units include:Health, Wellbeing and SportAnatomy and PhysiologySports DevelopmentSports NutritionSports PsychologyResearch methods in sports and exerciseSports coachingApplied Sports CoachingCareers in the Sports IndustrySelf Employment in the sports industryFitness Testing Entry Requirements Five GCSEs at grade 4 to 9 (A to C), including Maths and English alongside GCSE P.E or BTEC Sport. Candidates must also possess an interest in pursuing a career within sports.

An Exciting Practical Face to Face Course with FIONA BALDING, learning about and developing eco printing techniques, for Teachers of GCSE & A Level Textiles, both Art & Design and D&T.

£ Enquire Highfield Functional Skills Qualification in Mathematics, level 2 45 - 50 hours

£ Enquire Highfield Functional Skills Qualification in Mathematics, level 1 45 - 50 hours

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

A simple pattern drafting course for anyone wanting to learn how to make their own blocks from scratch - great for teachers of GCSE & A Level Fashion & Textiles for both Art & Design and D&T.

Unlock Potential

Welcome to GLA Tutors, a pioneering platform for primary school tutoring and SATs preparation.  At GLA Tutors, we understand the importance of a strong foundation in primary school subjects and strive to provide comprehensive support to help children excel in their academic journey. Our team of expert tutors is well-versed in the English National Curriculum, which forms the basis of primary school education in the UK. We have carefully analysed the curriculum requirements to ensure that our tutoring services cover all key subjects and align with the learning objectives set by the curriculum. Our provision for tutoring all primary school subjects encompasses a wide range of subjects, including: 1. English: - Reading comprehension - Vocabulary development - Grammar and punctuation - Writing skills 2. Mathematics: - Number and place value - Addition, subtraction, multiplication, and division - Fractions, decimals, and percentages - Geometry and measurement 3. Science: - Investigating scientific phenomena - Understanding the natural world - Conducting experiments and making observations - Developing scientific thinking and inquiry skills 4. History: - Understanding historical events and timelines - Exploring significant figures and civilizations - Analysing primary and secondary sources - Developing historical knowledge and critical thinking skills 5. Geography: - Studying different landscapes and environments - Investigating human and physical geography - Exploring global issues and sustainability - Developing geographical skills and understanding At GLA Tutors, we understand that preparing children for SATs can be a challenging task. Our tutors are well-versed in the SATs format and content, and they provide targeted support to help children excel in their exams. We cover all areas of the SATs, including English (reading, grammar, and writing) and Mathematics, ensuring that children are well-prepared and confident on exam day. Our tutoring sessions are designed to be engaging and interactive, fostering a love for learning and encouraging children to reach their full potential. We use a variety of teaching techniques, including hands-on activities, visual aids, and interactive resources, to make learning enjoyable and effective. With GLA Tutors, you can be assured that your child will receive top-quality tutoring in all primary school subjects and be well-prepared for SATs. Our tutors are committed to providing personalised support, tailoring their teaching methods to meet the unique learning needs of each child. Join us and let us help your child thrive academically and achieve success in their primary school journey and SATs.