Jul 30 2013

Tech Tuesday: Creating Paragraphs with WordPress

Pixelkris

Now that we’re back to writing our own blog entries (we already miss our intern, Kelsi!), I was reminded of how fickle WordPress can be. I don’t know if you’ve noticed that whenever you hit the Enter key, WordPress assumes you are creating a new paragraph, and some goomer at WP thinks that means two carriage returns (for those of you who remember using a typewriter). Now when did hitting the Enter key ever mean “give me an extra line there, buddy.” This is so annoying. I finally came upon a great trick after some masterful googling, so I thought I should pass on the information. When you are working in WordPress and hit the Enter key, like now,

you get that extra space. Try hitting the Enter key again, only this time while pressing the Shift key,
and you simply get to the next line, like God intended. I can now sleep tonight.

Share

Jul 29 2013

Last Day Of My Internship

InternKelsi

During this six week internship I have learned a lot. I learned how to use a spreadsheet, touch type, sort, use WordPress to write blogs, format my resume properly, and that’s not even including everything I learned about fabric. There were some things I did that I never thought I would be able to do like answer the phones, call someone and sound professional, or get up at 8 in the morning and go to work everyday. I hope that in the future Deb and Kris decide to have another intern because they helped me so much and really have prepared me for getting a job. While I apply for jobs, I want to keep building up my resume. Kris showed me a great website for volunteering that I want to share. It matches people with volunteering positions they are interested in. Here is the link http://www.volunteermatch.org/. This was a great experience, and I am very grateful to Kris and Deb for giving me have this opportunity to work with them.

InternshipEndLunchWeb

Share

Jul 23 2013

Tech Tuesday: Summing Across Multiple Worksheets Is Different In Excel, Google Spreadsheets, And Mac Numbers

InternKelsi

I made a spreadsheet for my hours during this internship using Google Spreadsheets. I really liked using Google Spreadsheets because I could easily format the cell colors into my favorite neon pinks, yellows, and greens. But, I ran into a  big problem. I could not figure out how to sum up the totals for each week, which were on different worksheets, into one cells. I searched the Internet and found a helpful tutorial. Click here to watch it:  http://www.youtube.com/watch?v=3G86lgIy2_0. This procedure seemed kind of difficult, so I wanted to know if it would be easier to do it on Excel or Numbers on my Mac – it was. Here are the steps to sum across multiple worksheets in all three programs:

Google Spreadsheets:

1) Click in the cell you want your sum to go.

2) Click on the function button. Click Sum and put your curser between the two parentheses that show up in your function bar.

3) Click in the cell you want to add. If you are only adding one cell in that worksheet, you must select more than one cell and then go back to the actual cell you want to add. You can’t select just one cell from the outset.  I think this is a Google booboo, but it works if I select more than one cell and then go back and select the one cell I want.

4) Go into the formula bar and type an addition (+) sign.

5) Click on the next sheet and click on the information you want to add into the summation, add another plus sign. You will have to select more than one cell and then go back and select the cell you really want.

6) Repeat until you have added all of the information into the function bar. Your formula will look something like this:

GoogleScreenShot

7) Press enter.

Excel:

1) Click in the cell you want your sum to go.

2) Click the function button.

3) Click into the first cell you want to add into the summation.

4) Type an addition (+) sign.

5) Go to the next sheet and repeat until you have added all of the cells you want. Your formula will look something like this:

ExcelScreenShot

6) Press enter.

Numbers (Mac):

1) Click in the cell you want your sum to go.

2) Click the function button.

3) Click in the first cell of data you want to add into the summation.

4) Hold down the command button.

5) Go to each sheet and click on the cells of data you want to add, while still holding down the command button.

6) Do that until all of the information you want is added. Your formula will look something like this:

NumbersScreenShot

7) Press enter.

I hope that this has helped some of you, especially if this is something you have struggled with like I did.

Share

Jul 18 2013

Quilt National 2013: More Price Information

InternKelsi

Many of you had a lot of interesting questions about my previous blog entry on the Quilt National 2013 prices. Click here to read my previous post:  http://www.pixeladies.com/quilt-national-2013-analysis-of-prices/. I would like to answer some of those questions for you here. Since many of you wanted to see the actual price sheet, I have posted it here: QN 2013 Price Sheet. Some of you were asking what the purchase option (PO) quilts sold for. I found out that information and have added it to the new QN 2013 Price Sheet. I have also made a chart that graphs the quilt price and price per square foot. The graph illustrates that most of the quilts were between $100-$300 per square foot.

The averages and medians changed when I added the PO quilts:
Average (Mean) Price: $4,436.21
Median Price: $3,650
Average (Mean) Price Per Square Foot: $301.87
Median Price Per Square Foot: $241.33

 

Screen Shot 2013-07-17 at 4.34.32 PM

Share

Jul 16 2013

Tech Tuesday: How To Concatenate (Combine Information Into One Cell) On A Spreadsheet

InternKelsi

When you’re working on a spreadsheet and you want to combine information from different cells into one cell, that is called concatenating. For example, you have the first and last names in two different cells and you want to combine them into a new cell.

Once you have your spreadsheet open, the steps for concatenating are:

1) Create a new column for the information.

2) In the new column, click in the cell that you want to put your information in, and click on the function (fx) button. That brings up a function wizard. Scroll down until you find “concatenate.” Then click the “next” button.

3) Under “text for concatenation,” type the cell that you want to combine (or click on the cell) in the first box. In the second box, add a quotation mark, a space, and another quotation mark. In the third box, add the second cell you want to combine. Click OK. Your formula in the cell should look like this,

Screen Shot 2013-07-15 at 1.45.25 PM

Make sure that you keep a space between the two quotation marks in the formula. Whatever you put between the quotation marks (here I put a space) will show up in your cell.

Screen Shot 2013-07-15 at 1.42.13 PM

In my first example, I combined the first and last names of the actors into one cell. I put first name then last name (A2,” “,C2).

Screen Shot 2013-07-15 at 1.44.34 PM

In my second example, I put them last name, “comma”, first name (C2,”,”,A2).

Screen Shot 2013-07-15 at 1.58.03 PM

This is good for presenting your spreadsheet while still keeping the data separate. It is good for doing things like making a mailing list, which I haven’t had to do yet. But I know one thing, you want to keep your data separate because you never know how you’ll have to present it.

Share

Jul 11 2013

Quilt National 2013: Analysis Of Prices

InternKelsi

QuiltNational

 

Quilt National is a biennial exhibition of contemporary art quilts. Most of the quilts are for sale. Because the quilts are so different in size and style, Kris and Deb, who have a quilt exhibited in Quilt National, asked me to analyze  the QN ’13 prices. Here is what I learned:

Number of quilts in the exhibition: 88
Number of quilts for sale: 70
Number of quilts  not for sale: 12
Number of quilts with purchase  option (no price available): 6
Lowest price: $900
Highest price: $20,800
Average (Mean) price:$5111.36
Median price:$3,950
Average (Mean) price per square foot: $305.50
Median price per square foot: $245.83

The size information can be found in the Quilt National 2013 Best of Contemporary Quilts book, and the price information can be found on the Dairy Barn Arts Center Quilt National price list. Creating this spreadsheet taught me how to calculate averages( means and medians), but I also got to look at some really amazing art. You can see some of the quilts by going to the Dairy Barn Arts Center website: http://www.dairybarn.org/

Share

Jul 9 2013

Tech Tuesday: Split Screen View In Windows 7 Is A Great Tool

InternKelsi

Because I own a Mac and Kris and Deb both have PC’s, I have been introduced to a lot of cool things you can do with Windows, like split your monitor screen. For example, Kris and Deb teach an online Photoshop class, and it is very convenient to be able to have their video lesson open while also having Photoshop open. The steps for how you use the split screen option are:

1) Open the programs you want to have on the screen at the same time. Click the “Maximize” middle button in the upper right-hand corner of the programs to make both of the screens smaller.

SplitScreenWindowsAFixedWeb

2) Right-click on the taskbar and click the option Show Windows Side by Side.

SplitScreenWindowsFixedBWeb

Your windows will then pop up next to each other where they are supposed to be and you are done!

SplitScreenWindowsCWeb

 

 

Share

Jul 2 2013

Tech Tuesday: LibreOffice Is A Free Alternative to Microsoft Office

InternKelsi

Being only 19 and not having an extra $140 to spend on Microsoft Office, I was having a lot of problems trying to do things like send my resume to someone or Email homework to a teacher. When I started my internship, Kris and Deb recommended I try LibreOffice. It made sharing documents much easier. Unlike Pages, the writing software that came with my Mac,  LibreOffice is compatible with Microsoft Office, so I can save a file in Microsoft format and send it where it needs to go. During my internship I have needed to use Excel almost every day, so having the Spreadsheet option on LibreOffice has been awesome. Not only is LibreOffice free but it is really easy to use and the format is very similar to Microsoft Office. When I get stuck and need help (and Kris and Deb aren’t around to help me), I can usually find a tutorial on Google or YouTube. The first spreadsheet I had to make was to keep track of my hours. Since the Pixeladies need to know how I divide my time, I made a color-coded bar graph. Here’s the first page:

ScreenshotSample

If you need a free alternative to Microsoft Office, I recommend LibreOffice.

Click here to download LibreOffice.

Click here for a good YouTube introduction to the LibreOffice spreadsheet.

Share