Category Archives: Uncategorized

Final Computer Tech Project

Choose a new technology that you are interested in.Technology permeates every facet of our lives so this should be a fairly easy task. You will be doing a min TED Talk to discuss how this technology is changing the world. Explain how it is revolutionary right now, and talk about future implications it might have.  Do a little research on your topic—you need at least three sources. You will make three documents to accompany your research: a powerpoint, word document, and excel chart of table.

Click here for a formatting guide for your works cited page.

The requirements are as follows:

WORD DOCUMENT

  • Two pages double spaced
  • 1″ margins
  • size 12pt Times New Roman
  • Your last name and page number in the top right header
  • Follow MLA Format
  • Uses concrete evidence from at least three sources
  • SPELL CHECK.

POWERPOINT

  • Has at least 7 slides.
  • Is used as a visual to aid your TED Talk
  • Includes the chart or table you make in excel

EXCEL

  • Find some relevant data to your topic—this could be how usage of your technology is increasing, an interesting correlation between the usage of the technology and the behavior of people, money spent on this technology etc. You will decide what data is relevant to your topic. This should not be a chart you just found in an article, this should be you gathering data from your sources and creating your own new chart/table.
  • Take the data and create the most appropriate type of chart or table to display the data
  • Title
  • Key

Word Formatting

Click here for a digital copy of the handout I gave you.

When you are finished, you should submit one file that has all four documents in it. (separate each document with a page break.) Please make sure your name is in the title of your file and email it to me at mrsapuglisi at gmail dot com.

Here is the data you will need for the table in the fourth part.

Screen Shot 2015-05-06 at 11.57.35 AM

Spreadsheet Formulas

Formulas are probably the most important thing that a spreadsheet can do for you. We’ve used them a little bit in the past, but we want to be completely sure we feel comfortable with using these simple formulas, and knowing how to set them up, before we move on.

Below is a list of twenty story questions, that are accompanied by a sheet that can help you visualize and work out each problem. Each question has it’s own table, and they are each on a separate sheet tab within your spreadsheet.

Click here to download the sheet you will use as reference as you answer the questions.

Click here for the response form.

Making Charts and Graphs in Excel

Today we are going to do a simple little activity to learn about making charts and graphs in Excel. When you are finished your spreadsheet should look something like this:

Screen Shot 2014-04-04 at 8.19.52 AM

Requirements:

  • Make two charts— one pie and one bar graph.
  • The pie chart should show how you time will be spent during Summer Vacation. (this means you need to break it into percentages and remember, the percentages need to add up to 100%) You must have at least four different activities.
  • The bar graph should show at least 4 of your favorite foods. Research their calories and compare them side by side.
  • The charts should be the same width as the cells with the data.
  • You should have a title over your data and charts that is bolded and centered. Merge together two columns and two rows to get the cell for your title.
  • Save your file, upload it to google drive and share it with mrsapuglisi at gmail.com

Compound Interest

You have accumulated some money from gifts/babysitting/your paper route/selling things on ebay/whatever it is you do for money. You’d like to invest $500 of it for four years because you want the big bucks for college. There are three different banks in your area that all pay a 4.0% interest rate, but they each have a different compounding policy. At Bank A the interest is compounded annually, at Bank B it is compounded quarterly, and at Bank C it is compounded monthly. What impact does compounding have? Where should you invest your money? WHO KNOWS?

Well, we are going to find out! Make Dave Ramsey proud and figure out where would be best to invest your money by downloading the following set of instructions and making a spreadsheet in Microsoft Excel to solve this problem. When you are done with your spreadsheet, upload it to your Google Drive and share it with Mrs. Puglisi so you can get a grade! After you finish, there is also a form with a few questions you need to answer—make sure you do it!

Click here to download the instructions for your spreadsheet.

Click here to go to the form you need to fill out.

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.

That Thing I Love Powerpoint

Regardless of how you feel about power points, they are a technology that is rather prevalent in our society (especially in higher education) so we are going to take the time to get really good at making them. Technically, creating a power point is really quite easy. The tricky thing about power points is presenting them well. We’ve all sat through boring as death presentations before and usually it’s because the person presenting doesn’t know how to do it well. We are going to practice being good presenters!

Your assignment will be to create a powerpoint to present to our class. It can be on any topic that you want. The requirements are as follows:

  • 10-13 slides
  • A theme is applied
  • 8 images
  • 5 transitions
  • 3 animation — at least one must be a custom animation.
  • 1 chart or table
  • One piece of word art
  • Follows the 7×7 rule

When you present these are the things you are going to be graded on:

  • Asking the audience  at least one question (or interacting with them directly in another way)
  • Using intonation in your voice
  • Professionalism
  • Ability to talk about your topic without just reading straight off the slide.

Computer Tech Test

Click here to take the test