Spreadsheet Work

Getting Started:

1. Log on to the school's Google Sign In

(You can find files and examples you need in the Analysis Spreadsheets Shared Collection)

2. To get started, in Google Docs, create a "Folder" called Spreadsheets Name, where Name is your name (for example, Spreadsheets Duxton C). "Share" this "folder" with your teacher. Once you have done this, you turn in your projects by adding them to the folder.

3. Please keep in mind that the point of this spreadsheet work is for you to get experience with spreadsheets. It is NOT a race and it is NOT going to be a good learning experience for you if you are constantly asking me or others what to do or having me or others do the work for you. Be comfortable being uncomfortable!!! Trial and error is going to be a big part of this. Use the help pages if you need them. And yes, you can work together some, just make sure you know what you are doing and that you are doing a lot of it on your own.



Projects:

1. Make your own schedule

While spreadsheets are mainly used for mathematical calculations, they can be a convenient way to create tables.

Start with the template that I provide in the shared collection. "Make a copy" of the template and call it Schedule Name, where Name is your name (for example, Schedule Caroline Bell). Create your WHS schedule. Play with formatting, fonts, borders, etc. If you want an example, look at my schedule.

*Remember to add your final Schedule to your Spreadsheets Name folder.



2. Spreadsheet Functions

Start with the Project 2 spreadsheet in my shared collection. Make a copy of the spreadsheet and call it Project 2 Name, where Name is your name (for example Project 2 Caroline Bell). You will notice there are three sheets in this spreadsheet. Complete all three sheets. You may want to adjust formatting to make the sheets clearer to read.
  1. In the grades sheet, the Average column gets the student's average for the three courses. The Honor Roll column gets YES if the students average is 80% or above and NO otherwise. The summary row summarizes the performance of the entire class. Try to use the "IF" command to get the spreadsheet to evaluate each average and decide whether the student should have a "YES" or a "NO" in the honor roll column and state so automatically.
  2. In the Pete's Pawn Shop sheet, the amount over/under should show the difference between budget and actual. The status column should read "Overdrawn" if the account is overdrawn and "Normal" otherwise. Again, try to use the "IF" command to get the spreadsheet to evaluate whether the account is Overdrawn or Normal and state so automatically.
  3. In the Sales Worksheet sheet, complete the pay calculations for each salesperson and the totals at the bottom.
  4. Create at least 1 chart for some data on each sheet. The type and data for the charts are up to you, but you should use more than one chart type.

*Remember to add your final Project 2 to your Spreadsheets Name folder.



3. Series and Sequences with Spreadsheets

Click the link below for a document with instructions for this project.

Sequences and Series on Spreadsheets

*Remember to add your final Sequences and Series to your Spreadsheets Name folder.



4. TVM with Spreadsheets

Click the link below for a document with instructions for this project.

Time Value of Money

*Remember to add your final TVM to your Spreadsheets Name folder.



Only if you finish 1-4 in class time allotted or if you want to do extra practice with spreadsheets and loans...

5. TVM Assessment Review

*Remember to add your final TVM Assessment Review to your Spreadsheets Name folder.