IT Training (MSc)

Topic outline

• Booking a place on IT workshops
  This topic
  

  Booking a place on IT workshops

  Bookings for IT 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://intra.lshtm.ac.uk/studentbookings

  If prompted to log in, use your LSHTM username and password. You will not be prompted to log in a second time if you are already logged in to Moodle or Webmail. Should you get stuck when trying to book, please email:

  training@lshtm.ac.uk
• 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 - Pivot Tables File
  • Excel - Pivot Tables 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
  • ____________________________

• 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

• EpiData
  
  

  EpiData

  This material provides an introduction to EpiData 3.1.

  • Introduction to EpiData 3.1 File
  • EpiData 3.1 Exercises File
  • EpiDATA Exercise Solutions Book
• EndNote X8
  
  

  EndNote X8

  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.

  • EndNote X8 Full guide File
  • EndNote Training File
  • EndNote Essentials Video Tutorials Book
  • EndNote Video Tutorials - Databases Book
• 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: 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
• 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.
  

  • GraphPad PRISM Video Tutorials Book
  • Analyzing Dose-response Data Folder
  • Interpolating from a standard curve Folder
  • Paired t-test Folder
• NVivo 10
  
  

  NVivo 10

  NVivo is a database package that assists with organising qualitative data. These materials provide an introduction to NVivo10.

  • NVivo 10 Guide File
  • NVivo exercise files
• 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
  • ____________________________

  • 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.

  • PowerPoint Posters Guide File
  • PowerPoint Posters Training Files Folder
  • LSHTM Brand Guidelines File
  • PowerPoint Posters Templates Folder
• 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
  • Read & Write Gold Toolbar URL
  • Read & Write Gold Speech Feature Video URL
  • Read & Write Gold Spelling Feature URL
  • Read & Write Gold PDF Aloud URL
  • Read & Write Gold Screen Masking URL
• 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
• 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.

  • MSc projects in Word - Windows version File
  • MSc Projects in Word Guide - Mac File
  • MSc Projects in Word 2015 - Exercises File
  • Training Files Folder
  • MSc Projects in Word Video Tutorials Book
  • Copying MS Excel Tables and Charts into MS Word 2013 - Video Page
• 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
• Topic 17
  
  

  Topic 17
• Topic 18
  
  

  Topic 18