|
PELLISSIPPI STATE COMMUNITY COLLEGE |
|||||||||
|
ACCESS II CBT
|
|||||||||
|
Class Hours: 0.0 |
|
Credit Hours: 1.0 |
|
||||||
|
Laboratory Hours: 3.0 |
|
Revised: Fall 09 |
|
||||||
|
NOTE: This course is not
designed for transfer credit. |
|
||||||||
|
Catalog Course
Description: |
|
|
|||||||
|
|
Advanced database features
and applications used to search through databases, create reports, queries, macros,
and Internet features will be presented. The course is created specifically
to meet the Microsoft Certified Application Specialist program guidelines. It
is delivered through Computer Based Training materials; some basic
computer-use knowledge is required. |
||||||||
|
Entry Level Standards: |
|
|
|||||||
|
|
Basic knowledge of a
personal computer and its operation |
||||||||
|
Prerequisite: |
|
|
|||||||
|
|
OST 1007—Access I CBT or
equivalent |
||||||||
|
Textbook(s) and Other
Course Materials: |
|
||||||||
|
|
|
||||||||
|
I. Week/Unit/Topic
Basis: (Tentative Schedule) |
|
|
|||||||
|
You can take the entire
semester to complete this course as listed below. Due dates will be strictly
followed and a grade of zero will be given to work not submitted by the due
date. No late work will be accepted. If you are taking more than one CBT course, you will
need to work on two courses at the same time. (To complete two or three courses in one
semester, it is imperative that you budget your time accordingly.) (See Where
Do I Begin? section at the end of this syllabus for detailed
instructions on accessing tutorials, textbook assignments, and testing
structure.) |
|||||||||
|
|
Week |
Topic |
|||||||
|
|
1 |
Complete Introduction
Assignment and Online Entrance Exam
(if necessary) Complete and post the
Introduction Assignment as directed under Getting Started in D2L. Complete
the Online Entrance Exam in D2L. (NOTE:
If this is your second CBT course for this semester, you have already
completed these activities and should begin with Chapter 5 in the textbook.) |
|||||||
|
|
2-3 |
Complete Chapter 5 (in
textbook—Be sure you have downloaded the necessary files for completing this
course from the Shelly/Cashman Website, before beginning in the textbook.) Adding special fields to a
table; using the input mask wizard; enhancing forms with OLE fields,
hyperlinks, and subforms; adding date, memo, OLE, hyperlink and attachment
fields; updating the new fields; advanced forms techniques including
modifying forms and subforms, moving and resizing fields and labels; changing
special effects and colors; using date and memo fields in a query; view
object dependencies. Complete Access Chapter 5
Assignment—In the Lab |
|||||||
|
|
4-6 |
Complete Chapter 6 (in
textbook) Creating an application
system using macros, wizards, and the switchboard manager; creating, using,
and modifying macros; creating and using a switchboard; import data and
create a query; creating PivotTables and Pivot Charts. Complete Access
Chapter 6 Assignment—In the Lab. |
|||||||
|
|
7 |
Access 2007—Application Test
1 over Chapters 5-6 Take the first application
test in the Main Campus Testing Center over Chapters 5 and 6. |
|||||||
|
|
8-10 |
Complete Chapter 7 (in
textbook) Creating reports using
design; aligning controls; adding text boxes; grouping and updating controls;
adding and modifying a subreport; adding a date, page numbers and titles to
reports; assigning conditional values; creating mailing labels. Complete
Access Chapter 7 Assignment—In the Lab. |
|||||||
|
|
11-13 |
Complete Chapter 8 (in
textbook) Creating a form with combo
boxes, command buttons and option groups; creating a multi-page form, inserting,
modifying, and formatting a chart type; using tools in control groups. Complete Access Chapter 8 Assignment—In the
Lab. |
|||||||
|
|
14 |
Access 2007—Application Test
2 over Chapters 7-8 and Complete the Online Exit Exam in D2L. |
|||||||
|
II. Course Objectives*: |
|
|
|||||||
|
|
A. |
Demonstrate advanced features of
Microsoft Access. (I, III, VI, XI) |
|||||||
|
|
B. |
Understand advanced terminology and
concepts of database management. (III, IV, XI) |
|||||||
|
|
C. |
Use advanced Access features such as
macros, wizards, and switchboard manager. (I, III, V, IX) |
|||||||
|
|
D. |
Use advanced Access features to create
customized forms and reports. (I, III, V, IX) |
|||||||
|
|
E. |
Demonstrate proficiency using realistic
database applications and strength ability to proofread, explore associated
database concepts, and use decision-making skills. (I, VIII, IX, X, XI) |
|||||||
|
*Roman numerals after
course objectives reference goals of the OST program. |
|||||||||
|
III. Instructional
Processes*: |
|
|
|||||||
|
Students will: |
|
|
|
||||||
|
|
1. |
Use technology to promote the
objectives of this course; specifically, the Internet, email, and database
management. Technological Literacy Outcome |
|||||||
|
|
2. |
Use email to communicate
problems, questions, and issues to instructor. Communications Outcome |
|||||||
|
|
3. |
Using a personal computer,
browser software, and the Internet, read and respond to tutorials on how to
use the application packages presented in this course to gain user
proficiency. Technological Literacy Outcome, |
|||||||
|
|
4. |
Use
the skills and applications taught in the SAM 2007 Training tutorials in
actual work required in exercises that simulate real-world applications. Transitional Strategies |
|||||||
|
|
5. |
Download applications from the
Web and install the applications on the student's personal computer to
complete research activities required in exercises. Active Learning
Strategy |
|||||||
|
*Strategies
and outcomes listed after instructional processes reference TBR’s goals for
strengthening general education knowledge and skills, connecting coursework
to experiences beyond the classroom, and encouraging students to take active
and responsible roles in the educational process. |
|||||||||
|
IV. Expectations for Student Performance*: |
|
|
|||||||
|
Upon
successful completion of this course, the student should be able to: |
|||||||||
|
|
1. |
Use
Internet resources. (A) |
|||||||
|
|
2. |
Use
correspondence tool: email. (A) |
|||||||
|
|
3. |
Copy
and download files and programs. (A) |
|||||||
|
|
4. |
Instal1
wizards. (A,C) |
|||||||
|
|
5. |
Create a macro. (A,B,C,G) |
|||||||
|
|
6. |
Run macros. (A,B,C,G) |
|||||||
|
|
7. |
Modify a macro group.
(A,B,C,G) |
|||||||
|
|
8. |
Use the Access wizards.
(A,B,C,G) |
|||||||
|
|
9. |
Define an input mask.
(A,B,C,G) |
|||||||
|
|
10. |
Create lookup fields.
(A,B,C,G) |
|||||||
|
|
11. |
Create
and use a switchboard. (A,B,C,G) |
|||||||
|
|
12. |
Create advanced forms and
reports using combo boxes and buttons. (A,B,D,G) |
|||||||
|
|
13. |
Create and use PivotTables
and PivotCharts. (A,B,D,G) |
|||||||
|
|
14. |
Use shared databases. (A,B,E,G) |
|||||||
|
|
15. |
View object dependencies. (A, B, E) |
|||||||
|
|
16. |
Create and print mailing labels. (A, B, E) |
|||||||
|
|
17. |
Add calculations to advanced forms and
reports. (A, B, E) |
|||||||
|
|
18 |
Insert, modify and format charts in
advanced forms. (A, B, E) |
|||||||
|
|
19. |
Create custom input masks. (A,B,F,G) |
|||||||
|
|
20. |
Add hyperlinks and export to HTML.
(A,B,F,G) |
|||||||
|
*Letters after performance expectations reference the course objectives
listed above. |
|||||||||
|
V. Evaluation: |
|
|
|||||||
|
|
A. Testing Procedures: 70 % |
||||||||
|
|
A.
Two
examinations will be given in this course for grade determination: (1)
Application
Exam 1 over Chapters a5-6. (35 percent). (2)
Application
Exam 2 over Chapters 7-8. (35 percent) These two tests will count as 70
percent of the total grade for the course |
||||||||
|
|
B.
Laboratory Expectations: |
||||||||
|
|
N/A |
||||||||
|
|
C.
Field Work: |
||||||||
|
|
N/A |
||||||||
|
|
D.
Other Evaluation Methods: 30% |
||||||||
|
|
·
20
percent—Four In-the-Lab assignments will be completed from the textbook. Each
assignment must be submitted before the due date. No late work will be accepted after due date and a grade of zero
will be recorded for unsubmitted assignments. Be sure to check course
calendar for designated due dates. ·
10
percent—Successful completion and posting of the Introduction assignment in
D2L by designated due date. Online Entrance Exam and Exit Exam grades
completed by due dates. |
||||||||
|
|
E.
Grading Scale: |
||||||||
|
|
The final grade will be
determined by averaging the scores on the SAM 2007 Assessment and Training theory/application
tests (90 percent) and on the above mentioned other evaluation methods (10
percent) according to these standards: A
93-100 |
||||||||
|
VI. Policies: |
|
|
|||||||
|
|
A.
Attendance Policy: |
||||||||
|
|
Pellissippi State expects
students to attend all scheduled instructional activities. As a minimum,
students in all courses (excluding distance learning courses) must be present
for at least 75 percent of their scheduled class and laboratory meetings in
order to receive credit for the course. Individual
departments/programs/disciplines, with the approval of the vice president of
Learning, may have requirements that are more stringent. In very specific
circumstances, an appeal of the policy may be addressed to the head of the
department in which the course was taken. If further action is warranted, the
appeal may be addressed to the vice president of Learning. (Pellissippi
State Online Catalog) |
||||||||
|
|
B.
Academic Dishonesty: |
||||||||
|
|
Plagiarism,
cheating, and other forms of academic dishonesty are prohibited. Students
guilty of academic misconduct, either directly or indirectly through
participation or assistance, are immediately responsible to the instructor of
the class. In addition to other possible disciplinary sanctions which may be
imposed through the regular Pellissippi State procedures as a result of
academic misconduct, the instructor has the authority to assign an F or a
zero for the exercise or examination or to assign an F in the course. (Pellissippi
State Online Catalog) |
||||||||
|
|
C.
Accommodations for disabilities: |
||||||||
|
|
Students who need accommodations because of a disability, have
emergency medical information to share, or need special arrangements in case
the building must be evacuated should inform the instructor immediately,
privately after class or in her or his office. Students must present a
current accommodation plan from a staff member in Services for Students with
Disabilities (SSWD) in order to receive accommodations in this course.
Services for Students with Disabilities may be contacted by going to Goins
134 or 126 or by phone: 694-6751(Voice/TTY) or 539-7153. More information is
available at www.pstcc.edu/departments/swd/. |
||||||||
|
|
D.
Other: |
||||||||
|
|
Computer Usage
Guidelines: College-owned or -operated
computing resources are provided for use by students of Pellissippi State.
All students are responsible for the usage of Pellissippi State's
computing resources in an effective, efficient, ethical and lawful manner. (Pellissippi
State Online Catalog) Students must have a valid
PSTCC ID to be presented on demand to gain access to PSTCC facilities. A. Where Do I Begin? 1. Once you have your textbook, supplies
and hardware/software setup, you should go to http://www.pstcc.edu/online
2. Under Student Resources, click on the Log
into your courses button and login to "D2L" 3. Enter your username and password to
login. 4. Scroll to the bottom of the screen to
find your Web courses and click on OST
1008 – Access II. 5. Click on Course Content and begin with
the Getting Started module.
·
Personal
computer using the Internet to deliver the course. You will need your own
Internet Service Provider for access to the Internet. ·
Shelly/Cashman
Access 2007 Comprehensive textbook to complete In the Lab assignments. ·
Student
Data Files for use with your textbook. These can be downloaded free via the
Web at http://www.scsite.com
·
Applications
software. You will need to have the following software packages installed on
your computer to complete the course: o Windows XP or higher o An Internet browser. Internet Explorer
(browser software--free to students). You must download it from the WWW or
get it through your ISP. Minimum
browser requirements: See http://www.pstcc.edu/online/specs.html
or see Microsoft Office 2007 Professional.
(As a registered student, you can use the open computer labs at PSTCC
if you do not have this software.) |
||||||||