Trevor Smith
Instructor at Library Juice Academy- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Advanced Visio: Working with Data
LinkedInNov, 2019- Nov, 2024 -
Database Foundations: Storage
LinkedInJun, 2019- Nov, 2024 -
Master SQL for Data Science
LinkedInMay, 2019- Nov, 2024 -
Become an Access 2013 Microsoft Office Specialist
LinkedInJan, 2018- Nov, 2024 -
Access 2016: Reporting to Web Systems
Lynda.comSep, 2017- Nov, 2024 -
Microsoft StaffHub Essential Training
Lynda.comSep, 2017- Nov, 2024 -
Access 2016: Advanced Tips and Tricks
Lynda.comAug, 2017- Nov, 2024 -
Access 2016: Forms and Reports
Lynda.comAug, 2017- Nov, 2024 -
Access 2016: Queries
Lynda.comAug, 2017- Nov, 2024 -
Building Solutions Using Excel 2013 and Access 2013 Together
Lynda.comAug, 2017- Nov, 2024 -
SQL Essential Training
Lynda.comAug, 2017- Nov, 2024 -
Cert Prep: Access 2013 Microsoft Office Specialist (77-424)
Lynda.comJul, 2017- Nov, 2024 -
Microsoft Planner First Look
Lynda.comJul, 2017- Nov, 2024 -
Learning Microsoft Flow
Lynda.comJun, 2017- Nov, 2024 -
Learning Microsoft PowerApps
Lynda.comJun, 2017- Nov, 2024 -
SQL Tips, Tricks, & Techniques
Lynda.comJun, 2017- Nov, 2024 -
Advanced NoSQL for Data Science
Lynda.comMay, 2017- Nov, 2024 -
Learning Python
Lynda.comMar, 2017- Nov, 2024 -
Project Management Foundations: Procurement
Lynda.comMar, 2017- Nov, 2024 -
Power BI Pro Essential Training
Lynda.comFeb, 2017- Nov, 2024 -
Microsoft Project 2016 Essential Training
Lynda.comNov, 2016- Nov, 2024 -
Access: VBA
Lynda.comOct, 2016- Nov, 2024 -
Learning Power Pivot and SharePoint 2013
Lynda.comMay, 2016- Nov, 2024 -
Managing Projects with SharePoint 2013
Lynda.comMay, 2016- Nov, 2024 -
SharePoint Tips and Tricks
Lynda.comMay, 2016- Nov, 2024 -
Learning Raspberry Pi
Lynda.comNov, 2015- Nov, 2024 -
Cleaning Up Your Excel 2013 Data
Lynda.comOct, 2015- Nov, 2024 -
Office 2016 New Features
Lynda.comOct, 2015- Nov, 2024 -
Office Sway First Look
Lynda.comOct, 2015- Nov, 2024 -
Creating Interactive Dashboards in Excel 2013
Lynda.comSep, 2015- Nov, 2024 -
Master SQL for Data Science
Lynda.com
Experience
-
Library Juice Academy
-
United States
-
E-Learning Providers
-
1 - 100 Employee
-
Instructor
-
2021 - Present
Microsoft Access for Libraries * Introducing how to create tables, design forms, build reports, and packaging it all together. * Exercises will from library examples such as building a Reference Desk tracking system, merging disparate ILS reports, creating a year-end spending report, and preparing a report on a vendor title package against LC/DCC classification schemes. https://libraryjuiceacademy.com/shop/course/281-microsoft-access-for-libraries/ Microsoft Access for Libraries * Introducing how to create tables, design forms, build reports, and packaging it all together. * Exercises will from library examples such as building a Reference Desk tracking system, merging disparate ILS reports, creating a year-end spending report, and preparing a report on a vendor title package against LC/DCC classification schemes. https://libraryjuiceacademy.com/shop/course/281-microsoft-access-for-libraries/
-
-
-
Douglas College
-
Canada
-
Higher Education
-
700 & Above Employee
-
Metadata and Monograph Acquisitions Librarian
-
Sep 2015 - Present
* Monograph Acquisitions * Technical Services * Dept Chair (2017 - 2019) * EDCO member (2018 - 2020) * Prepare and teach 5-20 classes per term * Liaison Librarian for Humanitites & Social Sciences * Monograph Acquisitions * Technical Services * Dept Chair (2017 - 2019) * EDCO member (2018 - 2020) * Prepare and teach 5-20 classes per term * Liaison Librarian for Humanitites & Social Sciences
-
-
-
The University of British Columbia
-
Canada
-
Higher Education
-
700 & Above Employee
-
Adjunct Faculty Instructor
-
2015 - Present
LIBR 580, Collections Management Present * Instructing students on the fundamentals of collection development, analysis, and management LIBR/ARST 554, Database Design 2021-Present * Instructing students on sound database principles and how to create tables and SQL queries using MySQL LIBR/ARST 574 Project Management in Information Organizations 2015-Present *Introducing students to the Project Management Body of Knowledge and Agile Project Management * Train students in using Project Management documentation and software such as Microsoft Project
-
-
-
Capilano University
-
Canada
-
Higher Education
-
400 - 500 Employee
-
Librarian; Technical Services & Emerging Technologies
-
Sep 2012 - Aug 2015
o Technical Services and Emerging Technologies o Social Sciences Librarian o Assessment and Communications (previous) o Reference and directional assistance o Instructional workshops o Project Work o Millennium to Sierra ILS conversion o Library SharePoint site o Technical Services and Emerging Technologies o Social Sciences Librarian o Assessment and Communications (previous) o Reference and directional assistance o Instructional workshops o Project Work o Millennium to Sierra ILS conversion o Library SharePoint site
-
-
-
-
Librarian
-
2012 - 2013
o Virtual reference for BC post-secondary students o Virtual reference for BC post-secondary students
-
-
-
-
Graduate Academic Assistant
-
Dec 2010 - Apr 2012
cIRcle is the University of British Columbia's digital repository for research and teaching materials created by the UBC community and its partners. Materials in cIRcle are openly accessible to anyone on the web, and will be preserved for future generations. • Developed info-graphics and dashboards for the digital library’s usage • Inform users of UBC’s digital repository and copyright concerns • Upload and item map documents in DSpace • Contracted to develop a SharePoint Contact Management database
-
-
-
Environment and Climate Change Canada
-
Government Administration
-
700 & Above Employee
-
Ecosystem Technician
-
Oct 2011 - Mar 2012
Recommended and designed a custom in-house SharePoint document repository for legacy project files. Duties included: • Gathering user needs and FOI requirements • Ensuring site design met government specifications • Uploading all files, and coding meta-data Recommended and designed a custom in-house SharePoint document repository for legacy project files. Duties included: • Gathering user needs and FOI requirements • Ensuring site design met government specifications • Uploading all files, and coding meta-data
-
-
-
-
Information Scientist
-
2012 - 2012
During our stealth mode, I conducted research into various professional groups and affiliations and in developing a common taxonomy to locate and search for highly-skilled individuals. It was fun, challenging, and a secret. During our stealth mode, I conducted research into various professional groups and affiliations and in developing a common taxonomy to locate and search for highly-skilled individuals. It was fun, challenging, and a secret.
-
-
-
Wilp Wilxo’oskwhl Nisga’a Institute
-
Gitwinksihlkw, B.C.
-
Library Contractor
-
Aug 2011 - Aug 2011
Established a library catalogue of 3,000 titles for a post-secondary, First Nations Institute. Duties included: * Collection Development from community donations * Cataloging * Weeding * Train staff on library systems and procedures Established a library catalogue of 3,000 titles for a post-secondary, First Nations Institute. Duties included: * Collection Development from community donations * Cataloging * Weeding * Train staff on library systems and procedures
-
-
-
Simon Fraser University
-
Canada
-
Higher Education
-
700 & Above Employee
-
Bennett Library, Reference (Co-op)
-
May 2011 - Jul 2011
• Reference and directional assistance • Instructional workshops • Virtual reference through AskAway • Project work on Information Repository, Facebook, & journal reports • User testing of new database and searching tools • Reference and directional assistance • Instructional workshops • Virtual reference through AskAway • Project work on Information Repository, Facebook, & journal reports • User testing of new database and searching tools
-
-
-
-
Contractor
-
2010 - 2011
• Designing SharePoint content for 2007 and 2010 platforms • Designing SharePoint content for 2007 and 2010 platforms
-
-
-
The University of British Columbia
-
Canada
-
Higher Education
-
700 & Above Employee
-
Circulation and Shelving Assistant
-
2010 - 2011
• Handling student enquiries, check-in and check-out • Shelving and shelf-reading • Handling student enquiries, check-in and check-out • Shelving and shelf-reading
-
-
-
Government of Alberta
-
Canada
-
Government Administration
-
700 & Above Employee
-
Program Coordinator Asst.
-
Jan 2010 - Mar 2010
• Created custom database booking system for all guests on the Alberta Olympic Train from Vancouver to Whistler in Access 2007 • Trained staff in database usage and data entry, and increased productivity by 60% • Liaised with project stakeholders and greeted Alberta Government VIP guests • Prepared daily manifests in accordance with Federal guidelines • Created custom database booking system for all guests on the Alberta Olympic Train from Vancouver to Whistler in Access 2007 • Trained staff in database usage and data entry, and increased productivity by 60% • Liaised with project stakeholders and greeted Alberta Government VIP guests • Prepared daily manifests in accordance with Federal guidelines
-
-
-
Rocky Mountaineer
-
Canada
-
Travel Arrangements
-
300 - 400 Employee
-
Information Systems Manager
-
Jan 2009 - Nov 2009
• Identified departmental weaknesses and developed new business processes to increase average customer response times from 4 months to one week.• Developed SharePoint sites to increase communication and delivery of federally regulated reports from one week to instantaneous reporting.• Developed a call centre tracking system to report incoming client concerns.• Built extranet portals to provide schedule information to staff and external resource staff for procurement fulfillment.
-
-
Guest Relations Manager
-
Jan 2007 - Jan 2009
• Managed and responded to 3,000 guest concerns seasonally.• Researched topics to brief senior executives and to respond on their behalf.• Responsible for tracking and refunding $1 M in guest refunds.• Developed KPIs to track the development of emerging issues and offer corrective action to reverse negative trends.
-
-
Guest Relations Assistant
-
Apr 2005 - Dec 2006
• Create original responses to client enquiries and complaints.• Track client survey results and provide reports for senior management.
-
-
-
-
Member-at-Large (Graduate), Graduate Issue Committee
-
May 2003 - Apr 2004
• Represented Graduate Students for Simon Fraser University. • Chaired the Socials Committee to improve student invovlement in the university's development. Membership increased from 8 members to 32. • Chaired the Health Committee and developed a scope framework for investigating future Health Care coverage for all Graduate Students. • Represented Graduate Students for Simon Fraser University. • Chaired the Socials Committee to improve student invovlement in the university's development. Membership increased from 8 members to 32. • Chaired the Health Committee and developed a scope framework for investigating future Health Care coverage for all Graduate Students.
-
-
-
Simon Fraser University
-
Canada
-
Higher Education
-
700 & Above Employee
-
Teaching Assistant
-
Sep 2002 - Dec 2003
• Assisted in teaching first year European history classes. • Marked all tests and assignments for 45 students a semester. • Created original teaching content for audiences between 15 and 300. • Delivered weekly tutorials for students and evaluated their progress • Assisted in teaching first year European history classes. • Marked all tests and assignments for 45 students a semester. • Created original teaching content for audiences between 15 and 300. • Delivered weekly tutorials for students and evaluated their progress
-
-
-
-
Administration Assistant / Bookkeeper
-
1999 - 2001
• Bookkeeping duties include: setting up the company’s history on Accpacc, maintaining current financial records, and creating financial summaries. • Clerical duties such as writing, transcribing, and proof-reading letters, filing and database entry, taking meeting minutes, maintaining office supplies, and telephone reception. • Bookkeeping duties include: setting up the company’s history on Accpacc, maintaining current financial records, and creating financial summaries. • Clerical duties such as writing, transcribing, and proof-reading letters, filing and database entry, taking meeting minutes, maintaining office supplies, and telephone reception.
-
-
Education
-
2010 - 2012
The University of British Columbia
MLIS, Library and Information Studies -
2008 - 2009
Langara College
Certificate, Project Management -
2001 - 2004
Simon Fraser University
Masters of Arts, History -
1996 - 1999
Simon Fraser University
BA, English
Community
