Computer Applications Week 9

1
Computer ApplicationsWeek 9

• A New Quarter
• Excel, PowerPoint, Internet Research

2
Unit Assignment List

• Make a Simple Chart
• Excel Help Questions
• Required Study Hour
• Making Money Doing Nothing!
• Multiplication Table

3
What is your favorite number?

• and you?
• and you?
• ..and you?

4
Can anyone memorize all 38 favorite numbers?
A spreadsheet can do it!
5
Agenda

• What is a spreadsheet?
• Excel demonstration
• Making a chart
• Using help
• Power Point

6
What is a spreadsheet?
Like a table in Word, a collection of
cells Excel is the standard spreadsheet program
7
Why use a spreadsheet?

• Store and manipulate data
• Communicate through charts

8
Quick Demo- Making a chart

• Make labels and data
• Select labels and data
• INSERT gt CHART

9
Insert data and headings into cells
10
Select (highlight) data and headings
11
INSERTgtCHART
12
Your Turn

• I will show each of your charts to the whole
  class through the projector.
• Remember
• Make labels and data
• Select labels and data
• INSERT gt CHART

13
What is the best way to learn about a program?
HELP
14
Excel Help

• On the desktop, there are 10 questions you will
  answer using the HELP in excel.
• You will type your answers in Word
• We will discuss them as a class so make it look
  good

15
Agenda

• New Seating Chart
• Required Study Hour
• What would you do with 150,000?

16
Seating Chart

• Some students will be directly assigned a seat.
• All student with an A will choose their own
• B - C students Some will choose their own
• Listen for instructions!

17
Required Study Hour

• Students who are earning a D or F are being
  assigned a required study hour.
• Parental Notification Sheet is due next week.
• Thursday November 17th, 300 - 400

18
Spreadsheets

• Today you will learn how to do two things,
• Insert formulas using the calculator
• Quick Copy patterns in cells
• You will also see how to make 100,000 doing
  (almost) nothing

19
Why are we learning this?

• Spreadsheet have many purposes
• Projecting into the future is easy to do if you
  know the formula
• You can apply this to other types of projections

20
How will you make 100,000?

• Notes first- Get your notes out
• Demo and Guided practice second
• Finish all 4 parts- on your own
• Grade at end of period- double points today

21
Comparing 4 scenarios

• Saving 10/ month with no interest
• Saving 100/month with no interest
• Saving 10/month with 5 annual interest
• Saving 100/month with 5 annual interest

22
Formulas for each scenario

• 1- Add 10 to previous month
• 2- Add 100 to previous month
• 3- Multiply previous month by 1.00417 and add 10
• 4- Multiply previous month by 1.00417 and add 100

23
What are the steps?

• Create new Excel worksheet
• Type in headings for 5 columns
• Month
• Scenario 1
• Scenario 2
• Scenario 3
• Scenario 4

24
More Steps

• Type 1 and 2 for month, this establishes a
  pattern
• Select cells that have 1 and 2 in them
• Grab the corner and copy all the way to 480 months

25
More Steps- Set up first month

• In the first month- put either 10 or 100 for each
  scenario
• VIEWgtFORMULA BAR - turns on the formula bar

26
More Steps- Inserting the formula

• 6) Click the cell for the second month
• 7) Click calculator button on formula bar
• This lets you build the formula
• Create the formula by adding 10 to the value in
  the previous months cell

27
Last Step

• Copy the formula from month 2 into all of the
  cells up to month 480

28
Day 2 Agenda

• Make Graphs Comparing 4 scenarios for saving
  money (15 minutes)
• Making a Multiplication Table

29
Making Graphs and Money

• Make a line graph that compares money for each
  scenario with the month
• Select all the data and labels first
• INSERTgtCHART
• Choose x-y scatter with the continuous line
  choice
• Put title and labels for each axis

30
Making a Multiplication table

• Today you are going to make a multiplication
  table using Excel.
• The multiplication table is a good example of how
  information can be stored and formatted in Excel.

31
What other types of cells are there?

• Cell phone
• Cell in you body
• Prison cell

32
Prison Cell Analogy

• Prisoner goes inside cell, data goes inside cell.
• There are different kinds of prisoners that go
  inside cells, there are different kinds of data
  that goes into cells, text, numbers, formulas.

33
Prison Cell Analogy

• Prison cell is part of a cell block,
  spreadsheet cell is determined by row and column.
• Prison cell walls (usually cement blocks) can be
  painted and so can the bars
• Spreadsheet cell can be filled with color
  (shading) and can have color on the edge (border)

34
Formatting Cells

• Select Cells you want to format
• Apple-1
• FORMATgtCELLS
• Formatting Palette- Shading and Borders section
• Toolbars

35
Quick review

• A specific cell can have any combination of the
  following
• Value ( or data- the prisoner in the cell)
• Format ( how the cell is formatted )
• Formula

36
Copy and Paste

• To make your life easier, Excel does have copy
  and paste.
• You need to know what you are trying to copy, do
  you want to copy the value in the cell or the
  format of the cell?
• Paste Special
• Formatting Painter

37
Spreadsheet Assignment

• Make a Multiplication Table up to 10
• Separate Labels and Answers with different colors
• Answers are in a checkerboard pattern
• Pick you own colors
• Use copy-paste special
• Use Pattern tool (Auto-fill)

38
Closure

• Show your neighbor your assignment
• Show them an example of the copy-paste special
• Show them an example of using the pattern copy
  tool
• Who can make the chart in the least number of
  steps?