Skills Checklist - Cumberland College



Checklist of Office SkillsWordBasicCan create a new document or open an existing one.Can add change or delete text.Can cut, copy and paste text.Can do formatting (bold, underline, italics) as well as centering.Can change fonts and settings using the font dialogue boxCan change line and paragraph spacingCan use the format painter.Can change paper size and orientationCan insert page numbers, headers and footersCan use tab formatting on ruler and from dialogue boxCan save to a network drive.Can print to specific printersIntermediateCan use tabs and indents from Format menuCan insert pictures, clip art and SmartArt with text flow.Can use columns.Can use, modify and save stylesCan apply and customize themesCan add watermarksCan use bullets from formatting menu.Can insert, edit and format tablesCan add formulas to tablesAdvancedCan send documents to emailCan do a mail merge on a form letter.Can insert form fields into a documentCan set tracking optionsCan use digital signaturesCan use footnotes and endnotes in all major stylesCan set up an automatic Table of ContentsCan create an Index and update and edit entries. ExcelBasicCan open or create a new spreadsheet.Can navigate to specific cells.Can enter text and numbers.Can enter a simple formula.Can use absolute and relative referencesCan save to a specific folder.Can do simple formatting.Can apply cell formatting such as cell borders, patternsCan copy and paste formulas as well as cell contents.Can apply themesCan adjust column and row widths and heightsCan create a chartCan move resize and copy charts into other Office appsCan print gridlines and formulasIntermediateCan enter functions and find the correct syntax for all functionsCan open extra worksheets in same spreadsheetCan print PART of a spreadsheetCan sort a spreadsheet.Can insert SmartGraphics, pictures and objectsCan customize charts, legends and apply stylesCan customize formats and apply conditional formatting.Can create a table as wells as format it and add and delete rows or columnsCan create a database and apply simple and advanced filtersCan sort with two criteriaAdvancedCan use such functions as LOOKUP to enter data in multiple cellsCan lock and unlock parts of a spreadsheetCan perform a query.Can find and replace dataCan group and ungroup cellsCan convert text to columns.Can save as Html documentCan create a shared workbook, track changes and show historyCan create a pivot tableOutlookBasicCan read, reply and forward email messagesCan save attachmentsCan add a sender to contactsCan print messagesCan flag a message for follow upCan use the search functionCan sort messages for date and nameCan use the contacts list for multiple recipientsCan add an entry in the calendarCan set a reminderCan access the web version from homeIntermediateCan set up a distribution listCan create folders and drag items to themCan apply themes and use stationeryCan set up a signature fileCan set up an “away from the office” message.Can set up a recurrent appointment.Can set up recurrent appointmentsCan view and share a calendarAdvancedCan set up a rule to automatically file messages in various foldersCan view multiple calendarsCan set up an online calendarCan import and export items from Outlook.Can schedule a meeting request with inviteesPowerpointBasicCan open or create a PowerPoint presentation with a template or theme.Can insert, move or delete slidesCan add text, pictures, or clipart.Can format pictures and use effects. Can animate objects in a slideCan create a Photo AlbumCan insert and edit SmartArtCan insert a chart or table.Can format text with fonts bullets and numbersCan view and navigate through a slideshowCan switch to and use the Views including Notes.Can insert text boxes.Can insert WordArtCan save to a specific network driveCan use the slide sorter and slide show mode.Can apply a design templateIntermediateCan view and edit a slide masterCan format and add elements to a slide masterCan create a slide which plays automaticallyCan insert sounds as well as picturesCan add multiple animationsCan use custom animationCan add transitions.Can create HandoutsCan create a presentation from an Outline especially Word outlines.AdvancedCan work with markupCan set passwords on presentationsCan compress images and use PPSCan create a presentation CD which will play on any computerCan record narrationCan control timings in presentationCan create a menu with a non-linear presentationSMARTBoardBasicCan start and stop the LCD projector and adjust resolutionCan adjust keystoningCan orient the SMARTBoardCan type on SMARTBoardCan do markup with pens and erase with eraserIntermediateCan save markup on SMARTBoard and with Office Pen ToolsCan use scanning and panningCan run programs using SMARTBoard onlyCan use PowerPoint on a SMARTBoardCan start the Notebook 10 program and save workAdvancedCan create presentations in Notebook 10Can import pictures from the net into Notebook presentationsCan use the My Collections to save presentation resourcesCan link objects in Notebook to sounds, other pages or turn them into hyperlinks to netCommunication Technologies - PolycomBasicCan call one other location and initiate a meeting using favoritesCan control the near and remote camerasCan pan and zoomCan mute and unmute the microphoneIntermediateCan add IP addresses to favorites Can set up a meeting involving more than one other siteAdvancedCan send a computer screen, video or SMARTBoard through the units to multiple sitesCommunication Technologies - LyncBasicCan use Lync to conduct a text dialogueCan send files to attendees IntermediateIntermediateCan join a video or audio call in LyncCan initiate a video or audio call in LyncAdvancedCan configure a webcam or microphone for use in LyncCan control multiple monitors in LyncCan record a meeting for later use ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download