| Other Information: |
Textbook Topics
Abstract view of computers: hardware, software, users
Hardware (l class)
o CPU, I/O, Buses, Storage devices and media
o Embedded hardware: consumer electronics, cars, power plants, factories,
medical devices, etc.
Software (1 class)
o Programs: application vs. system programs
o Structure: Files and Folders
o Size: bits, bytes, K, M, G, T
System Software: Operating systems, Browser (1 class)
o Operating system functions: file management, device control and communication,
job scheduling
Application software (4 classes)
o General purpose: graphics, word processing, spreadsheets,
Databases (for specifics see Lab Topics below)
o Special purpose: accounting, medical, inventory management, CAD/CAM,
etc.
Networking and Telecommunications: (2 classes)
o intranets, internets, THE Internet, email, web browsing and publishing
Social implications. (2 classes)
o Focus on 2 or 3 among: privacy, security (of data and systems), changes
in the workplace, e-commerce, e-communication and e-communities, copyright,
risks of computing (loss of $ and life), democracy (e-voting, universal
access), global implications (cultural invasion)
Lab Topics
System Fundamentals: (1 lab)
o Mouse operations: move, click, double-click, click & drag
o Window op's: open, close, iconify, move, resize, maximize
o OS: format disk, filesystem navigation, starting applications, copying,
renaming files
o Applications in general: open existing, close, save, create new
Word Processing (3 labs)
o Entering, deleting, and editing text
o Selecting text
o Formatting characters, paragraphs, pages
o Copying and moving text
o Making tables
o Copying/linking spreadsheet data and graphics
Spreadsheets (3 labs)
o Definitions: cell, range, active cell, formula, function
o Data types: label, number, formula
o Data format
o Inserting rows and columns
o Moving and copying ranges
o Constructing formulas
o Using pre-defined functions, which functions are available
o Absolute vs. Relative addresses, and their relationship to moves/copies
o Charting
o Sorting
Databases (2 labs)
o Queries using relational (=, <, >, etc.) and logical (AND, OR)
operators. Operator precedence.
o Applied to: library database, WWW search engine/webcrawler (see below)
o Creating a database
The Internet (2 labs)
o Email: sending and receiving, including text files, saving as text
files, attachments
o WWW browsing: going to a URL, saving data locally from a website,
using the history list, bookmarks
o Search using relational and logical operators
o Publishing: saving in WP as text, creating a web page, "View Source",
simple HTML: data vs. "tags", nested tags, a few simple tags (e.g., for
making lists, for character formatting). |
