print page
< Back
Menu > About EDB >
Forms & Circulars
-
Forms
-
Circulars
< Back
Menu > Curriculum Development and Support >
Major Levels of Education
-
Kindergarten Education
-
Primary Education
-
Secondary Education
< Back
Menu > Curriculum Development and Support >
Assessment
-
Basic Competency Assessment (BCA)
< Back
Menu > Students and Parents Related >
Life Planning Education and Career Guidance
-
Life Planning Education
-
Business-School Partnership Programme
< Back
Menu > Students and Parents Related >
Safety Matters
-
Safety of Students
-
School Bus Services
< Back
Menu > Students and Parents Related >
Non-Chinese speaking (NCS) students
-
Education services for non-Chinese speaking (NCS) students
-
What's new
-
Overview
< Back
Menu > Students and Parents Related >
Programs and Services
-
Programs
-
Services
< Back
Menu > Teachers Related >
Qualifications, Training and Development
-
Qualification
-
Training
-
Development
< Back
Menu > School Administration and Management >
Financial Management
-
About Financial Management
-
Information on Subsidy
-
Notes to School Finance
< Back
Menu > School Administration and Management >
School Premises Related Information
-
Allocation of a School
-
Furniture and Equipment List for New Schools
-
School Premises Maintenance
< Back
Menu > Public and Administration Related >
Public Forms and Documents
-
Public Forms
-
Efficiency Office - Guide to Corporate Governance for Subvented Organisations
< Back
Menu > Public and Administration Related >
Tender Notices
-
Tender Notices
-
Works Tender Notice
Main content start

Stakeholder Survey Result Analysis Tool (Advanced Version)

 

Installation Guide for "Stakeholder Survey Result Analysis Tool (Advanced Version)"
1)
Download "Stakeholder Survey Result Analysis Tool (Advanced Version).zip"
2)
Right-click "Stakeholder Survey Result Analysis Tool (Advanced Version).zip" and choose "Extract All…" to decompress all files into the same folder

Installation Step 1 (Extraction)

The decompressed files include "Teacher Survey Tool.xls", "Stakeholder Survey Result Analysis Tool.xls", "Installation and User Guide for Stakeholder Survey Result Analysis Tool (Advanced Version).doc" and "Database.mdb", which is a hidden file

Installation Step 1 (Files)
3)
Open MS Excel
4)
Set the security level
MS Excel 2003:
Select "Tools > Macro > Security". Change "Security Level" to "Medium"

Installation Step 4 (MS Excel 2003)



MS Excel 2007:
Select "Microsoft Office button > Excel option > Trust Center > Trust Center Setting…". In the "Trust Center" dialog box, change "Macro Settings" to "Disable all macros with notification"



MS Excel 2010 and later versions:
Select "File > Options > Trust Center > Trust Center Settings…". In the "Trust Center" dialog box, change "Macro Settings" to "Disable all macros with notification" 

Installation Step 4 (MS Excel 2007, 2010, 2013 & 2016)
5)
Open "Teacher Survey Tool.xls":
MS Excel 2003:
"Security Warning" window appears. Choose "Enable Macros"

Installation Step 5 (MS Excel 2003)


MS Excel 2007:
"Security Warning" message bar appears. Click "Options…" The "Microsoft Office Security Options" dialog box appears. Select "Enable this content"

Installation Step 5 (MS Excel 2007)

MS Excel 2010 and later versions:
"Security Warning" message bar appears. Click "Enable Content"

Installation Step 4 (MS Excel 2007, 2010, 2013 & 2016)





User Guide for "Stakeholder Survey Result Analysis Tool (Advanced Version)"
1)
Open "Teacher Survey Tool.xls"

Usage Step 1
2)
Follow the instructions to complete the teacher survey and export the data

Usage Step 2
3)
Open "Stakeholder Survey Result Analysis Tool.xls"

Usage Step 3
4)
The tool will have the teacher survey results ready automatically
5)
Enter parents and supporting staff (clerk and janitor staff) survey responses into the tool manually
6)
When completed, the tool will compile and analyse the stakeholder survey results automatically
7)
Choose the appropriate worksheets to view the analysis results