Computer Literacy

Current sections

• 08: Mon / Wed 3:00 PM   (Blackwood)
  • Class Schedule and Due Dates
  • Assignments
  • Presentation Sign-ups

Current Events Presentation

Class slides

Building your own website

• Setup a site at webs.com (preferred).
• Instructions for setup
• Webs.com login page to edit site
• My site at Webs.com

• Set up a Zoho site
• Zoho login page to edit site

What web sites looked like in the early 1990s

HTML

• primer: PowerPoint download, View PDF
• getting started: instructions and template

Moore's Law Assignment

Excel Exercises and Practice

1. Extra Help
2. Grade Sheet Exercise^*: Illustrates how to create a basic spreadsheet by entering text, numbers, and formulas.
3. Checkbook Exercise^*: Introduces formatting of cells and columns.
4. Mortgage Exercise^*: See how functions can be used to create a spreadsheet to perform "what if?" calculations.
5. Using ChartWizard^*: Demonstrates the ease of creating charts.
6. Using Logical IF functions and VLOOKUP
7. Pivot tables
8. Making charts

Excel Assignments

1. Ice Cream: assignment, zip file
2. Steggel Consulting Salaries: pg. E-120, zip file
3. Outlander Spices: assignment, zip file
4. Houses on Pine Circle: pg. E-156, zip file

Review for Excel Test

Access and Databases

• Sample databases (Movies)
• Access assignment: Frats and Sororities
• Access Project
• Learn about relationships from Barack Obama vs. the Martians