The Project is for a Modular Intranet Template. We need to be able to insert Logos and pictures to personalize the Intranet and to update by changing Word, Excel, and Access Documents. The Home Page should have room for a Mission Statement, Announcements (updated with a Word Document), Industry Stock Pricing (Specific Stocks Updated from the Internet (Stock Symbols to be stored in an Excel Spreadsheet), Weather Forecast (Updated from the Internet and Location for Weather determined by Zip Code stored in an Excel Worksheet), and allow for the addition of the links to the following components:
- Employee Directory (To be updated by a Word Document)
- Employee Schedules (To be updated by an Excel Spreadsheet)
- Employee Manual (PDF)
- Document Repository
- Time Clock (Stored in Access Database) (Log In and Out by password or Biometrics)
- Suggestion Box (Submitted by E-Mail. E-Mail Address to be stored in an Excel Spreadsheet).
- Survey Form (Running Totals to be sent by E-Mail. E-Mail Address to be stored in an Excel Spreadsheet).
- Online HR Forms (Forms that can be filled out online, printed, and submitted by E-mail (E-mail address to be stored in an Excel Spreadsheet).
- In/Out Board
Also to include a Password Protected Area that displayed data showing sales and other financial data (Data to be stored in an Excel Spreadsheet or Access Database that will be automatically updated so these pages should have an automatic 5 minute refresh time). This page should have a summary of data with the ability to Drill-Down to more detail.
Results of Online Surveys should be available in this area.