STEDFast Data Warehouse Admin User Manual
Contents
1. Scores by Teacher Subject and Grade and double click on it to open 10 STEDFast Admin User Manual 5 Click the Toggle Browser button again to hide the data browser and give you more space for the report 6 The new file will open in another tab in the user interface If you kept the Analyzer Report open from the last module you will still see it listed as another tab You can keep several reports open at once if you would like Scores by School and Subject by Term Dashboard Scores by Teacher Subject and Grade mining Dachhoard 7 You will see in the very top window options to select a school and term Since you are restricted to only the schools you have access to you may only have one option in the Select a School drop down list Go ahead and select a school and term Prompts Select a School Select a Term E B Stanley Middle School 2010 2017 Ege 8 Click the small arrow beside Prompts to hide the prompt window to give you more room for the charts 9 Thetop chart labeled Scores by Grade will show you a bar chart with the aggregate score of all benchmark tests for the term and school you selected with a separate bar for each grade There may be a special grade labeled N A for test subjects that are not tied to a particular grade similar to End of Course SOL tests 10 The bottom two charts may be showing no data or erroneous data right now They are not updated properly until you select2. Select a grade from the Benchmark Test Grade Level prompt Again this will reflect the grades you have access to in the system For the Test Subject prompt you will need to make sure you select a subject that will have data for the grade you previously selected Select a period from the Benchmark Test Period drop down list Click the View Report button to generate the report based on the prompts you have selected You can see several elements of this report on the first page The report is titled Student Scores by Teacher You will see a heading for each teacher followed by rows for each student in that teacher s class After all the students for a particular class are displayed you will see an average for that teacher s class Scroll through the pages of the report using the arrows at the top You can also type in a page number in the box followed by lt ENTER gt to jump directly to a page within the report Go ahead and type in the last page number of the report followed by lt ENTER gt to jump to the last page One the last page you will see the final teacher s average score followed by a line listing the school wide average for the benchmark test you selected STEDFast Admin User Manual Module 4 View a Premade Analyzer Report We will now look at a simple Analyzer Report to show you the basics of using that interface re If the folder browser is not visible click the Toggle Browser button to display it Double c
3. Drag Teacher Last Name over to the report design canvas so that you get a vertical green line on the left side of the report Let go of the mouse button to place Teacher Last Name onto the report Average Scores by Teacher Teacher Last Name Bowman Hir kes 4 Scroll back to the top of the list of available fields and drag Score over to the report design canvas to the far right of the report until you get a vertical green line Let go of the mouse button to place Score to the right of Teacher Last Name 5 We need to now group the items so that they make more sense We ll start out by grouping the items by subject 6 Scroll down through the list of available fields until you see Benchmark Test Subject Drag it above the heading for the previous data fields until you get a horizontal green line Horizontal green lines tell the reporting interface that you want to group the report by this field Your report should now look similar to the following Average scores by Teacher Benchmark Test Subject Algebra I Teacher Last Name King 77 Widener 70 Benchmark Test Subject Civics amp Economics Teacher Last Name Score Confere 63 7 Let s further group the scores by testing period In the list of available fields drag Benchmark Test Period over to the report canvas immediately under Benchmark Test Subject until you get a horizontal green line Let go of the mouse button to further group the report by test peri
4. Student Table rrrnnrarnnvnnnnnenennnnnnnnsennvnnnnnernnnnnnnnnsennnnnnnnsennsnrnnnnnsnnnnnnnnnennnnnnnnnnsnnnrnnnnssnnnvnnnnenennnsnnnnnnneee 26 CRT E 27 TIME TMOG een ee ee ee ee 27 Appendix B Revision History rrrnranrrnnnnrrnnnnnrnnnnnrnnnnernnnnernnnnernnnnnrnnnnevnnnnsnnnnnssnnnnssnnnnesnnnnennnnunsnnnnssnnnnssenneee 29 A STEDFast Admin User Manual STEDFast Admin User Manual Chapter 1 Accessing and Navigating STEDFast Module 1 Logging Into STEDFast The STEDFast system can be accessed from any web browser Firefox Chrome Internet Explorer Safari etc Some features will work in a limited manner on iPads and other tablets but you need to be using a standard computer and web browser to access all of the features Future releases will have better mobile support and be more usable on devices like tablets and smart phones To Access and login to STEDFast 1 2 Open your computer s web browser In the Address Bar type in https stedfast wcs k12 va us 3 You should see the login screen 4 2005 2012 Pentaho Corporation All rights reserved pentaho POWERFUL ANALYTICS MADE EASY Pentaho User Console The Pentaho User Console provides Login access to powerful business analytics User Name Login for access to your reports lester U analysis views and dashboards Password a gt D Launch in new window Login using your e mail username and password Module 2 U
5. Report An interactive and easy to use web based reporting interface This tool allows end users to create simple ad hoc reports without needing a programmer or report designer Features include o Drag and drop interface o Inline formatting filtering sorting and summary calculations o What You See Is What You Get WYSIWYG report design and editing o Report templates for quick access o Output to PDF and Excel Analyzer Interactive analytical reporting for non technical business users Quickly analyze business information in chart or graphic form Features include o Drill into data using visual analysis o Narrow down data to understand or exclude outliers o Conditional formatting to visually contrast data points o Many forms of visualizations bar chart pie chart scatter graph heat map etc Dashboards Interactive dashboards allow you to view data at a glance Features include o Drag and drop interface allows you to quickly assemble content o Embed reports created with other tools into a single dashboard o Link multiple reports together for on the fly visualizations Module 3 View a Premade Interactive Report This report will allow you to display scores for a single term school grade test subject and test period The scores will be displayed for each student and grouped by teacher For each teacher an average score will be displayed for all their students and there will be a grand total average at the end of the repo
6. can use the Save As option to save a copy of your modified report to your home directory Do not be afraid to play around with different reports and options in the program If you have ideas for reports please let us know If you are attempting to build your own report and get stuck on something we would be glad to help you with that as well Further Reading http wiki wcs k12 va us stedfast start The newest version of this document along with other relevant information can always be found at this link http www pentaho com Makers of the Pentaho Business Intelligence Suite that is used to build the STEDFast Data Warehouse http infocenter pentaho com Online documentation for the Pentaho Business Intelligence Suite http en wikipedia org wiki Data_warehousing General information about Data Warehouses http en wikipedia org wiki Fact_table Description of the fact tables used to store measures like benchmark test scores for quick lookups Future Changes We are working on automating the import of data so that when a new benchmark test period is completed the data from those tests will be made available very quickly Adding the last three years worth of SOL test data Attendance and discipline information from PowerSchool 23 STEDFast Admin User Manual 24 STEDFast Admin User Manual Appendix A Available Fields in STEDFast Benchmark Testing Data Source This data source contains information rela
7. could choose particular terms schools and grades to narrow the data down further Fortunately this is easy to do with an nteractive Report 1 8 On the toolbar above your report click the button to display the Prompts window SG E x YS OSG To add a new prompt drag a field from Available Fields to this area In the left column click back on the Data tab to display the available fields once more Scroll down near the bottom of the available fields until you find Term Drag Term over to the Prompts window Uncheck the Auto Submit box so that you do not have to wait for the report to refresh each time you make a change Scroll through the available fields until you find School Name Drag School Name over to the Prompts window beside Term Scroll through the available fields until you find Benchmark Test Grade Level Drag Benchmark Test Grade Level over to the Prompts window to the right of the previous two fields Inthe Prompts window go ahead and select an available term school and grade level Click the View Report button to generate the report based on your selections You will now only be seeing report data that matches your selections This report can be exported in case you want to save itto your computer or printout a hard copy 18 STEDFast Admin User Manual 2 oe On the toolbar above the report click on the Export icon Note that you can export in several different formats Choose PDF from the
8. menu and the report will now open in Adobe Acrobat Reader You can print the report or save it to your computer Close the PDF report You will now save this report for future use L 5 On the main toolbar click the Save icon In the Save As window that pops up double click on Benchmark Testing Custom folders are setup for you to save your own personal reports Where you save to varies depending on whether you are a principal or a central office administrator e fyou are a principal double click on the Principals folder followed by your school level and then finally your school initials e If you are a central office administrator double click on Central Office and then your title or area of responsibility Type a name for the report in the Filename box and then click the Save button The report will be saved to your custom folder using the name you specified Reports saved to your custom folder can be seen and run by other users but cannot be changed or deleted by them In addition if they run your report it will still be restricted by the data they can see and will not show data from your school unless they have access to it Module 7 Create an Analyzer Report During this module you will create a new Analyzer Report to analyze benchmark test data by different classes of students You will use filters to narrow down the dataset and conditional formatting to visualize the scores 1 Close any reports that
9. you have open and close the folder browser if it is open You should see the main welcome screen displayed Click on New Analysis to begin working on a new Analyzer Report When the Select Data Source window pops up make sure Benchmark Testing Benchmark Test Scores is highlighted and then click OK Since we are working with benchmark test data the measure that we are concerned with is Score Scroll down through the available fields until you get to the Measures section Drag the Score field over to the Layout panel under the Measures section 19 STEDFast Admin User Manual 4 The report will update to show the average measure across all terms schools grades etc that your user account has access to 5 Scroll through the available fields window until you see the heading School Year Quarters Drag Term over to the Rows section of the Layout panel 6 The report will refresh to show a separate row for each term 7 Click on Report Options at the bottom of the Layout panel Check the boxes for both Show Grand Totals for Rows and Show Grand Totals for Columns and then click OK Report Options Blank Empty Cells In blank Measure cells show i Totals Show Grand Totals for Rows v Show Grand Totals for Columns 7 Also display totals that include filtered out values Cell Drillthrough Show drilthrough links on Measure cells Freeze Panes in Table Freeze column headers Freeze row labels 8 The repo
10. STEDFast Data Warehouse Washington County Public Schools pentaho POWERFUL ANALYTICS MADE EASY Admin User Manual STEDFast Admin User Manual STEDFast Admin User Manual Table of Contents Chapter 1 Accessing and Navigating STEDFast rrrannnrnnnnornnnnrnnnnnernnnnernnnnennnnnvnnnnnernnnnennnnnsnnnnsvrnnnnsnnnnnennnneeee 5 Module 1 L ggine Into STEDEASC 2 nee 5 Module 2 User Interface een een 5 Chapter FEN 7 Module 3 View a Premade Interactive Report rrrrarrrnnanrrnnnnnrnnnnnrnnnnnrnnnnernnnnnvnnnnsvnnnnsvnnnnernnnnnsnnnnssnnneee 7 Module 4 View a Premade Analyzer REport ccccccsssceccssececesececseccessceceeecesseceseseessensceseucensueceneness 9 Module 5 View a Premade Dashboard Report ss 10 Chapter 3 Creating Your Own ReportsS rrrunrnnnnnrnnnnnrnnnnnernnnnrnnnnsrnnnnsrnnnnnvnnnnevnnnnsvnnnnssnnnnsnnnnnssnnnnsnnnnsnsnsnnee 13 Module 6 Create an Interactive Report ccccsscscsssrescssrcncuseccsescncsserencusrencusescsesescuserencustencesescasseneuss 13 Module 2 Createan Analyzer RPO vrede 19 Chapter 4 Summary Further Reading and Future Changes rrranrrnnnnrrnnnnnrrnnnnrrnnnernnnnsrnnnnnsrnnnnsnnnnnsennnee 23 TN 23 Te 23 VU AN E D 23 Appendix A Available Fields in STEDFast scccssssscssssecessseccnsvencussscncussceesseseusvencusesencuseseuseseuesencusess 25 Benchmark Testing DAS OCR de ec ENE 25 PETTEE 25 ETNE 25 MAEM TD a E E 26 TOUT 26 PT 26
11. School Courses Is the course a Governor s School Course Governor s School or Non Governor s School e Honors Courses Is the course an Honors course Honors or Non Honors e Virginia Highlands Courses Is the course a Virginia Highlands Course VHCC or Non VHCC e Course 5 Course Number Alternate Course Number State Course Number Name Credit Value This is a special item that gives us a unique course identifier based on the items listed after the field name Properties that may change will always show the original content from when the field was first created 25 STEDFast Admin User Manual Term Table This table contains information about the terms and semesters e Term The term as named in PowerSchool 2008 2009 2009 2010 e Trimester The trimester as named in PowerSchool T1 T2 T3 e Mini The mini semester as named in PowerSchool M1 M2 M3 e Semester The semester as named in PowerSchool S1 S2 53 e Quarter The quarter as named in PowerSchool Q1 Q2 Q3 School Table This table contains information about the schools The school information is stored by date so we will know who the principal was during a particular school year not just the current principal e School Level The level of the school High Middle Elementary CTE e School 3 School Number State School Number Principal This is a special item that gives us a unique school identifier to match up with other data based on th
12. a grade from the top chart 11 Double click on a grade to update the bottom left chart with data related to that grade 12 The bottom left chart should now show you scores by testing period with a separate bar for each subject The data in this chart is filtered based on the school and term you selected from the Prompts section as well as the grade that you double clicked on in the top chart 13 The bottom right chart may still be showing no data or erroneous data 14 Double click on one of the bars in the bottom left chart to update the bottom right chart 15 The bottom right chart should now be showing you scores by teacher with a separate bar for each section Again the data in this chart is filtered by the prompts and the selections you chose in each of the other charts You can double click on a different test period and subject in the bottom left chart to see the bottom right chart updated accordingly 11 STEDFast Admin User Manual 12 STEDFast Admin User Manual Chapter 3 Creating Your Own Reports You will now use the reporting interface to create your own Interactive Report and Analyzer Report As seen in the last chapter there are also Dashboard Reports available Dashboard Reports are more complicated and require programming knowledge and more advanced reporting writing skills Module 6 Create an Interactive Report During this module you will create an interactive report from scratch that will show you average scores
13. by teacher for a given term grouped by subject and test period 1 If you have any reports open go ahead and click the X on the report tab to close them 2 Ifthe data browser is currently displayed click the Toggle Browser icon to hide it 3 You should now see the main window with options to create new reports r 1 Yew Dashboard L Il b 3 eS eS ee eee eo eee 4 Click on the New Report button to open a new Interactive Report 5 Apop up window will display asking you to select a Data Source Make sure that Benchmark Testing Question Responses is selected and then click OK 13 STEDFast Admin User Manual 10 11 Specify which data source you want to report on This wil determine which fields you will have available Data Sources A Benchmark Testing Question Responses You may get a window with a little information about Pentaho Interactive Designer If you get this window click the Get Started button You will get a blank report template to begin with There may be tooltips displayed on different elements of the interface Turn these tooltips off by unchecking the box at the bottom right Show tips on startup Then click the Hide Tips button at the bottom right El Show tips on startup Hide Tips The left column of the screen should be showing you all the data fields that are available for your report Unfortunately the Interactive Report interface does not allow u
14. data source You may notice that some of the fields are duplicated under multiple headings These are different views of the same data to make it easier to build certain types of reports and graphs If you scroll down you will see a Benchmark Test Data multiple views Course Information Measures School Terms Schools Sections Students Teachers sm 4 OM QO i Time Note More information on the available data fields can be found in Appendix A of this training manual The next column shows you the data that is currently being used to build this particular report You can see that the rows are made up of the school again your assigned school is pre selected and then by test subject within that school The columns are broken up into the terms that are currently loaded in the system Finally the overall benchmark test score is used as the STEDFast Admin User Manual measure for the report Conditional formatting is used to allow you to quickly determine your best scores green versus your worst scores red The main report window has buttons to show or hide the available fields columns and the layout panel If you are looking at a large report it is helpful to hide those options after you have everything selected r m r I 1 Analyzer Scores by Subject No Filter in use This pre made Analyzer Report can be further modified if you would like We will now narrow down this report to only show one year and further br
15. e school number state school number and principal Properties that may change will always show the original content from when the field was first created Section Table This table contains information about course sections e Section The section number of the benchmark test as stored in PowerSchool Student Table This table contains information about students and is built from PowerSchool data e Asian Students Is the student s race Asian Asian Non Asian e Black Students Is the student s race Black Black Non Black e CTE Completers Is the student a CTE completer CTE Completer Non CTE Completer e CTE Displaced Homemaker Students s the student a CTE Displaced Homemaker Currently unused e CTE Nontraditional Students Is the student a CTE Non Traditional CTE Traditional CTE Non Traditional e CTE Single Parent Students Is the student a CTE Single Parent CTE Single Parent Non CTE Single Parent e Disabled Students Is the student classified as disabled Disabled Non Disabled e Disadvantaged Students Is the student classified as disadvantaged Disadvantaged Non Disadvantaged e Hispanic Students Is the student s ethnicity Hispanic Hispanic Non Hispanic e Homeless Students Is the student classified as homeless and if so what type of homeless Non Homeless Doubled Up Hotels etc 26 STEDFast Admin User Manual e Native American Students Is the student s race Native America
16. eak down the subjects by teacher 1 Click the Funnel icon to display the filter window Drag Term from the Columns section of the Layout Browser up to the Filters window From the pop up menu click 2011 2012 to select it and then click the single right pointing green arrow to move 2011 2012 to the Included list and then click OK The report will now refresh to only display scores from the 2011 2012 term To further break this report down by teacher scroll down the Available Fields column until you see the Teachers heading Drag the field named Teacher 4 to the Layout window directly under Benchmark Test Subject The report will refresh to show the teachers for each subject It displays the teacher number rather than their name though The reason for this is that teacher names may change over time so our primary index is the teacher number It would be helpful to display their names as well Click the drop down arrow beside Teacher in the Layout Browser Go down to Show Properties and select Teacher Last Name The report will refresh to add a column for teacher name Module 5 View a Premade Dashboard Report We will now look at a dashboard report that allows you to drill down into data from one screen dl a If the folder browser is not visible click the Toggle Browser button to display it Double click on Benchmark Testing in the Browse window Double click on Training in the Browse window Find the file titled Dashboard
17. le contains all the information about teachers e Teacher First Name Teacher s First Name e Teacher Last Name Teacher s Last Name e Teacher 4 Teacher Number State Teacher Number Teacher Last Name Teacher First Name This is a special item that gives us a unique teacher identifier based on teacher number state teacher number first name and last name If a teacher s name changes we can still track them in the database Properties that may change will always show the original content from when the field was first created Time Table This table contains information about every date in the database It allows us to look at a particular date and see the term semester quarter etc that corresponds to that date It can be used to group or sort data in your reports e In Session Was school in session on this date In Session Holiday Vacation etc e Years What year are we looking at e Months What month are we looking at 27 STEDFast Admin User Manual 28 STEDFast Admin User Manual Appendix B Revision History 1 12 17 2012 Initial version released in Draft format Still need to add information for Chapter 4 2 12 18 2012 Chapter 4 information added Corrections to some data fields Further proofreading and error corrections 29 STEDFast Admin User Manual 30
18. lick on Benchmark Testing in the Browse window Double click on Training in the Browse window Scroll down through the list of reports until you find the one titled Analyzer Scores by Subject Double click on that report to open it Click the Toggle Browser button again to hide the data browser and give you more space for the report You should now see something similar to this Stores by School and Subject By Term amp Scores by School and Subject By Term sen On SES SE Er LE Available fields 67 for Benchmark Test Scores Find View fl Benchmark Question Sources VEE VERSET re ne eee No Filter in use E Benchmark Test Question 2 vB I k Questions 2010 2011 2011 2012 2012 2013 Columns Score Score Score Benchmark Question Type E Benchmark Tes Quest 2 Agen v Benchmark Tests Civics amp Economics Benchmark Grade Level English Benchmark Test Period Measures L Math Benchmark Test Subject D Benchmark Test 2 Br Benchmark Tests Grade Sub 9 Benchmark Test Grade Level f Benchmark Test Subject Benchmark Test Period Benchmark Test 2 Benchmark Tests Period Gra fl The column down the left shows you all the available fields from the Benchmark Test Scores By E B Stanley Middle School Reading _ Science I U S History 1877 to Present World Geography Writing
19. llowed by lt ENTER gt 6 The last page of your report should now look similar to this December 18 2012 01 43 Test Period Average 65 Benchmark Test Period 3rd 9 Weeks Teacher Last Name Crawford 91 Test Period Average 91 Test Subject Average 68 Overall Average 72 Let s now apply some formatting for better readability 1 Scroll back to the first page of your report Click the text Test Period Average and then hold down your lt CTRL gt key to also select the actual average displayed on the report Both the 17 STEDFast Admin User Manual description we manually entered and the average for the test period should both be selected and display cross hatches on the report Click the Formatting tab in the left column Change the font size to 12pt and click the B icon to make the text bold The report will refresh to show the period summaries with the larger font and bolded Scroll down through the report until you find the first instance of Test Subject Average Select both the description and the average as we did before Make this font 14pt and Bold Scroll to the last page of the report and find the overall average Select both the description and average as we did before and make this font 16pt and Bold This report now has some useful data and is formatted and grouped for readability However it is displaying data for all terms schools and grades that you have access to It would be helpful if you
20. n Native American Non Native American e Neglected Delinquent Students Is the student classified as Neglected or Delinquent Non Neglected Delinquent At Risk Juvenile Detention etc e Pacific Islander Students Is the student s race Pacific Islander Pacific Islander Non Pacific Islander e Primary Disability Students Does the student have a primary disability and if so what type Non Primary Disability Emotional Disturbance Autism etc e Student Gender What is the student s gender Male Female e Title Health Students Is the student flagged as Title I Health Health Non Health e Title I Math Students Is the student flagged as Title I Math Math Non Math e Title Reading Students Is the student flagged as Title Reading Reading Non Reading e Title Students Is the student flagged as Title I Title 1 Non Title 1 e Title Support Students s the student flagged as Title Support Support Services Non Support Services e White Students Is the student s race White White Non White e Student 3 Student Number Student Last Name Student First Name This is a special item that gives us a unique student identifier based on student number student first name and student last name If a student s name changes we can still track them in the database Properties that may change will always show the original content from when the field was first created Teacher Table This tab
21. od 16 STEDFast Admin User Manual We now have a basic report built that shows us average scores by teacher and grouped by both subject and test period It would be nice to see some averages based on our grouping and add some formatting for better readability 1 To display averages by group click on the Score column on the report The interface will cross hatch the column to show that it is selected Right click to bring up a pop up window go to Summary and choose Average 2 Thereport will now show rows at the end of each grouping that will display the overall average for that grouping The summaries do not have a description so let s add some text to describe the group average 3 Double click on the report in the blank space immediately to the left of the Benchmark Test Period summary average In the pop up window that appears type in Test Period Average and then lt ENTER gt Test Period Average 12 4 Scroll down until you see a summary line for the Benchmark Test Subject Double click on the report in the blank space immediately to the left of the Benchmark Test Subject average and type Test Subject Average in the pop up window that appears followed by lt ENTER gt Test Subject Average 10 5 Goto the last page of the report and find the overall average for the report Double click on the report in the blank space immediately to the left of the overall average and type Overall Average in the pop up window that appears fo
22. r future use 1 Onthe main toolbar click the Save icon we Ree Ze e 2 Inthe Save As window that pops up double click on Benchmark Testing Custom folders are setup for you to save your own personal reports Where you save to varies depending on whether you are a principal or a central office administrator e fyou are a principal double click on the Principals folder followed by your school level and then finally your school initials e fyou are a central office administrator double click on Central Office and then your title or area of responsibility 4 Type a name for the report in the Filename box and then click the Save button 5 The report will be saved to your custom folder using the name you specified Reports saved to your custom folder can be seen and run by other users but cannot be changed or deleted by them In addition if they run your report it will still be restricted by the data they can see and will not show data from your school unless they have access to it 22 STEDFast Admin User Manual Chapter 4 Summary Further Reading and Future Changes Summary This has hopefully given you a good overview of the main reporting features in the STEDFast system The data you are looking at is read only so you do not have to worry about messing anything up Also any ofthe premade reports that are available cannot be overwritten by your user account so do not worry about making changes to them You
23. rt re 5 If the folder browser is not visible click the Toggle Browser button to display it Double click on Benchmark Testing in the Browse window Double click on Training in the Browse window Scroll down through the list of reports until you find the one titled Interactive Report Student Scores Double click on that report to open it This report will show student scores by teacher for a given term school grade subject and period Click on the Prompts icon to display the drop down boxes that we will use to define our report STEDFast Admin User Manual 10 11 12 13 14 15 16 17 18 Interactive Report Student Scores Once you click the Prompts icon you should see the Prompts window display E F Ms AS 1 Term Name Benchmark Test Grade Level Benchmark Test Subject Benchmark Test Period 2010 2011 EB Stanley Middle School 6 Algebra I Ist9Weeks Auto Submit The report will auto refresh as the prompts are changed Since this takes a while each time you change a prompt uncheck the Auto Submit box so that the report will not refresh until we are finished setting our prompts Go ahead and select one of the terms from the Term drop down list The schools you see will be determined by your security rights as setup in the system Principals will only have rights to view data at their particular school Make sure you have a school selected for the School Name prompt
24. rt will refresh to show a grand total average for all terms 9 Scroll back up through the list of available fields until you find the section named Benchmark Tests Drag Benchmark Test Subject over to the Layout panel immediately under Term in the Rows section 10 The report will refresh to further break down the terms by subject 20 STEDFast Admin User Manual Term Benchmark Test Subiect Score Algebra I 77 Civics amp Economics 68 English 83 Math 74 2010 2011 Reading 76 science 21 U S History 1877 to Present 24 World Geography 75 Suppose we now want to compare scores among genders Let s add that data to the analysis and do some conditional formatting to more easily visualize the data 1 Scroll through the list of available fields until you find the Students section Drag the Student Gender field over to the Layout panel under Columns The report will refresh and add columns for both Female and Male In addition it will add grand totals for both columns and rows Right click on the word Score over one of the columns In the pop up menu go to Conditional Formatting and choose Color Scale Green Yellow Red The report will refresh to color the individual cells based on a color scale of Green being best Yellow being average and Red being worst What if instead of looking at the data based on gender we want to view it based on disadvantaged or homeless status In the Layout panel click on Studen
25. s to group the fields into appropriate blocks like in some of the other tools You can see all the available fields under the Data tab in the left column Click on the Formatting tab in the left column The options here are grayed out because we do no currently have anything selected Once you start adding data to the report you can use this table to format the font alignment color etc Click on the General tab in the left column next This tab allows you to select a template for your report You can also turn the tooltips back on that we turned off earlier in the exercise Click the Select button under Template to bring up the list of available templates 14 STEDFast Admin User Manual Interactive Report 12 Use the arrow to scroll to the right until you find the template labeled Indented Cobalt Click on the template to select it and go back to the design screen You will now have a blank report reflecting the template that we just chose We will now start customizing the report 1 To get started we need to give the template a name Double click where it says Untitled to pop up a box to edit the report name Type in Average Scores by Teacher In the left column of the interface click the tab labeled Data to display the available fields once again Formatting General Al bid sta iss 15 STEDFast Admin User Manual 3 Scroll to the bottom of the list of fields until you see Teacher Last Name
26. ser Interface The STEDFast user interface should be familiar since it is based on standard concepts of other computer programs you are already using File Menu New Generate new reports Open Saved reports Save Save current report for later use Manage Work with your saved reports Properties Log Out Logout and exit STEDFast STEDFast Admin User Manual View Menu e Browser Show or hide the folder browser for saved reports e Workspace Show reports that are queued up e Use Descriptions for Tooltips Shows small popups over user interface elements e Themes Change colors and skins e Language Change language for interface e Refresh Reload the current view Help Menu e Documentation See the built in online user manual e Pentaho Com Visit the software vendor s website e About See information about the current version Toolbar ge Q oo e en PS EEE G ae a ee EEE EEE q an STEDFast Admin User Manual Chapter 2 Premade Reports Several reports have been premade based on input from principals and administrators These premade reports make it easy to quickly get information in a predesigned layout and template Some of the reports are customizable to enable you to look at data in different ways If you have ideas for other premade reports please let us know There are three types of premade reports available in STEDFast Interactive
27. t Gender and then start dragging it towards the bottom right of the screen A trash can appears as you drag the field Drag Student Gender into the Trash Can to erase it from the report In the list of available fields find the Students section again Drag the field labeled Disadvantaged Students over to the Columns section of the Layout panel The report will refresh to add columns Disadvantaged and Non Disadvantaged students Find the Homeless Students field under the Students section and drag it over to the Layout panel immediately under Disadvantaged Students The report will refresh to add Homeless Students as another column heading What can we tell about Disadvantaged Students versus Homeless Students Drag the Homeless Students field to the trash and drag Neglected Delinquent Students over the to the Layout panel immediately under Disadvantaged Students What can we tell about Disadvantaged Students versus Neglected Delinquent Students Finally let s add a filter to narrow down the data 1 Click on the Funnel icon to display the Filters window 21 STEDFast Admin User Manual 2 Inthe list of available fields scroll down to School Year Quarters and drag Term over to the Filters window 3 Inthe box that pops up select 2011 2012 and click the right facing green arrow to move it over to the Currently Included side and then click OK 4 The report will update to only show the included term You will now save this report fo
28. ted to benchmark testing using Moodle Benchmark Test Table This table contains information about the benchmark tests e Benchmark Test Name Name of the benchmark test in Moodle normally the subject plus period e Benchmark Test Period Period benchmark test was taken i e 1 9 weeks e Benchmark Test Grade Level Grade of the benchmark test N A for end of course tests e Benchmark Test Subject Subject of the benchmark test similar to SOL test subjects e Benchmark Test Question Text The text of the question not available for all tests and not easily readable for those where it is available e Benchmark Test Question Type The type of question i e multichoice e Benchmark Test Question Source Where the question came from i e teacher created released SOL question etc e Benchmark Test Question Name The name used for the question in Moodle can be used to match up scores by question with the actual test question in Moodle Course Table This table contains information about the courses e Base Course Number The main course number from PowerSchool e Block Courses Is the course a block course Block or Non Block e Distance Courses Is the course a distance course Distance or Non Distance e Elite Courses Is the course an Elite Learning course Elite or Non Elite e Emory and Henry Courses Is the course an Emory amp Henry Course Emory amp Henry or Non Emory amp Henry e Governors
Download Pdf Manuals
Related Search