Century 21 Jr.: Computer Applications and Input Technologies, 2e

IC3 Correlation

(Internet and Core Computing Certification)

Standard Number / Standard / Lesson Number
Correlation (page #) or Web Reference (www.cengage.com/
school/keyboarding/c21jr)
Module 1: Computing Fundamentals
DOMAIN 1.0 / COMPUTER HARDWARE, PERIPHERIALS AND TROUBLESHOOTING
Objective 1.1 / Identify types of computers, how they process information, and the purpose and function of different hardware components
1.1.1 / Identify different types of computer devices / Lessons 1, 56, 57 (pp. 2-5, 211-215, 216-225); also PDA lesson (on Web/IRCD)
1.1.2 / Identify the role of the central processing unit (CPU) including how the speed of a microprocessor is measured / Lesson 1 (p. 4); Web Reading 2
1.1.3 / Identify concepts related to computer memory (measurement of memory, RAM, ROM) / Lesson 2 – RAM (p. 15); Web Reading 2
1.1.4 / Identify the features and benefits (storage capacity, shelf-life, etc.) of different storage media / Lessons 1 & 5 (pp. 4-8, 41-44); Web Reading 2
1.1.5 / Identify the types and purposes of standard input and output devices on desktop or laptop computers / Lessons 1 (p. 8)
1.1.6 / Identify the types and purposes of specialized input devices (e.g. cameras, scanners, game controllers, etc.) / Lessons 1, 56, 57, 60, 61 (pp. 4-8, 211-215, 247-258, 259-265); also PDA lesson (on Web/IRCD)
1.1.7 / Identify the types and purposes of specialized output devices (e.g. printers, projectors, etc.) / Lesson 1 (pp. 4-5)
1.1.8 / Identify how hardware devices are connected to and installed on a computer system / Web Reading 6
1.1.9 / Identify factors that affect computer performance / Web Readings 2 and 5
Objective 1.2 / Identify how to maintain computer equipment and solve common problems relating to computer hardware
1.2.1 / Identify the importance of protecting computer hardware from theft or damage / Web Reading 4
1.2.2 / Identify factors that can cause damage to computer hardware or media (e.g. environmental factors, magnetic fields, etc.) / Web Reading 4
1.2.3 / Identify how to protect computer hardware from fluctuations in the power supply, power outages and other electrical issues (such as use of computers on different electrical systems) / Web Reading 4
1.2.4 / Identify common problems associated with computer hardware / Web Reading 4
1.2.5 / Identify problems that can occur if hardware is not maintained properly / Web Reading 4
1.2.6 / Identify maintenance that can be performed routinely by users / Web Reading 4
1.2.7 / Identify maintenance that should ONLY be performed by experienced professionals, including replacing or upgrading internal hardware (especially electrical) components (such as processors or drives) that are not designed to be user accessible / Web Reading 4
1.2.8 / Identify the steps required to solve computer-related problems / Web Readings 4 & 5
1.2.9 / Identify consumer issues related to buying, maintaining and repairing a computer including:
• Factors that go into an individual or organizational decision on how to purchase computer equipment
• Factors relating to maintenance and repair responsibilities / Web Readings 1 & 4
DOMAIN 2.0 / COMPUTER SOFTWARE
Objective 2.1 / Identify how software and hardware work together to perform computing tasks and how software is developed and upgraded
2.1.1 / Identify how hardware and software interact / Lessons 2 & 62 (pp. 9-15, 273-276); Web Reading 6
2.1.2 / Identify the difference between an operating system and application software / Lessons 1 & 2 (pp. 5-6, 9-12); Web Readings 5 & 6
2.1.3 / Identify issues relating to software distribution (e.g. licenses, upgrades) / Web Reading 6
Objective 2.2 / Identify different types of application software and general concept
relating to application software categories
2.2.1 / Identify fundamental concepts relating to word processing and common uses for word-processing applications (e.g. reviewing, editing, formatting, etc.) / Lessons 4 & 66 (p. 26, pp. 317-324)
2.2.2 / Identify fundamental concepts relating to spreadsheets and common uses for spreadsheet applications (e.g. worksheets, data sorting, formulas and functions, etc.) / Lessons 7, 8, 91, 93 (pp. 57, 58-60, 496-50, 507-510)
2.2.3 / Identify fundamental concepts relating to presentation software and common uses for presentation applications (e.g. slides, speaker notes, graphics, etc.) / Lessons 86, 87, 89, 90 (pp. 464, 469-470, 89, 90)
2.2.4 / Identify fundamental concepts relating to databases and common uses for database applications (e.g. fields, tables, queries, reports, etc.) / Lessons 97, 98, 100, 101, 102 (pp. 536-537, 540, 547-548, 558, 561-562, 567-568)
2.2.5 / Identify fundamental concepts relating to graphic and multimedia programs and common uses for graphic or multimedia software (e.g. drawing, painting, animation tools, etc.) / Lessons 56, 59, 78, 89, 90, 104 (pp. 214-215, 240-242, 245, 409-413, 478, 490, 591)
2.2.6 / Identify fundamental concepts relating to education and entertainment programs (e.g. computer based training (CBT), video, audio, etc.) / Web Reading 1, Web Reading 2
2.2.7 / Identify the types and purposes of different utility programs (e.g. virus, adware and spyware detection programs, etc.) / Chapter 3 Applying & Lesson 70 (p. 108, 357); Web Readings 4, 5 & 7
2.2.8 / Identify other types of software (e.g. chat, messaging, Web conferencing, accounting software, etc.) / Lesson 11 (pp. 78-82); Web Readings 6 & 7
2.2.9 / Identify how to select the appropriate application(s) for a particular purpose, and problems that can arise if the wrong software product is used for a particular purpose / Web Reading 6
2.2.10 / Identify how applications interact and share data / Lesson 1 (pp. 6-8)
DOMAIN 3.0 / USING AN OPERATING SYSTEM
Objective 3.1 / Identify what an operating system is and how it works, and solve common problems related to operating systems
3.1.1 / Identify the purpose of an operating system and the difference between operating system and application software / Lessons 1, 2, 5 (pp. 5-7, 9-15, 41); Web Reading 5
3.1.2 / Identify different operating systems (e.g. Windows, Macintosh OS, Linux, etc.) / Lesson 2 (p. 12); Web Reading 5
3.1.3 / Identify that a computer user may interact with multiple operating systems while performing everyday tasks / Web Reading 5
3.1.4 / Identify the capabilities and limitations imposed by the operating system including levels of user rights (administrative rights, etc.) which determine what a user can and cannot do (install software, download files, change system settings, etc.) / Lessons 2, 4, 5, 12 (pp. 9-16, 34-35, 42-44, 86); Web Reading 5
3.1.5 / Identify and solve common problems related to operating systems / Web Reading 5
Objective 3.2 / Use an operating system to manipulate a computer’s desktop, files and disks
3.2.1 / Shut down, restart, log on and log off the computer / Lesson 2 (pp. 9-10, 15-16)
3.2.2 / Identify elements of the operating system desktop / Lesson 2 (p. 11, 14)
3.2.3 / Manipulate windows (e.g. minimize, maximize, resize) / Lesson 3 (pp. 21-23)
3.2.4 / Start and run programs / Lessons 2 & 3 (pp. 13-14, 18-21); OneNote lessons (on IRCD/Web)
3.2.5 / Manipulate desktop folders and icons/shortcuts / Lesson 2 (pp. 11-15); Chapters 2 & 6 Supplemental Activities (on Web)
3.2.6 / Manage files (e.g. identifying files, folders, directories, moving and retrieving files, display file properties, etc.) / Lessons 5, 6, 7, 8, 9 (pp. 41-46, 47-53, 54-57, 58-63, 64-67)
3.2.7 / Identify precautions one should take when manipulating files including using standardized naming conventions / Lessons 6 & 7 (p.47, 54); Chapter 2 Review (p.69)
3.2.8 / Solve common problems associated with working with files (e.g. incompatibility of application programs, corruption of files, denied access, etc.) / Lesson 3 (p. 20); Web Reading 5
Objective 3.3 / Identify how to change system settings, install and remove software
3.3.1 / Display control panels/system preferences / Lesson 103 (p.581); Web Reading 5; Chapter 1 Supplemental Activity (on Web); PDAs lessons (on IRCD/Web)
3.3.2 / Identify different control panel/system preference settings / PDAs lessons (on IRCD/Web); Web Reading 5
3.3.3 / Change simple settings (e.g. date and time, audio, security, etc.) / PDAs lessons (on IRCD/Web); Web Reading 5
3.3.4 / Display and update a list of installed printers / Web Reading 5
3.3.5 / Identify precautions regarding changing system settings / PDAs lessons (on IRCD/Web); Web Reading 5
3.3.6 / Install and uninstall software including installing updates from online sources / See lesson on PDAs (on Web/IRCD); Web Reading 6
3.3.7 / Identify and troubleshoot common problems associated with installing and running applications / See lesson on PDAs (on Web/IRCD); Web Reading 5
Standard Number / Standard / Lesson Number
Correlation (page #) or Web Reference (www.cengage.com/
school/keyboarding/c21jr)
Module 2: Key Applications
DOMAIN 1.0 / COMMON PROGRAM FUNCTIONS
Objective 1.1 / Be able to start and exit an application, identify and modify interface elements and utilize sources of online help
1.1.1 / Start and stop a Windows application / Lessons 3, 4, 56, 51, 59, 60, 86 (pp. 18-19, 29-30, 200, 212-214, 241, 250, 465)
1.1.2 / Identify on-screen elements common to applications (e.g. menu bar, scroll bar, application window, etc.) / Lessons 3 & 4 (p. 17, 25)
1.1.3 / Navigate around open files / Lesson 3 (pp. 20-21)
1.1.4 / Use, change and change location of onscreen command buttons (toolbar/ribbon) / Lessons 4, 7, 8, 68, 70, 78, 79, 80, 81, 86, 87, 89, 90, 91, 95, 98, 99 (pp. 26-35, 57-61, 63, 335, 354-356, 410-412, 413-418, 419-424, 425-429, 464-465, 468-469, 483, 486, 497-498, 519, 549-565, 554)
1.1.5 / Change views (draft/normal, print-layout/page-layout, etc.) / Lessons 4, 86, 91, 98 (pp. 26, 465-466, 498, 548)
1.1.6 / Change magnification level (zoom) / Lessons 8, 59, 72, 91 (pp. 59-64, 241-242, 365-368, 498)
1.1.7 / Display options for changing application defaults (where files are stored, custom display, print and auto save options, etc.) / Lessons 4, 5, 7, 103, 105 (pp. 27-29, 44-46, 54-57, 581-582, 596-603)
1.1.8 / Identify and prioritize help resources (e.g. online resources, help desk, peers, etc.) / Chapter 3 Review (p. 528); Chapter 1 Supplemental Activity 9 (on Web); Online Resources section (end of each chapter);
1.1.9 / Use automated help (e.g. F1 key, appropriate online resources, etc.) / Lessons 69, 86, 96 (p. 341, 465, 528); Chapter 1 Supplemental Activity (on Web)
Objective 1.2 / Perform common file-management functions
1.2.1 / Create files / Lesson 7 (pp. 54-55); OneNote lessons (on IRCD/Web)
1.2.2 / Open files / Lesson 7 (pp. 56-58); OneNote lessons (on IRCD/Web)
1.2.3 / Switch between open documents / Lesson 8 (pp. 58-60)
1.2.4 / Save files in specified locations/formats (e.g. “Save” vs. “Save As”, saving to directories, saving in a different file format, etc.) / Lessons 7, 59, 60, 70, 86, 91, 97, 99, 103, 104, 105 (pp. 54-58, 245, 249, 354-355, 467, 501, 537-545, 553-554, 581, 591-592, 596-603)
1.2.5 / Close files / Lessons 4 & 59 (p. 26, 242)
1.2.6 / Identify and solve common problems relating to working with files (e.g. unsupported file formats, file corruption, etc.) / Web Reading 6
Objective 1.3 / Perform common editing and formatting functions
1.3.1 / Insert text and numbers into a file / Lessons 4, 58, 65, 74, 91 (pp. 27-28, 226-233, 303, 382-384, 500-501); OneNote lessons (on IRCD/Web)
1.3.2 / Perform simple editing (e.g. cut, copy, move information) / Lessons 8, 11, 71 (pp. 58-59, 85, 361-362); OneNote lessons (on IRCD/Web)
1.3.3 / Use the Undo, Redo and Repeat commands / Lessons 4, 60, 65, 72, 89 (pp. 25, 258, 296-297, 365, 480)
1.3.4 / Find and/or Find and Replace information / Lesson 71 (pp. 363-364); Chapter 11 Supplemental Activity (on Web)
1.3.5 / Check spelling / Lessons 68 & 70 (pp. 333-335, 354)
1.3.6 / Perform simple text formatting (e.g. bold, text effects, etc.) / Lessons 4 & 58 (pp. 30-33, 232-233); Chapter 13 Supplemental Activity (on Web); OneNote lessons (on IRCD/Web)
1.3.7 / Insert pictures and other objects into a file (e.g. clip art, graphic files, text art, etc.) / Lessons 78, 79, 80, 87 (pp. 410-413, 413-418, 419-424, 470-472); Chapter 7 Supplemental Activity (on Web); OneNote lessons (on IRCD/Web)
Objective 1.4 / Perform common printing/outputting functions
1.4.1 / Format a document for printing (e.g. margins, paper size, etc.) / Lessons 66, 67, 68, 92, 95 (pp. 318-324, 325-332, 333-339, 504-506, 520-522)
1.4.2 / Preview a file before printing / Lessons 8, 72, 97 (pp. 60-64, 365-366, 544-546); Chapter 2 Supplemental Activity (on Web)
1.4.3 / Print files, specifying common print options / Lessons 4, 8, 92, 98 (pp. 33-34, 62-64, 504-505, 552)
1.4.4 / Manage printing and print jobs / Web Reading 5
1.4.5 / Identify and solve common problems associated with printing (e.g. printer issues, connection issues, etc.) / Web Reading 5
1.4.6 / Output documents in electronic format (e.g. PDF, fax, email, etc.) / Lesson 72 (pp.365-367)
1.4.7 / Identify issues related to outputting files in electronic format / Web Reading 6
DOMAIN 2.0 / WORD PROCESSING FUNCTIONS
Objective 2.1 / Be able to format text and documents including the ability to use automatic formatting tools
2.1.1 / Change spacing options / Lessons 66, 68, 70, 75, 103 (pp. 318-319, 322-324, 336-339, 353-355, 394, 586)