Technology, Systems, and Software
Access 2003 Fundamentals (Two day class)
Microsoft Access is the most popular database in the world. In this training course you will learn general database concepts and the main features of Access: tables, fields, forms, queries, and reports.
________________________________________
Access 2003 Intermediate (Two day class)
Continuing where the Introduction course left off, this 2-day training course will delve further into forms, queries, and reports in more detail.
________________________________________
Access and Excel Tips and Tricks
Learn tips and tricks to increase your efficiency and make both Excel and Access easier and fun to use. PREREQUISITE: You must already be familiar with Excel and/or Access to benefit from this class.
________________________________________
Access 2007 Fundamentals
MS Access is a database program used to create and organize relational databases.Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports.
________________________________________
Access 2007 Intermediate
MS Access is a database program used to create and organize relational databases. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.
________________________________________
Access 2007 VBA (Two Day Class)
This workshop will focus on using VBA within Access to build specific functions that will allow you to streamline your tasks and make your workflow more efficient.
________________________________________
Acrobat Fundamentals (Two Day Class)
Adobe® Acrobat lets users create documents from any file, preserving original layout, content, graphics and fonts. In this training course, students learn how to create PDF files for various applications, including the use of innovative features which add visual appeal and interactivity.
________________________________________
Ajax Fundamentals (Three Day Class)
This Ajax training will introduce you to the most exciting new technique in web development. Ajax is an acronym for “Asynchronous JavaScript and XML”.
________________________________________
ASP.net
In this class you will learn about active server pages, and their many uses in web technology.
Prerequisites: Classic ASP, VBscript or Visual Basic
________________________________________
Blogs and Wikis: Leveraging collaboration technologies
The presenter will explain the benefits of each, demonstrate the steps involved in creating and using them, and show how they can be useful for your team and organization.
________________________________________
Captivate Fundamentals (Two Day Class)
Learn to create interactive training videos to demonstrate software or show users how to navigate your web site.
________________________________________
ColdFusion (Three Day Class)
By the end of the training class, you will be able to create a secure web site with the ability to insert, update and search a database.
________________________________________
CSS Advanced
So you would like to make your site more accessible and usuable but you have run out of tricks using HTML and your basic knowledge of CSS? This class will decrease your dependence on tables and teach you advanced features that include positioning and layout.
________________________________________
CSS Fundamentals
This class will go over the basics of CSS allowing you to add your own style and unique attributes to web pages.
________________________________________
Distributed Computing Support at UCSF
This course is for people who have a role in supporting the computing needs of their departments. It introduces the model for computing support at UCSF and provides information about responsibilities and resources.
________________________________________
Dreamweaver Fundamentals
Learn how to use Dreamweaver 8 to create and publish Web sites. Students will learn how to define a Web site, format text, apply images, tables, and styles, create and format links, and publish a Web site.
________________________________________
Dreamweaver Intermediate
Students will learn how to apply CSS styles, manage site assets, create interactive forms, apply rollovers and other behaviors, and create dynamic Web pages that interact with a database.
________________________________________
Dreamweaver Advanced
This class focuses on advanced topics in Dreamweaver. Dreamweaver offers several features to create dynamic and database-driven web sites. In addition to developing standard client-side languages like HTML, CSS and Javascript, Dreamweaver can create server side code like ASP, PHP, JSP and ColdFusion. We will illustrate how to use these features in a practical web site application.
________________________________________
Excel 2003 Introduction
In this training course, attendees learn basic spreadsheet concepts and core MS Excel features including worksheets, workbooks, cells and formulas.
________________________________________
Excel 2003 Intermediate
Continuing where the Excel Fundamentals training course left off, this one-day class delves further into the use and design of worksheets and workbooks. Course attendees also learn advanced functions.
________________________________________
Excel 2003 Advanced
This Advanced Excel training course helps students master the application, offering comprehensive instruction in the use of macros, pivot tables, vlookup/hlookup and more.
________________________________________
Excel 2007 Advanced
This Advanced Excel training course helps students master the application, offering comprehensive instruction in the use of macros, pivot tables, vlookup/hlookup and more.
________________________________________
Excel 2007 Intermediate
Continuing where the Excel Introduction training course left off, this class delves further into the use and design of worksheets and workbooks. Course attendees also learn advanced functions.
________________________________________
Excel 2007 Introduction
In this training course, attendees learn basic spreadsheet concepts and core MS Excel features including worksheets, workbooks, cells and formulas.
________________________________________
Excel Techniques (Live On Line)
Note! This is an online class where you will log on to a website, watch and interact with an instructor to learn your topic of choice. After you have attended the live on line session you will be given access to a recorded video of the same topic that you just took in order to watch again for something you missed or use for later use.
This workshop is for users of Microsoft Excel who want to take their skills to the next level. It teaches powerful techniques that save time and enable the user to manipulate data and extract important business insights, present information in a compelling way, and collaborate with others more effectively.
________________________________________
Excel 2007 VBA (Two Day Class)
This workshop will focus on using VBA within Excel to build specific functions that will allow you to streamline your tasks and make your workflow more efficient.
________________________________________
Filemaker Fundamentals
This class teaches the core features and functions of FileMaker Pro 8. Students will learn how to view, edit, sort, and search for records, create databases, import data, and design layouts.
________________________________________
Flash Fundamentals (Two Day Class)
Use Adobe Flash to add creative animations and illustrative animations to your web site incorporating sound and video effects.
________________________________________
Flash ActionScript (Three Day Class)
Macromedia Flash 8: ActionScript is designed to teach experienced Flash designers the fundamentals of programming Flash Player content using the ActionScript programming language.
________________________________________
Flex Fundamentals
This training course explores the primary features of Flex used to create Rich Internet Applications. Attendees gain hands-on instruction with events, controls, containers, constraint-based layout, DataGrids and more
________________________________________
Flex Intermediate
This class builds upon the Flex Fundamentals Class and Covers Data and Communications.
_______________________________________
Information Security Fundamentals
This course is intended to provide IT professionals at UCSF with a comprehensive understanding of come key network and computer security principles. It is strongly recommended for any individual who has administrator privileges.
________________________________________
Information Security Policy & Privacy Practices
This course on electronic security regulations and policies is strongly recommended for any individual who has system administrator priviledges.
________________________________________
Installing and Configuring Key Tools (part 1)
This course introduces students to four key software tools licensed for use on any UCSF workstation: Sophos, Sygate, Spy Sweeper, and VPN.
________________________________________
Installing and Configuring Key Tools (part 2)
This course introduces students to three key software tools licensed for use on UCSF workstations and servers: SSH, Fugu, and Tripwire.
________________________________________
Intro to Programming (Two Day Class)
This workshop will cover the basics of programming using the JavaScript language. You will learn many different concepts including conditionals, loops, functions and objects.
________________________________________
IT Governance at UCSF
This course introduces the IT governance model at UCSF. It covers the process by which campus IT polices and guidelines are developed, reviewed and adopted. It also covers current campus policies pertaining to network, web and identity services.
________________________________________
Java Fundamentals (Five Day Class)
This workshop is designed to give proficiency in developing applications and applets as well as build visually interesting GUI and web-based applications.
________________________________________
Javascript for Programmers
This workshop integrates JavaScript into your programming language skillset and teaches you integrating JavaScript with HTML and CSS.
________________________________________
Project 2007 Fundamentals
Project Management Professionals (PMPs) around the world choose MS Project to align their project teams, manage tasks, and keep project stakeholders informed. Make sure you are getting the most out of this robust program that can be one of your strongest assets in your role as a manager.
________________________________________
Microsoft Project Techniques (Live on Line)
In this workshop, users learn powerful techniques that can help them save significant time, while effectively planning their project tasks and resources, managing internal and external demands, and communicating at all levels.
________________________________________
Microsoft Visio
When you’ve completed the course, you will have a firm grasp of all of the skills needed to create any kind of diagram using Visio.
________________________________________
Microsoft Word Techniques (Live on Line)
This workshop will teach you powerful techniques that will save time and grow your skills in manipulating and formatting documents, presenting information in a compelling way, and collaborating with others more effectively.
________________________________________
Outlook 2007 Introduction
This course will provide you with the skills you need to start sending and responding to email in Microsoft Outlook 2007, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes.
________________________________________
Outlook 2007 Intermediate
Learn to customize Outlook, used advanced inbox, Calendar and Contacts features, manage tasks, use Outlook as a desktop manager, integrate Outlook with other Office products and use Outlook with the Internet.
________________________________________
PAM of EMF- Advanced OLFS WebLinks for Sponsored Projects
In this course you will build upon the concepts and knowledge base you developed in previous PAM courses as well as the concepts and skills you practiced in General Ledger and Fund Accounting using OLFS WebLinks – Part 1 & Part 2. We will use WebLinks reports to explore a variety of scenarios and determine if there is a problem, what the problem is, and how to correct it.
Intended for:
Post-award RSAs, MSOs, department managers and administrators who manage extramurally funded sponsored agreements
Mandatory Prerequisites
Introduction to Sponsored Research (WebCT)
Research Administration System (RAS) Post-Award
General Ledger & Fund Accounting using OLFS WebLinks – Part 1
General Ledger & Fund Accounting using OLFS WebLinks – Part 2
Suggested Prerequisites
PAM of EMF: Award Set-Up
PAM of EMF: Billing and Reporting
PAM of EMF: Revenue, Cash Management and Collections
PAM of EMF: Compliance
________________________________________
PAM of EMF- Award Closeouts and FSRs
This course is designed to provide the basics of sponsored research award closeouts, the general rules we need to be aware of, our campus procedures, and an inside look at the EMF closeout process.
________________________________________
PAM of EMF- Award Set-up
This course will assist campus managers and administrators to navigate the set-up activities between the Research Administrative System (RAS), the General Ledger (GL), and the Account Fund Profile (AFP) systems, and to ensure that each award complies with Generally Accepted Accounting Principles (GAAP), university, and external sponsor restrictions.
Intended for: RSAs, MSOs, department managers and business managers who manage extramurally funded sponsored agreements and who want to learn about their responsibilities and role in the how their awards are set up in RAS and AFP.
Mandatory Prerequisite Courses:
Introduction to Sponsored Research (WebCT)
General Ledger/Fund Accounting using OLFS Weblinks - Part I
Research Administration System (RAS) Post-Award
Suggested Prerequisite Course:
General Ledger/Fund Accounting using OLFS Weblinks-Part II
________________________________________
PAM of EMF- Billing and Reporting
In this class, learn to review your award agreements and identify type of interim billing or interim financial status report to be performed, and the specific billing and reporting requirements. Understand the EMF billing and reporting processes and clarify your role as a department administrator in the various processes.
Intended for:
- RSAs, MSOs, department managers and business managers who oversee extramurally funded sponsored agreements and who want to learn about their responsibilities and role in the interim billing and reporting of award charges to sponsor agencies
- EMF staff who want to learn the billing and reporting processes and how the departments and EMF share responsibility for these processes
Prerequisite: PAM of EMF: Award Set-up
________________________________________
PAM of EMF- Compliance
Learn the key compliance issues and audit risks when managing sponsored projects, including associated internal controls. Understand issues surrounding OMB circulars, allowable/unallowable costs, cost transfers, cost sharing, and effort reporting.
Intended Audience: Post-award RSAs and administrators
Mandatory Prerequisite Courses:
• Introduction to Sponsored Research (WebCT)
• RAS Post-Award (WebCT)
• ERS Training Course (WebCT)
Mandatory Prerequisite Reading:
• Understanding the basics of OMB Circulars A-21, A-110, A-133
• ERS job aids: http://acctg.ucsf.edu/ers/index.htm
• Understanding cost accounting standards: http://acctg.ucsf.edu/extramural_funds/policies/ (bottom of page)
• Review of cost sharing documentation: http://acctg.ucsf.edu/extramural_funds/policies/ (top of page)
Suggested Prerequisite Courses and Meeting Attendance:
• General Ledger/Fund Accounting using OLFS Weblinks -Part I
• General Ledger/Fund Accounting using OLFS Weblinks-Part II
• PAM of EMF: Award Set-Up
• PAM of EMF: Billing and Reporting
• PAM of EMF: Revenue, Cash Management, and Collections
________________________________________
PAM of EMF- Revenue, Cash Management, and Collections
This class will assist campus departments to understand key concepts and practices regarding revenue, cash, Accounts Receivables (AR), and collections of sponsored agreements. The class will also cover the EMF cash management structure, types of payments in and outside of RAS, key accounting concepts, and tools to manage your revenue.
Mandatory Prerequisite Courses:
Introduction to Sponsored Research (WebCT)
PAM of EMF 1: Award Set-Up
General Ledger/Fund Accounting using OLFS Weblinks - Part I
Research Administration System (RAS) Post-Award
Suggested Prerequisite Course:
General Ledger/Fund Accounting using OLFS Weblinks-Part II
Perl Bootcamp
Perl is a very handy programming language that can be used in a wide variety of applications from system admin tasks or for creating dynamic web pages using a CGI protocol. In this class you will learn the ins and outs of the program from the basic to the advanced level
________________________________________
Perl Bootcamp
This Perl training course is geared toward programmers who know at least one other language, but have no experience in Perl. Over the five days we cover everything from variables, loops, and conditionals to pattern-matching, references, modules, xml, and database integration.
________________________________________
Photoshop Fundamentals (Two Day Class)
This course will introduce you to Photoshop and also explain some common concepts within the software.
________________________________________
Photoshop Advanced (Two Day Class)
This course is for users of Photoshop who would like to know more about retouching, color correction and other advanced techniques in custom imaging.
________________________________________
PHP & MySQL Training Course (Five Day Class)
The PHP and MySQL combination of technologies is currently the most popular web platform. Over the span of five days, you will learn how to integrate the two most common web servers, the MySQL database server, and the PHP programming language.
________________________________________
PowerPoint 2003 Introduction
MS PowerPoint is used to create dynamic and professional slide shows that utilize texts, graphics, charts and diagrams to organize and enhance presentations. This introduction teaches the basics of inserting and manipulating text, graphics and slides.
________________________________________
PowerPoint 2003 Intermediate
MS PowerPoint is used to create dynamic and professional slide presentations. It offers users the opportunity to create and modify graphics, charts, tables, and diagrams. These topics are covered, in addition to techniques to customize presentation designs and to create and deliver slide show presentations.
________________________________________
PowerPoint 2003 Advanced
MS PowerPoint is used to create dynamic and professional slide presentations. Advanced multimedia features such as audio and video integration, hyperlinks and interactivity can effectively illustrate a point and capture audience attention. These techniques are taught, in addition to: how to embed charts and Excel objects and how to peer review, package, publish and broadcast captivating slide show presentations.
________________________________________
PowerPoint 2007 Introduction
MS PowerPoint is used to create dynamic and professional slide shows that utilize texts, graphics, charts and diagrams to organize and enhance presentations. This introduction covers the basic functions and features of PowerPoint 2007. Students will create new presentations that include text, graphics, WordArt, tables, charts, and diagrams. They will also edit and format slide content, and apply transition effects.
________________________________________
PowerPoint 2007 Intermediate
Continuing where the PowerPoint Introduction course left off, this class delves further into its features including common font and color schemes, notes and handouts, animation, customized design, charts and data tables.
________________________________________
PowerPoint 2007 Advanced
This training class continues where the PowerPoint 2007 Intermediate left off. Topics include how to distribute a presentation, action buttons, customizing graphics, adding multimedia content and creating custom themes & templates.
________________________________________
PowerPoint 2003 Introduction
Learn the basic concepts of PowerPoint. Learn to create, edit and print presentations, format text, proof, work with objects, use WordArt and ClipArt, and build and run a slide show.
________________________________________
PowerPoint 2003 Intermediate
Learn the intermediate features of PowerPoint: slide outlines, charts and tables, multimedia elements, templates, animation, slide linking, presentation preparation.
________________________________________
PowerPoint 2003 Advanced
Our PowerPoint 2003 Advanced training class will turn you into a PowerPoint expert with added know-how around tasks like adding effective graphical and multimedia content creating stand-alone slideshows with integrated voice narration.
________________________________________
PowerPoint 2007 Advanced
Sharpen both your development and your delivery skills: learn more about organizing multiple slideshows, setting up master slides, adding buttons and multimedia effects to your slides, and saving time by integrating information from other Office applications.
________________________________________
PowerPoint 2007 Intermediate
Today it’s no longer enough just to create “slide shows” using simple text and images on a colored background - presentations have become much more complex and creative. Learn how to make compelling, professional presentations that inspire and persuade your audience - by adding animation, sound, and graphics that really get the message across.
________________________________________
PowerPoint 2007 Introduction
Make yourself heard with Microsoft PowerPoint, the leading software for delivering professional presentations. Our introductory PowerPoint training will quickly get you up and running with this Office-integrated application that allows you to combine graphics, text, and animation effects in elegant, dynamic slideshows that are sure to get your message across.
________________________________________
PowerPoint techniques (Live on Line)
This workshop is for business users who use Microsoft PowerPoint and want to take their skills to the next level. You will learn powerful techniques that will save time and improve your ability to manipulate and format presentations, convey information in a compelling way, and collaborate with others more effectively.
________________________________________
PowerPoint Tips and Tricks
Learn to speed up your work in PowerPoint using a variety of techniques including: quick incorporation of charts and graphics into presentations, techniques for moving and selecting, timesaving toolbar and double-click tricks, and quick ways to work with multiple files and windows.
________________________________________
QuickBooks Fundamentals
This course covers the fundamentals of using QuickBooks 2008 to track the finances of a small business. Students will learn how to set up a new company, manage bank account transactions, maintain customer and vendor information, generate reports, and write and print checks. They will also create invoices and credit memos, add custom fields, set up budgets, and learn about data backup/protection.
________________________________________
SharePoint Fundamentals
Training class introduces students to creating web pages using SharePoint Designer. Class focuses on web page layout, images, layers, tables, data-driven web pages and site managment.
________________________________________
SharePoint Techniques (Live on Line)
This workshop is for business users who wish to use Microsoft SharePoint to track and share information and collaborate with others. It will show you how to:
________________________________________
SQL Scripting (2 day class)
Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions.
________________________________________
Web Design Program (24 Evenings)
This 24-evening program meets twice a week on Mondays and Wednesdays, 6pm-9pm at AcademyX’s downtown training facility. Over the course of three months, students learn how to lay out, design, and publish professional web sites.
________________________________________
Word 2003 Introduction
Students will gain a solid understanding of the basic concepts and features in Word.: opening, closing and saving files, formatting text, the most commonly used menu items, formatting text, and printing.
________________________________________
Word 2003 Intermediate
MS Word offers several incredibly useful features that are used in many different types of documents. Notable among these are table layouts, insertable graphics, and mail merges. Students will learn these and other important features.
________________________________________
Word 2003 Advanced
MS Word has many advanced features that you can implement in order to create sophisticated documents. User interactivity features such as macros and forms are covered in addition to advanced formatting options. Students will learn these and other advanced topics, such as inserting MS Excel data into Word documents.
________________________________________
Word 2007 Introduction
This class will give you an understanding of the concepts and features of Microsoft Word. You will learn the basics of the program that will allow you to create, edit, format and save documents.
________________________________________
Word 2007 Intermediate
Continuing where the Microsoft Word Introduction course left off, this one-day training class teaches students how to use tables, borders, graphics and other special features. Students also learn how to merge two or more documents into one.
________________________________________
Word 2007 Advanced
This course includes discussion on the following topics: styles, templates, fields, macros, forms, graphics, charts, diagrams, importing worksheet data, using collaborative tools.
________________________________________
Word Level 2003 Introduction
Learn the basic features of Microsoft Word: document creating, saving, printing, formatting, proofing, editing and more.
________________________________________
Word Level 2003 Intermediate
Learn the intermediate features of Microsoft Word: working with graphics, using advanced formatting options, using headers and footers, working with columns, using styles, creating and formatting tables, using basic collaboration features, working with charts, and using diagrams and organizational charts.
________________________________________
Word Level 2003 Advanced
In this one-day course gain competency in creating forms; working with form fields; enhancing, protecting and testing forms; using the mail merge tool to create form letters, labels and envelopes; and using advanced collaboration features.
________________________________________
XML Fundamentals (Three Day Class)
This workshop will cover a few of the technologies that comprise XML, while providing you with enough exposure to edit and customize the display (in a browser) of XML documents.
________________________________________
XSLT Fundamentals
The Intermediate client-side XML class examines XPath and XSLT. XSLT is used to transform your XML documents into a format appropriate for particular applications (e.g., browsers) such as HTML or text. XPath allows you to specify a location in the referenced XML document to indicate which content or information you would like to use or extract.
________________________________________