ITIS 130: Microcomputer Applications I

• identify general features of MS Office Applications (Word, Excel, Power Point, Access, and Outlook) by summarizing key points to demonstrate grasp of knowledge
• construct a Word document using acceptable formats
• design, input, outline, and plan a presentation to illustrate knowledge of skills
• construct a spreadsheet incorporating formulas, formats, and charts
• use research techniques to locate information from online resources
• understand database concepts, and manage a database, by creating a new database, to add and modify records
• read independently to acquire information for discussion in written responses
• practice integrity by observing ethical and honest behaviors in completing assignments
• evaluate important ethical questions in the use of informations technology (IT) by creating papers and reports
• demonstrate effective decision-making strategies regarding IT ethics and issues by participating in directed discussions
• display time management and study habits that reveal ability to complete assignments independently by meeting deadlines for submitting well-prepared work according to designated guidelines
• demonstrate comprehension of essential hardware, software, and computer system terminology by successfully completing written assignments and quizzes
• use prompts, commands, menus, and dialog boxes to interact with the Computer and Office Application software program (Word, Excel, Power Point, Access, and Outlook)
• organize computer-based documents into files and folders using the Windows operating system

Word Processing Objectives

1. Understand document processing
2. Identify components of the word processor Interface
3. Create a new document
4. Create a new document from a Template
5. Entering text in a document
6. Editing a document
7. Insert headers and footers
8. Divide a document into sections
9. Add page numbers
10. Format and balance columns
11. Insert and format Clip Art
12. Add borders and shading
13. Insert and format WordArt
14. Insert footnote
15. Create a table 
16. Create a multiple-page document
17. Create a newsletter using desktop publishing features
18. Create a web page using MS word

Electronic Spreadsheets Terminal Objectives

1. Understand electronic spreadsheets
2. Identify the components of the electronic spreadsheets Interface
3. Navigate in a workbook 
4. Open and save workbooks
5. Work with ranges 
6. Enter data in a worksheet 
7. Work with rows and columns 
8. Edit a worksheet in edit mode 
9. Work with worksheets 
10. Understand functions 
11. Copy and past formulas
12. Understand relative and absolute references
13. Using formulas 
14. Use logical functions 
15. Use the AutoSum button
16. Use date functions
17. Formatting worksheets 
18. Open the print review window 
19. Understand charts
20. Create and modify a chart 
21. Format chart elements 
22. Work with 3-d charts 
23. Use the drawing toolbar
24. Print charts 
25. Publish a non-interactive website using Excel workbooks
26. Publish an interactive website using Excel workbooks 

Database Management Systems Terminal Objectives

1. Understand database concepts 
2. Understand the database Management Systems Interface 
3. Manage a database
4. Understand how to design a database 
5. Create a new database
6. Create a new table
7. Add records to a table
8. Modify the structure of a table
9. Obtain data from another database 
10. Update a database 
11. Understand queries
12. Identify components of the query window
13. Create and run a query
14. Update data using a query
15. Define table relationships 
16. Create a multi-table query
17. Sort data in a query 
18. Filter data
19. Define record selection criteria for queries 
20. Define multiple selection criteria for queries 
21. Perform calculations 
22. Create a form using the form wizard
23. Change a form?s AutoFormat
24. Preview and print selected form records
25. Maintain table data using a form
26. Check the spelling of table data using a form 

Multimedia/Presentation Graphics Terminal Objectives

1. Understand
2. Identify the components of the Multimedia/Presentation Graphics Interface
3. Open an existing PowerPoint presentation
4. Run a slide show
5. Plan a presentation
6. Use the Auto content wizard
7. Edit Auto content slides
8. Create a folder for saving presentations
9. Save presentations
10. Modify a presentation
11. Use the style checker
12. Create speaker notes
13. Plan a presentation
14. Apply design templates
15. Modify slide masters
16. Apply a second design template
17. Add and modify tab stops
18. Insert footers and slide numbers
19. Insert and modify clip art
20. Create a table in a slide
21. Create cycle diagram
22. Add textbooks
23. Create and manipulate a shape
24. Insert and recolor a shape
25. Add text to a diagram