COSC1300 Lab Assignments – Fall 2006 1
Homework 1
1. Bring your resume.
(One of the project works is to make your resume in 3 different styles)
2. 3-ring binder, diskette for lab
3. Get your diskettes or flash memory or … for Lab
Word
For each Word lab,
(1) Place your name in Word document (or in the heading) and
(2) Print all the Word document(s) when you are done.
Lab 1 – Do Tutorial 1 in pages WD 11-31 (Old Book: Word 1.15 – 1.34)
Lab 2 – Do Tutorial 2 in pages WD 44-78 (Old Book: Word 2.02 – 2.37)
Do Equation Formula. (For Tutorial: see http://www.richland.edu/james/editor/)
Lab 3 – Do Tutorial 3 in pages WD 92-125
Add your name to the footer,
Screen-Print Fig 3-8 and Fig 3-34 (Old Book: Fig 3-33)
Do Case 4 in pages WD 131-132 (Old Book: 3.38 – 3.39),
Only do steps 1-10 and type one (or two lines) for each cell (box).
Lab 4 – Do Tutorial 4 in pages (a) WD 137-164 and (b) WD 165-172.
Note: (a) WD165-172 Mail Merge is a new material (not in the old edition).
Screen Print Fig. 4-11 and 4-22 (Old Book: Fig 4-14 and Fig 4-25)
For (a), replace “us” (in “call us at 283-333-9010”) by your name in bold.
Do “Creating Web Pages with Microsoft Office 2003” WEB 6-13.
(Old Book: WORD Web pages 2-8. Do not do REVIEW ASSIGNMENT on the
bottom of page: WEB 8).
COSC1300 Lab Assignments – Fall 2006 2
Homework 2.
(a) Create a resume using Microsoft Word one of resume Template (in Template’s Other
Documents folder)
(b) Create a sample Fax coversheet using Fax Wizard Template.
(c) Create an organization chart (Insert => Picture => Organization Chart)
You may use an example of your family, your classroom, or your workplace, etc..
Excel
For each Excel lab,
(1) Place your name in Excel spreadsheet on the top (or in the heading) and
(2) Print all the final Excel spreadsheet(s) including all charts when you are done.
(If it is too much in pages, you may print only first few pages.)
Lab 1 – Do Tutorial 1 Pages EX5 – EX43
(Old Book: Do Tutorial 2, pages 1.07 – 1.19)
No screen print for this lab
Lab 2 – Do Tutorial 2 Pages EX52 – EX83
Screen Print Fig. 2-10 and 2-27.
(For Old Book: Do Tutorial 2. Screen Print Fig. 2-21 and Fig. 2-22)
Lab 3 – Do Tutorial 3 Pages EX96 – EX134, and Screen Print Fig 3-13 and Fig 3-16.
(For Old Book: Do Tutorial 3 and Screen Print 3-28 and Fig. 3-38)
Lab 4 – Do Tutorial 4 Pages EX146 – EX186 and Screen Print Fig 4-14 and Fig 4-33.
And Do INT 1-4 to INT 1-20.
(For Old Book: Do Tutorial 4 and Screen Print Fig. 4-34 and Fig. 4-37
and Do Integrating Word and Excel (after Excel Tutorial 4) - INT 1.03-1.20
Do not do Creating Web Pages with Excel. WEB.)
COSC1300 Lab Assignments – Fall 2006 3
Access
For each lab, print your results including Tables, Forms, Reports, Queries, etc.
If this generates too many pages, just print first page.
Note: !!!
1. Make sure that you save first the database in your Diskette or Flash Memory before
you start working on the database.
2. If the database table is large, just print first 1-2 pages
Lab 1 – Do Tutorial 1 Pages AC 7 – AC 27 and Screen Print Fig. 1-5 and Fig. 1-13.
(Old Book: Do Tutorial 1 and Screen print Fig. 1.12, Fig 1.13)
Lab 2 – Do Tutorial 2 Pages AC41 – AC71 and Screen Print 2-12 and 2-30.
(Old Book: Do Tutorial 2 and Screen Print Fig. 2-12 and Fig. 2-31.)
Lab 3 – Do Tutorial 3 Pages AC82 – AC120 and Screen Print 3-8 and 3-34.
(Old Book: Do Tutorial 3 and Screen Print Fig. 3-8 and Fig. 3-34.)
and Do Case Problem 1 in AC123 (Old Book: Case Problem 1 in AC 3.43)
Lab 4 – Do Tutorial 4 Pages AC 130 – AC160 and Screen Print 4-29 and 4-30.
(Old Book: Do Tutorial 4 and Screen Print Fig. 4-29 and Fig. 4-30)
and put your name next to the heading “Employers and Position” on the top.
and Do Case Problem 1 in AC 163 (Old Book: Case Problem 1 in AC 4.36).
PowerPoint
Lab 1 – Do Tutorial 1 and Screen Print Fig 1-22, Fig 1-27
Lab 2 – Do Tutorial 2 and Screen Print Fig 2-12, 2-36
And Do Creating Web Pages In Powerpoint WEB 26 – WEB 29
(Old Book: Creating Web Pages with PP in pages WEB 2 – WEB 8).
COSC1300 Lab Assignments – Fall 2006 4
Term Project
1. 3 resumes (You may use MS Word 3 resume-templates available).
2. Powerpoint presentation about your goal
3. and a few other items
4. and your presentation in class
Homework 3. (Also toward Final Project) Due: ______
Write an short essay on your goal to study (about 200 words) using Word. This is also a
part of your final project.
Homework 4. (Also toward Final Project) Due: ______
(1) Read I:\Min\COSC1300\word project\pdf note.doc
and to Install and create a PDF file for your Word Lab 4 (or Project)
(2) Read Install and create Zip file for all of your Lab files (and Project)
You may use PDFCreator (1) and WinZip (2) in I:\Min\COSC1300\freesoftware\
COSC1300 Lab Assignments – Fall 2006 5
For Final Exam Tips
1. Draw a block diagram of a typical computer architecture
2. Write top 4 categories of Computers
3. Name 3 main makers for Unix server market
4. List three popular database systems in the market
5. Explain Referential Integrity in a relational database
6. Name two popular script languages
7. Name two popular third-generation programming language (not Script language).
8. List OSI 7 layers of communication model
9. Explain TCP/IP (or where TCP and IP fit into which of OSI 7 layers)
10. Explain (a) MAC address, (b) IP address and (c) DNS?
11. List 4 hardware components commonly used in networking (the simplest one is Hub).
12. What are (a) Internet Service Providers and (b) Application Service Providers?
13. Name 3 web servers.
14. List at least 3 characteristics of the modern computer
15. Name a free or open-source UNIX system in the market
16. List a few ways to stop or prevent Virus or Worm, or Spyware
17. Explain Random Access versus Sequential Access for Storage Access
18. Identify the protocol and domain name from http://www.jnj.com/careers/index.html
19. What is most frequently used protocol for file download.
20. What is top-level domain for an educational institution?