Difference between revisions of "Training Courses"

From Info Wiki
Jump to: navigation, search
m (Excel for Beginners (Roger Quarterman))
(2018 - Introduction to Spreadsheets (using Microsoft Excel 2007 and Libre Office Calc))
 
(138 intermediate revisions by 6 users not shown)
Line 5: Line 5:
 
=== Expressions of Interest ===
 
=== Expressions of Interest ===
 
*We welcome expressions of interest from Trainers wishing to run courses, and Participants seeking courses.
 
*We welcome expressions of interest from Trainers wishing to run courses, and Participants seeking courses.
*Please contact the [[mailto:office.manager@pcug.org.au PCUG Office]] for either/or.
+
*Please contact the [http://www.pcug.org.au/wp/contact-us/contact-forms/training PCUG Training Coordinator] via the contact form, or phone the PCUG on 1800 728 853 for either/or; OR
  +
*Use the [http://pcug.org.au/documents/forms/pcug-training-course-booking-form-general.pdf Training Course Booking Form]to lodge expressions of interest, whether advertised or otherwise.
   
 
=== Placing Bookings and Enquiries ===
 
=== Placing Bookings and Enquiries ===
* All bookings and enquireis may be emailed to [mailto:training@pcug.org.au PCUG Training Coordinator], or phone the PCUG Office on 6287 2922
+
* All enquires may be emailed to [http://www.pcug.org.au/wp/contact-us/contact-forms/training PCUG Training Coordinator] via the contact form, or phone the PCUG on 1800 728 853
  +
*Use the [http://pcug.org.au/documents/forms/pcug-training-booking-form-general.pdf Training Course Booking Form]to apply for a course or lodge an expression of interest.
*Please provide PCUG membership status and details, email address and contact phone number in any enquiry.
 
  +
*Please provide PCUG membership status and details (if applicable, non-members are also welcome), email address and contact phone number in any enquiry.
*All applications will be confirmed by the PCUG Office Manager, ASAP on receipt.
 
  +
*All applications will be confirmed by the PCUG Training Coordinator, ASAP on receipt.
   
== Courses for February 2013 ==
+
=== Course Fees ===
  +
* Course fees advertised are applicable to the current advertised course only, and may vary for future courses.
  +
* An admin levy of up to $40 is applicable to non-PCUG members attending PCUG courses (variable per individual course).
  +
* If the non-member course participant wishes to apply for PCUG membership, and does so within 3 months of the course start date, the applicant may apply for a $20 discount off the current PCUG subscription.
   
  +
== Courses for 2019==
=== Introduction to Databases, using Microsoft Access 2007 ===
 
*Fri 1, 8 , 15, 22 Feb 2013 0930am-1200pm (midday)
 
* A four week course will introduce participants to the design of a database system.
 
* Content to be covered will be the creation of tables to hold the data, queries to filter and sort data, forms to input and edit data and generating reports.
 
* Training Team: Peter Barker, assisted by Bob Winchester.
 
* Prior experience is not necessary. Pre-requisites are basic keyboard and mouse skills.
 
* Places: 6
 
* Apply: by email to [mailto:training@pcug.o​rg.au training@pcug.org.au] or phone the PCUG Office on 6287 2922.
 
* Course fee: $65 (or $45 for PCUG members)
 
   
=== Excel for Beginners ===
+
=== ABC - Absolute Beginners Computing ===
  +
* '''About''':
  +
**This course is designed for absolute beginners who are just starting out or those who never learned the basics - ''but who DO have home internet and Windows 7/10''.<br/>Sessions are based on the Windows 10 operating system, and held in the Grant Cameron Community Centre, Room 35 on Level 2A, 27 Mulley Street, Holder, with experienced volunteer trainers.<br/>Topics include learning your way around the computer, Internet basics, and Email. Each session is paced for beginners, with revision, take-home notes, and practice exercises.<br/>
  +
The need for this type of course is very popular, and reaching those who would
  +
benefit happens largely by word of mouth. Do you know someone who would benefit?
  +
As different people have varied needs, other groups are being formulated for
  +
example, for people who do not yet have a computer, or internet or email, we are
  +
planning on a modified version of the above training. All enquiries welcome.
  +
*'''Bookings and Expressions of Interest''':
  +
**'''Expressions of Interest are now being taken''' and may be lodged with the [mailto:training@pcug.org.au&subject=ABC&nbsp;Course PCUG Training Coordinator] or call the PCUG and request an email to be lodged on your behalf.
  +
**Full details of enrolment information may be viewed at the [http://www.pcug.org.au/info/index.php/Training_Courses#Expressions_of_Interest top of this page].
  +
*'''Brochure''':
  +
**A guide to session content is outlined in the [http://www.pcug.org.au/documents/brochure/abc-flyer-w10.pdf Absolute Beginners Computing Brochure (pdf)], noting that the Trainer may vary content focus to meet the needs of the group.
  +
*'''Trainer''': Mike Cassidy (and a team of experienced PCUG trainer assistants)
  +
* '''Session Information''':
  +
**Sessions for ABC Courses will be held on Mondays, Wednesdays or Fridays (to suit participants' needs) from 9.45am-12.15pm or 12.45-3.15pm, , and include a break for tea/coffee.
  +
**Sessions are planned for March 2019.
  +
**A similar Win-7 to Win-10 conversion course may be conducted depending on demand.
  +
**ABC and/or Win-7 to Win-10 conversion course dates to be announced.
   
  +
*'''Participants''': Limit 12 ''Applications open as detailed in Bookings and Expressions of Interest above''
*'''Course Title:''' Excel for Beginners<br>
 
  +
*'''Venue''': Room 35, Level 2A, Grant Cameron Community Centre, 27 Mulley St, Holder (Bus route 83)
*'''Description & Requirements:''' A training course introducing participants to Microsoft Excel (2007). Basic familiarity with Windows and Microsoft Office screens helpful but not essential. No previous knowledge of Excel required. Prepare to be surprised at the variety of things you can do with a spreadsheet!!
 
  +
*'''Fee''': $85 for members, $105 for non-members (includes afternoon tea, documentation and completion certificate). The surcharge of $20 for non-members can be put towards the cost of membership if you join within one month of the end of the course.
*'''Trainer:''' Roger Quarterman<br>
 
  +
-----------------------------------------------------------------
*'''When:''' runs over 6 sessions, with break (that includes Easter)
 
** Wed 6, 13, 20 Feb 2013 & Wed 10, 17, 24 April 2013
 
** Class times 10.00 to 12 noon.
 
* '''Where: '''PCUG Training Room, 27 Mulley St Holder.
 
*'''Fee:''' $80 ($60 for PCUG members)
 
*'''Places:''' CAPPED AT 6
 
*'''Applications:''' Email [mailto:training@pcug.org.au PCUG Training Coordinator]or phone the PCUG Office on 6287 2922.
 
   
  +
===2019 - Introduction to Spreadsheets (using Microsoft Excel 2007 and Libre Office Calc) ===
=== Excel: Using Macros and VBA in Excel ===
 
   
*'''Course Title:''' Using Macros and VBA in Excel<br>
 
*'''Description & Requirements:''' A training course in creating, modifying and using macros and isual Basic in Excel. Participants should be competent in using common features in Excel but no prior experience is required with macros and/or Visual Basic.
 
*'''Trainer:''' Peter Barker<br>
 
*'''When:''' The course will be conducted over 3 (three) consecutive sessions
 
** Wed 27 February 2013 0930am and 1200 midday; and
 
** Wed 6 March 2013 0930am and 1200 midday; and
 
** Wed 13 March 2013 0930am and 1200 midday.
 
* '''Where: '''PCUG Training Room, 27 Mulley St Holder.
 
*'''Fee:''' $45 (or $25 for PCUG members)
 
*'''Places:''' CAPPED AT 6
 
*'''Applications:''' Email [mailto:training@pcug.org.au PCUG Training Coordinator]or phone the PCUG Office on 6287 2922.
 
   
  +
*'''Course Title: Introduction to Spreadsheets'''
=== Absolute Beginners Computing (ABC) ===
 
  +
**Description & Requirements:
  +
***A course introducing participants to spreadsheets using Microsoft Excel (2007) and/or Libre Office Calc. Libre Office is free software that performs basically the same functions as Microsoft Office. Basic familiarity with the Windows environment will be assumed. No previous knowledge of spreadsheets required. Prepare to be surprised at the variety of things you can do with a spreadsheet!!
  +
***Spreadsheets are very powerful, versatile and widely used software. They make it easy to manage all sorts of problems from preschool arithmetic to highly sophisticated financial or statistical analysis. This course will start at the simplest level looking at how to manage your spreadsheet to make it work for you like an ordinary piece of paper (but better!), and progress to finding out how to use the spreadsheet to simplify some everyday tasks like planning a holiday itinerary or working out which is the best dog food to buy. Using the graphics features and charts will also be introduced.
  +
***There will be six sessions of two and a half hours with a 30 minute break for tea and discussion. Class members are invited to bring forward their own projects for the group to work on together.
  +
**The course prerequisite is that you should have completed the PCUG Absolute Beginners Computing course or attained an equivalent level of familiarity with a computer (ie you can open, close save and copy files).
  +
**'''Trainer:''' Roger Quarterman
  +
**'''When:''' Held over 6 sessions usually on Wednesday afternoons 02:00 pm to 04:30 pm.
  +
**'''Where:''' Room 35 Level 2A, Grant Cameron Community Centre, 27 Mulley Street, Holder.
  +
**'''Fee:''' $85 for PCUG members. There is a surcharge of $20 for non-members which can be put towards the cost of membership if you join within 1 month of the end of the course.
  +
**'''Places:''' up to 10.
  +
**'''Applications & Enquiries:''' Please contact Roger Quarterman quanro@pcug.org.au., for details of planned courses.
   
  +
== Other Courses (but not limited to ...) ==
*'''ABOUT''': This course is for absolute beginners who are just starting out or those who never learnt the basics. Sessions are in the PCUG Training Centre with experienced trainers. Topics include learning your way around the computer, email and Internet basics. Each session is paced for beginners, with revision, take-home notes and homework.
 
  +
* ''dates pending for next sessions, to be advised''
*'''TRAINER''': Eleanor Whelan (and a team of PCUG trainers)
 
  +
* NB: These and other courses listed here are scheduled pending demand & trainer availability,
*'''PARTICIPANTS''': Limit 11 ''Application open as detailed in FEE information''
 
  +
* Expressions of interest may be lodged at any time by emailing training@pcug.org.au, or contacting the PCUG on 1800 728 853
*'''VENUE''': PCUG, Level 2A, Grant Cameron Community Centre, 27 Mulley St, Holder
 
  +
* Are you wanting a course, or demonstration, or session on a subject not listed? Please let us know.
*'''FEE''': $60 for members, $80 for non-members (includes morning tea, documentation and completion certificate).
 
   
  +
=== ACCESS - Introduction to Databases (using Microsoft Access 2007) ===
*'''WHEN''': This course runs fortnightly for 6 x 2hr sessions. Class times: 10-12 noon. <br/>(Homework is allocated for you to do at home in the "off" week) <br/>
 
  +
* '''Expressions of Interest''' being accepted currently
** Session 1 - Tues 26 Feb, 2013
 
  +
* '''Scheduled:''' Last held Wed 9, 16, 23, & 30 April 2014 10am-1200pm (midday)
** Session 2 - Tues 12 March 2013
 
  +
* '''About:''' A four week course will introduce participants to the design of a database system. Content to be covered will be the creation of tables to hold the data, queries to filter and sort data, forms to input and edit data and generating reports. Prior experience is not necessary. Pre-requisites are basic keyboard and mouse skills.
** Session 3 - Tues 26 March 2013
 
  +
* '''Applications and Expression of Interest''': by email to [mailto:training@pcug.o​rg.au training@pcug.org.au] or phone the PCUG on 1800 728 853. Full guide to bookings and enquiries is outlined at the [http://www.pcug.org.au/info/index.php/Training_Courses#Expressions_of_Interest| top of this page]
** Session 4 - Tues 9 April 2013
 
** Session 5 - Tues 23 April 2013
 
** Session 6 - Tues 7 May 2013
 
 
*'''BOOKINGS & INFO''': '''Expressions of Interest are now being taken''' and may be lodged with the [mailto:training@pcug.org.au PCUG Training Coordinator]
 
 
*'''BROCHURE''': Details of session content is overviewed in the [http://www.pcug.org.au/documents/brochure/abc-flyer-w7.pdf Absolute Beginners Computing Brochure (pdf)]
 
 
== Other Courses (scheduled pending demand) ==
 
NB: These and other courses listed here are scheduled pending demand.
 
Expressions of interest may be lodged at any time by emailing training@pcug.org.au,
 
or contacting the PCUG office on 6287 2922
 
   
  +
=== EXCEL - Using Macros and VBA ===
  +
*'''Course Title:''' EXCEL - Using Macros and VBA in Excel<br>
  +
*'''Description & Requirements:''' A training course in creating, modifying and using macros and visual Basic in Excel. Participants should be competent in using common features in Excel but no prior experience is required with macros and/or Visual Basic.
  +
*'''When:''' Expressions of Interest being accepted currently <br/>The course will be conducted over 3 (three) consecutive sessions
  +
*'''Expressions of Interest & Applications:''' Follow the Expression of Interest information outlined at the [http://www.pcug.org.au/info/index.php/Training_Courses#Expressions_of_Interest|top of this page] Email [mailto:training@pcug.org.au PCUG Training Coordinator]or phone the PCUG on 1800 728 853.
   
 
=== Wiki Editing ===
 
=== Wiki Editing ===
Line 85: Line 88:
 
* '''PARTICIPANTS''': 10 places open to any PCUG member or others interested in learning more about editing wikis.
 
* '''PARTICIPANTS''': 10 places open to any PCUG member or others interested in learning more about editing wikis.
 
* '''FEE''': $20 (PCUG members), $40 (non-members), or Free** (**''the fee will be waived for any regular PCUG volunteer who agrees to use this training to further build our information resources'')
 
* '''FEE''': $20 (PCUG members), $40 (non-members), or Free** (**''the fee will be waived for any regular PCUG volunteer who agrees to use this training to further build our information resources'')
* '''BOOKINGS''': to [[mailto:training@pcug.org.au PCUG Training Bookings]] or phone the PCUG Office on 6287 2922. (''Further sessions will follow pending demand'').
+
* '''BOOKINGS''': to [[mailto:training@pcug.org.au PCUG Training Bookings]] or phone the PCUG on 1800 728 853. (''Further sessions will follow pending demand'').
 
   
   

Latest revision as of 00:34, 29 January 2019

Introduction

General Overview Information regarding Training Facilities and Courses

Expressions of Interest

  • We welcome expressions of interest from Trainers wishing to run courses, and Participants seeking courses.
  • Please contact the PCUG Training Coordinator via the contact form, or phone the PCUG on 1800 728 853 for either/or; OR
  • Use the Training Course Booking Formto lodge expressions of interest, whether advertised or otherwise.

Placing Bookings and Enquiries

  • All enquires may be emailed to PCUG Training Coordinator via the contact form, or phone the PCUG on 1800 728 853
  • Use the Training Course Booking Formto apply for a course or lodge an expression of interest.
  • Please provide PCUG membership status and details (if applicable, non-members are also welcome), email address and contact phone number in any enquiry.
  • All applications will be confirmed by the PCUG Training Coordinator, ASAP on receipt.

Course Fees

  • Course fees advertised are applicable to the current advertised course only, and may vary for future courses.
  • An admin levy of up to $40 is applicable to non-PCUG members attending PCUG courses (variable per individual course).
  • If the non-member course participant wishes to apply for PCUG membership, and does so within 3 months of the course start date, the applicant may apply for a $20 discount off the current PCUG subscription.

Courses for 2019

ABC - Absolute Beginners Computing

  • About:
    • This course is designed for absolute beginners who are just starting out or those who never learned the basics - but who DO have home internet and Windows 7/10.
      Sessions are based on the Windows 10 operating system, and held in the Grant Cameron Community Centre, Room 35 on Level 2A, 27 Mulley Street, Holder, with experienced volunteer trainers.
      Topics include learning your way around the computer, Internet basics, and Email. Each session is paced for beginners, with revision, take-home notes, and practice exercises.
 The need for this type of course is very popular, and reaching those who would
 benefit happens largely by word of mouth. Do you know someone who would benefit?
 As different people have varied needs, other groups are being formulated for
 example, for people who do not yet have a computer, or internet or email, we are
 planning on a modified version of the above training. All enquiries welcome.
  • Bookings and Expressions of Interest:
    • Expressions of Interest are now being taken and may be lodged with the PCUG Training Coordinator or call the PCUG and request an email to be lodged on your behalf.
    • Full details of enrolment information may be viewed at the top of this page.
  • Brochure:
  • Trainer: Mike Cassidy (and a team of experienced PCUG trainer assistants)
  • Session Information:
    • Sessions for ABC Courses will be held on Mondays, Wednesdays or Fridays (to suit participants' needs) from 9.45am-12.15pm or 12.45-3.15pm, , and include a break for tea/coffee.
    • Sessions are planned for March 2019.
    • A similar Win-7 to Win-10 conversion course may be conducted depending on demand.
    • ABC and/or Win-7 to Win-10 conversion course dates to be announced.
  • Participants: Limit 12 Applications open as detailed in Bookings and Expressions of Interest above
  • Venue: Room 35, Level 2A, Grant Cameron Community Centre, 27 Mulley St, Holder (Bus route 83)
  • Fee: $85 for members, $105 for non-members (includes afternoon tea, documentation and completion certificate). The surcharge of $20 for non-members can be put towards the cost of membership if you join within one month of the end of the course.

2019 - Introduction to Spreadsheets (using Microsoft Excel 2007 and Libre Office Calc)

  • Course Title: Introduction to Spreadsheets
    • Description & Requirements:
      • A course introducing participants to spreadsheets using Microsoft Excel (2007) and/or Libre Office Calc. Libre Office is free software that performs basically the same functions as Microsoft Office. Basic familiarity with the Windows environment will be assumed. No previous knowledge of spreadsheets required. Prepare to be surprised at the variety of things you can do with a spreadsheet!!
      • Spreadsheets are very powerful, versatile and widely used software. They make it easy to manage all sorts of problems from preschool arithmetic to highly sophisticated financial or statistical analysis. This course will start at the simplest level looking at how to manage your spreadsheet to make it work for you like an ordinary piece of paper (but better!), and progress to finding out how to use the spreadsheet to simplify some everyday tasks like planning a holiday itinerary or working out which is the best dog food to buy. Using the graphics features and charts will also be introduced.
      • There will be six sessions of two and a half hours with a 30 minute break for tea and discussion. Class members are invited to bring forward their own projects for the group to work on together.
    • The course prerequisite is that you should have completed the PCUG Absolute Beginners Computing course or attained an equivalent level of familiarity with a computer (ie you can open, close save and copy files).
    • Trainer: Roger Quarterman
    • When: Held over 6 sessions usually on Wednesday afternoons 02:00 pm to 04:30 pm.
    • Where: Room 35 Level 2A, Grant Cameron Community Centre, 27 Mulley Street, Holder.
    • Fee: $85 for PCUG members. There is a surcharge of $20 for non-members which can be put towards the cost of membership if you join within 1 month of the end of the course.
    • Places: up to 10.
    • Applications & Enquiries: Please contact Roger Quarterman quanro@pcug.org.au., for details of planned courses.

Other Courses (but not limited to ...)

  • dates pending for next sessions, to be advised
  • NB: These and other courses listed here are scheduled pending demand & trainer availability,
  • Expressions of interest may be lodged at any time by emailing training@pcug.org.au, or contacting the PCUG on 1800 728 853
  • Are you wanting a course, or demonstration, or session on a subject not listed? Please let us know.

ACCESS - Introduction to Databases (using Microsoft Access 2007)

  • Expressions of Interest being accepted currently
  • Scheduled: Last held Wed 9, 16, 23, & 30 April 2014 10am-1200pm (midday)
  • About: A four week course will introduce participants to the design of a database system. Content to be covered will be the creation of tables to hold the data, queries to filter and sort data, forms to input and edit data and generating reports. Prior experience is not necessary. Pre-requisites are basic keyboard and mouse skills.
  • Applications and Expression of Interest: by email to training@pcug.org.au or phone the PCUG on 1800 728 853. Full guide to bookings and enquiries is outlined at the top of this page

EXCEL - Using Macros and VBA

  • Course Title: EXCEL - Using Macros and VBA in Excel
  • Description & Requirements: A training course in creating, modifying and using macros and visual Basic in Excel. Participants should be competent in using common features in Excel but no prior experience is required with macros and/or Visual Basic.
  • When: Expressions of Interest being accepted currently
    The course will be conducted over 3 (three) consecutive sessions
  • Expressions of Interest & Applications: Follow the Expression of Interest information outlined at the of this page Email PCUG Training Coordinatoror phone the PCUG on 1800 728 853.

Wiki Editing

  • ABOUT: A lot of PCUG information is now delivered using a wiki interface. Editing Wikis is not as daunting as it seems, and we are seeking to encourage members to share information via this tool where-ever possible. Our secretary, and TIP admin, Lawrie Brown will step participants through the process of placing information on a wiki by editing and creating pages, and formatting their content. He will use the reference guide pages he created. This will be a hands on session, with plenty of time for you to explore the content creation and formatting process. If at all possible, please bring some plain text content that you'd like to contribute to one of our wikis on a USB drive. You can also bring some images to include in your pages, as we'll also be exploring how to upload and reference images.
    If you are new to contributing to wiki's, please see these guides, which we will work through and discuss during this course: Getting Started Editing Wiki Pages, and More_on_Working_with_Wikis.
  • WHEN: TBA (last session held Wed 26 September, 2012 with Lawrie Brown)
  • WHERE: PCUG Centre, Grant Cameron Community Centre, Holder.
  • TRAINER: TBA
  • PARTICIPANTS: 10 places open to any PCUG member or others interested in learning more about editing wikis.
  • FEE: $20 (PCUG members), $40 (non-members), or Free** (**the fee will be waived for any regular PCUG volunteer who agrees to use this training to further build our information resources)
  • BOOKINGS: to [PCUG Training Bookings] or phone the PCUG on 1800 728 853. (Further sessions will follow pending demand).