Design new look
(deliverable: document describing look of site, fonts to be used,
placement of graphics, approval of images, etc)
Write an instruction sheet for all to use in creating new pages
(static or dynamic).
(deliverable: Instruction sheet)
Meet with deparments and develop a web page wish list for that
department.
(deliverable: minimum of one page describing meeting and departments wish
list)
Design and document web page structure (i.e. Home Page shall connect
to Perspective Students, Existing Students, Faculty / Staff, etc)
(deliverable: document)
Design and document folder structure
(deliverable: document)
List all Virtual Folders and why they were created and where they are
used. For example, /policeacademy is used in Fall 2007 marketing
borchure.
(deliverable: list of virtual folders)
Create new tables on the SQL Server
(deliverable: all tables loaded onto SQL server with supporting
documentation showing what fields there are and the purpose of each field
if not obvious)
Employees
Programs
Departments
Committees
Courses
Schools
Links
Publishers
Break down new look into functional scripts that can be called from
all pages.
(deliverable: formal interface with embedded documentation)
Create a new function library with the following functions
(deliverable: working libarary)
createTable()
listAllTables()
queryDB()
getNextRecord()
getDBField()
Create scripts for the following pages:
(deleverable: finished scripts that can be called from static pages)
Within a specific academic program, list all courses and employees
for that program
The Microsoft SQL Server contains several tables containing information that
is referenced throughout the web site. Maintaining this data is almost a
full-time job so many of the tasks have been delegated to various departments
with automated scripts designed to actually do the updates. Each of the
tables has a specific update procedure as shown below.
The COURSES table contains the academic program ID, the course number, the
course title, and the CCNet ID. This table is used when displaying all of
the courses for a given program. The "official" list of "approved"
and "active" courses is maintained in Curricunet and is updated as needed.
The web site needs to be updated at least once a year to coincide with the new
printed college catalog. Thus, a snapshot of the course list needs to be
made after July 1st each year and integrated into the COURSES table for the Fall
semester. Ideally, this would also be done after January 1st so that when
planning the fall semester instructors can refer to it.
How to Update the COURSES Table
Log into Curricunet
Search for all courses at Miramar with an
ACTIVE status
This takes about 4 minutes to build the web page (about 800+ records)
Save the web page as courselist.htm
Open VB program, check input file and output file variables
Run it. Program is done in the blink of an eye. The output
file name is typically called courses.csv
File now contains PRGM, CRSNUM, TITLE, CCNET
Fields are delimited by tabs
Rows are delimited by vbCRLF
Program can be modified to create a series of SQL statements that can be
imported directly into the SQL server.
Key VB files:
courselist.htm - Example of web page downloaded from Curricunet
courses.csv - Output from Curricunet Conversion Program (below)
The EMPLOYEES table contains the email, name, room#, category, telephone,
teaching discipline and web page url of ever employee (both full and part-time).
This table is constantly evolving and will probably have to be updated weekly.
How to Update the EMPLOYEES Table
Create a Master Excel spreadsheet with all of the names in it.
Send it to Reprographics Supervisor and have them update it as needed
Provide a web page where Reprographics Supervisor can upload Excel
spreadsheet to web server and execute a script that will automatically upload
all of the changes via a script.
