Concepts
Number of People in the world, in the USA, on the internet
Hardware
Software
People
Data (GIGO)
Procedures Trends in Computers [faster, cheaper, smaller, most reliable (importance to business), easier to use/more capable Moore's law. Exponential change: double every 1.5 years now double every year (Now did you know) Data->process->information sort, summarize, save, send select->Information ROM RAM (volatile/nonvolatile, user decides contents vs mfgr decide) Desktop vs file cabinet Storage( Floppy, Zip, Flash/USB/Thumb, Hard disk, CD/DVD - Speed capacity, reliability, portability, cost) Surge Suppressor, UPS Password
Killer Apps Typewriter->word processing (why pay cost? easier revise so you'll do it so better documents that communicate) Calculators->Spreadsheet (why cost? more information, better decisions) File Cabinet- cost savings cabinet but bigger data in one place What computers do well (versus human do poorly)- repetitive - formulaic Most expensive part of computer system (training and the mistakes made because it is inadequate)
WindowsFormat disk (how, why ready for files, detect & isolate bad)
Poor reliability of floppies cover storage types and attributes
Speed, capacity, reliability, portability (see trends in computers above):
floppy, thumb drive, Zip, hard disk, CD & DVD, tapeMove, Size, Minimize, Maximize
Scroll Bar
Folders
File, View, Sort in Detail, Delete
Shift and Ctrl to select
My Computer
Control Panel
Ctrl F or Edit Find
InternetInet- WWW, Email, IM
Icons, Hover,
Hyperlinks, sometimes text, color, graphic, hover (see URL in lower left, invite to download whatever to your machine, virus) Favorites, Digg, tagging, social, del.ic.us Toolbar customize
NetNetiquette & Emoticons
Directories and Search Engines
Searching (" " - ), read tips
Ctrl +N
RateMyProfessor Bulletin Board
Incorporating Text & Graphics
into Web pages or Word documentsCreate a personal web site using Google Sites
Portals
Answers.com (download, cite) New Window with Ctrl + N
Importance of Subject Pros/Con versus telephone and snail mail Sending (to, cc bcc) (reply, reply all. forward, delete, file, mark as unread)
Receiving (Reply, Reply All, Forward, Mark as new, Folder)
Folders
Signatures Address Books
Groups or Distribution Lists
Word ProcessingMenus, Tool Bars, Help, UNDO
Using Help
Entering, Editing, Moving vs. Copying (cut & paste, drag & drop)
Saving, Retrieving (finding) Documents
Printing Documents (copies) - Print Preview importance
Formatting Characters (Bold, Italic, Underline, Size, Typeface, Color, Fonts)
Formatting Paragraphs (Inheritance, Alignment, Indents, Leading [singe, double, 1½, exact, multiple], Keep Together)
Borders and Shading Symbols Bullets and Numbering Headers & Footers,
Ruler (Right Indent, Left, First Line, Hanging)
Formatting (Page Setup - Margins, Orientation)
Customizing toolbar Tabs
Speller, Thesaurus, www.onelook.com Find/Replace
Clip Art: inserting, sizing, positioning, obtaining from Internet
Footnotes
AutoCorrect Columns Case Change Tables (Insert, Deleting, Sizing, Formatting, rows and columns, Merging cells, shading, borders)
Mail Merge (creating, modifying, selective printing)
Form Letter
Data Document Tracking Changes
Resume - going to be scanned, san serif (versus serif) keywords
Excelmoving around in the sheet store enrollment carpet store invoice P&L loan payroll one value per cell, delete, edit inserting and deleting rows and columns Sigma for totaling Vlookup IF PMT VLOOKUP Printing - importance of Preview Graphs Using the Wizard Modifying chart properties
PowerPoint Similarities to MS Word Themes Animated Clip Art Slide Transitions Drawing: circle/oval, square/rectangle, lines/arrows, Autoshapes: paint bucket, border color/width, text color Slide show setup: kiosk Animating Objects, order of appearance Locating & Using Themes on the Internet Views: slide, slide sorter, slide show Pen on slide show view
AccessDesign Queries Forms Change Field properties Multiple Fields Reports