CSCI 1100 Challenge Exam Skill Set (Microsoft 2007 applications)
Computer Concepts
Parts of a computer
Four basic operations of a computer
Hardware components (input, output, storage, memory, CPU)
Software (system and application)
Networks and the Internet
Windows XP
Operating system
Desktop concepts
My Computer concepts
Menu bar
Icons, and folders
Overview of Office applications (Word, Excel, PowerPoint, Outlook)
File management (hierarchical structure, storage media, folders)
Data management (create files/folders, rename, move, delete)
Problem resolution (data loss, lock-ups, viruses)
E-Mail (Goldmail)
E-mail/Goldmail differences, ETSU accounts
Read, write, send, reply, forward, and manipulate e-mail
Creating E-mail address books and distribution lists
Locating E-mail addresses
Attachments, file types, limitation factors
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)
ETSU web site (areas, events, addresses, classes, search)
On-line library resources (Charles C Sherrod Library web site)
Search catalogs (Millenium online catalog)
Find articles
Get research help (Infotrac OneFile)
Downloading files from the Internet
Verifying sources, and content
Word Processing (Microsoft
Word 2007)
Creating, modifying,
and deleting documents
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
Paragraphs, autocorrect, footnotes, word count
Page breaks (manual, auto)
Symbols, hyperlinks, and synonyms
Resume Wizard
Cover letter w/ tables
Word to HTML conversion (web page)
Spreadsheets (Microsoft
Excel 2007)
The Excel worksheet
and workbook
Layout, menu bars, cell references, page tabs
Cells, selecting, entering text, numbers
Formatting, saving, and printing a worksheet
Cell formulas, sum, auto-calculate
Fill handle, merge and center, entering formulas
Paste and insert function, smart tags, titles
Point mode, copying formulas, numeric formatting
Saving, moving, printing, and copying worksheets and workbooks