CSE 2337Introduction to Data Management Introduction
Overview • Syllabus • Outline • Expectations and Requirements • Overview of course materials • Data vs information • Spreadsheets vs. Databases
Course Information CSE 2337 Introduction to Data Management Blackboard URL: http://courses.smu.edu • Syllabus and Outline • Assignments • Labs • Lecture Notes
Instructor Info. Mark Fontenot Office: SIC 318 E-mail: firstname.lastname@example.org Phone: 214 768 2854 Office Hours: Tu 10:00 – 11:30 a.m. W 8:00 – 9:30 a.m. Email: 24/7
Teaching Assistant Laura Spenner E-Mail: email@example.com
Books • Lecture: • Concepts of Database Management, 5th ed.Pratt and Adamski, Course Technology • Lab: • Succeeding in Business with Microsoft Office Excel 2003: Gross, Akaiwa, Nordquist - Course Technology • Succeeding in Business with Microsoft Office Access 2003: Bast, Cygman, Flynn, Tidwell - Course Technology
Class Meetings • Lecture: Caruth 228 • MW 10 – 11 • Lecture based presentation • Lab: Patterson 214 • N11: 10 – 12 • N12: 12 – 2 • Hands-on Computer work
Exams And Quizzes • 3 exams • not cumulative • closed notes, closed book • during lecture • Quizzes • unknown number • may or may not be announced
Homework • 5 – 6 homework assignments throughout the semester • See assignment for exact due dates • All in Microsoft Word • download the Word document and add your solutions to this document. DO NOT delete the questions. • Upload completed assignments to Blackboard
Lab Assignments • Assignment files can be downloaded from Blackboard • Due in 2 parts • Pre-Lab Due Thursday @ 10:00 am before lab • Lab due Saturday @ 10:00 p.m. • Completed Assignments must be uploaded to the appropriate Blackboard folder • separate folder for pre-lab and lab for each week
Late Assignments • Late Assignments are not accepted except in extreme cases. • See Prof. Fontenot • Bring an Excuse • If possible, get permission before • Work ahead – submit early!!
Course Outline go to outline
Academic Honesty • All work is required to be your own • Do not work in groups on any graded assignment unless explicitly stated as acceptable • Penalties are severe • You may work together on anything non-graded • study for tests • review lecture notes • … See Outline for more info
Attendance Policy • Lecture • Attendance is necessary for success • You’ll gain knowledge not found in the texts • Lab • Attendance is mandatory • no lab attendance = no lab grade for that week See Outline for more info
Data Management • What is data management? • What organizations need data management?
Why do we need management techniques? • Would we have an international credit card system? • Would we be able to use cell phone internationally? • How do they charge and track your calls? Where is that info stored? • How does NTTA manage toll-tag charges and fines?
Why do we need management techniques? • To quickly search for information • To analyze data quickly • Forecasting • Prediction • Mine for information that we didn’t even know we didn’t know. • Perform calculations on massive data sets very quickly
This class and data • Part I • Excel and Data Analysis • Part II • Access and Data Management Emphasis on Practical and Useful Skills with Access and Excel
Material Excel Databases Lab Excel Databases Lecture Week 0 Week 16
Blackboard http://courses.smu.edu If you’ve never used it before: SMU ID and Password
For Wednesday • Read pp 2 – 65 • Should be a review of Excel topics that you are familiar with from EMIS 1305 or other pre-req classes • Quiz on Wed • Will not cover this chapter in Lab