Databases

In order to work successfully with databases, one needs to understand how they are organized. This blog post is designed to provide a working knowledge of database organization and to introduce basic terminology you will need for mastering Access.

Reminder:

You can click on any screenshot image to spawn a new window with an enlarged image for easier reading.

Excel tutorial #1 - spreadsheets

In order to work successfully with spreadsheets, one needs to understand how they are organized. This blog post is designed to provide a working knowledge of spreadsheet organization and to introduce basic terminology you will need for mastering Excel. Scroll to the bottom of this post to see a labeled screenshot of an example spreadsheet.

First Excel class file

I have typed up the first part of the Excel tutorial for today's class instead of having everyone type the whole thing during class time. The file has been uploaded to Google Docs.

First Word class files

I have typed up the first part of the Word tutorial for today's class instead of having everyone type the whole thing during class time. The file has been uploaded to Google Docs. The other documents needed have also been uploaded.

Using Grader

This semester, we are using a relatively new functionality in myItLab. It is called "Grader" and was recently included in the suite of tools available in myItLab.

Most of your Office homework assignments will be completed using Grader so this is a tutorial to ensure that all students are clear on how to use the tool.

First class files

The files needed for today's class have been uploaded to Google Docs.

Hotkeys

When working in Microsoft Office, there are a number of hotkeys available to you. Hotkeys are combinations of keystrokes which allow you to do (quickly) certain operations such as bolding text, moving around the document, and saving your work.

How to create an effective presentation

During our first class, you will be creating a PowerPoint presentation about yourself. These are some basic guidelines for creating effective PowerPoint presentations: