CINS 101 - Introduction to Microcomputers

1. Identify the principle hardware components of a microcomputer and describe their functions.
2. Utilize an operating system utility to create and manage folders and copy, move, and delete files.
3. Use a word processing application software to perform the following tasks:
   1. Open, format, edit, and save simple and complex documents created from scratch orby utilizing templates
   2. Use find and replace, format painter, themes and styles
   3. Create and format tables
   4. Use the spelling, grammar, readability and accessibility tools
   5. Use the Quick Access toolbar and Backstage view
4. Use spreadsheet application software to perform the following tasks:
   1. Create, modify, edit, format, and perform calculations in a worksheet
   2. Split and manage worksheet windows
   3. Enter data and formulas
   4. Format, print, and preview workbooks
   5. Create headers and footers
   6. Share workbooks with others
   7. Use functions
   8. Import data,
   9. Create data tables and charts;
   10. Use Flash Fill, Format Painter, and Range Finder
   11. Apply conditional formatting
   12. Use absolute and mixed cell references
   13. Create and edit charts
   14. Use Goal Seek and Smart Lookup
   15. Answer What If questions
5. Utilize presentation software to perform the following tasks:
   1. Demonstrate how to add media and animations with or without transitions
   2. Add SmartArt and math equations to a presentation
   3. Apply and format slide backgrounds
   4. Add speaker notes
   5. Change views
   6. Modify illustrations using ungroup, change color of and regroup
   7. Use animation effects on entrance, emphasis, and exit
   8. Change themes and variants
   9. Secure and distribute a presentation
6. Use email/calendar program to perform the following tasks:
   1. Compose, read, open, print, reply to and close emails
   2. Preview, attach and save a file attachment
   3. Create, move and delete messages
   4. Display the People pane and set language preferences and sensitivity levels
   5. Describe the calendar components; display the calendar in various views
   6. Organize with color categories and add national holidays
   7. Use the Date Navigator; set status and reminders
   8. Import an iCalendar, create appointments and schedule meetings in calendar
   9. Use Backstage view to print, save and share a calendar

• Demonstrate ability to open, format, edit, save, and print single and multi-page documents from scratch or through templates
• Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles
• Create and format tables
• Identify and correct problems using the spelling, grammar, readability, and accessibility tools
• Create complex and professional documents
• Work with the Quick Access Toolbar
• Use the Tell Me and Smart Look up features
• Work with the features located in the Backstage view

Use a presentation software program to perform the following tasks:

• Create and deliver engaging multimedia presentations through the use of text, graphics, special effects and animations
• Demonstrate how to add media and animations with or without transitions
• Add SmartArt and math equations to a presentation
• Apply and format slide backgrounds
• Add speaker notes to a slide
• Change views
• Modify illustration using ungroup, change color of and regroup
• Use transition effects on entrance, emphasis, and exit
• Change themes and variants
• Secure and distribute a presentation

Use a spreadsheet program to perform the following tasks:

• Create, modify and edit worksheets
• Perform calculations in a worksheet
• Enter data, formulas, format and print workbooks
• Split and manage worksheet windows; set print options; print and preview workbooks; create headers and footers; and share workbooks with other users
• Demonstrate ability to copy contents of cells to a range of cells
• Show ability to use functions, create nested functions, import data from other sources and create different types of data tables and/or charts
• Change a worksheet name and sheet tab color
• Insert, delete and hide data in worksheets
• Use Flash Fill and Format Painter
• Apply the IF, MAX, MIN, and AVERAGE functions
• Use Range Finder to verify a formula
• Apply conditional formatting
• Use absolute and mixed cell references in a formula
• Create and edit clustered column charts, Sparkline charts and use chart filters
• Demonstrate ability to Use Goal Seek, Smart Lookup Insight and answer what if questions

Use an email/calendar program to perform the following tasks:

• Navigate, compose, read and respond to email
• Apply a theme
• Demonstrate ability to preview a message
• Attach a file to an email and save a file attachment
• Demonstrate how to open, read, print, reply to and close an email message
• Create and move messages into a file and delete email messages
• Show how to display the People Pane
• Set language preferences and sensitivity levels
• Describe the components of the Calendar
• Use the Date Navigator to navigate the calendar
• Demonstrate ability to display the calendar in various views
• Demonstrate ability to organize your calendar with color categories and add national holidays to the calendar
• Set the status of and a reminder for an appointment
• Import an iCalendar
• Create appointments and schedule meetings in Calendar
• Use backstage view to print, save and share a calendar