Computer 1

Chapter 7 is due 9/12/08. 

Here's the study guide for chapter 7 - Using a Spreadsheet

A spreadsheet is a computer application for storing and analyzing data.
A spreadsheet document is called a workbook.
Each workbook contains three worksheets or sheets.
Rows are horizontal and are labeled with numbers
Columns are vertical and are labeled with letters.
A cell is the intersection of a row and a column.
The name box displays the name of the current cell.
The active cell is displayed with a dark border.
The formula bar is to the left of the name box and is where formulas are entered into a cell.
It is important to plan the layout of a spreadsheet before starting.
Enter key moves you down, tab moves you across, and arrow keys are used to move around the spreadsheet from cell to cell.
Undo will reverse an edit.
Cells can be formatted as text, with bold, italics, underline, and alignment.
Numeric data can be formatted as well by going to format -> cells.
- Number displays a value with two decimal places
- Currency displays a value with a dollar sign and two decimal places.
- Accounting is the same as currency except the dollar sign aligns to the left side
- Percentage displays a value as a percentage with two decimal places.
- Scientific uses scientific notation
Know how to select a range of cells.
File->Print preview allows you to preview the document as it will print.
Know PEMDAS and what it means in Excel (order of operations)
Exponentiation ^
Multiplication *
Division /
Addition +
Subtraction -
Common Errors
- #DIV/0 - divided by zero
- #### - cell to small to display contents
Ctrl+`(grave accent) displays the formulas instead of formula results
Know the difference between cell references and cell contents
Know how to format borders of a range of cells.

Practices
- Do all practices except widget sales
- Print Grades (pg 232), Examples (pg 223), Dept. Memo (pg 224), and Widget Invoice (pg 236).

- Print the following Review Questions and Exercises
- Print a cover sheet with your name, date and class (A or B)
Review Questions
- 1-10, 12, 14-15, 18-21, 25, 27, 34, 39, 41-43
Exercises
- 1-4, 10, 12
Here's the files for Chapter 7

Welcome to class! It's great to have you as a student. Attached to this post you will find the syllabus for the class that you must have signed and returned for your first quiz grade. Get the class (and your grade) off to a good start by getting this in ontime!

Hello! I hope you leave my class in May as a person who is fully comfortable with using a computer for work and school related tasks. From microsoft office to online applications, you'll learn how to use, choose and discuss technology intelligently! Here's wishing you an excellent year.

Posts above this post will be for the 2008-2009 year, while posts below are from the previous year, 2007-2008. 

1. 3D text Cloud Text Google Text
2. Don't forget to send me the jpg images.

Reminders:
- Recipes are for bonus only,  not  required.
- There's no need to spend a lot on a pricey recipe,  you can choose something cheaper.
- You should prepare the recipe yourself.
- I'll provide paper plates, plastic utensils, beverages and cups.

This is not a complete list of everything that you'll find on the exam. Study the study guides from this quarter (ch 12-15).

• Everything on the study guides.
• Review Access
• All the query types
• Wildcards
• Mail Merge
• Form letter
• Reports
• Summary options
• Ways you can share a report.
• Different views
• Slide Master
• Annotations
• Multi-Media
• Relationships
• Sub-data sheet
• Reports
• Grouping
• Color schemes
• Different views in power point
• Logical operators (and, or, not)
• Contrasts

You may earn back missed points on chapter 13 by following these instructions:

- Redo any wrong work
- Place new work on top of your old, graded packet
- Turn the re-done work before your Quarter 3 exam for this class.
I'll give back 1/2 of the points lost when you correct the problems with your packet.

After checking for other listed quizzes, our computer quiz on Friday 1/25 and Monday 1/28 will take place as scheduled.