Language:
SEARCH
  • Recent Posts

  • Categories

  • Archives

Training

3 day online Excel course

Monday, May 3rd, 2021

Due to Covid restrictions training will still be hosted online through our training partner Stellietech.

The following course dates are available on Sun-e-hr for staff members to enrol.

10-12 May 2021
17-19 May 2021
5-7 June 2021
7-9 June 2021
2-4 August 2021

Should you be interested in attending you must please apply via the Sun-HR System by following the steps below:

>employee self-service
     >>training and development
             >>>learner home
                     >>>>Information Technology
                                >>>>>Online Excel course

COURSE OUTLINE:

Import Data and Navigate workbooks

  • Import Data from Text Files
  • Import Data from CSV Files
  • Search for Data
  • Navigate to workbook Elements

Format worksheets and workbooks

  • Modify Page Setup
  • Adjust Row Height and Column Width.
  • Customise Headers and Footers

Customise Options and Views

  • Customise the Quick Access Toolbar
  • Explore Workbook Views
  • Freeze Rows and Columns
  • Change Window View
  • Modify Basic Workbook Properties
  • Display Formulas

Configure Content for Collaboration.

  • Set a Print Area
  • Save in Alternative File Formats
  • Configure Print Settings
  • Inspect Workbook for Issues.

Manipulate Data in Worksheets

  • Use Special Paste Options
  • Use Autofill to Fill Cells
  • Insert and Delete Rows and Columns
  • Insert and Delete Cells

Format Cells and Ranges

  • Merge and Unmerge Cells
  • Alignment, Orientation, and Indentation
  • Use the Format Painter
  • Wrap Text Within Cells
  • Apply Number Formats

 

 

Error reporting FAQs

Wednesday, October 7th, 2020

How do I report an IT problem, request or enquiry?

Option 1
Log a service request on our ICT Partner Portal
 with the following information:

1. Description of problem
2. Telephone number
3. Room Number
4. Department and building
5. Asset number of computer, laptop, printer, etc.

Requests will be logged automatically and reference number sent via email.

For video instructions on how to log a request on the ICT Partner Portal, click here. More information on our Service Catalogue.

Option 2
Contact the IT Service Desk – 021 808 4367

We require username and asset number in order to assist OR leave a voicemail message.


How do I follow up on the IT request I have logged?

Whether you have called the IT Service Desk at 0218084367, sent an email to help@sun.ac.za or logged a request via the ICT Partner Portal at https://servicedesk.sun.ac.za you can do the following:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requests. The status of all the requests that you have raised will be displayed.

How do I follow up if I sent an email to help@sun.ac.za?

If you send an email to help@sun.ac.za it automatically logs a request on the IT Service Portal. You can check on the status of your request as follows:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2.  Select: Requests, My requests. The status of all your requests will be displayed.

How do I follow up on a request I reported by calling the IT Contact Centre?

If you call the IT Contact Centre, the service agent will log a request on your behalf on the IT Service Portal. You can check on the status of your request as follow:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requests. The status of all your requests will be displayed.

Can you follow up on a request emailing help@sun.ac.za again?

If your request have already been logged and you have a reference number, please do not send another email to help@sun.ac.za. This will log a second, duplicate request which will only clog up the system and cause confusion. The same goes for replying to emails from help@sun.ac.za. Rather click on the request number and add your comment on the system.


How do I add a comment to my request?

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requestsThe status of all the requests that you have raised will be displayed.
  3. Click on the reference number of a request to see its details.
  4. Type your comment in the text box and click on Add. The comment will be added to the request. You can also add screen shots for clarification

What does the different status options mean?

WAITING ON SUPPORT =you are waiting for a response / feedback from IT regarding your request.

WAITING ON CUSTOMER =IT is waiting on a response / feedback from you regarding your request.

IN PROGRESS = your request is being attended to.

ESCALATED =your request is escalated for further investigation.

RESOLVED =your request has been resolved.

CLOSED = your request has been closed.

 

 

Online Excel training now available

Monday, June 15th, 2020

If you want to brush up on your Excel skills, we have just the solution for you. 

You can now do an online Excel course which covers all the content of Microsoft Office Excel 2019 needed to become internationally certified. It also aims to help with the navigation of Excel within the office 2019 and 365 environment.

The course takes place over four days and there are fixed training periods you can choose from. The next session takes place 24 to 27 August.

The only prerequisites are that you are computer literate, you have a desktop or laptop, Office365 and an internet connection.

To enrol for the course, you can register on SUN-e-HR. Browse to my.sun.ac.za, click on the SUN-e-HR tab and log in with your sun account. After logging in, you can go to
Training and development-> Learner Home->Information Technology and the Excel course will show there.

As soon as you’ve registered StellieTech, the company responsible for the training will contact you. Their trainers will follow along with your training progress and assist you to make sure you are on track throughout the programme.

The training material that will be covered is exactly the same as the material covered in StellieTech training centres. All aligned to the global industry standard and internationally accredited certification. On the platform, you will find their pre-assessments, training videos, practice simulations, post-assessments, and downloadable workbooks & follow along files. Everything is clearly laid out in the platform and very user friendly. 

More detailed information on the Excel-course.

Online survey tool for SU staff and students

Tuesday, May 12th, 2020

 

The web-based e-Survey service (SUNSurveys) is available to support academic staff and students of the University of Stellenbosch using online surveys for their academic research. SUNsurveys is also regularly used for staff opinion polls, voting and service delivery surveys.

Information Technology uses Checkbox as platform for our surveys. Checkbox is an intuitive survey creation tool with real-time reporting which allows for surveys to be customised. 

To register for use on Checkbox and send out official Stellenbosch University surveys, you can apply for the service online. More information on our Service Catalogue.

Once you have registered, support will be provided throughout to enable you to set up your survey, as well as training if needed. Additionally Checkbox has detailed help guides which will assist you will any potential problems you may encounter.

Take note that before you are allowed to send out a survey for research purposes, you will need institutional permission. Full information on the process can be found on the Information Governance website 

If you have any enquiries, please log a request on our ICT Partner Portal at ICT Partner Portal.

Free digital literacy training

Tuesday, October 1st, 2019

Our training service provider, StellieTech is currently offering a 3 Day Digital Literacy Course (see below for more detail on content, requirements, etc.)

The course is free to all SU staff, but space is limited, so register as soon as possible if you’re interested.

To register, go Sun e hr-> SUN Employee Self service-> Training and Development-> Learner Home-> Information Technology and the course will be listed there.

 


 

Duration: 3 Days

Recommended Prerequisites: Basic computer skills

Certificate of training: StellieTech Certificate of Completion

Assessments: Graded pre and post assessments between lessons.

Overview: This course aims to equip the learner with the knowledge and appreciation of the business environment and to empower them to be efficient and effective in the office.

Course Objectives:

·         Gain an insight into working with the internet and being able to use these skills in the workplace.

·         Learning how to be an effective assistant by using technology to enhance your productivity.

·         Computer training and basic tasks needed as a certified computer user.Course Information

Course Outline

Session 1: Working with the Internet

  • Internet
  • Navigation and Media Literacy
  • Browser Functionality
  • Rights and Usage
  • Email Clients
  • Calendaring
  • Communication Methods
  • Digital Citizenship

Session 2: Fundamental basics

  • Hardware
  • Internet Basics
  • Mobile Devices
  • Software Architecture
  • File and Software Management
  • Troubleshooting Basics
 

© 2013-2024 Disclaimer: The views and opinions expressed in this page are strictly those of the page author(s) and content contributor(s). The contents of this page have not been reviewed or approved by Stellenbosch University.