modules - doITlab

crateleftInternet and Web Development

Dec 4, 2013 (3 years and 11 months ago)

85 views

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
1

St Andrew’s Catholic College, Redlynch Valley

INFORMATION TECHNOLOGY COURSE ENROLMENT


VET COURSE ASSESSMENT SUMMARY


STUDENT DETAILS:
Name:

Cohort:





COURSE ENROLLING IN:

ICA40311 CERTIFICATE IV IN WEB
-
BASED TECHNOLOGIES



Design and development


MODULE

COMPETENCIES

RESULT

ASSESSOR/DATE

(completed)

VET CO
-
ORD/DATE

(reports completed)

WORKPLACE

BSBOHS302BParticipate effectively in OHS communication and consultative processes

□ SATISFACTORY □ UNSAT



CLIENTS

ICAICT401ADetermine and confirm client business requirements

ICAICT418A Contribute to copyright, ethics and privacy in an IT environment

ICAWEB414A Design simple web page layouts

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT



DESIGN

ICAWEB409A Develop cascading style sheets

ICAWEB401A Design a website to meet technical requirements

CUFPPM404A Create storyboards

ICAWEB412A Produce interactive web animation

ICAWEB418A Use development software and IT tools to build a basic websi
te

ICAPMG401A Support small scale IT projects

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT



STATIC WEB

ICAWEB402A Confirm accessibility of websites
for people with special needs

ICAWEB429ACreate a markup language document to specification

ICAWEB420A Write content for web pages

ICAWEB411AProduce basic client side script for dynamic web pages

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT


SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT



BUILD DOT
COM

ICAWEB424A Evaluate and select a web hosting service

ICADBS403A Create basic databases

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT



WEB 2.0

ICAWEB403A Transfer content to a website
using commercial packages

ICAWEB415A Produce server side script for dynamic web pages

ICAWEB425A Apply structured query language to extract and manipulate data

ICAICT420A Develop client user interface

ICAPRG405A Automate processes

ICAWEB410A Apply web auth
oring tool to convert client data for websites

ICAPMG401A Support small scale IT projects

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY □ UNSAT

□ SATISFACTORY

□ UNSAT




Course completed
-

Certificate to be issued.









Assessor Signature

Course terminated
-

Statement of Attainment to be issued.








Date

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
2

C
ertificate IV in Web
-
Based Technologies

MODULE: WORKPLACE

ASSESSMENT MATRIX


STUDENT NAME:


NTS Id:

Units of
Competence:

BSBOHS302B

Participate effectively in OHS communication and
consultative processes



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


Job 1





Satisfactory


Unsatisfactory

Job 2





Satisfactory


Unsatisfactory

Job 3





Satisfactory


Unsatisfactory

Job 4





Satisfactory


Unsatisfactory

The final test
-

at 70%+





Satisfactory


Unsatisfactory

Project
-

guidelines for computer use





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY


SUPPORT

1.

Contribute to establishing consultative processes within the workplace



Does support


Does not

2.

Contribute to obtaining and providing
information about OHS issues



Does support


Does not

3.

Raise OHS issues with others



Does support


Does not

Evidence of the following is essential:



Does support


Does not



contribution to consultative arrangements

for managing OHS in a workplace



Does support


Does not



knowledge of relevant OHS legislation, codes of practice, agreements, industry
standards, workplace policies and procedures.



Does support


Does not

The student requires t
he following skills development before reassessment / Feedback to student on overall performance during
assessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of
Assessor: D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
3


RECEIVING AND RESPONDING TO
FEEDBACK CONSTRUCTIVELY

-

Student Self

Checklist


Student:


How do you respond to feedback? Do you:

RESPONSE

YES

DONT
KNOW

NO

Area for

development


Accept and manage your
emotions






Reflect on the feedback





Talk with the feedback giver(s)





Demonstrate your openness




Listen for understanding




Admit ignorance or confusion




Avoid getting defensive.




Admit it when you believe you
were in error, admit it.




Find out what changes on your
part would most help the
feedback giver(s)




Commit yourself to specific
actions by specific dates




Student Signature:


Assessor


after discussion








doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
4



SKILLS EMPLOYERS SEEK

SELF ASSESS
CHECKLIST

Student name:



Source: National Association of Colleges and Employers

Research: Job Outlook Survey 2011

SKILLS

Rate yourself

3 average 5 is best

AREA FOR DEVELOPMENT

Communication Skills

1 2 3 4 5


Teamwork Skills

1 2 3 4 5


Interpersonal Skills

1 2 3 4 5


Analytical Skills

1 2 3 4 5


Computer Skills

1 2 3 4 5


Creativity

1 2

3 4 5


Friendly/Outgoing

1 2 3 4 5


Strong Work Ethic

1 2 3 4 5


Initiative

1 2 3 4 5


Problem
-
Solving Skills

1 2 3 4 5


Flexibility/adaptability

1 2 3 4

5


Technical Skills

1 2 3 4 5


Organizational Skills

1 2 3 4 5


Self
-
confidence

1 2 3 4 5


Tactfulness

1 2 3 4 5


Sense of Humour

1 2 3 4 5


Candidate signature:



Assessor


after discussion












doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
5

CERT IV in WEB BASED TECHNOLOGIES

MODULE: UPGRADE SKILLS

ASSESSMENT MATRIX

STUDENT NAME:


NTS Id:

Units of Competence:

ICAWEB409A

Develop
cascading style sheets



Satisfactory


Unsatisfactory

ICAWEB412A

Produce interactive web animation



Satisfactory


Unsatisfactory

ICAWEB418A

Use development software and IT tools to build a basic website



Satisfactory


Unsatisfactory

ICAWEB411A

Produce basic client side script for dynamic web pages



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


Fully functional tutorial web site





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY


SUPPORT

1 Format, style and lay out the elements on a web page
-
obtain user requirements
-

Style
elements of a web page using a CSS
-

Apply CSS style sheets to multiple pages in a website
-

Position document
elements using CSS



Does support


Does not

2 Test and validate web pages
-

Test website in
various browsers
-

Validate the CSS against
industry standards
-

Report result of tests to
appropriate person



Does support


Does not

Evidence of the ability to:



Does support


Does not



develop a website styled and formatted using CSS to user requirements



Does support


Does not



lay out page elements using CSS



Does support


Does not



test
web pages in a variety of browsers



Does support


Does not



validate the CSS against industry standards.



Does support


Does not

1. Define technical environment
-

business requirements
-

standards required to develop the
site
-

hardware and software required



Does support


Does not


2. Define human computer interface
-

conduct user analysis to determine a user profile and
user needs
-

user content
-

appropriate design principles and OS for the site



Does support



Does not

3. Determine site hierarchy


of pages
-

content is logical
-

navigation between pages is
consistent and clear



Does support


Does not

4. Integrate design components
-

apply appropriate information hierarchy to site
design
-

design principles are appropriate to business and user
-

process flow is developed in a logical
and simple manner
-

test site against user needs
-

complete and document the design structure



Does support


Does not

Evidence of the abi
lity to:



Does support


Does not

Identify and select appropriate tools and procedures required to develop a website



Does support


Does not

analyze user analysis to identify site or design structure required



Does support


Does not

test website meets the standards required by the user profile or needs.



Does support


Does not

1 Analyse project requirements
-

Determine the necessary dynamic functionality of the
animation to be include
d inside web document
-
Determine the appropriate language to
achieve that functionality
-

Determine web document requirements
-

Research and evaluate
current requirements for online advertising with major agencies and websites



Does support


Does

not

2 Design web animations
-

Design web document and animations to enhance the page
-

Design
advertisements to promote the web page within a website
-

Design advertisements to promote
the web page on externally hosted paid advertising
-

Design advert
isements that meet current
website advertising specifications for size, number or loops, sound and buttons
-

Design and
create gif replacements for animation as per major advertising agency requirements
-

Design
animations for a website that will add to th
e overall professionalism or entertainment value of
a website



Does support


Does not

3 Produce animations
-

Produce web animations for web pages
-

Produce web animations for
external advertising
-

Produce web animations for internal website
advertising
-

Produce web
animations for a website that enhance the overall professionalism or entertainment value of
the website
-

Test and debug scripts against required functionality and reiterate until correct



Does support


Does not

4 Publish animations
-

Publish animations in acceptable web format
-

Incorporate web
animations into a hypertext markup language (HTML) page
-

Complete documentation and
submit to appropriate person for approval



Does support


Does not

Eviden
ce of the ability to:



Does support


Does not



design and create interactive animation for advertising, following current industry
standards



Does support


Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
6



design and create interactive animation to enhance the profe
ssionalism or
entertainment value of a website.



Does support


Does not

The student requires the following skills development before reassessment / Feedback to student on overall performance during

assessment:





The candidate has been
provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor: D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
7



SELF
-
MANAGEMENT SKILLS


STUDENT
SELF
-
CHECKLIST

Student name:



Th
e self management skills required for an employee to be more productive

are important. T
h
e listed
skills
are those needed to
develop
all the necessary abilities for self
-
organization.

SKILLS

Good

OK

AREA FOR DEVELOPMENT

SELF MANANGEMENT SKILLS

Stress
-
Resistance

The first and foremost skill of self
-
management refers to a personal
ability to resist any stressful situations. When you develop this self
management skill, you can avoid many mistakes that people usually
make
when being stressed out. Because a stressful situation usually
blocks our ability to think and make rational decisions, we can’t cope
even with the simplest tasks at our workplace, so our productivity
goes down and we get frustrated. That’s why you need to

develop this
ability in order to be a productive employee able to offer resistance to
a stressful situation.




Problem
Solving

The second self
-
management skill requires you to use your brain as a
mechanism for making right decisions. Even the hardest ta
sks and
challenges can be efficiently handled if the mental process in your
head is always in progress. Problem solving requires you to operate
facts and make right assumptions to analyze the situation, review
problems, and find effective solutions. Keepin
g your mind sober
allows you to take right decisions even in the toughest situations




Communication

The way how you can communicate information to others will
determine your success. Communication is one of the
key self
-
management skills

required for
both personal development and
career advancement. Being able to efficient communicate any
information to other people means that you can share information
with the minimized possible distortion and in the fastest possible way.
Productive employees always c
an efficiently communicate with their
colleagues and management because they comprehensively
understand the value of clearly and timely delivered information. So
be sure you work on developing this skill for self
-
management.




Time
Management

Producing e
xpected results in a timely manner defines the success of
our effort. Time management is an extremely important self
-
management skill that makes an employee be more productive.
There’re a great variety of time management techniques that show
you how to dev
elop this skill for self
-
management. Just use the web
search to find plenty of them.





Memory

An ability to memorize events, names, facts, etc., allows an employee
to remember about everything he/she needs to do daily tasks and
duties. Among other
self
-
management skills examples
, committing to
memory requires your personal effort for developing your mind
abilities. There’re a lot of techniques for improving memory, so use
the web search to find them.




Student

signature:



Assessor


after
discussion








doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
8



ANIMATION CHECKLIST

Student



The animator must have a sense of what makes an inanimate character alive.

The principles that must be applied
in the folio of animations
are:


S

NYS

Fixes

Timing





Ease In and Out

(or Slow In and

Out)




3. Arcs





4. Anticipation





5. Exaggeration





6. Squash and

Stretch




7. Secondary Action




8. Follow Through

and Overlapping Action




9. Straight Ahead and Pose
-
To
-
Pose Action




10. Staging





11. Appeal





12. Personality





Yet

The student requires the following skills development before reassessment:




Feedback to student on overall performance during assessment:




Candidate signature



Assessor








doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
9

CERT
IV

in WEB BASED TECHNOLOGIES

MODULE:

STATIC WEBSITE

ASSESSMENT MATRIX

STUDENT NAME:


NTS Id:

Units of Competence:

ICAWEB418A

Use development software and IT tools to build
a basic website



Satisfactory□ Unsatisfactory

ICAWEB402A

Confirm accessibility of websites for people with special needs



Satisfactory□ Unsatisfactory

ICAWEB429A

Create a markup language document to specification



Satisfactory□ Unsatisfactory

I
CAWEB420A

Write content for web pages



Satisfactory□ Unsatisfactory

ICAPMG401A

Support small scale IT projects



Satisfactory□ Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


3
-

PRAC: Trends in 2010





Satisfactory□ Unsatisfactory

4
-

PRAC Trends in 2011





Satisfactory□ Unsatisfactory

5
-

TEST: Social media terms





Satisfactory□ Unsatisfactory

6
-

PRAC: Government regulations





Satisfactory□ Unsatisfactory

7
-

PRAC: The basic technologies





Satisfactory□ Unsatisfactory

8
-

PRAC: Web 2.0 technologies





Satisfactory□ Unsatisfactory

9
-

PRAC: A sample companies web services





Satisfactory□ Unsatisfactory

10
-

PRAC: Sample report of a bad web site ... report 1





Satisfactory□ Unsatisfactory

11
-

PROJ: Review a web site





Satisfactory□ Unsatisfactory

MAJOR PROJECT
-

BUILD CLIENT WEB SITE





Satisfactory□ Unsatisfactory

13
-

The client





Satisfactory□ Unsatisfactory

14
-

Design the web site





Satisfactory□ Unsatisfactory

15
-

Build the web site
-

upload to server





Satisfactory□ Unsatisfactory

16
-

Test the web site





Satisfactory□ Unsatisfactory

17
-

Review and maint
ain the web site





Satisfactory□ Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY

ICAWEB418A

Use development software and IT tools to build a basic website

SUPPORT

1 Select and analyse website structure and development tools
-


Analyse
business
specification and select appropriate software
-

Identify technical needs for the website and
select appropriate software tools
-

Identify site structure and navigation flow and demonstrate
understanding of functionality
-

Review design documentati
on and integrate design work with
site structure and navigation, according to web development standards



Does support

Does not

2 Begin site construction
-

Take action to ensure user input during website construction
-

Validate existing information and

basic content when incorporating data on website
-

Apply
consistent design specifications to all aspects of the website
-

Gather feedback from user on
web design, content, accessibility and structure, using appropriate feedback mechanism



Does support

Does not

3 Complete and validate website construction and content
-

Undertake an evaluation of the
website against technical requirements and design specification
-

Test each function and
process of the website
-

Conduct navigation tests and hypertext ma
rkup language
-

(HTML)
compliance with website standards
-

Stress test the website to meet design criteria and user
load
-

Record testing results to ensure website meets user requirements
-

Obtain sign
-
off and
approval of user



Does support

Does not



build a basic website to website specifications



Does support

Does not



undertake and audit against the business requirements and design needs prior to
task completion and sign
-
off



Does support

Does not

ICAPMG401A

Support small scale IT projec
ts



Does support

Does not

1 Support project commencement
-

Confirm business opportunity to ensure the project
objectives are understood
-

Identify stakeholders and gather requirements
-

Prepare a project
charter or project proposal and obtain agreemen
t from project sponsor



Does support

Does not

2 Support project plan development
-

Break down the requirements to identify tasks and
resources needed to complete the project plan
-

Compile a schedule of project tasks, including
realistic timeframes an
d costs if required
-

Allocate task responsibilities to project team
members
-

Agree on a process with the sponsor to manage risks or unexpected events that
may arise and affect project objectives or expectations



Does support

Does not

3 Support proje
ct completion
-

Work with project team to ensure project activities meet
timeframe, scope, cost and quality expectations
-

-

Verify that project deliverables meet


Does support

Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
10

project expectations and sign off as complete
-

Train users if applicable

4 Support project closure
-

Prepare IT support or maintenance documents if applicable
-


Obtain
final project sign
-
off from sponsor and key stakeholders
-

Document lessons learned and close
the project



Does support

Does not



support the i
nitiation, control and completion of a simple small
-
scale IT project



Does support

Does not



identify and apply requirements and expectations of a project.



Does support

Does not

ICAWEB402A

Confirm accessibility of websites for people with
special needs



Does support

Does not

1.Identify accessibility standards
-

research and identify specific user groups with particular
accessibility requirements
-

identify general legislated and industry accessibility standards and
requirements

Identi
fy standards
-

consolidate specific and general standards into an
accessibility checklist for application to website
-
related work



Does support

Does not

2. Test for website accessibility


Select appropriate automatic testing tools
-

run testing tools

and make document changes based on results
-

verify that information conveyed with colour is
also available without colour
-

identify changes in the natural language of a document text
-

check identified in the analysis of web development standards are m
et
-

test site with
different user groups to maintains accessibility



Does support

Does not

3. Test pages
-

check and ensure that pages are not dependent on colour and can operate in a
monochrome environment
-

check and ensure that pages are logical
and accessible in a text
-
only environment
-

verify that pages operate on text
-
to
-
speech browser
-

ensure that
accessibility of website meets web
-
development standards



Does support

Does not

Test a website for accessibility



Does support

Does not

Demonstrate theoretical knowledge of website content creation



Does support

Does not

communicate and negotiate with user groups, government and industry



Does support

Does not

ICAWEB420A

Write content for web pages



Does support

Does not

1 P
repare to develop content for site
-

Identify customer information needs with reference to
audience, site functionality and client requirements
-

Confirm site purpose and functionality
with reference to client specification
-

Select content and format as p
art of client requirements
-

Obtain templates and style guides
-

Identify content and analyse with reference to audience
needs, maintenance requirements, information architecture, and site design and functionality
-

Negotiate alterations to site design, as

required by the content and client requirements



Does support

Does not

2 Write site content
-

Create content according to content and client requirements
-

Establish
that content is easily and conveniently accessible and visible and that information
is clear,
understandable and logical
-

Edit content with reference to audience needs, site functionality,
content and client requirements



Does support

Does not

3 Upload content
-

Log into server site using either administrative or anonymous file tran
sfer
protocol in preparation for upload
-

Launch transfer file transfer protocol (FTP) client Store and
order files according to logical design and user needs, using accepted file extension scheme
-

Demonstrate operation in closed contention mode



Does support □Does not



write in a manner that recognises cultural differences, diversity and people with
special needs



Does support

Does not



demonstrate some knowledge of website content creation



Does support

Does not



develop and uplo
ad quality content for a website.



Does support

Does not

ICAWEB429A

Create a markup language document to specification



Does support

Does not

1 Analyse specifications and requirements
-

Determine uses and audience of the document
-

Determine appr
opriate markup language based on document uses and audience and current
industry best practice
-

Determine document structure



Does support

Does not

2 Create document structure
-

Create and assign basic elements of the document, taking into
account ac
cessibility
-

Mark up sections of the document to describe the structure



Does support

Does not

3 Incorporate web page components
-

Identify web page components
-

Evaluate suitable web
page components
-

Include required web page components



Does support

Does not

4 Validate documents
-


Validate markup language document against specifications and
record outcomes
-

Validate markup language document in different browsers for compatibility
and record outcomes



Does support

Does not



de
sign, create and save a markup language document using a markup language
without the automated generation of code.



Does support

Does not

The student requires the following skills development before reassessment / Feedback to student on overall
performance during
assessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor: Date:



doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
11

CERT

IV in WEB BASED TECHNOLOGIES

MODULE: BUILD DOT COM

ASSESSMENT MATRIX


STUDENT NAME:


NTS Id:

Units of Competence:

ICAWEB424A

Evaluate and select a web hosting service



Satisfactory


Unsatisfactory

ICADBS403A

Create basic databases



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check



Signing up with a hosting service





Satisfactory


Unsatisfactory


Setting up Joomla





Satisfactory


Unsatisfactory


Using Joomla





Satisfactory


Unsatisfactory


Setting up a forum





Satisfactory


Unsatisfactory


Finishing touches





Satisfactory


Unsatisfactory


Using C
-
panel





Satisfactory


Unsatisfactory

Prac questions





Satisfactory


Unsatisfactory

Prac log





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY

Select ISP

SUPPORT

Ensure guarantee of permanent online presence



Does support

Does not

Ensure that web host meets technical requirements



Does support

Does not

Benchmark performance and test against specified criteria



Does support

Does not

Analyse requirements for the database



Does support

Does not

Use data modelling to design the database to suit requirements



Does support

Does not

Create a da
tabase on a web or database server



Does support

Does not

Test database and debug



Does support

Does not

The student requires the following skills development before reassessment / Feedback to student on overall performance during

assessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor: D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
12

CERT IV in WEB BASED TECHNOLOGIES

MODULE: WEB 2.0
-

APPLICATIONS

ASSESSMENT MATRIX

STUDENT NAME:


NTS Id:

Units of Competence:

ICAWEB403A

Transfer content to a website using commercial packages



Satisfactory


Unsatisfactory

ICAWEB425A

Apply structured query language to extract and
manipulate data



Satisfactory


Unsatisfactory

ICAICT420A

Develop client user interface



Satisfactory


Unsatisfactory

ICAPRG405A

Automate processes



Satisfactory


Unsatisfactory

ICADBS403A

Create basic databases



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


Prac 2: Joomla





Satisfactory


Unsatisfactory

Prac 3: PHP BB





Satisfactory


Unsatisfactory

Prac 4: wiki





Satisfactory


Unsatisfactory

PROJ 1:build 'n script: a blog





Satisfactory


Unsatisfactory

PROJ 2:build 'n script: an image gallery





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY

ICAWEB403A

Transfer content to a website using commercial packages

SUPPORT

1 Configure the file transfer protocol
client
-

review and select FTP client
-

ensure that FTP is
suitable for the technical environment
-

including user ID, password and host name or ID


use
settings such as auto
-
detect, save profile and password depending on organisational security
and priv
acy policy and organisational guidelines


test and verify configuration by connecting
to the web hosting server



Does support

Does not

2 Plan and prepare for data transfer


prepare data content and back it up
-

identify data as
compressed or uncompr
essed with tools available on the server to manage uploaded data
-

ensure files are in appropriate
-

receiving directory structure is applicable for the data to be
uploaded



Does support

Does not

3 Establish connection to server
-

log on to remote
server
-

proceed through security layers
-

initiate FTP and locate destination directory



Does support

Does not

4 Transfer data to remote server


select files to be transferred and choose mode
-

run
antivirus software on downloaded files
-

move, ren
ame, copy, and delete files on the server
-

store files
-

account for decompression or de
-
archival of the files for use



Does support

Does not

Evidence of the ability to:



Does support

Does not



configure an FTP client



Does support

Does not



prepare content to be transferred



Does support

Does not



connect to the server



Does support

Does not

• t
ransfer content



Does support

Does not

ICAWEB425A

Apply structured query language to extract and manipulate data



Does support

Does not

1 Identify SQL requirements from the specification documentation
-

Determine information to
be used from database
-

Identify tables that hold this information
-

Identify primary keys in
these tables
-

Identify relationships betwe
en these tables, including foreign keys



Does support

Does not

2 Create a relational database
-

Create tables in a database using SQL statements
-

Identify
primary and foreign keys for database table
-

Manipulate data in a database using SQL
statement
s
-

Query the database using SQL statements
-

Write SQL statements to retrieve
information from database



Does support

Does not

3 Test SQL results
-

Construct test data to test SQL statements
-


Construct expected
results to verify SQL statements
-

V
erify result of the constructed SQL statements against
expected results



Does support

Does not

Evidence of the ability to use SQL to:



Does support

Does not



create databases and tables



Does support

Does not



query one or more tables to
provide required data



Does support

Does not



add, modify and delete records from tables



Does support

Does not



drop databases and tables.



Does support

Does not

ICAICT420A

Develop client user interface



Does support

Does not

1 Prepare design for interface
-

Review requirements and other documentation to determine
user needs
-

Investigate system environment to determine the impact of user interface design
-



Does support

Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
13

Review organisational goals to ensure consistency with organisational s
tyles
-

Define data
query and report formats for the user interface design where appropriate
-

Document needs
and findings and obtain approval for the proposed interface from the appropriate person

2 Design and document user int
erface
-


Design menu structures according to
requirements and



Does support

Does not

acceptance criteria and following design principles
-

Design screen dialogues according to
requirements and acceptance criteria and following design principles
-

Des
ign batch
procedures where appropriate to technical specifications and acceptance criteria
-

Design
online help and tutorials for the prototype following design principles
-

Document prototype
according to organisational goals
-

Submit prototype to appropr
iate person for sign
-
off



Does support

Does not

Evidence of the ability to:



Does support

Does not



determine impact of user interface design in the system environment and identify
appropriate data query and report formats



Does support

Does not



design menu structures according to design principles



Does support

Does not



design screen dialogues in line with requirements and acceptance criteria



Does support

Does not



design batch procedures



Does support

Does not



d
evelop online help and tutorials for prototype.



Does support

Does not

ICAPRG405A

Automate processes



Does support

Does not

1 Develop algorithms to represent solution to a given problem
-


Develop an algorithm
which is an exact and sufficient des
cription of the solution
-

Develop an algorithm which takes
account of all expected possible situations
-

Develop an algorithm which is guaranteed to end



Does support

Does not

2 Describe structures of algorithms
-

Demonstrate use of structure, sequen
ce, selection and
iteration
-

Use structures to describe algorithmic solutions to a problem



Does support

Does not

3 Design and write script or code
-

Create an abstract design to fulfil the requirements of the
proposed process
-

Review the abstract
design for omissions or errors
-

Translate the abstract
design to the chosen language
-

Create internal documentation



Does support

Does not

4 Verify and review script or code
-

Check the script or code for syntax and semantic errors
-

Identify areas
that are not covered or are covered incorrectly in the script or code



Does support

Does not

5 Document script or code
-

Create technical
-
level documentation
-

create user
-
level
documentation



Does support

Does not

Evidence of the ability to:



Does support

Does not



develop an algorithmic statement of a solution for a set process



Does support

Does not



produce a functional script to automate a set process



Does support

Does not



document this script both internally and externa
lly.



Does support

Does not

ICADBS403A

Create basic databases



Does support

Does not

1 Analyse requirements for the database
-

Determine the information that the database is
required to hold
-

Develop a written requirement report for the
functionality of the database
-

Complete documentation and submit to appropriate person for approval



Does support

Does not

2 Use data modelling to design the database to suit requirements
-

Design an entity
-
relationship (ER) diagram to model the rel
ationships between the entities and attributes the
database will hold
-

Develop the primary and foreign keys to link the entities
-

Develop a data
dictionary
-

Complete documentation and submit to appropriate person for approval



Does support

Does not

3 Create a database on a web or database server
-

Use the appropriate language on a web or
database server to create one or more databases
-

Use the appropriate language on a web or
database server to create tables
-

Populate the database fields



Does support

Does not

4 Test database and debug
-

Test the database on the web or database server
-

Ensure that the
information represented matches the requirements



Does support

Does not

Evidence of the ability to:



Does support

Does not



research client requirements for a database solution



Does support

Does not



design a database that meets client requirements



Does support

Does not



create a database on a web hosting service to meet client requirements by a due
date.



Does support

Does not

The student requires the following skills development before reassessment / Feedback to student on overall performance during

assessment:





The candidate has been provided with feedback and informed of the assessment result an
d the reasons for the decision.

Signature of Assessor: D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
14



Certificate III
/
IV


WEB APPLICATION

ROBUSTNESS CHARACTERISTICS

Assessor Checklist


Student:


Robustness
is one of the most important qualities of any application, is also one of the most difficult to achieve.
This
list
has
the FOUR
principal characteristics
that must be met for an application to be
considered robust.

Application APPROPRIATE key areas need to

be included in any individual application.

CHARACTERISTIC

KEY AREAS TO LOOK FOR

S

NYS

FIXES IF NYS

Transactions

F
rameworks usually try to abstract the access to
the underlying database of the application, while
this is certainly good, is also causing an

increasing
lack of understanding of what is happening behind
the scenes. Being able to explain what is the SQL
likely to be executed by your framework, and
when is going to be executed will help you to
create better database access code, and to
optimize t
he database access, especially if you
don’t have a DBA in your project. Some key areas
to look for:

Transaction modes.




Transaction frameworks
and APIs



Database access

Frameworks usually try to abstract the access to
the underlying database of the

application, while
this is certainly good, is also causing an increasing
lack of understanding of what is happening behind
the scenes. Being able to explain what is the SQL
likely to be executed by your framework, and
when is going to be executed will hel
p you to
create better database access code, and to
optimize the database access, especially if you
don’t have a DBA in your project. Some key areas
to look for:

SQL




Indexes



Lazy loading.



ORM frameworks and
APIs



Caching



Multithreading

Multithreading is the next big thing in software
development, is been there now for ages, but with
the new hardware architectures going multi
-
core,
multithreading is emerging as the new must
-
know
skill. It is also critical to acknowledge tha
t your
code is probably already running in a
multithreading platform so you need to consider it
to prevent your code to fail. Some key areas to
look for:

Stateless services




Unmodifiable beans



Race conditions



Locks



Logging and auditing

Logging and auditing are one of the most
underrated qualities of an application, especially
for server applications. Is easy to forget in
development how useful a log is when the
application has already been rolled into
production. Some key areas to look f
or:

Consistent identifiers.




Consistent format



Completion: It should be
possible to track a thread




Student Feedback:



Assessors
:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
15


Certificate III
/
IV


WEB APPLICATION

GOOD PHO HABITS / STANDARDS

Assessor Checklist


Student:



Good habits are the firm foundation upon which you can add more OO habits and build software that is easily maintained
and extended. These habits target characteristics
and
modularity.

Bad habit usage is unsatisfactory.

CHARACTERISTIC

ASSES:
Good/Bad

S

NYS

FIXES

Be modest


Be modest is to avoid exposing
yourself in your implementations
of classes and functions.

Bad habit: Expose
public fields




Good habit: Use
public
accessors

Be a good neighbour

A class should handle its own
errors appropriately. If the class
doesn't know how to handle the
errors, it should package them in a
format that its caller understands.

Bad habit: Not
handling errors




Good habit: Each
module handles its
own errors

Avoid looking at Medusa

Be specific, concrete
implementation, your code must
change if your implementation
code changes.

Bad habit: Not using
interfaces




Good habit: Use
interfaces

E
mbrace the weakest link

Loosely
coupling

your modules
is a good thing; it's one of the
properties that allows you to
encapsulate change.

Bad habit: Tight
coupling




Good habit: Loose
coupling between
objects

You're rubber
; I'm glue

Highly cohesive OO designs are
focused and
organized in related
modules
-

"concerns" is important
in determining how to organize
functions and classes to be tightly
cohesive.

Bad habit: Low
cohesion




Good habit: Embrace
high cohesion

Keep it in the family

W
ith good design, copying code is
completely unnecessary.

Bad habit: Not using
class hierarchies




Good habit: Leverage
inheritance

Think in patterns

Design patterns are common
interactions of objects and
methods that have been proven
over time to resolve certain
problems


Bad
habit: Consider
one object at a time





Good habit: Adding
objects, in concert,
composed in
patterns


Student Feedback:



Assessor
:







doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
16

CERT IV in WEB BASED
TECHNOLOGIES

MODULE: CLIENT
-

WEB 2.0


INTEGRATED PROJECT PART 1

ASSESSMENT MATRIX

STUDENT NAME:


NTS Id:

Units of Competence:

ICAICT401A

Determine and confirm client business requirements



Satisfactory


Unsatisfactory

ICAICT418A

Contribute to

copyright, ethics and privacy in an IT environment



Satisfactory


Unsatisfactory

ICAWEB414A

Design simple web page layouts



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


Client interview





Satisfactory


Unsatisfactory

Design page layouts





Satisfactory


Unsatisfactory

Code of ethics statement





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY


SUPPORT

ICAICT401A

Determine and confirm
client business requirements



Does support


Does not

1 Determine context of business need or problem
-

Establish the business problem to be
investigated, including determining system boundaries, scope and the development
methodology to be use
d
-

Choose information
-
gathering method and develop questions
appropriate to business problem
-

Develop objectives and identify expected outcomes to be
achieved
-

Document the business problem
-

Submit documentation to appropriate person for
substantiation



Does support


Does not

2 Gather information
-

Use chosen information
-
gathering method to identify clients of the
system and problems they encounter
-


Record client responses
-

Analyse gathered information
to identify new system
requirements and establish problem specifications
-

Document system
requirements and problems
-

Analyse physical requirements and identify changes required to
implement new systems



Does support


Does not

3 Confirm system specifications
-

Che
ck documentation to ensure it meets client business
needs
-

Submit documentation to the client for verification of accuracy and approval
-

Make
changes to the documentation as necessary and indicated by the client
-

Submit
documentation to client for final

approval or sign
-
off



Does support


Does not

Evidence of the ability to:



Does support


Does not



use investigative techniques to interview and document



Does support


Does not



produce a clear statement of
business expectations and needs, including critical
business requirements.



Does support


Does not

ICAICT418A

Contribute to copyright, ethics and privacy in an IT environment



Does support


Does not

1 Protect intellectual proper
ty
-


Identify current legislation and standards relating to
intellectual property and copyright
-

Investigate current organisational copyright policy
-

Adhere to organisational policy and current legislation in work practices



Does support


Does

not

2 Contribute to copyright policy
-

Contribute to the creation or updating of the organisation's
copyright policy and procedures to align with legislation and industry standards
-

Distribute
new or revised policy and procedures to stakeholders



Does support


Does not

3 Protect rights of stakeholders
-

Identify and document the relevance of legislation and
standards to organisational outcomes
-

Investigate and review organisational privacy policy
and procedures
-

Investigate and revi
ew organisational code of ethics
-

Determine the
integrity, confidentiality, security and availability of information as required by organisational
policy
-

Maintain confidentiality and proprietary rights of stakeholder interests



Does support


D
oes not

4 Contribute to privacy policy
-

Contribute to the creation or updating of the organisational
privacy policy and procedures to align with privacy legislation
-

Distribute new or revised policy
and procedures to stakeholders
-

Implement new work

procedures and collect feedback from
stakeholders
-

Ensure the integrity, confidentiality, security and availability of information as
required by organisational policy



Does support


Does not

5 Maintain privacy policy
-

Review work practice
s to ensure application of privacy policy and
procedures
-

Maintain the integrity, confidentiality, and availability of information as required
by organisational privacy policy
-

Review work practices to ensure system security according to
organisational p
rivacy policy



Does support


Does not

6 Contribute to creation of ethics code
-

Assist in developing or updating a code of ethics to
align with legislation and standards for the organization
-

Distribute the new ethics code to


Does support


Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
17

stakeholders
and collect feedback
-

Implement new ethical work procedures and collect
feedback
-

Review ethical work practices and feedback to ensure application of the code

7 Maintain ethics code
-

Perform regular checks to ensure
stakeholders understand and are
continuing to apply the code of ethics in the workplace
-

Establish a review and grievance
procedure to enable confidential reporting of any ethical issues
-

Interview and regularly follow
up with stakeholders to ensure they

are receiving consistent and appropriate service in dealing
with the code of ethics



Does support


Does not

Evidence of the ability to:



Does support


Does not



analyse legislation and standards relating to professional conduc
t and privacy in the
IT industry



Does support


Does not



contribute to the development of a code of ethics and monitor the workplace to
ensure code of ethics is being applied and is appropriate



Does support


Does not



contribute to the development of a privacy policy and monitor the workplace to
ensure the policy is being applied and is appropriate.



Does support


Does not

ICAWEB414A

Design simple web page layouts



Does support


Does not

1 Id
entify main layout sections from design specification
-

Identify required sections of the web
page
-

Create web page structure



Does support


Does not

2 Lay out web page to match design specification
-

Position document elements
-

2.2

Style
w
eb page elements to match design specifications



Does support


Does not

3 Test and validate layout
-

Test website in various browsers
-

Validate web pages against
industry standards



Does support


Does not

Evidence of the abilit
y to:



Does support


Does not



develop a website according to design specifications



Does support


Does not



lay out page elements



Does support


Does not



test web pages in a variety of browsers



Does support


Does not



validate the web pages against industry standards.



Does support


Does not

The student requires the following skills development before reassessment / Feedback to student on overall performance during

as
sessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor: D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
18


CLIE
NT DESIGN BRIEF ASSESSMENT TOOL

Student name:




A creative or design brief is your road map for the project. Write a Design Brief for the e
-
product

WHAT THE BUSINESS DOES

S

NYS

Feedback

The company / organisation activity (what it does) is
detailed




The company’s history


overview stated




THE GOALS OF THE ORGANISATION
-

WHY




The overall goals of the new design project are clearly listed




A clear statement of what is to be communicate in the design
-

and why




Clear differentiation between products and services




Clear differentiation between just increasing awareness of and/or selling




A clear statement of how the organisation differs from its competitors




Clear differentiation between completely
reinvent yourself and simply updating
promotional material




THE TARGET MARKET





Clear, detailed information about the target market’s demographics: the age,
gender, income, employment, and geography of those to reach.




Clear, detailed information
about the target market’s psychographics: tastes,
views, attitudes, lifestyle of those to reach.




COPY (TEXT) AND PICTURES GIVEN / REQUIRED




Inclusion, listing of copy required and who is providing the copy




Inclusion, listing of what pictures / p
hotographs / diagrams etc are to be used
and who is providing them




THE SPECIFICATIONS




The size of the design is defined




Clear statement of where the product will be printed / used: web, business
cards, stationery, on a car




Any other
information the designer should know in regards to specifications




THE PROJECT BENCHMARK




Some clear examples of what is consider to be effective or relevant to the design
(probably from the main competitors)




Provides things not to do, and style
s not liked




THE BUDGET




Provides a budget that prevents wasting time and resources




THE TIME SCALE / DEADLINE




Details a schedule for the project and sets a realistic deadline for the completion
of the work.





The student requires the following skills development before reassessment:



Feedback to student on overall performance during
assessment:




Candidate signature:


Assessor







doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
19

CERT IV in WEB BASED TECHNOLOGIES

MODULE: DESIGN


WEB 2.0


INTEGRATED PROJECT PART 2

ASSESSMENT MATRIX

STUDENT NAME:


NTS

Id:

Units of Competence:

ICAWEB409A

Develop cascading style sheets



Satisfactory


Unsatisfactory

ICAWEB401A

Design a website to meet technical requirements



Satisfactory


Unsatisfactory

CUFPPM404A

Create storyboards



Satisfactory


Unsatisfactory

ICAWEB412A

Produce interactive web animation



Satisfactory


Unsatisfactory

ICAWEB418A

Use development software and IT tools to build a basic website



Satisfactory


Unsatisfactory

ICAPMG401A

Support small scale IT projec
ts



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


Developed cascading style sheets





Satisfactory


Unsatisfactory

Design to meet technical requirements
-

the test
documentation to be done





Satisfactory


Unsatisfactory

Create storyboard
-

of the shopping cart experience from the
customer POV





Satisfactory


Unsatisfactory

Design interactive web animation





Satisfactory


Unsatisfactory

How the project will be
supported
-

time planning and check
points.





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY

ICAWEB409A Develop cascading style sheets

SUPPORT

1 Format, style and lay out the elements on a web page
-
obtain user
requirements
-

Style
elements of a web page using a CSS
-

Apply CSS style sheets to multiple pages in a website
-

Position document elements using CSS



Does support


Does not

2 Test and validate web pages
-

Test website in
various browsers
-

Validate the CSS against
industry standards
-

Report result of tests to
appropriate person



Does support


Does not

Evidence of the ability to:



Does support


Does not



develop a website styled and formatted using CSS to user
requirements



Does support


Does not



lay out page elements using CSS



Does support


Does not



test web pages in a variety of browsers



Does support


Does not



validate the CSS against industry standards.



Does support


Does not

ICAWEB401A

Design a website to meet technical requirements



Does support


Does not

1. Define technical environment
-

business requirements
-

standards required to develop the
site
-

hardware and software r
equired



Does support


Does not


2. Define human computer interface
-

conduct user analysis to determine a user profile and
user needs
-

user content
-

appropriate design principles and OS for the site



Does support


Does not

3. Determine site hierarchy


of pages
-

content is logical
-

navigation between pages is
consistent and clear



Does support


Does not

4. Integrate design components
-

apply appropriate information hierarchy to site design
-

design principles

are appropriate to business and user
-

process flow is developed in a logical
and simple manner
-

test site against user needs
-

complete and document the design structure



Does support


Does not

Evidence of the ability to:



Does support



Does not

Identify and select appropriate tools and procedures required to develop a website



Does support


Does not

analyze user analysis to identify site or design structure required



Does support


Does not

test

website meets the standards required by the user profile or needs.



Does support


Does not

CUFPPM404A Create storyboards



Does support


Does not

ICAWEB412A

Produce interactive web animation



Does support


Does not

1 Analyse project requirements
-

Determine the necessary dynamic functionality of the
animation to be included inside web document
-
Determine the appropriate language to
achieve that functionality
-

Determine web document requirements
-

Research and evalu
ate
current requirements for online advertising with major agencies and websites



Does support


Does not

2 Design web animations
-

Design web document and animations to enhance the page
-

Design
advertisements to promote the web page within a

website
-

Design advertisements to promote
the web page on externally hosted paid advertising
-

Design advertisements that meet current
website advertising specifications for size, number or loops, sound and buttons
-

Design and
create gif replacements fo
r animation as per major advertising agency requirements
-

Design


Does support


Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
20

animations for a website that will add to the overall professionalism or entertainment value of
a website

3 Produce animations
-

Produce web animations
for web pages
-

Produce web animations for
external advertising
-

Produce web animations for internal website advertising
-

Produce web
animations for a website that enhance the overall professionalism or entertainment value of
the website
-

Test and debug

scripts against required functionality and reiterate until correct



Does support


Does not

4 Publish animations
-

Publish animations in acceptable web format
-

Incorporate web
animations into a hypertext markup language (HTML) page
-

Complet
e documentation and
submit to appropriate person for approval



Does support


Does not

Evidence of the ability to:



Does support


Does not



design and create interactive animation for advertising, following current industry
standards



Does support


Does not



design and create interactive animation to enhance the professionalism or
entertainment value of a website.



Does support


Does not

The student requires the following skills development before

reassessment / Feedback to student on overall performance during
assessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor:

D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
21


Cert III/IV in IT


WEB SITE

ASSESSORS Checklist

Student


WEB DESIGN CRITERIA

Meets

standard

Fixes

1. NAVIGATION

Navigation options are clearly marked and self
-
explanatory



S


NYS


Links to other pages and back to home page are functional



S


NYS

All links work



S


NYS

L
inks to other sites are relevant



S


NYS

2. EASE OF USE

Users can navigate without difficulty



S


NYS


Users can locate needed
information easily



S


NYS

Help features are available and easy to access



S


NYS

Download speed is acceptable



S


NYS

3. CRAP PRINCIPLES

Contrast

colours support readability and understanding, headings
and subheadings help with
navigation



S


NYS


Repetition


page design is consistent for all pages



S


NYS

Alignment


page design helps users read the content



S


NYS

Proximity


related items are close to each other, information is easy
to find



S


NYS

4. AUDIENCE APPEAL AND SUITABILITY

Text is readable and in an appropriate font for the intended
audience



S


NYS


Media elements enhance the content



S


NYS

Advertising does not interfere with content



S


NYS

The site invites the user

to explore



S


NYS


Student Feedback:



Assessors
:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
22



VISUAL LANGUAGE COMMUNICATION

ASSESSORS CHECKLIST

Student name:



The concept of visible language refers
to all the graphical techniques used to communicate the message or content.


STANARDS

Meets
standard

Fixes

Are the following visual communication elements successfully applied
?

Layout:

formats, proportions, and grids


two
-
dimensional and three
-
dimensional


organization.



S


NYS


Typography:

selection of typefaces
-
vari
able
-
width sans
-
serif



/ serif fonts


fixed
-
width fonts found on most computer



displays.



S


NYS


Colour

/
texture: colour, texture
s

that convey information


/
pictorial reality



S


NYS


Imag
ery:

signs, icons, and symbols,
-

fr
om real to the



abstract.



S


NYS


Animation:

dynamic or kinetic display

-


video
-
related



imagery.



S


NYS


Sequencing:

the overall approach to visual storytelling.



S


NYS


Sound:

abstract, vocal,
musical cues

"earcons".



S


NYS


Visual identity:

unique rules


overall consistency to a user interface.



S


NYS



The student requires the following skills development before reassessment:




Feedback to student on overall performance during assessment:




Candidate
signature:



Assessor








doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
23



HTML CODING ASSESSMENT TOOL

Student name:



TASK:

Construct the base Contact Us page using only HTML coding

SUBMIT:

You need to submit: The page in web format and a notepad print of your code.

The coding must meet the following standards:

S

NYS

Feedback

Names of HTML files should always end with the ".html" extension




Command tags should be completely capitalized,

in order for the tags to stand
out better from the surrounding text



"HREF=" fields in anchor tags should always be enclosed in quotes



Coding a URL which does not specify a specific file name, always end the URL
with a front slash (some browsers
choke if you don't do this)



Uses logical formatting tags instead of physical formatting tags
--
let the client's
browser figure out the best way for the information to be displayed



Includes a <HTML> tag at the very beginning and a </HTML> tag at the
very end
of your HTML documents



Uses the <HEAD> and </HEAD> tags to define a header section in your HTML
documents



Includes a LINK with REV="MADE" in the header section of your HTML
documents identifying you as the author



Gives your documents a title by using the <TITLE> and </TITLE> tags in the
header section of your HTML documents



Uses the <BODY> and </BODY> tags to define the body in your HTML
documents, which is everything in your document between the <HTML> and
<
/HTML> that isn't contained in your header section



Uses the horizontal line tag <HR> to place a horizontal line beneath any
prominent headers in your documents to help them stand out from the
surrounding information



"Signs" any HTML documents that

you create by including a horizontal line and a
link to your homepage (using the ADDRESS style) at the very bottom



Other specifications:

REQUIREMENT: Meets design document specifications




REQUIREMENT: CSS is applied and is consistent with other
pages



REQUIREMENT: Includes the necessary contact information: business name,
email, phone, fax, address



THE
CODING


The student requires the following skills development before reassessment:


Feedback to student on overall performance during assessment:


Candidate signature:


Assessor







doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
24

CERT IV in WEB BASED TECHNOLOGIES

MODULE: WEB 2.0


INTEGRATED PROJECT PART 3

ASSESSMENT MATRIX

STUDENT NAME:


NTS Id:

Units of Competence:

ICAWEB403A

Transfer content to a website using commercial packages



Satisfactory


Unsatisfactory

ICAWEB415A

Produce server side script for
dynamic web pages



Satisfactory


Unsatisfactory

ICAWEB425A

Apply structured query language to extract and manipulate data



Satisfactory


Unsatisfactory

ICAICT420A

Develop client user interface



Satisfactory


Unsatisfactory

ICAPRG405A

Automate
processes



Satisfactory


Unsatisfactory

ICAWEB410A

Apply web authoring tool to convert client data for websites



Satisfactory


Unsatisfactory

ICAPMG401A

Support small scale IT projects



Satisfactory


Unsatisfactory

ICADBS403A

Create basic datab
ases



Satisfactory


Unsatisfactory


WORK TO BE SUBMITTED

Student

check

Assessor

check


PROJ 1:build 'n script: a blog





Satisfactory


Unsatisfactory

PROJ 2:build 'n script: an image gallery





Satisfactory


Unsatisfactory

PROJ 3:build 'n
script: a shopping cart





Satisfactory


Unsatisfactory

Signature of Student:



ASSESSORS SUMMARY

ICAWEB403A

Transfer content to a website using commercial packages

SUPPORT

1 Configure the file transfer protocol client
-

review and select FTP
client
-

ensure that FTP is
suitable for the technical environment
-

including user ID, password and host name or ID


use
settings such as auto
-
detect, save profile and password depending on organisational security
and privacy policy and organisational gu
idelines


test and verify configuration by connecting
to the web hosting server



Does support

Does not

2 Plan and prepare for data transfer


prepare data content and back it up
-

identify data as
compressed or uncompressed with tools available on th
e server to manage uploaded data
-

ensure files are in appropriate
-

receiving directory structure is applicable for the data to be
uploaded



Does support

Does not

3 Establish connection to server
-

log on to remote server
-

proceed through securit
y layers
-

initiate FTP and locate destination directory



Does support

Does not

4 Transfer data to remote server


select files to be transferred and choose mode
-

run
antivirus software on downloaded files
-

move, rename, copy, and delete files on th
e server
-

store files
-

account for decompression or de
-
archival of the files for use



Does support

Does not

Evidence of the ability to:



Does support

Does not



configure an FTP client



Does support

Does not



prepare content to be
transferred



Does support

Does not



connect to the server



Does support

Does not

• t
ransfer content



Does support

Does not

ICAWEB415A

Produce server
-
side script for dynamic web pages



Does support

Does not

1 Analyse
requirements for web documents requiring server
-
side dynamic interaction
-

Determine necessary dynamic functionality of the web document
-

Determine appropriate
language to achieve that functionality
-

Determine web document requirements



Does support

D
oes not

2 Design server
-
side scripts
-

Design web document and server
-
side code to interact with an
external data source
-

Design web document and server
-
side code to allow an administrator to
insert, update and delete entries to the external data source

-

Implement security features in
the web document



Does support

Does not

3 Produce web documents
-

Write extensible hypertext markup language (XHTML) considering
accessibility
-

Write server
-
side scripts to current XHTML standards



Does support

Do
es not

4 Test scripts and debug
-

Test web document against required functionality and reiterate until
correct
-

Complete documentation and submit to appropriate person for approval



Does support

Does not

5 Set up security
-

Determine necessary perm
issions to prevent error messages displaying to
the public
-


Configure server software to minimise potential database attacks



Does support

Does not

Evidence of the ability to:



Does support

Does not



create dynamic web pages from a client
requirement using server
-
side scripting to
retrieve information from a web
-
hosted database



Does support

Does not



create scripts for the quick upload of data to web
-
hosted databases



Does support

Does not



create server
-
side scripts for inserting, updating and deleting data from a web server


Does support

Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
25

database



create server
-
side scripts to encode passwords



Does support

Does not



create server
-
side scripts to upload and retrieve ima
ges



Does support

Does not



create server
-
side scripts to manage sessions and secure login.



Does support

Does not

ICAWEB425A

Apply structured query language to extract and manipulate data



Does support

Does not

1 Identify SQL requirements
from the specification documentation
-

Determine information to
be used from database
-

Identify tables that hold this information
-

Identify primary keys in
these tables
-

Identify relationships between these tables, including foreign keys



Does support


Does not

2 Create a relational database
-

Create tables in a database using SQL statements
-

Identify
primary and foreign keys for database table
-

Manipulate data in a database using SQL
statements
-

Query the database using SQL statements
-

Write SQL

statements to retrieve
information from database



Does support

Does not

3 Test SQL results
-

Construct test data to test SQL statements
-


Construct expected
results to verify SQL statements
-

Verify result of the constructed SQL statements against
expected results



Does support

Does not

Evidence of the ability to use SQL to:



Does support

Does not



create databases and tables



Does support

Does not



query one or more tables to provide required data



Does support

Does not



add,

modify and delete records from tables



Does support

Does not



drop databases and tables.



Does support

Does not

ICAICT420A

Develop client user interface



Does support

Does not

1 Prepare design for interface
-

Review requirements and other
documentation to determine
user needs
-

Investigate system environment to determine the impact of user interface design
-

Review organisational goals to ensure consistency with organisational styles
-

Define data
query and report formats for the user inter
face design where appropriate
-

Document needs
and findings and obtain approval for the proposed interface from the appropriate person



Does support

Does not

2 Design and document user interface
-


Design menu structures according to
requirements and



Does support

Does not

acceptance criteria and following design principles
-

Design screen dialogues according to
requirements and acceptance criteria and following design principles
-

Design batch
procedures where appropriate to technical specificati
ons and acceptance criteria
-

Design
online help and tutorials for the prototype following design principles
-

Document prototype
according to organisational goals
-

Submit prototype to appropriate person for sign
-
off



Does support

Does not

Evidence o
f the ability to:



Does support

Does not



determine impact of user interface design in the system environment and identify
appropriate data query and report formats



Does support

Does not



design menu structures according to design principles



Does support

Does not



design screen dialogues in line with requirements and acceptance criteria



Does support

Does not



design batch procedures



Does support

Does not



develop online help and tutorials for prototype.



Does support

Doe
s not

ICAPRG405A

Automate processes



Does support

Does not

1 Develop algorithms to represent solution to a given problem
-


Develop an algorithm
which is an exact and sufficient description of the solution
-

Develop an algorithm which takes
account
of all expected possible situations
-

Develop an algorithm which is guaranteed to end



Does support

Does not

2 Describe structures of algorithms
-

Demonstrate use of structure, sequence, selection and
iteration
-

Use structures to describe algorithmic

solutions to a problem



Do
es support

Does not

3 Design and write script or code
-

Create an abstract design to fulfil the requirements of the
proposed process
-

Review the abstract design for omissions or errors
-

Translate the abstract
design to the

chosen language
-

Create internal documentation



Does support

Does not

4 Verify and review script or code
-

Check the script or code for syntax and semantic errors
-

Identify areas that are not covered or are covered incorrectly in the script or code



Does support

Does not

5 Document script or code
-

Create technical
-
level documentation
-

create user
-
level
documentation



Does support

Does not

Evidence of the ability to:



Does support

Does not



develop an algorithmic statement of a solu
tion for a set process



Does support

Does not



produce a functional script to automate a set process



Does support

Does not



document this script both internally and externally.



Does support

Does not

ICAWEB410A

Apply web authoring tool to

convert client data for websites



Does support

Does not

1 Create files
-

Create files and save in correct location and directory
-

Insert and format text
content according to
business requirements
-

Insert and
optimise images
as required



Does suppo
rt

Does not

2 Create formatting templates
-


Create basic external cascading style sheets (CSS)
-

Define styles for the required tags according to business requirements
-

Link CSS to the files
and display formatting



Does support

Does not

3 Define

library items
-

Identify items that recur on several pages and include in library
-

Format selected items according to CSS definition
-

Check tags of selected items
-

Create and
clearly name selected library items
-

Update items contained in library accor
ding to business
requirements



Does support

Does not

4. Develop templates
-

Create and save file as template and link with CSS
-

Format template


Does support

Does not

doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
26

and create and name editable regions
-

Place generic image icons in page as required by
business image
-

S
ave and modify templates

5 Identify authoring requirements
-

Select preferred web authoring tool, according to business
requirements
-


Set preferences for web authoring tool, including site file transfer protocol
(FTP) client
-

Customise and navigate the web author tool environment or workspace to meet
individual requirements
-

Select buttons and tools, both opened and closed, to access full
range of features
-

Define and name site and root folder



Does support

Does n
ot

6
Create simple forms
-

Add form elements to page
-

Set form element properties for each
form element
-

Insert additional fields as required for processing form
-

Identify availability and
location of common gateway interface
-

Test form to ensure no errors



Does support

Does not

7 Create simple navigation
-

Create site map to plan navigation
-

Create links between pages to
reflect content structure using both text and images
-

Check links in multiple browsers for
errors
-

Check website content across a
number of different browsers and browser versions to
ensure consistency of presentation, performance and accessibility



Does support

Does not

Evidence of the ability to:



Does support

Does not



develop web content using authoring tools to meet s
pecifications



Does support

Does not



use authoring tools to create cross
-
browser web documents



Does support

Does not



create forms



Does support

Does not



create navigation tools.



Does support

Does not

ICADBS403A

Create basic
databases



Does support

Does not

1 Analyse requirements for the database
-

Determine the information that the database is
required to hold
-

Develop a written requirement report for the functionality of the database
-

Complete documentation and submit

to appropriate person for approval



Does support

Does not

2 Use data modelling to design the database to suit requirements
-

Design an entity
-
relationship (ER) diagram to model the relationships between the entities and attributes the
database will
hold
-

Develop the primary and foreign keys to link the entities
-

Develop a data
dictionary
-

Complete documentation and submit to appropriate person for approval



Does support

Does not

3 Create a database on a web or database server
-

Use the approp
riate language on a web or
database server to create one or more databases
-

Use the appropriate language on a web or
database server to create tables
-

Populate the database fields



Does support

Does not

4 Test database and debug
-

Test the database
on the web or database server
-

Ensure that the
information represented matches the requirements



Does support

Does not

Evidence of the ability to:



Does support

Does not



research client requirements for a database solution



Does supp
ort

Doe
s not



design a database that meets client requirements



Does support

Does not



create a database on a web hosting service to meet client requirements by a due
date.



Does support

Does not

The student requires the following skills development

before reassessment / Feedback to student on overall performance during
assessment:





The candidate has been provided with feedback and informed of the assessment result and the reasons for the decision.

Signature of Assessor:

D
ate:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
27



VISUAL LANGUAGE COMMUNICATION

ASSESSORS CHECKLIST

Student name:



The concept of visible language refers to all the graphical techniques used to communicate the message or content.


STANDARDS

S

NYS

Fixes

Are the following visual communication elements successfully applied
?

Layout:

formats, proportions, and grids


two
-
dimensional and three
-
dimensional


organization.




Typography:

selection of typefaces
-
vari
able
-
width sans
-
serif



/ serif fonts


fixed
-
width fonts found on most computer



displays.




Colour

/
texture:
colour, texture
s

that convey information


/
pictorial reality




Imagery:

signs, icons, and symbols,
-

fr
om real to the



abstract.




Animation:

dynamic or kinetic
display

-


video
-
related



imagery.




Sequencing:

the overall approach to visual storytelling.




Sound:

abstract, vocal,
musical cues

"earcons".




Visual identity:

unique rules


overall consistency to a user interface.





The student requires the following skills development before reassessment:




Feedback to student
on overall performance during assessment:




Candidate signature:



Assessor







doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
28


Certificate III
/
IV


WEB APPLICATION

ROBUSTNESS CHARACTERISTICS

Assessor Checklist


Student:


Robustness
is one of the most important qualities of any application, is also one of the most difficult to achieve.
This
list
has
the FOUR
principal characteristics
that must be met for an application to be
considered robust.

Application APPROPRIATE key
areas need to be included in any individual application.

CHARACTERISTIC

KEY AREAS TO LOOK FOR

S

NYS

FIXES IF NYS

Transactions

F
rameworks usually try to abstract the access to
the underlying database of the application, while
this is certainly good, is
also causing an increasing
lack of understanding of what is happening behind
the scenes. Being able to explain what is the SQL
likely to be executed by your framework, and
when is going to be executed will help you to
create better database access code, an
d to
optimize the database access, especially if you
don’t have a DBA in your project. Some key areas
to look for:

Transaction modes.




Transaction frameworks
and APIs



Database access

Frameworks usually try to abstract the access to
the underlying
database of the application, while
this is certainly good, is also causing an increasing
lack of understanding of what is happening behind
the scenes. Being able to explain what is the SQL
likely to be executed by your framework, and
when is going to be ex
ecuted will help you to
create better database access code, and to
optimize the database access, especially if you
don’t have a DBA in your project. Some key areas
to look for:

SQL




Indexes



Lazy loading.



ORM frameworks and
APIs



Caching



Multithreading

Multithreading is the next big thing in software
development, is been there now for ages, but with
the new hardware architectures going multi
-
core,
multithreading is emerging as the new must
-
know
skill. It is also critical to acknowledge
that your
code is probably already running in a
multithreading platform so you need to consider it
to prevent your code to fail. Some key areas to
look for:

Stateless services




Unmodifiable beans



Race conditions



Locks



Logging and auditing

Logging and auditing are one of the most
underrated qualities of an application, especially
for server applications. Is easy to forget in
development how useful a log is when the
application has already been rolled into
production. Some key areas to look
for:

Consistent identifiers.




Consistent format



Completion: It should be
possible to track a thread




Student Feedback:



Assessors
:






doITlab.com: Across schools
certificate courses documentation


V5


July 2012


Peter Noonan

P a g e

|
29


Certificate III
/
IV


WEB APPLICATION

GOOD PHO HABITS / STANDARDS

Assessor Checklist


Student:



Good habits are the firm foundation upon which you can add more OO habits and build software that is easily maintained
and extended. These habits target characteristics
and
modularity.

Bad habit usage is unsatisfactory.

CHARACTERISTIC

ASSES:
Good/Bad

S

NYS

FIXES

Be modest


Be modest is to avoid exposing
yourself in your implementations
of classes and functions.

Bad habit: Expose
public fields




Good habit: Use
public
accessors

Be a good neighbour

A class should handle its own
errors appropriately. If the class
doesn't know how to handle the
errors, it should package them in a
format that its caller understands.

Bad habit: Not
handling errors




Good habit: Each
module handles its
own errors

Avoid looking at Medusa

Be specific, concrete
implementation, your code must
change if your implementation
code changes.

Bad habit: Not using
interfaces




Good habit: Use
interfaces

E
mbrace the weakest link

Loosely
coupling

your modules
is a good thing; it's one of the
properties that allows you to
encapsulate change.

Bad habit: Tight
coupling




Good habit: Loose
coupling between
objects

You're rubber
; I'm glue

Highly cohesive OO designs are
focused and
organized in related
modules
-

"concerns" is important
in determining how to organize
functions and classes to be tightly
cohesive.

Bad habit: Low
cohesion




Good habit: Embrace
high cohesion

Keep it in the family

W
ith good design, copying code is
completely unnecessary.

Bad habit: Not using
class hierarchies




Good habit: Leverage
inheritance

Think in patterns

Design patterns are common
interactions of objects and
methods that have been proven
over time to resolve certain
problems


Bad
habit: Consider
one object at a time





Good habit: Adding
objects, in concert,
composed in
patterns


Student Feedback:



Assessor
: