CSE/INFO 100: Computer Fluency, Winter 2009

The questions below are only examples of the types of questions that may be asked. The actual questions on the final may have different wording or will cover related ideas.

Given a picture of a directory structure, what is the relative path from file A to file B?
If you open a PowerPoint file in Notepad (Windows) or TextEdit (Mac), it shows up as gibberish, why?
Given a picture of a web page, what is the HTML to generate that page?
You should be able to do the "Computer 'knows'" problem from Lab #5.
Lab #6 type questions will NOT appear on the final. Focus on Lab #7/8 and Project #2 for the JavaScript portion.
Given a picture of a menu option, list the steps of 3 different ways to access that menu item? The answer to this question would list the steps of using the mouse, mnemonics, and the appropriate shortcut.
Example of a search question: You are trying to find out when the first coast-to-coast trip by automobile in the US took place and how long it took. What will you type into a search engine?
Know the difference between memory and hard drive and why you would need more of one or the other.
Show how to create a hoax link in a phishing e-mail.
What makes up a computer program?
What is an IP address?
What is the (usual) keyboard shortcut to save a file?
Explain the general idea (not the specific details of transistors) of Moore's Law.
It is possible to put the styles in an HTML file, but it's generally not a good idea. Styling should go in the CSS file. Why?
In simple English, what is the point of escape sequences?
Given a picture of a web page, write the event handler that will cause XYZ to happen when the button is clicked.
Know how to translate absolute and relative references in a spreadsheet.
Know what cookies are (no, not the eating kind), where they come from, and what they are for.
Know how to write basic SQL queries including selecting fields and joining two tables.
If you have a good question idea, let me know.

Sample Final Questions Ideas