CS110 Intro to Personal Computing & the Internet

Study Guide for the Course Final Exam

II. UNIX and the Web (WWW)
1.UNIX
2.Basic HTML
3.Web Tables
4.Frame Layouts
5.FrontPage
6.Forms

To master the test, you should do the following:
1.Have a good understanding to the labs (1 --> 12).
2.Re-do Quizzes (1--> 5).
3.Do the Midterm.
4.Understanding to the lecture slides for topics covered in the course.

Below is a list of detailed items you should know for this exam:

I. Windows XP and PC Applications:
1.Windows XP
a) Use the File Manager (Windows Explorer) to format a diskette, create new directories, copy, move, and delete files.
b) Associate a file with a Windows application.
c) Start menu options, task bar, file types (ASCII vs Binary).
d) Select a picture, paste it to the clipboard.
e) Use Notepad to create a plain (ascii) text document.
f) Capture and print a window or the entire screen.
g) How to cut or copy then paste.
h) How to cycle through applications.
i) What is the purpose of each application, Notepad, Start menu,  Shortcuts

2.Microsoft Word
a) Know how to construct a nicely formatted document
b) In particular, know how to change font, font size, bold, italics, underline text, save and print a file, add a border, justify text, show the hidden characters on the screen, seek help on a topic, use the wizards.
c) save files as different types available in Word, in particular, save as a Web Page and as text file.
d) how to capture the entire screen vs an active window
e) file types and extensions.
f) select text, change font, add attributes of bold, italics, underline, center, right-justify text.
g) show invisible characters, load an existing file, save a file, determine if document fits a page
h) insert a graphic from a drawing program, resize graphic
i) Work with Tables, Create letters, envelops, and labels
j) Work with long documents
k) Type of views in Word.

3.Microsoft Excel
a) Know a function and a formula
b) Key presses for selecting multiple-adjacent and non-adjacent range of cells.
c) Copy cells using absolute and relative references.
d) How to generate charts.
e) Moving data in a worksheet  

4.Micorsoft Access
a) Access objects
b) Tables of records, fields, fields data types, and a field property.
c) Various ways to create a table of records, and the primary key(s).
d) Query vs. Filter
e) A query on a single or multiple tables.
f) Reports on a query and on a table of records.
g) Ways to create a database and the size of a database.

II. UNIX and the Web (WWW)
1.UNIX:
a) Learn the basic UNIX commands linked from the course webpage. Most notably, learn to change directory (cd), view the current path of a directory (pwd), list the contents of a directory (ls), create a directory (mkdir), copy a file (cp f1 f2), rename/move a file (mv), and delete a file (rm).
b) Understand the difference between UNIX file permissions and AFS permissions.
c) Store your web page in the html directory that is inside public.
d) Create a file with Pico and save it.
e) store files, delete them, and move files across directories.

2.Basic HTML:
a) Basic HTML tags to format text (i.e. headings, underline, bold face, text color, paragraphs)
b) Web page background and bgcolor.
c) Load an image in a web page.
d) Create hyperlinks to local files, remote sites, and mailto link.

3.Web Tables:
a) Table border, background color for the entire table, number of rows and columns.
b) Table Cells: background color, colspan and rowspan.
c) Be familar with laying out your web page with a table.

4.Frame Layouts:
a) Frameset's Cols and Rows division (for vertical and horizontal window division).
b) Nested framesets.
c) Frame filler name and target in the HREF anchor tags.

5.FrontPage:
a) Create a basic web page with FrontPage: format text, load an image, create hyperlinks (local and remote) and mailto links.
b) Create Interactive buttons.
c) Use Table Layouts.
d) Use Frame layouts.
e) Develop websites.

6. Forms:
a) Type of objects that may be included/created in a form (i.e. text box, radio button, checkbox, pop-up menu, scroll list, text area, and submit/reset buttons).
b) Action and method attributes in the form code.
c) Collect data and send it by email using the mailto command.

2.FTP:
a) Connect to a remote computer to transfer files only.
b) How to use FTP to access public archives (username=anonymous and password=your-full-email-address) vs accessing your own authorized access (i.e.unixs.cis.pitt.edu where you use your own username for the login and your own password)

3. Windows File Sharing
a) Know the difference between Simple and Advanced File Sharing
b) Understand how to give network access to files on your PC
c) Understand how to view files on other PCs

3. Internet
a) Know the basic Client/Server idea
b) Understand the basic function of the Domain Name System (DNS) (provides text addresses like unixs.cis.pitt.edu)

4. Home Networking
a) Know the basic hardware for a home network (hub, switch, router, WAP)
b) Understand what a router does (including using your PC as a router) (needs at least two network interfaces)
c) Understand the services that home routers provide (NAT, DHCP, Firewall (Port Forwarding))