E 115 Final Exam Study Guide

The E 115 Final Exam will cover all topics from the Online Textbook, assignments, and supplements. The exam will include multiple choice, short answer, essay, matching, multiple response, and practical tasks using the terminal and file transfer. Ensure that all required software is working before the exam.

Video: Midterm Review→

Campus Resources

Unity Accounts

  • Understand the difference between Unity ID and Student ID
  • Password recommendations vs. requirements
  • Resources available through Unity Accounts

Campus Email

  • Email fields: Subject, recipient, body
  • Identifying phishing attempts
  • Appropriate use and email etiquette

Campus Printing and Submissions

  • How to print from campus computers
  • Uploading assignments via Moodle

Antivirus Software

  • Recommended software and how to update it

Computing Ethics

  • NCSU computing policies and responsible use.
  • Difference between freeware, open source, buyware, and other licenses.

Operating Systems

  • Kernel: Definition and functions
  • User Interfaces: Differences between GUI and CLI
  • Device Drivers: Purpose and function

File Systems and Pathnames

  • File System Hierarchy: Root, parent, child, leaf
  • NFS File Tree: Absolute and relative paths
  • Home Directory Paths: Absolute and relative
  • Accessing NFS:
    • Windows: Putty
    • Mac: Terminal
    • File Transfer: Filezilla, SCP

UNIX Commands

Basic syntax: eos% command -options argument_1 argument_2

  • Command chaining: command1 ; command2
  • Creating a log file: script -options logfile-name.txt
  • Access command documentation: man command
  • Print working directory: pwd
  • Change directory: cd pathname
  • List directory contents: ls -l -a
  • Create a directory: mkdir directory-name
  • Copy files: cp -r source destination
  • Move or rename files: mv source destination
  • Remove files or directories: rm -r -f file

GitHub and Version Control

  • What version control is and why it is useful
  • Creating repositories, committing changes, pulling and pushing to remote

Spreadsheets (Excel)

  • Formatting Data: Font, size, colors, borders
  • Autofill: Cell referencing, formulas, functions, conditional logic
  • Formulas & Operators: Basic calculations
  • Functions: SUM(), AVERAGE(), MIN(), MAX()
  • Conditional Logic:
    • Simple and nested IF() statements
    • AND() and OR() logic
    • SUMIF() and COUNTIF() functions
  • Graphing: Creating bar, line, and pie charts

HTML, CSS, and Styling

  • Text Tags: <p>, <h1>, <br>, <hr>
  • Image Tags: <img> (with src and alt attributes)
  • Link Tags: Text link, image link, mailto:
  • List Tags: Ordered and unordered lists (<ol>, <ul>)
  • Table Tags: <table>, <tr>, <th>, <td>
  • Inline Styling: style="property:value;"
  • Hex Color Codes: Understanding #rrggbb
  • CSS Selectors: Type, ID, Class

Networking and Hardware

  • Client vs. Server and P2P
  • Networking protocols and topics in the textbook
  • SSH, RDP, and remote access
  • Binary conversions
  • All chapters in Hardware section

Exam Tips

  • Review all assigned readings, assignments, and lab materials.
  • Ensure your software is installed and functioning (Terminal/Putty, Excel, Text Editor).
  • Pay attention to file paths — expect questions on both relative and absolute paths.
  • Practice key UNIX commands, especially file manipulation and navigation.
  • Memorize spreadsheet functions, especially IF() statements (and other conditional logic).
  • Prepare to identify HTML/CSS syntax errors — expect both practical and multiple-choice questions.
  • Make sure you know how to create a webpage on GitHub Enterprise (the one NCSU uses, not your personal GitHub!).
  • Be familiar with networking terminology, especially client/server concepts and SSH usage.