ࡱ> /. @\pcypher Ba==h;\:8X@"1Arial1Arial1Arial1Arial1Arial1 Tahoma1Tahoma1Tahoma10Tahoma10Arial10Arial1 Arial1 Arial1$Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *    x@ @ 7 x@ @  x@ @  @ @  x@ @ x@ @ 7  x@ @  x@ @  1t p@ @   @ @  x@ @ p@ @ 7   @ @ 1| t  `! Assessment`i0Example Technology/Computer Assessment WorksheetnUse this worksheet to determine the level of technology/computer knowledge and skills of potential volunteers or employees. Directions: The four categories of competency include Operating Systems, Hardware, Software, and Internet/Networking. Please use the following key to indicate your level of understanding and provide the appropriate number in the grid below.# 1 = Yes. I can preform this task.$ 0 = Maybe. I need additional help.& -1 = No. I cannot preform this task.Competency/ SkillLevelOperating Systems7Explain the difference between the Mac and PC platforms/Boot up, log-on, restart and shut down computer<Open, resize, maximize, minimize, close and restore a windowYExplain and modify properties of desktop settings (e.g., resolution, color, refresh rate)1Modify properties of files (e.g. name, file type)8Manage multiple windows and modify properties of taskbar0View and change file extensions and window views+Create, modify and delete files and folders'Locate a file by using the Find optionsJExplain and perform the terms drag-and-drop, right click and cut-and-pasteInstall and uninstall programs>Maintain hard disk integrity via scan disk and defragmentation1Provide examples of programs for file compressionInstall new fonts-Access backend functions using command promptSubtotalHardware]Explain basic components of a computer (e.g., CPU, Memory) and the relationships between themAInstall peripherals such as printers, scanners or digital cameras4Explain basic terms such as AGP, SCSI, USB, PCI etc& (Upgrade memory or install new hard drive\Explain the use and capacity of CD-RW, Zip, Floppy Disk and other media/data storage formats Software KExplain the difference between freeware, shareware, spyware and open source,Discuss anti-virus prevention and techniques.Discuss characteristics of a good back up plan3Explain, download, install, save and view PDF files5Edit, modify and create PDF files using Adobe AcrobatWord!Create a document from a template'Modify font size, color, and formatting2Toggle between print, web, outline and normal viewTurn on/off Office Assistant/Insert and modify special symbols or characters)Edit documents using copy, cut, and paste%Select, resize and customize toolbarsRevise normal.dot templateModify headers/footersModify paragraph formatting"Create numbered and bulleted lists*Insert and modify tables within a documentInsert and modify hyperlinks1Modify table settings such as borders and shading=Create, edit and customize labels, envelopes and form letters1Sort a list or selected paragraphs alphabetically)Turn on/off spelling and grammar checking Insert files, clip art or photosExcel-Enter, edit, and evaluate data in a worksheetSModify cell formatting (e.g., merge cells, change font/color/size, modify decimals)/Select, move and edit multiple cells or columns:Adjust cell and column properties such as height and width"Insert, modify and delete commentsCModify print features such as print size, orientation and selection*Use formulas for data analysis (i.e., sum) Freeze panesUtilize auto-fill featuresDPrint background features such as comments, formulas, gridlines etc& ,Create charts, tables and diagrams from data%Combine, rename and delete worksheets'Define absolute and relative references Create, manage and modify macros#Modify toolbar features and options6Sort and filter data within multiple cells and columnsAccess:Describe the components of a database (e.g., form, report)1Create and edit new and existing Access databases'Define SQL and describe benefits of use&Create and design forms for data input'Run reports and create design templates.Define primary key and describe its importance&Demonstrate linking of multiple tablesCreate multiple queries PowerPoint/Create and edit new or existing presentation(s)IInsert, create and edit tables, pictures, shapes and sounds within slides;Modify master template, slide transitions and color schemes(Edit slide arrangement via drag and drop!Export presentation as a Web pageOutlook'Create, edit or delete an email account&Modify address book display properties&Customize toolbars and viewing optionsSend emails with attached files-Create message rules to filter incoming emailAdd/Edit signaturesChange file storage locationDefine POP, SMTP, SSL and PGPCreate HTML email,Import and Export messages and address booksInternet/NetworkingBDefine WWW and the difference between the Internet and an intranetLName 3 major Web browsers and explain how to change default browser settingsBDefine and use URL s and hyperlinks to access documents on the Web(Print a Web page, specific frame or text'Send and attach files to outgoing email9Utilize search engines or databases to locate information/Explain, manage and create Favorites/Bookmarks BLocate, modify and clear cache, history and manage browser optionsView HTML source of Web pageTransfer files via FTP.Apply mail rules for filtering junk/spam email9Explain the terms LAN, WAN, Hub, Router, NIC and FirewallIIdentify and diagram components of a LAN (e.g., cable type, network card)SExplain different types of Internet access mediums (e.g., cable modem, dialup, T-1)9Discuss encryption and methods of securing files and data@Discuss password security and give an example of a good passwordCUtilize commands such as Ping and Traceroute to test network statuscDesign basic Web page either by handcoding HTML, using WYSIWYG software or saving as HTML from WordTotalScoring90-10080-89GGood competency level, may need additional training in particular areas70-7960-69JWeak skill level. Needs additional training and practice of general skills?Strong competency level. Able to perform virtually all requestsHGeneral understanding of computer functions and can perform basic skills V - _} H d `?,H @ $r"h(j.4:~;  dMbP?_*+%"??cU} K} $ @@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ '' ((         ! &  &   &   &   &   &  & & & & & & & & & #"| %A ! & & & & & ## %t ! &Dl55 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@   & !!!& """& ###& $#$# %# %$%! &%&& '&'& ('(& )()& *)*& +*+& ,+,& -,-& .-.& /./& 0/0& 101& 212& 323& 434& 545& 656& 767& 8#8#$ %&7A 979! :8:& ;9;& <:<& =;=& ><>& ?=?&Dl55@@A@B@C@D@E@F@G@H@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@ @>@& A?A& B@B& CAC& DBD& ECE& FDF& GEG& HFH& IGI& J#J#8 %:IA KHK! LIL& MJM& NKN& OLO& PMP& QNQ& ROR& SPS& T#T#J %LS a UQU$ VRV& WSW& XTX& YUY& ZVZ& [#[#T %VZt \W\$ ]X]& ^Y^& _Z_&Dl555`@a@b@c@d@e@f@g@h@i@j@k@l@m@n@o@p@q@r@s@t@u@v@w@x@y@z@{@|@~@@ `[`& a\a& b]b& c^c& d_d& e`e& faf& g#g#[ %]ft hbh$ ici& jdj& kek& lfl& mgm& nhn& oio& pjp& qkq& rlr& sms& tnt& uou& vpv& wqw& xrx& ysy& ztz& {#{g %izA |uK|g5D{DgD[DTDJD8D$DD ~%v~ } %wBX55]@@@ y %x ~ %z | %{ (>@7 Oh+'0@HXh cyphercypherMicrosoft Excel@GI)@{6՜.+,0 PXd lt| s2  Assessment  Worksheets  !"#$%'()*+,-Root Entry FWorkbook;SummaryInformation(DocumentSummaryInformation8&