West Contra Costa Unified School District



Option 2: Power School Instructions (Creating your Student Roster)Open a web browser (Google Chrome, Mozilla Firefox, or Internet Explorer)If you are a teacher type : you are an admin type: you have successfully logged-in, you will be at the “Start Page”54762406127750057626255721300Type this in the search box: grade_level in 3,4,5,6,7,8,11Click the blue search button & the total student count will pop upClick the blue “Quick Export” buttonYou will be at the “Quick Export” page414020216535005452110126047500 Type the following fields: State_StudentNumber, Last_Name, First_Name, Grade_LevelClick “Submit”The following window will open up285273815925800074771213544550047561538417500Choose the location where you want to save your document-preferably on your desktop for easy accessClick “Save” (DO NOT CHANGE FILE’S NAME OR TYPE)A “student.export.tex” tab will appear on the bottom left hand corner – IGNORE/DO NOT OPENSign out of Power SchoolGo to your computer’s local disk (C:) to find the “student.export.text” (or wherever you saved it)Right click on it, then choose “rename”Change the file extension from “.text” to “.xls”A window will pop up asking you if you want to change the name 200501356261000Click yes Your document icon will change from a white to a green excel iconOpen the document. A message will pop up, letting you know that the file is in a different format and asking you if you still want to open the document321945045116800Click yesThe list of students will pop upGo to the “file” tab and then “save as” A window will pop up:4057650246507000104774917840340058102479883000Choose desktop (or your preferred location for saving this document)Type a file name; an example is “SBAC_Student_Cards_Date_2015”Change the “Save as type” from “Text (Tab delimited)” to “Excel Workbook”SaveIMPORTANT STEP: Add “CA-“(CA plus the dash) in front of every student SSID . You may do so manually or you may use the following concatenate instructions. This step will generate the correct SSID # on the student cards which they need to log onto their SBAC test.CONCATENATE INSTRUCTIONS:Open your saved excel student rosterHighlight Column A by clicking your cursor on the A at the top of the column, then right click & choose insert. This will add a blank column to the left, which will now be named “A”Put your cursor on cell 2 of Column A & type “CA-“Position your cursor on the bottom right of this cell until a black cross appears. Left click your mouse & continue to hold it while dragging your cursor all the way down to the last student record. Let go of the mouse and the whole column A will now be populated with “CA-“Go to the top of the pageHighlight Column A, right click & insert. This will create another blank column to the left, named “A”Click cursor on cell 2 of Column AGo to “Formulas”, then “Text” and then “Concatenate”A window will appear. Click on the grid icon of “Text 1”, place cursor on cell B2 & close the box with the XClick on Text 2 grid icon, highlight cell C2 & close box with the X Click Ok. The merged data will appear on cell 2 of Column A (CA-SSID #) Drag cell 2 of Column A, as in #15, all the way down to the last student record in that columnHighlight Column A & right click & copy. Right click again and click paste (choose the icon that is a 123 clipboard). This way, we see the values on the function bar (fx), as opposed to the concatenate formula.Delete Columns B & CClick your cursor on cell 1 of Column A & type “SSID”To save document, go to “File” and then “Save”.You are done and can now use this excel document (student roster) to do the mail merge for the SBAC student cards. Go to and locate the “Mail Merge Tutorial for Student Cards” under “CAASPP/SBAC Online Resources.” ................
................

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

Google Online Preview   Download