1 / 13

Essential Computer Tools for CE Students: Master Excel, File Syncing, and PIMs

Discover a curated list of essential computer tools specifically designed for Civil Engineering (CE) students. Enhance your productivity with Excel features like PivotTables, VBA, and Solver while mastering file sending and syncing methods with services like Dropbox, Google Drive, and FTP. Organize your tasks effectively with Personal Information Managers (PIMs), ensuring you can manage contacts, calendars, and to-do lists. Explore how Google Maps can aid in data collection and visualization. This guide also includes collaboration tools like Google Docs and Office 365 for seamless teamwork.

lisandra-graham
Télécharger la présentation

Essential Computer Tools for CE Students: Master Excel, File Syncing, and PIMs

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