•  

     

    This class runs during RVCC's Spring 2018 Semester and SHS's 3rd and 4th Marking Periods for 2017-18.

     See Google Classroom for the most current information, updates, assignments, etc...
     
    Diane Bolger- Business Education
     
     

    Welcome to SALA Computer Literacy

     

    RARITAN VALLEY COMMUNITY COLLEGE

     

    CISY 102 COMPUTER LITERACY

     

     

     

    This introductory course focuses on how productivity software (word processing, spreadsheet, presentation, and database management) can be used efficiently and effectively to gather, analyze, organize, and present information. The social, ethical, and privacy related aspects of computing are deliberated. Students will also learn how to develop effective online research techniques and will develop the skills required to successfully purchase a personal computer.

     
     

    The skills acquired in this course will be valuable throughout a student’s college career due to its emphasis on using word processing tools to type and format a research paper as well as how to utilize multimedia software to enhance an oral presentation.

     

     

     

     

     

    Course Outline

     

     

    A. Microsoft Operating System
     

    1. Using Windows Explorer

     

    2. Performing Commands from a Dialog Box

     

    3. Creating Folders

     

    4. Saving Files

     

    5. Adding Document Properties

     

    6. Compressing Files

     

    B. Microsoft Word

     

    1. Creating/Editing/Saving/Printing Documents

     

    2. Inserting Objects into Documents

     

    3. Bulleted Lists

     

    4. Tab Stops

     

    5. Adding/Editing/Formatting Tables

     

    6. Proofreading

     

    7. Document Templates

     

    8. Research Papers with Footnotes and Citations

     

    9. Multiple Column Newsletters

     

    10. Mail Merge

     

    C. Microsoft Excel

     

    1. Creating/Editing/Saving/Printing Excel Worksheets

     

    2. Formulas and Functions

     

    3. Formatting Cells

     

    4. Charting

     

    5. Filtering and Sorting

     

    6. Clear Contents/Formatting

     

    7. Goal Seek/What-if Analysis

     

    D. Microsoft Access

     

    1. Creating Table Relationships

     

    2. Sorting Table Records

     

    3. Creating/Editing/Running Queries

     

    4. Creating/Editing Forms

     

    5. Creating Reports Using Report Tool

     

    6. Modifying/Printing Reports

     

    E. Microsoft PowerPoint

     

    1. Creating/Editing/Printing Presentation

     

    2. Slide Transitions/Animation

     

    3. Clip Art

     

    4. Bulleted Lists

     

    5. Adding Objects

     

    6. Backgrounds/Themes

     

    7. Adding Tables/Charts

     

    F. Computer Concepts

     

    1. Basic Computer Hardware

     

    a. Input/Output/Storage Devices

     

    b. Connecting Peripherals

     

    2. Utilizing Internet Resources

     

    a. Email

     

    b. Blogs

     

    c. Wikis

     

    d. Podcasts/Webcasts

     

    e. E-Commerce Safeguards

     

    f. Effective Web Searching

     

    g. Client/Server Architecture

     

    h. Connecting to the Internet

     

    3. Information Technology Ethics

     

    4. Application Software

     

    a. Productivity Software

     

    b. Business Software

     

    c. Buying/Installing/Uninstalling Software

     

    5. System Software

     

    a. Operating System Functions

     

    b. Boot Process

     

    c. File Management

     

    d. Utility Software

     

    6. Computing Alternatives

     

    7. Evaluating Computer Systems

     

    a. RAM

     

    b. Hard Drive

     

    c. Video Cards

     

    d. Sound Cards

     

    8. Fundamentals of Computer Networks

     

    a. Network Architectures

     

    b. Network Components

     

    c. Peer to Peer Networks

     

    d. Installing/Securing Wireless Networks

     

    9. Managing Digital Data and Devices

     

    a. VoIP

     

    b. Cell Phone Security

     

    c. Digital Media

     

    d. Ubiquitous Computing

     

    10. Securing Computer Systems

     

    a. Viruses

     

    b. Hacking

     

    c. Firewalls

     

    d. Malware, Spyware, Adware

     

    e. Spam

     

    f. Cookies

     

    g. Data Backup

     

    h. Social Engineering

     

    11. Careers in Information Technology

     

     

     

    Educational Goals

     
     
    Students will:
     

    1. Be able to use productivity tools including word processing, spreadsheet, database, and multimedia presentation software to perform a task.

     

    2. Utilize spreadsheets/database queries to efficiently solve relevant quantitative problems.

     

    3. Evaluate the importance of ethics to the field of personal computing

     

    4. Student will utilize various databases to locate relevant information on a variety of topics

     

     

     

    Learning Outcomes

     
    Students will be able to:
     

    1. Create/edit word processing documents containing clip art and tables.

     

    2. Create/edit spreadsheets containing formulas and functions.

     

    3. Run queries to elicit relevant information from a database.

     

    4. Design/edit a multimedia presentation replete with graphics/transitions/tables/audio.

     

    5. Determine if a computer system is secure

     

    6. Differentiate between authentic and inauthentic electronic communication.

     

    7. Analyze ethical issues in a variety of computer related situations.

     

     

     

     

    Assessments
     
    • 30% daily laboratory products (Word processing documents, spreadsheets, databases, multimedia presentations) 
    • 15% demonstration workplace readiness
    • 15% marking period /project
    • 40% tests/quizzes/mini projects
     

     

     

    Texts

     

     

    • See Google Classroom for the latest information, updates, assignments, etc....