Study Plus Courses

Broadening horizons and expanding minds


Our Skills & Employability courses

KE024 - Talking Cultures: Exploring Intercultural Competence

Course dates: Every Wednesday during weeks 15-18 and 20
Times: 14:00- 16:00
Number of hours: 10 hours (5 x 2 hour sessions)
Employability Points: 20 points maximum (Based on 100% attendance)

employment

Talking Cultures

Course outline

The module which tackles the notion of intercultural communication, aims to develop students' engagement and integration with their fellow classmates within a contemporary internationalised classroom. The module will help to increase awareness of cultural differences and will explore cultural heritage, prejudices and stereotypes.
Thematic areas that will be covered in the seminar/workshops but not necessarily in the order they are presented below are:

  • Cultural knowledge and identity (of other cultures, people, nations, behaviours ...) with emphasis on ways to compare and contrast cultures, identify fundamental differences between cultures and the notion of cross-cultural understanding
  • Politeness, respect and power
  • Identifications of problems that can occur during spoken discourse and social interaction

Learning outcomes

Students successfully completing this module will:

  • have a greater understanding of the way people communicate  within and across social groups
  • have a greater understanding of their own culture and themselves
  • awareness of ethnocentrism
  • awareness of cultural bias
  • knowledge about other cultures
  • develop a sensitivity to the social, cultural and political issues which surround language

 

KE029 - Rosie 2 - A Child Protection Simulation: Serious Games and Simulation in Child Protection

towns-and-townspeople

Rosie 2 - A Child Protection Simulation

Date: Tuesday 6 March 2018 (week 20)
Time: 15:00-18:00
Number of hours: 3 hours (1x 3 hour session)
Employability Points: 15 points maximum
(Based on 100% attendance)

 

Course outline

The Centre for Child Protection at the University of Kent is a hub of excellence and innovation in training, research and practice and has been received many awards in recognition of this including the 2017 Higher Education Academy Award for Teaching Excellence. Please visit our website to learn more about us:
https://www.kent.ac.uk/sspssr/ccp/

CHILD PROTECTION: THE USE OF TECHNOLOGY AND INNOVATION IN TRAINING

  • Are you interested in learning about innovative approaches to learning in child protection?
  • Do you have an interest in the application and potential for learning through simulation and serious games?
  • Learn and engage with the Centre for Child Protection which is leading proponents in the field of innovative simulation.
  • This is an exciting opportunity to learn about a difficult topic and consider we should respond in the 21st century using a relevant evidence base and technological know-how.
  • What is the future for learning? What could it be?

'ROSIE 2’: A CHILD PROTECTION SIMULATION

The computer based simulation ’Rosie 2’ was developed by the Centre for Child Protection in 2012, in direct response to evidence and research in the area of child protection. ‘Rosie 2’ is a professional learning and development tool designed to be used by all professionals working with child protection (social workers, nurses, teachers, police etc.) to explore and better understand the issue of child neglect.

The child protection simulation (serious game) concept offers a safe new medium to explore and reflect upon child protection assessment and practice. It offers a unique and innovative way to evaluate child protection situations.
‘Rosie 2’ is relevant and useful to newcomers to the filed, and those with more experience and helps consider the potential and possibilities of learning through new technology. New technologies offer original, relevant and exciting ways to learn and engage with complex and challenging topic areas.

The session has broad disciplinary relevance and will enhance students understanding of the potential for enhanced learning through technology.

Content:

  • What is a serious game/Simulation?
  • What are the benefits of the use of technology in professional training?
  • How did the Centre for Child Protection develop ‘Rosie 2’ and why?
  • Playing the game – how does this simulation work and engage professionals?
  • Eye tracker and facial recognition technology

Students will participate in a half-day session which will combine lecture delivery with seminar discussion.

Please be aware that this course discusses difficult and sensitive issues relating to child protection. We would encourage you to seek appropriate support and advice if the course content raises any personal issues or causes you distress.

Learning outcomes

By the end of the module, you will:

  • An overview of the current policy and practice base of child protection in the UK context.
  • Be able to identify and discuss some of the key elements of child neglect.
  • Knowledge of the significance of using child protection simulations (serious games) in developing skills and knowledge in what is a highly emotive working environment.
  • Understanding and knowledge around the Centre’s research using eye tracker and facial recognition technology.
  • An opportunity to discuss how decisions are made, their impact upon workers and the importance of achieving the best outcomes for children.

 

KE044 - Journalism (Medway Campus)

Start date: Monday 11 June 2018 (week 30)
End date: Friday 15 June 2018 (week 30)
Time: 10:00-16:00 (5x two hour sessions)
Number of hours: 25 hours contact time (five sessions of 5 hours) + 5 hours private study
Location: Medway Campus
Employability Points: 60 points maximum (based on 100% attendance)

 

journalism

Journalism

Course outline

This course offers an intensive immersion in the basic principles and practices of professional journalism in the multimedia age. During five consecutive days of teaching, you will learn what professional journalists do, how they do it and how their work informs the public sphere. You will experience the pressure and the pleasure of making real journalism  to real deadlines under professional leadership. 

Monday: What is journalism for? Reporting politics. Reporting for newspapers. Journalism law and ethics.

Tuesday: Making a newspaper.

Wednesday: Editorial conference. Reporting for radio. Making radio news.

Thursday: Editorial conference. Reporting for television. Making television news.

Friday: Editorial Conference.  Reporting online. Making news for the Internet.

  • six hours of lectures, five hours of newsroom workshops, 12 hours live news days, two hours of editorial conferences. 
  • you will be expected to spend five hours reading newspapers, listening to radio news and, watching television news in preparation for editorial conferences and news days.

Watch the video.

 

Please note, this course takes place at the Medway Campus. A free shuttle bus is available from the Canterbury campus.

You must book a ticket online before you travel.

Learning outcomes

At the end of this course you will:

  • Be aware of major debates about the value and purposes of journalism
  • Have a basic understanding of the relationship between government and journalists
  • Understand the responsibility journalists have to report accurately and fairly
  • Understand key processes, principles and skills involved in writing for publication in print and online
  • Understand what a news story is and why different news providers treat them in different ways
  • Acquire writing, interviewing and note-taking skills and experiment in deploying them in the coverage of news stories
  • Understand key processes, principles and skills involved in reporting for radio, television and online
  • Know how to gather organise and deploy ideas for radio, television and online journalism
  • Develop basic skills in writing cues, reports and headlines for radio and television news bulletins.
  • Understand the structure of editorial teams in broadcasting, newspapers and online publications.  
  • Have a basic understanding of those elements of the English legal system within which the law relating to freedom of expression and the media is administered.
  • Have an understanding of the ethical principles underlying the notion of freedom of expression, its promotion by the state and also the restrictions placed upon it by the law
  • Have an understanding of the tensions between the state’s support of freedom of expression and the legal restrictions placed upon it  

 

KE051 - Clio Barnard Workshop: Writing and Directing Feature Length Fiction for Cinema - The Selfish Giant

Course date: Wednesday 14 March 2018 (week 21)
Time: 13:00 - 16:00
Number of hours: 3 hours (1x 3 hour session)
Employability Points: 10 points maximum (Based on 100% attendance)

SELFISH-GIANT

The Selfish Giant

Course outline

The interactive workshop will last for three hours; it will explore writing and directing a feature film for theatrical distribution using The Selfish Giant (Directed by Clio Barnard Film4 BFI 2013 90mins) as a case study.

One hour will focus on discussing development, research and screenwriting, another hour on pre-production/production/post-production, and another hour on distribution and exhibition.

The workshop will give the participants an introductory overview of writing and directing a feature film for theatrical distribution from initial idea through to completion and exhibition.

All participants must watch the film in preparation for the workshop. You can access a DVD of the film free of charge in the university library. You can also stream it via the BFI
http://player.bfi.org.uk/film/watch-the-selfish-giant-2013/ and claim the cost of this if you bring proof of payment to the workshop.

Learning outcomes

During this module, students will:

  • explore the writing and directing of a feature film for theatrical distribution using The Selfish Giant (Dir. Clio Barnard Film4 BFI 2013 90mins) as a case study
  • have the opportunity to discuss what is involved with the development, research and screenwriting of a film
  • consider key concepts involved with film production such as pre-production/production/post-production
  • explore what is involved with the distribution and exhibition of a feature length film

 

KE086 - Zak & Lottie: Tackling Online Radicalisation and Sexual Grooming

Zak and Lottie

Zak & Lottie: Tackling Online Radicalisation and Sexual Grooming

Date: Wednesday 7 February 2018 (week 16)
Time: 13:00-16:00
Number of hours: 3 hours (1x 3 hour session)
Employability Points: 15 points maximum
(Based on 100% attendance)

Course outline

A standalone 3 hour workshop based on the Centre for Child Protection serious game simulations Zak, spotting the signs of radicalisation and Lottie, tackling online sexual grooming. There will be an introduction into grooming methods.

Students will then go through the simulations as a group with the opportunity for small group activities and self-reflection on their own internet usage and safety.

Please be aware that this course discusses difficult and sensitive issues relating to child protection. We would encourage you to seek appropriate support and advice if the course content raises any personal issues or causes you distress.

Learning outcomes

On successful completion of this course students will be able to:

  • Demonstrate an increased awareness around the process of radicalisation and Grooming
  • Identify and discuss factors/indicators of radicalisation and Grooming
  • Consider aspects of internet safety
  • Self-reflect on their own and other behaviour
  • Understand where and to whom they should report their concerns on radicalisation, internet safety, grooming and exploitation
  • Identify some of the procedures in place to support individuals affected by these issues
  • Recognise factors attributed to the grooming process
  • Understand how to stay safe both on and offline
  • Identify and discuss  factors/indicators of online grooming and exploitation

 

KE087 - Screenwriting for Non-Writers: How to Provide Shape, Voice and Style to your Creative Ideas.

Dates: Saturday 24 Feburary 2018 (week 18) and Saturday 10 March 2018 (week 20) N.B. You will need to attend both sessions
Time: 10:00- 14:00
Number of hours: 8 hours (2x 4 hour sessions)
Employability Points: 20 points maximum (Based on 100% attendance)

screenwritingScreenwriting

Course outline

This course is designed to encourage writing for non-specialists, using storytelling and screenwriting as essential tools for further writing and creative pursuits

Through a two-phase lecture and workshop course, you will learn the fundamentals of storytelling and screenwriting and then apply these to your own creative ideas.

You will also be able to share and pitch your ideas.

No prior writing experience or screenwriting expertise required.

 

Learning outcomes

This course will:

  • encourage you to write for personal pleasure and instil confidence and purpose
  • develop your writing skills by teaching the principles of storytelling
  • teach you how to shape ideas into a tangible creative product (screenwriting).
  • teach you how to conceive, plan and write a screenplay after learning the creative and critical approaches to storytelling for the screen
  • teach you to use personal or cultural experiences to generate storytelling potential, especially for the screen

 

 

KE095 - How to Communicate with Confidence

Dates: Wednesday 31 January 2018 and Wednesday 7 February 2018 (Weeks 15 and 16)
Time: 13:00-16:00
Number of hours: 6 hours (2 x 3 hour sessions)
Employability Points: 30 points maximum (Based on 100% attendance)

communicate

How to communicate with confidence

Course outline

This interactive workshop will help you to communicate clearly and confidently even when faced with challenging situations.  Through group work and self-reflection activities we will cover how your preferred communication style affects your relationship with others, how to speak so that others listen and how to really listen to others.  We will practice various techniques which will enable you to have constructive conversations with others rather than avoiding them or having a confrontation.

Learning outcomes

By the end of this course, you should be able to:

  • recognise various communication styles and respond appropriately
  • identify your own preferred communication style and its impact on others
  • enhance communication with others using effective listening skills
  • give and receive feedback (compliments and criticisms) in a constructive manner
  • communicate effectively with others instead of arguing or avoiding them
  • deal confidently with other people’s expectations and demands (without feeling anxious or guilty)
  •  

KE096 - Sharpen your writing skills for work

Start date: Wednesday 28 February 2018 (Week 19)
End date: Wednesday 7 March 2018 (Week 20)
Time: 13:00-16:00
Number of hours: 6 hours (2 x 3 hour sessions)
Employability Points: 30 points maximum (Based on 100% attendance)

writing skills

Sharpen your writing skills for work

Course outline

At the university's career fair, graduate recruiters put communication skills top of the list. Sadly for them, about 20 per cent of graduates’ English skills are not up to scratch for the workplace.

Employers look for confident, professional communicators. They want people who write clearly, concisely and effectively. Whether you’re emailing a colleague or drafting the annual report, your writing has to be accurate, and make things happen.

This practical workshop course will help you make your words count. We’ll pin down the function of different kinds of writing. We’ll identify who we’re writing for. We’ll learn about tone, content and structure. We’ll include a scattering of grammar and punctuation so you’ll avoid the worst pitfalls.

Above all, we’ll write. Bring a pen and paper or a laptop and be ready to try out all kinds of writing.

Learning outcomes

By the end of this course, you should be able to:

  • Understand what writing skills employers look for
  • Be ready to write clearly, accurately and effectively in a professional context
  • Have a toolkit for approaching any piece of writing, from emailing the CEO to writing a press release
  • Be ready to write a persuasive and effective CV.

 

 

KE097 - Meditation for study, work and life

Date: Wednesday 21 February 2018 (Week 18)
Time: 13:00-16:00
Number of hours: 3 hours (1x 3 hour session)
Employability Points: 10 points maximum (Based on 100% attendance)

meditation

Meditation for study, work and life

Course outline

A practical introduction for students into meditative practices drawing from Mindfulness (awareness in the moment), Focus and Taoist approaches and exploring their application to support students’ study, work, life and goals.

Basic principles and aims of meditation will be presented first, highlighting its key attributes as a low-cost, proven, effective, systematic method for training the mind, coping with stress and helping us to achieve goals.

Background, principles and strengths of the three meditative techniques to support students’ specific study, work and personal goals will then be examined followed by a representative practise of:

  • Mindfulness meditation (awareness in the moment)
  • Focus meditation
  • Taoist meditation

Outlines of the historic, religious and philosophic background of each approach will provide students with context to consider the contemporary interest in meditative practices and relevance of meditation to their own situation.

To conclude students will consider experiences, and may seek advice on continued practise and further developments in the field, such as pain-management.

Students should wear shoes with flexible soles and comfortable clothes to keep warm while sitting meditating and to allow mobility in light preparatory and for mindful movement.

Learning outcomes

By the end of this course, you should be able to:

  • understand the potential of meditation for study, work and life
  • illustrate some of the roots and purposes of meditative practise
  • identify basic principles of meditation and how they are applied
  • learn contemplative skills of mindfulness, focus, and personal transformation
  • pragmatically apply a toolkit of 3 meditative approaches to suit their needs

 

KE104 - Student Mentoring at University (Canterbury Campus OR Medway Campus)

Dates: Every Wednesday during weeks 6-11 and 13-18 (Canterbury and Medway)
Canterbury Times: 13:00-14:00 OR 14:00 - 15:00 OR 15:00-16:00
Medway Times: 14:00 - 15:00
Number of hours: 12 hours (12x 1 hour sessions)
Employability Points: 60 points maximum (Based on 100% attendance)
Location: Canterbury campus OR Medway Campus

mentoring at university

Student Mentoring at University

This course will provide an understanding of mentoring in an academic setting and a recognition of how the skills gained can be applied in the workplace.  For those already mentoring on the Academic Peer Mentoring Scheme, the course will enhance and extend the skills learned in training, and those new to mentoring will develop an understanding of the core elements of how to support their peers.

Course outline

  • Week 1: Introductions and discussion on what new students find challenging about university study
  • Week 2:What are mentors' characteristics and what skills do you need to develop?
  • Week 3: Planning a session: you will work together in subject groups to plan the content of a mentoring session.
  • Week 4: Research methods for evaluating mentoring. You will develop a questionnaire to analyse the impact of your mentoring.
  • Week 5: Team work: you will be introduced to Belbin's team roles theory and will use it to identify your own role in the mentoring team.
  • Week 6: Mid-year review.
  • Week 7: Planning a session: how to help a mentee to set goals and plan their time.
  • Week 8: Equality issues in mentoring and power dynamics.
  • Week 9: Careers Service session reflecting on mentoring skills and developing your CV.
  • Week 10: Mental health and wellbeing session recognising students' stress and signposting to services.
  • Week 11: Cross cultural communication.
  • Week 12: Evaluating yourself as mentor.

Learning outcomes

  • On successful completion of this course, you will be able to:

    • Understand the role of mentoring at university
    • Communicate effectively with other students face to face and via email
    • Guide small groups of students in their learning and facilitate discussion
    • Work effectively as part of a small team
    • Reflect on the skills of mentoring such as communication, problem solving, team work and leadership

This course will be running at both our Canterbury and Medway campuses. Please ensure you sign up for the correct course. The Canterbury sessions are on Wednesdays, the Medway sessions are on Fridays.

 

 

KE105 - Beginners' Presentations with Microsoft PowerPoint

Dates and times: Friday 26 January 2018 (Week 14) 11:00-12:00 OR Tuesday 6 March 2018 (Week 20) 15:00-16:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

MS-PowerPoint

Beginners' Presentations with Microsoft PowerPoint

Course outline

This is a practical computing session covering:

  • How to prepare a Presentation from scratch in Microsoft PowerPoint
  • How to use themes, slide layouts and tools to create a consistent presentation
  • How to apply a variety of formatting features
  • How to set up a slide show and apply slide transitions

You will be provided with a workbook should you wish to continue exploring in your own time.

Learning outcomes

On successful completion of this course, you will be able to:

  • Use presentation fundamentals
  • Create new and work with existing presentations
  • Use themes and pre-defined presentations
  • Insert and work with different slide layouts
  • Use a variety of formatting tools
  • Use different PowerPoint objects, e.g. Pictures, Charts, Shapes
  • Set up a slide show
  • Apply slide transitions

 

KE106 - Preparing Essays with Microsoft Word

Dates: Thursday 15 February 2018 (Week 17)
Times: 11:00 - 12:00
Number of hours: 1
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

Word

Preparing Essays with Microsoft Word

 

Course outline

This is a single practical computing session covering:

  • How to prepare an essay in Microsoft Word using word-processing features and safely save files to the Kent network.
  • How to apply a variety of formatting features to enhance essays and use some automatic formatting features to save time
  • How to review and prepare your essay for printing

You will be provided with a workbook should you wish to continue exploring in your own time.

Learning outcomes

On successful completion of this course, you will be able to:

  • Use word processing fundamentals
  • Create new and work with existing documents
  • Edit text and arrange text easily
  • Apply formatting to text and paragraphs
  • Use editing tools to find and replace text
  • Use the spell checker
  • Understand headers and footers
  • Change page layout options

 

KE108 - Beginners' Spreadsheets with Microsoft Excel

Dates: Thursday 15 February 2018 (week 17)
Times: 15:00-16:00
Number of hours: 1
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

word

Beginners' Spreadsheets with Microsoft Excel

 

Course outline

This is a single practical computing session covering:

  • How to prepare a spreadsheet in Microsoft Excel
  • How to create simple formulae and use basic built-in functions
  • How to apply a variety of formatting features and set print options
  • How to prepare a worksheet for printing

You will be provided with a workbook should you wish to continue exploring in your own time.

Learning outcomes

On successful completion of this course, you will be able to:

  • Use spreadsheet fundamentals
  • Create new and work with existing spreadsheets
  • Create simple formulae
  • Format the display of cells
  • Edit, copy and move cells
  • Set printing options and preview
  • Use basic functions

KE109 - Preparing Dissertations or Extended Assignments with Microsoft Word

Dates and Times: Thursday 22 February 2018 (week 18) 10:00-11:30 OR Tuesday 6 March 2018 (week 20) 10:00-11:30
Number of hours: 1.5
Employability Points: 10 points maximum (Based on 100% attendance)
Location: Canterbury campus

word

Preparing Dissertations or Extended Assignments with Microsoft Word

 

Course outline

This is a single practical computing session covering:

  • How to prepare a dissertation or extended assignment in Microsoft Word using many of the advanced features
  • How to apply and modify styles to create consistent looking documents and enables the creation of a table of contents
  • How to use referencing tools including footnotes, endnotes and captions
  • How to create tables of figures
  • How to divide your documents into sections and control page numbering
  • How to use different headers and footers across document sections

Learning outcomes

On successful completion of this course, you will be able to:

  • Produce professional looking documents
  • Apply and modify styles
  • Create tables of contents
  • Use referencing tools including footnotes, endnotes and captions
  • Create tables of figures
  • Work with sections

You will be provided with a workbook should you wish to continue exploring in your own time.

KE113 - Business Start-Up Workshops - Canterbury Campus

Date: Every Wednesday during weeks 15-19
Time: 15:00-17:00
Number of hours: 10 (5 x 2 hr sessions)
Employability Points: 50 points maximum (based on 100% attendance)
Location: Canterbury campus

busines-start-up

Business Start-Up Workshops

Course outline

Kent Invicta Chamber of Commerce, who have been advising and guiding individuals through the process of how to start and run a successful business for years, will run five 2 hour workshops spread over five weeks. Delivered in group sessions with like-minded students, you will benefit from a series of intensive workshops that will cover the following topics:

  • Generating a business idea,
  • Testing a business idea
  • Developing marketing research
  • Understanding sales processes
  • Pricing
  • Planning cash flow
  • Knowing your tax, insurance and VAT requirements
  • Understanding the elements of a business plan

Workshop 1: 'The Beginning'

  • Introductions
  • Ideas Generations
  • Group Task and Presentations
  • Guest Key Note Speaker

Workshop 2: 'What do you need?'

  • Legal
  • Insurance
  • Tax
  • Regulatory
  • Landlord
  • Operational
  • Staff
  • Timetables
  • Bookkeeping/records
  • Guest Key Note Speaker

Workshop 3: 'Sales and Marketing'

  • PESTEL analysis
  • Strengths and weaknesses
  • Who is the customer?
  • Who will sell and how?
  • Buying drivers
  • S&M template
  • Intellectual property rights - identifying and defending
  • Guest Key Note Speaker

Workshop 4: 'Finance, Funding, Tax and Insurances'

  • Personal budget
  • Cash flow and P&L objectives
  • Start-up and running costs
  • Funding help
  • Guest Key Note Speaker
  • Different business structures
  • Accruing for tax, different types
  • Your liabilities – the risks
  • Insurances:
    • Personal Insurance
    • Public Liability
    • Business
    • Professional associations
    • Critical person
    • Employers

Workshop 5: 'The Business Plan'

  • Why bother, who is it for?
  • KICC template
  • Elements of the business plan
  • Guest Key Note Speaker

Learning outcomes

The workshops have been structured so that all students who are interested in freelancing or being
self-employed can feel confident that they’ll walk away with valuable information. Whether you
want to start a business after graduation, or use freelancing as a tool to build a portfolio, these workshops
are the right starting point.
By the end of this course, you should be able to:

  • Pitch a business idea
  • Understand the finances, legalities and processes for starting up a business
  • Identify a suitable structure for a business plan

 

KE125 - Advanced Spreadsheets 1: Lookup Functions in Microsoft Excel

Date: Wednesday 24 January 2018 (week 14)
Time: 11:00-12:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

Please note: you will require a good working knowledge of Microsoft Excel for this workshop

excel

Advanced Spreadsheets 1 Microsoft Excel

Course outline

This is a single practical computing session covering Lookup Functions in Microsoft Excel, including:

  • How to create a lookup table in Microsoft Excel
  • How to use vertical and horizontal lookup functions
  • How to populate lists using lookups

Learning outcomes

On successful completion of this course, you will be able to:

  • Use vertical and horizontal lookup functions
  • Create lookup tables
  • Confidently use lookups to populate lists

You will be provided with a handout.

KE126 - Advanced Spreadsheets 2: Sorting and Filtering Lists in Microsoft Excel

Date: Friday 2 February 2018 (week 15)
Time: 11:00-12:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

 

Please note: you will require a good working knowledge of Microsoft Excel for this workshop

excel

Advanced Spreadsheets 2 Microsoft Excel

 

Course outline

This is a single practical computing session covering sorting and filtering lists in Microsoft Excel, including:

  • How to sort a list safely
  • How to filter information in a list
  • How to filter using an advanced tool to select multiple data

Learning outcomes

On successful completion of this course, you will be able to:

  • Use basic Sorting and Filtering tools
  • Use an advanced filter to pick out specific data

KE127 - Advanced Spreadsheets 3: Pivot Tables in Microsoft Excel

Date: Wednesday 7 February 2018 (week 16)
Time: 11:00-12:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

Please note: you will require a good working knowledge of Microsoft Excel for this workshop

excel

Advanced Spreadsheets 3 Microsoft Excel

Course outline

This is a single practical computing session covering Pivot Tables in Microsoft Excel, including:

  • How to create a Pivot Table in MS Excel
  • How to filter a Pivot Table
  • How to filter and group data in Pivot Tables
  • How to create a Pivot Chart

Learning outcomes

On successful completion of this course, you will be able to:

  • Create a Pivot Table
  • Format Pivot Tables
  • Filter Pivot Tables
  • Group data in Pivot Tables
  • Create Pivot Charts

You will be provided with a handout.

KE143 - Advanced Spreadsheets 4: Charts in Microsoft Excel

Date: Wednesday 21 February 2018 (week 18)
Time: 11:00-12:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

 

Please note: you will require a good working knowledge of Microsoft Excel for this workshop

excel

Advanced Spreadsheets 4 Microsoft Excel

 

Course outline

This is a single practical computing session covering charts in Microsoft Excel, including:

  • How to create different charts
  • How to format and enhance charts
  • How to set up charts for printing

Learning outcomes

On successful completion of this course, you will be able to:

  • Create simple charts
  • Explore different chart types
  • Format charts
  • Enhance charts
  • Print charts

You will be provided with a handout.

KE144 - Advanced Word Processing: Mail Merge in Microsoft Word

Date: Monday 12 March 2018 (week 21)
Time: 15:00-16:00
Number of hours: 1 hour
Employability Points: 5 points maximum (Based on 100% attendance)
Location: Canterbury campus

Word

Advanced Word Processing: Mail Merge in Microsoft Word

Course outline

This is a single practical computing session covering:

  • How to prepare a mail merge document
  • How to edit and organise recipient lists
  • How to use mail merge rules
  • How to complete a mail merge
  • How to mail merge to labels

You will be provided with a workbook should you wish to continue exploring in your own time.

Learning outcomes

On successful completion of this course, you will be able to:

  • Create and edit a mail merge document
  • Work with various data sources
  • Merge documents
  • Perform merge queries
  • Merge labels

 

KE148 - U. N. I. (You and I) Protect

Dates: Every Friday during weeks 20-22 inclusive
Times: 10:00-11:30
Number of hours: 4.5 hours (3x 1.5 hour sessions)
Employability Points: 15 points maximum (Based on 100% attendance)
Location: Canterbury Campus

UNI Protect

U.N.I. (You and I) Protect

Course outline

The ‘U.N.I (You and I) Protect’ movement encourages students to be active bystanders by equipping students with the skills to recognise and safely intervene in an instance of sexual harassment or abuse.


The course will be delivered in three workshops by experienced facilitators and each workshop will last approximately 1.5 hours.
You will be asked to complete an anonymous ‘Social norms’ questionnaire in the first session and will be asked to provide feedback at the end of the course.

There will be no homework but resources and readings are available on the Moodle site if you wish to learn more about the issues raised in the workshop.


Please note that there are important ground rules to consider for this course, specifically around confidentiality and please also be aware that throughout the course the group will be discussing sensitive issues. The sessions are run by experienced Facilitators who can help and support the participants and the Wellbeing Team are also available for support, if needed.

 

Learning outcomes

  • On successful completion of this course students will be able to:
    • Understand what a ‘bystander’ is, form ideas about the types of situations which might call for a bystander intervention and become confident and motivated active bystanders.
    • Develop familiarity with intervention strategies and be safe and comfortable practising intervention behaviours
    • Understand that individuals can often be mistaken about others’ beliefs and values
    • Understand why sexual violence and domestic violence is a problem in society and in student populations
    • Recognise the links between sexist attitudes, discriminatory practices and gender based violence; and,
    • Understand more detail about rape and sexual assault including rape ‘myths’, male rape and sexual assault, law definitions and issues around consent

       

KE151 - European Computer Driving Licence (ECDL)

Dates: Every Wednesday during weeks 14-23 (24 January 2018 - 28 March 2018)
Time:
15:15-16:15
Number of hours: 10 hours (10 x 1 hour sessions)
Employability Points: 50 points maximum (Based on 100% attendance)
Location: Canterbury Campus

ECDL Logo

European Computer Driving Licence (ECDL)

Course outline

The ability to use a computer effectively is an essential life skill. Computer skills enable people of all ages to understand and use technology to improve their personal and professional lives. Certified computer skills can help the holder’s professional life by making them more attractive to employers, while increasing their ability to communicate and access information and services in their personal life.

This course offers computing sessions with trainers available to support online learning and guidance to complete the full ECDL Extra qualification. Depending on initial IT skill level there may be 1-4 hrs per module online learning required outside of the sessions.

Learning outcomes

On successful completion of this course students will be able to:

  • Demonstrate to employers their IT knowledge by gaining an internationally recognised IT qualification covering Word processing, Spreadsheets, Presentations and Improving Productivity
  •  

KE154 - Environmental Management and Auditing

Dates: Every Wednesday during weeks 18-21 inclusive
Time:
13:00-15:00
Number of hours: 8 hours (4 x 2 hour sessions)
Employability Points: 40 points maximum (Based on 100% attendance)
Location: Canterbury Campus

Forest

Environmental Management and Auditing

Course outline

Session 1: Environmental Management Systems (EMS) part 1:

  • Types of EMS
  • Drivers for Environmental Management
  • Setting up and running an EMS

Session 2: Environmental Management Systems (EMS) part 2:

  • Setting up and running an EMS
  • Behaviour Change programmes
  • The ‘Plan, Do, Check, Act’ approach

Session 3: Environmental Management Systems (EMS) part 3:

  • What is auditing?
  • Auditor skills
  • Audit techniques
  • Guided audit

Session 4: Auditing (practical)

  • Conducting 1 or 2 basic environmental audits of University buildings
  • Understanding audit results
  • Making recommendations

Sessions 1 and 2 will be classroom based and will consist of presentations and small-group exercises.
Sessions 3 and 4 will be part classroom based and will also involve students conducting prearranged environmental audits of University buildings.

Learning outcomes

On successful completion of this course students will be able to:

  • Understand the drivers for Environmental Management in organisations
  • Develop a knowledge of Environmental Management Systems and how organisations use them to manage their impacts
  • Understand the potential benefits and challenges of an environmental behaviour change programme and develop the skills necessary to influence positive environmental behaviour in the workplace
  • Learn basic environmental auditing skills
  • Conduct several environmental audits of University buildings

KE155 - An Introduction to Sustainability

Dates: Every Wednesday during weeks 14-17 inclusive
Time:
13:00-15:00
Number of hours: 8 hours (4 x 2 hour sessions)
Employability Points: 20 points maximum (Based on 100% attendance)
Location: Canterbury Campus

Earth from space. Image Credit: NASA/NOAA/GSFC/Suomi NPP/VIIRS/Norman Kuring

An Introduction to Sustainability

Course outline

Week One – What is Sustainability? (2hrs interactive lecture with exercises and group activities)

  • Definitions of sustainability
  • Sustainability explained with natural science
  • What sustainability challenges are we facing globally?
  • Trends for energy use, population growth, lifestyle, food production and need.
  • An introduction to the Millennium Development Goals and Sustainable Development Goals
  • Using a PESTLE analysis to understand a sustainability issue: Food

Week Two – Environmental, Economic and Social Sustainability (Part One) (2hrs interactive lecture with exercises and group activities)

  • Environmental: An introduction to the Climate Change Challenge
  • Environmental: Ecosystem Services and biodiversity decline
  • Economic: Are economic growth and sustainability incompatible?
  • Economic: Who pays for socials and environmental damage?

Week Three – Environmental, Economic and Social Sustainability (Part Two) (2hrs
interactive lecture with exercises and group activities)

  • Social: Human Needs
  • Social: The importance of toilets!
  • Social: Inequality around the world
  • Understanding systems and the connectivity of the problem
  • Case studies from around the world

Week Four – Innovating for a sustainable future (2hrs interactive lecture with exercises and group activities)

  • Doing more with less
  • Sustainability: A catalyst for innovation
  • Examples from Architecture, Zero Waste Design, City Planning…
  • Collaborations across curricula and sectors
  • Behaviour change interventions
  • What are we doing here at Kent?
  • What can you do?

Learning outcomes

On successful completion of this course students will be able to:

  • Give a concise definition of sustainability
  • Have an understanding of the key environmental, social and economic challenges facing the world
  • Describe systems thinking
  • Give examples of innovations/solutions to global challenges
  • Talk about what is currently being done at Kent around sustainability and what they can do as individuals

KE157 - Introduction to Care Proceedings via Simulation Learning

Date: Wednesday 28 February 2018 (week 19)
Time:
13:00-16:00
Number of hours: 3 hours (1 x 3 hour session)
Employability Points: 15 points maximum (Based on 100% attendance)
Location: Canterbury Campus

Rosie's family go to court

Introduction to care proceedings via simulation learning

Course outline

Learning and Teaching Methods:

  • Lecture, simulation, report reading and group discussions are the methods of teaching that will be employed to meet the learning outcomes.
  • A lecture will introduce learning outcomes, key concerns raised by child protection practitioners around court work skills and cover a basic foundation of court knowledge which is necessary to proceed.
  • Participants will be asked to read a short ‘safeguarding letter’ to introduce the background of the family. We will discuss the contents of this letter as a group.
  • myCourtroom: Rosie’s family go to court is a simulation designed to support the acquisition of court room skills and knowledge and this will be introduced. The First Directions Hearing (Private law) scene will be played in full. Group discussion will be held looking at potential difficulties and expectations at key points in this scene.
  • Building on the previous activity, progression to the next scene in myCourtroom will include a direct work session with Rosie whereby she discloses concerns. Group discussions will be held looking at how this material should be handled and how they feel about it. Ultimately, this will lead to the initiation of public law proceedings.
  • The Final Hearing scene from myCourtroom will be played in part and participants will be asked to consider the roles of different professionals in this arena, the process of cross examination and giving evidence.
  • If time allows, a lecture on key cross examination and preparation techniques can be provided; however, this is unlikely.
  • This will all be undertaken in 3 hours.

Learning outcomes

On successful completion of this course students will be able to:

  • Appreciate key concerns raised by child protection practitioners around court work skills
  • Understand the difference between private and public law settings
  • Consider the different roles and expertise in courts
  • Reflect on direct work with children whose families are involved in proceedings
  • Start contemplating skills to provide evidence or be cross examined in public law proceedings

It would be useful for students to view Rosie1 simulation which will give them an introduction to Rosie and her family. Rosie is 4 years old within Rosie1 and in myCourtroom: Rosie’s family go to court she is 12; however, having this historical background can be helpful. Rosie1 can be downloaded for free from: https://www.kent.ac.uk/sspssr/ccp/game/rosie1index.html


 

 

University of Kent - © Study Plus

The University of Kent, Canterbury, Kent, CT2 7NZ, T: +44 (0)1227 823790

Last Updated: 14/02/2018