IT Skills
This page provides, documents introducing Queen's computing facilities, documents and online resources to help you improve your IT skills (basic and advanced) and a link to information about how to acquire the European Computer Driving Licence (ECDL), which is an internationally recognised computer qualification. Windows 7 and Office 2010 training materials will be available shortly. For Office 2007 and other training materials (see table below). See also Computing Tips. Visit the Microsoft site to see Microsoft's Office 2010 materials http://office.microsoft.com/en-us/support/training-FX101782702.aspx.
Working with Long Documents: Associated files (Zipped)
Excel 3: Data Analysis and Basic Statistics using Excel Excel 3 data files (zip)
| New Student's Guide to Library and IT Facilities | The Guide can be accessed via the Queen's Online Home page - in the folder entilted: "IT and Library Guides" |
|
Core IT Skills [Microsoft Office 2010] |
Word Processing Essentials (PDF) | Managing your files using Windows 7 PowerPoint Essentials (PDF) | Excel Essentials (PDF) Data Files for Use IT @ Queen's: Facilities for Clubs and Societies.doc | Student Computer Centres.doc  This image has the file name SCCS.gif(To download this file point at the image then press the RIGHT MOUSE BUTTON and select Save Picture As from the Menu. Then Save the file with the file name sccs.gif) |
| Word 2007 |
Word 1: Essentials .pdf (34 page PDF document) Data File:
Zip files for Word Essentials course.zip |
| Excel 2007 | Excel 1: Essentials: workbook:
Excel 1: Essentials (36 page PDF) | Data file for Excel 1 course:
Returns08.xlsx
Excel 2: Managing Data: Excel2PG.pdf | Data Files: Class list.txt | Patients Data.xlsx Excel 3: Excel3PG.pdf (28 page PDF) | FunctionsPG.xlsx | DataTables2.xls Creating Charts using Excel: Creating Charts (22 page PDF) | Zip Files for Excel Charts course Introduction to PivotTables using Excel: Excel: PivotTables (23 page pdf) | PPT: PowerPoint for PivotTables and Pivot course | Source Data Basic Statistics using Excel: Excel: Basic Statistics (21 page PDF) | Statistics data (Excel 2007).xls | DataFile.xlsx |
| PowerPoint 2007 | Presentation:
Using PowerPoint for Academic Presentations.pptx
PowerPoint First Steps (26 page PDF)
|
Zip Files for PowerPoint First Steps Poster Presentations using PPT: PowerPoint: Poster Presentations (17 page PDF) | Data Files: PosterText.doc | alcohol.jpg | alcopops.jpg Advanced PowerPoint (34 page PDF) | Files for Advanced PPT: Zip files for Advanced PPT - PG.zip |
| Office 2007 (various) |
Questionnaire and Form Design: Questionnaire and Form design (26 page PDF workbook) |
| Email - Queen's Webmail | Outlook Web Access Introductory Guide (28 page PDF file) |
| Email - MS Outlook 2003 | Workbook: Making best use of MS Outlook.pdf (PDF doc - 48 pages) [This does not cover MS Exchange email accounts] |
| Internet |
Resources for the course: Refine and Consider the Quality of your Web Searches: 1) Web Searching - Course Outline 2) Searching: The University of California at Berkeley Library have a Five-Step Search Strategy - Step #1 has a a printable form (PDF file) as a guide in analyzing your topic 2) Quality: Notes: Web Sites - Evaluation of Quality: issues and solutions (PDF) and The University of California at Berkeley Library have Webpage evaluation checklist, see link at http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/Handouts.html#EvalForms The Internet Detective (online tutorial to distinguish between the good, the bad and the ugly when web searching).The Intute Virtual Training Suite provides free Internet tutorials to help you learn how to get the best from the Web for your education and research: http://www.vts.intute.ac.uk/ |
| ECDL | How to acquire the European Computer Licence at Queen's. When you enrol for ECDL you are provided with training materials. |
| Matlab | Matlab - on the Mathworks website, sign up for training materials - http://www.mathworks.co.uk/help/index.html?s_cid=global_nav |
| ArcInfo | Arcinfo For training on spatial and mapping analysis see ESRI site http://www.esri.com/ ESRI UK site is http://www.esriuk.com/ |
| Programming | C from StrathClyde University http://www.strath.ac.uk/IT/Docs/Ccourse/ccourse.html Java getting started http://java.sun.com/docs/books/tutorial/getStarted/index.html QUB Fortran 90 Course slides http://www.pcc.qub.ac.uk/tec/courses/f90/ohp/f90-ohp.html and Unix http://unixhelp.ed.ac.uk/, University of Edinburgh See also Online E-books available via the Library Web site: http://library.qub.ac.uk/qu_pages/azbook.html#S |
Contact Information
For further information, please contact the Training Unit (itcourses@qub.ac.uk), or (9097) 6189
