IMPORTANT
Contents
1. sword If you have use the input box below to i lt forward this information 0 yot aaa H at E A mh Pape as a 3 Contact Cathy Hafer at Extension 3149 or haferc bedford k12 pa us m Main Menu After logging in you will be at your districts CDA Main Menu screen The left menu bar contains navigation links for Querying Data Quick Reports Editing Tables Changing Passwords User Administration PSSA AYP Report Student Ledger Uploading Importing Data and Workshop Videos To log off the system click on Log Off located at the top of the screen in the green menu bar The center of the screen displays the current login information including the user name and organization and all the access capabilities of that user The Last Import column to the right of the table list denotes the date when data was last imported to the database and the Records column Figure 5 Menu Screen District N 6 information User Manual User Jennifer Ross Te a Reference District Jupiter11 Area SD Last Import Raspas i Current Demographics STUDENTINFO0405 ATTMOB0304 R 15 22 2004 7 ATTMOB0405 R 1 11 2005 CBA0304 W 5 22 2004 i RNN Ena CBA0405 R 1 11 2005 DIBELS0304 R 8 4 2004 Quick Reports DIBELS0405 R 16 3 2005 EE a DISCO304 R 5 22 2004 Old Query DISCO405 R 1 11 2005 ss pce ick dana IST0304 W 5 22 2004 CDA Edit Tables ISTO405 R 4 11 2005 Navigation F MATHCPP0304 R 5 22 20042. i Change Your Password MATHCPPO405 R 1 11 2005 Links a PSATO304 R 5 22 2004 User Administration PSSA0304 R 8 4 2004 PSSA0405 R 8 8 2005 PSSA Report PSSA11W0304 R s 8 4 2004 S PSSA11W0405 R 8 8 2005 Student Ledger PSSA12RM0203 R 11 11 2005 cu PSSA12RM0304 R 2 24 2005 Upload Import Data PSSA12W0203 R 1 11 2005 mee Se PSSA12W0304 R 2 24 2005 Workshop Videos PSSA3RM0405 R 8 28 2005 Table Name o frades _ Buildings Teachers AIU CDA 92 2 User Manual 3 Revised 7 2006 Changing User Passwords Passwords should be changed on a regular basis to prevent security breaches and to ensure d protection and accuracy 1 Log onto the system using your current password Choose Change Your Password link from the left menu bar Enter current password in the first field Enter the new password in the second field Confitm the new password by retyping it in the third field Click on the Submit button Hn PON Figure 6 Change Password Screen Enter your old current password a new password repeat the new password in the Confirm Passwo Name Last Name and Email then press Submit Login ID Old Password st New Password f y Confirm Password EmailAddress First Name First Last Name 7 Click Main Mente a to return to the Main Menu screen Updating Your Email Address Please take a moment to update your email address after you have completed changing your password by adding it to t
3. IMPORTANT CDA is equipped with a 20 minute logout feature to protect your data in case you leave your computer unattended A seconds remaining counter appears in the lower left corner of your browser s window to let you know how much time is left before the system logs you out The counter restarts every time the user clicks Submit or navigates to another page SECTION I GETTING STARTED Accessing the CDA Web Site The CDA database is easily accessible from any computer with an Internet connection regardless of the user s opetating system Because the system is web based data is available 24 hours per day every day 1 Open the Internet browser CDA requires Internet Explorer 5 0 or higher or MAC v 10 2 Type the database URL in the Address block in the navigation menu https cda aiu3 net OR Click on the File drop down menu and choose Open Type the URL in the window and click OK Atthe CDA home page the user has the option to explore the site or to log in 3 To log in to the system select Log into CDA from the left side of the window Figure 1 CDA Website ppup Log into CDA ATU CDA 2002 User Manual Reviced 7 2006 Allegheny Intermediate Unit 475 East Waterfront Orive Hortestead PA L53120 Phone 412 354 5921 Comprehensive Data Analysis for School Improvement CDA for Registered Users Quick Query 2 Reference Sheet Retrieve d
4. STUDENTINFO0405 INNER JOIN PSSA0405 ON PS04038 5104001 WHERE 5 AND PS04025 lt gt 4 ATU CDA 2002 User Manual 16 Revgiced 7 906
5. ata quickly amp efficiently Make decisions with fact driven precision Overview of the CDA Project The amount of data that flows through schoo districts can be overwhelming making it difficult to target the information that decision makers need Now districts can quickly and efficiently share information that is critical to improving student achievement The Allegheny Intermediate Unit AIU3 developed a web based data collection management and reporting system to assist schoo districts in organizing and using their data for informed decision making Using CDA schools can make informed decisions about curricula stratagic planning and school policies through systematic data collection and analysis which positively impacts the school s physical social and leaming environments COA Resources CDA Update vpdstedi CDA FAQs Brochure Choosing a Data Warehouse System CDA Start Up Screen The next screen that you see after you Log into CDA from the CDA website is the CDA Start Up Screen The information displayed on this screen includes system updates changes and other systems related information To access the CDA Log In Screen Click on the blue Login to CDA link located on the left side of the window gt Figure 2 CDA Start Up Screen Oe sh inih mer aire A mi ah bee eae ie a L A aA be mmli l a eee E a E ee e ee A a Login to CDA DA Program Updates and Changes last updated 4 30 2006 If you re
6. cieve the IE security warning message This page contains both secure and nongecure items Do you want to display the nonsecure items you can disable this behavior by doing the following a In your web browser go to Tools Select Internet Options from the drop down menu 3 Click on the Security tab 4 Click on the Web content zone you use to access the Site IE Configuration S Click Custom level 6 Scroll down to find the heading Miscellaneous 7 Find the eons Display Mixed Content 8 Click Enable 9 Click OK 10 In response to Are you sure you want to change the security settings for this zone click Yes 11 Click OK to close the Intemet Options box Quick Repons p simpler interface for retrieveing PSSA and other assessment information This module is active however we are in the Quick Reports Quick Reports process of ena all of its features on an individual district basis If you have a more urgent need for this function please let us know Logging In To CDA Figure 3 CDA Log In Screen ease enter your user name and password userName Sd Password Use Manual Rererence Helpful Hint User names and passwords are case sensitive 4 At the login screen enter your user name and password and click on the GiccSubmit button ATU CDA 2002 User Manual Danada TIME User name and Password Have you forgotten your CDA usert name and pass send us your last name and email address and w nw
7. h Performance Level Code teanaoas is Not Equal to O Click to highlight the field you wish to filter A Select a Comparison Type from the drop down list Is less than Is greater than etc B Select a Common Value from the drop down list selections in this drop down list depend on the field you have highlighted If there are no common values you can type a value directly into the Comparison Value field C e Choose a relationship AND OR See page 20 for an explanation of data relationships By clicking to highlight AND OR D NOTE When building a basic query most filter relationships are AND e Select the appropriate AND OR the Student button in the Group 1 or Group 2 filter box and click on it to set the filter E NOTE Multiple filters can be set up in the same Group 1 filter box e Filter selections can be easily removed from the Group 1 or Group 2 filter box by double clicking on it to delete Click on the Submit Query button F AIU CDA amp 2002 User Manual Reviced 7 7006 Query IT Results Green Menu Bar Details Stats Charts Analyze Create PDF Save Query e Details query results records rendered in a report format example below e Stats displays a quick statistical summary of mean median standard deviation min max range and variance for the total records displayed in the query results Charts displays in graphical form categorical data results using a Bar o
8. he Email Address field located on the Change Password Screen Your first and last name will be automatically furnished by default Note Ifyou do not elect to update your email address after you change your passw CDA will periodically remind you to do so You will see the following message Microsoft Internet Explorer amp We do not seem to have an email address for your account Please use the Change Password function to enter it AIU CDA 2002 User Manual Revgiced 7 9006 SECTION IV QUERYING STUDENT DATA Query II Getting Started Adobe SVG Viewer must be installed on your PC in order to view the reports that ate generated by query Click on the link below to access Adobe s SVG Viewer download page then follow the instructions to complete the download Like Adobe Reader this softwate is available at no cost and it is available for both Windows and MAC operating systems http adobe com sve viewer install main html Generating Queries There are two ways to generate query results 1 by retrieving a saved query or 2 by building your own query From the CDA main menu screen choose the Query IJ navigation link from the left menu bar From the Query II screen you can either 1 choose a saved query or 2 build a new query Choose a saved query by clicking on the blue hyperlink in the sort by Date column Figure 15 Query II Screen 1 Bain Planet Calert Cahani Voara 3 MaN Hent Seie e
9. ol year The user wants to look at 5 graders who did not score Advanced 4 on the PSSA in Mathematics e The user ONLY wants to view data for students in Grade 5 so he she adds the filter is Equal to 5 e The user ONLY wants to view PSSA Mathematics Performance Codes 1 2 and 3 Below Basic Basic and Proficient so he she adds the filter is Not Equal to 4 Figure 18 Filtering Queries _ AND the Student _OR the Student be STUDENTINFOOSOS Grade 5104013 ig Equal to 5 E il Hen S i pe PSSA0405 Math Performance Level Code PS04025 is Not Equal to 4 AND i Calculate a percentage based on Ra Include students with missing records ry AIU CDA 2002 User Manual 14 T aeea TAANE How to Apply Filters to your Query Figure 19 Applying Filters W ables and fields available ____ DIBELSO405 PSSA0405 Fields selected JSTUDENTINFOO4S0S5 StudentID S10460013_ st tt i ld STUDENTINFOO405 Last Name S104002 eeeeeee STUDENTINEOO405 First Name PSSA11W0405 PSSA3RM0405 STUDENTINFOO405 TUDORS coe AADAC tach Parlormance Unvel Cote TpEOaGast __ Pie Chare PSSA0405 Mathematics Performance Level Name PS04058 __ Pie TLN LLII PSSA0405 Mathematics Scaled Score PS04059 Seats O 6 0 eNO oS ihes std ert OR the TT a See ISTUDENTINFOO4OS Grade T1040 13 js a Goual to AND PSSA0405 Mat
10. r Pie Chart e Analyze Use Stat Crunch for more advanced statistical analyses correlations inferences linear regression and more Create PDF generate print or save a clean orderly report of your queried records Save Query File the query report as a Saved Query in CDA Blue Menu Bar e Jump to page options for easy navigation through the pages of query results records Records per page option 25 records are displayed by default If you wish to see more or all of the records choose the number of records to display by using the drop down arrow then click on Records per page Reset Results will reset the results page back to its original state Download Save and file the query report as an Excel worksheet Use the Query Builder button to navigate back to the query builder screen fehl 20 vlna Results Query Builder _ J Pf om a cn gt nalerc roaato DN Cava Minor ae s statis biaiins tnans s MENS anave lied AA Lreate Kur EN T Save puer i he Sh dal ih EN EN EAT are x Dia id eaka 3 aAa O o dle STUDENTINFO STUDENTINFO STUDENTINFO STUDENTINFO PSSA fae 0405 0405 0405 0405 0405 0405 StudentID LastName First Name CUA Math Performance Level Mathematics Performance Level Mathematics Scaled Score ANDONTNMA ORE gt FONI MA a Last command executed was lt br gt SELECT 5104001 5104002 5104003 5104013 PS04025 P504058 PS04059 5104001 AS LEDGERKEY FROM
11. rea to the right of the data field in the Fields selected box To deselect Stats from a field highlight the field then click on the Stats button to toggle off the Stats feature To deselect Bar or Pie Chart from a field highlight the field then click on the Pie or Bar Chart Icon to toggle off the Charts feature AIU CDA 2002 User Manual fp 1 7 4Ans Building New Queries After you have chosen the year s of data to view and clicked on the Build a New Query button you ate ready to move on with building your own query Select a Table by clicking on the blue book icon to open and or close the table When you open a table a list of the data fields contained in that table will display e Click once on your choice of data field the data field chosen will list to the right in the Fields selected builder box Figure 17 Building Queries fs Fields selected _ a pssaosos Gea d STUDENTINFO0405 StudentIO 5104001 FELICE STUDENTINFO0405 Last Name S104002 TUTTLE pssariwoa0s y g STUDENTINFO0405 First Name 5104003 GO Te OO ab pssazrmo405 A stupentimroosos StudentiD 5104001 Last Name 5104992 First Name 5704003 Middle Name 5104004 i Addrass 5104095 Cty 104006 State 5104097 Phone 5104005 Gender STO4005 10 Ethnicity 5104020 21 Birth Date 5104011 12 Building 5104022 23 Grage 5104023 14 Cu Jolum 5704014 Enter Da
12. s Selected Box Fields selected STUDENTINFOO40S Building 5104012 BET Chart STUDENTINFO0405 Gander S104009 TI a Chari STUDENTINFOG405 Frae Reduced Lunch S104027 Pie Chart ee DIBELSO304 End Oral Reading Fluency Score DB030233 Stats Hidden DIBELSO405 End Oral Reading Fluency Score DB04023 ___ Stats Hidden _ SFAREAD0506 4Sight Raw Score BL Test 1 SROSOO2 _ Stats Hidden SFAREADO506 4Sight Raw Score ist Teast 2 SROSOO4 Stats Hiddan SFAREADOSO6 4Sight Raw Score 2nd Test 3 SROS006 Stats Hidden j SFARE4D0506 Predicted Scale Score BL Test 1 SR05003 Stats SFARESD0O506 Predicted Scale Score 1st Test 2 SR05005 Stats 1 amp Sorting priarity Sorting Click to highlight the field to which you want to apply the sorting priority e Click the Sorting priority drop down arrow and select the sorting criteria Charts Select a Pie or Bar chart for a field by clicking on the Pie or Bar Chart Icon Note e Data fields that contain categorical data like PSSA Performance Level Code are automatically set to be represented graphically with a Bar chart e Data fields that contain numeric value data such as PSSA Scaled Scores are automatically se to be represented statistically Stats All sorting priorities Stats and Bar and Pie chart selections appear in the a
13. t SCNOOI Years Select a saved query or select s to build a new query sort by sort by ae sort by sort by Date Description Tables Shared gt a 2 2006 04 21 test 4 aoe STUDENTINFOO405 DIBELSO304 DIBELSO405 jupiteril Yes 2 ZOOG 04 11 Gateprej 4Sight Read Regress STUDENTINFO04053 DIBELSO204 DIBELS0405 SFAREAD0O506 jupiteri1 Yes amp 2006 04 11 Ax GateProj 4Sight Read Prog STUDENTINFO00405 DIBELS0304 DIBELSO405 SFAREADOSO6 juplterll Yes r oot GateProj Dibels amp 4Sight STUDENTINFOO405 DIBELS0304 DIBELSO405 SFAREADOSO6 jupiterii Yes 2 GateProj 4Sight PredScaleScores Bates ent Eee EET for 3rd Bie da STUDENTINF0 405 DIBELS0304 DIBELS0405 SFAREADOS06 jupiter1l Yes oa VF GateProj Dibels Grade 1 amp 2 STUDENTINFO0405 DIBELS0304 DIBELS0405 Jupiteri Yes ie Gee STUDENTINFOO405 PSSA0405 jupiteril Yes amp 2006 01 11 MSP 0405 Demographic ey l 1354 eee APRA STUDENTINFOO405 jupiteriit Yes r 2005 12 07 PSSA 0405 Math by Anchor and ees pice Pia A oes ee a Se a E TEE JOEN 2 0 E O AEE ree To build a new query Select the year s of data you wish to view Click on Build New Query AIU CDA 2002 User Manual 11 A i JAAS Saved Queries If you choose a saved query you can run the query as is by clicking on the Submit Query button from the lower right corner of your screen or you can modify the saved query by adding sorting priorities and or filters Figure 16 Field
14. te 5104015 PPMP PY eer Sorting priority _ E e Move data fields up or down by clicking to highlight the data field then using the up down arrow to move Sorting e Click to highlight the field to which you want to apply the sorting priority e Click the Sorting priority drop down arrow and select the sorting criteria Charts Select a Pie or Bar chart for a field by clicking on the Pie or Bar Chart Icon Note Refer to the image on page 2 Data fields that contain categorical data like PSSA Performance Level Code are automatically set to be represented graphically with a Bar chart e Data fields that contain numeric value data such as PSSA Scaled Scores are automatically set to be represented statistically Stats All sorting priorities Stats and Bar and Pie chart selections appear in the area to the right of the data field in the Fields selected box To deselect Stats from a field highlight the field then click on the Stats button to toggle off the Stats feature To deselect Bar or Pie Chart from a field highlight the field then click on the Pie or Bar Chart Icon to toggle off the Charts feature ATU CDA 2002 User Manual 13 Revicad 7 9006 Filtering Data Applying filters helps you drill down further into the data for more specific detailed results For example A uset is building a new query The user chose data fields from the Student Information and PSSA tables for the 2004 2005 scho
Download Pdf Manuals
Related Search
IMPORTANT important synonym important important numbers important links important documents important information important dates important definition important thesaurus important phone numbers important notes important dates in august important women in history important message from medicare important links uofl important person important html important synonyms in english importante png important medical event list important tailwind important records important cities important and urgent importante significado