1 / 13

Essential Computer Tools for CE Students: Excel, File Syncing, PIMs & Data Collection

This resource provides a comprehensive overview of essential computer tools beneficial for CE students. Explore powerful applications like Excel for data analysis, file syncing options such as Dropbox and Google Drive for sending large files, and personal information managers (PIMs) for effective organization. Learn how to handle KML files with Google Maps for data collection and leverage collaboration tools like Google Docs. This guide also covers Excel features including PivotTables, VBA/Macros, and handy functions that streamline your study tasks.

lark
Download Presentation

Essential Computer Tools for CE Students: Excel, File Syncing, PIMs & Data Collection

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