If your department or team have a Facebook page, then it is important not to share the administrator password with anyone. You can add additional editors onto your page by following these steps:
Search results
Excel Quick Selection Techniques
In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more effciently. Esspecially when you have large ammounts of data.
I...
There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Ribbon1.png
This menu...
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
Change font, style, point size and all formatting, in one go to match pre-existing text
Many times in Word you have copied and pasted something into your document only to find it is in a different font, size or is in bold or italics or some completely different format. Format...
This guide will show you how you can create hanging indents that you may need to use in your referencing or simply to format your paragraphs throughout your document.
If however, you are...
A sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it...
If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...
Create a chart
Select the data for which you want to create a chart.
Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not...
Word has a feature to auto-recover and save documents in case of crashes or problems to the file. This area is hidden on the computer under a hidden folder and therefore accessed using a method that's different from accessing a regular file.
When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie...
VLC media player
VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVDs, Audio CDs, VCDs, and various streaming protocols. One of the features that VLC can provide is the option to 'loop' or replay videos once they...
Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup.
...Track changes can be used to lock a document. Any changes made to the document after it has been locked will feature in a list of 'tracked changes' that can be approved or denied. These are similar to comments but will update the original document if approved.
Turning on...
There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns:
Text to Columns'Text to columns' is found in the 'data'...
Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
If you are concerned about the health impact of "Blue Light" (the light that comes from a PC monitor, tablet, mobile phone, TV), then there is a filter built into Windows 10 that you may wish to enable.
Windows 10 has a Night Light setting which gently reduces the monitors blue-tones,...
When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & OtherHigh priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...
Submitted PDF files can be downloaded and annotated in the Microsoft Edge browser:
Used effectively for activities such as research and self-promotion, social media can dramatically enhance your employability. However, if used carelessly, social media can significantly damage your chances in the job market. This guide outlines some of the things you need to consider, and the...
GIMP (GNU Image Manipulation Program) is a free and open-source raster graphics editor used for image retouching and editing, free-form drawing, converting between different image formats, and more specialised tasks.
How to download GIMPHere are a number of useful features, tips and reminders for you during the online marking process
Dyslexia StickersWhen marking assignments, please make sure that you are checking for the dyslexia icon. This appears alongside the student ID when you are viewing the submissions...
You can use Microsoft Teams either from the Teams App or by using the web version. You will get the best user experience by using the Desktop App this is installed on all university computers.
If you are joining a meeting or lecture you will be prompted when you click on the meeting or...
The following formatting options have no visibility unless the ¶ button is selected:
=Unique is a function used in Excel to find only Unique values in a range or array.
e.g. If you have a list of Departments:
We can use the unique function to identify all the unique values in this list and produce a list of them...
Excel Quick Selection Techniques
In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data.
I shall...
Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
Conditional formatting is a feature that has a variety of uses. Mainly surrounding different ways of displaying data corresponding to the value found within the cell or range of data. This can help you visualise the data faster...
A sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it...
Create a chart
Select the data for which you want to create a chart.
When creating charts/graphs in Excel you may find that some labels are not added by default and must be added manually or are in an unsuitable place. Excel also allows for modification of these labels, as well as their placement. In this example i'm going to amend a pie...
Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup.
...There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not...
Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns:
Text to Columns'Text to columns' is found in the 'data'...
The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
The SORT function sorts the contents of a range or array.
In this example we are sorting an array of sales which currently unordered. When =SORT(B3:E51) is used we will see the array now sorted by the first column, in this case A-Z of the Item column:
...The SORT function sorts the contents of a range or array.
In this example we are sorting an array of sales which currently unordered. When =SORT(B3:E51) is used we will see the array now sorted by the first column, in this case A-Z of the Item column:
...The FILTER function allows you to filter a range of data based on criteria you define.
Syntax=FILTER(array,include,[if_empty])
arrayThe array or range to filterincludeThe array from which you'd like to filter results by[if_empty] (optional)The value to return if all...There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Ribbon1.png
This menu...
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
BeginnerExcel...
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
SharePoint sites exist in a number of different ways and therefore accessing them for the purposes of syncing with your local PC are done differently according to their type:
You can add a Poll in any chat window, whether you are in a meeting or if you are just using chat on its own.
If you are in a meeting and you want to set up a poll, open the Chat window and click on the ellipses (...) at the bottom of the chat
...
Once you have clicked into your meeting you have a number of ways to manage your participants.
If one person will be speaking at a time, it is advisable to ask all other participants to mute their microphones. Teams will try to prioritise the loudest noise it detects so if you have...
You can contact individuals via Microsoft Teams to communicate by text, voice, video and share your screen. This does not require you to join a Team and can be useful for direct communication.
In the participants window you can also click on the ellipses at the top of the page (in the same line as the heading People) and from here you can change the meeting options by clicking manage permissions or you can download an attendee list. This can be useful for online lectures in the...
If you hover over a participant and click the Ellipses that appear, you have a number of options, such as:
If your participants wish to say something or ask a question in a Teams meeting, you can advise them at the beginning to unmute themselves if you want them to be able to speak as and when they choose, or if you don't want to be interrupted, you can ask them to submit questions in the chat window...
There are two ways to set up Breakout roomsIn Teams meetings, you can either create them on the moodle page in advance, or use the Microsoft breakout rooms feature, so which should you use?
Setting them up on the Moodle page in advance
You can set up a Team space to:
There are a number of ways you can check and test your audio and video device settings
click on the account icon at the top of...
How many times have you clicked to download a zip file, image, or document to find that your computer has automatically saved the file to a folder called “Downloads”… and how many times have you deleted the files in this folder?
Many of us will have a Downloads folder that is full of files...
If you have a shared document in Teams, Office 365 groups, in SharePoint or in Onedrive, you can edit it at the same time as other people when it is opened online in a browser. This enables you to work collaboratively on the same document, either in real time or at separate times, without the...
On University computers the Staff intranet is the home page for both Chrome and Edge or it can be accessed from the Start menu.
On personal devices you can access it by visiting staffnet.chi.ac.uk, or from the Staff/student links on the main website....
There are two ways that you can download submissions:
You can do this one by one by clicking on the file name
Or to download all at the same time, at the top under Grading action, choose Download all submissions.
You can use the Moodle Assignment for formative as well as summative assignments and for collating documents such as consent forms.
You can follow the same guide for setting up the Assignment tool for summative assignments, but make two changes:
In the Assignment settings, navigate...
To use live captions in a meeting, go to your meeting controls and click the ellipses (...) then choose Turn on live captions.
To stop using live captions, go to the meeting controls and click the ellipses (...) then choose Turn off live captions.
...Objects in Microsoft Office (Word, Excel, Powerpoint etc) can be grouped together to perform as a singular object. This includes; images, textboxes, shapes and SmartArt.
Once grouped, the layout of each object relative to one another will stay the same even if you move or...
While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...
The Animation pane allows you to change the order objects animate in, without needing to remove and reapply animations.
The Animation pane can be found in the Animations tab of the ribbon:
When selected the animation pane open in the sidebar and will...
There are two ways to add audio to a presentation:
1. Adding Audio already on your PC (saved)
2. Record Audio (record live)
To add a clip from your computerHave the audio file saved to the computer locally as an MP3 file - (if you have...
PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.
In the 'Insert' tab of...
In order to reduce the file size of any Microsoft document (Word, Powerpoint or Excel) there are a few steps we can take without removing content.
Images usually make up the vast majority of a document's file size as text uses very little file space by comparison. Although removing...
In PowerPoint 2019 and onwards you can record a Presentation. This will save your narration of the slides (audio or video) and the timings of your slide changes and animation triggers. Once the presentation recording has been complete. The video/audio will be...
PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole...
'Slide Masters' are the templates or layouts, which are shown in in your 'new slide' button:
These can be modified, duplicated or created from new, so that you can include your own template slides to work from. Slide Master can also contain logos or images,...
Microsoft Teams is a tool designed for team communication and collaboration, combining chat, audio/video calling, file storage, and apps. You can use Microsoft Teams either from the Teams App or by using the Teams web version.
You will get the best user experience by using the Teams...
The HEAR is a University-verified online document that records a student's broader achievements, as well as their programme and module details and results. The HEAR is added to during a student's time at the University and a final HEAR is released to applicable students when they complete their...
It is important that the University has an accurate record of attendance. The expectation is that students attend all timetabled sessions for each module.
Each department has a student attendance management coordinator if you have any questions
The Student Attendance and Absence...
Information about the General Data Protection Regulation (GDPR) is available on the Data Protection area of the staff intranet (login required).
Microsoft has a great collection of help pages for how to get the most out of Microsoft Stream.
Getting startedIn most instances, creating chapters is a faster and easier way to help your viewers quickly reach the important parts of your recordings. Rather than editing out sections (where perhaps you all went off on a coffee break), it could be quicker to add a chapter for when...
Starting this academic year, some lead lectures will be delivered online using Microsoft Teams. These guides will help you set up these online lead lectures in advance, and show you the various things you can do once in the lecture.
Advice for the lecturerIf a student has submitted a MS Word document, then you can use Word to view and annotate the submission
Word has a number of useful features:
MAF allows for you to add additional documents to support student feedback. You can attach Word and PDF documents, MP3 audio files and even link to a shared OneDrive file for sharing video feedback.
If you wish to allocate certain submissions to specific markers, to do this:
Whilst students like a consistent experience, we understand that staff have their own ways of marking, grading and giving feedback; we believe that our workflow allows for both.
ema.jpg Click...The University has said farewell to Panopto (aka ChiPlayer) and has moved over to Microsoft Stream as its new video platform.
The way you record videos has changed but the new workflow includes tools such as Teams and OneDrive, with which you...
1. Check the assessment criteria
Your module's Moodle page will have all the details you'll need regarding any assessments.
This should include:
There are a few different ways of making video recordings but for the moment we recommend using Microsoft Teams as this should be the most familiar to you.
Jump to:
Microsoft Teams is designed, by default, to focus on one main speaker. To do this, it uses active noise suppression to remove background noise, such as music, dogs barking or colleagues talking in...
Whether you are a student or member of University staff, many of our systems, software and services are available to access from offsite.
Useful links:When working off-campus for the first time, here are some useful links to University systems: University Links
Support for using our...If you want to keep using your current Panopto recordings, you will need to move them onto Stream before 17th July 2023.
Follow these three steps to complete the process:
When you are in your Teams meeting, select the More icon at the top of the page, and select Record and transcribe > Start recording. All members of the meeting will see a message informating them that the meeting...
If you are a staff member you will be able to change your voicemail preferences within the Teams app. You will be able to change if your number simultaneously 'also rings' another group or individual or what happens when a call is unanswered and the length of time before the voicemail...
This page contains the SEAtS Student Attendance Management system user guides.
SEAtS _Date Filtering.pdf SEAtS _Date Filtering.pdf SEAtS _Exporting Data.pdf SEAtS _Exporting Data.pdf SEAtS Student...Word has a feature that allows users to automatically generate an automatic table of contents, assuming that heading styles have been used. This table of contents supports different levels of indentation to highlight chapters and sub-chapters of the document itself. ...
Styles can be quickly used to apply a formatting choice over a large area of a document. All text is initially created under the Normal style and will remain in this style unless Word is told otherwise. You can modify any existing style or create your own if there is not a pre-existing...
Page & Section breaks have multiple uses. They are most notably used to create different sections within the same document, so that you can apply a different page orientation, affect page numbers and different headers/footers per section.
You can find the...
Page numbering happens in the headers or footer of the document, making use of section breaks to indicate where page numbering will and will not be present. This guide will focus on adding page numbers from the beginning but will cover their usage afterwards.
Adding Page numbersOn the...
Footnotes and endnotes are useful tools for adding citations, comments, or explanations to your text.
This guide will walk you through the steps to insert and manage footnotes and endnotes in Microsoft Word.
Footnotes and...
Captions are useful for providing context to images, charts, and other illustrations in your document. A table of figures helps readers navigate these elements quickly by creating a table with all 'captions' in it as well as their page number. ...
This guide will show you the several types of views available within Microsoft Word that will be able to help you view your document the way you'd like to.
Word has several different ways you can view documents:
These can all...
This guide will show you how to insert images from different sources, adjust text wrapping, and explore basic formatting options.
Inserting Images From Microsoft's Stock Library:Go to the 'Insert' tab on the Ribbon.
Click on 'Pictures' and select 'Stock...
The Dictation feature allows you to speak into your microphone, and Word will convert your speech into text. Here’s how to use it:
Check Your Microphone: Ensure you have a working microphone connected to your computer.
Open Microsoft Word: Launch Microsoft Word and open the...
At the University of Chichester, we're committed to providing as best an experience for gaming as we can, whilst remaining within the confines of a secure environment for all staff and students.
Here are some commonly asked questions and their answers:
Tables are a powerful tool in Microsoft Word that allow you to organise and present data effectively. This guide will walk you through the basics of creating, formatting, and modifying tables in Word.
Whilst this site displays tables differently to Microsoft word, here is an example...
OneDrive is used to store files, folders, and photos in the 'cloud' (Online) so you can access them easily on multiple devices and share them with colleagues, or with people outside the university.
How can I access my OneDrive Quickly?OneDrive can be accessed in your web...
The files on your OneDrive are private until you share them.
Launch PowerPoint and open a new or existing presentation.
Layouts, Design Theme and Slide Size
Text
How to create a text box
SmartArt
Adding/editing shapes
Grouping
Adding Images
Remove background (Images)
Embedding Videos
Adding Audio
Animations/...
Social media tools such as Instagram, X, TikTok and Facebook are a part of everyday life. Used well, they can add to your learning experience at university, and make you more employable when you graduate. But used poorly, they can cause lasting damage to you and others.
Your responsibility...
Use SmartArt to quickly and easily make a visual representations of your information. You can choose from among many different layouts including: Lists...
Adding images to a slide is one the features of PowerPoint you will use most often. You can insert Images from multiple locations: On your computer, from the web or off of your clipboard:
Inserting an Image from your computerInside the 'Insert' tab of the menu ribbon, you...
This page will show you how to embed an online video like YouTube in your PowerPoint Presentation.
1. Find the Youtube video you wish to embed in your Internet browser (on Youtube.com Website):
2. Select the URL (address)...
Images and text boxes can be shaped into more than just a square that we start with, as PowerPoint allows for custom shapes. This guide will show the steps required first generate a shape and then to edit it.
Inserting a shape (to customise)Powerpoint...
PowerPoint has a feature which allows you to remove the background from an image. There are limitations such as needing a high-resolution, decent quality image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a 'cut-...
This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple...
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
BeginnerQuick...
Please review each section carefully:
*/ 1. Import your content from a previous years' Moodle pageMoodle allows you to move content from one page to another. You will need to have...
The university offers support, advice, and training on a number of topics including
MAF (Module Accessment Feedback) Online is the University's platform for grading, marking and giving feedback for student summative assessments.
You can use MAF Online for:
As well as written feedback, you're able to attach files (such as annotated Word documents) and link to online documents (such as files and videos saved in OneDrive and SharePoint).
1. Firstly, click on the Feedback icon next to the Mark and Grade boxes
...Enter Marks and Feedback Enter marks and feedback.png