Utilizing R-Studio for Data Analysis
Learn how to effectively use R-Studio for data analysis tasks such as assigning variables, calculating mean, median, and standard deviation, creating graphs, working with probability distributions, and understanding binomial distributions. Follow step-by-step instructions and examples provided in the content to enhance your skills in R-Studio.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
NAFEA Conference Adelaide 2017 PLACEMENT DATA REPORTING WORKSHOP Rob Cherry Professional Experience Office School of Education Deakin University
NAFEA Conference Adelaide 2017 Presentation Overview 1. WHY HAVE A DATA REPORT? 2. CONTEXT OF DEAKIN S SCHOOL OF EDUCATION PEO 3. HOW DATA IS GATHERED 4. CREATING THE REPORT 5. PRESENTING ASPECTS OF PEO REPORT 6. WHERE TO FROM HERE AS A PROFESSIONAL ORGANISATION?
NAFEA Conference Adelaide 2017 WHY CREATE A REPORT? INFORMATION AUDIENCES PEO TEAM HEAD OF SCHOOL SCHOOL EXECUTIVE COURSE DIRECTORS UNIT CHAIRS ACHIEVEMENTS CHALLENGES STAFFING NEEDS INFORMATION FOR PROBLEM SOLVING
NAFEA Conference Adelaide 2017 GROUP ACTIVITY TABLE GROUPS 10 MINUTE DISCUSSION 1. WHICH AUDIENCES WOULD YOU REPORT TO IN YOUR CONTEXT? 2. LIST QUESTIONS YOUR AUDIENCES MAY HAVE OF YOUR WORK. 3. WHOLE GROUP SHARING
NAFEA Conference Adelaide 2017 DEAKIN SCHOOL OF EDUCATION PEO CONTEXT Courses 3 Campuses InPlace Software Burwood Geelong Warrnambool Request Manager Placement Manager Work in sector teams at each campus Early Years, Primary, Secondary (U/G & P/G Courses) Assign schools to each officer for all sector cohorts for each given school U/G on campus mode 5 courses, 19 placement units P/G Cloud based & on campus modes 9 courses, 11placement units TOTAL =13 COURSES & 30 UNITS
NAFEA Conference Adelaide 2017 INFORMATION DATA SOUGHT SAMPLE QUESTIONS: 1. How many placements per year/per sector/per course & per unit? 2. What are the average number of placements per placement officer across the office/ per sector/per campus? 3. Which sector is the most or least difficult to find placements for? 4. What are the acceptance and rejection rates for each course/mode/unit? 5. Which suburbs and Local Government Areas do we place PSTs in? 6. How many interstate and international placements do we achieve each year? 7. What are the estimated & projected placement costs per year? 8. What trends are emerging across the years?
NAFEA Conference Adelaide 2017 GATHERING DATA QUERY REPORT 1 Base Query Placement Personnel Parameters: Start & End Dates Agency Placement Numbers Number of completed/confirmed/offered placements Agency/student/course data fields Produces Data about
NAFEA Conference Adelaide 2017 QUERY 1 AGENCY PLACEMENT NUMBERS
NAFEA Conference Adelaide 2017 GATHERING DATA QUERY REPORT 2 Rejection & Placement Rates per Year Base Query Request Parameters: Start & End Dates Request Status Course, Agency data fields & Student Totals Data
NAFEA Conference Adelaide 2017 QUERY 2 REJECTION/PLACEMENT RATES/YEAR
NAFEA Conference Adelaide 2017 GENERATING DATA & DATA REPORT STAGE ONE STAGE TWO Export Query Data to Excel Select Charts to include in PowerPoint presentation Create Pivot Tables and charts Add analytical comments
NAFEA Conference Adelaide 2017 STAGE ONE USING EXCEL DEVELOPING EXCEL EXPERTISE Selected courses from their playlists: a) Excel 2013 Essential Training b) Excel 2013: Working with Charts & Graphs c) Excel 2013 Tips & Tricks 40 hours of training Subscribe to Lynda.com
NAFEA Conference Adelaide 2017 EXCEL MASTER SPREADSHEET Initial spreadsheet: managing data for 2013 2015 (from the beginning of InPlace) Data clean up remove duplicates/add year /LGA type/cost fields etc. Combine individual years into one spreadsheet Insert Pivot Table and manipulate fields Create Pivot Charts to answer questions
NAFEA Conference Adelaide 2017 STAGE TWO POWERPOINT CREATE POWERPOINT PRESENTATION Select Pivot Charts Write up accompanying analytic comments based upon team discussion to tell our story
NAFEA Conference Adelaide 2017 REPORT CHARTS Annual Placement Totals
NAFEA Conference Adelaide 2017 Annual Placement Costs
NAFEA Conference Adelaide 2017 Average Placements per 1.0 EFT per Sector
NAFEA Conference Adelaide 2017 DURATION & NUMBER OF PLACEMENT BLOCKS
NAFEA Conference Adelaide 2017 ANNUAL TOTAL AGENCIES ALL SECTORS
NAFEA Conference Adelaide 2017 ANNUAL AGENCY TYPE TOTALS PER SECTOR
NAFEA Conference Adelaide 2017 BURWOOD CAMPUS PLACEMENT TOTALS PER COURSE TYPE
NAFEA Conference Adelaide 2017 Annual Acceptance & Rejection Totals All U/G Course Types
NAFEA Conference Adelaide 2017 Annual Acceptance & Rejection Totals All P/G Course Types
NAFEA Conference Adelaide 2017 M. Teach On Campus Annual Acceptance & Rejection Totals per Unit
NAFEA Conference Adelaide 2017 Comparison of M. Teach Off & On Campus Annual Acceptance & Rejection Percentages
NAFEA Conference Adelaide 2017 TOTAL ANNUAL ALLIANCE PLACEMENTS
NAFEA Conference Adelaide 2017 2016 METRO SUBURBAN SECONDARY PLACEMENTS - 20 OR MORE
NAFEA Conference Adelaide 2017 INTERSTATE & INTERNATIONAL PLACEMENTS TOTALS
NAFEA Conference Adelaide 2017 WHERE TO FROM HERE? NAFEA present data to ACDE & other bodies Produce own office reports Could this be linked to Health & Well being survey? Amass data across PEOs
