Workshop

Description

Resources

Intro to Excel:

This is the beginners workshop for Excel to learn the basics. You will be taught how to create, save and edit spreadsheets, format cells, enter basic arithmatic functions, etc.

Pre-requisites:

• Basic keyboarding skills

• Basic math

Working Example

Finished Example Data

Intermediate Excel

Pick up from where you left off in the Intro to Excel workshop. Learn how to use formulas, advance in formatting, create multiple worksheets, link seperate worksheets, etc.

Pre-requisites:

• Intro to Excel

• Basic math

Working Example

Completed Sample

Advanced Topics Excel: Managing Data

This is the last workshop in the Excel series. This class covers the features used in Excel to manage and format data imported from external sources such as .csv or .txt files or created within the program in order to create usable content for use in reports. Manage large datasets by cleaning data, recoding data, deleting and consolidating data, sort data, and prepare data for creation of pivot table/reports.This class is useful to students that import data from external sources or that enter data into excel and need to create data reports/pivot tables.

Pre-requisites:

• Intro to Excel

• Intermediate Excel

Sales Sample .csv file

Sales Sample .txt file

Sales Sample Pivot/Table Report Completed

Intro To SPSS: Entering, Formatting and Analysing Data

In this course, students will learn how to navigate the different views and windows in SPSS, how to enter data collected from a sample study/survey directly into the SPSS data editor window, how to do some basic formatting of that data in SPSS, how to perform some basic descriptive statistics such as Frequencies and crosstabs, and how to save/copy/export the data, analysis results, and charts.

Pre-requisites:

• All attendees must be enrolled in a statistics class or have an assignment from that class.

• Undergraduate Students Only

Workshop Presentation

Sample Survey Data

Coding Scheme

Intermediate SPSS: Running Descriptive and Inferential Analyses for Data Imported into SPSS

In this workshop, students will learn how to import existing data from Excel into SPSS or from an SPSS data file .sav. We will go over how to manage a data set in SPSS e.g. Sorting or Transforming data variables in the Data View, learn the menu/options to select in SPSS to run the appropriate analysis types we need (Descriptive or Inferential Analysis types) for a sample assignment like Standard Deviation, Correlation, T-test, Chi-square and ANOVA, how to navigate through the Output Window after running an analysis and how to save and/or export work.

Pre-requisites:

• All attendees must be enrolled in a statistics class or have an assignment from that class.

• Undergraduate Students Only

Sample Excel Data (.xlsx)

Sample SPSS Data (.sav)

Workshop

Description

Resources

SafeConnect

Learn more about SafeConnect, a technology being implemented at Sac State to help promote a safe and secure computing environment.

Overview of SacCT Powered by Blackboard

Learn how to navigate and become familiar with the new features of SacCT 9.1 powered by Blackboard. 

Length: 90 mins.

You, Your Computer, and SacCT

Learn how to navigate and become familiar with the features of SacCT.

Length: 60 mins.

Why is my computer slow?

Learn how to make your computer run at its full potential. You will learn how to use tools found in Windows XP to optimize your computer’s speed.

This workshop consists of a presentation followed by hands-on instruction. You will have the opportunity in class to practice the tools and skills as you are learning them. Feel free to bring in your personal laptop, if you have one.

Length: 60 mins.

Anti-Virus and Anti-Malware

Learn how find and eradicate nasty viruses and malware. Put an end to slow internet connections and intrusive, annoying popups.

This workshop consists of a presentation followed by hands-on instruction. You will have the opportunity in class to practice the tools and skills as you are learning them. Feel free to bring in your personal laptop, if you have one.

Length: 60 mins.

Wireless lets me
do that?

Learn how to connect to SacLink Secure, download and install the wireless print drivers, how to use on campus wireless print services, and how to configure your computer to access SacFiles (On Campus U:Drive).

This workshop consists of a presentation followed by hands-on instruction. You will have the opportunity in class to practice the tools and skills as you are learning them. Feel free to bring in your personal laptop, if you have one.

Length: 60 mins.

The Computer Ate My Homework!

Learn how to set up and make sense of computer files and folder structure so you will never lose that homework assignment ten minutes before it’s due. You will learn how to use Windows Explorer, set up a friendly file structure and safeguard your files by storing them on SacFiles (On Campus U:Drive).

This workshop consists of a presentation followed by hands-on instruction. You will have the opportunity in class to practice the tools and skills as you are learning them. Feel free to bring in your personal laptop, if you have one.

Length: 60 mins.

Security Best Practices

Learn the Best Practices for Passwords, Security Software, Internet Browsing, Email, Files and Folders, and much more.

This workshop consists of a presentation followed by hands-on instruction. You will have the opportunity in class to practice the tools and skills as you are learning them. Feel free to bring in your personal laptop, if you have one.

Length: 60 mins.

Workshop

Description

Resources:

Intro to Word

This is the beginners workshop for Word to learn the basics. You will be taught how to create, save and edit a document, set margins and tabs, apply different fonts, etc.

Pre-requisites:

• Basic keyboarding skills

Length: 90 mins.

Intermediate Word

Pick up from where you left off in the Intro to Word workshop. Learn how to apply different styles, incorporate tables, use columns, insert pictures or objects, etc.

Pre-requisites:

• Intro to Word (or equivalent knowledge of Word)

Length: 90 mins.

Advanced Topics Word

This is the last workshop in the Word series. Become proficient in inserting citations, generating a table of contents, formatting pages using section breaks and page numbering, etc.

Pre-requisites:

• Intro to Word (or equivalent knowledge of Word)
• Intermediate Word (or equivalent knowledge of Word)

Length: 90 mins.

Intro to Powerpoint

This is the beginners workshop for Powerpoint to learn the basics. You will be taught how to create, save, and edit a presentation, implement a master slide, format the layout, print slides, etc.

Pre-requisites:

• Basic keyboarding skills

Length: 60 mins.

Intermediate Powerpoint

Pick up from where you left off in the Intro to Powerpoint workshop. Learn how to apply slide animations, embed a video, insert a picture, add sound effects, etc.

Pre-requisites:

• Intro to Powerpoint (or equivalent knowledge of Powerpoint)

Length: 90 mins.

Advanced Topics Powerpoint

This is the last workshop in the Powerpoint series. Gain a better understanding of the advanced features and available tools. After the workshop you will aquire the skills to produce a proficient final presentation. 

Pre-requisites:

• Intro to Powerpoint (or equivalent knowledge of Powerpoint)
• Intermediate Powerpoint (or equivalent knowledge of Powerpoint)

Length: 90 mins.

Office Drawing Tools

Learn how to navigate and use Office Drawing Tools. You will be taught how to create sections, use the picture and drawing tools, apply smart art, insert layers, shapes, and fills, etc.

Length: 60 mins.

Microsoft Word for Papers

Learn tips and tricks to make writing a paper easier.

 Sample Document

Workshop

Description

Resources

Module 1.
Introduction to Document Formatting

Teaches you our formatting methodology and what to expect from the workshops and the Student Tech Center.

Length: 30 mins.

Module 2.
Styles and Outline

Teaches you how to format your document easily using styles, view your document as an outline, and identify and fix formatting problems easily.

Length: 45 mins.

Module 3.
Illustrations

Teaches you how to caption images, charts and tables properly using captions. The content in this workshop is required to automate your lists of tables and figures.

Length: 45 mins.

Module 4.
Page Layout and Numbering

Guides you step-by-step through the complicated process of formatting your page numbers. This is the most common area of difficulty for students because of the long sequence of steps required.

Length: 50 mins.

Module 5.
Final Formatting

Walks you through the final steps of formatting your document, including inserting your table of contents, list of tables, and list of figures. This culminating workshop is predicated on the content in Modules 1-3.

Length: 50 mins.