Cpt 170 microcomputer applications Syllabus
|
Instructo=
r |
|
Phone |
(803) 822-6196 |
|
Office |
Lexington Hall,&nb=
sp;
Room 123 |
E-mail |
bouldrick=
d@midlandstech.edu |
|
Office Ho=
urs |
M W: =
10:05
a.m. - 12:05 p.m. T TH:
10:00 a.m. - 12:00 p.m. &nbs=
p;
Friday: By
appointment only |
Credit Hrs. |
3.0 |
|
PREREQUISITES: |
RDG 100,=
MAT
100 |
|
TEXT: MATERIALS NEEDED: |
Marquee Series Microsoft Office 2007 XP, by: Rutkosky/Seguin/Rutkosky. 2008. Paradigm
Publishers. ISBN#: 978-0-76382-694-9. Student
Resources CD (provided with textbook) USB flash
drive |
|
COURSE DESCRIPTION:
This course introduces microcomputer applications software, including word
processing, databases, spreadsheets, graphs, and their integration.
STUDENT COMPETENCIES:
Upon successful completion of this course, the student will be able to perf=
orm
the following tasks:
- Identity
the parts and the interoperability of an office software suite contain=
ing
word processing, spreadsheet, database and presentation software
capabilities.
- Identify
the purpose and applications of an office software suite containing wo=
rd
processing, spreadsheet, database and presentation software capabiliti=
es.
- Produce
a business letter, business memo, resume', and one-page outline using =
word
processing software.
- Produce
a dynamically linking spreadsheet data and graphs.
- Produce
a spreadsheet with formulas and graphs. A typical application would be
household budget with monthly total and yearly averages for several ca=
tegories.
- Apply
an appropriate graph type for given data in a spreadsheet—pie ch=
art,
bar graph, etc.
- Identify
the components of a relational database: fields, records and tables.
- Identify
basic considerations when developing a database.
- Develop
a simple database with one table and enter data into that table.
- Produce
simple reports from an existing database.
- Add,
delete and change records within an existing database and understand t=
he
consequences of those actions.
- Understand
the benefits of using presentation software.
- Produce
a multi-slide presentation using presentation software.
- Browse
and conduct simple searches on the internet to find specific sites and
topics.
- Produce
a simple web document with links, send and receive e-mails.
Classroom Policies and Procedures:
ÿNo eating, drinking, or smoking in classroom.
ÿBeepers and cell phones must be silent: DO
NOT BEGIN A PHONE CONVERSATION DURING CLASS!! IF YOUR PHONE VIBRATES DURING
CLASS, QUIETLY LEAVE THE ROOM AND TAKE YOUR CALL. FAILURE TO DO SO WILL RES=
ULT
IN THE STUDENT BEING ASKED TO LEAVE AND BEING COUNTED ABSENT!!!
ÿText
Messaging: Text messaging is =
not
allowed during class. Failure to comply will result in the following action=
(s):
1.
1st offense-verbal warning
2.
2nd offense-student dismissed from class-c=
ounted
as absent
3.
Each time you are caught texting after the first offe=
nse,
you will be asked to leave the class and be counted as absent for class
attendance.
ÿOnly enrolled students may attend class.
ÿStudents are expected to arrive to class on time.
ÿALL work must be clearly identified (name, lesson, and
date).
ÿ Disresp=
ectful
behavior will NOT be
tolerated. ÿStudents are NOT
allowed to check or send personal e-mails during class. ÿStudents are NOT
allowed to surf the net during =
class.
ÿFailure t=
o comply
with e-mail and internet usage will result in same action as text messaging
listed above! &nb=
sp; =
GRADING SYSTEM:
The final grade will be computed as follows: 40%
Tests (5) &nbs=
p; 40%
Skill Assessments /Marquee Challenge Assignments 10% Homework/Quizzes 10%
Final Exam GRADING SCALE A 94 - 100=
B<=
/span> 87 ̵=
1; 93 C<=
/span> 78 ̵=
1; 86 F<=
/span> 0 - 77 <=
/span> TESTS: All tests are announced in advance;
therefore, students are allowed only one makeup =
test
per semester. ACADEMIC INTEGRITY: Academ=
ic
integrity questions should be resolved by consulting the Student Code as
documented in the Midlands Technical College Student Handbook. All issues of
academic dishonesty will be referred to the director of Campus Life. ATTENDANCE POLICY: Students are expected to attend all class sessions.=
Record keeping for attendance purp=
oses
will begin the first day the class meets. If a student must be absent, it is
the student’s responsibilit<=
/b>y
to notify the instructor as quickly as possible of the absence and complete
missed assignments as a result of the absence. Students may not miss more=
than twice the number of days the class
meets per week. After exceeding this limit, the instructor may take extenua=
ting
circumstances (e.g. withdrawing student from course). Campus
Emergency PROTOCOL: Students and emp=
loyees
are asked to report safety concerns or suspicious activities to Campus Secu=
rity
at 7199(on campus), or 738-7199 (cell phone and o=
ff
campus). In the event of an emergency, student and employee protocol is to
immediately call Campus Security or local 911. If an emergency occurs,
employees and students may seek additional information and instructions via=
MTC
Information Centers, email, college Intranet, the MTC website, campus voice
mail and loud speakers. Tentative course schedule; instructor reserves the ri=
ght to
change schedule. All Assignments not completed in class =
must
be completed for homework. Week Class<=
o:p> Unit/Section Assignment(s) 1 M Class
Orientation Windows
XP, Section 1: Ex=
ploring
Windows XP All Activities Knowledge Check p. 12 Skills Review 1 & 2 p. 13 Skills Assessments 1 & 2 p. 14=
W Windows
XP, Section 2: Ma=
intaining
Files and Customizing Windows All Activities Knowledge Check p. 41 Skills Review 1-7 p. 43-44 Skills Assessments 1-4 p. 45-46 F Internet
Explorer 7.0, Section 1: Browsing
the Internet Using Internet Explorer 7.0 All Activities Knowledge Check p. 12 Skills Review 1-2 p. 13 2 M Word,
Section 1: Creati=
ng and
Editing a Document All Activities Knowledge Check p. 25 Skills Review 1-3 p. 26-27 W Word,
Section 1: Creati=
ng and
Editing a Document Marquee
Challenge 1-2 p. 30-32 Due
by end of class F Word,
Section 2: Format=
ting
Characters and Paragraphs All Activities 3 M Word,
Section 2: Format=
ting
Characters and Paragraphs All Activities Knowledge Check Skills Review 2 p. 58-59 Skills
Assessments 2-3 p. 60-61 Due
by end of class W Word,
Section 3: Format=
ting
and Enhancing a Document All Activities Knowledge Check p. 89 Skills Review 2-3 p. 90-91 F Word,
Section 3: Format=
ting
and Enhancing a Document Skills
Assessment 1&3 p. 92-93 Marquee
Challenge 1&2 p. 93-96 Due
by end of class 4 M Word,
Section 4: Format=
ting
with Special Features All Activities Knowledge Check p. 123 Skills Review 2,3, 5 p. 125-127 W Word,
Section 4: Format=
ting
with Special Features Skills
Review 2, 3, 5 p. 125-127 Due
by end of class F Word Unit Test 5 M Excel,
Section 1: Analyz=
ing
Data Using Excel All Activities Knowledge Check p. 27 Skills Assessment 1-2 W Excel,
Section 1: Analyz=
ing
Data Using Excel Marquee
Challenge 1&2 p.31-32 Due
by end of class F Excel,
Section 2: Editin=
g and
Formatting Worksheets All Activities Knowledge Check p. 59 Skills Review 1 p. 60 6 M Excel,
Section 2: Editin=
g and
Formatting Worksheets Skill
Assessment 2 p. 61 Marquee
Challenge 1 p. 63 Due
by end of class W Excel,
Section 3: Using
Functions, Setting Print Options, and Adding Visual Elements All Activities Knowledge Check p. 90 Skills Review 1-2 p. 91 F Excel,
Section 3: Using
Functions, Setting Print Options, and Adding Visual Elements Skills
Assessment 2 -3 p. 92-93 Marquee
Challenge 1 p. 95 Due
by end of class 7 M Excel,
Section 4: Workin=
g with
Multiple Worksheets, Formatting Sheet Tabs All Activities Knowledge Check p. 121 Skills Review 1&3 W Excel,
Section 4: Workin=
g with
Multiple Worksheets, Formatting Sheet Tabs Marquee
Challenge 1-2 p. 127-128 Due
by end of class F Integrating
Word and Excel All Activities 8 M Integrating
Word and Excel Skills
Review 1-3 p. 142 Due
by end of class W Excel Unit Test F Access,
Section 1: Mainta=
ining
Data in Access Tables All Activities Knowledge Check p. 27 Skills Review 1-2 p. 27-28 9 M Access,
Section 1: Mainta=
ining
Data in Access Tables Marquee
Challenge 1-2 p. 31-32 Due
by end of class W Access,
Section 2: Creati=
ng
Tables and Relationships All Activities Knowledge Check p. 56 Skills Review 1-2 F Access,
Section 2: Creati=
ng
Tables and Relationships Skills
Assessment 1-3 pp. 59-60 Due
by end of class 10 M Access,
Section 3: Creati=
ng
Queries, Forms, and Reports All Activities Knowledge Check p. 89 Skills Review1-3 W Access,
Section 3: Creati=
ng
Queries, Forms, and Reports Marquee
Challenge 1-2 p. 94-95 Due
by end of class F Access,
Section 4: Summar=
izing
Data and Calculating in Forms and Reports All Activities Skills Review p. 121-122 11 M Access,
Section 4: Summar=
izing
Data and Calculating in Forms and Reports Skill
Assessment 1, 3 Due
by end of class W Access Unit Test F Integrating
Word, Excel, and Access All Activities 12 M Integrating
Word, Excel, and Access Skills
Review 1-5 p. 140-141 Due
by end of class W PowerPoint,
Section 1: Prepar=
ing a
Presentation All Activities Knowledge Check p. 27 Skills Review 1 p. 28 F PowerPoint,
Section 1: Prepar=
ing a
Presentation Marquee
Challenge 1-2 p. 31-32 Due
by end of class 13 M PowerPoint,
Section 2: Editin=
g and
Enhancing Slides All Activities Knowledge Check p. 57 Skills Review 1 p. 57-58 W PowerPoint,
Section 2: Editin=
g and
Enhancing Slides Skills
Review 2 p. 59 Due
by end of class F PowerPoint,
Section 2: Editin=
g and
Enhancing Slides Marquee
Challenge 1-2 p. 63-64 Due
by end of class 14 M PowerPoint,
Section 3: Custom=
izing
a Presentation All Activities Knowledge Check p. 88 Skills Review 1-3 W PowerPoint,
Section 3: Custom=
izing
a Presentation Skill
Assessment 2 p. 92 Marquee
Challenge 1-2 p. 94-97 Due
by end of class F PowerPoint Unit Test=
15 M Integrating Word, Excel, and PowerPoint All Activities W Integrating
Word, Excel, and PowerPoint Skills
Review 1-3 Due
by end of class F Integration Test 16 M Review
Marquee Series 2007
COMPUTER TIME: Approximately six to eight ho=
urs
per week of computer time outside of class is recommended for successful
completion of course requirements.
1