Tutor profile: Elizabeth W.
Subject: Microsoft Suite
I want to make a poster for an upcoming class assignment. Would you suggest creating this project in PowerPoint or in Publisher?
Great question! This genuinely depends upon how you plan to present this project (are you printing it? Are you displaying it electronically?) and which program you're more familiar with. Both programs allow you to create custom sizes for your slide (PowerPoint) or project (Publisher). Both allow for ease of inserting text boxes and image files. Some people find that Publisher is helpful in that it provides templates objects that you plan to print, but again, if your item is a custom size, the template may not apply. Feel free to give me more information on your project so that we can discuss it further.
Subject: Microsoft Excel
I want to create an Excel file for my business that has related information in one file, but separates out different kinds of data from one another. Can you advise how I can do that.
I sure can! My response is based on Microsoft Excel 2016. One way to approach this is to create a new Excel file, being sure to save it in a place that you can easily find again. Name the file something that will jog your memory as to the contents when you read the name. Next, you can create different worksheets within the same file and keep separate data on separate worksheets. For instance, if you want to track your supply ordering in one sheet and sales in another, you can look for the tab at the bottom of the page. In a new file, it is labeled Sheet1 with a + sign near to it. Move your mouse cursor on top of the tab, left click your mouse button to select it, then right click it to bring up a menu. Left click on "Rename" in that pop-up menu. You'll notice Sheet1 is now highlighted in gray with a flashing cursor at the end. Begin typing the new name for this sheet. Make it simple, such as Supplies, or Supply Ordering. For your next tab, click the plus sign and a new tab will appear. Repeat the previous steps to rename this tab to reflect your purchases. Trust this helps. Please keep asking questions as you have them!
Subject: Library and Information Science
You had helped me get started on researching the topic "the effects of social media on politics," but I want to create a more refined search. How can I combine subject headings and keywords to make a more powerful search?
You can powerfully combine a subject in one line and a keyword on another, forcing the database to search it's contents for all articles that contain X phrase in its subject line with a keyword of X anywhere else in the record or full text. Let's revisit the effects of social media on politics. When we did the demo, our Research Strategy worksheet was set up with these concepts: <<image file>> Recall:we went to Communication and Mass Media Complete (the database) through the library's website (ask if you need a refresher on steps). We entered in the initial search terms like so: <<image file>> We then made sure to checkmark "Peer Reviewed", and then limited our results to the publication years of 2013-2018 to assure currency. Once we click search and get our results, we begin skimming through the records that returned -when set up ask described, I received 1,099 results (See here:http://arbor.idm.oclc.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=ufh&bquery=(%26quot%3bsocial+media%26quot%3b)+AND+(politic*)&cli0=DT1&clv0=201301-201812&cli1=RV&clv1=Y&type=1&site=ehost-live&scope=site) Let's say I really liked the first article in the set, titled "Second screening and political persuasion on social media."When I click on that title, I am taken into the article's record that displays all sorts of labeled lines about this article: <<image file>> As I look this over, not only can I discover additional terms/ideas within the abstract, but I want to pay special attention to other areas, such as the Subject Terms field (see the image above).Recall that subjects are not only overarching themes of the entire piece, but the way that they're written here is a prescribed format in this database so that there is a precise way to find other items that are similar.I decide to try combining a subject search (i.e. when I tell the database to search by subject, it knows to search for what I enter specifically in the subject line of the record) with a keyword (which will search anywhere within both the record of the item and any full text documents that are attached to the record). My search now looks like this: <<image file>> Note how the first line is input exactly as it appeared in the subject line of my ideal article, and I changed the dropdown to say SU Subject Terms, telling the database to search this in specifically the Subject line of the record.The second line of my search, influence, is searching as a keyword.When I run the search, the results are much more narrow, dropping to just 48 results (See:http://arbor.idm.oclc.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=ufh&bquery=(SU+(Mass+AND+media+AND+Political+AND+aspects))+AND+(influence)&cli0=DT1&clv0=201301-201812&cli1=RV&clv1=Y&type=1&site=ehost-live&scope=site) Now I'll browse through this new set, glean what applies, and continue altering/refining my search, depending on the usefulness of the results.
needs and Elizabeth will reply soon.