Transcription

1 Creating Bulk Rosters from PowerSchool to Allow Staff Access to MEA/SBAC Score Results in the Online Reporting System (ORS) 1 Purpose of this Quick Start Guide: In order for teachers or other staff to see assessment results within ORS they will need to have rosters of students assigned to them. There are a number of ways rosters can be created, however this guide will allow DSAs and SCs to use existing data within their student information system to quickly create bulk rosters that are reflective of all teachers existing classes. By following the instructions below you will generate data that can be easily manipulated in a spreadsheet for uploading within the TIDE system. Once the data below is entered into TIDE, staff and teachers who access ORS will be able to see student assessment results. There is no bulk roster upload feature within ORS, though rosters uploaded via TIDE are almost immediately viewable within ORS. Please note that Test Administrator accounts must be created in TIDE before rosters are added to TIDE. For steps by step instructions on prepping the TA import file please use the earlier QuickStart guide, which is located here:

3 3 5. Click Export Records 6. Enter the fields below into the box: a. [04]Course_Number b. [04]Section_Number c. [01]state_studentnumber d. [05] _addr 7. Click submit. The file may open in a spreadsheet or you may have to copy and paste the contents of the next screen into a spreadsheet (this depends on your local machine preferences).

4 4 8. Save File and use spreadsheet software (e.g. Excel or Numbers) to extract text file It should look like below (student data redacted) 9. After you have copied and pasted into a spreadsheet, or opened in a spreadsheet, you will need to concatenate the first two columns. 10. Insert a column between columns B and C. 11. Select Cell C1 12. Enter: =A1&"-"&B1 and fill down through the entire column. This will combine the course number and the section number with a hyphen in the middle. 13. Rename the newly created column Roster Name

5 5 14. Highlight Columns A & B and delete them. 15. Insert a new column to the far left and use the header School ID 16. Insert a new column to the far left and use the header District ID 17. Type in your District s 4 Digit IRN/ID number* in cell A2, then fill down. Type your School s ID in cell B2, and fill down. District/School codes can be found here: 18. Rearrange the columns so that they match the headers below* *Instructions for column reordering: https://www.ablebits.com/office-addins-blog/2014/01/23/swap-excel-columns/ 19. Save your spreadsheet in either CSV or Excel format. 20. Your DSA or SC can now upload the spreadsheet into TIDE. A reminder your TA data must be entered before uploading roster. Instructions are here: 21. Rosters and student assessment results will now be viewable by appropriate staff who log in to the Online Reporting System at It is always recommended that you upload and verify a smaller sample of rosters before importing dozens or hundreds of rosters! Support for this process is NOT handled by the AIR/MEA helpdesk, please refer inquiries to CHANGE LOG: Original document posted to DOE website 06/02/2015 Future changes to this document will be recorded here

Clever School Signup: PowerSchool 1. Introduction Clever allows the students, teachers, schools, and class rosters in PowerSchool to automatically sync with the applications you authorize. This eliminates

What is Expense Processor? The Expense Processor is an inquiry tool in the Expense System, and is accessed from the home page of the Expense System, by clicking on Expense, then Process Reports. It can

Google Apps for Sharing Folders and Collecting Assignments The Google Drive is cloud (online) storage space, and it is also where you create and work with Google Docs, Sheets, Slides, etc. Create a Folder

It s as simple as 1, 2, 3 This email archiving setup guide provides you with easy to follow instructions on how to setup your new archiving service as well as how to create archiving users and assign archiving

INTRODUCTION This document shows a Local Department Administrator for how to set up projects and assigned employees within the web application. The web application works in conjunction with HCM and CalTime

User Manual - Overview The Leads module of MVI SLM allows you to import, create, assign and manage their leads. Leads are early contacts in the sales process. Once they have been evaluated and assessed,

Washington Access to Instruction and Measurement (WA-AIM) Engrade Users Guide Copyright 2015 by OSPI, Data Recognition Corporation, and McGraw-Hill LLC. All rights reserved. Developed and published under

Data Director Create a New Answer Sheet DataDirector allows you to create answer sheets for assessments. Your answer sheet may contain multiple question types. Once the Answer Sheet is created and saved,

How to Manage a Branch Account This guide is intended for use by the Main Account that has established Branch accounts. The Main Account may need to edit Branch Account information such as allowing sharing

A guide to setting up pay periods (including week 53) PM00104.0315/1 Within this document you will find instructions for creating new pay periods and amending existing pay periods for the 2015/2016 tax

Creating a Participants Mailing and/or Contact List: The Limited Query function allows a staff member to retrieve (query) certain information from the Mediated Services system. This information is from

The bulk upload facility in CCMS allows you to export data from your case management system and upload it directly into CCMS. This replaces the need for you to manually enter bills line by line. Your software

M3 The PTA s new membership website database and dues reporting system State Level Actions from Task Menu M3 CAPABILITIES The State must authorize a user to have access to M3. The State s authorized users

How to create database in GlycomcsPortal? 1. Log- in Log in through Log in 2. Submit Content Click Submit Content on the menu. 3. Choose Database Choose Database as a type of entry you desire to create.

USC Marshall School of Business Customer Technology Services AKINDI Test Forms Creating and Grading Test Forms You can use AKINDI to create multiple choice test forms that can be printed out for student

How to transfer your Recipient Address Book from FedEx Ship Manager at fedex.ca to FedEx Ship Manager Software There are three phases to completing the transfer process. Phase I Phase II Phase III Export

EXPORTING THE SCHOOL ROSTER INTO AN EXCEL SPREADSHEET QUICK GUIDE Since Columbus City Schools were closed eight days during the 2013-2014 school year due to weather, three of those days will be made up

emarketing Manual- Creating a New Email Create a new email: You can create a new email by clicking the button labeled Create New Email located at the top of the main page. Once you click this button, a

2 Quick Reference for DRA Online Management System FAQs Minimum Hardware and System Requirements 1. What kind of computer do I need to run the DRA Online Management System (DRA OMS)? Since this an online

Hatco Lead Management System User Guide General Notes: The Hatco Lead Management System (HLMS) is designed to work with modern web browsers, such as Internet Explorer 9 or newer, Firefox, Chrome & Safari.

Management Maintain Reporting Relationships Tool The Maintain Reporting Relationships tool is used to maintain Manager Employee and HR Administrative Manager relationships for use in University Performance

I. Setting Listserv password Before you can manage the Listserv lists that you own, you will need to set up a Listserv password. This is a one- time procedure, although for security purposes it is a good

Introduction The wireless guest server solution provides a simple means of utilizing the University s network resources while securing access to critical network areas. Guests of the University who require

MicroStrategy Desktop Quick Start Guide MicroStrategy Desktop is designed to enable business professionals like you to explore data, simply and without needing direct support from IT. 1 Import data from

1 FAMU HOUSING ONLINE APPLICATION PROCESS FAMU Housing application process is online. This process will allow you to first, apply for housing online through your irattler account by selecting a term and

WorkKeys Internet Version Test Administration and User Guide ACT endorses the Code of Fair Testing Practices in Education and the Code of Professional Responsibilities in Educational Measurement, guides

Transitioning from TurningPoint 5 to TurningPoint Cloud - LMS 1 A Turning Account is a unique identifier that is used to tie together all software accounts and response devices. A Turning Account is required

Information used to create labels in the Client Data System (CDS) can be exported out of CDS and used to create labels in Microsoft Word, making it possible to customize the font style, size, and color.

How Do I Upload Multiple Trucks? 1. Log into account. Please see the How Do I Log into My Account? document (DOC-0125) for additional assistance with logging into PrePass.com. 2. On the Admin Home tab,

The makes grant information accessible to EPA Personnel, OMB, and State agencies. Grant pages contain general information as well as electronic copies of workplans and progress reports. The information

introduction to emarketing emarketing is typically used for promotional campaigns for attendee generation and for attendee communication. It works closely with ereg which also includes email capabilities

Instructor QuickStart Guide This brief manual provides instructions for setting up and customizing your SmartWork course, and will outline the functions of the grade book and other administrator tools.

Module 1. 4 Login-Send Message to Teacher Students, in this lesson you will 1. Learn to login to your InterAct account. 2. Learn how to send an email message. Logging on to Students Online 1. Launch the

Welcome to HR Classroom! The following will show you how to use your HR Classroom admin account, including setting up Training Groups, inserting Policies, and generating Trainee Reports. 1) Logging into

HOW TO SET UP SINGLE SIGN ON FOR PARENT PORTAL IN POWERSCHOOL Before you can access your student(s) information, you MUST create your account which ties you to your student(s). Even if you have your user

INFORM VED 5.7 EXPORTING DATA TO EXCEL INSTRUCTIONS July 2004 Exporting Data to an Excel Spreadsheet When TCS data files (TCS files = Teacher, Class, Student) get rolled over for a district at the beginning

Transitioning Your School Email Account This tutorial will walk you through transferring the email and other data from your School account to a personal email account. Establish a New Email Address (or

ReadyResults.net 2014 Managing the Database and Student Records Online (at the District Level) For Administrators Only For help, send email to: help@readyresults.net or call: 877-456-1547 Table of Contents

Downloading RIT Account Analysis Reports into Excel In the last lesson you learned how to access the Account Analysis detail and export it to Excel through the Account Analysis function. Another way to

Canyon Creek Online Scheduler Teacher Instructions Accessing the Online Scheduler and Logging In Click the link to access Canyon Creeks Online Scheduling software. There will also be an Online Scheduler

Basic Pivot Tables Pivot tables summarize data in a quick and easy way. In your job, you could use pivot tables to summarize actual expenses by fund type by object or total amounts. Make sure you do not

Mail Merge: Create Mailing Labels Using Excel Data and Filtering the Contents in the Data Prior to starting this, please save the.csv file that you exported as an excel file (example: xxxx.csv will now

Creating Codes with Spreadsheet Upload Ad-ID codes are created at www.ad-id.org. In order to create a code, you must first have a group, prefix and account set up and associated to each other. This document

INTRODUCING QUICKBOOKS WEBCONNECT! The Mechanics Bank now offers Web Connect to download account information into QuickBooks, which gives you the power to manage your business more effectively. No manual

Glogster EDU School/Faculty account set-up instructions. Please take a few minutes to familiarize yourself with your new account by following these instructions: Firstly log in to your administrative account

An Introduction to the Moodle Online Learning Platform For a general orientation to features of the course platform review the Computer Configuration, Course Navigation and Moodle Features document presented

Web Ambassador Training on the CMS Learning Objectives Upon completion of this training, participants will be able to: Describe what is a CMS and how to login Upload files and images Organize content Create

Two major approaches to run Clickers a. Anonymous b. Tracked Student picks any pad as s/he enters classroom; Student responds to question, but pad is not linked to student; Good for controversial questions,

Result Entry by Spreadsheet User Guide Created in version 2007.3.0.1485 1/50 Table of Contents Result Entry by Spreadsheet... 3 Result Entry... 4 Introduction... 4 XML Availability... 4 Result Entry...

Page 1 of 7 AVDC Document Management System Getting Started Login Upon entering the AVDC document management system (http://www.avdc-dms.org/dms/ or via the link on the AVDC web site Home page), the initial

A guide to bulk deposit submissions What is a bulk deposit submission? The Bulk Deposit Submission process is used for agents/landlords who have a large amount of deposits to submit at the same time, reducing

Power Editor Guide February 29, 2012 Why should I use Power Editor?...2 Get started in 5 easy steps...3 Power Editor buttons and features.................................... 4 Navigate within Power Editor....6

PowerSchool 7.x Student Information System Released June 2012 Document Owner: Documentation Services This edition applies to Release 7.2.1 of the PowerSchool software and to all subsequent releases and

Email Address Collector - Tutorial - How to extract email addresses from mail folders 1. Open Email Address Collector Once the product is installed and your license is activated, you can start extracting

Here is a Trial Balance sample, generated and exported into an Excel spreadsheet, by an accounting software* (*) It should be straightforward to put the trial balance produced by accounting software into

GUIDE FOR SORTING RX HISTORY REPORTS IN MICROSOFT EXCEL 1. Log in to your INSPECT WebCenter Account. 2. Go to the Requests tab on the left, and select New Request. 3. Select Practitioner from the drop-down