![]()
![]()
Concepts
Tue/Thur
007
008
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 every year 9/4 9/4 data->process->information sort, summarize, save, send select 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
9/4 9/4 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 - 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
floppy, thumb drive, Zip, hard disk, CD & DVD, tape
Move, 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
Internet
Inet- 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 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 Googlepages.com
Portals
Answers.com (download, cite) New Window with Ctrl + N Print Selection with name in footer 9/4 9/4
Tue/Thur 007 008 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
Reference Ribbon- Footnotes , Insert Citation, Bibliography
AutoCorrect Save, Save As, naming, .docx, .doc, .rtf 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