Training Materials
This collection of training materials includes handouts, which
were developed for TEC workshops. Materials are organized in
three main categories: MS Office (including Access, Excel, PowerPoint,
and Word), Internet, and Miscellaneous.
Note: these materials are in PDF Format and require
Adobe Reader to view them. If you do not have this software,
click
here for a free download.
M
S
O
F
F
I
C
E |
Access,
Working with |
Access
workspace, design and develop a small database, create
tables with primary keys and relationships, create queries,
create forms. |
| Excel,
Working with |
Excel
workspace, freezing panes and splitting worksheets, cursor
changes, entering data, AutoFill, AutoCorrect, formatting
numbers, formulas and functions, charts and linking cells
and sheets. |
| Excel,
Beyond the Basics of |
Calculating
with ranges of cells, composing and using formulas and
functions, using analysis tools such as tracking precedents
and dependents, validating data, and evaluating formulas,
protecting a workbook, tracking changes made to a workbook,
and using macros and toolbars to increase productivity. |
| PowerPoint,
Working with |
PowerPoint
workspace, presentation views, slide and title master,
adding text to slides, adding graphic images, slide transitions
and animations, adding movies and sound, various ways
to print a presentation and effective presentation tips. |
| PowerPoint,
Beyond the Basics of |
Creating
templates with the slide master, basic info about multimedia
files, adding audio, sound, and video, manipulating and
inserting photos and graphics, setting up a slide show,
adding speaker notes, and additional information on where
to obtain multimedia files to use within a PowerPoint
document. |
| Word,
Working with |
Organizing
text with margins, indents, tables, tabs, and columns,
creating and formatting headers and footers, adding endnotes
and page numbers, creating document sections and apply
specific formatting to each. |
| Word,
Beyond the Basics of |
Manipulate
and customize toolbars, create and edit an index and table
of contents, adding form fields, collaboration tools (track
changes, make comments, save versions) and creating macros. |
| MS
Office Mail Merge |
Definition
of mail merge, create and edit three data sources: a Word
table, an Excel spreadsheet and an Access database, practice
working with merge documents. |
| MS
Office Collaboration Tools |
Add
highlighted areas, comments and track changes to a collaborative
document, save different versions of a document. |
| MS
Office Learning Tools |
Templates
and wizards, online resources and tutorials that help
teachers use the Microsoft Suite as a learning tool, and
sample MS Office integration lessons. |
| MS
Office Draw Tools and Graphics |
Manipulate
graphics, moving, copying, changing appearance, deleting,
ungrouping and grouping. Use in both PowerPoint and Word.
Create original graphic images using the Office Draw Tools. |
I
N
T
E
R
N
E
T |
Browser
Tips and Tricks |
Identify
components of the two major Internet browsers, customize
toolbars, manipulate Preferences or Options, work with
bookmarks/favorites, discover online resources for learning
more about your browser. |
| Internet
Searching Strategies |
Define
search engine, a directory, an index, and portal, conduct
basic key word searches, use advanced searching techniques,
including Boolean operators. |
| HTML
Quick Tips |
HTML
is a "language" that web browsers use to determine how
to display information on a web page. It is made up of
a series of commands or "tags" that are customized to
meet the specific demands of a web page. |
| Creating
a Dynamic Syllabus |
Explore
elements of interactive, dynamic syllabi, analyze different
online syllabi, email and page links, graphics and video,
communication tools such as threaded discussions, live
chats, email lists and PDF files. |
| Netscape
Messenger |
Setup
Netscape Messenger for UNM email. |
| Put
Your Syllabus Online |
Create
a syllabus document in Word using Microsoft's syllabus
template and wizard. Save and edit as HTML, upload to
UNM CIRT web server. |
| Web
Publishing with Netscape Composer |
Design
a basic web page, work with formatting text, organize
text with tables, add graphic images, email and page links,
change background and text, and publish page to the CIRT
web server. |
| WebQuest
Design and Evaluation |
Learn
the 6 building blocks of a WebQuest, work with a rubric
for evaluating WebQuests and with a Process Checklist
for the process section. |
M
I
S
C
|
Working
with Peripherals |
Different
types and uses of peripherals, hands-on experience setting
up and using different types of peripherals. |
| Creating
PDF Documents |
Process
for creating a PDF document from a document originally
created in Word, Excel, PowerPoint or other application,
add additional features such as text boxes, thumbnails
and bookmarks, add security and prepare for posting on
the Internet. |
| Inspiration |
Software
tool to help you develop ideas and organize your thinking
by creating outlines and diagrams called webs or mental
maps. |
| iMovie |
Desktop
application that allows you to design, edit, and produce
digital movies. |
| CD
Burning |
Use
CD-R and CD-RW for electronically recording, storing,
and playing back audio, video, text, and other information
in digital form. |
| Atlas
TI |
This
document contains information on using Atlas TI for qualitative
data analysis. It was contributed by Karen DeMoss. |
|
