Monthly Archives: April 2015

Puglisi Wish List

Spring is quickly approachingĀ so we’re in the mood to shop! Download the following list of Mrs. Puglisi’s current dream shopping list, and answer the set of questions that comes with it. You will be practicing all the skills you have thus far learned in Excel. No calculators allowed! All your math must be done on the spreadsheet!

Click here to download the spreadsheet and move it into your folder. Remember you must enable editing before you can change anything on it. Just try and delete something and a window will pop up. Click enable editing. You are going to re-upload this when you are done and share it with me, so make sure you save it!

Click here to access the response sheet which will tell you what to do and is where you will put your answers to the questions it asks.

We’re going on a shopping spree!

You have won $1000 to spend on a shopping spree! Using excel, and the new spreadsheet skills that we learned, make a shopping list of all the stuff you would want to buy with your cash. Follow the guide on the worksheet that Mrs. Puglisi gave you to set up your shopping list in excel (click here if you need another copy of it). Here are the constraints for your shopping spree:

  1. You may only buy five things
  2. You may only buy from three different stores
  3. If you don’t spend the $1000 you don’t get to save any so spend spend spend!
  4. Get as close to the limit as you can without going over. Remember, tax counts in your overall total
  5. Sales tax in utah is 6.25%
  6. You must use formulas to find the totals of your shopping spree, not a calculator!

This is what your shopping spree spreadsheet will look like after you get it all set up.

Screen Shot 2014-03-17 at 8.16.17 AM

Powerpoint Jeopardy

Using a topic of your choice, you will create a jeopardy game using powerpoint. We will play these later in class, so make sure they are challenging enough to be interesting, but not so hard that no one will be able to guess the answers.

Requirements:

  • title Page
  • Menu page with all the question options
  • Three categories, and five questions in each category (15 questions total)
  • One slide for each question
  • Create a hyperlink that links the point optionsĀ to the slide with the question
  • Create a hyperlink button on each question slide to take you back to the menu
  • Add an animation to each question so the answer doesn’t show up at the same time.