Access 2010 Basics – use Access to collect, sort and manage data. In class we will setup a database to collect information, learn how to setup a table to house our data, create data entry forms, manipulate data (select, sort, etc.) via a query and create reports showing query results.
Angel Basics for Students – ANGEL is Penn State’s electronic (web based) course management system and is used in many undergraduate classes. In this introductory workshop, learn how to log on using your PSU access account, personalize your profile page, edit your preferences, use Angel email and mail forwarding, download documents including the course syllabus and use electronic drop boxes to submit assignments.
Excel 2010 Basics – use Excel to organize, calculate and analyze data. We will cover: basic formulas, inherited spreadsheets, recording & sorting data (excellent for mailing labels and recording other data), templates & pre-designed forms (saves labor), and charting/graphing data (visually displaying data).
Excel 2010 - Using Formulas – use Excel to calculate and analyze data. We will cover: entering formulas in a variety of ways, using the insert function and formula bar, using the formula tab, absolute and relative cell references in copying formulas, using the fill handle to quickly copy formulas or patterns.
Excel 2010 - Charting/Graphing - use Excel to analyze and view data graphically via Excel's charting/graphing commands. We will cover the basics of creating a chart/graph and the ribbons (toolbars) used to modify them.
Google Drive - use this on-line resource to store documents and to create wordprocessing and spreadsheet documents.
PASS Space (PSU on-line storage) – The University’s network storage system known as Penn State Access Account Storage Space (PASS) is provided to all students, faculty & staff. This electronic storage space can be used for a variety of needs including file sharing & data backups. Each individual starts with 500MB of storage space. Learn how to access and use this space to store and share files. Download workshop handout (PDF)
PowerPoint 2010 Basics – use PowerPoint to make effective presentations. Learn the basics of creating a PowerPoint presentation including: adding slides, using text boxes, sorting slides, showing your presentation, alternate delivery methods, color schemes, design schemes, inserting clip art & photographs, printing and slide transitions. Download workshop handout (PDF)
Publisher 2010 Basics – use templates and included options to quickly create desktop publishing documents. We will illustrate Publisher capabilities by creating a flyer. Features such as: template selection; selecting color schemes; selecting font schemes; using text boxes; using clip art & photographs; grouping & ungrouping objects; inserting graphics & customer addresses; inserting tear-offs for contact information, coupons, order forms, response forms and sign-up forms will be covered. Download workshop handout (PDF)
Smart Board (interactive whiteboard) & Sympodium (interactive computer monitor) Basics (for faculty & staff only) - covers the basics of Smart Board & Sympodium usage including saving your on-screen notes to the computer. Using the "Notebook" software with either platform allows the user to create slides that may include text, images, links and room for student interaction. Notebook software may be loaded onto your own computer to prepare presentations.
Twitter Basics – use Twitter to send and receive the thoughts of others. We will cover account setup and basic communication.