Digital Skills Training

Support Information

• News forum
• meeting URL

Staff Contact Details

Session Bookings

• Click here to book for ECDL Spreadsheet Sessions Booking

One-to-One Appointments

• Click here to book your One-to-One Appointment URL

Courses on Offer

• In addition to the individual bespoke support offered to students and staff during drop-in sessions, we provide you the opportunity to receive a nationally (and internationally) recognised IT qualification.  You will need to take exams in order to receive the certificate and you will need to pay for exam fees. However the cost is minimal in comparison to what the public have to pay for their IT course. We offer qualifications at 2 levels:

  • ECDL (European Computer Driving Licence) - Level 2
  • ECDL Advanced - Level 3

  Any training session taking place will be advertised on the 'Session Booking' section and will also be advertised on the Hub (student newsletter).

  You don't have to take an exam if you don't wish to; you can just turn up for a specific session to learn new skills (for example learning how to work with tables).

  For more information email digitalinnovation@marjon.ac.uk 

• ECDL Information for Students File
• ECDL Information for Staff 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 File

PowerPoint Resources

• For complete beginners:

• A Guide for Beginners File 787.7KB
• Working with images File

  You will need to save this file to use with the guide.

• Text effects File
• Try these resources if you've used PowerPoint before:

• Creating PowerPoint Presentations - get it right... File

  The text for this presentation can be found on the bottom of each slides in the notes section.

• Creating dynamic presentations - 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

• How to apply colours using the Adobe Colour Wheel File
• 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

Dissertation Resources

• Are you having trouble formatting your dissertation?  No need to panic! Mersedes is here to support you. 

  The resources below are here to guide you.

  A recording of the Dissertation Formatting session is available in the Replay block on the Digital Skills Training page on LearningSpace, just click here (please ensure you are logged on to LearningSpace before you access the page). Select the option to Show All to find the recording.

  Once you have completed your template, email it to Mersedes Farjad: mfarjad@marjon.ac.uk and she will check that it's correct and email you with feedback.

  Any queries can be answered via email and you can also arrange a one-to-one appointment with Mersedes using Microsoft Teams, just email to arrange a time to meet.

  Email mfarjad@marjon.ac.uk if you would like to see a resource in this section.

• Formatting Guide and documents required:

• Dissertation Formatting Guide Office 2016 File

  This is the guide used for the Dissertation Formatting taught sessions delivered by Digital Innovation as part of the AIM initiative. 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:

• Session Recordings: Don't forget to check out the Replay block on this page to see the Completed Recordings. There are recordings for the Dissertation Formatting Session, line numbering interview transcripts, tips on working with images and tips on working with tables. 

  Study Skills: You can find a wealth of resources and information in the Student Information Handbook in the Study Skills section.  For more information regarding the content of the dissertation visit Writing your Dissertation in the Study Skills section of the Student Information Handbook. 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!

  Plagiarism Checking Service: In order to help you prepare your dissertation for final submission, the Digital Innovation 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 LearningSpace from January 2021 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 dissertation before seeing the similarity report.

  Aims sessions: Specialist staff in academic, library-based, and digital skills have worked together to put on a program of sessions designed to help you Acquire, Improve and Master a range of generic skills that fall outside the normal curriculum but could save you time and effort as well as help you achieve better results. You can find more information and booking options on our AIM page on LearningSpace.

  Dissertation Abstracts: Browse a selection of dissertation abstracts on the Library page on LearningSpace, as completed by Marjon students within the past five years. These dissertations have been chosen by the Academic Senate.  The dissertation can be viewed in full from the dissertation PCs, located on the ground floor of the Library. You must be logged in to view this resource.

  Printing Information: The campus is currently closed so you won't be able to print your dissertation using our CopyShop. You will be submitting a copy of the dissertation on Turnitin. More information about accessing dissertation front covers and printing will be posted soon.  

  Student Regulations Framework: The Student Regulations Framework details the regulations for 'Substantial Assessment Tasks' (Dissertations, Honours Projects, Independent Study Modules and other modules of 30 credits or more) in Section 13.  Direct access Section 13.

• 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