Unit 2: Spreadsheets

Unit 2 – Spreadsheet and Database Unit

Feb 12

** Student instruction:  Copy the entire note from today into your notebook (do this each day)  **

1)  Create a Unit 2 folder – unit2spreadsheets on H: Drive to store the files from all exercises in this unit

Start Microsoft Excel   (part of Office 2010)

Get a textbook:   Computer Applications for Business – back shelf of classroom

2) Read Lesson 1 Exercise 1 on page 205 and the top of page 206 to get a look at the areas of a Microsoft Excel window

Answer the following questions in your notebook:

a) How are rows labelled?

With Numbers

b) How are columns labelled?

With letters

c) How are cells labelled?

(column,Row) ex: C,15

3)  Try: Exercise 2 page 207, Exercise 5 page 210, Exercise 6 page 211 and Exercise 8 page 213     DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.

These exercises demonstrate simple data entry of values (numeric) and text.  Notice the default formatting difference between values and text and answer the following questions in your notebook:

a)  How is text displayed by default (how is the text justified – ie right justified, left justified, center justified)?

Text is regular font, and left justified.

b)  How are values displayed by default (how are they justified)?

They are right justified

c)  Is there a way to change the justification from the default and how is it accomplished – for example can you change text so it has center justification?

Hit “center” on the cell you want centered.

Feb 13

** Student instruction:  Copy the entire note from today into your notebook (do this each day)  **

1)  Try:  Exercise 9 page 214 and Exercise 11 page 216.  DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.

These exercises demonstrate the use of mathematical formulas (Note:   If you are not sure how to perform a mathematical calculation read the Microsoft Excel help file   (Hint:  use = for simple calculations, =sum to sum a range of cells), data formatting (numeric formats) and alignments.  Answer the following questions in your notebook:

a)  What is the command to specify a mathematical formula?  What is the spreadsheet function to find the sum of a range of cells?

=, if you type this, you will be presented a list of options. =SUM(, and than click or highlight a range of cells you want to sum.

b)  How do you copy a formula from one cell to another so that the cell addresses update relative to copied position?

Just copy and paste a cell

c)  How do you change the numeric format for a value to currency ($000.00) format?  How do you change numeric format to percent format?

Click on the ” $ ” icon. click on the ” % ”

Feb 14

** Student instruction:  Copy the entire note from today into your notebook (do this each day)  **

1)  Try:  Exercise 15 page 221, Exercise 17 page 225  and Exercise 18 page 226-227.    DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.

These exercises demonstrate the use of formatting techniques in spreadsheets.  Adding and deleting columns / rows is also demonstrated.   Answer the following questions in your notebook:

a)  How do you add a border / shading to a spreadsheet?

Click the border icon and pick what type of border you may like.

b)  What is an automatic format and how is it added to a spreadsheet?  What is an advantage of automatic formats?  What is a disadvantage of an automatic format?

When it auto formats the writing to ” black, size 11, left justified, calibri font” All writing is the same and you must change it to look different and special.1

Feb 15

** Student instruction:  Copy the entire note from today into your notebook (do this each day)  **

1)  Try:  Exercise 24 page 236-238, Exercise 25 page 239, and Exercise 26 page 240-241, Exercise 29 page 245     DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.

These exercises demonstrate the use of functions beyond the SUM function.     Answer the following questions in your notebook:

a)  Explain each of the following functions including an example:

i)  Average

Averages a group of cells

ii)  Maximum

The max amount of a group of cells

iii)  Minimum

The min amount of a group of cells

iv)  Count

When its counts all the cells in a range

5) what is if?

ex: =IF(B5>=10,E5*0.1) you type in data that is the data is equal, greater than, or less then a certain equation wil solve “if” that amount is there.

c)  How do you copy a formula to a range of cells?

drag it down, or copy and paste

d)  How is a sort performed?

Feb 19

** Student instruction:  Copy the entire note from today into your notebook (do this each day)  **

1)  Try:  Exercise 34 page   and Exercise 35 page.    DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.

These exercises reviews charting (graphing) in spreadsheets.  Answer the following questions in your notebook:

a)  Name the types of graphs that can be created in the spreadsheet program you are using?

Bar, Pie, Column, Area, Scatter, Line

b)  Outline the steps to create a graph

Highlight data, Click insert, choose the graph you want, and edit headings and press “done”

c)  How do you print to a PDF file from your spreadsheet program?

Click the PDF heading in the top tool bar, save as PDF.

2)  Print the following spreadsheets to PDF files, upload the PDF files to google drive (or another cloud storage area) and link them into your notebook here:

Exercise 8

Exercise 17

Exercise 18

Exercise 24

Exercise 25

Exercise 26

Exercise 29

Exercise 29 (State 1)

Exercise 34

Grow

Growbar

Growline

Exercise 35

Expense

Exbar1

Exbar

Exstbar

Expie

Expie1

Feb 25

Work Period – Spreadsheet assignment – all due at end of class

In addition to the links above print the following spreadsheets and hand in to your teacher:

Exercise 17, 18, 24, 26, 29, 35

Feb 26

1)  Print the following completed spreadsheets ( you can print the excel file or the linked PDF file – your choice) and hand them in.  Be sure you get the correct spreadsheets and put your name or ( you can print the excel file or the linked PDF file – your choice) and hand them in.  Be sure you get the correct spreadsheets and put your name or a title page with your name on the package.

Exercise 17, 18, 24, 26, 29, 35

2)  Spreadsheet Integration

When creating a business presentation it is often necessary to use more than one piece of software to accurately, efficiently and effectively display all information. Often the use of a word processor is required for the structure of a report, or letter but a spreadsheet is used to accurately and efficiently manipulate and chart numeric data.

The integration of the two pieces of software is a useful tool.  To enhance word processing documents it is often necessary to copy spreadsheet data or charts from a spreadsheet program into a word processing program.

Steps:

1. Completely manipulate and chart all data in spreadsheet (Be sure they are perfect)

2. Copy necessary spreadsheet rows or charts to your wordprocessing document

Task 1: Complete Integration Exercise 4 on page 384 and Exercise 10 on page 394.

This requires the completion of:

  • word processing exercise 43 on page 68-69 of the textbook.  (Note that exercise 43 requires the completion of Exercises 26, 29, 34, 39 or you can just look at exercise 43 and create the block formatted letter as shown)
  • spreadsheet exercise 34 (which you have already completed

 

END OF UNIT:

Be sure you have answered all required questions in your notebook

Included links to all completed PDF files

 

Be sure you have handed in: Exercise 17, 18, 24, 26, 29, 35 printouts

Integration Assignment printout

 

Spreadsheet Unit Test:  Tuesday, March 5th 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s