|The Course||Research a Topic at WCU|
|WCU and ITS||CIS/Tech News / Links of Interest|
Spring 2007 FILES
(Left-click, Save It To Disk)
Expert Systems, examples (Ch. 4 in Haag)
Exsys Online Examples
Example, Calculate your interest payments (PPMT)
Spreadsheet Exercise A, In-Class (Sort and
As in class, click link and SAVE TO DISK (a local drive); then open in Excel.
Save all versions of your final sorted spreadsheet used to answer each question below (for example, Travel-Comm.xls, Travel-Price, etc.)
For an illustration of how to use the Sort and Subtotal functions in Excel, see 'Help' link below.
(Advertising With Banner Ads, Case 7, p. 369; but just address my
a. What is the sum of Total Purchase, broken out (itemized) by previous web site?
(Affordable Homes Real Estate, Case 2, p. 363; but just address my
b. What is the average Selling Price of houses by project number?
c. What is the average Asking Price of houses by number of bathrooms?
Travel Consultants, Case 3, p. 364; but just address my questions
d. What is the average Commission per travel agent?
e. What is the average Package Price by cruise line?
Mechanics, Case 1, p. 362; but just address my questions below)
f. What is the average Total Charge for repair by car type?
g. What is the average Total Charge by work completed?
HELP: If you are unfamiliar with the DATA,
here to see a five-slide PowerPoint explanation (PDF).
(You can also try Subtotal without first using Sort)
Spreadsheet Exercise B (Budget):
»Save the following to local drive and open in Excel:
Spreadsheet Exercise B, Budget (Monthly budget calculations, illustrating DSS)
[From Professor: Download and Show Financial Sheet, Comics -- Not testable]
Spreadsheet Exercise, In-Class (Data
Design a Spreadsheet presenting 10 years of data reflecting a) graduation rates, and b) student retention rates
Look at the examples after you have sketched your own idea on how to display such data.
WCU Spreadsheet Examples -- go to University Planning, Data, Fact_Book, Retention and Graduation Rates
Institutional Profiles (For universities in the UNC System)
/ Graduation statistics exercise (txt file; Using Excel for
calculation and display; as discussed in class)
Example (PDF) --
Westminster College Retention and Graduation Rates
From Professor: Exercise C (Multiple sheet workbook problem) and Show Spreadsheet, Beverage Consumption -- Setting up multiple worksheets, multiple worksheet formatting and calculation, worksheet hyperlinks, and more...
(See handout; files below are in Excel, to be imported into MS Access)
CUSTOMER (type data directly into Access; see handout for numbers)
MIDTERM, BUDGET, EXCEL
MIDTERM, STUDENT PROFILE, EXCEL & ACCESS
FINAL, EXCEL II AND ACCESS
Sample Resume, plain text format (.txt)
Sample Resume, the desired look (.PDF)
Sample Resume, solutions (.doc file)
Hot Links (Note ARCHIVES)
Salon, Tech & Business
USA Today, Tech News
Wired News, Technology
ZD Technology News
- - - - - - - - - - - - - - -
Google, Directory, Technology
The Technology Source (Michigan Virtual University, now at UNC)
AITP (Association of Information Technology
About the organization
Institute of Electronics and Electrical Engineers
IEEE Standards Association
IEEE History Center
Get IEEE Standards (download)
Other Standards Organizations
WWW Top-Level Domain (TLD) Suffixes
Understanding Domain Names (Inc.com, Oct. 1999)
Roll Out the New TLD Suffixes (Computer World, May 2001)
New TLD's Rich for Profiteers (Ad Age, Dec 2000)
New Internet Names Right for You? (Inc.com, Nov 2001)
Domain name searches (from mega net))
For more on mutual responsibilities...