260 likes | 412 Views
CSE 2337 Introduction 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
E N D
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: mfonten@engr.smu.edu 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: lspenner@smu.edu
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