business institutional (ilo), program (plo), and course (slo ... info...slo #2 cascading style sheet...

Business Institutional (ILO), Program (PLO), and Course (SLO) Alignment

Program: Computer Information Systems Number of Courses:

20

Date Updated

Submitted by Pat Vacca /Jacquie Thompson

ILO Rating Rubric 4 - A major focus of the course. Direct instruction is provided. Students are evaluated multiple times (and possibly in various ways) throughout the course.

3 - An important part of the course. Some direct instruction is provided and students are evaluated on the concepts once or twice within the course.

2- Only a minor focus of the course. Some instruction is given in the area but students are not formally evaluated on the concepts.

1- May be tangentially part of the class, but is not directly taught or evaluated or is not part of the course at all.

Institutional SLOs

I. Content Knowledge

II. Critical, Creative, and Analytical Thinking

III. Communication and Comprehension

IV. Professional and Personal Growth

V. Community and Collaboration

VI. Information and Technology Literacy

Program Rating Rate each from 1-4 based on above rubric

4

4

3

3

4

4

Program Level SLOs

ILOs to PLOs Alignment (Rate 1-4)

I II III IV V VI

PLO #1 Computer Literacy Students will demonstrate their proficiency in computer literacy through performance in laboratory exercises and objective examinations.

4 4 3 4 2 4

PLO #2

PLO #3

Course Level SLOs

Course to Program SLO Alignment

Mark with an X if you will use the course when

assessing your PLO.

ILOs to Course SLOs Alignment

P1 P2 P3 I II III IV V VI

CIS 3 Introduction to Microcomputer and Software Application: SLO#1 Basic windows operations(create a folder; copy, delete, rename a file)

X 4 4 4 4 2 4

SLO #2 Create, save; open, close a word document X 4 4 4 4 2 4

SLO #3 Word editing functions(cut, copy, paste, find/replace, spell check) X 4 4 4 4 2 4

SLO #4 Perform document formatting functions (insert page breaks, sections, word art, clip art X 4 4 4 4 2 4

SLO #5 Add headers, footers X 4 4 4 4 2 4

SLO #6 Create, save, open, close an excel spreadsheet X 4 4 4 4 2 4

SLO #7 Create formulas including absolute cell references

X 4 4 4 4 2 4

SLO #8 Use Min and Max functions

X 4 4 4 4 2 4

SLO #9 Insert/delete rows and columns

X 4 4 4 4 2 4

SLO #10 Create and edit and enhance a column chart

X 4 4 4 4 2 4

CIS 11 Help Desk Operations: SLO #1 Rapport and Trust Identify the communication strategies to build rapport and trust with customers.

X 4 4 4 4 3 3

SLO #2 Impact of Internet and Email Internet and Email Identify the impact of internet and email on the role of Helpdesk analyst.

X 4 4 4 4 2 4

SLO #3 Technical Writing Compare and contrast the characteristics of various types of technical writing skills. X 4 4 4 4 2 4

SLO #4 Managing Knowledge Resources Demonstrate the use of various types of tools used by the companies to manage their knowledge resources. X 4 4 4 4 2 4

SLO #5 Root Cause Analysis Identify the root cause of problems by performing trend and root cause analysis. X 4 4 4 4 2 4

SLO #6 Demanding Customers Demonstrate the use of proven techniques to handle irate, difficult and demanding customers. X 4 4 4 4 2 4

Course Level SLOs



assessing your PLO.



CIS 13 Introduction to Computers: SLO #1 Browsers and Search Engines Given a topic, use an internet browser and multiple search engines to generate appropriate information for a research paper

X 4 4 4 4 2 4

SLO #2 Common Business Software Demonstrate the use of common business software such as word processing, spreadsheets, database manager, and operating system. X 4 4 4 4 2 4

SLO #3 Creating Presentations Using presentation tools to create a presentation following the design and content guidelines X 4 4 4 4 2 4

SLO #4 Hardware Configurations Given user need scenarios, specify various computer hardware configurations, including an explanation of operating system. X 4 4 4 4 2 4

SLO #5 Boolean Logic Operators Given a set of conditions, compare and contrast the effect of Boolean logic operators. X 4 4 4 4 3 3

SLO #6 Risk, Maintenance, and Security Using a computer system as a basis, analyze system risks, perform computer maintenance, and establish computer security. X 4 4 4 4 3 3

SLO #7 Problem Solving Identify various disciplines where computers can be useful in problem solving, information retrieval, control and forecasting. X 4 4 4 4 3 3

SLO #8 Systems and Solutions Given a case study, analyze and design systems and implement solutions. X 4 4 4 4 3 3

SLO #9 Analyzing and Using Systems Given a variety of business scenarios, analyze the use and application of computers in a variety of environments. X 4 4 4 4 3 3

SLO #10 Electronic Communications Given user scenarios for electronic communication identify appropriate hardware and software. X 4 4 4 4 3 3

Course Level SLOs



assessing your PLO.



CIS 16 Introduction to Visual Basic: SLO #1 Creating an Interface Creating an interface with appropriate controls to calculate total price for items purchased. Students will create a user interface. Only relevant controls related to the application are added to the interface. At run time the application prompts the user for the number of items to be purchases. The application returns the subtotal, total, taxes and total.

X 4 4 4 4 4 4

SLO #2

SLO #3

CIS 18 Systems Analysis and Design: SLO #1 Interview Techniques Use effective interview techniques to gain an understanding of the company computer system’s current data inputs, outputs, and processes.

X 4 4 4 2 4 2

SLO #2 Graphical Models Understand how 1) data flow diagrams visually illustrate the way data moves through a company’s information system, and 2) entity-relationship diagrams serve as a graphical model that depict the relationships among the entities of a company’s information system.

X 4 4 4 2 4 2

SLO #3 Logical Design Documents Prepare logical design documentation for a company’s new or modified computer system that includes a systems requirements document and a systems design specification. X 4 4 4 2 4 2

Course Level SLOs



assessing your PLO.



CIS 19 Introduction to the Internet and Web Publishing: SLO #1 HTML Tags Demonstrate an understanding of HTML tags by designing and coding by hand, multiple linked Web pages.

X 4 4 2 2 2 4

SLO #2 Cascading Style Sheet Design and build a Cascading Style Sheet and multiple linked Web pages using the features available in Web authoring software. X 4 4 2 2 2 4

CIS 19 SLO #3

CIS 20 Microsoft Windows: SLO #1 Functions Understand functions of Start menu, Restore Points, and system-level rights of Administrators and Users.

X 4 4 3 4 2 2

SLO #2 Points, Defragging, Cookies, and Users Given an in-class assignment, set and name restore points, defragment a hard drive, delete cookies, and create users accounts. X 4 4 3 4 2 2

SLO #3 Effects of Malware Understand effects of malware and appropriate countermeasures; demonstrate ability to perform backup and restore procedures X 4 4 3 4 2 2

SLO #4 Security Software Given an in-class assignment, download, install, and execute security software. X 4 4 3 4 2 2

SLO #5 Multi-use Environments Demonstrate ability to design multi-user environment, assign rights and privileges, and schedule ongoing system-level maintenance. X 4 4 3 4 2 2

SLO #6 Administrator User Accounts Given an in-class assignment, create Administrator and User accounts, assign and re-assign (modify) rights and privileges. X 4 4 3 4 2 2

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 26 Using Microsoft Excel: SLO #1 Spreadsheets Given an in-class assignment, construct an accurate and complete spreadsheet that demonstrates appropriate formatting and fundamental math calculations.

X 4 4 3 4 2 2

SLO #2 External References Given an in-class assignment, modify an existing spreadsheet to include external references, conditional logic, formulas that reference non-contiguous ranges, and control of row/column sizing. X 4 4 3 4 2 2

SLO #3 Conditional Formatting Given an in-class assignment, modify an existing spreadsheet to include conditional formatting involving mathematical states (positive, negative and zero), and conditional logic involving day and time calculations.

X 4 4 3 4 2 2

SLO #4 Testing for Logic and Errors Given an in-class assignment, modify an existing spreadsheet to include testing for logic, syntactical, and runtime error conditions. X 4 4 3 4 2 2

SLO #5 Spreadsheet Formulas Given an in-class assignment, demonstrate proficiency in array processing of spreadsheet formulas, table structures, and database (“D”) functions. X 4 4 3 4 2 2

SLO #6 Spreadsheet Concepts Demonstrate comprehension of spreadsheet concepts and terminology. X 4 4 3 4 2 2

SLO #7 Spreadsheet Formulas, Functions and Formatting Demonstrate comprehension of spreadsheet formulas, functions, internal and external referencing, range naming, charting, absolute and relative referencing, and conditional formatting.

X 4 4 3 4 2 2

SLO #8 Multi-dimensional Table Structures Demonstrate comprehension of multi-dimensional table structures, basic macro construction, and consolidations by name and by position. X 4 4 3 4 2 2

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 27 Using Spreadsheet Macros: SLO #1 Decision Support Tools Given an in-class assignment, construct accurate and complete spreadsheets that that utilize Decision Support Tools, what-ifs, the Scenario Manager, and Regression Analysis.

X 4 4 3 4 2 2

SLO #2 Utilizing Lists Functions and Data Scrubbing Given an in-class assignment, construct accurate and complete spreadsheets that utilize Lists, Text functions, and Data Scrubbing. X 4 4 3 4 2 2

SLO #3 Pivot Tables and Charts Given an in-class assignment, construct accurate and complete spreadsheets that utilize Pivot Tables and Pivot Charts. X 4 4 3 4 2 2

SLO #4 Atypical Charts Given an in-class assignment, construct accurate and complete spreadsheets that display atypical charts to include radar, surface, and doughnut; understand values in formulas taken to nth power. X 4 4 3 4 2 2

SLO #5 Radar, Surface, Doughnut, Tables and Charts Understand Text functions, Data Scrubbing, atypical charts to include radar, surface, and doughnut, Pivot Tables and Pivot Charts. X 4 4 3 4 2 2

SLO #6 Error Correction in Finance and Databases Given an in-class assignment, construct an accurate and complete spreadsheet that utilizes Error Correction, and advanced functions in the categories of Finance and Databases

X 4 4 3 4 2 2

SLO #7 Utilizing Advanced Functions Given an in-class assignment, construct an accurate and complete spreadsheet that utilizes advanced functions in the categories of Date and Time, Statistics, Math & Trig, Engineering, Lookups, Information, and Text.

X 4 4 3 4 2 2

SLO #8 Understanding Advanced Functions Understand Error Correction, Advanced Functions in Finance and Databases, Advanced Functions in the categories of Date and Time, Statistics, Math & Trig, Engineering, Lookups, Information, and Text.

X 4 4 3 4 2 2

Course Level SLOs



assessing your PLO.


(Rate 1-4)


SLO #9 Structure and Purpose of VBA Given an in-class assignment, construct accurate and complete spreadsheets that demonstrate the structure and purpose of VBA. X 4 4 3 4 2 2

SLO #10 Custom VBA Functions Given an in-class assignment, construct accurate and complete spreadsheets that employ custom VBA functions. X 4 4 3 4 2 2

SLO #11 Constructing VBA Forms Given an in-class assignment, construct VBA forms that collect, store, and calculate values.. X 4 4 3 4 2 2

SLO #12 Constructing VBA Modules –Variable Events Given an in-class assignment, construct VBA modules which collect and pass variables, define ranges, and execute subroutines based on variable events X 4 4 3 4 2 2

SLO #13 VBA Module Between Subroutines Given an in-class assignment, construct VBA modules that execute a defined number of loops and pass arguments between subroutines. X 4 4 3 4 2 2

SLO#14 Structure and Purpose of VBA Understand the structure and purpose of VBA, custom functions, forms, the collection and passing of variables, defining ranges, the execution of subroutines based on variable events, and looping.

X 4 4 3 4 2 2

CIS 28 Database Management Using Microsoft Access: SLO #1 Concepts and Terms 1Understand database concept and terminology X 4 4 3 4 2 2

SLO #2 Table Structures Design, create, and modify table structure X 4 4 3 4 2 2

SLO #3 Table Relationships Create, document, and delete table relationships X 4 4 3 4 2 2

SLO #4 Modify tables to include default values, validation rules, input masks, and indices X 4 4 3 4 2 2

Course Level SLOs



assessing your PLO.


(Rate 1-4)


SLO #5 Adding Records Add new records to a table X 4 4 3 4 2 2

SLO #6 Queries Create single-table and multi-table queries X 4 4 3 4 2 2

SLO #7 Use queries to perform calculations on data contained in tables. X 4 4 3 4 2 2

SLO #8 Creating Forms Create forms for viewing, entering, and editing data. X 4 4 3 4 2 2

SLO #9 Summarizing and Grouping Information Present data from tables by creating reports that summarize and group information. X 4 4 3 4 2 2

SLO #10 Mailing Labels Create mailing labels. X 4 4 3 4 2 2

SLO #11 Command Buttons Utilize command buttons and macros. X 4 4 3 4 2 2

CIS 29 Advanced Database Applications: SLO #1 Filtering and Queries Use filtering and queries to select data from a database X 4 4 4 4 2 2

SLO #2 Complex Queries Create and modify complex, multi-table and crosstab queries X 4 4 4 4 2 2

SLO #3 Forms Create and customize forms X 4 4 4 4 2 2

SLO #4 Modifying Forms Create and modify simple and complex forms X 4 4 4 4 2 2

SLO #5 Tables Import and export tables X 4 4 4 4 2 2

SLO #6 Running MACROS Create and run MACROS X 4 4 4 4 2 2

SLO #7 Using Access Design and develop a working database using Access X 4 4 4 4 2 2

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 30 Introduction to eCommerce: SLO #1 e-Business Plan By the end of the course, students will develop and present a Business plan for an Ecommerce Company with the functionality of selling goods or services

X 4 4 4 4 3 3

CIS 40 Personal Computer Operations: SLO #1 Operational Concepts Examine the basic operational concepts of microcomputers. X 4 4 3 4 3 3

SLO #2 Hardware Components Inspect various hardware components of a microcomputer and assess how these components, such as motherboards, disk drives, i/o devices, printers, modems, network cards, zip drives, flash drives, and mice, function.

X 4 4 3 4 3 3

SLO #3 Terminology Examine operating systems terminology and technologies as they apply to microcomputers. X 4 4 3 4 3 3

SLO #4 PC Boot Problems Students will be able to solve a PC boot problem, given a set of circumstances that occur once the power button is pressed. Using a BIOS software troubleshooting flowchart, they will be able to determine which BIOS process is causing the failure.

X 4 4 3 4 3 3

SLO #5 Team Work on a Virtual Machine Working in teams, students will be able to create a virtual machine on a windows operating system, and install the prior release of the windows operating system in the virtual machine. They will install the operating system, service packs, video and audio drivers, and configure the virtual machine to share hardware resources, such as CD/DVD drives. They will install an audio program such as iTunes and verify that the audio drivers work properly in the virtual machine.

X 4 4 3 4 3 3

SLO #6 Ethics and Responsibility Examine the ethical responsibilities and concerns that confront microcomputer operations X 4 4 3 4 3 3

SLO #7 Application Software Install and configure application software such as spreadsheet, data base, word processing, and utility programs used for diagnostic evaluation. X 4 4 3 4 3 3

SLO #8 Managing Microcomputers Create the requirements necessary to manage an organization’s microcomputers X 4 4 3 4 3 3

SLO #9 Evaluating Hardware, Systems and Applications Demonstrate the ability to evaluate hardware, operating systems, and applications software in relation to installing and configuring software. X 4 4 3 4 3 3

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 80 Oracle Application Programming: SLO #1 Tables and Relationships Design and develop tables and relationships for common business problems X 4 4 3 4 2 2

SLO #2 Tables Create and process tables X 4 4 3 4 2 2

SLO #3 Solving Common Business Problems Solve common business oriented problems by using an application programming language to access database for answers to common business queries X 4 4 3 4 2 2

SLO #4 Conditional Statements Develop conditional statements and multiple level “if” statements to query database tables X 4 4 3 4 2 2

SLO #5 Program Code Write programming code to manipulate database tables X 4 4 3 4 2 2

SLO #6 Efficient Programming Techniques Demonstrate use of efficient programming techniques. X 4 4 3 4 2 2

CIS 133 Mashup JavaScript, jQuery and AJAX: SLO #1 e-commerce Website The student will demonstrate the ability to create an e-commerce website by using a web development process including design, planning, coding, and testing. The website is limited to client-side development.

X 4 4 4 4 2 2

SLO #2

SLO #3

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 134 ASP.NET with C# Business Web Programming: SLO #1 Website Using ASP.NET and C# The student will demonstrate the ability to create an e-commerce website using ASP.NET and C#.

X 4 4 4 4 4 4

CIS 140 Data Communications Cisco 1: SLO #1 Data Communication Terms Describe and explain data communication terms such as broadband and baseband communications

X 4 4 4 4 2 4

SLO #2 Modulation Techniques Describe and use different modulation techniques such as time-division and frequency division. X 4 4 4 4 2 4

SLO #3 Network Systems Analyze and design network systems using differing transmission methods such as copper wire, fiber optics, microwave and satellite. X 4 4 4 4 2 4

SLO #4 Communications with the Internet Use microcomputer hardware and software to facilitate communications with the Internet. X 4 4 4 4 2 4

SLO #5 Hardware and Data Communications Describe how microcomputer hardware relates to data communications. X 4 4 4 4 2 4

SLO #6 Local and Wide Area Networks Describe and define the similarities and differences between local area and wide area networks. X 4 4 4 4 2 4

SLO #7 Security Issues Analyze security issues such as protections, detection and correction. X 4 4 4 4 2 4

SLO #8 Ethical Considerations Identify ethical considerations such as privacy, hacking, and piracy. X 4 4 4 4 2 4

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 141 Networking Microcomputers Cisco 2: SLO #1 Connection and Connection-less Oriented Networks Describe connection-oriented network services and connectionless- oriented network services and identify their key differences.

X 4 4 4 4 2 4

SLO #2 Basic Methods Define flow control and describe the three basic methods used in connection oriented networking. X 4 4 4 4 2 4

SLO #3 Functions of the TCP/IP Identify the functions of the TCP/IP transport-layer protocols. X 4 4 4 4 2 4

SLO #4 Comparing Protocols Compare TCP/IP protocols to the ISO reference model layer four. X 4 4 4 4 2 4

SLO #5 ICMP Functions Identify the functions performed by ICMP. X 4 4 4 4 2 4

SLO #6 Routing Type Problems List problems that each routing type encounters when dealing with topology changes, and describe techniques used to reduce the number of these problems. X 4 4 4 4 2 4

CIS 142 Implementing and Administering Network Routers Cisco 3 SLO #1 Router Components Identify router components such as Ethernet and Serial Interfaces, Console and Auxiliary ports, Ram, NVRam, and Rom memory

X 4 4 4 4 2 4

SLO #2 Router Hardware Configuration Create valid router hardware configurations using proper router protocols, IP addressing, interface addressing, and network address identification. X 4 4 4 4 2 4

SLO #3 Router Design of LANs and WANs Install and configure routers for design of LANs and WANs. X 4 4 4 4 2 4

SLO #4 Periodic Maintenance Perform periodic maintenance on routers by logging into the console port and testing IOS, the configuration file, and the status of each interface X 4 4 4 4 2 4

SLO #5 Troubleshooting Troubleshoot malfunctioning routers by examining the status of the POST test, the interface status, the IP status, and the status of the time-to-live facility. X 4 4 4 4 2 4

SLO #6 New Version of Cisco Download and install a new version of the Cisco Internetworking Operating system software. X 4 4 4 4 2 4

Course Level SLOs



assessing your PLO.


(Rate 1-4)


CIS 143 LAN and WAN Router Configurations Cisco 4: SLO #1 Internet Working Modules Define and discuss internetworking models. X 4 4 4 4 2 4

SLO #2 Paths for Internetworking Determine appropriate paths for internetworking X 4 4 4 4 2 4

SLO #3 User Interfaces Install user interfaces. X 4 4 4 4 2 4

SLO #4 Router Issues List basic router issues. X 4 4 4 4 2 4

SLO #5 Configuring Routers Configure hardware and software for routers to use both LAN and WAN protocols. X 4 4 4 4 2 4

SLO #6 Configuring Protocols Configure TCP/IP and AppleTalk protocols. X 4 4 4 4 2 4

SLO #7 Traffic and Access Lists Manage traffic with access lists. X 4 4 4 4 2 4

SLO #8 Serial Connections Describe serial connections for wide area networking. X 4 4 4 4 2 4

SLO #9 Router Configurations Auto install router configurations. X 4 4 4 4 2 4