Difference between revisions of "Integrationsstatus 2010 - 10008vox"

From Catglobe Wiki
Jump to: navigation, search
(Created page with 'dsvf category:Production guidelines')
 
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
dsvf
+
<accesscontrol>Main:MyGroup</accesscontrol>
 +
== Introduction  ==
  
−
  [[category:Production guidelines]]
+
=== The production team ===
 +
 
 +
{| border="1" class="CGTable"
 +
|-
 +
! Function
 +
! Name
 +
|-
 +
| Consultant (DK)
 +
| Ulrik Hjarnaa
 +
|-
 +
| Data Consultant (VN)
 +
| [[Đàm Thục Vy Vân]]
 +
|-
 +
| Data Consultant (VN)
 +
| [[Huỳnh Huy Phong]]
 +
|}
 +
 
 +
=== Assignment<br>  ===
 +
 
 +
Our assignments for this project are: <br>
 +
 
 +
*Create two table reports; each report must include the listed questions as frequency tables and then as cross tables on demographic background variables; Create this as two tabulation script so that it will be to run multiple times.They should have nice table layout and be converted to PDF.
 +
 
 +
'''<u>Questionnaire:</u>''' 10008vox - IntegrationsStatus 2010
 +
 
 +
<u>'''Variables report 1:'''</u> (Report name: '''''10008vox – Indenrigsministeriet''''')
 +
 
 +
Q1inm
 +
 
 +
Q2inm
 +
 
 +
Q3inm
 +
 
 +
Q4inm
 +
 
 +
<u>'''Variables report 2:'''</u> (Report name: ''10008vox – RUC'')
 +
 
 +
RUC_1
 +
 
 +
RUC_2
 +
 
 +
<u>'''Demographic variables (Column):<br>'''</u>
 +
 
 +
Demographic_Gender
 +
 
 +
D_Demographic_AgeGroup
 +
 
 +
D_Demographic_RegionMinimize
 +
 
 +
RefugeeStatus_dupe
 +
 
 +
Origin
 +
 
 +
*Create the stylesheet that takes care of as much as possible of the settings.<br>
 +
 
 +
=== Project location<br>  ===
 +
 
 +
All resources for this project must be created under the project named '''10008vox - Integrationsstatus 2010''' located on mycatinet.catglobe.com<br>
 +
 
 +
[[Image:Path.png]]<br>
 +
 
 +
'''Tabulation scripts:'''<br>
 +
 
 +
*''<u>10008vox – Indenrigsministeriet</u>''<u></u>
 +
 
 +
<source lang="csharp">
 +
 
 +
setReportStyleSheetId(550);
 +
 
 +
array aAxes = {"Q1inm_SQ_1","Q1inm_SQ_2","Q1inm_SQ_3","Q1inm_SQ_4","Q1inm_SQ_5","Q2inm","Q3inm","Q4inm"};
 +
 
 +
array bAxes = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
 +
 
 +
Tabulation_setTableLayout(TableChartLayout_Ifka);
 +
 
 +
Tabulation_setAbsText("abs");
 +
Tabulation_setPctText("%");
 +
Tabulation_setCountAnswer(true);
 +
Tabulation_setTotalAnswerText("Total sample size");
 +
Tabulation_setEnableOddEvenRowHeader(true);
 +
Tabulation_setMergeStatisticPctItem(true);
 +
 
 +
//set values for Abs column
 +
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
 +
array fill_AbsCol = {19,{17,0,0,0},2,true};
 +
string valign = "center";
 +
string halign_AbsCol = "right";
 +
number decimal = 0;
 +
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
 +
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);
 +
 
 +
//set values for Count Answer Row
 +
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
 +
string halign_CountAnswer = "left";
 +
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
 +
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);
 +
 
 +
//set values for Headers column
 +
array font_Header = DiagramFontStyle_getDefault();
 +
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
 +
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";   
 +
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;   
 +
array fill_style = DiagramFillStyle_getDefault(); 
 +
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);   
 +
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;   
 +
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;   
 +
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 +
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
 +
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
 +
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
 +
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);
 +
 
 +
for (number i=0;i < arrayCount(aAxes);i=i+1)
 +
{
 +
createFrequenceDiagram(aAxes[i]);
 +
}
 +
 
 +
style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);   
 +
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;   
 +
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;   
 +
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 +
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
 +
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);
 +
 
 +
for (i=0;i < arrayCount(aAxes);i=i+1)
 +
{
 +
for (number j=0;j < arrayCount(bAxes);j=j+1)
 +
{
 +
  createCrossDiagram({aAxes[i]},{bAxes[j]});
 +
}
 +
}
 +
 
 +
Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);
 +
Tabulation_setHasPageNumber(true);
 +
Tabulation_setShowResultAsPdf(true);
 +
 
 +
</source>
 +
 
 +
*<u>''10008vox – RUC''</u><br>
 +
 
 +
<source lang="csharp">
 +
 
 +
setReportStyleSheetId(550);
 +
 
 +
array aRow = {"RUC_1","RUC_2"};
 +
 
 +
array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
 +
 
 +
Tabulation_setTableLayout(TableChartLayout_Ifka);
 +
 
 +
Tabulation_setAbsText("abs");
 +
Tabulation_setPctText("%");
 +
Tabulation_setCountAnswer(true);
 +
Tabulation_setTotalAnswerText("Total sample size");
 +
Tabulation_setEnableOddEvenRowHeader(true);
 +
Tabulation_setMergeStatisticPctItem(true);
 +
 
 +
//set values for Abs column
 +
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
 +
array fill_AbsCol = {19,{17,0,0,0},2,true};
 +
string valign = "center";
 +
string halign_AbsCol = "right";
 +
number decimal = 0;
 +
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
 +
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);
 +
 
 +
//set values for Count Answer Row
 +
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
 +
string halign_CountAnswer = "left";
 +
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
 +
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);
 +
 
 +
//set values for Headers column
 +
array font_Header = DiagramFontStyle_getDefault();
 +
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
 +
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";   
 +
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;   
 +
array fill_style = DiagramFillStyle_getDefault(); 
 +
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);   
 +
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;   
 +
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;   
 +
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 +
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
 +
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
 +
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
 +
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);
 +
 
 +
for (number i=0;i < arrayCount(aRow);i=i+1)
 +
{
 +
createFrequenceDiagram(aRow[i]);
 +
}
 +
 
 +
style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);   
 +
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;   
 +
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;   
 +
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 +
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
 +
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);
 +
 
 +
for (i=0;i < arrayCount(aCol);i=i+1)
 +
{
 +
for (number j=0;j < arrayCount(aRow);j=j+1)
 +
{
 +
  createCrossDiagram({aRow[j]},{aCol[i]});
 +
}
 +
}
 +
 
 +
Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);
 +
Tabulation_setHasPageNumber(true);
 +
Tabulation_setShowResultAsPdf(true);
 +
 
 +
</source>
 +
 
 +
== Deliveries  ==
 +
 
 +
=== Status report  ===
 +
 
 +
Setup Tabulation report for providing consultant and management with easy overview of project progress.
 +
 
 +
<br>
 +
 
 +
[[Category:Production_guidelines]]

Latest revision as of 04:03, 18 October 2013

<accesscontrol>Main:MyGroup</accesscontrol>

Introduction

The production team

Function Name
Consultant (DK) Ulrik Hjarnaa
Data Consultant (VN) Đàm Thục Vy Vân
Data Consultant (VN) Huỳnh Huy Phong

Assignment

Our assignments for this project are:

  • Create two table reports; each report must include the listed questions as frequency tables and then as cross tables on demographic background variables; Create this as two tabulation script so that it will be to run multiple times.They should have nice table layout and be converted to PDF.

Questionnaire: 10008vox - IntegrationsStatus 2010

Variables report 1: (Report name: 10008vox – Indenrigsministeriet)

Q1inm

Q2inm

Q3inm

Q4inm

Variables report 2: (Report name: 10008vox – RUC)

RUC_1

RUC_2

Demographic variables (Column):

Demographic_Gender

D_Demographic_AgeGroup

D_Demographic_RegionMinimize

RefugeeStatus_dupe

Origin

  • Create the stylesheet that takes care of as much as possible of the settings.

Project location

All resources for this project must be created under the project named 10008vox - Integrationsstatus 2010 located on mycatinet.catglobe.com

Path.png

Tabulation scripts:

  • 10008vox – Indenrigsministeriet
setReportStyleSheetId(550);

array aAxes = {"Q1inm_SQ_1","Q1inm_SQ_2","Q1inm_SQ_3","Q1inm_SQ_4","Q1inm_SQ_5","Q2inm","Q3inm","Q4inm"};

array bAxes = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};

Tabulation_setTableLayout(TableChartLayout_Ifka);

Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setCountAnswer(true);
Tabulation_setTotalAnswerText("Total sample size");
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setMergeStatisticPctItem(true);

//set values for Abs column
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
array fill_AbsCol = {19,{17,0,0,0},2,true};
string valign = "center";
string halign_AbsCol = "right";
number decimal = 0;
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);

//set values for Count Answer Row
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
string halign_CountAnswer = "left";
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);

//set values for Headers column
array font_Header = DiagramFontStyle_getDefault(); 
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";    
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;    
array fill_style = DiagramFillStyle_getDefault();   
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);

for (number i=0;i < arrayCount(aAxes);i=i+1)
{
 createFrequenceDiagram(aAxes[i]);
}

style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);

for (i=0;i < arrayCount(aAxes);i=i+1)
{
 for (number j=0;j < arrayCount(bAxes);j=j+1)
 {
   createCrossDiagram({aAxes[i]},{bAxes[j]});
 }
}

Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setHasPageNumber(true);
Tabulation_setShowResultAsPdf(true);
  • 10008vox – RUC
setReportStyleSheetId(550);

array aRow = {"RUC_1","RUC_2"};

array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};

Tabulation_setTableLayout(TableChartLayout_Ifka);

Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setCountAnswer(true);
Tabulation_setTotalAnswerText("Total sample size");
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setMergeStatisticPctItem(true);

//set values for Abs column
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
array fill_AbsCol = {19,{17,0,0,0},2,true};
string valign = "center";
string halign_AbsCol = "right";
number decimal = 0;
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);

//set values for Count Answer Row
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
string halign_CountAnswer = "left";
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);

//set values for Headers column
array font_Header = DiagramFontStyle_getDefault(); 
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";    
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;    
array fill_style = DiagramFillStyle_getDefault();   
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);

for (number i=0;i < arrayCount(aRow);i=i+1)
{
 createFrequenceDiagram(aRow[i]);
}

style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);

for (i=0;i < arrayCount(aCol);i=i+1)
{
 for (number j=0;j < arrayCount(aRow);j=j+1)
 {
   createCrossDiagram({aRow[j]},{aCol[i]});
 }
}

Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setHasPageNumber(true);
Tabulation_setShowResultAsPdf(true);

Deliveries

Status report

Setup Tabulation report for providing consultant and management with easy overview of project progress.


Retrieved from "http://wiki.catglobe.com/index.php?title=Integrationsstatus_2010_-_10008vox&oldid=24749"