TCRWP AssessmentPro Data Specialist User Manual Getting Started
Contents
1. the kachers Colle Reading Whiting t TCRWP AssessmentPro Data Specialist User Manual Getting Started Step 1 Sign in Open your internet browser and enter the following URL into the address bar https www rwpassessments com This is the welcome page for the AssessmentPro system Here you can find helpful links and information regarding TCRWP assessments This is also where you will go to login to the system Your account has been created for you Please follow these steps to log in 1 You will notice a login when first entering the TCWRP AssessmentPro site If you know your password a Simply type your full email address into the email address field Be sure this is the same email address that you have used to correspond with TCRWP regarding AssessmentPro and enter in your password Both your email address and your password are case sensitive If you are first seeing the TCRWP AssessmentPro site for the first time and do not know your password a Click on Forgot your password 5 CAES l ce 5 rojet a s a amp Waitt al C ry eat wet Welcome Email Address The Teachers College Reading and Writing Project welcomes you to Password TCRWP AssessmentPro the web based data platform that supports our many reading assessments To log on simply enter your email and password above If you do not yet have an account click register in the upper right hand corner of the screen If you2. 999999990 999099999 999999999 999999999 999099999 999999999 999999999 999099909 999999999 999990099 999999999 999999990 999999999 999999999 999099909 999099999 999099999 999999999 999099099 999099999 909990990 909999909 909999999 909999999 999099999 999099099 999909090 909990990 909999999 You may be asked if you wish to continue to save the file in CSV format due to some incompatible data Select Yes 13 13 13 Save in My Recent Documents S SampleAssessmentData_LF xls Bal Selection_Schools_1001 exis Hd Shortcut to Dominion_Digital My Documents 3 Shortcut to WritingProject on tcdataDepartments w My Network File name Sample Assessment Data 2007 2008 xls x Places Save as type Microsoft Excel 97 Excel 2003 amp 5 0 95 Workbook xlIs z Microsoft Excel 5 0 95 Workbook xls Bees Excel 97 Excel a amp 5 07 95 Workbook SY Co na de nited 1 csy Microsoft Excel 4 0 Worksheet xls Microsoft Excel 3 0 Worksheet xIs QOTO mmmn nOn 0an oOo oO wm e oT oao oaan moonman m oml Glo lOO 6boogooocoocooooooooocooooognooooogooooooooonooo Be sure to remember where on your computer you are saving each of these files A suggestion is that you keep these files in a folder titled AssessmentPro You will need to know the location to import them into AssessmentPro Step 4 Import your data files On the Data Specialist homepage click on Administration in the top navigation bar hi
3. CAMARRO ELIZA ecamarro schools nyc gov eacher schools nyc Teach DAY MARCELLA mday21 schools nyc gov eacher duncan schools nyc gov Teacher DUNCAN INGRID virank schools nyc gov Teacher FRANKENBERGER VICTOR afueri2 schools nyc gov ae FUER ADRIANE jgreen32schools nyc gov Mear GREEN JONATHAN Igriffis22 nyu edu Data Specialist GRIFFIS LORI thaines123 schools nyc gov Teacher HAINES LUPE hinken schools nyc gov Teacher HINKEN REVA jordan12345 schools nyc gov Teacher JENKINS JORDAN johns234 schools nyc gov Teacher JOHNS LAWANA Littlefield schools nyc gov Principal Assistant Principal LITTLEFIELD MARYELLEN moore22schools nyc gov Teacher fica 4eia s MOORE CAROLINE morland22schools nyc gov Teacher MORLAND KACIE RAYBOULD DARCI raybould schools nyc gov Teacher sandb schools nyc gov Teacher SANDBLOOM DESEREE SANCHEZ SARA sanchez schools nyc gov Teacher sander 5 chools nyc gov Teacher SANDERSON MINNIE Access Management Page Pending Registration When new users in your school register themselves you will receive an email about their registration requests Their information will appear on the top half of the following screen under Pending Registration You may choose to Accept or Reject any person s registration If you accept him or her the new user will receive an email confirmation You may also change t
4. If you notice that classroom assignments are not accurate see the classroom management section of the user manual 15 Add a New User Important The DOE asks us to remind you that data specialists must get approval from administration before adding a new user New Users can register for AssessmentPro in one of two ways 1 Anew user can register his or herself by clicking on the register link on the AssessmentPro login page see next page When this happens the user will show up in your list of Pending Registrations where you can either approve or reject the user If you accept him or her the new user will receive an email confirmation You may also change the role the user selected before granting them access For example if one of your teachers accidentally signed his or herself up as the principal you must correct that information here before giving the teacher access Welco me Email Address The Teachers College Reading and Writing Project welcomes you to Password TCRWP Assessment the web based data platform that supports our many reading assessments To log on simply enter your email and password above If you do not yet have an account click register in the upper Forgot Your right hand corner of the screen If your school has signed up for the OIF Password Click TCRWP assessments and this web based data system your data specialist Here Will be able to validate your registration If you are a NYC school and you are
5. interested in the TORWP Assessment you can access those at https rwproject te columbia edu If you are a NYC school interested in TCRWP Assessment this web based data platform please have the data specialist for your school contact the DOE at periodicassessmentischools nyc goyv If you are outside of NYC and are interested in this platform contact us at readingandwritingpro tc edu You may preview the reports and pages of this platform at our website at httos frworoject te columbia edu Simply click on the link for TOR WP Assessment Preview Announcements Upcoming assessment workshops at TCRWP August 28th and September 23rd Status Report for TCRWP Assessment Currently members may log in register create classroom rosters access student data enter current reading levels and view student history pages To receive assistance entering additional missing data on students please contact readingandwritingpro tc edu to get a data template before September 15th After September 15th schools will be responsible for entering this data manually Check in on October 25th for updates on printing charts and graphs and doing a mail merge for a parent letter for report cards Homepage 2 A data specialist also can add a new user by clicking on the Add a New User button from either the Access Management or Teacher Management screens in Administration Clicking OK will save the new user s information in all applicable places th
6. atch Column Headers to TCRWP Fields Your Column Name TCRWP Field Name Student ID Ignore Field ne NOVEMBER Independent Reading Level S a MARCH Independent Reading Level JUNE IndependentReadingLevel ConceptsOfPrint Custom Assessment 10 LetterIDSoundsLower DBN Student ID LetterIDSoundsUpper Ignore Field LetterIDSoundsSounds ignore Field WordList Ignore Field x WordListB Ignore Field x Import School Data Step 4 10 Be sure to pay close attention to the type of TCRWP Field Name For Independent Reading Level it is important to choose IRL and not IRL Benchmark or IRL Help Text Doing so will record you data in the wrong places throughout the system Please ask questions in the user forum if you feel as though you need more clarification on the field names Importing Data Step 5 Import Results AssessmentPro will tell you which data was successfully imported into the system and which data had errors There can be up to three links on this page e View and Save General Clicking on this link will generate a report that tells you WHY any rows of data were rejected e View and Save Success Clicking on this link will generate a CSV file that contains only the rows of your data file that imported successfully e View and Save Failure Clicking on this link will generate a CSV file that contains only the rows of your original data file that were not accepted by the system You can open this file cor
7. ding Level IRL IRL Benchmark Reading Accuracy g6 Reading Fluency Select Optional Reading Comprehension Select Optional Non Fiction Reading Level Select Optional 5 When you have completed entering in all the data for that student please make sure that you press save at the bottom of the screen The third way to enter your schools data is by using a Teachers College Reading and Writing template to import your data from a spreadsheet into Assessmentpro The template contains all the assessments that TC offers and no you do not have to give or enter every assessment The only mandatory items are school id number DBN student id number and independent reading level The other assessments such as concepts of print letter sound letter id etc could be entered at your discretion but remember the more data entered the more information you will have on your students Here are some steps you must take to prepare your data files on the teachers College template for the import process It is important to note that your data will not upload properly if you do not prepare each document in the following way 1 Take out the description row this row will only exist if you are using a template provided by TCRWP Highlight row 2 of the template where the descriptions are located Do this by clicking on the number 2 Delete the entire row by right clicking on the number 2 after you ve highlighted the row and selecting delete T
8. e 2007 step 2 Locate Your Data F sentember 2007 November 2007 7 March 2008 PL es September 2008 November 2008 March 2009 View a sample assessment data file June 2009 View a sample school data file coe E Import School Data Step 1 e Importing Data Step 2 Locate Your Data File This process is very much like attaching a file to an email Click the Browse button to locate your data file This is the file that you created using a data template in Microsoft Excel AssessmentPro will connect to your computer network so you can select the appropriate data file Clicking Open will populate the browse field with the file name Step 2 Locate Your Data File Choose file ILo ee Lookin SempeDts eaae Fe El Sample Assessment Data 2007 2008 cs SF Sample Assessment Data 2007 2008 xls View a sample assessment data View a sample school data file My Recent l sample xls Documents SF SampleAssessmentData_LF xls es SampleData csv In order for a file to import successfully Ne Desktop cannot be any spaces or periods in your file name November 2008 csv will NOT be accepted November 2008 csv will NOT be accepted My Documents November2008 csv WILL be accepted New York City Schools should only be importing TCRWP Assessment information All other information is imported for you If you still choose My Computer to import class assignments all students will be unassigned from a
9. g Student Prog ress Assessment A EE Student Student ID f Date of Birth Gender Ethnicity 3 Once in the TC Assessment window you can enter any and all data All you need to do is to scroll down in the under the proper assessment and its categories Assessment Window November 2009 Student v 4 TC Assessment Reading Level Reading Level IRL N v IRL Benchmark 4 Reading Accuracy 96 M Reading Fluency Select Optional v Reading Comprehension Select Optional vi Non Fiction Reading Level Select Optional These readers are progressing nicely so now is a good time to support deeper comprehension One thing you might want to do is introduce your readers to N level books As a benchmark 4 reader you might want to guide your students to hold onto information and synthesize the information as they read by working with a partner They could say to themselves So here is what I am thinking and answer each other by saying Here is what I just read Help Text Concepts of Print Letter ID Letter Sounds High Frequency Word Tests J Oral Words Per Minute Primary Spelling Inventory Elementary Spelling Inventory Upper Level Spelling Inventory Writing Assessment Custom Assessment Fields 4 Again please make sure that you are in the proper assessment window Assessment Window November 2009 Student TC Assessment l Reading Level Rea
10. ghlighted below Or click on Data Management under Administration on the right hand side of the screen CNS m l rE z 2 Pat v oea cot gt A oj A A y YY a 4 nj 4 i gt K a c4 L 2 gt P S i x Go gt Assessment September 2008 w Current Window o i Benchmark Administration Go User Management 4 Student amp Classroom Management Data Management Assessment Management Resources Go Knowledgebase User Forum Glossary Getting Started F User Manual Classroom Level Information Select a Classroom Search for a Classroom OR by Classroom Name gt gt O by Teacher s Last Name Search l Clear On the Administration main page click on the Import School Data link highlighted below Administration User Management User Administration Page There are 5 steps to importing your data Importing Data Step 1 Identify Data Period Use the drop down list to select the assessment month and year for the data you are going to import Choosing the wrong assessment period here will record all of your data in the wrong place for all reports It is VERY important that you carefully choose your assessment period in step one a os E d ia w Administration User Forum Import Data a Return to School Administration Step 1 Identify Data Assessment Window Nowember 2008 September 2006 November 2006 March 2007 Jun
11. hat row does not belong there It was just added to inform you of the numbers that you may have in each section Oy a SampleAssessmentData ver_2 1 Compatibility Mode Microsoft Excel ox Home Insert Page Layout Formulas Data Review View a I Lid ar saan St Arial jio jA p Wrap Text General z Hl rA G CE i 2 Autosum Ay F 23 copy aaa oS a Fin Z Paste 8 ea aed SSE FES CE v 9 Conditio AE Sea In ee x Spie in J Format Painter B z u Ee F S S E H Merge amp Center o 9 60 328 Formalin ae s Table Styles lt 2 Clear Filter Clipboard E Font Alignment ts Number E Bin Cells Editing A mand E e C eT E E Ga 2 Please make sure that after you take away the description row you put in all data in the appropriate row under the right name 3 Please also make sure you include your DBN number for every student record in the file 4 Add an Ignore column After all your data is entered scroll all the way to the right of the document until you reach the end of the title row the next available column In the very next row type ignore Enter zeros into all the cells in that row for as many student ID numbers that you have in the document for example if you have 401 student records you will paste in 401 zeros in the ignore column The reason for this is because the database needs to know that you may or may not have filled in all the parts of the tem
12. he role the user selected before granting them access For example if one of your teachers accidentally signed his or herself up as the principal you must correct that information here before giving the teacher access 13 Schoolwide Access Privileges The lower portion of the page Schoolwide Access Privileges enables you to view the name email address and role of each user You can sort by any of these fields to easily locate and access the profile of any particular user You can also edit that person s information including their role by clicking the Edit button Teacher Management To view a list of all users in your school and see which classrooms they are assigned to click on Teacher Management The Teacher Management section allows you to quickly make sure that all classroom assignments are correct and accounted for If you notice that teachers are missing see the adding new users section below Administration User Management View Edit User PEO Data Management Import School l Export School Assessment Management Define Custom Administration 14 Teacher Management Return to School Administration Name Email Address Classroom Name Students CAMARRO ELIZA ecamarro schools nyc gov 104 18 Gx pep e u e o lL a E E E m m gt e e F e E e a a e y a a a p e i a a a gt a SANDERSON MINNIE sander schools nyc gov Teacher Management
13. ick is one you will remember e After entering the information return to the AssessmentPro screen Enter your login information this will be an email address and password 2 Click the blue login button to continue Step 2 Change your password email Once you have logged in you will be brought to the Data Specialist homepage Click on the Edit Profile link highlighted below se lies PT P ac owe O Walo a Canes aa E Th to oF aye P 7 A Lt r D i aw g k a S O i 4 Wit l i Pai teal felcome Janet steinberg Sehool Project 4aminmstration ser Forum Edit Your Profile First Name First name is required Last Name ee Last name is required Primary Role TC Administration ed Under Edit profile you have the ability to change your information by simply clicking on that field and writing in whichever information you would like to use Then press save Step 3 Enter your data Remember before anything shows on the homepage for the present benchmark period you need to enter your data for that period If you want to see old data you need to make sure you Select the appropriate period in the reports There are three ways to enter data into the system The first way to enter data could be done by your classroom teachers or by you Allowing teachers record information is important because the teachers will see their data and be able to use it for instruction 1 Go directly to
14. ll classes before new am assignements are made This action cannot be a oe Taam File name 7 Places Files of type all Files 7 Ls Import School Data Step 2 e Importing Data Step 3 Identify Type of Data By choosing which type of data you are about to import you are telling the AssessmentPro system where to store this data e Be sure to choose TCRWP Assessment Choosing Class Assignment Information will un assign the students in your school from their current classes this action cannot be undone e Assessment Information will update create assessment scores that are used in student profiles and in generating reports Select TCRWP Assessment State Assessment information is for importing state test scores Click Next to import your data file Step 3 Identify Type of Data Student and Class G TCRWP Assessment State Assessment Import School Data Step 3 e Importing Data Step 4 Match Your Data You will now be prompted to tell the system which columns in your file match the required TCRWP Field Names Carefully matching your column headers as shown below to the required Field names will ensure that your data is represented properly This step tells the system where to save each piece of data When you are sure that your data is properly represented click Import Data gt i P Kowt i OG ij i 7 Import School Data Return to School Administration Step 4 M
15. plate and the zero is a signal to ignore anything that isn t there Fy Microsoft Excel Sample Assessment Data 2007 2008 xls File Edt View Insert Format Tools Data Window Help Adobe POF Type a question for help X DSGEBSIEGRIV EG 4 BB JA O 5 4h Fl GB te Ofira TO B 7 UEZ ho El A Ar arkal Al fe Ignore ee 1 Student ID JUNE IndependentRea ConceptsOfPrint LetterlDSoundsLower 999909997 D 13 999999999 f 13 999999999 J 90920999 ERRE EREK 999999099 499099999 EEEREN EE l l D mMm oD OO cs es oa ea 5 Save your data file as a CSV document The AssessmentPro system will only be able to read your data files if they are saved in a CSV format Once you have made the above changes save each file in the following way a Click File and Save As b Inthe Save As box that appears look for the save as type selection box Scroll down and choose CSV format c Inthe file name field be sure that your file has no spaces or dots in the name EJ Microsoft Excel Sample Assessment Data 2007 2008 xls 18 x B9 Fie Edit view Insert Format Tools Data Window Help Adobe PDF Type a question for help v f X DBE RBSBIGg Bl AaB FJI M 3 4X he B 100 Bara El Pe E AW v amp Ignore E F a ID JUNE IndependentRea v ConceptsOfPrint _x LetterIDSoundsLower 999999999 D 13 999999999 13 999999999 13 999999999 11 999999999 13 999999999 999099999 999999999 909999999 999099999
16. r school has signed up for the TCRWP assessments and this web based data system your data specialist will be able to validate your registration To access user manuals for data specialists administrators and teachers please go to the knowledge base section of this system once you log in If you need to access the TCRWP Assessments visit http rwproject tc columbia edu If you would like to access the quick start guide which will help you quickly get started using the system please click here Announcements Urgent Upcoming Workshop for Data Specialists at the Teachers College Reading and Writing Project October 28th 9 am 2 pm At this workshop vou will learn how to manage vour data now that the svstem is live You will learn to manage users add new users sort classroom b Type your full email address into the email address field Be sure this is the same email address that you have used to correspond with TCRWP regarding AssessmentPro c Please then go onto your email There you will receive a message from webmaster If you do not receive a message from webmaster within a few minutes be sure to check your junk mailbox d Please open the email from webmaster and scroll down to the first link on the page and click on that link You will automatically be taken back to AssessmentPro where you will be asked to write your email address again and pick a password Word of caution make sure the password you p
17. rect the errors save it and then import this file to correct the rejected rows Import Data Return to School Administration Step 5 Import Failure Click the links below to view the errors that were found in your CSV file View and Save Bad Record file Import School Data Step 5 11 Step 5 Manage Users A user s role will determine their level of access to data throughout the AssessmentPro system e Teachers Specialists are able to enter and access their own classroom data only e Principals Assistant Principals have access to school wide data and reports in addition to classroom and student information e Data Specialists have access to all aspects of the system for the school As a data specialist you manage and assign these roles in the Access Management feature It is important that there is only one person per school that has this responsibility due to consistency and accountability You must receive authorization from vour principal administration before granting users school wide access assigning someone as a principal or as a data specialist View Edit User Prone Data Management Import School Export School Assessment Management Define Custom Fields for Administration Main Page 12 Access Management Return to School Administration Pending Registration Requests Schoolwide Access Privileges Name EmailAddress Role c i s T
18. roughout the system AssessmentPro will send an email to the new user with a log in procedure A teacher will be able to enter and access his her own classroom data once the data specialist has approved him her as a new user 16
19. the classroom section of Assessmentpro Classroom Level Information Select a Classroom Search for a Classroom OR by Classroom Name yY O by Teacher s Last Name Css clear th p 2 When you are in the classroom please go to the top tabs and click on Quick Edit Managing Your Classroom Quick Edit 3 All you have to now is to enter your data When you enter your data please enter it in the IRL column not the reading level column Quick Edit Assessment Window November 2009 Last Reading Assessment IRL Student Name Level Date IRL Bench 11 6 2006 4 11 6 2006 4 11 8 2006 113008 2 11 6 2006 4 11 8 2008 z 11 6 2006 4 Also make sure you are in the right assessment window If you are entering September data then please enter it in September 5 You can also enter in data for accuracy fluency comprehension etc 6 Please make sure press save at the end to save your data rif cle rif Save The second way to enter data is to go to the individual student reports 1 These reports could be found by simply going to roster in the classroom section and clicking on a student s name Classroom Roster Student Name Date of Birth Grade IEP 2 13 2002 2nd Mo ap e Os 2nd Mo Trza 200z end Mo 10 2 2002 2nd No 6 21 2002 2nd Mo 2 Once you click on a student s name you are taken to the student s profile Please go to the upper tabs and click on TC Assessment Ma nag i n
Download Pdf Manuals
Related Search