1 / 13

CE120

CE120. Computer tools for CE applications. Computer Tools Useful for CE Students. Excel Sending big files File Syncing PIMs Google Maps Others tools. Excel Demo. Pivot Tables VBA/Mac ros Solver (Add-Ins) Data Ribbon Custom Functions Concatenation Vlookup Handy Formulae.

lisandra-graham
Download Presentation

CE120

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CE120 Computer tools for CE applications

  2. Computer Tools Useful for CE Students • Excel • Sending big files • File Syncing • PIMs • Google Maps • Others tools

  3. Excel Demo • Pivot Tables • VBA/Macros • Solver (Add-Ins) • Data Ribbon • Custom Functions • Concatenation • Vlookup • Handy Formulae

  4. Sending Large Files • Zip compression • Right click, send to • No need to zip JPEGs, PNGs • Free services • www.yousendit.com • DropBox (public link) • FTP • Post to website

  5. File Syncing • Dropbox • 2.5 GB to 20+GB • Windows SkyDrive • Hotmail/Windows Live • 7 GB • Google Drive • Gmail • 5GB • Others…

  6. PIMs • Personal Information Manager • Contacts • Calendar • Task List • Notes

  7. PIMs • iOS • Exchange • Gmail • Yahoo! • Hotmail/Windows Live

  8. PIMs • Sending meeting requests • Checking availability • Sharing calendar • Doodle/When Is Good • Managing to dos • E-mail (unread, flag) • Task list • Notes • Other services • Evernote • Toodledo • Remember the Milk • Let's create a meeting (Outlook Web Access)

  9. Google Maps for Data Collection

  10. Google Maps for Data Collection

  11. KML file: Keyhole Markup Language • XML based file that expresses geographic annotation and visualization • KML files may be bundled and compressed with other files that they reference as single KMZ files • KML files hosted on Earth Browsers (public web server) • Many applications display KML, including Google Earth, Google Maps, Google Maps for mobile, NASA WorldWind, ESRI ArcGIS Explorer, Adobe PhotoShop, AutoCAD, and Yahoo! Pipes.

  12. Collaboration Tools • Google Docs • Office 360 • SVN • Git Version Control

  13. Questions? Eric Green, PE, MSCE, GISP Kentucky Transportation Center Research Engineer 140C Raymond Building University of Kentucky Lexington, KY 40506-0281 eric.green@uky.edu Phone: (859) 257-2680

More Related