Automated FCAR System & Assessment Report Generator

1. Automated FCAR System& Assessment Report Generator Web Pages Agile Modeling For software engineering, traditional engineering methodologies are impractical and too confining. Sometimes the best solution is not apparent before solving smaller parts of the problem. Other times, the problem changes half way through the project. With agile modeling, stakeholders can participate in the engineering process as developers quickly respond to change to create working software. Agile modeling seeks to identify the high-level scope of a solution, and then iteratively work through specific issues in a Just-In-Time manner.Details are left out in the beginning, and the requirements evolve as the project grows. Matt Downs, Steve Garofalo, and Kelly Patterson Problem:ECCS professors fill out Faculty Course Assessment Reports (FCARs) in a Microsoft Word document template and email it to the ECCS Department Chair, who, at the end of each year, manually filters through each report to put together an overall assessment report. This process results in inconsistent documents, excess manual labor, and frustration for all participants. Solution:An online system that allows users to enter FCAR data through a form, which upon submission is stored in a database, assembled into a report in Microsoft Word, and sent to the Department Chair by email. The assessment report can then be generated with the click of a button at the end of the year. Client-Server Distributed System Object-Oriented Design Implementing the system in C# .NET, an object-oriented programming language, enabled the application of OOD principles. The resulting code is abstract, easy-to-understand and reusable. The system uses a three-layer application architecture, which separates the interface from the logic. A separate data-access layer handles data transactions. Database Schema • The database is structurally designed to be in Boyce-Coddnormal form. This means no redundant data is stored, every attribute can only be functionally dependent on the primary key, there are no transitive dependencies between attributes, and every determinant is a candidate key. Open XML In the past, Microsoft Office documents were binary files, but the 2007 versions use the Office Open XML format, which is easier to understand and readable by different applications and platforms. The schema for Open XML is publicly available, allowing programmers to create and manipulate Word documents programmatically. Word 97-2003 (Binary) Word 2007 (OpenXML) <w:pPr> <w:indw:left="540" w:hanging="540" /> </w:pPr> <w:p> <w:r> <w:txml:space="preserve">PO-4: Be familiar with, and be able to select and use, the tools and devices available to build solutions to problems and have the skills to carry out the design and implementation</w:t> </w:r> </w:p> <w:pPr> <w:indw:left="1080" w:firstLine="1080" /> </w:pPr> Deliverables Methodology