• Instructional Software
• Desktop Basics & Troubleshooting
• Word Processing & Desktop Publishing
• Spreadsheets
• Database
• Internet
• Multimedia

INSTRUCTIONAL SOFTWARE OBJECTIVES

Level I	Level II	Level III	Level IV
IS.I.1 Participant will use drill and practice software	IS.II.1 Participant will use drill and practice software that includes adjustments for student levels and for teacher reporting.
	IS.II.2 Participant will understand the three types of software available for classroom uses.	IS.III.1 Participants will evaluate software as it is related to curricular needs and teaching strategies	IS.IV.1 Participants will act as a resource and promote the use of software specific to curricular needs.
		IS.III.2 Participants will use a variety of software given specific curricular objectives.
	IS.II.3 Participants will use a variety of software titles that are available at the site level.	IS.III.3 Participants will research software titles based on curricular needs.	IS.IV.2 Participants will use external sources (i.e. Internet software review sites, journals, colleagues, etc.) to seek out quality software given specific needs.
		IS.III.4 Participants will apply strategies for efficiently and effectively learning the operation of a new program.
	IS.II.4 Participants will use a presentation device for large group instruction of software applications.	IS.III.5 Participants will use a variety of large group, small group, and individual implementation strategies having specific curricular objectives in mind.	IS.IV.3 Participants will design effective learning environments based upon student needs and curricular objectives.

DESKTOP BASICS & TROUBLESHOOTING OBJECTIVES

Level I	Level II	Level III	Level IV
DT.I.1 Participant will identify computer components and their functions. Define computer components Connect CPU, monitor, keyboard, mouse, peripherals, network, and power supply
DT.I.2 Participant will contact the appropriate person to obtain a password(s).	DT.II.1 Participant will periodically change passwords to maintain security.
DT.I.3 Participant will demonstrate proper computer start-up and shutdown. Start up computer system Shut down computer system Perform cold boot Perform warm boot	DT.II.2 Participant will install and upgrade applications from disk or CD-ROM.	DT.II.1 Participant will install and/or upgrade applications using downloads from e-mail or internet websites.
DT.I.4Participant will access programs/files with or without desktop security program.(At Ease, Foolproof, On Guard, etc.)	DT.II.3 Participants will bypass desktop security programs if allowed.
DT.I.5 Participant will demonstrate proper usage of computer menu items and other desktop elements. Locate and use menu bar Select appropriate menu item for a desired task Respond appropriately to dialog boxes. Apply appropriate mouse clicks to icons and buttons Distinguish between icons, buttons and menus Distinguish between applications, folders, documents, harddrive, servers and trash can/recycle bin Use vocabulary and terminology
DT.I.6 Participant will manage windows with a mouse. Use the mouse to click, double click and drag Open, close, move and resize a window Minimize/hide a window. Restore a minimized/hidden window Maximize a window Restore a maximized window. Tile and cascade displayed windows Hide all windows to display only the desktop	DT.II.4 Participant will increase computer functionality. Use appropriate keyboard shortcuts to execute commands Open and use more than one application at a time Put most used items in Start/Apple menu Use the find utility Use the control panel Lock file/folder Identify and manipulate preferences, defaults, and other selectable features of operating systems or applications Create an alias/shortcut when necessary/helpful. Use the alias/shortcut to locate target/original item	DT.II.2 Participant will customize their computer for advanced use. Make more memory available to one or more applications Configure network and internet settings Print to a network printer Add/setup printer software for local printer
DT.I.7 Participant will organize their files and folders so that they are easily accessible. Locate a file/folder Move a file/folder to a different location Copy a file/folder to a different location Delete/trash a file/folder Retrieve a deleted file/folder Empty recycle bin/trash Create a folder .	DT.II.5 Participant will connect to a server in order to access applications and access saved documents.	DT.III.3 Participant will share files between networked computers. Set up file sharing Log onto another computer Access and/or save to another computer
	DT.II.6 Participant will demonstrate essential computer maintenance. Make backup copies of files Identify system files Protect system files from deletion/modification Exchange files among different operating systems Install an application Upgrade an application	DT.III.4 Participant will perform advanced computer maintenance. Rebuild desktop(Mac only) Run appropriate disk repair utility Protect against computer viruses
	DT.II.7 Identify and describe the major operating systems associated with computer platforms found in the district (ISTE 4.4.1)	DT.III.5 Participant will use strategies to resolve compatibility issues. Save documents in cross-platform formats Format and/or use PC disks Use applications which are cross-platform (i.e., Word, html, etc,)
			DT.IV.1 Participant will teach troubleshooting techniques to another user.

WORD PROCESSING OBJECTIVES

Level I	Level II	Level III	Level IV
WP.I.1 Participant will navigate within an existing word processing document. Open an existing document by double-clicking on it Open a word processing application; open an existing document from within word processing application Change the insertion point location by using a variety of methods Use a variety of methods to move through a multiple-page document (i.e. scroll bar, arrows, page up, page down, etc.) Perform simple operations by using menu bar and toolbar Close a document and exit/quit the word processor application     WP.I.2 Participant will edit, save and print an existing word processing document. Use text wrap Start a new paragraph using the return or enter key Undo the last action Insert and delete text, spaces and returns Select text using a variety of methods Copy and paste text to a new location in the document Move text to a new location in the document using drag-and-drop Use a spell checker Name and save a document to a specific location or disk. Print a document. Utilize a template	WP.II.1 Participant will become proficient at independently navigating, editing and formatting with a word processing application. Use the help system as reference tool Use keyboard commands to navigate and edit the document Customize and use toolbars Use writing tools (i.e., thesaurus, grammar check, word count) Display and hide nonprinting characters
WP.I.3 Participant will create and format a new word processing document. Create new document and input text Change page orientation from portrait to landscape Understand default settings Change line spacing Change font, style and/or size Change justification Change margins of a document Use default tabs	WP.II.2 Participant will create, edit and format a new word processing document with graphics.   Find and replace text. Set tabs (i.e., left, center, right, decimal). Insert page breaks Save a document as a template. Insert headers and footers. Insert date, time and page number. Create labeled lists using application commands/buttons Change paragraph indentation settings using the ruler Insert a graphic from application's clip art collection. Manipulate a graphic (i.e., rotate, flip, resize, reshape) Wrap text around a graphic Create an outline using appropriate tools Insert and edit a table or chart	WP.III.1 Participant will create, edit and format a new document using desktop publishing techniques. Plan and design a visually appealing document (i.e., font, color, graphics, etc.) Create and use columns and columns breaks Copy and paste paragraph formatting/ruler Insert graphics from a variety of sources Use graphic tools to create special effects (i.e., shadows, transformation, etc.) Arrange multiple graphics (i.e., layer, align, group/ungroup, lock/unlock) WP.III.2 Participant will share/merge information from other applications with a word processing document. Mail merge with database or data documents Insert and link spreadsheet data Participant will use HTML features in a word processing application. Create a page with active internet links. Create a document and save as a HTML page.
		WP.III.3 Participant will develop and implement a whole group project which utilizes word processing/desktop publishing applications. (I.e., brochure, class newspaper, research, etc)	WP.IV.1 Participant will develop and implement a lesson or project where students utilize word processing/desktop publishing applications. (I.e., brochure, class newspaper, research, etc)

SPREADSHEETS OBJECTIVES

Level I	Level II	Level III	Level IV
SS.I.1 Participant will describe the various uses and educational applications of spreadsheets. I.e., develop various spreadsheets, analyze data, organize data
	SS.II.1 Participant will be able to input a given set of data into a predesigned spreadsheet. Enter data including text, numbers, and dates Save and close Use tool bars Open an existing document Print an existing document Use appropriate vocabulary regarding spreadsheets (cells, number cells, text cells, columns, rows, etc.)	SS.III.1 Participant will design a spreadsheet that presents in an organized fashion for a specific purpose. Column/row headings Row height, column width Entering data Formatting data for sorting
	SS.II.2 Participant will be able to edit and format a predesigned spreadsheet. Edit information within a cell (cut, copy, paste, clear) Edit information within a range of cells (cut, copy, paste, clear) Move data using "drag and drop" Delete data and undo action Select single cells, columns, rows, and whole spreadsheet Insert and delete rows and columns Adjust column widths and row heights Use numeric format Format data within a cell or groups of cells (fonts, size, color, alignment) Preview print jobs Use page setup options (print size, margins) Print spreadsheets Utilize fill commands	SS.III.2 After creating a spreadsheet, participant will be able to edit and format the document according to their needs. Print a document, cell ranges, etc. Sort in ascending vs. descending order Sort multiple rows and columns Protect and unprotect cells Shade ranges
	SS.II.3 Participant will be able to use basic formulas to obtain quantitative results given a set of data in a predesigned spreadsheet. Use a variety of cell references Use averaging tools Use auto sum	SS.III.3 Participant will be able to create formulas for numeric and text calculations. Format for calculations Use relative cell references Use absolute cell references Use relative and absolute references Use appropriate functions Use advanced formulas Use cell references (Absolute, Relative, and Mixed)
	SS.II.4 Participant will be able to create a graph or chart from a given set of data in a predesigned spreadsheet. Use wizard/menu bar/button bar to create a graph or chart Add footers and headers Use borders (outline, right, left, top, and bottom) Change display (Claris Works users) Use style sheets (create, modify, format cells)	SS.III.4 After creating a spreadsheet, participant will be able to analyze the data and determine appropriate charts and graphs to display the information. Identify purpose for each type of chart or graph Create appropriate chart and graph for intended purpose Format and modify charts and graphs to elaborate the purpose Modify charts and graphs (change types, reposition legends, resize/move)	SS.IV.1 After collecting relevant data, participant will be able to use spreadsheets to create charts and graphs which are then imported into other applications. Move and copy data between spreadsheets/worksheets Link data from one spreadsheet/worksheet to another Import/export spreadsheets into other applications Link spreadsheets to other applications Cut and paste spreadsheets into other applications
		SS.III.5 Participant will develop and implement a whole group lesson plan utilizing spreadsheets to collect, organize, and analyze information within a curricular topic. Determine appropriate spreadsheet uses Create a spreadsheet for data input Create appropriate graph or chart to analyze data; assist students in analysis/synthesis	SS.IV.2 Participants will develop and implement a lesson or project where students design/create spreadsheets for developmentally appropriate analytical / statistical purposes. Determine appropriate spreadsheet uses Create a spreadsheet for data input Create appropriate graph or chart to analyze data; assist students in analysis/synthesis

DATABASE OBJECTIVES

Level I	Level II	Level III	Level IV
DB.I.1 Participant will identify three database applications (e.g., search engines, library catalogs, etc.), what information they contain, and describe how they are used.
	DB.II.1 Participant will identify and define database components given an existing database. Use database vocabulary (i.e., tables, fields, etc.) Define database components
	DB.II.2 Participant will enter, edit, and print data, given an existing database Enter data Edit data Print database	DB.III.1 Participant will design a database for a specific purpose. Determine and develop categories of information Enter data Change, delete fields
	DB.II.3 Participant will organize data within a given database by sorting information using one criteria Sort alphabetically, numerically, chronologically, etc. Sort in ascending and descending order	DB.III.2 Participant will analyze and manipulate data in a database View, hide, sort, find and match records Share/merge database information with other applications Import data from other applications Add, change, and delete fields Design data tables (for Access users only) Define field types Copy, delete, and paste records
		DB.III.3 Participant will create, edit and print a report for a specific purpose. Create a n organized report/layout presenting selected data Create multiple reports within a given database for a variety of purposes. Edit a report/layout Print a report/layout
		DB.III.4 Participant will develop and implement a whole group lesson plan which utilizes a database to collect, organize, and analyze information. Determine appropriate database uses Create database for data input Create report to analyze data Assist students in analysis/synthesis	DB.IV.1 Participant will develop and implement a lesson or project where students create/manipulate databases for developmentally appropriate research purposes.   Determine appropriate database uses Create database for data input Create report to analyze data

INTERNET OBJECTIVES

Level I	Level II	Level III	Level IV
IN.I.1 Participant will have an understanding of Internet connectivity and structure. Understand hardware, browsers & networking to include LAN & WAN, & current ways of connecting to the Internet (school, home, business) Discuss historical & social implications Discuss Acceptable Use Policies for student and staff   IN.I.2 Participant will understand and describe the value of telecommunications to increase relevant and authentic learning opportunities. I.E., collaborative projects, real time data applications, access to experts
IN.I.3 Participant will locate web pages, given a list of web sites related to various curriculum topics. Start the navigation browser Input URLs to view web pages Identify domain types Use the navigation tool bar Navigate links	IN.II.1 Participant will locate and utilize web pages, given a list of web sites related to various curriculum topics. Print data Download graphics, video, sounds Save a web page Copy and paste web based text to another application Follow Fair Use Guidelines and Copyright procedures	IN.III.1 Participant will locate, utilize, and evaluate relevance and validity of web pages, given a list of web sites related to various curriculum topics. Determine validity of a web site to include: Author posted vs. juried (peer reviewed) website, broad over generalizations vs. specifics Find collaborating evidence Credentials of author listed Resources and references listed by author Biased or commercial interest Publication date of the information
IN.I.4 Participant will use simple procedures which support district Acceptable Use Policies Demonstrate personal security with respect to credit card numbers, names, phone numbers, addresses, email addresses, etc.. Use appropriate e-mail and "net etiquette"	IN.II.2 Participant will be able to develop classroom procedures as a way to provide safe internet use. Provide students with safe searching situations to include: Instructor generated bookmarks, arrange computers so that screens are visible to the instructor, use a teacher developed web page that links to predetermined sites, don’t allow free internet surfing, instructor screened email, web whacking
IN.I.5 Participant will research a relevant topic using a simple search technique. Perform category searches (i.e.. Yahoo links to categories) Perform simple keyword searches Perform searches via system software where provided (i.e. Sherlock)	IN.II.3 Participant will research a relevant topic using advanced search techniques. Perform advanced keyword searches using Boolean and logical operators (i.e., +, -, &, or, not, " " ) Use meta-search engines
		IN.III.2 Participant will utilize freeware/shareware programs available via the Internet. Follow copyright laws Understand the increased potential for conflicts when using non-commercial products Identify, locate freeware/shareware programs Scan for virus and install freeware/shareware programs	IN.IV.1 Participant will utilize plug-ins to enhance web browser capabilities. Identify, download and install required plug-in in appropriate location (i.e. Shockwave, RealAudio, etc.) Identify download and install players (i.e. Midi player, Movie player, MP3, etc.)
IN.I.6 Participant accesses and utilizes e-mail for professional/educational communications. Address and compose a message Send and receive e-mail messages Forward and reply to messages Save messages Delete unwanted messages Print messages	IN.II.4 Participant accesses and utilizes advanced features of an e-mail system for professional/educational communications. Create address books, Create distribution lists Attach and retrieve files Subscribe/ Unsubscribe to listservs Organize mail	IN.III.3 Participant will develop and implement a whole group lesson plan which utilizes telecommunication resources for research and collaboration with peers, experts, and other audiences to create an educational publication. Teacher will: Participate in video conferencing Cite resources in MLA or APA format Utilize E-mail / web mail Access web-based and/or collaborative projects Follow Fair Use Guidelines and Copyright procedures Create a product which integrates telecommunications into word processing, multi-media presentation, desktop publishing, and/or web page design	IN.IV.2 Participant will develop and implement a lesson or project in which students utilize telecommunication resources for research and collaboration with peers, experts, and other audiences to create an educational publication. Students will: Participate in video conferencing Cite resources in MLA or APA format Utilize E-mail / web mail Access web-based and/or collaborative projects Follow Fair Use Guidelines and Copyright procedures Create a product which integrates telecommunications into word processing, multi-media presentation, desktop publishing, and/or web page design
IN.I.7 Participant will access pre-existing bookmarks in a web browser.	IN.II.5 Participant will use a web browser to create and organize bookmarks/favorites of educational sites. Mark locations and access bookmarks/favorites Organize bookmarks/favorites by using separators Delete bookmarks	IN.III.4 Participant will utilize bookmarks for initial research and ongoing use during curriculum/lesson planning. Save bookmarks to disk, server, web, or email. Import and access bookmarks on another computer Save bookmarks as an HTML file, to be shared and accessed by other users Organize bookmarks in folders	IN.IV.3 Participant will develop and implement a lesson or a project where students utilize bookmarks for initial research and ongoing use during curriculum/lesson planning. Save bookmarks to disk, server, web, or email. Import and access bookmarks on another computer Save bookmarks as an HTML file, to be shared and accessed by other users Organize bookmarks in folders
		IN.III.5 Participant will develop and implement a whole group lesson plan in which they create an educational website (3 page minimum). Participant will: Create a storyboard for the web site, which includes elements of good screen design Use web publishing software to create a website, which includes: text, graphics, internal and external links, anchors, table and charts, bulleted or ordered lists, citations using MLA or APA format Follow Acceptable Use Policies, including copyright law	IN.IV.4 Participant will develop and implement a lesson or project where students create an educational website (3 page minimum). Student will: Create a storyboard for the web site, which includes elements of good screen design Use web publishing software to create a website, which includes: text, graphics, internal and external links, anchors, table and charts, bulleted or ordered lists, citations using MLA or APA format Follow Acceptable Use Policies, including copyright law

MULTIMEDIA OBJECTIVES

Level I	Level II	Level III	Level IV
MM.I.1 Participant will describe the value and purpose of using multimedia in the teaching/learning process
	MM.II.1 Participant will understand the planning procedures in multimedia production, given an existing presentation and its planning documents. Determine presentation objectives Analyze audience and setting Analyze flowchart Analyze storyboard Analyze screen design	MM.III.1 Participant will create a plan for a multimedia presentation on an educational topic (5 screens minimum). Determine objectives and audience Determine presentation medium & environment. Determine which multimedia software to use for the specific purpose Select linear or non-linear format Determine if use of multimedia elements are appropriate and meaningful Determine optimal design elements (font style, color, and size, background color or pattern and balanced layout, taking in account presentation format to be used, i.e. large screen projection, TV, computer monitor, etc.). Create flowchart Create storyboard
	MM.II.2 Participant will modify and enhance an existing multimedia presentation. Adhere to copyright laws Add text Add graphics Add buttons/hyperlinks Use tools to edit presentation	MM.III.2 Participant will produce a multimedia presentation on an educational topic (5 screens minimum). Create/delete slides/cards Rearranging slide/card order Copy/duplicate slides/cards Create transitions between slides/cards Create hyperlinks between slides/cards or other applications Add sound & video clips to add meaning if appropriate Create & print handouts from presentation/stack Import graphics from a variety of sources Import audio clips from a variety of sources Create bibliography, crediting sources of information & graphics Save presentation in self-contained format (file with player or "pack & go")     MM.III.3 Participant will evaluate effectiveness of a multimedia slideshow/stack when given a rubric.	MM.IV.1 Participant will produce a multimedia presentation on an educational topic using advanced development techniques. Use Master slide/background to customize entire presentation Create animations on slides/cards Create pop-up windows Embed objects into slide (i.e. tables, charts, spreadsheets, etc.) Save presentations/stacks to other media and platforms Connect and use presentation system to present Export presentation to other media (i.e. videotape, internet, CD-ROM etc.)               MM.IV.2 Participant will evaluate effectiveness of a multimedia presentation. Create an rubric to evaluate the product and presenter Present to peers Evaluate peer presentations
		MM.III.4 Participant will create digital media files and use in presentations. Scan photos and text Capture images with digital camera and download to computer Record audio clips Digitize video clips	MM.IV.3 Participant will manipulate digital media files and use in presentations. Manipulate digital images (i.e., crop, resize, filter, effects, color adjustments, etc.) Change digital images to other file formats (i.e. GIF, JPEG, PICT etc.) Use file compression utility Transfer digital sound clips from audio CD (copyright free only) Edit digital sound clips Edit video using computer video software Create own digital images using image manipulation software
		MM.III.5 Participant will develop and implement a multimedia presentation during the teaching and learning process.	MM.IV.4 Participant will develop and implement a lesson plan or project where students create a multimedia presentation on an educational topic.