Digital Skills Training

Support Information

• News forum
• meeting URL

Staff Contact Details

Session Bookings

• Click here to book for Email & Internet 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

ECDL Qualification & Tasks

• ECDL Syllabus Page
• Database Files for ECDL Session one:

• Estate Agent File
• Parking File
• Holiday File
• Database Files for ECDL Session two:

• Sunshine File
• Consultants File
• Database Files for ECDL Session three:

• Staff File
• Central File
• Club File
• Database Files for ECDL Session four:

• Expenses File
• Geography File
• Central File
• Production File
• Database Files for ECDL Session five:

• Expenses File
• Central File
• Database practice papers:

• BCS Sample Test File
• Relationship File
• sample answerfile
• Antiques File
• Practice paper 2 File
• Hire File
• Wages File
• Chemistry 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

• Dissertation Formatting Support during April 2021:

• 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 (a new recording with more guidance for Mac users) and other trouble-shooting recordings (table of contents, tables, captions, interview transcripts, page numbering etc) can be found in the Replay block of this page. Select the option to 'Show All' in the Completed Recordings' section to view all the recordings.

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

  If you still need help, you can make a one-to-one appointment with Mersedes via the One-to-One Appointments section, also on this page.

  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

• 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 and much more. 

  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. These sessions are no longer taking place from April 2021 onwards but you can contact the AIM team if you have any queries.

  Dissertations: Browse a selection of dissertations  including the 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.  You must be logged in to view this resource.

  Printing Information: The campus no longer has a CopyShop, but you can print your dissertations using any one of the MFD printers on campus (Multi Functional Devices). TIP: If you are printing your dissertation on campus; send the print job to the printers, log onto the MFD to see the cost of printing and then top up your library card for that amount.

  Dissertation front covers: The Library has a limited supply of dissertation front covers. They are available upon request and will handed out on a first-come, first serve basis. There is no charge for the front covers. We do not have a binding service on campus.

  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 163.2KB
• Apply Line Numbering to a selection of text (Interview Transcripts) File 202.8KB
• How to capture a screen clipping File 109.6KB
• Create the dissertation 'Front Cover' File 264.6KB
• Wrapping In Line With Text - How to stop images, graphs & tables from moving around when inserted in Word documents File 287.8KB
• 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 submitting to Turnitin! File

AIM