prelab5 - CS&E 200 Spring, 2008 CS&E200 Purpose: 30...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
30 Points Pre-Lab Session 5: Spreadsheet Design, Charting & Advanced Functions Purpose: The purpose of this lab is to expand your problem solving skills to include Reference and Financial functions. In the in-lab assignment you will be required to solve a large problem directly from the data. This will require your knowledge of spreadsheet design as well as all of the other skills you have acquired thus far in the course. There is no one right way to do this, however some ways make it easier than others to update information and create multiple what-if scenarios. Estimated Time to Complete: Pre-Lab: 2-5 hours, closed lab session:1 hr. 48min – assignment to be distributed in class Pre-Lab Assignment - to be completed before coming to lab Part I: Charts : Review chapter 5 & 6 – Level 1 of the text. 1. COMPLETE the Steps to Success Chapter 5 Level 1 tasks starting on page 768 of the text. The starting file Golf.xlsx is available on Carmen. Save the completed Golf Orders.xlsx workbook to your Z:\windows\personal\lab5 directory. This file will be submitted at the beginning of your in-lab session. 2. COMPLETE the Chapter 5 Level 1 exercises starting on page 817 of the text. The starting file Taxes.xlsx is available on Carmen. Save the completed Tax Analysis.xlsx workbook to your Z:\windows\personal\lab5 directory. This file will be submitted at the beginning of your in-lab session. 3. COMPLETE the Steps to Success Chapter 6 Level 1 tasks starting on page 842 of the text. Create the new file Advertising.xlsx and save it to your Z:\windows\personal\lab5 directory. This file will be submitted at the beginning of your in-lab session. 4. COMPLETE the Chapter 6 Level 1 exercises starting on page 883 of the text. The starting file Loan.xlsx is available on Carmen. Save the completed Loan Analysis.xlsx workbook to your Z:\windows\personal\lab5 directory. This file will be submitted at the beginning of your in-lab session. 5. You will be starting your analysis of the X-Mart Remodeling problem. Part of this exercise is to design your own unique workbook that will effectively convey the information requested. During the in-lab assignment you will be executing this design by implementing it in a workbook. The entire assignment is meant to reinforce both your spreadsheet design skills and ultimately during design implementation, reinforce your knowledge of reference functions, financial functions and charts. It is expected that your workbook design will be unique and as such you are expected NOT to confer with other students on your workbook design. Complete the following as part of your pre-lab assignment. Create a sketch on paper (or if you’re ambitious in PowerPoint) which you will bring to lab and turn in. This sketch should include the layout that you want your workbook to Office 2007 Lab 5 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
take and some ideas of which functions you would use for the different calculations. Note: you are NOT allowed to bring in already started workbooks, the file must be
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

prelab5 - CS&E 200 Spring, 2008 CS&E200 Purpose: 30...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online