Topic Checklist

Home
Up
CIS100 Quzzes/Test
Topic Checklist
Site Map and Search
What's  New/What's Due?
General Guidelines
Assignments for CIS 100
Calendar- CIS100
CIS 100 Syllabus
Hints for Assignments
Student Learning Outcomes
Word Processing
Internet & Email
Spreadsheets
Access DB
PowerPoint
Portfolio


 

Concepts

   

Bit,Byte
Kilo, mega,giga, tera, size of one piece of page

   

Number of People in the world, in the USA, on the internet

   

Components of A Computer Information System

   
bulletHardware
   
bulletSoftware
   
bulletPeople
   
bulletData (GIGO)
   
bulletProcedures
   
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)    
     


Windows

Format 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, 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, 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 documents
   

Create a personal web site using Google Sites

   

Portals

   
Answers.com (download, cite)    
New Window with Ctrl + N    

Email    
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 Processing

Menus, 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)

   
bulletForm Letter
   
bulletData Document
   

Tracking Changes

   
Resume - going to be scanned, san serif (versus serif) keywords    

Excel
   
moving 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    

Access
   
Design    
Queries    
Forms    
Change Field properties    
Multiple Fields    
     
Reports