Feb 28

Work Period – Spreadsheet Integration Assignment

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

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 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)

Exercise 43

Exercise 10

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, 34

Feb 21

1)  Try:  Exercise 34 page   and Exercise 35 page.

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?

There are several types of graphs that can be created in the Excel spreadsheet program. Users are able to insert bar, pie, line, area, scatter and graphs and charts. As well there are special charts such as doughnut, bubble, radar, surface and stock charts.

b)  Outline the steps to create a graph

To create a graph using the data in your spreadsheet, simply copy the data that you would like to include in your graph. Next, select the Insert tab and select which graph or chart you would like to use in the chart tab. A graph will be created by the program and you can add additional features to the graph by clicking on Design, Layout and Format. In these tabs found in the chart tools tab that automatically pops up once a graph is created; users can add axis and chart titles, data labels, colours and can change the design of the chart.

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

To print a PDF file from the Excel spreadsheet program select the PDF tab than click save as PDF. This will save the spreadsheet that you have created as a PDF on your computer. To print a PDF click on the File tab, Print, select the printer that you would like to use as PDF complete. This will save your document as PDF on your computer.

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 #1

Exercise 18 #2

Exercise 24

Exercise 25

Exercise 26

Exercise 29 #1

Exercise 29 #2

Exercise 34 #1

Exercise 34 #2

Exercise 35 #1

Exercise 35 #2

Exercise 35 #3

Exercise 35 #4

Exercise 35 #5

Exercise 35 #6

BONUS:

Exercise 22 & 27

Exercise 36 #1

Exercise 36 #2

Exercise 36 #3

Exercise 36#4

Exercise 36 #5

Exercise 36 #6

Exercise 36 #7