CSCI 1100 Challenge Exam Skill Set

Computer Concepts
Parts of a computer
Four basic operations of a computer
Hardware components (input, output, storage, memory, CPU)
Software (system and application), types and purpose
Networks, servers, bandwidth, internet, intranet and the Internet
Interface, GUI, shortcut keys, mouse commands

Windows XP
Operating system
Window concepts, menu bar, title bar, toolbar, moving windows, changing window sizes, minimize, maximize, restore
Desktop concepts, wallpaper
My Computer concepts
Menu bar
Icons, and folders, shortcuts
Overview of Office applications (Word, Excel, PowerPoint, Outlook)
File management (hierarchical structure, storage media, folders)
Data management (create files/folders, rename, move, delete, formatting diskettes)
Problem resolution (data loss, lock-ups, viruses)

E-Mail
Addresses, sending, receiving, CC, BCC, address field, message, attachments
Top level domains, legal rights, spam, privacy

Internet/On-Line Resources
Internet Explorer browser application
Menu structure and functions
Control button functions
Status bar functions
Security features
Organization functions (Favorites, History, Cookies)
WWW, URL's, and navigation on the web
Search engines (index and directory types), wild card characters
Downloading files from the Internet
Verifying sources, and content
Privacy, encryption, hacking, top level domain, viruses

Word Processing (Microsoft Word XP)
Creating, modifying, and deleting documents
Cut, Copy, and Paste text, text borders, bullets, numbering outline, find/replace text
Word wrap, spell check, undo, formats
Fonts, italics, bold, alignment
Insert, delete, text, pictures, tables, charts
Save a document, save as, save to
Research paper, styles APA, MLA
Margins, line spacing, headers and footers, footnotes, end notes
Paragraphs, autocorrect, footnotes, word count, indenting, paragraph styles
Page breaks (manual, auto), Page Orientation
Symbols, hyperlinks, and thesaurus synonyms
Resume Wizard
Cover letter w/ Tables, inserting, modifying text inside, inserting rows, columns, delete rows, columns
Developing envelopes

Spreadsheets (Microsoft Excel XP)
The Excel worksheet and workbook, inserting worksheets, deleting worksheets
Layout, menu bars, cell references, page tabs, renaming page tabs, moving page tabs
Cells, selecting, entering text, numbers, inserting, modifying text, find/replace, cell alignment, cut, copy and paste, rotate text, Go To
Formatting, conditional formatting, saving, and printing a worksheet
Cell formulas, sum, max, min, averages auto-calculate, pmt, pv, absolute references, relative references
Fill handle, merge and center, entering formulas
Paste and insert function, smart tags, and titles
Point mode, copying formulas, numeric formatting
Saving, moving, printing, and copying worksheets and workbooks, page orientation
Charts, embedding, labels, data, formatting, customizing
Custom headers

Close Window