Course Expectations and Tentative Syllabus
CSC:151 Introduction to Computing – Business Applications Fall 2007
Section 25: Room: 201 Olney Hall Time: TR 9:30-10:45am
Section 26: Room: 201 Olney Hall Time: TR 11:00am-12:15pm
Professor: Dr Redmond Office Hours: Mon 10:00am-12:50pm
330 Olney Hall (215) 951-1096 Mon 2:00-2:50pm
redmond@lasalle.edu Fri 10:00am-12:00 noon http://www.lasalle.edu/~redmond/teach/151 And at other times by appointment
Text:
Materials:
You will find it convenient to have a USB storage device (“jump drive”, “memory stick”) . Most assignments will require you to submit your work to Blackboard Course Management System; however, you may want storage you can carry around with you.
You should keep copies of all of your assignments at least until you receive your grade for the assignment (and don’t have any questions about it)..
In addition, you should get into the habit of saving often, and saving backup copies of important files. (You should know its name and location. If you save a file in a space that is not allocated to you (such as the C: drive of a lab computer), you risk losing it.). Missing or destroyed files are not acceptable excuses for incomplete assignments.
Course Description:
Problem solving and computer applications for business – including word processing; design and use of electronic spreadsheets; presentation software; and PC-based database. Particular emphasis will be put on Microsoft Excel and Access.
This course is about using the computer as a tool (“computer fluency”). It is really about surviving in the 21st Century business world!!
All class periods will be in the lab. There will, however be times when class time will involve lecture or discussion. Do NOT use the computers as a distraction from class when we are not using them (i.e. no game playing, instant messaging, private e-mail). There will be some in-class time for working on most assignments. In your own time, it is expected that you will do reading, further hands-on learning, and complete assignments when not finished in lab.
Sometimes we will shuffle material around so the attached tentative course plan is tentative.
Prerequisite: None
Grading: Final Grades:
Assignments 20% B+ 88-89 C+ 78-79 D+ 68-69
3 Midterm Exams 60% A 92-100 B 82-87 C 72-77 D 60-67
Final Exam 20% A- 90-91 B- 80-81 C- 70-71
F < 60
Late Assignments -20% per weekday (NOTE - NOT per CLASS)
UNLESS SPECIFIED OTHERWISE ASSIGNMENTS ARE DUE AT THE BEGINNING OF CLASS
-10% if handed in after start of class and before I leave for the day.
Makeup exams only by advance arrangements or for documented real emergencies, such as medical problems. Makeup may involve substituting your final exam score for the missing midterm.
The Final Exam is not cumulative.
Cheating:
Claiming another's work as your own is cheating. A student caught cheating will receive a score of zero for the assignment. Asking another for help on a step or two in a many-step homework or lab assignment is acceptable; handing in duplicate or nearly duplicate work is not. Finally, openly allowing your work to be copied is also cheating. Plagairism, be it from a book, a web site or a fellow student, will be considered cheating.
Open Lab Location: Wister Building basement lab is available. Reportedly, ½ will be Windows XP, and ½ will be Vista. All should have both Office 2003 and Office 2007 (which we will use) Last semester the hours were:
Mon-Thu: 8am-11pm
Fri: 8am-7pm
Sat: 9am-7pm
Sun: 12pm-11pm
College Hall 201 lab hours last semester were: Monday-Friday 9am-9pm
There are other labs on campus with varying availability.
Objectives
1. Understand and appreciate the power and use of computers and information in business.
2. Develop competency in file management, research database search, and with word processing, spreadsheet, database and presentation graphics packages, with a focus on business applications.
3. Develop problem-solving techniques, e.g. design of a spreadsheet, create and interpret a graph, design useful database queries, …
4. Understand and adhere to the University computing policy.
5. Understand some of the ethical issues involved in processing and using information.
Tentative Course Plan:
|
Week |
Date |
Material |
Reading |
|
1 |
8/28, 8/30 |
Intro to Class, Memory, Storage, Blackboard |
|
|
2 |
9/4, 9/6 |
Spreadsheet Basics, Formatting |
Excel Chapts 1, 2 |
|
3 |
9/11, 9/13 |
Usability / Best Management Practices Particularly tied into Word and PowerPoint |
PowerPoint slides |
|
4 |
9/18, 9/20 |
TEST 1, Excel Calculations, Formulas & Functions |
Excel Chapt 3 |
|
5 |
9/25, 9/27 |
End of Chapt 3, Advanced Editing and Calculations |
Excel Chapt 4 |
|
6 |
10/2, 10/4 |
Advanced Editing and Calculations |
Excel Chapt 4 |
|
7 |
10/9, 10/11 |
Charting |
Excel Chapt 5 |
|
8 |
10/16, 10/18 |
TEST 2, Pivot Tables |
|
|
9 |
10/23, 10/25 NO CLASS on 10/23; |
Add ins: Goal Seeking, regression, solver, what if scenarios |
|
|
10 |
10/30, 11/1 |
Advanced Word, Advanced PowerPoint |
Word Chapt 4, notes |
|
11 |
11/6, 11/8 |
Library database searching |
PowerPoint slides |
|
12 |
11/13, 11/15 |
TEST 3, Intro to Databases |
Access Chapt 1 |
|
13 |
11/20, 11/22 NO CLASS on 11/22 |
Creating Tables / Importing Data |
Access Chapt 2 |
|
14 |
11/27, 11/29 |
Queries |
Access Chapt 3 |
|
15 |
12/4, 12/6 |
Reports |
Access Chapt 5 |
|
16 |
TBD |
FINAL EXAM (non-cumulative) |
|