ConsciousVibes.com

Home | Links ( Motorcycles, Computers )

Projects by Mr. Chin

All of the information, instructions, and recommendations on this Web site are offered on a strictly "as is" basis. Remember "Murphy's Law." Please take the proper precautions before attempting any of the tips or modifications listed here.

Contents

Overview

For the projects listed here, I’ve done the following:

• A full systems analysis to determine the needs of the users, stake holders, and scope of the projects.
• Designed the client/server relational databases
• Created the user interfaces, forms, reports, etc.
• Written all the VBA code and SQL queries.

Note:

• The Office of Adult and Continuing Education (OACE) is a division of the NYC Department of Education

OACE Class Directory

• Used to document the over 800 classes, city-wide, given by OACE.
  
• Lists all classes, with their days, times, locations, and assigned teachers.
• For teachers, lists their full-time and part-time assignments.
• Used in conjunction with ASISTS (Adult Student Information System & Technical Support) for tracking student information.
  
• Used as a tool to help assigning teachers at the hiring hall each new school year.
• This application is a client/server database system, with up to 3 concurrent users

OACE GED Testing

• Used to schedule persons taking the Official Practice Tests (OPT) and GED tests
• Generate the data source for mail-merge notification letters and mailing labels that are sent to test takers to inform them of when they're scheduled for testing.
• Generate the GED Examiner's Attendance Sheet for a specific GED test that is submitted to the State:
  • Names are alphabetized as required, and counts of each test language, plus totals are automatically calculated and included.
• Tracks the OPT and GED tests taken, with scores, for each person
• This application is a client/server database system, with several concurrent users, and is currently hosted on a Terminal Server which allows access from different locations via the Internet.