Child Welfare Data and Dashboard Resources This page provides resources to child welfare professionals who may need assistance working with Microsoft Excel, locating help when accessing eWiSACWIS reports, or learning how to use dashboards or revised eWiSACWIS functionality. Working With Microsoft Excel Webinars These Webinars provide brief demonstrations on how to use Microsoft Excel and access eWiSACWIS reports Excel Layout and Tips (19 minutes) Excel layout and terminology Columns and rows (resizing, freezing panes, hiding and un-hiding) Values (finding and replacing values, and retaining values) Access reports and locate resources within eWiSACWIS (19 minutes) Available eWiSACWIS reports and dashboards Where to find webinars and other guides Make a chart with Excel (17 minutes) Make a pivot table with Excel (10 minutes) Excel Guide Create a Pivot Table in Excel Using The Workload Management Dashboard And Tools The Workload Management Dashboard and Calendar/Task List provide workers, supervisors, and county managers with improved tools to understand and manage their caseload. Webinars Workload Management Calendar and Task List (for Initial Assessment) (12 minutes) Workload Management Dashboard – Initial Assessment (8 minutes) Workload Management Dashboard Guide The Written Guide with screen shots The 'About' button and 'Usage Tips' within each dashboard further describe the dashboard's content. Locating Help When Using eWiSACWIS Reports Frequently Used Child Welfare Reports The WiSACWIS Frequently Used Child Welfare Report Guide provides a description of those Wisconsin Department of Children and Families Child Welfare reports used the most often. It can help you determine which data reports you need, and how to find relevant data. Functional Summaries Most eWiSACWIS Reports have a ‘functional summary’ document providing definitions of each field (or column header), and each worksheet within the eWiSACWIS report. To obtain these documents: Login to eWiSACWIS and click on the ‘Reports - Scheduled and On-Demand’ hyperlink Click on the report name you would like to review Scroll to the bottom of the pop up screen, and click the 'View File' button, if available. The functional summary file will then be available for download. eWiSACWIS Knowledge Web Available within the eWiSACWIS desktop, the Knowledge Web consolidates links to several helpful eWiSACWIS guides including: Quick Reference Guides display screen shots and descriptions of how to fill out eWiSACWIS information. How-do-I… Guides provides refreshers on eWiSACWIS functions, such as CANS or Access. Learn About Revised eWiSACWIS Functionality These webinars describe and instruct on revised eWiSACWIS functions. Webinars Permanency Planning (18 Minutes) Streamlining permanency planning and documentation Structured Case Notes Immunizations