School+Testing+Coordinator+Technology+Information


 * Finding Materials on RandaSolutions Sites ||
 * Locating Materials on the Server ||
 * Controlling Pop ups ||
 * Downloading and Working with Spreadsheets ||
 * Creating Folders on Your Computer ||
 * Organizing Email to Work for You ||
 * Using the Calendar to Stay on Top of Things ||
 * Finding Things Quickly In Files ||
 * Managing Testing Resources In Your Building ||


 * For Questions Email: assessment@cmcss.net**

Using __https://tdoe.randasolutions.com__ to f ind materials


 * Finding and exporting demographics data from PowerSchool
 * Sharing Server
 * [[file:I’m an APPLE.docx]]
 * [[file:Win7toServers.docx]]
 * Finding Testing Coordinator Materials Pam has shared go to the staff.cmcss.net server and look in the SHARING FOLDER and then the BENCHMARKS folder.

>> ** In your Microsoft Exchange Account (accessible from any computer via the OWA) ** >> Open Outlook. Right-click on your name (or Control-Click for a Mac) or on the name of the folder you in which you want a sub-folder to appear. Choose New Folder. 
 * Maneuvering within the web browsers / turning preferences on and off
 * [[image:Screenshot 2015-08-03 14.22.17.png width="277" height="113"]][[file:Allowpop-ups_currentURL.docx]]
 * Turning pop-ups on and off to ensure you have access to all information on the site. Look at this example site to demonstrate turning off POP UP Blocker
 * Chrome
 * Firefox
 * Safari
 * Bookmarking websites and updating previously saved bookmarks
 * Chrome
 * Firefox
 * Safari
 * Working with Excel spreadsheets to export data, save files, add and delete fields, sort data, and copy large amounts of data [[file:3 to 8 2015 quickscores.csv]]
 * Saving documents in different formats – csv, xlsx
 * //TIP: The following process works best for opening csv documents from various testing sites. Download the document as a csv type and save the document to your documents folder or a desktop folder. Finally open the Excel Program choosing FILE > OPEN and choose the document you just saved on your computer. This will ensure the document opens in a delimited format for easy manipulation. //
 * //TIP: Freeze headers or rows in Excel to keep headers in view PC_ Excel 2010 or 2013 // //MAC_Excel 2011//
 * //<span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Creating Filtered Reports in Powerschool and Opening them as Excel Spreadsheets //
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">[[file:Opening A Difficult CSV File.docx]]
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">[[file:Creating Filtered Reports in Powerschool.docx]]
 * Organizing email messages related to testing for quick access
 * To help manage your email, you can create folders. These folders can help you separate the mail you must keep from the mail you would just like to keep so you don't overload your inbox. You can use folders to keep mail from your committee at school separate from your email you received from your grade level.
 * [[image:empowerstudents/Mac_NewFolderOL2011.png width="216" height="292" caption="Mac_NewFolderOL2011.png"]] ||
 * Downloading email attachments
 * This process is necessary to fully open a document so that it may be manipulated, otherwise you may just be viewing a preview version of the document.
 * [[image:savingemail.png width="287" height="202"]]
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">When saving documents be sure to leave on the necessary to extensions .xlsx, .pdf, .ppt, .doc
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Using Outlook calendar to add reminders for test dates and other deadlines is a great way to become more efficient as a testing coordinator. To use the calendar feature simply click CALENDAR inside your Outlook email and place an appointment or meeting on the calendar. If you are inviting others so the testing event appears on your colleagues' calendars simple choose meeting rather than appointment.
 * [[image:Screenshot 2015-08-03 09.51.11.png]]
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Mac
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Windows (PC)
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Creating folders on your computer to organize testing information received from CMCSS or the state.
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Mac
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Windows (PC)
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Creating Desktop Shortcuts - to make access to these folders quick and easy!
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Add your folders to Favorites in Navigation Pane
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">Finding needed information or data quickly and easily using by holding down the COMMAND KEY while pressing the F key (Mac) or holding down the CONTROL key while pressing the F key ( Windows)
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">Outlook
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">searching inbox vs. searching folders
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">PDF files
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">Web pages
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px; line-height: 1.5;">Spreadsheets
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Managing laptops and anticipating common issues for troubleshooting
 * Charging laptops – the amount of time it takes to fully charge and how long they will stay charged; COWS
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Testing on laptop computers vs. desktop computers (Wireless vs. Wired)
 * <span style="color: #222222; font-family: Arial,Verdana,sans-serif; font-size: 12px;">Choosing testing locations that minimize network access issues
 * Computer density issues and access points (due to the abundant number of students testing at one time)
 * Computer density issues and access points (due to the abundant number of students testing at one time)

=Making Your Life Easier with Powerschool Quick Export= Here are some common Powerschool custom reports you may need during the school year. To make these work for you simply go to QUICK EXPORT and copy and paste the fields. 1. On the Powerschool Start Page Click ALL for all students 2. Choose

Then go to All Reports>Student Schedule Listing ||
 * **All Students in Bio (1st semester)** || *enrolled_in=3210@1
 * ** To Find Students ** || TN_Yearentereredninthgrade=2011

or in advance of creating the DOE, pull the following report:

PowerSchool>All Reports>Custom SQL Reports>High School>Misc>School Counselor Information ||
 * ** Retention Report ** || TN_Yearentereredninthgrade+2011

Student_Number LastFirst Grade_Level *credit_hours || first_name *period_info;4teacher_name || first_name Student_Number TN_StudentPIN || CMC_Alert_SpecEd TN_ELB LunchStatus || last_name Gender DOB State_StudentNumber Grade_Level || first_name grade_level CMC_Plan_Composite CMC_Explore_Composite *GPA || first_name wm_address Student_Number TN_StudentPIN || first_name wm_address Student_Number TN_StudentPIN || For students prior to 2014: firstlastlast3oflunch,2initialsPS# || grade=10;*not_enrolled_in contains @3002@
 * ** To find a group of student's 4th period teacher ** || last_name
 * ** Credit Recovery ** || last_name
 * ** To Find Special Status Info ** || LastFirst
 * ** MIST Entering of students ** || first_name
 * ** PSAT Candidates ** || last_name
 * ** TCAP Writing PowerSchool Student Login ** || last_name
 * ** Kuder Career Assessment **
 * For computer login ** || last_name
 * ** For Kuder login ** || firstlast, 2intitialsPS#
 * ** Plan-Students not enrolled in Eng II ** || Students not enrolled in Eng II:

To Find Special Status Info: LastFirst CMC_Alert_SpecEd TN_ELB LunchStatus || Alg I (3102) & Eng III (3003) Eng II (3002) & US Hist (3405) Bio (3210) & Chem (3221) Eng I (3001) & Alg II (3103)
 * ** Student enrolled in more than 1 EOC ** || *enrolled_in contains @3102@;*enrolled_in contains @3003@

AP Chem (3225) & Eng III (3003) AP Span (3025) & US Hist (3405) AP Cal (3139) & Chem (3221) || grade=11;*not_enrolled_in contains @3405@2 || LastFirst TN_LicenseNumber TN_PrevFirstName TN_PrevLastName || last_name Gender DOB TN_StudentPIN ethnicity CMC_Alert_SpecEd LunchStatus || all reports stored grades by percent report select grading period 0-69% option || custom CMCSS reports all school reports Misc testing demographics report || modify schedule all periods select semester1 or semester 2 || go to powerscheduler side click reports student request tally submit once report is ready click on total and it sorts by number || First_Name CMC_Special_Status ||
 * ** ACT-Students not enrolled in a class ** || Students not enrolled in US History:
 * ** EOC Teacher Licenses ** || Teacher Licenses:
 * ** GPA ** || *GPA ||
 * ==**Counselor Information Report**== || All Reports>Custom CMCSS Reports>High School Reports>Misc>Counselor Information Report ||
 * ** TCAP Full Information ** || first_name
 * ** Failure Report ** || select students
 * ** EOC Student Demographics ** || all reports
 * ** How many benchmarks do I need to order? ** || select a student (any student)
 * ** Powerscheduler to see requests # of requests entered for each student ** || powerschool side TN_yearentered=2014
 * ** Entry Date **
 * To find students that entered after a certain date ** || EntryDate>02/22/15 ||
 * ** To find Special alert (sped...) ** || Last_Name
 * ** Retention Report ** || select my students

Last_Name First_Name CMC_SpecialEdGrad Grade_Level *cumulative_credit_hours || First_Name TN_EndOfServiceAction || LastFirst Grade_Level Sched_NextYearGrade || example *as_of=05/23/2014
 * ** to make sure we did it correctly **
 * select my students ** || Last_Name
 * ** Hand selecting students that are retained and then quick export the following in order to copy and paste in the report ** || Student_Number
 * ** To access previous year students ** || *as_of=(put date you want to pull from)

in quick export enter First_Name Last_Name Grade_Level

LunchStatus ||