CSCI 1300: Essential
Computer Skills

Fall 2006

 

Coates
Library

Webopedia

Helpful
Links

MS Training

Helpdesk

Academic
Calendar

Tiger's Lair 

Blackboard

TigerPaws

Trinity 

CompSci

  ITS 

Google 

Computer Setup

Tutorials

NOTES # TOPICS HANDS-ON READINGS/ASSIGNMENTS
TR 8/24

 
1

Introduction to Course
Logon/Logoff
Password Management Site

Making a Weblog

Setting up a Blog on LiveJournal

LiveJournal FAQ

Choose computer for semester next class

1blog

Syllabus
Course Outline

ITS - Student Resources

Code of Ethics for Computing
Code of Ethics for Electronic Mail and Voice Mail

TU 8/29
1blog


 
2 Livejournal Updates

How to Create Shortcuts to Folders and Change Icons

2practice
2scavenge

General ITS Info:
Network Drives
and other important services

ITS FAQ

Lab: Desktop and My Documents

TR 8/31
2scavenge
 
3

Joe Hatch, Maintaining your Computer

copy 3netdrives to groups folder and use the file maintaining your computer to take notes.

 

3netdrives

Blog Update

Computer Security
Turn Off File Sharing

Protect AIM Account
Phishing, Email Scams, and Spoofing
Ebay Spoof Email Tutorial

Trojan Horses, Viruses, Worms, Spyware


Identity Theft (.gov site for education)

CCleaner (removes temporary files)
Hard Drive Clean and Defrag

Spyware Basics - take the quiz

Tutorial on drawings and pictures in Word

TU 9/5
3netdrives
 
4 Fred Zapata, Network Tour
4network
Advanced: Drawing in Word
MS Word Drawing Tools
TR 9/7
4network
 
5 Diane Graves and Jason Hardin:
Copyright
5BlogCopyright

Trinity University's Copyright Policy

TU library links on copyright
Copyright FAQs from US Gov't.
Copyright Policy for Students Using TU Resources
Ten Big Myths about Copyright Explained
Friends of Active Copyright Education
When Copying is OK: The "Fair Use" Rule
Copyright Challenge (take the quiz online)

Creative Commons (alternative to copyright)
Stock Exchange Photos (free photos)

Operating System: Windows XP (link to Lawrenceville Press website)

TU 9/12
5BlogCopyright

 
6 Quiz 1:

The quiz will cover everything we have done so far this semester, including hands-on assignments and practices in class, homework assignments, reading and information from all of our guest speakers.

MS Word Formatting Skills

 

6winword
Wireless Network Email from Jonathan Echols

MS Word:

Indentations and tables
Text boxes and layout
Insert and resize graphics
Format text in columns
Borders and text
Copy information from Internet to clipboard and insert in a table
Word Help (good reference)

Use Chapters 4 and 5 in your text as an additional reference

 

TR 9/14
6winword
 
7 Quiz Review

Windows Self-Assessment Review

MS Word Formatting Skills (Pt. 2)

7wordextras
Citation Machine
RefWorks

FYI - Translating in MS Word
TU 9/19
7wordextras
8 Benjamin Harris, Reference Librarian
TU Library
8internet
Before Pressing Send (GRASS test)
12 tips for email etiquette
Email Check List
Professional Email Video

Writing Effective Email

Text: Chapters 2&3
 

TR 9/21
8internet
9 Chris Nolan:
Internet Searches
9search
Searching the Internet (TU library)
Finding Information on Internet
Steps for Better Searching (advanced search on Google)
The Invisible Web
Evaluating Web Pages (Berkeley)

Developed for Faculty:
Google: Advanced Searching Tips

Text: Chapter 7 - Spreadsheets

TU 9/26
9search
10 Introduction to Spreadsheets:
MS Excel
10spread
Text: Chapter 7: Using a Spreadsheet, pp207-222, 230-232

Assignments -

Practice: Grades - Parts 1-3 and Part 5. (beginning on p. 210 and continuing through the chapter.) Use the blank file named Grades.xls in the 10spread folder

Practice: Examples p. 218-219 Use the blank file named Examples.xls in 10spread folder.


Ms. Jungman's Animated Excel Tutorials

Tutorials created by Ruth Jungman for
teacher training at Alamo Heights ISD

 
TR 9/28
10spread
11 Quiz 2:  Material covered from the beginning of the semester, including guest speakers

Spreadsheets (Continued)

11balance

Homework from Text:
Personal Finances Worksheet (p. 251)
Mileage_log (p. 262-3)
Mileage_summary (p. 265-6)

Reading:Text: Chapter 9 - Creating Charts

TU 10/3
11balance
12 Quiz 2, short review

Spreadsheets: Sorting, Filtering, Graphing & Formatting Charts

Intro to the Internet

12filter

Homework from Text:
CONTINENTS
TEMPERATURE
Pizza Palace

Read Chapter 8 (Working with Functions and Organizing Data)

Internet Basics, Part 1

(see notes page for locations)

 
TR 10/5
12filter
13 Review of homework - spreadsheet, chart Q&A

Internet Basics, Part 2

Introduction to Graphical Image Formats
13review

Homework:

Review for Midterm, including Internet Basics, Part 1&2 and Graphical Image Formats

Read Appendix B (Digital Images) in text (pp. 565-568)

 
TU 10/10
 
14 Midterm Exam    
TR 10/12
13review

15

Analyze midterm grades on spreadsheet
Linking Data Between Office Applications -
(Excel and PowerPoint)

Midterm Grades due for Ds and Fs

15data

Dynamic Links

Text: Chapter 14 (497-532) Creating Presentations

TU 10/17
15data

16

Bringing together graphics and presentations

Photodolls

Animating a GIF file in Photoshop Elements 3

Choosing hardware from Dell site

Last Day to Withdraw

16animate

What is a Digital Photo?

DPI and PPI explained

 
TR 10/19
16animate
17 PowerPoint: AutoContent Wizard, Design Template, from Scratch

Inserting Pictures into Slide Presentations
17slides
PPT Blog Update

Text: Ch. 15
Microsoft Training (good PowerPoint tutorials on special topics, fyi)

Recommendations for Faculty on PowerPoint (presentation to TU Teaching and Learning Committee, also presented at EDUCAUSE Conference)
Really Bad Power Point - and How to Avoid It

Sound files

TU 10/24
17slides
18 Advanced PowerPoint Techniques

Web Banners in Photoshop Elements (can also be used in PowerPoint)

18banner
19present
Making a Web Graphic with PSE and Layers

Photoshop Elements 3 Toolbar

Using Special Effects with Text in Photoshop Elements

Photoshop Elements Tips

Photocollage Basics 

TR 10/26
19present
19 Cybersecurity Presentation
Security Blog Entry
 

11:20 Class meets in Chapman Auditorium

TU 10/31
Security Blog Entry
20 Power Point Presentations and Critique

Advanced Photoshop Techniques

Adobe Photoshop Elements and Web Graphics
Download site for Adobe Photoshop Elements 5:
http://www.adobe.com/downloads/

20postcard
Photoshop Collages

Downloading PSE 5 from Adobe

FYI - Ms. Dewey

TR 11/02
 
21 Power Point Presentations and Critique

Scanning and resolution

Making an Album Automatically in PowerPoint

Registration

21scan
PPT Blog Entry
 

Image File Sizes

Image Size, Resolution, and format

Scan Wizard 5 in CLT

Scan Using the HP Software in Halsell Lab

Scan Using Photoshop Elements in Halsell Lab

 
TU 11/07
20postcard
21scan
PPT Blog Entry
22 Making an Album Automatically in PowerPoint

Intro to HTML

Final PowerPoint Presentations

22links
Getting Started with HTML
Fun and Easy HTML Tutorial
HTML Help
HTML Tags
TR 11/09
22links
23 Hexadecimal Colors

 

Front Page:

  • Navigation
  • Images
  • Tables
23webplan
FrontPage Tutorial

Key West Practice Site:

Making Hyperlinks in FrontPage

Hexadecimal Colors on the Web

Read: Web Colors Tutorial  

 

TU 11/14
23webplan
24 Short Quiz on HTML and Front Page

Imagemaps

Evaluating Website Design (Cont'd)

Interactive and Extra Web Page Features

24imagemap
25myweb (create in class)

Resize and Resample in FP

Color and Emotion
Color Picker
What is Color?

Interactive Buttons and Other Web Techniques

TR 11/16
24imagemap
25 Hardware

Fixing Photos

Work in Front Page

Corrections Folder
Front Page FAQs
TU 11/21
25myweb
26 Publish Webs

Course Evaluations CSCI-1300-1&3
(Thanks, TAs)

26siteblog
 
TR 11/23    

Thanksgiving Holiday

 
TU 11/28
26siteblog
27 Intro to Access and Databases
27access
Access 2003 Tutorial

Access introduction from Atomic Learning

Text: pp. 377-409

TR 11/30
27access
28 Mail Merge
28datamerge
 
TU 12/05
28datamerge
29 Final Exam (2 parts)    
TR 12/07   Reading Day    
    G. Senior Grades due 12/14
All others due noon, 12/18