Download - ISMT E-120
![Page 1: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/1.jpg)
1
ISMT E-120Desktop Applications for Managers
Office for the Web
![Page 2: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/2.jpg)
2
Office for the Web• HTML & Server Basics• Browsing• Static Publishing• Web Query with Excel• Dynamic publishing• Integration Through Internet Explorer
![Page 3: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/3.jpg)
3
Office for the Web• HTML/Server Intro and Basics• Browsing• Static Publishing• Web Query with Excel• Dynamic publishing• Integration Through Internet Explorer
![Page 4: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/4.jpg)
4
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
![Page 5: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/5.jpg)
5
Office for the Web• Browsing• Static Publishing• HTML/Server Intro and Basics• Web Query with Excel• Dynamic publishing• Integration Through Internet Explorer
![Page 6: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/6.jpg)
6
Browsing
• Word - Good • Excel – Pretty good• PowerPoint – No• Access – No
![Page 7: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/7.jpg)
7
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
![Page 8: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/8.jpg)
8
Static Publishing
• Word: Save as Web Page• Excel: Save as Web Page• PowerPoint: Save as Web Page• Access: Export as a Web Page
![Page 9: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/9.jpg)
9
Static Publishing: Word
• Office Component Most Suited to Publishing Web Pages
![Page 10: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/10.jpg)
10
Word: What Works Well• Text Basics - <P>, indents, basic tables,
justification• Character Format Basics
– Bold, Italic– Color– Underline
• Hyperlinks• Lists
– Bulleted– Numbered
![Page 11: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/11.jpg)
11
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
![Page 12: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/12.jpg)
12
Word: What May Work with Some Variability
• 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
![Page 13: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/13.jpg)
13
Static Publishing: Continued
• Excel– Worksheets– Charts
• PowerPoint– HTML– PowerPoint Animation
• Access
![Page 14: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/14.jpg)
14
Excel: What Works Well
• Text, Numbers, Numeric Formats• Table Structures• Basic Formatting
![Page 15: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/15.jpg)
15
Excel: What Works Quite Well
• Table Formatting– Borders– Alignment– Background color
• Hyperlinks– Can insert – may not updated correctly
![Page 16: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/16.jpg)
16
Excel: What May Work With Some Variability
• Some Cell Formatting – Patterns– Wrapping
• Formulas
![Page 17: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/17.jpg)
17
Static Publishing: PowerPoint
• HTML
• PowerPoint Animation
![Page 18: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/18.jpg)
18
Static Publishing: Access
• Export database objects– Tables– Reports– Forms
![Page 19: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/19.jpg)
19
Office for the Web• HTML/Server Intro and Basics• Browsing• Static Publishing• Web Query with Excel• Dynamic publishing• Integration Through Internet Explorer
![Page 20: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/20.jpg)
20
Web Query with Excel • Dynamic Web Query with Excel
![Page 21: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/21.jpg)
21
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
![Page 22: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/22.jpg)
22
Dynamic Publishing Example • CGI-enabled example – current grade
query
![Page 23: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/23.jpg)
23
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
![Page 24: ISMT E-120](https://reader035.vdocuments.us/reader035/viewer/2022062520/568164d6550346895dd71480/html5/thumbnails/24.jpg)
24
Integration Through Internet Explorer
• Internet Explorer as a Container