1



Trends in Degree Granted by Degree Level and Major: 2003-2004 to 2007-08

[pic]

Note: In the text for this exercise, business areas are shown in bold italics (e.g., Degree Facts Business Area), folders are shown in bold (e.g., Degree Facts), and items are shown in italics (e.g., Headcount).

Workbook Wizard Step 1: Create/Open Workbook

1. Open Discoverer Desktop 11g and connect to the database (IRDBPROD2) using your username and password

2. Select “Create a new workbook”, select “Crosstab”, and click “Next”.

[pic]

Workbook Wizard Step 2: Select Items

3. Select the Degree Facts Business Area for queries on degrees granted.

[pic]

The Degree Facts Business Area contains the folders you will need to create the crosstab query. You may have to scroll down to view folders or to view items that are contained in each folder. For this exercise you will need to select the following items:

|Item |Folder |Layout Position |

|Headcount |Degree Facts |Data point |

|Academic Year Desc |Degree Facts |Column |

|Degree Earned Level Desc |Degree Facts |Row |

|College |Degree College Dim |Page Item |

|Major 1 NYSED HEGIS GROUP Desc |Degree Major 1 Dim |Row |

4. Expand the Degree Facts folder by clicking on the plus sign [pic] to the left of the folder.

[pic]

5. For this exercise, we are counting degrees granted (may contain duplicated count of students who’ve earned more than one degree). The data point to use is Headcount. Highlight Headcount and click the right arrow [pic] to move the selected item from the “Available” window to the “Selected” window.

[pic]

Note: A data point is a numeric item that fills the cells of your crosstab table. Data points are variables that have values upon which you can perform a mathematical operation such as sum, average, minimum, or maximum. The default function for the Headcount item is SUM, which is the appropriate function for this exercise.

6. Scroll down to Academic Year Desc and click the plus sign [pic] next to that item. A list of academic years that are available in the IRDB will be displayed.

Scroll down to highlight ‘2003-2004’, ‘2004-2005’, ‘2005-2006’, ‘2006-2007’, and ‘2007-2008’. Hold the Ctrl button to highlight multiple selections. Press the right arrow [pic] to move the selected item and values from the “Available” window to the “Selected” window.

[pic]

Note: We will be using Academic Year as a column item but do not want to include all years in the query. Therefore, we will make an implicit condition by selecting specific values of the Academic Year Desc item.

7. The Degree Earned Level Desc item forms the rows in the crosstab table. Scroll down and select this item. Press the arrow button [pic] to move Degree Earned Level Desc from the “Available” window to the “Selected” window.

[pic]

Note: No implicit condition was set for this item. Therefore all values of the Degree Earned Level Desc item will be included in the crosstab. To see what values are part of this item, click on the [pic] next to the Degree Earned Level Desc item.

8. Scroll up to the top and collapse the Degree Facts folder by clicking on the minus sign [pic] next to the folder. Open the Degree College Dim folder by clicking on the plus sign [pic] next to it.

[pic]

9. Click the plus sign [pic] next to College and scroll down to highlight your college. Press the right arrow button [pic] to move the College item from the “Available” window to the “Selected” window (Here, we use Bruch as an example).

[pic]

Note: We have made another implicit condition by selecting one value of the College item

10. Close the Degree College Dim folder by clicking on the minus sign [pic]next to it.

Open the Degree Major 1 Dim folder by clicking on the plus sign [pic] next to it.

[pic]

11. The Major 1 NYSED HEGIS Group Desc item forms another set of rows in the crosstab table. Highlight this item (you may need to scroll down to see it) and click the right arrow button [pic] to add it.

[pic]

12. The “Selected” window now contains all the items that will be displayed in the crosstab as a row, column, data point, or page item. Click “Next” to continue.

Note: oftentimes you may select more items than can be displayed at once in the selected window without scrolling. You can make the Wizard window larger, by dragging at the corners, in order to see all the items in your selection window without scrolling or to see complete item names.

Workbook Wizard Step 3: Crosstab Layout

13. Since we don’t want to display college in our crosstab, check the “Show Page Item” checkbox and drag College to the “Page Items” window.

Since there is no more items in the row area there will be a notice from Discoverer, click “OK” to continue.

[pic]

14. Drag Major 1 NYSED HEGIS Group Desc and Degree Earned Level Desc from the column section to the row section.

[pic]

15. Drag the Degree Earned Level Desc item from the column section to the row section and position it above the Major 1 NYSED HEGIS Group Desc.

[pic]

16. Drag Academic Year Desc above Data Point Headcount SUM, if it is not already in that position. Click “Next” to continue.

[pic]

Workbook Wizard Step 4: Conditions

17. Here you can see two implicit conditions we have created through selecting specific years and college. You can add explicit conditions by clicking “New”. In this analysis we don’t need any more conditions so click “Next” to continue.

[pic]

Workbook Wizard Step 5: Calculations

18. We don’t need to add calculations for this analysis and therefore click “Finish” to finish the Workbook Wizard steps.

[pic]

Formatting Query Results

19. This is how the query results look like.

[pic]

20. To add a title, select “Edit Tittle” from the “Sheet” menu. The “Edit Title” dialog box will appear. Set the desired font type and size. Then add a title and click “OK”.

[pic]

[pic]

21. Change the style of your cross tab from inline to outline. Select Tools-->Options to open the Options Dialog Box. Select the "Crosstab" tab, and then select the “outline” from the style section.

And the results will look like the table below.

[pic]

[pic]

22. Next we want to edit the headings so that it appears and aligns the way we want.

First highlight the first row, right click and select “Format Headings” (or select “Headings” from the “Format” menu)

[pic]

23. Then in the “Alignment” tab, select “Center” alignment.

[pic]

24. Highlight Headcount SUM, right click and select “Item Properties”.

[pic]

25. The “Item Properties” dialog box will appear. Type “N” in the Heading window and click “OK”. Then follow steps 23-24 to make it align in the center.

[pic]

26. Place mouse pointer to the right side of the column heading and drag it to the right to desirable display of the crosstab results.

[pic]

27. To rename the worksheet from its default name, double click on the “Sheet1” tab at the bottom of the table, and then select “Worksheet Properties”. Type a new name in the Name window, and click “OK”.

[pic]

28. To save the workbook, select “File” ( “Save As”, select My Computer and set the directory you want to save the workbook in.

[pic]

29. This is how the completed crosstab query may look (counts may vary depending on what college you select):

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download