240 likes | 372 Views
ISMT E-120. Desktop Applications for Managers. Office for the Web. Office for the Web. HTML & Server Basics Browsing Static Publishing Web Query with Excel Dynamic publishing Integration Through Internet Explorer. Office for the Web. HTML/Server Intro and Basics Browsing
E N D
ISMT E-120 Desktop Applications for Managers Office for the Web
Office for the Web • HTML & Server Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Office for the Web • HTML/Server Intro and Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
HTML/Server Intro and Basics • Your FAS account/server space • Basic HTML components • Secure FTP and telnet • Build and publish a page • Build and publish with an editor
Office for the Web • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Browsing • Word - Good • Excel – Pretty good • PowerPoint – No • Access – No
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Static Publishing • Word: Save as Web Page • Excel: Save as Web Page • PowerPoint: Save as Web Page • Access: Export as a Web Page
Static Publishing: Word • Office Component Most Suited to Publishing Web Pages
Word: What Works Well • Text Basics - <P>, indents, basic tables, justification • Character Format Basics • Bold, Italic • Color • Underline • Hyperlinks • Lists • Bulleted • Numbered
Word: What Works Quite Well • Pictures • Convert to GIF files • Unless already JPEG • Charts, Equations, OLE objects • Convert to GIF files • Fonts • Fixed vs. Proportional • Special fonts are often lost • Point Size – relative size only
Fancy Character Formats Shadow, emboss Drop character Drawings Animations Fancy Page Layout Headers, Footers Footnotes, end notes Fancy Text Revision marks, comments Columns Text borders Word: What May Work with Some Variability
Static Publishing: Continued • Excel • Worksheets • Charts • PowerPoint • HTML • PowerPoint Animation • Access
Excel: What Works Well • Text, Numbers, Numeric Formats • Table Structures • Basic Formatting
Excel: What Works Quite Well • Table Formatting • Borders • Alignment • Background color • Hyperlinks • Can insert – may not updated correctly
Excel: What May Work With Some Variability • Some Cell Formatting • Patterns • Wrapping • Formulas
Static Publishing: PowerPoint • HTML • PowerPoint Animation
Static Publishing: Access • Export database objects • Tables • Reports • Forms
Office for the Web • HTML/Server Intro and Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Web Query with Excel • Dynamic Web Query with Excel
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Dynamic Publishing Example • CGI-enabled example – current grade query
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Integration Through Internet Explorer • Internet Explorer as a Container