- SNC Tutor System - ROGER NAULT Defining the Project Function: - - PowerPoint PPT Presentation

ROGER NAULT

CS 460 Presentation

• SNC Tutor System -

Defining the Project

1.

Function: This system is used both by the Tutoring Center administration, the tutors themselves and the tutees (those being tutored). All tutoring sessions must be recorded. Appointments can be requested for general subject tutoring as well as for a specific tutor.

2.

This system must be 'secure' in the sense that tutoring sessions are

• nly viewed by the concerned parties.

3.

Review the documentation and study the current system. Determine additional requirements from the primary user.

4.

Follow a system analysis methodology and a phased approach to development.

5.

Design and implement enhancements that make the system even more useful.

6.

Include client training and evaluation.

7.

Propose a Development Plan for current and future work on the System.

What Is The Tutor System?

 A Visual BASIC

application and PHP Web-Site interconnected with a MySQL database.

 A live application used

every day by Academic Support Services, mostly Carole Basak.

 Stored on the compsci

server.

What I Was Able To Accomplish

 VB Application

 Program minimization/maximization  Elimination of the CRN  Creation of a note field on the home screen  Creation of a batch file for simple installation  Creation of a new form to give the user the ability to search the database on

Student ID or TutorID

 Other

 Switch from compsci server to new cstutor server

Work Still Left To Do

 Major

 Convert Visual BASIC application to C#

 Minor

 Adjust Print-Out (hard-coded)  Add „blog‟ feature on web  Add functionality for students being tutored to update information on web  Implement a date along with the student‟s records  Implement email functionality

• R E V I E W A L L C O D E / D O C U M E N T S
• M A K E C O N T A C T E A R L Y & O F T E N
• T H E M O S T I M P O R T A N T T H I N G

My Plan of Attack

Review all the Code/Documents

 Familiarize myself with Visual BASIC

again

 Understand what everything does on

each form

 Get into the heads of Michelle, Ryan

and Ted to understand their thinking.

 Know previous struggles and triumphs  Try not to make the same mistakes that

have already been made

Contact all the Necessary People

 Get in touch with all the right people early and often.

 Carole Basak  Michelle Keehan  Scott Crevier  Rob Downard

 Attend weekly meetings with Dr. Pankratz

And Most Importantly…

 Dive into the code and start playing with the

application.

 Test things, even if you have no idea what they do or

how they do it

 Use the internet as much as possible  Learn! That‟s the point of the entire project

• S T U D E N T S E A R C H F O R M
• S T U D E N T N O T E S
• O T H E R C H A N G E S

My Changes To the Visual BASIC Application

Student Search Form

 Searches the Database based upon

two different variables.

 Displays the person‟s name (First

and Last) as well as their Student ID and TutorID.

 Helps to quickly find any data

entry mistakes or duplicates.

 No ability to edit, just search.

Student Notes

 Allows the user to write and store notes about the tutor.  Eliminates having to use old-fashioned pen and paper.  Stores a note up to 255 characters, doesn‟t allow you to save more.  Works for both active and inactive tutors.

Other Changes Explained

 Maximization & Minimization

 Had to change a property in the menu  Very Easy

 Elimination of the CRN Field

 Hide it, don‟t delete it.  Scan all 17 forms

 Visual Changes

 Allow everything to fit on the screen

• B A T C H F I L E
• S E R V E R C H A N G E

Other Changes Made for the Project

Installation File

 Batch File?  Creates a folder on C:\ named “Tutors”  Inserts a necessary image into the “Tutors” folder.  Runs proper driver so MySQL works.  Turns 4 tasks into 1  Code Sample:

IF EXIST C:\Tutors\ GOTO END MD C:\Tutors :END cmd.exe /c "G:\PANKDC\tutor\Installation\MyODBC-3.51.06.exe" xcopy "G:\PANKDC\tutor\picture\snc-logo-lg-color.gif" C:\Tutors /y /e

Switching to the cstutor server

 Allows for everything to be secure  Get‟s itself off the dreaded compsci server  Lots of help from both Scott and Rob  Gained a lot of knowledge talking to them and researching

• n the internet

• N O T E F I E L D
• S E A R C H B Y I D / T U T O R I D

Short Demo

• F I N A L T H O U G H T S
• W O R D S O F W I S D O M
• T H A N K S A N D A P P R E C I A T I O N

Thoughts, Reactions and Advice

Thoughts about the Project

 Gave me a broad range of knowledge  I was able to learn a lot about things I had never known

before

 Got to work with clients  Work with a base and expand off of it

Advice for the Future Students

 Work early, work often  Ask for help or ideas, even if you think you don‟t

need them

 Understand the big picture, not just your task  Use the opportunity to learn as much as you can  Have fun and enjoy work while it‟s still fun

Thanks and Appreciation

 My parents  The Computer Science Faculty



• Dr. Pankratz



• Dr. Agarwal



• Dr. McVey



• Dr. Blahnik

 IT Staff



Scott Crevier



Rob Downard

 Carole Basak  Fellow Classmates

C O M P S C I 0 2 . S N C . E D U / C S 4 6 0 / 2 0 1 1 /N A U L R P O R R O G E R . N A U L T @ S N C . E D U

Questions or Comments?