1 / 11

Update Online Results System

Update Online Results System. Project Supervisor: Ian Storey. Project Description. Develop a new enrollment system in ASP.NET using SQL server based upon the existing system created by Ian Storey who will supervise the project. Project Tasks

judith-england
Download Presentation

Update Online Results System

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. Update Online Results System Project Supervisor: Ian Storey

  2. Project Description • Develop a new enrollment system in ASP.NET using SQL server based upon the existing system created by Ian Storey who will supervise the project. • Project Tasks • Fully Normalize the existing database so it can handle multiple semesters before creating it in SQL server. • Add security features from ASP.NET (v3.5) library. • Design and develop each individual page based on the existing system. • Reuse logic where applicable • Project Timeline • 8 Weeks • 200 hours School of Business Information Technology

  3. Results System Sitemap School of Business Information Technology

  4. Result System Database Design School of Business Information Technology

  5. ASP.NET Membership Database School of Business Information Technology

  6. Design and Development • Page Design • Multiple ways of loading pages so its important to capture all use cases • Key data is stored in: • Session Variables • Objects from hand-made classes • ASP.NET viewstate • User Requirements • Business Rules handled • System does what it is meant to • Data • LINQ • Technology developed by Microsoft that translates queries into the required SQL for the database server • Builds data classes that can be called upon for CRUD • SQL Data Source • Using parameterized queries for CRUD helps to prevent SQL injection School of Business Information Technology

  7. Design and Development Cont… • Development System is broken down into 5 categories listed below, a user can only access groups they have been assigned to. Example: A student cannot assess the teacher or admin section as the student has not been assigned these roles, the ASP.NET membership library prevents all unauthorized access. • Teacher Section • The heart of the entire system and its main purpose is built around this section. • Allow new Enrolment, Allow Sign in to class • Coordinator can create assessments and weighting of marks • Check Attendance, Update Results • Student Section • List class’s currently enrolled in. • Enroll in new class • Sign In/Out • Check Timetable School of Business Information Technology

  8. Design and Development Cont… • Admin Section • Edit all tables in database • Perform checks to insure system’s integrity • Search Section • Ability to look up students, class or course. • Show results, attendance and student details. • Only available to teachers and admin. • Home • Login • Create Student • Create Teacher • Teacher ID must be set up by admin first and once a teacher has registered, admin must accept before the new teacher is assigned to teacher roles. School of Business Information Technology

  9. My Internship Experience • Knowledge Gained • Can never learn in class what is learnt during the eight weeks. • AJAX, Advanced editing of listview object, using onCommand and passing through command arguments. • Can see how I can then utilize these skills in industry. • Motivate Others • With the early completion of the barcode scanner I had extra help for a week or so from Aron. • I was able to share my knowledge and encourage Aron to find the ASP.NET solution to certain problems, a huge bonus was Aron’s ability to create an auto complete web service along with the look of the site. • Problem Solving Skills • Working 1-on-1 with the project supervisor Ian Storey has helped me to think more creatively about possible solutions to problems arising during development and design School of Business Information Technology

  10. My Internship Experience Cont…. • Organizational Skills • During design and development I have been able to map out the project into sections and work through each page in turn. • Kept records of interesting things I have learnt. • Kept records of bugs found and also things that still need to be complete. • Excellent experience and would recommend others to put their hand up for a project next time around. • Time spent brainstorming with a supervisor is invaluable knowledge • Suggestions • If the summer internship was ran again it would be good to work in groups on larger projects. • This would encourage collaboration • Closer replicate how systems are built in industry School of Business Information Technology

  11. Acknowledgements • Chris Cheong – Internship Coordinator • Ian Storey – Supervisor of the project • Aron Bury – Intern School of Business Information Technology

More Related