The director of the Child Protection Agency is very pleased with the summary report that you designed in Question 2. To help the child protection workers manage and prioritize their caseload, the director would now like you to design a report that would go to each worker, showing their open cases, including the age of each case. Further, the report should be a turnaround document, where the child protection workers can provide status on each of their open cases, including the estimated date of completion. What subclass of report is needed?

What data elements are needed? In what order should the cases be listed? Create a prototype design for this report.

Data from Question 2

You are working as a systems designer for the county Department of Social Services. The director of the county child protection agency is concerned about the agency’s caseload and the length of time that cases remain open. The agency’s objective is to have no open cases older than 60 days, and preferably none older than 30 days. The director wants a monthly report showing the number of cases, by age, for each of the 12 child protection workers in the agency.

What subclass of report should you design?

Should the output format be tabular or zoned?

Describe the data structure defi ning logical requirements for the report. Use the format described in the chapter.