Students Staff

Learning event search page

Results

EndNote

MPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. Recurring Zoom link for all sessions is: https://essex-university.zoom.us/j/97391299960 With the exception of: 23 June which is: https://essex-university.zoom.us/j/98063555242 This training is delivered using EndNote 20. Participants wanting to follow along, should make sure they have the software installed before the session starts. Find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/student/it-services/endnote OUTLINE EndNote is the University’s free, recommended and supported reference management tool. EndNote will save you valuable time by removing the manual labour associated with creating and formatting references. You can now access the fully-featured desktop software (from software.essex.ac.uk) and manage your EndNote library from multiple computers including your personal device (via myendnoteweb.com). In this course you will learn how to use EndNote to collect, organise and then use references in your Word documents. In this training session, you’ll work through the following exercises: - Collect references from websites like Google Scholar, Albert Sloman Library, Web of Science etc - Find references using the online search feature from within the program - Create your own reference - Create basic groups and search groups to organise your references - Find and remove duplicates - Locate and attach full text articles, then annotate them - Import PDFs - Insert references into Word - Create categories for your references in your bibliography - Trouble shoot common problems - Sync with the online account For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2, 4 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

Excel: conditional formatting

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/92161555447 Task workbook: https://essexuniversity.box.com/s/pzb3oc98lzbc634a1mbq20afj6ppoj7z This training is delivered using Excel 2016. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE Conditional formatting in Excel allows you to automatically apply formatting such as colours, icons, and data bars, to one or more cells, in order to highlight specific data in your spreadsheet. Applying conditional formatting to your data can not only help make your data easier to read, it will also allow you to isolate and then sort and filter your data to get specific results. In this training session you will follow a series of conditional formatting examples using both pre-set functions as well as applying a variety of formulas for more advanced formatting. - Naming ranges to use in formulas - Using pre-set conditional formatting rules - Modifying pre-set rules - Using a variety of formulas to create conditional formatting rules For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

Excel: further functions

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/98578993558 Task workbook: https://essexuniversity.box.com/s/ar2rspxvvprt932i6g6b67rf5hxl9z23 This training is delivered using Excel 2016. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE Improve the efficiency and productivity of your Spreadsheets by learning how to construct functions, manipulate data and format outputs. In this training session, you’ll work through a series of exercises using the following: - Autofill, paste special and format painter - Tables vs named ranges - Relative vs absolute referencing - Basic functions eg SUM, MAX, MIN, DATE eg TODAY() - Concatenate / text to tables - IF functions eg IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF etc - Strings eg LEFT, MID, RIGHT - VLOOKUP, XLOOKUP For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

Excel: pivot tables

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/96925927663 This training is delivered using Excel 2016. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE PivotTables allow you to calculate, summarise, sort, and format your data quickly and easily to see comparisons, patterns and trends. In this session you’ll create and manipulate a variety of PivotTables to answer questions of your data, and finally produce some PivotCharts to create dashboards to visualise your data. - Creating a PivotTable - Configuring a PivotTable - Pivoting a PivotTable - Sorting/filtering data - Changing the data field summary - Creating and manipulating Pivot charts For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

Face Fit training session

You may have staff and students within your department that request or are identified through Departmental Risk Assessments as requiring an FFP2 or FFP3 masks when working or studying on campus. To test that a person’s FFP2 or FFP3 mask fits, a face fit test must be undertaken to identify the best mask and we are looking to have at least one person from each department trained to administer this face fit test so this can be done as required within your department. This training will show you how to undertake this test. Course content includes: • RPE & PPE Regulations “RPE as a last resort” What is RPE? • The Surgical mask or face covering and its limitations • Alternative first steps to reduce exposure. Remove the task, LEV • Do’s & Don’ts with selecting RPE. Oxygen deficient atmospheres & Breathing Apparatus. • Limitations of Qualitative testing – RPE suitable for the Qualitative test method • Selection of RPE – terms “Adequate” & “Suitable” CE labelling of Masks and filters. • Expiry Date on Filters & masks – Types of masks and filter types • Colour coding of filter types. Importance of recognising that particle filters are not gas / vapour filters • Introduction to HSG53 and its contents • The Qualitative RPE fit test pre requisites – filling in the test sheet asking the correct questions. • Do’s & Don’ts when using and testing RPE – other PPE that might interfere with RPE • Explanation of the differences between “Fit Factor” and “Protection factor” • What is protection factor P1/P2/P3 dust & particulate filter examples, relevance to other control measures. • Use of Particulate Filters for Droplet protection in context of Covid 19 • Use of Bitter & Sweet Test Solutions. Allergies to Saccharin A Practical demonstration (participation required) will be carried out during the seminar which includes: • Assembly, Use and care of RPE • Differing type of RPE, Powered Full face, Orinasal, Loose fitting Powered Hood, Disposable FFP. • Full inspection of RPE normally used by participant (FFP2) • Some common faults – all candidates required to recognise 5 faults • Basic Face fit (Disposable FFP type only) • Candidate observed and participated in Qualitative fit testing of FFP Dust masks and demonstrated For more detailed information on fit testing, HSE have written Guidance on respiratory protective equipment (RPE) fit testing INDG479

Outlook: managing a busy inbox

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/98004721956 This training is delivered on a Windows machine using Outlook 2016 (desktop version). Participants wanting to follow along, should make sure they have the software installed before the session starts. NB: Mac users please be aware that QuickSteps and Building Blocks functionality is not currently available on the Mac OS at this time. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE Find out how to use the automatic features in Outlook to help organise your workload and save precious time. - Using Auto correct for your own common words and phrases - Drag and drop to create mail, task and calendar items - Natural language dates - Setting your working hours pattern in your calendar - Using folders to process email - Creating rules and quick steps to process emails automatically - Assigning colour categories to emails - Working with tasks - Using building blocks and email templates for repetitive information - Using the search function and creating search folders to find content quickly and easily For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 4 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

People Management Programme

This programme explores the role of a manager at Essex and provides an opportunity to understand different approaches to develop and manage a high-performing team. The programme is open to both existing managers of all experiences and those aspiring to be managers. We welcome bookings from those who also have supervisory responsibility for others. If you have any further questions about the programme please don’t hesitate to contact develop@essex.ac.uk Please note this programme includes multiple dates and you are required to attend all sessions. This programme is currently being delivered via Zoom and will include multiple breaks. If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient. If attending this event falls outside of your usual working hours, and you incur additional costs due to caring responsibilities, you may be able to claim towards this. One claim per year, of up to £150 is available through the Career Development Fund for Carers. Further information is available on the staff directory or speak to your Line Manager. https://www.essex.ac.uk/staff/pay-and-rewards/career-development-fund-for-carers Autumn term cohort; Day 1 -October 25th 2021 Day 2- November 2nd 2021 Day 3 - November 8th 2021 Day 4 -November 16th 2021 0930-1630 Spring Cohort Day 1 -Jan 18th 2022 Day 2- Feb 07th 2022 Day 3 -Mar 1st 2022 Day 4- Mar 22nd 2022 Summer Cohort Day 1 - April 26th 2022 Day 2 -May 16th 2022 Day 3 - June 1st 2022 Day 4- June 21st 2022