The enrolment duration for each course for students studying at our Free4U Henderson or Birkenhead classrooms is 18 hours (apart from Getting Started in Computing which is 15 hours) or 10 weeks (whatever comes first), but students can finish before the allocated time.  The maximum number of enrolments per student per course is two in line with government funding conditions.

Office 2016 Courses

FREE4U TASTER QUIZ

For an example of the types of things covered at Free4U, click here to do the Free4U Taster Quiz.  Our quizzes are not compulsory and you are not graded on your results.

Course Content

ISCGS200 - GETTING STARTED IN COMPUTING

Delivery Method: Instructional Website and Take Home Notes
By the end of this course you should be able to:

  • Understand how a mouse interacts with a computer (Mousing Around Exercise)
  • Understand what a computer is used for and the different types of computers
  • Identify various hardware components and define Operating System vs Application Software
  • Understand how a keyboard interacts with a computer and identify parts of the screen
  • Understand File Management, Drive Terminology and Data Storage
  • Create a new document and save it to a USB device
  • Check a document for spelling and grammar mistakes
  • Print a document
  • Convert a Microsoft Word document into PDF.
  • Understand Ergonomics and OOS

ISCGS201 - KEYBOARDING

Delivery Method: Instructional Software
By the end of this course you should be able to:

You'll use TypingMaster Pro to teach you which fingers to use, giving you accuracy and speed with your typing. There are lots of typing exercises and drills.

ISCGS207 - INTERNET AND EMAIL (includes Outlook)

Delivery Method: Instructional Website, Textbook and Take Home Notes
By the end of this course you should be able to:

  • Understand what the internet and the Word Wide Web are and what you can access on the Web
  • Understand how to be safe while using the Web
  • Identify the different parts of a browser, access websites and use YouTube & Google Maps
  • Understand how to use a Search Engine
  • Practice good email etiquette
  • Setup a Gmail account - send new emails, reply to emails, send attachments, forward emails, send links, add contacts and send appointments
  • Access an Outlook account - send new emails, reply to emails, send attachments, forward emails, add contacts and send appointments
  • Understand the basics of using Facebook & TradeMe
  • Access websites that will assist you in your job search or upskilling
  • Understand the basics of using Skype
  • Understand how to connect to the internet and how to setup the internet at home

ISCGS235/ ISCGS935 - INTRODUCTION TO WORD 2016 PART 1

Delivery Method: Textbook and Take Home Notes
By the end of this course you should be able to:

  • Identity the different parts of the Microsoft Word screen
  • Have a basic understanding of Microsoft Word terminology
  • Understand File Management, Drive Terminology and Data Storage
  • Create a new document and save it to a USB device
  • Check a document for spelling and grammar mistakes
  • Print a document
  • Open existing documents
  • Add content to existing documents and resave 
  • Know where to find MS Word help
  • Customize the Quick Access Toolbar
  • Add a Header & Footer to a document
  • Convert a Microsoft Word document into PDF.
  • Understand Ergonomics and OOS

ISCGS236/ ISCGS936 - INTRODUCTION TO WORD 2016 PART 2

Delivery Method: Textbook and Take Home Notes
By the end of this course you should be able to:

  • Rename, delete and move files and folders
  • Edit and proofread existing documents
  • Use the Cut, Copy and Paste functionality
  • Change text formatting on Microsoft Word documents including changing the font, font size, bold, italic, underline, text colour.
  • Change paragraph formatting on Microsoft Word documents including changing the alignment, bullets and numbering, line spacing, shading
  • Insert Online Pictures, Online Video, Word Art and Shapes
  • Insert Special Characters
  • Create a document based on a finished product.
  • Create a CV and Cover Letter based on a suggested format

ISCGS237/ ISCGS937 - INTRODUCTION TO EXCEL 2016

Delivery Method: Textbook and Take Home Notes
By the end of this course you should be able to:

  • Identity the different parts of the Microsoft Excel screen
  • Have a basic understanding of Microsoft Excel terminology
  • Know where to find MS Excel help
  • Customize the Quick Access Toolbar
  • Create a new spreadsheet and save it to a USB device
  • Print a spreadsheet
  • Open existing spreadsheets
  • Add content to and edit existing spreadsheets and resave 
  • Add borders and Merge & Center data
  • Use the Autosum function and the Autofill tool
  • Understand Font, Alignment & Number formatting
  • Insert & delete rows and columns
  • Insert, delete, rename, move and copy sheets
  • Link sheets and use basic functions SUM, MAX, MIN, AVG
  • Create basic charts
  • Create spreadsheets based on a finished product

ISCGS239/ ISCGS939 - INTRODUCTION TO PUBLISHER 2016

Delivery Method:  Textbook and Take Home Notes
By the end of this course you should be able to:

  • Identity the different parts of the Microsoft Publisher screen
  • Have a basic understanding of Microsoft Publisher terminology
  • Create a new publication and save it to a USB device
  • Print a publication
  • Open existing publications
  • Add content to publications and resave 
  • Know where to find MS Publisher help
  • Customize the Quick Access Toolbar
  • Insert, resize, rotate, autofit, format and move Text Boxes
  • Insert Pictures, Online Pictures, Word Art & Shapes
  • Select, delete, add colour to, resize, rotate, group/ ungroup, layer and apply 3D & other effects to Objects
  • Use templates and apply background patterns & colour schemes
  • Insert building blocks including page parts, calendars, borders/ accents and ads
  • Create publications based on a finished product

ISCGS238/ ISCGS938 - INTRODUCTION TO POWERPOINT 2016

Delivery Method:  Textbook and Take Home Notes
By the end of this course you should be able to:

  • Identity the different parts of the Microsoft PowerPoint screen
  • Have a basic understanding of Microsoft PowerPoint terminology
  • Know where to find MS PowerPoint help
  • Customize the Quick Access Toolbar
  • Create a new presentation and save it to a USB device
  • Print a presentation
  • Open existing presentations
  • Add content to and edit existing presentations and resave 
  • Use Normal, Slide Sorter, Reading, Slide Show, Presenter & Notes views
  • Insert, delete and move slides
  • Insert Pictures, Online Pictures, Online Video, Word Art & Shapes
  • Add slide transitions and custom animation
  • Create presentations based on a finished product

Extras - TBA

ISCGS240/ ISCGS940 - INTRODUCTION TO ACCESS 2016 (now available)

Delivery Method:  Textbook and Take Home Notes
By the end of this course you should be able to:

  • Understand what a database is and the advantages of storing information in a database
  • Be able to give some examples of databases
  • Identity the different parts of the Microsoft Access screen
  • Have a basic understanding of Microsoft Access terminology
  • Understand different types of databases (Flat file vs Relational Databases), database relationships and the definition of a Primary Key vs a Foreign Key 
  • Understand what Access Objects are (Tables, Queries, Forms & Reports) and how to open, close, rename and delete objects on the Navigation Pane
  • Know where to find MS Access help
  • Customize the Quick Access Toolbar
  • Open existing databases
  • Use existing Forms to navigate between records, add records, find & modify records, delete records, modify the forms design including adding & deleting fields to and from tables & modifying the forms accordingly, add a calculated control and add new Forms. 
  • Design basic queries and use search criteria, parameter queries and calculated fields to get the required output
  • Design basic reports and modify them; including adding logos, changing colours, adjusting column widths and fonts and adding calculated controls.