This webinar is the first in a three-part series on Microsoft Excel for school psychologists. It goes over relevant functions, formulas, data tables, graphing, and pivot tables. The most amount of time will be spent on pivot tables. If you are unaware, no data is safe from the pivot table! A pivot table is an extremely powerful tool to manipulate data, so it’s something every school psychologist should know about. This webinar reviews methods for collecting, organizing, and presenting data to enhance the process of effective decision making and problem-solving. This webinar provides attendees with the opportunity to practice what they’re learning during the webinar. Please be advised that there is a large amount of overlap between the content taught in Google Sheets webinars and the content taught in Microsoft Excel webinars. Presented by Tim McIvor, NCSP in July 0f 2018. The content in this webinar is intertwined with Domain 1 of the NASP Practice Model. This individual webinar can be purchased for $25 (scroll down to purchase). Schoolpsych.com’s recorded webinars are non-refundable. Attendees who complete this 1-hour webinar will receive 1.0 NASP-Approved CPD credit.
Participants will learn:
1. Basic data collection techniques relevant to a school psychologist’s job. 2. Basic Excel formulas to organize data. 3. Basic methods to improve visuals for enhanced data-based decision making.
Reviews Based on Attendee Evaluation Feedback:
“Well presented with helpful repetition included. The periodic humor was much appreciated. :)” -Darlene Hans’ Overall Rating: 5/5 (Excellent) “Methods presented are very helpful and will be useful in everyday practice as a school psychologist.” -Iris “This webinar was Awesome. I can’t wait to analyze some data!!” -Jeanette Jordan’s Overall Rating: 5/5 (Excellent) “I enjoyed the step by step process. I was able to pause the video and try out the techniques.” Julie “I am so excited I don’t have to run to the admin assistant to help me make my charts. I usually use excel to sort things, but now I can make formulas too. Thank you!!!” -Krista Laurie’s Overall Rating: 5/5 (Excellent) ” Well organized, very efficient” -Lisa M. Lisa P.’s Overall Rating: 5/5 (Excellent) Lisa T.’s Overall Rating: 5/5 (Excellent) “Knowledge of topic, time allotted, pacing were appropriate and helpful.” -Madeline “Thank you so much for going over this information! I have been wanting to learn more about for so long…just what I was looking for.” -Mary Michelle U.’s Overall Rating: 5/5 (Excellent) Michelle L.’s Overall Rating: 5/5 (Excellent) Paige’s Overall Rating: 5/5 (Excellent)
Data-Based Techniques for School Psychologists Using Microsoft Excel: Beginner
Quiz on Beginner Excel Webinar
Here you will complete the quiz on the webinar. You may take the quiz as many times as you need to until passing (75 percent).