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 find materials
Screenshot 2015-08-03 09.07.21.png

Screenshot 2015-08-03 09.09.38.png


  • Maneuvering within the web browsers / turning preferences on and off
  • 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
  • Bookmarking websites and updating previously saved bookmarks
  • Working with Excel spreadsheets to export data, save files, add and delete fields, sort data, and copy large amounts of data
    • 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
    • Creating Filtered Reports in Powerschool and Opening them as Excel Spreadsheets
  • 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.
      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.
Mac_NewFolderOL2011.png
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.
      • savingemail.png
      • When saving documents be sure to leave on the necessary to extensions .xlsx, .pdf, .ppt, .doc
  • 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.
Screenshot 2015-08-03 09.44.30.png
  • Screenshot 2015-08-03 09.51.11.png

  • Creating folders on your computer to organize testing information received from CMCSS or the state.
  • 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)
    • Outlook
      • searching inbox vs. searching folders
    • PDF files
    • Web pages
    • Spreadsheets
  • 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
  • Testing on laptop computers vs. desktop computers (Wireless vs. Wired)
    • 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)


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

All Students in Bio (1st semester)
*enrolled_in=3210@1
Then go to All Reports>Student Schedule Listing
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
To find a group of student's 4th period teacher
last_name
first_name
*period_info;4teacher_name
Credit Recovery
last_name
first_name
Student_Number
TN_StudentPIN
To Find Special Status Info
LastFirst
CMC_Alert_SpecEd
TN_ELB
LunchStatus
MIST Entering of students
first_name
last_name
Gender
DOB
State_StudentNumber
Grade_Level
PSAT Candidates
last_name
first_name
grade_level
CMC_Plan_Composite
CMC_Explore_Composite
*GPA
TCAP Writing PowerSchool Student Login
last_name
first_name
wm_address
Student_Number
TN_StudentPIN
Kuder Career Assessment
For computer login
last_name
first_name
wm_address
Student_Number
TN_StudentPIN
For Kuder login
firstlast, 2intitialsPS#
For students prior to 2014:
firstlastlast3oflunch,2initialsPS#
Plan-Students not enrolled in Eng II
Students not enrolled in Eng II:
grade=10;*not_enrolled_in contains @3002@

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

AP Chem (3225) & Eng III (3003)
AP Span (3025) & US Hist (3405)
AP Cal (3139) & Chem (3221)
ACT-Students not enrolled in a class
Students not enrolled in US History:
grade=11;*not_enrolled_in contains @3405@2
EOC Teacher Licenses
Teacher Licenses:
LastFirst
TN_LicenseNumber
TN_PrevFirstName
TN_PrevLastName
GPA
*GPA

Counselor Information Report

All Reports>Custom CMCSS Reports>High School Reports>Misc>Counselor Information Report
TCAP Full Information
first_name
last_name
Gender
DOB
TN_StudentPIN
ethnicity
CMC_Alert_SpecEd
LunchStatus
Failure Report
select students
all reports
stored grades by percent report
select grading period 0-69% option
EOC Student Demographics
all reports
custom CMCSS reports
all school reports
Misc
testing demographics report
How many benchmarks do I need to order?
select a student (any student)
modify schedule
all periods
select semester1 or semester 2
Powerscheduler to see requests # of requests entered for each student
powerschool side TN_yearentered=2014
go to powerscheduler side
click reports
student request tally
submit
once report is ready click on total and it sorts by number
Entry Date
To find students that entered after a certain date
EntryDate>02/22/15
To find Special alert (sped...)
Last_Name
First_Name
CMC_Special_Status
Retention Report
select my students

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

in quick export enter
First_Name
Last_Name
Grade_Level

LunchStatus