Monday, June 30, 2008
Thursday, June 26, 2008
I have also placed a copy of it on the shared Numan drive, under IS, Instructional materials, Class Assignments and then Research tips for Audit Failure Assignment, dated 06272008. The presentations are due in late July. I will be gone next week, on research leave from July 14, and gone again July 19.
They can select the audit failure that they want to work on. While Enron might be very popular, there is also probably an overwhelming amount of information on the case. One of the more difficult cases for locating information involves a pharmaceutical supply company on Long Island in the 1980s that did not generate many news stories when the audit failure (involving "cooking the books") was discovered, or afterwards. The company no longer exists.
When I did a workshop on helping students locate information, I first showed them how to locate the sources cited in the case study, which they really seemed to appreciate.
I also showed how to find articles in the databases such as how to avoid inventory fraud or embezzlement, which provide information for suggestions on how the situation might have been avoided, or for suggestions for improvements in internal controls and procedures.
Another professor, who teaches this during the spring and summer terms, has told me that he wants the students to develop a more skeptical approach, and realize that as auditor once you step into a firm, you are in their environment which they control. He has said you can't teach this from a book. But, reading the cases, with hindsight, you can see some instances of possible "red flags" --when excuses or exceptions were made, when procedures weren't followed, when people were related or involved with each other, or when there appears to be no where to turn for advice or to report something suspicious. So, psychology databases have some articles about
risk management, auditing and auditors.
I hope this is helpful. I am meeting with one of the student groups tonight so I will post if they have any suggestions as to what they find helpful. If a student comes to the desk who has not read the case, I have started to suggest that the student do so prior to seeking assistance.
I met with the student group doing the Enron case tonight. The assignment is different from past semesters as the assignment includes answering the questions at the end of each case study for their presentations. So, finding historical financial filings may be less important than in the past.
Many of the questions also ask the students to provide their own opinions on requirements and auditing standards.
Auditing standards online are available on CCH Accounting Research Manager, and as they are the current standards, print standards from prior years should be found using CUNY+.
The study is being lead by Prof. William Lutz, the author of Doublespeak Defined. He worked with the SEC on their Plain English Handbook. Prof. Lutz spoke about doublespeak at Baruch's College Convocation in 2005.
The choices may depend on whether the student wants to generate a chart/graphical data from price data or simply copy and paste a graph. Some of the options below provide only the company's stock prices over 5 years, while other options allow you to create a graph/chart comparing that company's stock prices performance to other companies or to an index or indices.
Creating a chart of stock prices is one of the things learned in the Reuters workshops but that didn't seem a practical solution today, given that it was an email question. Plus neither of us had saved such a created chart and then emailed it to ourselves.
So here is the answer that I sent the student, in the event that it comes up again:
Here's some options:
1. Go to the Home Depot homepage, www.homedepot.com, and
Click on Investor Information, then stock information. You will see that a chart is available on the prices. You can change the chart to 5 years and select different stock prices...weekly, etc. Then, right click on the chart and you will have the option Copy Image. Open Powerpoint and select a slide in which the content is graphs and past the image.
2. You can also use three subscription databases available to Baruch students to copy and paste a chart. Why would you use these databases over Home Depot's free option? Standard & Poor's Net Advantage, Mergent, and Morningstar allow you to build a graphical chart with more options..you can select to compare HD's stock price to different indexes. This would provide more information than the chart of the stock price alone.
Both Mergent Online, Morningstar and Standard & Poor's Net Advantage are databases that can be located through databases on the Newman Library homepage.
3.) for Standard & Poor's NetAdvantage.
Once you log on to the database, look to do a Companies search (blue toolbar). Enter HD as the ticker and search.
On the left column, you will see chart listed among the selections. Click Chart. A chart will appear and you will have options to select. When you have created the chart you want,
right click and copy the image. As before, insert into Powerpoint.
4.) Now, for Mergent. Select Mergent Online from the database options. Either enter Home Depot as the company name or HD as the ticker symbol to search. Then, click on the tab Equity Pricing when the option appears. You will see a chart of HD's stock prices. As with Standard & Poor's NetAdvantage, you can select the time period and if you want to compare the HD stock performance to a different index, make the selections you want.
Scroll down and click Draw Chart, when you have made your selections. As before, right click to copy the image, and then open Powerpoint and insert the image.
5) I forgot to look at Morningstar when I was doing the email reference. But it too allows you to get a five year graph of a company's stock prices and allows a comparison to another company to be added. Right click to copy the image and then paste into Powerpoint.
Some free web sites that also allow you graphs that can be copied are:
www.Reuters.com. Do a search for the stock you want and look for the chart. Click on it, and you can create a chart with different options, including comparing the company to three other companies. Once again, right click to copy image and then insert the graph into a Powerpoint.
Google Finance also might be used. Enter HD as the stock quote that you are looking for. Click on the link Historical stock prices and select five years. You will then need to click download to a spreadsheet. Once you have saved the spreadsheet as an Excel file, you can create a chart using Excel. This will require a few more steps than the other options that allow you to copy a chart.
I also looked at Valueline but since this is a black and white chart for 10 years, I didn't recommend it.
I also looked at Valueline but since this is a black and white chart for 10 years, I didn't recommend it.
Blackwell is not listed in our list of databases, but we subscribe to some of their journals, so that may come up on the full-text list.
The article does a nice job covering the history of the two companies and assessing possible strategies for the future.
See "The New Fight for Financial News" in the New York Times, June 23, 2008.
The following resources are helpful for this data:
(1) WRDS - for monthly exchange rates.
After connecting, choose "Federal Reserve Bank Reports". In the new page on the left you will see a heading for "Foreign Exchange Rates"; click on "Data" directly below. When selecting countries and years, change the frequency from "daily" to "monthly".
(2) WDI: World Development Indicators - for Consumer Price Index.
You need to select the countries, series (Consumer Price Index), and time (years). For the CPI, click on the Series tab and then click on "Exchange rates and prices" for the topic. You will see your options change in the box to the right. CPI will be listed first for you to select.
Wednesday, June 25, 2008
Tuesday, June 24, 2008
Ellen Bates on "what to do after you log off," which discussed ways that librarians/information
professionals can demonstrate their value, or offer addition help, after the initial inquiry is completed. Tonight on the desk a student asked for help in locating Milton's Paradise Lost, so I showed her how to locate the book in CUNY+. Then I asked, " will you need some information to help understand it," and she said "yes." So I showed her how to search Literature Resource Center and JSTOR. (She said aftewards she had only used our databases a little and not for literature articles.)
She said she appreciated the extra help. I realize that I should have framed my inquiry better like, "Would you like me to show you some library resources that help explain Milton's writings? "
Provisions of the covenants for a particular bond will usually be found in the bond prospectus or a supplement to the prospectus. Thomson Research provides the most comprehensive collection of prospectuses for both U.S. and foreign corporations.
There are two databases that can be used to find a list of the bonds that a company has issued. The SDC new issues database probably has the most complete list including bonds that have been recalled. Students might find it easier to use Mergent Online which in one of the company tabs lists all the long term debt and capital stock outstanding.
http://www.leg.state.vt.us/docs/legdoc.cfm?URL=/docs/2008/bills/intro/H-775.htm. (This is not the final version of the law.)
Some expect an outcome of the law is that nonprofit organizations will seek to incorporate under Vermont law, much like many for-profit corporations seek to incorporate in Delaware because of some features of Delaware corporate law.
Monday, June 23, 2008
- The Ticker Digitized Archives- (Choose Digital Collections, then click on "The Ticker" in the right sidebar)
- Lexicon yearbook - Ref. LD 331.B66457 L4
- Undergraduate Bulletins - Ref. LD 331.B66428 B37
Any other suggestions?
Friday, June 20, 2008
Furniture: Put everything you can on wheels. Buy many more whiteboards than you think you need - students love them. The Hub has 20 but could use another 20 more. Do not use TV monitors for signage. They are not as easy to program as simple projectors.
Services:They have replaced their reference desk sign with one that says "Help * Help * Help. They have a mobile reference desk too but are still looking for ways to increase reference traffic. They now offer workshops in RSS and SecondLife. They are partnering with their IT department to offer a laptop clinic. They have a tutoring kiosk (through a video conference/chat system) that allows students to get help from the writing center while in the library. They are going to set up a kiosk in the IT labs for students to get help from librarians. They have trained students to be "navigation assistants."
A description and pictures of The Hub are on their website along with links to more pictures on Flickr.
- The BCTC home page has a "Help Desk Alerts" section that you may want to check first to see if the problem you're reporting has already been noted
- When you report a problem to the help desk, the staff there logs your problem into a ticketing system. Please ask for the ticket number so that when you or someone else calls back for followup, you can refer to the original ticket number.
- If you post a message to the reference blog about the problem, include the ticket number in your post if your problem resulted in your calling the BCTC help desk.
- Although Saad and Arthur automatically receive copies of all blog posts via email, you may also want to call Saad's staff or submit your request also to the library's own help desk system (there's a link to it on the toolbar of all reference desk PCs). Indicate to Saad's staff that you've already contacted BCTC and provide the ticket number. You should know that any problem reported to the online help desk system for the library is automatically routed via email to Saad and his staff.
Wednesday, June 18, 2008
Once the student logged in, we went first to the 'Mediamark reporter' tab, and then chose 'Fall 2007 product.' There is an option to choose a report based on the type of product, or to search by keyword. We searched for coffee and found that 'ground coffee' was one of our results. There were many different brands listed, including Maxwell House. After that, you can generate reports for the past six months.
It sounded as if this is a group project for the class, so there may be other students coming in to use MRI+.
- the book is in the archives
- it does not circulate at all
- anyone who wants to look at it must make arrangements in advance with Prof. Sandra Roff, who will sit with that person as he/she reads the book
- limited numbers of pages may be photocopied by Prof. Roff at her discretion
Tuesday, June 17, 2008
1.) Select CRSP
2.) On the left select monthly stocks
3.) Enter the ticker symbol
4.) Under the variables section tick off "price"
5.) Then select Submit request
Thanks to Prof. Liu
We now have access to a new Gale database: Literature Criticism Online (LCO), a useful complement to Gale's Literature Resource Center (LRC), which we've long subscribed to.
What's Unique about LCO
Backfiles from ten essential literature reference series from Gale:
- Contemporary Literary Criticism
- Twentieth-Century Literary Criticism
- Nineteenth-Century Literature Criticism
- Shakespeare Criticism
- Literature Criticism 1400-1800
- Classical and Medieval Literature Criticism
- Poetry Criticism
- Short Story Criticism
- Drama Criticism
- Children’s Literature Review
A number of valuable Gale and St. James reference series are in LRC instead (such as Contemporary Authors).
When to Use LCO
If a student needs to find criticism of a specific work of literature, I'd start with Literature Resource Center (LRC) first, then move on to LCO, then finally to MLA International Bibliography.
If the student wants an overview of an author, then LRC first, LCO next, and don't bother at all with MLA International Bibliography.
LCO and Bearcat Search
LCO is not yet connected in Bearcat Search. I'll post a note here when it is. Speaking of federation, Gale promises that someday soon we'll be able to search LCO, LRC, and MLA International Bibliography from a single Gale search screen (as we can do with EBSCOhost databases); right now, if you go to LRC and run a search, it will automatically include MLA International Bibliography results too unless you unclick the checkbox at the bottom of the search screen.
Monday, June 16, 2008
Friday, June 13, 2008
Thursday, June 12, 2008
Tuesday, June 10, 2008
Ogden Nash: the life and work or America's laureate of light verse, by Douglas M. Parker (PS 3527 .A637 Z79 2005). Parker follows Nash's life from infancy to death, frequently interspersing Nash' s own verses (there is a 4 page Table of Poems). A bibliography of primary and secondary sources and a number of pictures make this a very useful source for anyone working on Nash.
Trust and honesty: America's business culture at a crossroads, by Tamar Frankel (KF 9351 .F73 2006). Pondering on the the recent business scandals of Enron, WorldCom and more, Frankel, a professor of law at Boston University, invites the reader to examine the state of trust and honesty in American business. What happens to society when deception seems pervasive? And how can we stop this trend? Extensive notes and bibliography.
Dragons at your door: how Chinese cost innovation is disrupting global competition, by Ming Zeng and Peter J. Williamson (HC 427.95 .Z424 2007). According to the authors, the real "Chinese threat" doesn't come from the "cheap, low-quality imitations flooding world markets" but from the ways in which they have been able to harness technology at low cost, offer a an incredibly high number of product choices, even for mass-market products, while also offering specialty products at dramatically lower prices.
Islamic law and the challenges of modernity, edited by Yvonne Y. Haddad and Barbara F. Stowasser (KBP 144 .I83 2004). With globalization, there are an increasing number of clashes between Islamic and Western laws. The authors start by looking at Islamic law from historical and regional views. The book is then divided in two parts, the first one looking at modern legal reforms in the Arab world, and the second examining the impact of these reforms on women specifically. Included are a substantial bibliography and a glossary of terms.
The impact of women in Congress, by Debra L. Dodson (HQ 1236.5 .U6 D63 2006). Looking specifically at the 103rd and 104th Congress, and at three specific areas (women's health, reproductive rights, and health care policy), Dodson examines the complex interactions between women's presence and impact and the institutions they work in. The author conducted a number of interviews and a number of tables appear throughout the book, as well as an extensive bibliography.
As a first step, Wiley is moving ALL Blackwell content to its own server. This will make it more difficult for us to find the titles we do subscribe to since we only subscribe to about a combined 220 titles out of over 1,600 titles that will be available.
Both sites will be unavailable June 28, 29 and 30.
Friday, June 06, 2008
The Latino National Survey (LNS) contains 8,634 completed interviews (unweighted) of self-identified Latino/Hispanic residents of the United States. Interviewing began on November 17, 2005, and continued through August 4, 2006. The survey instrument contained approximately 165 distinct items ranging from demographic descriptions to political attitudes and policy preferences, as well as a variety of social indicators and experiences. All interviewers were bilingual, English and Spanish. Respondents were greeted in both languages and were immediately offered the opportunity to interview in either language. Interviewers also provided a consent script that allowed respondents to opt out of the survey.
Wednesday, June 04, 2008
Tuesday, June 03, 2008
For future inquires, let students know that Reuters I is scheduled for next week on Wed., June 11th from 12:45-2pm. Alfredo will set up the online registration soon.
An internet search for "Hillary Clinton" and baruch will return this page as one of the top links (easier than giving someone this long url).