Tech Tools for Less Stress: How Excel and Google can make your life easier!
Presenter Name(s)
Vance Sims
Target Audience
Middle
Secondary
Independent
Counselor Educator, Supervisor
Post-secondary/Admissions
Abstract
Using data that is extracted from your school Student Information System can be confusing and difficult. This session will show you how to use simple functions in Microsoft Excel and Google to allow you to see information and data more clearly and in several ways (those of your choosing). Even if you are a novice with these technologies, you will leave to resources you can use throughout the years to come.
Description
In this session, you will learn about the beauty and simplicity of several Microsoft Excel functions that will be able to save you hours of time when attempting to find and use data extracted from your school's student information system (SIS). You will also walk away with ways to personalize letter of communication, both printed and emailed, from these data from your SIS. Here are the Microsoft componenets:
|
Text To Columns - How to take that garbled data that makes no sense and place it in useful columns to be sorted |
| Conditional Formatting - How to have Excel (or Google) to automatically find the data that you're looking for |
| Mail Merge - How to take data from your SIS and create personalized email and/or mailed communications in just a few keystrokes and clicks |
| Pre-Post Test - How to access and simple pre-post Excel file to give you results following administration of pre and post tests |
| Mentor Rubric - How to use a rubric for determining need when resources are thin that has time waiting built in |
| Drag Dates and other numbers - How to create long data or time ranges or extend number patterns in one click |
|
Column Sort - How to sort columns in multiple ways and keep up with your data |
With Google Forms and Spreadsheets:
We will reviewing quickly how to make a Google Form. We will then look at how to capture the data that stored in a spreadsheet and connect to other Google Spreadsheets that can answer questions such as PBIS BoQ or sort data such as a universal screener (Behavior Screener Checklist III) and how to sort that data.