||A+ Comp Tech Certification
CNT 110. A+ Computer Technician Certification (4). Install, configure, support, and troubleshoot personal computers. Emphasis on PC hardware, and installation, operation, and upgrade procedures. Focus on practical networking in a PC environment along with server hardware maintenance and troubleshooting. Preparation for the Comp TIA A+ Certification exam. This course, with CNT 120, prepares the learner for the Comp/TIA Server+ Certification Exam. Preparedness Recommendations: Experience using a computer keyboard and accessing the Internet with a web browser. Three lecture. Three lab.
1. Information Technology (IT) basics
2. How Computers Work
3. Assembling a Computer
4. Troubleshooting PC Hardware
5. Preventive Maintenance
6. Operating System Fundamentals
7. Troubleshooting Software and Operating Systems
8. Multimedia Capabilities
9. Printers and Printing
10. Hardware Fundamentals for Servers
11. Networking Fundamentals
1. Discuss the fundamentals of information technology (IT) and identify major IT components in a PC environment.
2. Install, configure, and upgrade PC hardware components, PC peripherals, and PC firmware.
3. Diagnose and troubleshoot a variety of PC hardware and peripheral component problems.
4. Identify and avoid potential safety hazards while working with PCs.
5. Identify PC components related to the PC motherboard, processors, and memory modules.
6. Implement preventive maintenance procedures.
7. Utilize common PC operating systems and discuss their operation.
8. Diagnose and troubleshoot PC software and operating systems problems.
9. Work with multimedia components in a PC environment.
10. Describe the printing process and identify printer components for a variety of printing technologies.
11. Implement care and maintenance procedures for printers.
12. Compare and contrast server hardware requirements versus PC hardware requirements.
13. Describe redundant disk configurations.
14. Configure and upgrade major server components.
15. Describe basic networking concepts including topologies, protocols, and network components.
16. Install and configure network cards and identify network media types.
17. Identify the causes of common network problems.
1. Cisco Academy on-line chapter exams and final exam. Cisco Academy skills final exam.
||Intro to Windows Server
CNT 120. Introduction to Windows Server (3). Introduction to the Windows Server line of network operating systems. Topics include installation, file systems, networking, directory services, file and printer sharing, and security. Extensive hands-on exercises with realistic scenarios to help students apply new concepts and sharpen problem-solving skills. Two lecture. Three lab.
1. Windows Server products and requirements
2. Windows Server installation
3. Server environment
4. Directory services
5. Resource access
7. Data storage
9. Remote access
1. Describe the Windows Server family of products and define system requirements for each. (1)
2. Install Windows Server and describe the options and requirements for installing Windows Server. (2)
3. Configure the server environment. (3)
4. Install and configure Windows directory services. (4)
5. Manage access to resources. (5)
6. Configure printing services. (6)
7. Manage and configure data storage. (7)
8. Configure and troubleshoot Windows network protocols and services. (8)
9. Configure remote access services. (9)
10. Configure security protocols. (10)
1. Cisco Academy on-line chapter exams and final exam. Cisco Academy skills final exam.
||Windows Client Operating Systm
CNT 121. Windows Client Operating System (3). A thorough examination of the Microsoft Windows client operating system. Installation, management, and support of the Windows client operating systems in a network environment. Includes advanced topics such as disk management, secure network configuration, disaster recovery, and performance tuning. Preparation for the Microsoft Windows MCTS certification exam. Prerequisite: CNT 100 or CNT 115 or CNT 120. Two lecture. Three lab.
1. Windows client operating system
2. Installing Windows
3. System utilities
4. Disk and file system management
5. User management
6. Windows security features
8. Remote access
9. User productivity and media tools
10. Performance tuning
11. Application support
12. Disaster recovery and troubleshooting
13. Enterprise computing
1. Describe the Windows client family of products and define their system requirements. (1)
2. Perform a Windows installation and describe options and requirements for installation. (2)
3. Use Windows system utilities. (3)
4. Manage disks and describe storage technologies. (4)
5. Manage Windows file systems. (4)
6. Work with user accounts and profiles. (5)
7. Describe and implement Windows security features. (6)
8. Configure and troubleshoot Windows network protocols and services. (7)
9. Evaluate methods and configure protocols for remote access. (8)
10. Configure Windows printing and user productivity tools. (9)
11. Use Windows performance management utilities for monitoring and baseline logging. (10)
12. Utilize Windows application management facilities. (11)
13. Troubleshoot Windows configurations and use disaster recovery tools. (12)
14. Configure and manage a Windows client in an enterprise network environment. (13)
CSA 126. Microsoft Office (3). Introductory concepts and techniques of Microsoft Office including Word, Excel, Access, PowerPoint, and Outlook. Two lecture. Three lab.
1. Introduction to Microsoft Office
2. Microsoft Word for Windows
3. Microsoft Excel for Windows
4. Microsoft Access for Windows
5. Microsoft PowerPoint for Windows
6. Microsoft Outlook for Windows
7. Microsoft Office Final Integration Project
1. Enter text into a document, save, retrieve, re-save, and print.
2. Format documents: alignment, margins, line spacing, font size, font face, italics, bold, underline, color, and Format Painter.
3. Insert and manipulate graphics and symbols in documents.
4. Describe the MLA documentation style for research papers.
5. Modify a style.
6. Add footnotes to a document.
7. Use Microsoft Word?s Auto Correct, Thesaurus, Find & Replace, and Sort features.
8. Create a hyperlink and convert a hyperlink to regular text.
9. Create a resume using Microsoft Word?s Resume Wizard.
10. Identify the components of a business letter.
11. Create and insert an Auto Text entry.
12. Create and enter data into a Microsoft Word table.
13. Create bulleted lists.
14. Address and print an envelope.
15. Enter text, numbers, and formulas in an Excel Worksheet, save, and print.
16. Copy a cell to a range of cells using the fill handle and apply the AutoFormat command to format a range.
17. Create Column and Pie charts using the Chart Wizard.
18. Use the AutoCalculate area to determine totals.
19. Enter formulas using both the keyboard and point methods, and verify a formula using Range Finder.
20. Apply the AVERAGE, MAX, AND MIN FUNCTIONS, and determine percentage.
21. Format cells and ranges of cells by changing the font, coloring the characters and background, aligning text, adding borders, formatting numbers using the Format Cells dialog box, and adding conditional formatting.
22. Rotate text in a cell.
23. Insert and delete cells, add a drop shadow to a range of cells, and use the Format Painter tool to format cells.
24. Use absolute cell references in a formula, copy absolute cell references, and use the IF function to perform a logical test.
25. Create a 3-D Pie chart on a separate chart sheet.
26. Rearrange sheets in a workbook.
27. Describe databases and database management systems.
28. Create a database.
29. Create a table, define the fields in a table, add records to a table, and print the contents of a table.
30. Create a custom report and print.
31. State the purpose of queries.
32. Create a new query, run a query, print the answer to a query, use a query to display selected fields, save a query, and clear a query grid.
33. Create, edit, save, and run a PowerPoint presentation using a design template and text slide layout.
34. Print a PowerPoint presentation as handouts and as handouts with notes.
35. Create a PowerPoint presentation from an outline.
36. Create text slides with multi-level bulleted lists.
37. Insert &manipulate graphics (clip art and photos).
38. Add a header and footer to slides.
39. Add animation to a PowerPoint presentation (text and graphics).
40. E-mail a slide show from within PowerPoint.
41. Create personal subfolders in Outlook
42. Create a calendar in Outlook with one-time and recurring appointments.
43. Move and edit appointments in Outlook.
44. Create an event in Outlook.
45. Create and print a task list in Outlook.
46. Create and print a contact list in Outlook.
47. Import and export personal subfolders in Outlook.
48. Delete personal subfolders from the hard disk in Outlook.
49. Add hyperlinks to a Microsoft Word document and a Power Point slide.
50. Integrate Microsoft Office applications to create and publish a Web site.
51. Use a Web query to get real-time data from a Web site.
52. Embed an Excel chart into a Microsoft Word document and publish it on the Web.
53. Add scrolling text to a Web page created in Microsoft Word.
CSA 170. PC Architecture (3) (Spring). Introduction to hardware components of a microcomputer. Emphasis on equipment comparisons, hardware requirements, and operating systems. Two lecture. Three lab.
1. Microcomputer bus design
2. A history of CPU development
3. Input-output ports
5. Operating systems
6. Hard disk capacity requirements
7. Special multimedia hardware requirements
8. Networking requirements of the PC
9. Requirements studies
10. Cost effectiveness analysis
1. Describe the different types of bus design.
2. Identify the types of memory chips.
3. Describe the organization and structure of the operating system.
4. Describe the minimum hardware requirements for an operating system.
5. Select an optimal multimedia system.
6. Evaluate the hardware requirements for networking a PC.
7. Perform a requirements study and select a cost effective computer system.
CSA 172. Microsoft Windows (2). Personal computer operations using the Microsoft Windows operating environment. Customizing, optimizing and maintenance of desktops, folders, and documents. One lecture. Two lab.
1. Introduction to personal computers and operating systems
2. Window components
3. The Start button
4. My Computer and Help
5. File, document and folder naming conventions
6. Creating documents
7. Modifying and editing documents
8. Printing documents and using the Managing the Print queue and spool
9. Using the taskbar
10. Working with multiple windows
11. Cutting, copying and pasting
12. Object moving, copying and shortcuts
13. Sorting and finding documents
14. Using the Recycle Bin
15. Using system tools such as defrag and scandisk
16. Explorer Window
17. System shut down
1. Identify fundamental personal computing concepts and terminology.
2. Identify components of the Windows screen; select items with the mouse pointer; access Windows features by using the Start button; and work with windows by using buttons and dragging techniques.
3. Observe the contents of a disk by using the My Computer icon; and access a disk quickly by creating a desktop shortcut.
4. Work with multiple programs by using the taskbar to switch between windows.
5. Share data between applications using the Edit Copy and Edit Paste commands.
6. Display the contents of a disk by using the Windows Explorer; create a folder by using a shortcut menu; copy and move documents and folders by dragging them; and sort and locate documents.
7. Prepare a disk for use with the Format command; copy and move groups of documents; delete and restore documents by using the Recycle Bin; and exit Windows.
8. Create a custom user interface by changing properties of the taskbar, the desktop, and other components.
9. Create subfolders and modify file attributes.
10. Manipulate the print queue; set up a printer to print.
CSA 201. Software Maintenance and Troubleshooting (3). Differentiating between hardware and software errors. Diagnosing and correcting software problems that are interfering with the operation of the computer. Prerequisite: CSA 172. Two lecture. Three lab.
1. Windows 95 review
2. Registration database and misregistered extensions
3. Protection fault errors
4. Utilities programs
5. Scandisk, defrag, tmp files, and general file housekeeping
6. Driver problems
7. Hardware problems
8. Resolving conflicts in poorly written software
9. Formatting the hard drive
10. Hardware resource conflicts with IRQs, DMAs and ports
11. Multimedia problems
1. Differentiate between hardware and software errors.
2. Determine if the operating system needs to be reinstalled and perform the installation as needed.
3. Repair malfunctions of the registration database.
4. Use the Regedit utility program when working on the registration database.
5. Use scandisk and defrag to fix problems.
6. Differentiate between application problems and operating system problems.
7. Install or reinstall application software.
CSA 282. Microcomputer Databases (3). Concepts, design, implementation, evaluation, and maintenance techniques of databases. Includes fundamentals of data model, data structure and data management. Two lecture. Three lab.
1. Database concepts
2. Data models
3. Data definition
4. Manipulation of the database
5. Normalization of relations (tables)
6. Relational database design
7. Building a table
8. Building a query
9. Building and customizing a form
10. Building and customizing a report
11. Use of macros
12. Building of an application
1. Analyze, define, and design a relational database.
2. Construct an application using a relational database program complete with
menus, reports, forms, and queries.
3. Update the database.
||Internship: Computer Systems
CSA 296. Internship: Computer Systems and Applications (3). Supervised field experience with businesses, corporations, government agencies, schools and community organizations to expand career interests and apply subject knowledge relevant to the workplace. Individualized internship placements to develop personal and professional skills, including professional ethics, leadership, and civic responsibility. Prerequisite: Student must have a GPA of 2.0; have completed specific degree requirements as required by the program; and have completed the internship application process. [Repeatable for a total of 6 credit hours towards degree/certificate requirements.] S/U grading only.
1. Organizational overview of assigned placement
2. Integration of job description and organization's requirements
3. Elements of documentation of experience
4. Planning and time management
5. Professional, legal, and ethical issues
6. Communication, critical thinking, and problem solving
7. Specialized equipment, tools, and software required in the placement
1. Exhibit appropriate workplace behaviors and professional ethics.
2. Apply discipline specific knowledge and skills in the professional workplace.
3. Define and utilize technical terms in written and oral communications.
4. Use critical thinking, problem solving, ethical awareness, and effective writing
5. Interpret written and oral instructions.
6. Initiate and complete assigned responsibilities.
7. Maintain documentation required to comply with government employer or nonprofit agency regulations.
8. Use specialized equipment, software, and tools as required.
9. Analyze and interpret data for specified reports.
10. Identify opportunities for improvement in process and documentation related to the workplace.
11. Articulate job description and position in assigned organization.
1. Record of Student Internship workplace hours.
2. Individual Education Plan (IEP) as approved by supervision faculty.
3. A daily journal, or work log of tasks, including dates, descriptive comments, problems and solutions.
4. A reflective paper or project as specified by the supervision faculty.
5. A minimum of two evaluations by the workplace employer or supervisor.
6. Student's self-evaluation of experience.