Our CCA

Training Workshops

Aligned with our mission to be the IT training hub in NUS, we are committed to providing highly-demanded training workshops to our NUS community. In every semester, we equip our members with the necessary skills and knowledge needed before embarking with them to spread their knowledge to the NUS community. Most our workshops are 6-hours long, except for several specialized workshops.

For workshop registration, we will be using NUSync, a platform for NUS students. You can access the NUS Student Union’s portal in NUSync and look for our events.

Once you have registered via NUSync, do remember to make the $5 refundable deposit payment. Deposit has to be submitted to NUSSU Secretariat, YIH Monday to Wednesday on the week of the respective workshop on office hours (1000 – 1800, minus the lunch time on 1300 – 1400). Deposit for each workshop must be done separately, each during the week of the workshop itself. The deposit will be returned upon attendance to the workshop.

To go to NUSSU Secretariat: in Yusof Ishak House, from the entrance of the Study Room, go towards Student Lounge. On your left, there will be a lot of stairs. Just keep on climbing until the 5th floor. In the right, there will be a sign saying “NUSSU Secretariat”.

If you have any queries, check out our Workshops FAQ, kindly approach our supervisor at YIH Computer Centre or feel free to contact us at trainingcell@nussucommit.com.

Microsoft Excel

Microsoft Excel has been the all-time favorite software for data handling through the use of its versatile spreadsheet layout. Be it to create simple tables and charts, or to handle massive financial records and experimental results, Microsoft Excel is able to manipulate these data into usable information with ease.

Our workshop will cover these topics which will bring you from the introductory page to the basic functions and manipulations in Microsoft Excel:

  • Navigation and Interface
  • Basic Formulas
  • Cell Formatting
  • Data Processing (Paste Values, Sort, Filter)
  • View (Freeze Panes, Page Break View)
  • Charts and Graphing
  • Protect
  • Pivot Table and Pivot Chart
  • Functions (IF, HLOOKUP, VLOOKUP)

There will be two Microsoft Excel workshops on Semester 2 AY 2017/2018, both of them covering exactly the same materials.
The workshop will be held on:

Session 1

  • Date: Saturday, 3 February 2018
  • Time: 11.00 – 15.30
  • Venue: Training Room, Central Library Level 6

Session 2

  • Date: Saturday, 17 March 2018
  • Time: 09.30 – 14.00
  • Venue: ThinkLab, Computer Centre Level 3

Adobe Photoshop CC

The premier and leading graphics-editing software in the world. Used by professional graphic designers to amateur photographers, the Photoshop skill has proven to be vital in differentiating oneself. Be it to create viral, hoax photos or beautifying one’s looks, we are there to provide you with the necessary skills.

  • Navigation and Interface
  • Basic Tools (Text, Brush, Eraser)
  • Selection Tools
  • Introduction to Layers
  • Layer Masking
  • Layer Style
  • Layer Blending Modes
  • Healing Tools, Dodge, Burn, Blur, Sharpen
  • Selective Adjustments
  • Filter, Liquify

There will be two Adobe Photoshop workshops on Semester 2 AY 2017/2018, both of them covering exactly the same materials.
The workshop will be held on:

Session 1

  • Date: Saturday, 10 February 2018
  • Time: 10.00 – 16.00
  • Venue: ThinkLab, Computer Centre Level 3

Session 2

  • Date: Saturday, 31 March 2018
  • Time: 10.00 – 16.00
  • Venue: ThinkLab, Computer Centre Level 3

Adobe Illustrator

Another one from the Adobe family, the world’s best digital editing software, Illustrator is the go-to program for professional vector drawing and editing. Create scalable vector artwork with no loss of resolution for use both in print and digital form using Illustrator. In this workshop, we will be teaching the essentials of the software Illustrator and practicing a simulation of the workflow of a graphic designer – from paper to screen.

  • Navigation and Interface
  • Tools Panel
  • Building Shapes
  • Lines, Curve and Sketching
  • Image Tracing
  • Effects

There will be two Adobe Photoshop workshops on Semester 2 AY 2017/2018, both of them covering exactly the same materials.
The workshop will be held on:

Session 1

  • Date: Saturday, 10 February 2018
  • Time: 10.30 – 16.30
  • Venue: Training Room, Central Library Level 6

Session 2

  • Date: Saturday, 31 March 2018
  • Time: 10.30 – 16.30
  • Venue: Training Room, Central Library Level 6

Website Design

We live in a world surrounded by websites, be it searching information from Google or updating your Facebook pages. Sometimes, the magic behind the websites are the seemingly unlimited yet intriguing designs & interfaces in front of your computer screens. Surprisingly, most of these designs relies on basic strings and codes which let you program your website interface with high degree of freedom. Therefore, understanding the basic HTML and CSS codes are essential to design your own website.

The workshop will cover these following topics:

Basic Web Development

  • What you’ll learn by the end of the day:
    • Build a mobile responsive website (viewable on phone, desktop and tablet) hosted online!
  • Detailed contents:
    • Introduction to overall computational thinking concepts
    • Web building blocks – HTML and CSS
    • Syntax and common web design elements
    • Publishing and collaborating online

    Basic Mobile App Development

    • What you’ll learn by the end of the day:
      • Create a downloadable Android app!
    • Detailed contents:
      • What is MIT App Inventor and What can it do
      • App architecture and problem decomposition
      • App #1: Snap and share; CS concepts: User interface, event-driven programming, variables
      • App #2: Photo booth; CS concepts: Conditionals (if-then-else), procedures
      • This year, NUSSU commIT collaborating with AIESEC will be hosting a special 2-day website design workshop. The workshop will be conducted by external professional trainers from Code for Asia assisted by 6 NUS students proficient in web design as teaching assistant. You will receive a certificate upon completion of the workshop.
        Check out about Code for Asia in http://codefor.asia/

        The workshop will be held on:

        • Date: Monday, 26 February 2018 – Tuesday, 27 February 2018
        • Time: 09.00 – 17.00
        • Venue: Biz 2, 05 – 09 and 05 – 10

        Excel VBA

        Excel Visual Basic for Applications is a highly-demanded software, long-demanded by the NUS community. Excel VBA is the most overlooked, useful feature in MS Excel. It is a specified required skill by many business firms as well as engineering firms. Programming with VBA allows spreadsheet manipulation that is awkward or impossible with standard spreadsheet techniques.
        This semester (AY17/18 Sem 2), we will be hosting a special workshop for Excel VBA. External professional trainers from Acadia training company will be conducting the workshop and you will receive a certificate upon completion of the workshop. The workshop will cover these following topics:

        Introduction to VBA

        • The Excel Developer Tab
        • Change Macro Security Settings
        • VBA Macro Security Settings
        • The VBA Environment
        • The Visual Basic Editor
        • Saving VBA Codes In Excel
        • The Standard Toolbar

        User Forms & Modules

        • Creating And Removing A User Form/Module
          • To Add A User Form / Module
          • To Remove A User Form / Module
        • The View Object Mode And Toolbox
        • Manipulating Objects In A User Form
        • Naming Objects
        • Activating A User Form
        • Writing Simple Codes

        Variables & Data Types

        • Visual Basic Data Types
        • Understanding Variables
        • Scope Of Variables

        VBA Codes

        • The Msgbox Function
        • Setting Objects Properties
        • Positioning The Excel Activecell Cursor With Codes
        • Retrieving The Content Of An Activecell
        • Populating A Combobox With Default Values
        • If–Then–Else Statement
        • Comparison Operators
        • Select Case Statement
        • The Offset Method
        • Do Until Loop
        • User-Defined Functions & Sub Procedures
          • Arguments
          • Passing Arguments By Value and By Reference
          • Calling VBA Functions & Sub Procedures

        The workshop will be held on:

        • Date: Thursday, 1 March 2018
        • Time: 10.00 – 17.00
        • Venue: Utown Lecture Theatre (Tentative)

        (If you wish to be updated on our workshops or events, you can subscribe to our mailing list by dropping us an email at nussu.commit@gmail.com)