Csci 241
Introduction to Software Packages I
Course description: Survey and usage of software packages such as spreadsheets, data bases, and statistical applications for mini and microcomputers. This course has been identified as a general education course.
Prerequisites: Math 113 and Math 170, or permission of department head.
Text: New Perspectives Microsoft Office Excel 2007 Comprehensive, by Parsons, Oja, Ageloff and Carey, Course Technology, 2007
Check your instructor's website at
www.faculty.mcneese.edu
or
www.dmcs.mcneese.edu
for additional information.
For details about your instructor's contact information, office hours, and policies, go to www.faculty.mcneese.edu and access your instructor's website.
General Education Competency
The General Education Competency assessed in this course: to be familiar with key technological and informational applications.
Student Learning Outcomes
The student will be able to demonstrate skills necessary for creating and maintaining electronic spreadsheets.
Objectives
The student will be able to
- demonstrate an understanding about the major components of electronic spreadsheets and how they work;
- demonstrate an understanding about the syntax of and the application of electronic spreadsheet formulas and functions;
- demonstrate an understanding about electronic spreadsheet formatting techniques and the ability to apply the techniques;
- demonstrate an understanding about electronic spreadsheet chart/graph techniques and the ability to apply the techniques;
- demonstrate an understanding about electronic spreadsheet list/table techniques and the ability to apply the techniques;
- demonstrate an understanding about working with multiple electronic spreadsheets, files, and applications.
Course material
The instructor reserves the right to change the order and the time spent on any portions of this syllabus.
Course material will include the following topics:
| Topic | Approx. time |
|---|---|
| Introduction to Excel | ~ 1 week |
| Formatting a workbook | ~ 1 week |
| Charts and graphics | ~ 1 week |
| Tables, PivotTables, and PivotCharts | ~ 1.5 week |
| Multiple worksheets and workbooks | ~ 1.5 weeks |
| Advanced functions, conditional formatting, | ~ 1.5 weeks |
| and filtering | |
| Developing an Excel application | ~ 1.5 weeks |
| Financial analysis | ~ 1.5 weeks |
| What-if analysis | ~ 1.5 weeks |
| Exams | ~ 1 week |
Other topics as time permits.
Assessment
The Semester score for the course will be calculated by using the weights (%) indicated below:
| Weight (%) | |||
|---|---|---|---|
| 75% | Semester average | Tests | ______ % |
| Assignments | ______ % | ||
| _________ | ______ % | ||
| 25% | Final exam grade |
The Semester letter grade in the course will be assigned according to the scale below:
| Semester grade | Semester score |
|---|---|
| 90–100 | A |
| 80–89 | B |
| 70–79 | C |
| 60–69 | D |
| 0–59 | F |
Notes:
- In cases of an excused absence, the instructor reserves the right to reweight the final exam in lieu of a make-up test.
- In the case where a student's score on his final exam indicates exceptional achievement above and beyond that indicated by the semester average, the instructor reserves the right to reweight the value of the final exam in computing the semester grade.
Please read the Department's Attendance Policy.
Instructor's office hours
can be found on the MSU web site at
http://www.faculty.mcneese.edu
Click on individual instructor to view their web page.
Or navigate from MSU Home Page; select Faculty & Staff, select Faculty Web Server.
Students should visit the MSU web page at
http://www.mcneese.edu/policy/diversity.htm
for information about diversity awareness and sexual harassment policies and
procedures, as well as the Americans with Disabilities Act.
Students should also visit the MSU web page at
http://www.mcneese.edu/integrity
for information on the Academic Integrity Policy.
ANY STUDENT WITH A DISABILITY IS ENCOURAGED TO CONTACT THE OFFICE OF SERVICES FOR STUDENTS WITH DISABILITIES IN DREW HALL, ROOM 200, VOICE (337) 475-5916, HEARING IMPAIRED (337) 475-5722. IT IS EACH STUDENT'S RESPONSIBILITY TO REGISTER WITH THE OFFICE OF SERVICES FOR STUDENTS WITH DISABILITIES WHEN REQUESTING A REASONABLE ACCOMMODATION.
One week of summer school is equivalent to 2 ½ weeks of Fall or Spring classes
DMCS
Location:
Kirkman Hall, Beauregard Drive
Mail:
Box 92340, MSU, Lake Charles, LA 70609
Phone:
(337) 475–5788,
Fax:
(337) 475–5799
e-Mail:
sbradley@mcneese.edu
