Business & Computer Resources
Accounting
Hot Links to sections of this page - RESOURCES (last revised 10/27/2008 - corrected some failed links)
TIP: To view pages in new browser
window to reduce scrolling and improve printing,
Right-Click the
link, and select Open Link in New Tab or Open Link
in New Window.
Business and Accounting Resources
- Glossaries - Software - Business Plans - Financial Calculators - Government
General Business / Accounting Info -- Accounting / Finance / Business Careers
- ECommerce -
Free Business-Related Tutorials & CoursesStock Market info and tutorial sites
COMPUTER-RELATED SITES
- Software Specific - Hardware & Ergonomics Specific
- Networking & Telecommunications
- Free General Computer and Software and How-To Tutorials- Computer Ethics - Computer Security & Privacy
EXCEL-SPECIFIC RESOURCES SITES
- General Excel Resources - Free Excel-Specific Tutorials- Functions & Formulas - NEW ! Math Order of Operations
- Specialized Tools - Linear Regressions with Excel
- Charts
GENERAL INFO SITES (Check out ASSIST.ORG for transfer courses)
- Other Sites
INFO TO UNDERSTAND THE INTERNET / WORLD WIDE WEB
SEARCH & WEB INFO SITES including list of Other Browsers
HOW TO SAVE WEB PAGE or EMAIL MESSAGES
Do you want to use your home computer for this course?
VERY GOOD DEALS on MS Windows XP (FREE fully licensed version)
and MS Office 2003 Professional (fully licensed version about $83 total incl tax & s/h)
- - link to the Systems Requirements page
- - - - - (it's located in the CLASSROOM area - Course Info & Instructions page)
The following list contains some excellent links to resources which will support you in your business career.
Please send an email to me if you discover additional relevant sites. I'll add them to this list if they check out. Also, please let me know if any of the links have died. That happens frequently online, especially with dynamic topics such as this.
These links to external resources will open a new browser window. When you've finished with the external site, CLOSE the new browser, and you will return to this page in your virtual classroom
This page contains useful links to resources to support your continuing business career.
Save this page (HOW TO SAVE WEB INFO below), and refer to it when a question comes up about "How do you do............??? some task???" or "Where did I see that great tip or solution?"
Referenced sites include info about software, small business assistance, mail lists, tutorials, tips, FAQs, specific step-by-step solutions, info about new versions/releases, and much much more. Some are links to publications with some online info and back issues plus information about subscriptions. Some provide info about support via news/discussion groups and list servs. Some provide info about additional software designed to enhance your productivity or with special capabilities for specific functionality.
Many of the sites have been provided by students in my classes. Please share with the class, or send a message to me additional relevant sites to add to this list. Also, please let me know if any of the links have died. That happens frequently online, especially with dynamic topics such as these.
Note: The following links open a NEW browser window, so you may easily return to this page by CLOSING the new browser window when you're through. If the resource is one that you think you might want to use in the future, be sure to ADD it to BOOKMARKs (Netscape Navigator) or to FAVORITES (MS Internet Explorer).
BUSINESS AND ACCOUNTING RESOURCES
GLOSSARIES - Accounting and Financial Terms
InvestorWords is the most comprehensive Financial Glossary you'll find anywhere, online or off, with over 6,000 definitions and 20,000 links between related terms
http://www.investorwords.com/
LittleBusiness.com - http://www.littlebusiness.com/startbus.htm
Venture Line Corp - http://www.ventureline.com/glossary.asp
Peachtree site with a newsletter that was interesting and helpful. - http://www.peachtree.com
Peachtree Knowledge Center - useful hints for getting started with your new software, "how-to" tips, frequently asked questions, and more - free registration
http://www.peachtree.com/support/rightnow/welcome.cfmQuickBooks (Intuit) site - http://www.quickbooks.com/
View QuickBooks Videos
FindAccountingSoftware.com provides information and links to publishers of all sorts of computerized accounting software, including many specialty categories:
http://www.findaccountingsoftware.com/
Little Business for Geeks (actually it's for everyone who's serious about: starting a business - lots of excellent links - pay special attention to the Business Plan links - that's a very important component of starting any business - PLANNING!!
http://www.littlebusiness.com/defacct.htmSBA Business Plans Basics - http://www.sba.gov/starting_business/planning/basic.html
Business Plan Software, Samples, and Strategy - http://www.businessplans.org/
MoreBusiness.com - demos, downloads - http://www.morebusiness.com/brc/search/search.ttml?query=business+plan&lower=0&upper=25
American Express - Small Business Plan Resources - http://www133.americanexpress.com/osbn/tool/biz_plan/index.asp
FinAid - The Smart Student Guide to Financial Aid - financial aid calculators - http://www.finaid.org/calculators/ (not "business" but very important business!)
Business Planning Experts - breakeven, starting costs, cash flow, credit cards, investment, etc - http://www.bplans.com/bc/#
BankRate.com - small business, investing, managing your money, financing, etc - http://www.bankrate.com/gookeyword/rate/calc_home.asp?link=5
FinanceCalc.com - financing, saving, investing, managing money, etc. - http://www.financecalc.com/
USA Today - - financing, saving, investing, managing money, etc. - - http://www.usatoday.com/money/perfi/calculators/calculator.htm
Altamira Financial Services Ltd is a financial and investment website with great into & links & useful investment downloads - Click Education and Calculators
http://www.altamira.com/Interest.com Home Finance - http://www.interest.com/
with all sorts of calculators - http://mortgages.interest.com/content/calculators/index.aspANZ - Benchmark your business - many calculators - http://www.anz.com/australia/business/calculator/businessbenchmark/home.asp
GOVERNMENT (and Govt Related) SITES
General Accounting Office - one purpose is to make funding decisions related to Federal Gov't with actual audits and cases to determine what's legal and what's not. - http://www.gao.gov
Small Business and Self-Employed One-Stop Resource - Starting a Business, Employer ID, Tax Aspects of hiring employees, independent contractors, scams, and more at
http://www.irs.gov/businesses/small/index.html
Small Business Administration - http://www.sba.gov/
SBA Online Women's Business Center: Bookkeeping and Accounting - http://www.onlinewbc.gov/docs/finance/bkpg_acct.html -- a text-based online accounting course training course on bookkeeping and accounting for a small business, covering such topics as keeping good records, financial statements, cash vs. accrual accounting, balance sheet accounts, basic types of business records, basics of budgeting, estimating profits and much more
Minimum Wage Laws by State - http://www.dol.gov/esa/minwage/america.htm
Internal Revenue Service - http://www.irs.gov/
Internal Revenue Bulletins - All kinds of Tax Info, Downloadable IR Bulletins,.. - http://www.irs.ustreas.gov/prod/bus_info/bullet.html
Employee or Contractor? "The Definition Is Changing-- Again!"
http://www.unclefed.com/AuthorsRow/GretaHicks/employeecon.html
TechProse summary of employee/contractor issue:
http://www.techprose.com/webforms/1099_criteria.htm
IRS on Small Business - - http://www.irs.gov/businesses/small/index.htm
Securities and Exchange Commission - http://www.sec.gov/
Tax and Accounting Directory with many links on it - http://www.taxsites.com/
Directory of tax and accounting sites for information - http://www.taxsites.com
Payroll Tax info site that contains addresses, phone numbers, form numbers, and filing dates for federal and state taxing authorities. - http://www.payroll-taxes.com/
GENERAL BUSINESS/ACCOUNTING INFO SITES
ALLBUSINESS.com -- critical tools, services and information to help you start, manage and grow your business - http://www.allbusiness.com/
Venture Line Corp -- offers info and services and links for accounting for businesses
http://www.ventureline.com/
Big Eye - list of Financial Megasites and Directories --
http://www.bigeye.com/finmega.htm
Fortune 500 Magazine - Includes Fortune 500 Small Business Magazine Archives Boards & Chat, plus Free Trial Issues Subscriptions, and free articles - http://www.fortune.com/
InternetNews.com --- current business news - http://www.internetnews.com/bus-news/
Toolkit Site explains why we do things and ways to do them is with several links that go through state and federal taxes as well as payroll.
http://www.toolkit.cch.com
CPA2Biz.com -- News, information, products and value-added services for CPAs and the organizations they serve - http://www.cpa2biz.com/
Dun & Bradstreet - The Dun & Bradstreet Web site allows you to run a report on a certain company or register and update your own company with D&B. You can obtain business and financial information on vendors and customers as well as finding information on a registered company. - http://www.dnb.com
Public Register's Annual Report Service - The Public Register's Annual Report Service Web site allows the user to obtain free annual reports for public corporations in order to obtain information about a company's financial performance. - http://www.prars.com/
SmartPros LTD - various categories - http://www.pro2net.com/accountinghome.xml
WebCPA - http://www.webcpa.com/ - publications and latest news relating to accounting.
FASB (Financial Accounting Standards Board) - Summary and status of all FASB statements, exposure drafts, documents... http://www.fasb.org
Edgar online - Corporation filings with SEC... - http://www.edgar-online.com/
Recent Tax Development - Proposed regulations, court rulings... - http://www.halcyon.com/lesourd/recent.html
Rutgers Accounting Web - Lots of accounting info and links... - http://www.rutgers.edu/accounting/
Environmental Accounting and Auditing Issues - Dr. L. Murphy Smith, Professor:
http://accounting.rutgers.edu/raw/internet/internet1.htm
NEW ! Environmental Accounting and Auditing Issues - Dr. L. Murphy Smith, Professor:
http://accounting.rutgers.edu/raw/internet/internet1.htm
Kaplan's AuditNet Resource List Online - An exhaustive list of resource for auditors and accountants - http://www.auditnet.org/karl.htm
Accounting for Non-Accountants' BLOG - good info - here's a discussion on finding and correcting accounting errors - http://reallifeaccounting.com/blog/archive/2005/01/04/205.aspx
NEW ! FixedAssetInfo.com - up-to-date happenings related to Fixed Assets accounting. Even includes a Depreciation Calculator:
http://www.fixedassetinfo.com/
Accounting / Finance / Business Careers
American Institute of Certified Public Accountants - The American Institute of Certified Public Accountants (AICPA) Web site provides a multitude of information from continuing education for accountants and updated news of the industry to providing services to students interested in becoming accountants.
- http://www.aicpa.org
AAA (American Accounting Association) - Very useful info including summary and status of all FASB statements, exposure drafts, documents... - http://www.rutgers.edu/accounting/raw/aaa/aaa.htm
Accounting: A Career Without Limits - http://www.aicpa.org/nolimits/index.htm -- A complete overview of the accounting profession from the American Institute of Certified Public Accountants designed for those who are considering it as a career, covering how to become an accountant and/or CPA, the wide array of job types and how to get a job, top accounting technologies and much more
CPAnet - The CPAnet Web site provides numerous links that allow you to gain access to online forums and online publications, the Web sites of the big accounting firms, state accounting societies' Web sites, as well as other useful information and resources. -http://www.cpanet.com
California Board of Accountancy - http://www.dca.ca.gov/cba/index.html
Practitioners Publishing Company - http://ppc.thomson.com/sitecomposer2/ for accounting professionals. Subscribers receive many services, training, support, etc. Check out the Online Demos and also the Most Popular Products links.
Association of Certified Fraud Examiners - The Association of Certified Fraud Examiners Web site offers the latest news about fraud, a free newsletter, and links to seminars and events to help educate businesses about how to combat fraud.
- http://www.cfenet.com
American Management Organization - The American Management Organization Web site offers information about seminars, courses, on-line classes, and resources regarding career development, career guidance, and career skills. - http://www.amanet.org
IMA (Institute of Management Accountants) - IMA publications, membership info... -
http://www.rutgers.edu/Accounting/raw/ima/ima.htm
Accounting, Finance and Banking Career Center Network (one of many such sites, but a very good one) - http://careerbank.com/
ANet (Part of International Accounting Network) - Info on various accounting related mailing lists - http://www.csu.edu.au/anet
REVISED URL Federal Trade Commission for the Consumer - ECommerce - use the SEARCH tool in top right corner, key words e-commerce e-business, to get links about Federal Trade Commission's Business Consumer Protection service's current problems and issues.
http://www.ftc.gov/bcp/
The ECommerce Guidebook - http://www.online-commerce.com/
InternetWorld.com has extensive articles about ECommerce -
http://www.internetworld.com/
Webopedia - Top 20 ECommerce terms - http://e-comm.webopedia.com/
Line56.com - B2B ECommerce news - http://www.line56.com/
Other current, relevant ECommerce online publications:
- http://zones.advisor.com/adv/e-CommerceAdvisor
- http://www.ecommerce-guide.com/
- http://www.ecommercetimes.com/
- http://www.internetnews.com/ec-news/
REVISED URL E-Commerce- for a listing of various E-Business topics and resources.
http://www.webmonkey.com/e-business/
How E-Commerce Works – from HowStuffWorks.com -
http://computer.howstuffworks.com/ecommerce.htm
REVISED URL Web Store Features - online business solutions options for technologies such as shopping carts - what's available - prices, etc..
http://onlinebusiness.about.com/od/shoppingcarts/ECommerce_Solutions.htm
Can prospective customers “Froogle” your website? -
http://onlinebusiness.about.com/b/a/2004_10_02.htm
Solutions from VeriSign to make Internet and telecommunications networks more intelligent, reliable, and secure –
http://www.verisign.com/verisign-business-solutions/index.html
The Different Ecommerce Habits Of Men And Women -
http://www.stargeek.com/item/23058.html
Women Business Owners and Ecommerce - “ . . . what is the best way for women to capture the potential of this huge market? Probably one of the best ways is to leverage the power of the net to enter into an online marketplace . . “
http://www.advancingwomen.com/web/women_business_owners.html
Online Minority Business Owners Organization website with lots of useful info – especially points out the power of putting business online –
http://www.mbnet.com
FREE
BUSINESS-RELATED TUTORIALS & COURSES
see others at
http://www.wannalearn.com/Business_and_Careers/Accounting/
Accounting Tutorial - http://www.access.wvu.edu/class/acctutor/accthome.htm - an introductory text-based tutorial on the basics of bookkeeping and accounting, complete with integrated self-examination questions, and covering the accounting cycle, adjusting entries, bad debts, debits and credits, end of period adjusting entries, financial statements, general journal entries, asset account names, liability account names, owner's equity account names, petty cash, reconciling a bank statement, understanding debits and credits and more
Accounting Concepts Tutorial - http://www.fso.arizona.edu/fso/training/tutorials/accounting/ - brief, text-based tutorials with quizzes on key accounting concepts, including the accounting equation, debits and credits and more
Bean Counter Accounting - http://www.dwmbeancounter.com/tutorial/Tutorial.html - sequential online bookkeeping lessons, covering bookkeeping language and terminology and definitions, bookkeeping systems, debits and credits, double entry bookkeeping, financial statements, how business transactions are properly analyzed, recorded and summarized, property & property rights, the accounting equation, the cash and accrual basis of accounting, the general ledger and journals, types of business activities, types of business organizations and more
Intro to Accounting - Simple - http://www.simplestudies.com/Lessons.htm - a complete online accounting course for beginners with sample problems and their solutions, covering what accounting is and its role, accrual accounting, costs vs. expenses, credit purchases, debit and credit, deferrals, depreciation methods, double-entry accounting system, financial statements preparation, general journal records, historical cost of assets, intangible assets and amortization, inventory cost flows methods (FIFO, LIFO, etc.), perpetual and periodic inventory methods, product vs. selling and administrative costs, revenue and expenses, service vs. merchandising companies, single- and multi-step income statements, tangible vs. intangible assets, the elements of financial reporting and more
Payroll Basics - http://www.payroll.com/resources/ - Payroll 101 is a text-based tutorial designed to help familiarize visitors with the basic concepts of payroll management and introduce options to facilitate the process, with an emphasis on using Intuit / QuickBooks products Also includes Tax Info, FAQs
Troubleshooting for common payroll problems, and New Hire Setup
Accounting and Excel Tutorial - accounting uses for Excel. Build an A/R system. Learn about forecasting techniques, comparative ratio analysis, ROI analysis, and more. Also, fee for service online Excel project assistance. http://www.lacher.com/toc.htm
FREE Accounting resources that may help as refreshers, or be an online reference if you don't have your accounting manual or installed Accounting Primer handy - http://www.docnmail.com/learnmore/accounting/financials.htm
Interactive Accounting, Business, Computer terminology and concepts exercises -
http://avconline.avc.edu/kmoore/courses/InteractiveBusCompSkills.htm
NEW ! Tutor2U.net - free tutorials - this one is on Fixed Assets & Depreciation:
http://www.tutor2u.net/business/accounts/assets_fixedassets_intro.asp
STOCK MARKET INFO & TUTORIAL SITES
-
NEW ! Stock market games - even for kids - and even those are great starters for folks who don't know much about stock market trading -
http://www.education-world.com/a_curr/curr179.shtml
-
NEW ! Links to various stock market simulations - again, even for kids -
http://www.surfnetkids.com/stockmkt.htm
-
NEW ! Investopedias info about brokers relative to investing
http://www.investopedia.com/university/broker/
-
NEW ! About.com has useful information for understanding stock market and trading -
http://netforbeginners.about.com/od/thenewgamershandbook/The_New_Gamers_Handbook.htm
-
NEW ! RightLine.net - Tips and info for active traders traders & investors
http://www.rightline.net/
-
NEW ! OnlineOption.com - learn when to buy & sell in any market
http://www.onlineoption.com/
AVC Online Learning (OLL) Resource Center for novice, intermediate and power users
http://avconline.avc.edu/avcoll/
Welcome to Triumph of the Nerds! - http://www.pbs.org/nerds/
Intro to Computers - A Beginners Guide - http://www.grassrootsdesign.com/intro/index.php
PC Magazine - how to articles, new technologies, comparisons of software and hardware
http://www.pcmag.com
PC World Magazine - how to articles, new technologies, comparisons of software and hardware
http://www.pcworld.com
How Stuff Works - about ...anything! Recently getting more commercial, but that's how these resources can remain free for our use ...... - http://www.howstuffworks.com
PC Guide - you need to register - free - but the info is terrific! - http://www.pcguide.com
ZDNet: Hardware reviews - http://reviews-zdnet.com.com/
HowStuffWorks - Software Channel -
http://computer.howstuffworks.com/software-channel.htm
NEW ! REVISED site info: Solve IT! for Office -
http://www.mysolveit.com/
no longer free but you can view a demo and use a trial version
http://www.mysolveit.com/guides.htm
REVISED site info: ZDNet: Software reviews - http://review.zdnet.com/
Microsoft.com - Windows XP home page - http://www.microsoft.com/windows/default.mspx
Microsoft.com - Office 2003 home page - http://office.microsoft.com/en-us/default.aspx
MS Office 2003 - Help / Support Center - http://support.microsoft.com/ph/2488
Woody's Watch website is a very useful FREE service of e-zines (electronic magazines) for beginners and pros with terrific info about Microsoft Windows OS and Office apps., providing "Advice, tips and news from author, guru, curmudgeon, and Microsoft software victim, Woody Leonhard, and friends" -- http://woodyswatch.com/
Netscape.com - http://www.netscape.com
Adobe.com - http://www.adobe.com
Macromedia.com - http://www.macromedia.com
Everything about Computers - Free Help - How To's - General Info - http://www.computerhope.com/
HowStuffWorks - Hardware Channel - http://computer.howstuffworks.com/hardware-channel.htm
How RAM Works - http://computer.howstuffworks.com/ram7.htm
Your Basic Hardware Page - How To's - http://www.basichardware.com/how_tos.html
What is Hardware - select from Hardware Device Listing
http://www.computerhope.com/ahardwre.htm
Beginning Computer Hardware Guide - old (2000) but generally useful info -- http://www.comptechdoc.org/hardware/pc/begin/index.html
Take Good Care of Your Computer Software, Data, & Hardware:
IMPORTANT COMPUTER CARE INFORMATION course page
Ergonomics - important for comfort and health - much more than just Carpal Tunnel Syndrome - http://www.ergonomics.com/
OSHA Ergonomics Employee Health - www.osha.gov/SLTC/ergonomics/
Office Ergonomics Training - http://www.office-ergo.com/
Ergonomics at Work - http://www.combo.com/ergo/atwork.htm
Ergonomics.org - http://ergonomics.org/
National Institute for Occupational Safety and Health - - http://www.cdc.gov/niosh/topics/ergonomics/
The Carpal Tunnel Syndrome Information Home Page- Ergonomics and Musculoskeletal Disorders - http://www.carpal-tunnel.com/
ErgoWeb.com - www.ergoweb.com/
NETWORKING & TELECOMMUNICATIONS
Networking: How Ethernet Works - http://computer.howstuffworks.com/ethernet.htm
Networking: Wireless Networking - Several very useful articles/sites -
http://compnetworking.about.com/
Networking: How Home Networking Works
http://computer.howstuffworks.com/home-network.htm
Networking: How hard is it to set up a network between two computers in my home?
http://computer.howstuffworks.com/question353.htm
Home Network Security - http://www.cert.org/tech_tips/home_networks.html
Networking/Telecommunications: How Ubiquitous Networking Will Work
http://computer.howstuffworks.com/ubiquitous-network.htm
Telecommunications: How Internet Infrastructure Works
http://computer.howstuffworks.com/internet-infrastructure.htm
Telecommunications: How Carnivore Worked (FBI)
http://computer.howstuffworks.com/carnivore.htm
Telecommunications: Why was 911 chosen as the emergency phone number?
http://people.howstuffworks.com/question664.htm
Telecommunications: International Telecommunication Union
http://www.itu.int/home/
Telecommunications: How Location Tracking Will Work
http://people.howstuffworks.com/location-tracking4.htm
Telecommunications / Telephony: How VoIP Works
http://computer.howstuffworks.com/ip-telephony.htm
FREE GENERAL COMPUTER & SOFTWARE & How-To TUTORIALS
Microsoft TRAINING home page:
http://office.microsoft.com/en-au/training/default.aspx
NEW ! Microsoft AUDIO courses about all things Microsoft!
http://office.microsoft.com/en-au/training/CR061958171033.aspx
PC Computer Notes & Hardware Tutorials - Start with "My Computer" Tutorials
http://www.pccomputernotes.com/
Computer Training Tutorials - Tutorials about everything related to computer hardware - some with interactive learning activities - http://www.ckls.org/~crippel/computerlab/tutorials/
REVISED site info: Tech Tutorials: Free tutorials about computer technologies - http://www.techtutorials.net/
Intro to MS Windows Tutorial - ver 2000 but much of it applicable to later versions - http://www.todayskills.com/introwindows/
Intro to Computers - A Beginners Guide - http://www.grassrootsdesign.com/intro/index.php
Microsoft in Education - Educator's Guide -- Resources, including in-depth step-by-step tutorial guides for students, teachers, and staff on basics of MS Office, Excel & others
http://www.microsoft.com/education/?ID=Tutorials
LearnThat.com - http://www.learnthat.com/courses/computer/ - provides very good FREE tutorials/courses for MS Windows, Office, and lots of other software.
Education Online for Computers - http://www.educationonlineforcomputers.com/ - this site offers "Free Access To Over 500 Standard Courses and Free Newsletter Subscription - as our thank you, we give you access to a ton of free templates and forms to use with your Office software!". Here's a page of links to various services that provide free online tutorials/courses.
http://www.educationonlineforcomputers.com/links/
Useful Tips - Computer / Windows / Excel / Word by Karen Ellis - http://mywebpages.comcast.net/kellis1/computer_tips.htm
EZResearch.com has specific lessons/tutorials for various Word tasks, such as text alignment, special effects, inserting a symbol, etc.
http://www.ezresearch.com click Computers link, Search "tutorial office" key words
Karyn's Toolkit - provides free MS Office tutorials, focusing on specific skills, such as Word shortcuts, using Clipart, using Autocorrect, etc. http://tutorials.esmartweb.com/
NEW !! LearningElectric.com - Word and other MS Office and miscellaneous tutorials
http://www.learningelectric.com/word.htm
Internet4Classrooms.com - basics and a "Beyond the Basics" section
http://www.internet4classrooms.com/on-line_word.htm
Interactive Keyboard Graphic - What do those keys do?
http://www.ckls.org/~crippel/computerlab/tutorials/keyboard/page1.html
Learn2Type - Typing Test & FREE Typing lessons - http://www.learn2type.com/
The Personal Computer and Its Construction - select SITE MAP link for listing of tutorials -
http://www.karbosguide.com/
With a bit of knowledge, you can do even more with computer systems:
Build your own computer -- -- http://www.hardwarecentral.com/hardwarecentral/tutorials/109/1/
Building the Perfect PC -- -- http://www.hardwarecentral.com/hardwarecentral/tutorials/97/1/
Installing a battery -- -- http://www.hardwarecentral.com/hardwarecentral/tutorials/14/1/
PC Show and Tell - Online Software How-To Tutorials - register for 24-hr free trial - 1 user ($30) -
http://www.pcshowandtell.com/index.asp
REVISED site info: The Brookings Institution - Computer Ethics Institute - includes NETIQUETTE - Ten Commandments
http://www.brook.edu/its/cei/CEI_HP.HTM
Centre for Applied Ethics - Global issues - covers ethics in many areas, not just business and computers - http://www.ethicsweb.ca/resources/
Ethics in Computing - Risks, Social Justice, Privacy, Commerce, etc - provides useful lessons and resources about Basics of Ethics in Computing, Risks, Computer Abuse, Social Justice, Intellectual Property Rights, Speech Issues, Commerce, Privacy, etc.
http://ethics.csc.ncsu.edu/
Think Quest - Computer Ethics - http://library.thinkquest.org/26658/
Computer Ethics Institute: Intellectual Property Rights - http://www.cpsr.org/issues/ip/
Ethics on the World Wide Web site provides links to resources dealing with ethics in many areas, not just business and computers:
http://commfaculty.fullerton.edu/lester/ethics/ethics_list.html - CSU Fullerton -
Centre for Computing and Social Responsibility - http://www.ccsr.cse.dmu.ac.uk/
Its mission is to undertake research and provide teaching, consultancy and advice to individuals, communities, organisations and governments at local, national and international levels on the actual and potential impacts of computing and related technologies on society and its citizens.
Privacy: Can your PC be subpoenaed? By Michael McCarthy The Wall Street Journal Online May 23, 2000
http://news.zdnet.com/2100-9595_22-502433.html?legacy=zdnn
An On-line Interactive Course in Internet Ethics
http://www.ess.pdx.edu/ets/etsub/Resources/Ethics_course.htm
Computer Ethics, Laws, Privacy Issues - © Virginia Montecino
http://mason.gmu.edu/~montecin/eprivacy.htm
NEW ! StaySafeOnline.org - National Cyber Security Alliance
http://www.staysafeonline.info/NEW ! Watch the Security Video at http://www.staysafeonline.info/video/stay_safe.wmv
NEW ! Top 8 Cyber Security Practices from StaySafeOnline.org - National Cyber Security Alliance (each is a link to detailed info)
Windows XP Security Home Page - use various security software, including firewalls (Windows XP includes a firewall), anti-virus and anti-spyware, AND keep your software updated:
http://www.microsoft.com/athome/security/protect/windowsxp/Default.mspx
IEEE Computer Society Technical Committee on Security and Privacy
http://www.ieee-security.org/
Computer Security Institute - http://www.gocsi.com/
Home Computer Security - http://www.cert.org/homeusers/HomeComputerSecurity/
and the Microsoft Security at Home page - http://www.microsoft.com/athome/security/default.mspx
ITSecurity.com - free assistance - http://www.itsecurity.com/
CERIAS Hotlist: Computer Security, Law and Privacy, Education, Organizations, Solutions
http://www.cerias.purdue.edu/hotlist/
Yahoo! Directory - Security & Encryption - links
http://dir.yahoo.com/Computers_and_Internet/Security_and_Encryption/
Computer Systems Security & Privacy Advisory Board/CSSPAB Home Page - established by the
Computer Systems Security Act of 1987
http://csrc.nist.gov
Ethics in Computing - Privacy & Risks & Abuse
http://ethics.csc.ncsu.edu/privacy/ & http://ethics.csc.ncsu.edu/risks/ & http://ethics.csc.ncsu.edu/abuse/
A Guide to Your Child's Safety on the Internet -
http://www.microsoft.com/protect/family/guidelines/default.mspx
Home Network Security - http://www.cert.org/tech_tips/home_networks.html
Desktop Security Resources -
NEW ! Ten Commandments of PC Security -- by Paul Gil - Unearthed in a garage near Cupertino, California, experts have found special tablets. With decrees on how to deliver us from computer evils and save us from computer viruses and hackers, these Ten Commandments are good news for everyone.
Read and follow the commandments. And honor thy firewall!
http://pcworld.about.com/news/Oct292003id113175.htm
NEW ! CyberAngels - volunteer organization, originally a group of parents whose children had been victimized. Homefront site is their training courses for parents, children, etc.
http://www.cyberangels.org/
NEW ! TopTenReviews.com - reviews various software, including:
Top Ten Internet Security Suite review page:
http://internet-security-suite-review.toptenreviews.com/Top Ten Anti-Spyware review page:
http://anti-spyware-review.toptenreviews.com/Top Ten Anti-Virus review page:
http://anti-virus-software-review.toptenreviews.com/
Microsoft Excel Home Page -- info, support, updates, solutions, examples, templates,...See links in section at bottom - Tools to Help You Work Smarter in Excel
http://office.microsoft.com/en-us/FX010858001033.aspxMicrosoft in Education - Educator's Guide
Resources, including in-depth step-by-step tutorial guides for students, teachers, and staff on basics of MS Office, Excel & others
http://www.microsoft.com/education/?ID=TutorialsMS EXCEL2003 - Help / Support Center - http://support.microsoft.com/ph/2512
Comprehensive Spreadsheet Resource - Excel - http://www.j-walk.com/ss/
Comprehensive is an understatement! - San Diego's JWalk & Associates, Inc. provides one of the best sites on the WWW covering all facets of all major spreadsheets.Mathtools.net - Learning > Newsletters > Excel directory - The technical computing portal for all your scientific and engineering needs - featuring Microsoft Excel
http://www.mathtools.net/Excel/Learning Microsoft Excel - basics and useful tips - http://www.usd.edu/trio/tut/excel/index.html
Pearson Software Consulting, LLC - Expert Excel & VBA Consulting -
This web site is provided as a public service. It includes terrific Excel, Office, and Visual Basic solutions. Search for the skill/task you need to learn.
http://www.cpearson.com/excel.htmExcel Worksheet Basics with Sample worksheets to download -- http://www.internet4classrooms.com/on-line_excel.htm
http://www.internet4classrooms.com/on-line_excel.htmExcel & Excel VBA Help.. Free MS Office Support -
Use the forums to get answers to questions - http://www.ozgrid.com/forum/Advanced Excel Add-Ins & Tips - - http://www.digdb.com/
Ask MrExcel.com - get useful responses - http://www.mrexcel.com/
and strange Excel Function Clock :-) http://www.mrexcel.com/excelfunctionclock.htmlExcel - Free MS Office Support - Basic thru Advanced - register free
Use the forums to get answers to questions - http://www.ozgrid.com/forum/Free ExcelTips.com Email Newsletter - Sign up at - http://www.exceltips.com/
Joseph Rubin's Excel Tips .com Free - http://www.exceltip.com/
FREE ElementKJournals.com Email TIPS on Excel &/or other apps - Sign up at -
http://www.elementkjournals.com/tips.aspCal Poly Excel Resources - TUTORIALS for EXCEL and all other MS Office apps plus more
http://www.tls.calpoly.edu/guides/Excel - Various Ways To Do Tasks - Use Mouse or Menu Bar or ShortCut Menu or Keyboard ShortCut to do all sorts of Excel tasks
http://avconline.avc.edu/kmoore/courses/Excel_WaysToDoTasks.htmBasic Excel Tutorials - Free
- http://www.usd.edu/trio/tut/excel/ - Intro Level - includes functions
- http://tutorials.freeskills.com/index/category/103
- http://www.chemistry.usna.edu/plebechem/excel_tutor/xlstut1.htm
- http://www.internet4classrooms.com/on-line_excel.htm
- http://www.wcu.edu/ccenter_inf/CatOnline/MSEX/
- http://www.fgcu.edu/support/office2000/excel/ - - good graphics
- http://www.uwec.edu/help/excel03.htm - Excel 2003 Tutorials
- http://www.baycongroup.com/el0.htm - Very detailed steps with skills exercises
- http://www.compusmart.ab.ca/alummis/excel/exceltutorial.html - step-by-step intro skills with detailed graphicsExample: http://www.microsoft.com/education/Excel2002Tutorial.aspx -- Hands-on Tutorial Packs -- Analyzing Data with Excel 2002 -- Learn How To:
Gather real-world data from different sources, including text files, databases, and the Web
Use PivotTables® and PivotCharts® to ask questions of complex data
Save your analysis as an interactive Web page
For basic steps to put various kinds of Excel object on the web, click on -- About Putting Excel data on the Web
For steps in creating and enhancing Excel worksheets, click on -- Publish interactive data to the Web using Excel and FrontPage
NEW ! Microsoft.com - Excel 2003 Tutorial courses
- http://office.microsoft.com/en-us/training/CR061831141033.aspxPut EXCEL OBJECTS ON THE WEB - basic steps tutorial
-- About Putting Excel data on the WebFor steps in creating and enhancing Excel worksheets, click on -- Publish interactive data to the Web using Excel and FrontPage
Businesssoft.about.com -- Free Excel tutorials -- Functions & Formulas - basic, intermediate, and advanced levels.
http://businesssoft.about.com/cs/exceltutorials/index.htm?iam=savvy&terms=Excel+-price*+-buy
Some Excel Keyboard Shortcuts for commands - http://www.tutorialbox.com/tutors/off2000/excel/shortcuts.html
PC Show and Tell - How-To Tutorials for a wide variety of software - register for 24-hr free trial - 1 user ($30) - e.g. Excel XP = 1584 objects in this library as of 2/17/2005.
http://www.pcshowandtell.com/index.aspAccounting Tips - Tutorial of accounting tips for Excel. Build an A/R system. Learn about forecasting techniques, comparative ratio analysis, ROI analysis, and more. Also, fee for service online Excel project assistance. - http://www.lacher.com/toc.htm
Interactive Accounting, Business, Computer terminology and concepts exercises -
http://avconline.avc.edu/kmoore/courses/InteractiveBusCompSkills.htmNEW ! Go to CHARTS section below for chart tutorials
Excel Functions & Formulas
- http://www.meadinkent.co.uk/excel.htm
- http://it.stlawu.edu/our_support/office/excel_functions.htm & common error messages
- http://spreadsheets.about.com/od/excelfunctions/
- http://www.functionx.com/excel/
- http://www.stewartpubliclibrary.ca/Common%20Excel%20Functions%20and%20Formulas.htmExcel Function - Calculate the business hours between dates - http://www.freevbcode.com/ShowCode.asp?ID=5244
Using an Excel worksheet - Basics of Using Functions - Internet4Classroom - http://www.internet4classrooms.com/excel_functions.htm
Excel Functions - used for Sampling Data
http://legacy.ncsu.edu/classes/bus350002/ppt/350-05/Financial Functions in Microsoft Excel - handouts including Excel Basics
http://www.utexas.edu/its/training/handouts/Selected Excel Financial Functions - And more, some rather exotic, Excel functions
http://www.sytsma.com/cism700/excelfinfcns.htmlPearson Software Consulting, LLC - Expert Excel & VBA Consulting - Macros & Functions - http://www.cpearson.com/excel/differen.htm
Mathtools.net - Excel Functions on Ranges - http://www.mathtools.net/Excel/Functions_on_ranges/
Excel - select Formulas & User-Defined Functions - http://www.barasch.com/excel/
A list of hard to find, hard to write Excel formulas to solve common problems:
Formula FAQs
Grab the last part of a string into a new formula
Extract and count the number of like elements in the middle of a string
A customer wanted to show both the formula and results in the same cell. It’s not very smart or useful but it works.
Compare 2 columns of numbers and count if a condition exists
Longest formula I ever created
Functions - basic to esoteric and combinations
Using external number templates in a spreadsheet
Determine number of working days between 2 days excluding holidays
Determine exact date for company holidays into the future
Convert a Gregorian date to Julian date
Figure how many hours someone worked
Build better Array functions
VLOOKUP - Microsoft tutorial page
http://office.microsoft.com/en-us/excel/HP052093351033.aspx
VLOOKUP - Step-by-step tutorial - example to determine the letter grade for numeric scores
http://domin.dom.edu/documents/office2000/vlookup.pdf
NEW ! MATHEMATICS - ORDER OF OPERATIONS RULES
About.Com - Mathematics - Tutorial - very straightforward
http://math.about.com/library/weekly/aa040502a.htm
The Math Forum @ Drexel - What is the correct order of operations? The purpose for this section is to understand how to build formulas and to avoid incorrect an over use of parentheses.
http://mathforum.org/dr.math/faq/faq.order.operations.html
Order of Operations & Evaluating Expressions - rules, self-scoring practice, learn it. OK, so it's from a K-12 math course - if we do not know something well, a good resource is a good resource!
http://regentsprep.org/Regents/math/math-topic.cfm?TopicCode=orderop
Solver Help - http://www.frontsys.com/xlhelp.htm
Comprehensive Solver information, answers, how tos, tips, such as:
Help with specific Solver messages
If you aren't getting the solution you expect (12K)
If the solution process takes a long time (10K)
If you've exceeded problem size limits
Known problems in Microsoft Excel Solver
Hints on Using Specific Solver Features
Understanding the Solver Reports
Understanding the Solver Options
How the Solver handles constraints (10K)
Hints for building readable, manageable models (25K)
Controlling the Solver with macros and VBA
Optimization Concepts (from the Tutorial)
Elements of Solver models
Linear and nonlinear functions
Discontinuous and non-smooth functions
Algorithmic methods used by the Solver
Excel-VBA Tips and more - http://www.excel-vba.com/
Free VB code - search "Excel" - http://www.freevbcode.com/
EXCELTIP.COM on VBA Macros - Custom Functions -
http://www.exceltip.com/show_tip/Custom_Functions/Worksheet_functions_in_VBA_macros_using_VBA_in_Microsoft_Excel/534.htmlPearson Software Consulting, LLC - Expert Excel & VBA Consulting -
This web site is provided as a public service. It includes terrific Excel, Office, and Visual Basic solutions. Search for the skill/task you need to learn.
http://www.cpearson.com/excel.htm
e.g. Macros & Functions - http://www.cpearson.com/excel/differen.htmExcel & Excel VBA Help.. Free MS Office Support - - register free
Use the forums to get answers to questions - http://www.ozgrid.com/forum/NEW ! VBA for Microsoft Excel - tutorial
http://www.functionx.com/vbaexcel/index.htmNEW ! Excel VBA - Variables and Data Types
http://www.functionx.com/vbaexcel/Lesson05.htmNEW ! Excel VBA Examples
http://www.mindspring.com/~tflynn/excelvba.htmlNEW ! Anthony's VBA Page - Excel VBA tutorials, projects, etc.
http://www.geocities.com/WallStreet/9245/NEW ! Introduction to VBA Excel - .pdf file tutorial.
http://www.math.vu.nl/obp/edu/project-obp/VBA-intro.pdfNEW ! Indigoware - how to add context-sensitive HELP to Excel VBA applications
http://indigoware.com/developers/excel_help.htmMacro Viruses
Solid info from Microsoft about viruses written into Excel macros. As viruses are discovered, Microsoft provides add-in utilities to detect the virus, and has built-in those utilities for subsequent versions and releases.
http://search.microsoft.com/us/default.asp?IntCat=0&IntCat=1&IntCat=2&IntCat=3&IntCat=4&IntCat=5&IntCat=6&IntCat=7&IntCatMicrosoft Developer Network (MSDN) Forum - Office - Excel
Home page for Developers who want to create custom solutions using MS Office products. Search keyword "Excel". - http://msdn.microsoft.com/Risk Management - Product information on Financial CAD, a risk management add-in for Excel (Free Trial available). FinancialCAD for Excel/PLUS for Excel - includes purchasing info. Everything you need to work with financial instruments and derivatives in Microsoft Excel. - http://www.fincad.com/
Excel with Exl-Plan -- fastest, best way to prepare financial projections
Entire business built on MS Excel technology. Some FREE stuff you can try out.
http://www.planware.org/exlplan.htmPsyFunc Psychrometric Functions for Excel -- Add in for Excel - download a full-featured free demo - http://www.linric.com/pfdown.htm
Analyse-It - Linear Regression for Microsoft Excel - free trial download
http://www.analyse-it.com/linear-regression_a.htm
Multiple Linear Regression - free trial download
http://www.analyse-it.com/multiple-linear-regression_y.htmLinear Regression - downloadable .PDF files
http://www.mathsci.appstate.edu/~hph/3310/linreg/Linear Regressions - Using Excel
www.uscs.edu/~mulmer/LinRegExcel.htmlGraphing Linear Regressions in Excel
http://www.ncsu.edu/labwrite/res/gt/gt-reg-home.htmlEssential Regression and Experimental Design --
http://www.geocities.com/SiliconValley/Network/1032/Slide Show - Linear Regression with Excel --
http://gorge.uwaterloo.ca/lfu/courses/cive342/cive342_econ/regression/sld001.htmRegression Using Excel's Solver --
http://archives.math.utk.edu/ICTCM/EP-13/C13/pdf/paper.pdfExcel Charts - What to use & when? Types & Sub-types
NEW ! Microsoft.com - Overview tutorial - How to CREATE A CHART in EXCEL
http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033NEW ! Univ of Texas - Useful graphics and basic tips for Creating an Excel Chart (old but still good)
http://www.utexas.edu/its/training/handouts/excelchart/NEW ! About.com - Another useful How To Create Excel Charts with very good graphics and tips
http://spreadsheets.about.com/od/excelcharts/ss/Chart_wiz_step.htmNEW ! Microsoft tutorial about CHARTs of various types, including combination charts, and charts with secondary axes
http://office.microsoft.com/training/training.aspx?AssetID=RC011097791033This page includes how to differentiate chart SUB-TYPES
http://office.microsoft.com/training/training.aspx?AssetID=RC011097791033NEW ! CREATE A GANTT CHART in EXCEL
http://office.microsoft.com/en-us/excel/HA010346051033.aspxNEW ! Univ of Vermont - Limited graphics but precise steps to Create and Manipulate an Excel Chart
http://library.uvm.edu/dana/guides/labhandouts/excel/excelchartbasics.htmlNEW ! LabWrite Resources - I like this q - quick tutorial - they use the correct terminology - GRAPHS
http://labwrite.ncsu.edu/res/gt/graphtut-home.htmlNEW ! Better Solutions.com - Excel Charts HOW TO, from very basic, click F11 to create a quick chart, thru very detailed information, including how to effectively use the Chart Tool Bar
http://www.bettersolutions.com/excel/EXX823/LT423111411.htm
College View -- A great resource for students. It gives great info about, you guessed it, colleges :-)
http://www.collegeview.com***** ASSIST.ORG - See if courses you take at AVC or any other CA public college or university are articulated (will transfer easily) to another CA public college or university.
ASSIST is a computerized student-transfer information system that displays reports of how course credits earned at one California college or university can be applied when transferred to another.
ASSIST is the official repository of articulation for California’s colleges and universities and therefore provides the most accurate and up-to-date information available about student transfer in California.
http://assist.org/
Greetings site - is not business related but - all work and no play ....
http://www.egreetings.comAccounting Jokes - http://www.ahajokes.com/accounting_jokes.html
Business Jokes - http://www.ahajokes.com/business_jokes.html
Computer Jokes - http://www.ahajokes.com/computer_jokes.html
*********************************************************
INFO TO UNDERSTAND THE INTERNET / WORLD WIDE WEB
NEW ! Internet for Beginners - by Paul Gil - sign up for free newsletter
http://netforbeginners.about.com/including Student's Quick Reference Guide to Internet Research
http://netforbeginners.about.com/od/searchenginehandbook/a/studentsguide.htmNEW ! LearnTheNet.com - tutorials about all-things Internet and World Wide Web
http://www.learnthenet.com/english/index.htmlNEW ! Library at University at Albany - How to use Internet / WWW tutorials:
http://www.internettutorials.net/NEW ! HowStuffWorks.com - Computer section - lots of useful tutorials/info
http://computer.howstuffworks.com/NEW ! WebTeacher.org - Interactive, illustrated guides
http://www.webteacher.org/windows.html
*********************************************************
For those wondering how to go about a search, here are some tips:
For our topics - business, accounting or bookkeeping, computers, small business startup, management, online e-commerce business, etc., - you would go to one of the search tools listed below and either (1) select a topic such as BUSINESS or eCOMMERCE or COMPUTER, then a subtopic such as ACCOUNTING or SMALL BUSINESS or HARDWARE or SOFTWARE, until you see links to websites that look promising;
or (2) input key words or phrases, such as ACCOUNTING or COMPUTERS;
or (3) in AskJeeves input a question, such as HOW DO IT START A SMALL BUSINESS? or HOW DO I UPLOAD A WEB PAGE?A list of sources will be provided, some with useful information.
SINK OR SWIM site -- A good workshop on searching the Internet is at http://www.ouc.bc.ca/libr/connect96/search.htm
Search About - useful search site - http://www.search.about.com
SearchEngineWatch.com - all about, well, you know .... http://searchenginewatch.com/
NEW ! ISP Comparisons - http://www.thelist.com/
BASIC INFO ABOUT SEARCH TOOLS see Search Internet course page
SEARCH INDEXES / DIRECTORIES - these create their own indexes of popular topics. So, if we're looking for general information about a fairly normal topic, like we are, we can usually get reliable results just by going to the site and selecting a topic, then a sub-topic -some good ones are
GoTo -- http://www.goto.com
Lycos -- http://www.lycos.com/
Open Directory - http://dmoz.org
Yahoo which calls the AltaVista search engine if there are few or no sites in its directory- http://www.yahoo.com
META SEARCH ENGINES - send queries simultaneously to multiple Web search tools. When looking for specific or exotic information, using one of the following will generate large-scale searches utilizing several search tools at once:
Ask Jeeves - : http://www.askjeeves.com/ just ask a question
Cyber411: - http://cyber411.com/ Searches 16 search tools
Dogpile: - http://www.dogpile.com/ searches newsgroups, too
SavvySearch: - http://www.savvysearch.com full-featured
ProFusion - http://www.profusion.com
INDIVIDUAL SEARCH ENGINES - Search engines check your key words against a database most often created automatically, by "spiders" or "robots" - with these you are not searching the web "live"AltaVista - http://www.altavista.com
Excite - http://www.excite.com
Google - http://www.google.com
HotBot - http://www.hotbot.com
Infoseek - http://infoseek.go.com
OTHER BROWSERS instead of MS Internet Explorer or Mozilla Firefox:
C|Net Latest in Browsers
The latest news about browsers from C|Net.Cello Web Browser
A multipurpose Internet browser that allows access to the myriad information resources of the Internet.HotJava Web Browsers
A lightweight, highly customizable solution for OEMs and developers creating Web-enabled devices and applications.Lynx Web Browser
Possibly the most widely used text mode browser on the Internet.NCSA Mosaic Web Browser
The last version of NCSA Mosaic for Windows was version 3.0. It should be noted that version 3.0 is Windows 95/NT specific.Opera Web Browser
A refreshingly different Internet Client that has a number of features that undoubtedly make it the Number 1 for the serious online computer user.
HOW TO SAVE WEB PAGE or EMAIL MESSAGE
Paperless Copies of Web Pages & Email and Discussion Messages
Select the Email or BB message you want to save. Be sure to Click once inside the message to be sure the frame it's in is selected. Then from the FILE menu, select SAVE FRAME AS if this command is available, else use SAVE AS, select FILE, choose the location to which you want the document to be saved.
If you are in EMAIL or Discussion Forums, the default filename will refer to the server and will not identify the message. So, change the name to something that describes what you're saving. I always include _em for email and _bb for forums messages to help remember the source.
Don't type the file extension and don't use periods (dots).
Then to view the file later, either Option (1) find the file in My Computer or Windows Explorer and double click on it to open your browser and open the file. Yes, you can use your browser OFFLINE - without dialing up your ISP - howabouthat!!
Option (2) would be to open your browser, or use one that's open and select FILE, OPEN, BROWSE to find the file you want to view and double click on it to view it in the browser.
Cool, huh!! Let me know if any questions - Kathy Moore
This page is ALWAYS under construction. If you find good, course-relevant resources, post the info as a message into the Blackboard Communication area / Discussion Board / Dialogue Chamber Q&A forum.
Also, let me know if there are any broken links. Websites come and go, and get revised all the time.
For
more information please use following 
:
SYLLABUS
CALENDAR
FAQs ASSIGNMENTS INSTRUCTIONS
USE OF HOME COMPUTER - SYSTEM REQUIREMENTS and BROWSER SETTINGS
|
|
Email: kmoore@avc.edu |
Last Updated 10/27/2007
By K E MOORE
Copyright 2005