Course: Digital Skills Training

Don't forget to visit our FAQs page to find guides and information regarding our IT network and procedures

Support Information
Where are you located? We have a dedicated training room with 13 computers accessible via the 24 hour room.

When can I attend? You can attend a drop-in session (see Drop In Bookings section) by using our online booking system, or make an appointment by emailing us: digitalinnovation@marjon.ac.uk

Some examples of what we do are:
- Help with using tables appropriately in Word to create a better layout for your document
- Inserting a table of contents in Word and changing page numbering
- Using formulas in Excel and producing graphs
- Creating online surveys using Survey Monkey
- Jazzing up PowerPoint presentations
- Using Prezi
- Help with using Outlook email and redirecting University emails to a personal email address
- Formatting your dissertation
- and the list goes on...
We also provide free IT Training to Marjon students and staff to receive nationally/internationally recognised IT qualifications. Come to the Unit for a taster session and see which course and level would be most suitable for you.
- News forum
Staff Contact Details
Mersedes Farjad - Digital Skills Manager, mfarjad@marjon.ac.uk, ext 2059, direct line 01752 636859

Kathryn Parker - Clerical Assistant, kparker@marjon.ac.uk, ext 2059, direct line 01752 636859, available Mon to Wed from 9:00 to 14:45, Thu from 9:00 to 12:00

Tracey Eaton - Digital Innovation Technologist, teaton@marjon.ac.uk, ext 5673

Matt Ewens - Digital Innovation Technologist , mewens@marjon.ac.uk, ext 5673
Session Bookings
Use the links below to book onto sessions for ECDL and ECDL Advanced.

You must be logged in to book onto a session!
- Click here to book for ECDL Word Processing Sessions Booking
- Click here to book for Advanced Spreadsheet Sessions Booking
One-to-One Appointments
Click below to book a one-to-one appointment with Mersedes.

If you are unable to attend, please remember to remove your booking or contact us direct on digitalinnovation@marjon.ac.uk
ECDL Qualification & Tasks
- ECDL Information Sheet - Students File
- ECDL Information Sheet - Staff File
- ECDL Syllabus Page
- TASK SHEETS - what are they?
  
  You can see a list of task sheets below that are associated with the ECDL module. If you can carry out the task on all the sheets then you are ready for the exam! If you're not too sure about one or two items then come and see us in a drop-in session.
  
  If most of the tasks are unfamiliar then attend one of our taught sessions (advertised on the Hub).
- WORD PROCESSING - TASK SHEETS AND FILES
- Word Processing Task one Page
- Word Processing Task two Page
- Word Processing Task three Page
- Word Processing Task four Page
- Word Processing Task five Page
- SPREADSHEET - TASK SHEETS AND FILES
- Spreadsheet Task one Page
- Spreadsheet Task two Page
- Spreadsheet Task three Page
- Spreadsheet Task four Page
- Spreadsheet Task five Page
- POWERPOINT - TASK SHEET AND FILES
- PowerPoint Task one Page
- PowerPoint Task two Page
- PowerPoint Task three Page
- PowerPoint Task four Page
- PowerPoint Task five Page
- PowerPoint Task six Page
- IT SECURITY FOR USERS - TASK SHEETS
- Task 1 - Threat Awareness File
- Task 2 - Protecting your Computer File
- Task 3 - Information Security File
- Task 4 - Guidelines and Procedures File
Word Processing Resources
- What do we mean by tabs, groups and commands? File
- Shortcuts and commands in Word File
- Indenting paragraphs and applying a hanging indent for APA referencing style. Please note that occasionally this clip does not begin exactly at 00:00 seconds - if this occurs please bring time back to begin from 00:00
Spreadsheet Resources
- How to create Column charts, Pie charts, Line graphs, Scatter charts, calculating
  Standard Deviations and Averages (videos)
- Worksheeet 1 - Managing Worksheets File
  This worksheet covers:
  
  Adjust Columns and Rows
  
  Deleting a Column/Row
  
  Inserting Rows/Columns
  
  Hide/Unhide Columns & Rows
  
  Freeze/Unfreeze Rows
  
  Name a Worksheet
  
  Copy or Move Worksheets
- Worksheet 2 - Formatting Cells File
  This worksheet covers:
  
  Align data
  
  Format Numbers
  
  Add Cell Borders:
  
  Embolden Data:
  
  Change Font Style, Size & Colour
  
  Apply Shading to Cells
  
  Text Wrapping in Cells
  
  Text Orientation
  
  Copy Formatting
- Worksheet 3 - Graphs and Charts File
  This worksheet covers:
  
  Column Charts
  
  Pie Charts
  
  Line Graph
  
  Scatter Charts
  
  Calculate Averages (Mean)
  
  Calculate Standard Deviation
  
  Display Standard Deviation on Chart
  
  Insert a Chart into a Word Document & Create Caption
  
  Normal distribution
  
  Correlation
  
  Format a trend Line to get r² and Equation for line
- Worksheet 4 - Creating Formulae File
  This worksheet covers:
  
  Using operators in formulas
  
  Creating formulas
  
  Copying formulas
  
  Operators
  
  Formula error messages
  
  Order of operations in a formula
  
  Absolute and relative cell referencing
- Worksheet 5 - Creating Functions File
  This worksheet contains:
  
  What is a function?
  
  SUM
  
  AVERAGE
  
  MAX
  
  MIN
  
  COUNT
  
  COUNTA
  
  COUNTBLANK
  
  IF
- Files required for the Worksheets Folder
  Files for worksheets 1 to 5 can be found in this folder
- How to do a t-test in Excel 2010 File
PowerPoint Resources
- For complete beginners:
- A Guide for Beginners File 1.1MB
- Preparing Slides File
  You will need to save this file to use with the guide.
- Presentation guidelines File
  You will need to save this file to use with the guide.
- presentation File
  You will need to save this file to use with the guide.
- Try these resources if you've used PowerPoint before:
- Creating PowerPoint Presentations File
  The text for this presentation can be found on the bottom of each slides in the notes section.
- Working with graphics on a presentation - have a go! File
  Open the presentation and follow the instructions provided in the notes section
- List of considerations for presenting File
  This list has been collaborated by students; suggesting what should be considered when preparing for a presentation.
- Embedding a YouTube clip onto a slide File
- Creating Posters in PowerPoint:
- Poster Presentations File
  Best viewed as a slide show - click on the the hyperlinks to move through the slide show
- Setting up your A1 paper size poster
- Enter a title for your poster
- Insert text and format text box with borders and shading
- Change background colour or insert an image in the background
- Grouping text boxes and objects
- How to apply colours using the Adobe Colour Wheel File
Dissertation Resources
- Click here to book for a Dissertation Formatting Session (direct link to AIM booking page) URL
- Formatting Guide and documents required:
- Dissertation Formatting Guide Office 2016 File
- Dissertation Formatting Guide Office 2010 File
  This is the guide used for the Dissertation Formatting taught sessions delivered by ITTS. You will need to save the following three files below in order to work through this handout: The Solar System.docx, and the 2 images: Transit of Mercury.jpeg, and Phobos.jpg.
  
  To save the Solar System, click on the link and select Save As... to save the Word document onto your computer/laptop
  
  To save the images, click on each image and then right-click onto each image and select Save picture as...
- The Solar System.docx File
- Transit of Mercury.jpeg File
- Phobos.jpg File
- Frequently Asked Questions regarding dissertation formatting:
- Frequently Asked Questions regarding formatting Page
  Click here to find out what questions I get asked about the most - you may find the answer to your query here!
- Links to other pages:
- Student Information Handbook: You can find a wealth of resources and information in the Student Information Handbook in the Study Skills section. For more information regarding the layout and formatting requirements of the dissertation visit Writing your Dissertation in the Study Skills section of the Student Information Handbook.
  
  Printing Information: Closer to the generic hand-in date (April 2019) we will provide information and links regarding printing/binding costs and the Copy Shop opening hours. If your dissertation is due before April 2019, please contact the Copy Shop direct regarding opening hours and printing/binding costs. If you are emailing your dissertation to the Copy Shop for printing and binding, you must save the dissertation as a PDF file. If you are printing the dissertation yourself, remember to print out dissertation single-sided on A4 paper. More information about printing costs.
  
  Plagiarism Checking Service: In order to help you prepare your dissertation for final submission, the eLearning team have created a Turnitin Plagiarism/Similarity Checking Service for the dissertation modules to check your work for unintentional plagiarism. You can find this service on your dissertation module on Learning Space from January 2019 onwards. Please note that this service is available on final dissertation modules only and has been set up for students to submit chunks of work rather than having to submit their 10,000 word dissertation before seeing the similarity report. If your dissertation is due before April 2019, please contact me and I will request for the service to be added.
  
  Study Skills: Check the Study Skills section on Learning Space for study skills drop-in sessions, and for support and guidance on a range of study skills topics such as APA Referencing, Dissertation Writing, Time Management, Critical Thinking and much more!
- Additional dissertation related guides can be found below:
- Working with Tables in Microsoft Word File 171.7KB
- Apply Line Numbering to a selection of text (Interview Transcripts) File 226.7KB
- How to capture a screen clipping File 297.4KB
- Create the dissertation 'Front Cover' File 285.5KB
- Wrapping In Line With Text - How to stop images, graphs & tables from moving around when inserted in Word documents File 478.9KB
- Printing specific pages of a document that contains section breaks File
- Printing options - single sided and in colour File
- Insert Captions for Graphs and Tables File
- How to scan hard-copy printouts as images File
- Dissertation Formatting Checklist - read this before printing! File
AIM
Click here for information and session bookings for AIM.

However if you already know about the sessions, click on the link to go direct into the booking options.