Course: IT Training (MSc)

Topic outline

Booking a place on Digital Workshops
This topic
Booking a place on Digital Workshops
Bookings for Digital workshops are now handled by a dedicated booking system. This system will let you book a place on a course, see details of courses you are booked on, receive reminders shortly before workshops commence, view your attendances, complete course evaluations, and cancel bookings.
To see a list of courses planned for the next few months and book a place, click the following link:

https://studentbookings.lshtm.ac.uk

If prompted to log in, use your LSHTM username and password. Should you get stuck when trying to book, please email:

training@lshtm.ac.uk
- Student Digital Workshop flyer download File
  This leaflet outlines the face-to-face digital workshops, delivered through LSHTM's Technology-Enhanced Learning team. Feel free to download a copy so you can keep up-to-date with which sessions are available to you.
- Digital training resources
  The following are standalone resources that may be used for self-directed training on digital tools that could be useful during your time studying at the School.
  Please note that, whilst periodic updates on such materials takes place, some resources may not represent the current set-up of certain tools.
  If you have any issues accessing the provided resources please contact us at: training@lshtm.ac.uk
Mendeley
Mendeley
Mendeley is a free reference manager and academic social network. You can use it to manage research, showcase your work, connect and collaborate with others or simply to generate extensive bibliographies.
- Mendeley training videos Book
  Training videos on how to use Mendeley can be found within this book.
- Mendeley User Guide File
  This guide can be used in conjunction with the provided training videos.
- Mendeley training files
EndNote X9
EndNote X9
EndNote is an application that stores and manages bibliographic information, an excellent tool for managing references for assignments, research projects. References can be imported directly into EndNote from many online databases, saving you the time of typing them manually. Once inputted into EndNote your references can be sorted and grouped. EndNote also has the capacity for you to store and annotate full text journal articles. References can be exported to a Word document in a variety of bibliographic styles. - See more at: https://intra.lshtm.ac.uk/its/ittraining/students/index.html#sthash.4wFlUc6c.dpuf

EndNote is an application that stores and manages bibliographic information, an excellent tool for managing references for assignments, research projects. References can be imported directly into EndNote from many online databases, saving you the time of typing them manually. Once inputted into EndNote your references can be sorted and grouped. EndNote also has the capacity for you to store and annotate full text journal articles. References can be exported to a Word document in a variety of bibliographic styles.
MS Access: Introduction
MS Access: Introduction
These materials give an overview of the key features and important design considerations for building a Microsoft Access database.

The materials cover:
- The Access database interface
- Designing a database
- Creating tables to store records, setting up field properties and validation rules
- Entering data, searching, and linking tables using relationships
- Creating a selection of queries to extract information
- Creating user-friendly forms and generating reports
- MS Access Guide File
- Access Training Files Folder
- ____________________________
- Access Queries Video Workshop - link to video URL
  This is a video workshop that covers the basics of creating queries in an Access Database.
  
  You should watch the video first (approx 36 mins.), then download the exercise instructions and the exercise file (links below) to put into practice what has been learned.
- Access Queries Video Workshop Exercise Instructions File
- Access Queries Video Workshop Exercise File
  Patient Treatments DB 8.accdb
Excel: Introduction
Excel: Introduction
These materials are for relative beginners with Excel, covering layout, data entry and formatting, creation of a range of formulae and functions including use of relative and absolute cells, sorting, filtering and transposing data ranges.
- Excel Introduction Guide File
- Excel FFF training files.zip
- Demonstration File
- ____________________________
- Video Workshop Book
  This is an online version of the Excel Formulae, Functions and Formatting face-to-face workshop.
  
  This book contains three pages which show: 1) How to use the materials, 2) The skills covered, 3) Links to the videos.
- Video Exercise Files Folder
- Exercise Instructions File
- Excel Functions Worksheets 2019-20 File
Excel: Data Management
Excel: Data Management
Excel contains a number of features which assist you in managing data. These materials cover a range of these, including sorting and filtering, advanced filters, conditional formatting, table formatting, various functions, data validation, using subtotals, pivot tables and exporting to other programmes. These materials are intended for those with knowledge of basic Excel formulae, functions and formatting.
- Excel Data Management Guide File
- Excel Data Management Training Files Folder
- ____________________________
- Excel: Data Management Video Workshop Book
  This is an online version of the Excel Data Management face-to-face workshop.
  
  This book contains three pages which show: 1) How to use the materials, 2) The skills covered, 3) Links to the videos.
- Excel Data Management Video Exercises File
- Data Management Video Exercise Instructions File
Excel: Charts & Graphs
Excel: Charts & Graphs
These materials cover a range of different graphs and charts in Excel. The exercises will help you to format and customize your charts and graphs, print and copy them into other programs e.g. Word.
- Excel Charts and Graphs Guide File
- Excel Charts and Graphs Training Files Folder
- Copying MS Excel Tables and Charts into MS Word - Video Page
- ____________________________
- Excel: Charts & Graphs Video Workshop Book
  This is an online version of the Excel Charts and Graphs face-to-face workshop.
  
  This book contains three pages which show: 1) How to use the materials, 2) The skills covered, 3) Links to the videos.
- Excel Charts Video Exercise Instructions File
- Excel Charts Video Exercises File
EpiData
EpiData
This material provides an introduction to EpiData 3.1.
PowerPoint: Academic Presentations
PowerPoint: Academic Presentations
These materials are for those with relatively little experience of creating PowerPoint presentations. They cover the basic operations of slide creation and adding content as well as some principles of good practice. They also cover some techniques you can use to increase the impact of your PowerPoint presentation, such as animation and transition effects.
- Powerpoint Guide File
- Download PowerPoint training files
- LSHTM Guidance on Copyright URL
- LSHTM brand guidelines 2017 File
- LSHTM Presentation Template File
- ____________________________
- PowerPoint: Academic Presentations Video Workshop Book
  This is an online version of the PowerPoint Academic Presentations face-to-face workshop.
  
  This book contains three pages which show: 1) How to use the materials, 2) The skills covered, 3) Links to the videos.
- Optional Exercise Files Folder
- PowerPoint Academic Presentations Video Exercises Instructions File
- EXTRAS
- PowerPoint Academic Presentations MANUAL File
  This PDF manual can optionally be used as a printed reference of the skills described in the Skills Demo Videos. In addition, reading from page 20 onwards describes some extra PP skills which you may find useful.
PowerPoint: Research Posters
PowerPoint: Research Posters
These materials cover some of the principles of good practice in research poster design. We provide tips and advice on practical considerations such as layout, size, font styles, images, accessibility and use of colour.
Word: Working with Academic Documents
Word: Working with Academic Documents

These materials cover useful features for formatting reports and academic documents. They include page and paragraph formatting, section breaks, using Word styles, generating automatic tables of contents, figure and table lists, headers & footers, numbering and footnotes & endnotes.

The materials also include some of the features associated with collaborative editing such as the track changes facility, showing and hiding revision marks and adding comments.
- Word Guide File
- Word Training Files Folder
- ____________________________
- Word: Working with Academic Documents Video Workshop Book
  This is an online version of the Word Working with Academic Documents face-to-face workshop.
  
  This book contains three pages which show: 1) How to use the materials, 2) The skills covered, 3) Links to the videos.
- Word Academic Documents Online Video Workshop Exercise Files Folder
- Word Academic Documents Online Video Workshop Exercise Instuctions File
- Writing Equations in Word screencast (with subtitles) URL
- Transcript for Writing Equations in Word screencast File
Word formatting for MSc projects
Word formatting for MSc projects

The School has exacting requirements about the formatting of MSc summer projects. In this workshop we will explain these guidelines and show you how to format your project accordingly. Skills include basic Word formatting including; margin setting, the presentation of tables and figures, tables of contents, lists of tables/figures, fonts, spacing, formatting images, and intellectual property considerations. Participants will produce their own document which can be used as a template for summer projects.
NVivo 10
NVivo 10
NVivo is a database package that assists with organising qualitative data. These materials provide an introduction to NVivo10.
- NVivo 2018 Essential Training URL
  The above link will take you to the LinkedIn Learning signing page. This is a library of professionally created tutorials all MSc students have access to.
  You should choose the option of continuing without LinkedIn and if you are logged in to the School network you should be signed straight into the platform. Once logged in and you should search for 'NVivo' and you will find courses on the following:
  NVivo terminology
  The NVivo interface
  Creating a new NVivo project
  Importing data
  Organizing data
  Analyzing data
  Exporting your coding structure
  If you have any problems logging in to LinkedIn Learning, advice can be found by searching for this within the Student Portal.
STATA 13
STATA 13

STATA 13 is a powerful statistical software package with integrated data management, data analysis, and graphics features. These materials are for those who have little or no experience using STATA but who have a basic understanding of statistics and their use in public health research. The materials cover introductory concepts relating to: command syntax, data management, analysis, and graphing.
- STATA 13 Guide File
- STATA 13 Training Files Folder
GraphPad PRISM
GraphPad PRISM
These materials have been posted with the permission of GraphPad PRISM. The materials include videos, guidance for carrying out specific functions in GraphPad PRISM, and practice files.
Read & Write Gold 10
Read & Write Gold 10
Read & Write 10 Gold is a software package which includes many features to support people with disabilities including: dyslexia/dyscalculia, dyspraxia, problems with visual acuity, and other learning difficulties. It assists with reading and writing, developing study skills, and facilitating research.
- Read & Write Gold 10 Guide File
Bite Size sessions - Exercises
Bite Size sessions - Exercises
The exercises to go with the Bite Size workshops here.
The written material can be found in the full size sessions of the workshops.
- EndNote BiteSize File
- ____________________________
- Excel - Getting started File
- Excel - Getting Started File
- ____________________________
- Excel - Useful functions File
- ____________________________
- Excel - Charts File
- Excel - Charts File
- ____________________________
- Excel - Data Manipulation File
- Excel - Data Manipulation/Display File
- ____________________________
- Excel - Data Management - Ebola data set File
- Ebola data set exercises File
- ____________________________
- ____________________________
- Mobile working File
- ____________________________
- Word - Collaborative Working File
- Word - Collaborative Working Folder
- ____________________________
- Word - Essential Formatting File
- Word - Essential Formatting Folder
- ____________________________
- Word - Presenting Academic Documents File
- Word - Presenting Academic Documents Folder
- ____________________________