1 / 14

PBS Big 5 Report using Infinite Campus Presented by: Stephanie Grisham Rolla High School

Learn how to utilize Infinite Campus for creating Big 5 reports efficiently. Customize cells, export data to Excel, collate information, create graphs, and dig deeper into student behavior events.

coxm
Download Presentation

PBS Big 5 Report using Infinite Campus Presented by: Stephanie Grisham Rolla High School

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PBS Big 5 Report using Infinite Campus Presented by: Stephanie Grisham Rolla High School

  2. INFINITE CAMPUS • ALL NEEDED INFORMATION EXISTED IN INFINITE CAMPUS • TWO CUSTOMIZABLE CELLS • BEHAVIOR EVENT • LOCATION • NO EXTRA COST TO CUSTOMIZE EXISTING CELLS • AD HOC IS USED TO EXTRACT DATA • DATA EXPORTED INTO EXCEL SPREADSHEET • DATA COLLATED/GRAPHS CREATED IN EXCEL

  3. BIG 5 REPORT • STUDENT NAME • STUDENT ID NUMBER • BEHAVIOR EVENT • BEHAVIOR EVENT DATE • BEHAVIOR EVENT LOCATION • BEHAVIOR EVENT TIME

  4. AD HOC REPORT • Create the Ad Hoc

  5. AD HOC REPORT Create Name Find required fields Save and Test

  6. AD HOC REPORT Most = important fields Next to customize fields

  7. AD HOC REPORT We collect data of all students, active or inactive. Choose your date(s) Customize any cell to target needed data. Then click “Save and Test”

  8. EXPORTING DATA 3. Select CSV 1. Select Data Export 4. Select Export 2. Select Ad Hoc Filter This will now take your data into an Excel Spreadsheet.

  9. COLLATING DATA IN EXCEL • MAKE SURE TO SAVE YOUR DOCUMENT IN AN “EXCEL WORKBOOK”.

  10. COLLATING DATA IN EXCEL • MAKE ANY FORMATTING CHANGES AS YOU WISH IN EXCEL • CREATE A TEMPLATE TO COLLATE NUMBERS—SEE MY PAPER COPY • USE DATA TAB TO SORT • USE MOUSE TO CLICK AND COUNT DATA • INPUT NUMBERS INTO SPREADSHEET

  11. COLLATING DATA IN EXCEL • FORMULAS TO REMEMBER • SUM: =SUM(CHOOSE CELLS) • COUNT: =COUNTA(CHOOSE CELLS) • ANY OPERATIONS: =CELL/CELL • CONCATENATE: =CONCATENATE (“#”, CELL) • TEXT TO COLUMNS (UNDER DATA TAB) • THIS ALLOWS TO SPLIT THE TIME STAMP COLUMN INTO A DATE AND A TIME. USE FIXED WIDTH

  12. CREATING GRAPHS • CHOOSE DATA • INSERT TAB > INSERT CHART • CUSTOMIZE CHART • PLACE ALL GRAPHS IN SEPARATE WORKSHEET CREATING THE BIG 5 REPORT • COPY (CTRL+C) AND PASTE (CTRL+V) INTO A WORD DOCUMENT (LANDSCAPE) • RIGHT CLICK, FORMAT PICTURE, TIGHT SO YOU CAN MOVE IT AROUND AND RESIZE

  13. DIGGING DEEPER • USE FILTERS IN EXCEL (UNDER HOME TAB) • CAN SORT AS NEEDED TO TARGET STUDENTS IN TIER 1, 2, 3

  14. QUESTIONS? CONTACT ME ANY TIME!! STEPHANIE GRISHAM sgrisham@rolla.k12.mo.us 573-458-0148

More Related