This course will take students through the entire process for building a database system to capture, store and present information. In addition to common database concepts like design and development, students will learn how to plan and build various database objects into a fully functioning system. We will also reflect on how various types of databases interact in our personal and professional lives.
After completing this course, you will be able to:
Based upon which competence(s) you opt for, you will be able to:
In this course, you will develop the following competencies:
|
Competence |
Competence Statement and Criteria |
|
S-1-D |
Can design and plan an information technology solution for a problem. |
|
S-3-X |
Understand different perspectives on the relationship between technology and society and is able to understand approaches to solve a problem through a computing program. |
|
H-2-B |
Can use public or private institutions as resources for understanding a social issue. |
|
F-X |
Can build and use database to solve business analysis. |
To buy your books, go to http://depaul-loop.bncollege.com.
You must have a complete installation of Microsoft Office 2013 on your computer. This software suite (with MS Access) is required. As a DePaul student, you may receive a free subscription to Office 365 ProPlus, which will enable you to install Word, PowerPoint, Excel, Outlook, OneNote, Publisher, Access, and Lync for the duration of your enrollment. Please visit http://offices.depaul.edu/is/services/software/Pages/office-365-proplus-for-students.aspx for more information. You will need a University email account for this subscription.
You also have the option to purchase a copy of Office 2013 from e-academy for about $80. You will need a University email account to do so. For information about how to get an email account see the FAQ at http://www.snlonline.depaul.edu/Current/current_faq.asp#StudentService
Textbook: Microsoft Access 2013: Complete (Shelly Cashman Series)
CENGAGE Learning -- Publisher
ISBN-10: 1285169077 | ISBN-13: 978-1285169071
|
A = 95 to 100 |
A- = 91 to 94 |
B+ = 88 to 90 |
|
B = 85 to 87 |
B- = 81 to 84 |
C+ = 77 to 80 |
|
C = 73 to 76 |
C- = 69 to 72 |
D+ = 65 to 68 |
|
D = 61 to 64 |
F = 60 or below |
INC |
Please note: Grades lower than a C- do not earn credit or competence in the School for New Learning.
This course consists of 10 modules. The time to complete each module/unit is one week.
| Week, Module # and Title |
Readings |
Assignments |
|---|---|---|
Week 1, Module 1: Introduction to Database Development
|
Read Intro to Microsoft Office (pOFF1-OFF64) If you have Office 365, please also review CLD1-CLD15 Read Module Content 1 (Why use Access over Excel for managing and presenting information) Read file "Module 1 - DVD Collection Example" Additional Resources: Open and examine Demo Database Program in Microsoft Access 2013 |
1.1 Introductions Discussion 1.2 Saying Yes! To Databases Discussion 1.3 Pre-study and pre-quiz |
Week 2, Module 2: Database Objects - Fields and Tables
|
Read text Ch1 (pAC1-AC72) Read Module Content 2 (Object Types: Tables and Fields) Read file "Module 1 - DVD Collection Example" Open "Module2 - Movie and Director Tables Example" file |
2.1 Database Objects Group Discussion 2.2 Build some fields and tables in Access |
Week 3, Module 3: Database Relationships
|
Read text Ch1 (pAC9) Read Module Content 3 (Data, the Relational Way) Read file "Module 3 - Relationships Examples" Read "Module 3- An Addendum" Read:Understanding Access Relationships |
3.1 Database Relationships Group Discussion 3.2 Relationships between tables |
Week 4, Module 4: Queries - Asking Questions of Your Data |
Read Text Ch2 (pAC73-AC135) Read Module Content 4 (Asking Questions Of Your Data) Read file: "Module 4 - Queries Examples" |
4.1 Database Queries Discussion 4.2 Building Queries in Access |
Week 5, Module 5: Reports - Displaying Information for Users
|
Read Text Ch4 (pAC201-AC233) Read Module Content 5 (Displaying Information for Users) Read file:"Module 5 - Reports Example" E-Reserves Reading: "Enhancing Queries and Reports with Visualizations" by M. Alexander |
5.1 Database Report Group Discussion 5.2 Build Reports in Access |
Week 6, Module 6: Controlling User Experience |
Read Text Ch4 (pAC233-AC264) Read Text Ch5 (pAC265-AC327) Read Text Ch4 (pAC233-AC264) Read Text Ch5 (pAC265-AC327) Read Text Ch7, (pAC427-AC430, Command Buttons) Read Module Content 6 (Controlling the User Experience with Forms) Read file "Module 6 - Form Examples" |
6.1 Database Forms Discussion 6.2 Build Forms in Access |
Week 7, Module 7: Putting it all together |
Read Text Ch3 (pAC137-AC159) Read Module Content 7 (Turning Concepts Into a System) Read file: “Module 7 - Navigation Form Examples” |
7.1 Database Navigation Group Discussion 7.2 Build Navigation Forms in Access
|
Week 8, Module 8: Putting it all together |
8.1 Projects Discussion 10.1 Database Project |
|
Week 9, Module 9: Project Week 2
|
9.1 Projects Discussion 9.2 Draft of Final Project Begin All Competences |
|
Week 10, Module 10: Final Project and Papers Due
|
10.1 Database Project 10.2 Final Competence Paper: Typical milestones found in each level of a software development lifecycle 10.3: Final Competence Paper: Data for investigating a social issue using public or private institutions 10.4 Final Competence Paper: Relationships between technology and society 10.5 Final Competence Paper: Critical needs for a business to run a database
|
To see course due dates, click on the Checklist link on the top navigation bar. This page contains module-specific checklists and due dates for the work due in the course.
| Grading Category | % of Final Grade |
|---|---|
| Weekly Discussions | 25% |
| Weekly Assignments | 35% |
| Final Project | 20% |
| Competence Specific Discussion and Paper | 20% |
| Total | 100% |
To complete the course, you must complete each of the assignments as described in the course and submit them to your instructor by the assigned deadline. In addition, you must participate in the course discussion forum by responding to all instructor requests and by interacting with fellow classmates as necessary.
Points are deducted for late work.
All writing assignments are expected to conform to basic college-level standards of mechanics and presentation.
Consider visiting the Writing Center to discuss your assignments for this course or any others. You may schedule appointments (30 or 50 minutes) on an as–needed or weekly basis, scheduling up to 3 hours worth of appointments per week. Online services include Feedback–by–Email and IM conferencing (with or without a webcam). All writing center services are free.
Writing Center tutors are specially selected and trained graduate and undergraduate students who can help you at almost any stage of your writing. They will not do your work for you, but they can help you focus and develop your ideas, review your drafts, and polish your writing. They can answer questions about grammar, mechanics, different kinds of writing styles, and documentation formats. They also can answer questions and provide feedback online, through IM/webcam chats and email.
Obviously, the tutors won’t necessarily be familiar with every class or subject, but they are able to provide valuable help from the perspective of an interested and careful reader as well as a serious and experienced student-writer.
Schedule your appointments with enough time to think about and use the feedback you’ll receive. To schedule a Face-to-Face, Written Feedback by Email, or Online Appointment, visit www.depaul.edu/writing.
Discussion Forums are an important component of your online experience. This course contains discussion forums related to the topics you are studying each week. For requirements on your participation in the Discussion Forums, please see "Course Expectations" in the syllabus.
A Course Q & A discussion forum has also been established to manage necessary, ongoing social and administrative activities. This is where the management and administrative tasks of the course are conducted, and where you can ask 'process' questions and receive answers throughout the course. Please feel free to answer any question if you feel you know the answer; this sharing of information is valuable to other students.
This course includes and adheres to the college and university policies described in the links below:
Academic Integrity Policy (UGRAD)
Academic Integrity Policy (GRAD)
Course Withdrawal Timelines and Grade/Fee Consequences
Accommodations Based on the Impact of a Disability
Protection of Human Research Participants
APA citation format (GRAD)
University Center for Writing-based Learning
This syllabus is subject to change as necessary. If a change occurs, it will be clearly communicated to students.
This course was designed and produced by Todd Hover and staff at SNL Online of the School for New Learning of DePaul University.
©2011 School for New Learning, DePaul University. All Rights Reserved by SNL during contractual interval with the Author.