Portland Community College | Portland, Oregon

zyBooks

Every week there will be reading and exercises in zyBooks to complete. These will be worth 10 points per module. These replace quizzes and exams.

Learning Outcomes

On completion of this course the student should be able to:

• Apply logic, business rules and entity relationship diagrams to design databases.
• Create web sites using latest HTML and CSS standards.
• Design a basic home wireless network and office network while utilizing current wireless security.
• Solve simple quantitative and qualitative problems using computer programming.
• Install and manage operating systems and applications.
• Weigh security issues related to technology including viruses and spyware.
• Identify ethical issues relating to the IT professional.

Covers evaluation, selection and application of computer technology to solve practical problems in database design, web page design, networking and programming. Addresses ethical issues associated with technology. Prerequisites: WR 115, RD 115 and MTH 20 or equivalent placement test scores.

Required Hardware

A microphone or webcam is required for an assignment and the presentation

Required Textbook

Sign in or create an account at learn.zybooks.com

Required Software

PC Users - Windows 7 or higher (available through Azure Dev Tools for Teaching)
MAC Users - macOS

Word Processor: Word (Microsoft Office Home or Microsoft Office 365 for students) or Writer (LibreOffice). Needs to include a Word Processor capable of saving in .docx format (MS Word, LibreOffice Writer, or OpenOffice Writer). Native macOS applications (Pages, TextEdit, Sheets, FileMaker, etc.) are NOT ACCEPTABLE.

Database: Microsoft Access.
If you have a Windows computer,
    - If Access isn't part of your Microsoft Office Suite, you can download Access through Azure Dev Tools for Teaching.

If you have a Mac, you may either:
    - Use Boot Camp, Parallels or VirtualBox to create a Windows partition, and use Azure Dev Tools for Teaching to download MS Access.
    - Use Splashtop (see below) to use the school's computers, which have MS Access installed.

Web browser (Microsoft Edge, Internet Explorer, Firefox, Chrome or Safari)
Zip program (should be included in your operating system)

Text Editor like Brackets
Diagram Software like MS Visio (available through Azure Dev Tools for Teaching) or Draw.IO
Python IDE: Pycharm Edu or Pycharm with EduTools plugin

Zoom - communication software as part of the online room

Azure Dev Tools for Teaching (formerly Microsoft Imagine)

Azure Dev Tools for Teaching is a service of the Microsoft Academic Alliance which provides free Microsoft products for students registered in classes that require them. Click on link for details.

Splashtop

This software enables students to access PCC computers from off campus. Students must contact their instructor who will, in turn, contact IT to provide access. IT will then contact the student with a Splashtop link. For security reasons, students cannot do this on their own.