CORE BODY OF KNOWLEDGE
INFORMATION TECHNOLOGY
For each of the sections that follow, students may be required to analyze, recall, explain, interpret, apply, or evaluate the particular concepts being taught.
BASICS OF WINDOWS XP AND NOVELL NETWORKING
o demonstrate performance of basic operations for Novell and starting Windows XP; including
§ Network Neighborhood and available resources
§ using dialog boxes
§ accessing online help and printing information
§ using the accessories
§ using the control panel
§ logon and changing passwords
§ “Moodle” navigation and/or “Blended Schools”
§ file folder navigation and maintenance
§ copying and renaming files
§ viewing details; sorting by date, type, name
DEMONSTRATE KEYBOARDING AND FORMATTING
o demonstrate basic proficiency in keyboarding using correct technique in alignment with the new state standards for technology.
INTRANET AND INTERNET WORK
o understand the importance of updating and using virus protection software and firewall protection
o access teachers’ passouts folders
o effectively use the primary features in Mozilla Firefox (or Internet Explorer)
WORD 2007
o demonstrate an understanding of Word 2007 basics
§ defining word processing software
§ launching Word 2007
§ viewing Word program window
§ entering and saving text in a document
§ inserting and deleting text
§ selecting and replacing text
§ getting on-line help with Office Assistance
§ previewing, printing, and closing a document
§ use of styles and themes
§ use of citations, bibliographies, and managing sources
§ use of footnotes, endnotes, tables of contents, captions, cross-references
§ watermarks, borders
o browse the Internet, download a list of employment opportunities, and compose a cover letter for a job application
o compose a resume
o demonstrate an ability to format a document by applying font effects using the toolbar, applying special font effects, aligning text with tabs, changing paragraph alignment, indenting paragraphs, and changing paragraph spacing
o show mastery in the use of the MLA format prescribed by the PTSD English Department.
o demonstrate an ability to create bulleted and numbered lists and to apply borders and shading
o demonstrate an ability to create new tables, convert text to a table, insert and delete rows and columns, calculate data in tables, sort information in tables, and format tables
o demonstrate an ability to use the Draw Table button and modify a table with the Tables and Borders toolbar
EXCEL 2007
o define spreadsheet software, launch and view the Excel Window, open and save an existing workbook
o enter labels and values, preview and print a worksheet, and access on-line help
o plan, design, and create worksheets, edit cell entries and work with ranges, enter formulas and functions
o copy and move cell entries, copy formulas with both relative and absolute cell reference
o describe the difference between relative and absolute values
o perform an integration task using the Internet and Excel spreadsheets
o format values, fonts, and point sizes, change attributes and alignment of labels
o adjust column widths, insert and delete rows and columns, apply colors, patterns and borders, use conditional formatting, check spelling, and split a window into panes
o design a chart in Excel and move, resize, and edit a chart
o enhance a chart and add text annotations and arrows and other graphical operations
o perform linking with Internet information and Excel charts
o integrate Word and Excel by copying and by creating dynamic links (DDE)
o explain the difference between "linking", "embedding", and "hyper-linking"
o convert Excel worksheet data and charts to Web pages
INTEGRATION BASICS TO CREATE MAIL MERGED DOCUMENTS, ENVELOPES, AND LABELS
o properly format a main document and a Word data source, insert merge fields in a main document, merge a main document and data source
o automatically create properly formatted envelopes and labels
ACCESS 2007
o open a database table, enter and edit records, preview and print a datasheet
o create forms and format controls
o use Access to generate a report from a database
o create and manage data using filters and complex queries
o create reports and labels from Access tables
o query and mail merge with Word documents
POWERPOINT and PUBLISHER 2007
o design elaborate animated presentations
o design web pages
o integrate PowerPoint with Visio 2007 projects
TEXTBOOKS
o Microsoft Office 2007 Illustrated Series Introductory, Thomson Course Technology, Copyright 2008
o Microsoft Office 2007 Illustrated Series Second Course Thomson Course Technology, Copyright 2008