1600 Courses in Cardiff delivered Live Online

The course will cover special procedures and the benefits of using IP and OP in your compliance.

Historical Association webinar series: Direct history teaching Presenters: Mike Hill and Jacob Olivey In this second session, Jacob and Mike will share how history teachers can teach substantive knowledge (what we know about the past) in more direct ways – whilst still challenging and engaging pupils. They will share ideas about using lean resources and high-quality images, worldbuilding through storytelling, and building lessons around extended texts. To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/Qr1PfgRHSS We are able to offer the webinars in this series at a subsidised cost as the presenters' time has been partially funded by their school, Ark Soane Academy. We are open to developing partnerships across schools and trusts. If you are interested in discussing this further, please contact Mel Jones at melanie.jones@history.org.uk

Historical Association webinar series: Building different types of historical knowledge Presenters: Claire Holliss This second session will consider how teachers have helped their students to develop coherent explanations of historical processes and to form judgments in response to historical questions. The session will then engage with the rich tradition of practitioner research on students’ writing at A-level, particularly focusing on how teachers have helped students engage with historical writing in order to gain a more sophisticated understanding of the discipline and to strengthen their written work.   To use your corporate webinar offer on this webinar please fill in this form: https://forms.office.com/e/9JZCQ0RUkJ

Transform stress into strength with this 4-week course, enhancing resilience, emotional skills, and effective communication for professionals.

In this series we invite globally respected studios to walk us through the processes and methods they employ when working with clients.

Historical Association webinar series: Building different types of historical knowledge Presenters: Claire Holliss This third session will focus on how a range of different teachers have dealt with student misconceptions about interpretations. It will first consider how teachers have helped their students to read the work of historians sensitively and will then discuss how teachers have designed teaching sequences to build students’ understanding of this aspect of the discipline.   To use your corporate webinar offer on this webinar please fill in this form: https://forms.office.com/e/9JZCQ0RUkJ

Historical Association webinar series: Draft Ofsted toolkits; implications for primary history Presenter: Dan Hartley This session will give an overview of the main areas of the school inspection toolkit, and how history could contribute to ensuring the school receives a positive outcome. The session will explore the main areas of the toolkit, how grades are given, and the potential role history subject leaders have in contributing to the overall evidence of the school report card.   To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/yk4dj9vXXs

Historical Association webinar series: Direct history teaching Presenters: Mike Hill and Jacob Olivey In this third session, Jacob and Mike will argue that a history teacher should always be a sage on the stage – and not a guide on the side. They will share strategies that allow history teachers to drive learning for an entire class, ensuring that all pupils pay attention, take part in the lesson, and feel successful. To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/Qr1PfgRHSS We are able to offer the webinars in this series at a subsidised cost as the presenters' time has been partially funded by their school, Ark Soane Academy. We are open to developing partnerships across schools and trusts. If you are interested in discussing this further, please contact Mel Jones at melanie.jones@history.org.uk

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.