CCOG for CIS 120 Fall 2024


Course Number:
CIS 120
Course Title:
Digital Literacy
Credit Hours:
4
Lecture Hours:
30
Lecture/Lab Hours:
0
Lab Hours:
30

Course Description

Covers computer concepts and the use of information technology in organizations. Includes the basics of Windows Operating System and Microsoft Office Suite as applied to basic uses of word processing, spreadsheets, databases, and presentation software, and file and folder management. Introduces hardware, software, and tools that businesses use for communication and collaboration. Includes the concepts of ethical conduct in a business/computer environment and the impact of technology on industry and society. Recommended: keyboarding by touch. Audit available. Prerequisites: WR 115, RD 115 and MTH 20 or equivalent placement test scores.

Intended Outcomes for the course

Upon completion of the course students should be able to:

  1. Solve basic information systems problems using MS Office products appropriate for the solution.
  2. Communicate in a business environment using the MS Office product appropriate for the communication.
  3. Use computing technology ethically, safely, securely, and legally. 
  4. Describe and analyze computer hardware, software, and the internet.
  5. Use file management techniques for file and directory/folder organization.

Course Activities and Design

Coaching

Individual reading assignments   

Lecture or mini lecture    

Comparisons among MS Office Suite’s software versus Google-docs or Libre Office

Small and large group discussions    

Videos    

Think-Pair-Share Presentations    

Online learning activities   

Hour of Code     

Collaborative groups    

Review of difficult concepts    

Presentation of exemplar works   

Service Learning-optional   

Outcome Assessment Strategies

  1. Performance tests
  2. Objective tests
  3. Projects
  4. Presentations
  5. Assignments
  6. Participation

Course Content (Themes, Concepts, Issues and Skills)

Savvy Computer Technology Consumer:Survival Tips

  1. Have trouble-shooting techniques, e.g., screen captures or snipping tools, and why re-boot (re-starting) the computer can help resolve malfunctions, how to research solutions, using “help” function and “Task Manager”
  2. Evaluate purchasing considerations when buying a computer, tablet or notebook
  3. Distinguish between the operating systems and software application
  4. Acquaint students with issues related to Security, Netiquette and Ethics

File & Folder Management

  1. Apply integration of the Office Suite and associated file-management
  2. Create, edit, save, retrieve, re-name, move, delete, and organize files and folders and apply organizational strategies
  3. Create zip-files
  4. Assess when a pdf-format is the preferable format

MS Word - Basic Word Processing

  1. Create, edit, save, retrieve and print MS Word documents
  2. Apply tools to create accessibility
  3. Use formatting tools for a single or multiple page(s), a paragraph and fonts and to adjust a document’s appearance to achieve professional quality documents
  4. Insert citations, bibliographies, footnotes/end notes, table of contents, headers/footers, and page numbering
  5. Make tables
  6. Use bulleted lists
  7. Insert and manipulate images, clip art, other graphics

MS Excel - Basic Spreadsheet

  1. Create, edit, save, retrieve and print MS Excel documents
  2. Apply tools to create accessibility
  3. Create formulas using absolute and relative references; if and average functions; AutoSum, and grand total
  4. Understanding data types (such as strings, numbers, date and time)
  5. Develop decision-making skills to do what-if analysis
  6. Name sheets and defined ranges, freeze columns and rows, and use formula view
  7. Develop skills in managing multiple-sheet worksheets
  8. Size and show/hide rows and columns
  9. Apply sort and filter features to a list
  10. Use importing and exporting functions
  11. Generate pie and column charts by using the chart wizard
  12. Format readable and printable worksheets and cells
  13. Use templates

MS PowerPoint - Basic Presentation

  1. Create, edit, save, and retrieve MS PowerPoint documents
  2. Apply tools to create accessibility
  3. Create multiple slides and manipulate them into one presentation
  4. Apply designs, formats, layouts, transitions, and animations
  5. Use or print views, such as:   normal, slide master, outline, slide sorter, slide show, handouts and notes
  6. Format lists, bullets and fonts
  7. Insert and manipulate clip art, other graphics  
  8. Assess the presentation for accuracy, readability, appearance, and consistency
  9. Identify the audience’s needs and the presentation’s likelihood to achieve its goal

MS Access - Basic Relational Database

  1. Edit, save, and retrieve MS Access databases
  2. Enter data into tables
  3. Create basic queries and reports
  4. Use help features

Related Instruction

Computation
Hours: 20

  • Identify and analyze computer hardware, software and network components
  • Install, configure and remove software and hardware
  • Solve basic information systems problems by applying systems development, word-processing, spreadsheet and presentation software techniques
  • Apply standard statistical inference procedures to draw conclusions from data
  • Retrieve information and create reports from relational databases. 
  • Make intelligent purchase decisions
  • Analyze compression techniques and file formats to determine effective ways of securing, managing and transferring data.

Direct instruction (+ study time) in discipline-related computations including:

  • Calculating numeric conversions between binary, decimal and
    hexadecimal base numbers related to memory addresses, memory
    data type representation and media size specifications.
  • Using and following standard statistical procedures.
  • Solving problems using databases.
  • Estimating compression rates, storage capacity, bandwidth, and bus speed.