Qualification - Proficiency Award In Computer Programming

Course CodeVIT008
Fee CodePA
Duration (approx)500 hours
QualificationProficiency Award

STUDY ONLINE COMPUTER PROGRAMMING

COURSE STRUCTURE

To attain a proficiency award, you need to:

 A/ Complete assignments and pass exams for three 100 hour modules/subjects
Visual Basic .Net Programming
ASP.Net
SQL Database Programming

(see brief outlines of these three modules below)

AND

B/ 200 hrs work experience or a workplace project
You can satisfy this by either submitting a reference from an employer or reputable colleague; or by undertaking a major programming project and submitting your work (under guidance from a tutor).

Modules

Core ModulesThese modules provide foundation knowledge for the Qualification - Proficiency Award In Computer Programming.
 Industry Project BIP000
 Visual Basic.Net BIT101
 Asp.Net Programming BIT200
 SQL For The Web BIT201
 Workshop II BGN203
 

Note that each module in the Qualification - Proficiency Award In Computer Programming is a short course in its own right, and may be studied separately.


VisualBasic.net

There are 12 lessons in this course:

  1. Introduction
    • History of BASIC
    • What is microsoft .NET
    • Programs
    • Keywords
    • Sequence
    • Selection
    • Repetition
    • Methods
    • Object libraries
    • Writing programs
    • Integrated Development Environment
    • Your first program : Hello World
    • A console program
    • Hello World explained
    • A windows based program
  2. Variables
    • What are variables
    • Arrays
    • Hungarian notation
    • Kinds of variables (Data types)
    • Assigning variable values
    • Operator precedence
    • Strings
    • Hard coding variables
    • Programming exercise
    • Using variables
    • Comments
  3. Understanding conditional statements
    • Program flow and branching
    • Sequence
    • Selection
    • if statements
    • if...else statements
    • Nested ifs vs elself
    • The select statement
    • Repetition (looping)
    • For loop
    • While loops
    • Do loops
    • Evaluating conditions with boolean expressions
    • Comparison operators
    • And, or and not
    • Formatting code (indenting)
    • Programming exercise: countdownTimer1_Tick() explained
    • Button1_Click() explained
  4. I/O handling
    • What is a file
    • Data files
    • Program files
    • Saving files
    • I/O
    • Accessing files
    • Sequential files
    • Random files
    • Binary files
    • Opening files
    • Namespaces
    • Streamreader and streamwriter classes
    • Streams
    • Programming exercises: Writing a file (output), Reading a file (input)
    • Exercises explained
    • Reading files by line
  5. Controls and Objects : An Introduction
    • Contros
    • Objects
    • Programming exercises
    • Simple poker machine
    • Stepwise development
  6. Structured Programming using Modules
    • Modular program techniques
    • Top down vs bottom up
    • Modules and methods
    • Methods
    • Method header
    • Parameters
    • Arguments
    • Cohesion and coupling
    • Variable scope
    • Local vs global variables
    • Passing values
    • Procedures vs functions
    • Programming exercise: Simple calculator
  7. Properties, Methods, Events and Classes
    • Objects and classes
    • OOP concepts
    • Fields, properties, methods and events
    • Encapsualation, inheritance andpolymorphism
    • Overloading, overriding and shadowing
    • Access levels
    • Constructors and destructors
    • Programming exercise: Cat class
  8. Inheritance
    • What is inheritance
    • When to use inheritance
    • Inheritance rules
    • Inheritance modifiers
    • Overriding properties and methods
    • MyBase
    • MyClass
    • Programming exercise: club members
  9. Polymorphism
    • What is polymorphism
    • Using polymorphism
    • Programming Exercise: Club members
  10. Using Controls
    • Types of controls
    • Button
    • Label
    • Text box
    • List box
    • Combo box
    • Check box
    • Radio button
    • HScroll bar
    • VScroll bar
    • Picture box
    • FolderBrowserDialog
    • Group box
    • Timer
    • Using controls
  11. Debugging
    • Programming errors
    • Types of bugs
    • Syntax errors
    • Logic errors
    • Runtime errors
    • Finding bugs
    • Breakpoints
    • Trapping Errors with Try ... Catch
  12. Developing a Complete VB.NET Application
    • System development lifecycle
    • System request
    • Analysis and design
    • Programming
    • Testing and acceptance
    • Installation, implementation
    • Maintenance
    • Using interface design (UID)
    • Appendix 1 Glossary of Visual Basic .NET Terminology
    • Appendix 2 Visual Basic .NET Resources

Each lesson culminates in an assignment which is submitted to the school, marked by the school's tutors and returned to you with any relevant suggestions, comments, and if necessary, extra reading.

 

Asp.Net Programming

There are 11 lessons in this course:

  1. Introduction
  2. VB.NET Essentials
  3. Web Forms
  4. Web Server Controls
  5. Form Validation
  6. Classes and Namespaces
  7. Creating ASP.NET Applications
  8. ADO.NET
  9. Error Handling
  10. Email from your Applications
  11. Project: Creating an Online Store

Each lesson culminates in an assignment which is submitted to the school, marked by the school's tutors and returned to you with any relevant suggestions, comments, and if necessary, extra reading.

 

SQL for the Web

There are 12 lessons in this course:

  1. Introduction to Databases
    • What is a database
    • DBMS
    • The relational model
    • Primary keys
    • Foreign keys
    • Relationships
    • Normalisation
    • Other normal forms
    • De normalisation
  2. Fundamentals of SQL
    • Installing a DBMS
    • SQL
    • The select statement
    • Common errors
    • Identifiers
  3. Building a database with SQL
    • Building a database: RAD tool, CSV file, opening database, commands, etc
    • Data types and MS access
  4. Retrieving, Storing, Updating and Deleting Data
    • Retrieving data
    • Retrieving from tables with relationships
    • Creating column aliasesEliminating duplicate rows withDISTINCT
    • Filtering rows with WHERE
    • Matching patterns with LIKE
    • Escaped and unescaped patterns
    • Range filtering with BETWEEN
    • List filtering with IN
    • Evaluating conditional values with CASE
    • Sorting rows by ORDER BY
    • Storing, updating and deleting dataUpdating rows with UPDATE
    • Deleting rows with DELETE
  5. Advanced SQL database access methods
    • Relational databases
    • Creating outer joins with OUTER JOIN
    • Subqueries
    • Summarising data
    • Grouping rows
    • Using HAVING for filtering rows
    • Set operations
    • Union
    • Intersect
    • Except
    • Handling duplicates
  6. Database Security
    • Security is important
    • Triggers
  7. Using SQL in applications
    • Using SQL in an application
    • Using SQL in web sites
    • Using SQL in desk top applications
    • Using SQL in mobile devices
    • Embedded SQL
    • SQL injection
  8. Cursors
    • What are cursors
    • Preventing updates and deletions
    • Scrollable Cursors
  9. Stored procedures
    • Introduction
    • Compound statements
    • Stored functions
    • Stored modules
    • Views
    • Indexes
    • Controlled flow statements
  10. Error Handling
    • Stability
  11. Dynamic SQL
    • Introduction
    • Execution of dynamic SQL
    • Single step execution
    • Two step execution
    • Dynamic cursors
  12. Advice and Tips
    • Common mistakes
    • Assuming the client knows what they need
    • Underestimating project scope
    • Only considering technical factors
    • Not seeking client feedback
    • Skipping beta testing

Each lesson culminates in an assignment which is submitted to the school, marked by the school's tutors and returned to you with any relevant suggestions, comments, and if necessary, extra reading.

 

Workplace Project

You next must complete a Workplace Project or work experience (approved by a tutor and equal to 200 hours duration)

There are four options available to you to satisfy the Workplace Project Requirement requirement:

Alternative 1.

If you work in the industry that you have been studying; you may submit a reference from your employer, in an effort to satisfy this industry (ie. workplace project) requirement; on the basis of RPL (ie. recognition for prior learning), achieved through your current and past work experience.

The reference must indicate that you have skills and an awareness of your industry, which is sufficient for you to work in a position of responsibility.

Alternative 2.

A one module credit (100 hrs) can be achieved by verifying attendance at a series of industry meetings, as follows:

  •  Meetings may be seminars, conferences, trade shows, committee meetings, volunteer events (eg. Community working bees), or any other meeting where two or more industry people or people who are knowledgeable about their discipline.
  •  Opportunity must exist for the student to learn through networking, observation and/or interaction with people who know their industry or discipline
  •  A list of events should be submitted together with dates of each attended and times being claimed for each
  •  Documentary evidence must be submitted to the school to indicate support each item on the above list (eg. Receipts from seminars, conference or shows, letters from committee or organisation secretaries or committee members. All such documentation must contain a contact details)

Alternative 3.

Credits can be achieved by completing standard modules Workplace Project I, II and/or III

Each of these modules comprises a series of “hands on” PBL projects, designed as learning experiences that involve interaction with the real world. (This approach is based upon tried and proven learning approaches that originated in American universities but are now widely used and respected by academia throughout many countries). See the web site or handbook for more detail.

Alternative 4.

If you do not work in the relevant industry, you need to undertake a project as follows.

 

Procedure for a Workplace Project

This project is a major part of the course involving the number of hours relevant to the course (see above). Although the course does not contain mandatory work requirements, work experience is seen as highly desirable.

This project is based on applications in the work place and specifically aims to provide the student with the opportunity to apply and integrate skills and knowledge developed through various areas of formal study.

Students will design this project in consultation with a tutor to involve industry based activities in the area of specialized study which they select to follow in the course. The project outcomes may take the form of a written report, folio, visuals or a mixture of forms. Participants with relevant, current or past work experience will be given exemption from this project if they can provide suitable references from employers that show they have already fulfilled the requirements of this project.

For courses that involve more than 100 hours, more than one workplace project topic may be selected. For example, 200 hours may be split into two projects each of 100 hours. This will offer the student better scope to fulfill the needs of their course and to meet the number of hours required. Alternatively, the student may wish to do one large project with a duration of 200 hours.

Students will be assessed on how well they achieve the goals and outcomes they originally set as part of their negotiations with their tutor. During each 100 hours of the project, the students will present three short progress reports. These progress reports will be taken into account when evaluating the final submission. The tutor must be satisfied that the work submitted is original.

If the student wishes to do one large 200 hour report, then only three progressive reports will be needed (however the length of each report will be longer).


HOW TO PROCEED

1. Students are expected to select a suitable project or task to complete that allows the student to apply and integrate the knowledge and skills they have obtained as part of their studies.

2. The student should submit a draft proposal outlining their proposed project, study or task. The expected outcomes of this project should be clearly stated. This will be looked at by a tutor and comments made. Students are welcome to visit the school or to talk to a tutor to obtain advice on how to draw up their proposal. The proposal should indicate what the student intends to do, how they intend to do it, where they intend to do it, and what they expect to produce (e.g. a written report, a folio, references from an employer) as a means of showing what they have achieved during their project/study/task.

3. A refined proposal will be submitted by the student incorporating changes based on the comments made by the tutor. This updated proposal will either be accepted as being suitable or further comments made. The proposal may need to be submitted several times before it is finally accepted.

4. The student will then be expected to carry out the project, study or task.

Progress Reports

The student will be expected to submit three progress reports during the duration of the progress. This is in addition to the final project product (e.g. report, folio). Each progress report should show what you have done so far (e.g. what research you have done, what tasks you have carried out, etc.). It should also cover any problems you have had so far, and if so, what you have done to overcome these problems. Each progress report should be in the vicinity of 300 - 500 words in length.

Progress Report 1.

This should be submitted about one quarter of the way through your study/project/task.

Progress Report 2.

This should be submitted about one half way through your study/project/task.

Progress Report 3.

This should be submitted about three quarters of the way through your study/project/task.

Final Report

This report is to be typed and submitted to the school.

The final report should summarise the objective of the workplace project, and be set out like a professional report.

Although content is the most important factor in determining a pass grade for the workplace project, your report should exhibit elements of professional report writing (in regards to spelling, grammar, clarity and presentation).

Final Report Length

For 100 hours Workplace Projects:

* this report should be about 1,500 to 3,000 words.

For a 200 hour Workplace Project:

* this report should be about 3,000 to 5,000 words.

 

 

Learning Facilities

ACS follows the old fashioned idea that “the student comes first”. Our staff are told to treat every student as an individual and respond promptly to their enquiries; and the facilities we have developed and continue to develop, are all focused on that goal. Facilities include:

  • Offices in two time zones (UK and Australia) –which means an international team of academics are responding to students 5 days a week and 16 hours a day.
  • An online student room with unique resources that are only available to students studying our courses, including online library.
  • Bookshop offering quality downloadable e books
  • A data base of 20 million words of unique information written by our staff over 3 decades that can be drawn upon if needed by academics for use in supporting our students.
  • Systems that ensure assignments are tracked, marked and returned to students, fast -commonly within a round 1 week & rarely more than 2 weeks (note: many other colleges take longer).
  • The school is active in social networking and encourages students to connect with us and each other.
  • No automated handling of student phone enquiries. When you call you get a real person; or leave a message and a real person will call you back within a day, but more commonly within an hour or two.
  • No additional charges for extra tutor support over the phone or email.
  • Free careers advice for graduates –It is our policy to provide support and advice to our students even after they graduate. If a graduate needs help with getting a CV together, or advice on setting up a business or looking for work; they only need ask.
  • The quality of academic staff is higher than many other colleges.

 

 How our Courses Differ

  • Courses are continually improved –we invite feedback from all graduates and change courses immediately the need is detected.
  • Courses are relevant to the whole world –we try hard to teach make the learning transferable to any region or country because the world is increasingly a global economy
  • Courses written by our staff, teach different skills to standard courses; giving a unique mix of skills and knowledge to provide a career advantage. Do you want an accredited certificate and the same skills as 100 other job applicants; or one of our courses with skills that no other applicants have?
  • Certificates and diplomas are longer. They teach you more, and our qualifications have built a reputation amongst academics and industry as being a very high standard for this reason.
  • We are focused on helping you learn in a way that improves your capacity to understand your discipline, apply knowledge, and continue learning and developing your capabilities beyond your course.

These things cannot be always said of other colleges.

 

Career Opportunities

Study alone can never guarantee career success; but a good education is an important starting point.

Success in a career depends upon many things. A course like this is an excellent starting point because it provides a foundation for continued learning, and the means of understanding and dealing with issues you encounter in the workplace.

When you have completed an ACS course, you will have not only learnt about the subject, but you will have been prompted to start networking with experts in the discipline and shown how to approach problems that confront you in this field.

This and every other industry in today’s world is developing in unforeseen ways; and while that is unsettling for anyone who wants to be guaranteed a particular job at the end of a particular course; for others, this rapidly changing career environment is offering new and exciting opportunities almost every month.

If you want to do the best that you can in this industry, you need to recognise that the opportunities that confront you at the end of a course, are probably different to anything that has even been thought of when you commence a course.

 

 

BOOKS

Visit our School bookshop at www.acsebook.com

  • Downloadable ebooks that can be read on ipads, PC’s, Laptops, or readers like a Kindle.
  • Titles are written by our principal and staff.
  • Anyone can purchase books –ACS students are offered a student discount




It's Easy to Enrol

Select a Learning Method

$1,191.00Payment plans available.

Courses can be started at any time from anywhere in the world!

Need Help?

Take advantage of our personalised, expert course counselling service to ensure you're making the best course choices for your situation.