Welcome to Professor Marshall's website for CSCI018

Back to Professor Marshall's profile.

Welcome to Computing for Business!
The intention of this course is to teach you how to use Microsoft Excel and to emphasize its extensive use in the business world. Topics include: formulas, functions, charting, formatting worksheets, absolute cell references, working with large worksheets, what-if analysis, financial functions, lookup functions, working with multiple worksheets and workbooks, customized printing, macros, Solver, data validation, password protection, PivotCharts, PivotTables, and importing data. Many financial concepts will be covered. Additionally, we will briefly cover Microsoft PowerPoint.

The class time will generally be a mixture of lecture as well as lab problems.

First things First
Login to your computer. If you don't have an account, you must set up and activate your account using the following link. This must be done from a campus computer. http://cams.qc.cuny.edu/

Checking your New Email Remotely (from Home)
Simply visit this link to check your new email account. Your username is your name 'first last' (yes, there is a space in there) and your password was set by you when you activated your account. https://qcmail.qc.cuny.edu/

Logging into your AD Account Remotely (from home)
This will give you access to your P drive remotely. http://helpdesk.qc.cuny.edu/FAQS/proxy.asp

Forwarding your QC email
This Word document explains how to forward your Queens College email to a preferred email address. forward_qcemail.doc

If you have Microsoft Office 2003 at home, you can download this free compatibility pack to open and edit Office 2007 files. http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

Accessing Library Resources from Home
Beginning September 2010, one only needs a current QC I.D. which has been activated at the Library to get into the databases from off-site. Go to the Library web pages, click on a database, and enter your barcode number. It's that simple!

THE COLLEGE IS CLOSED ON 9-4-2010 AND ALSO 9-18-2010. NEXT CLASS WILL BE ON 9-11-2010.

Textbook: Financial Analysis With Microsoft Excel
by Mayes & Shank. ISBN: 0324407505
Textbook Website: http://www.swlearning.com/finance/mayes/mayes3e/mayes3e.html

Textbook: Textbook on Amazon (3rd, 4th, or 5th edition is ok):

Textbook Website: http://www.amazon.com/Financial-Analysis-Microsoft-Excel-Timothy/dp/0324407505/sr=1-1/qid=1171472755/ref=pd_bbs_sr_1/105-7744100-2532443?ie=UTF8&s=books

Fall 2010
Syllabus-CSCI018.pdf

Notes:
	Name	Description	Link	Date
		All notes and lab assignments can be found here: (password is required)	http://www.campuspostit.com/hs/les/coursewebsite.ihtml?Instructor_last=Marshall&user_CourseCode=csci018&Instructor_ID=212	08/25/10

Other:
	Name	Description	Link	Date
	Bloomberg Information	Obtaining a Login and Getting Bloomberg Certification for Extra Credit (and a resume boost).	Bloomberg.doc	09/17/07
	Bloomberg	Notes for Introductory Course I100	I100.pdf	09/18/07
	Bloomberg	Notes for Introductory Course I200	I200.pdf	09/18/07
	Bloomberg	Notes for Introductory Course I300	I300.pdf	09/18/07
		Formula Sheet for Exam 1	exam1.pdf	09/26/07
		Keyboard Shortcuts	Shortcuts.doc	01/27/08
		Excel Error Cheat Sheet	Errors.doc	01/27/08
		Visual Basic Error Codes	Messages.doc	01/27/08

Email Professor Marshall:

Maintenance (faculty login required)