1 / 17

CSE 103

CSE 103. Section 002: M/W 10:20am-12:10pm 216 Berkey Hall Section 004: T/R 10:20am-12:10pm 1210 Anthony Hall. CSE 103: Introduction to Information Technology. Section 002 (602): Lead: Jo Assistant: Erica Section 004 (604): Lead: Carl Assistant: Brian. Overview of CSE 103.

lbyrd
Download Presentation

CSE 103

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSE 103 Section 002: M/W 10:20am-12:10pm 216 Berkey Hall Section 004: T/R 10:20am-12:10pm 1210 Anthony Hall

  2. CSE 103: Introduction to Information Technology • Section 002 (602): • Lead: Jo • Assistant: Erica • Section 004 (604): • Lead: Carl • Assistant: Brian http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  3. Overview of CSE 103 • Builds on CSE 101 • Similar course structure • no lectures, all classes in microlabs • cooperative learning • mastery model evaluation • Bridge Tasks! • UBT http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  4. Intro to Information Technology • Focus on databases • Access 2000 • Creation and modification of large databases • Storage and retrieval of information • Database design • MySQL • Data retrieval and modification • Dynamically-driven Web sites • Acquisition and storage of information via Web pages • Basis of e-commerce http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  5. CSE 103 • Five bridge tasks (BTs) • 1.0, 1.5, 2.0, 2.5, 3.0 • Each BT passed raises grade 0.5 • Maximum of Twelve attempts • Review 101 materials from the CSE 101 Web site (www.cse.msu.edu/~cse101) http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  6. Office Hours • Helprooms … TBA • Carl’s office hours in Engineering 1107 • Tentative: Tuesday 1:00-2:00 p.m. • and by appointment • Instructor’s office hours in EB 1107 • M W 3:00-5:00 p.m. • T R 2:00-4:00 p.m. • and by appointment http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  7. Course Web site • The URL for the course Web site is http://www.cse.msu.edu/~cse103 • You are welcome to look at the CSE 101 Web site for review purposes • Be sure you know how to use AFS (personal vs. public space) • Review using HandIn software from FAQs • http://www.cse.msu.edu/~cse101 • Select any track; it doesn’t matter. http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  8. E-mail • Do not send e-mail to cse101! It will be ignored. • If you need help or have questions, e-mail your Lead and Assistant (that way if one is gone, the other can answer): • Lead: 103taXX@cse.msu.edu (XX is two-digit section number) • Assistant: 103ataXX@cse.msu.edu • Instructor e-mail (unavoidable absences on BT days, problems your Lead can’t solve, etc.):cse103@cse.msu.edu http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  9. Fair Warnings • This class is substantially harder than 101 • If you don’t come to class, you won’t do better than a 2.5 • If you don’t do the homework and reading, we will waste valuable class time, leaving you behind on the BT • Staff will not waste time reviewing for 1-2 students, so you may be lost in class as well • If you don’t understand something, ask questions in-class or by e-mail http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  10. What is a database? What databases can you think of? • Non-electronic: rolodex, phone book • Database software: Excel*, Access, Oracle, MySQL • Electronic databases in general: Web search engines (Google), product catalogs (Amazon), library catalogs (Magic), etc. http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  11. Excel as a database • How do you use a spreadsheet as a database? • There is an example of an Excel database in the course AFS space. • Today is Day01, so the files are in that folder • Copy the musicdata01.xls spreadsheet to your personal AFS space • Open the spreadsheet http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  12. Correcting Data • Add two bonus tracks to Tom Lehrer's album Revisited • Track 14 namedL-Y with length 2 minutes, 11 seconds • Track 15, Silent E, length 1 minute, 31 seconds • You won’t know the digital filesizes; leave them blank • Album Lincoln by They Might Be Giants has the wrong label • Replace Elektra/Asylum with Restless Records • The artist named Natalie McMaster is entered incorrectly-- should be spelled Natalie MacMaster. Correct this. • Note how many changes you have to make http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  13. Access databases • Copy the musicdemo01.mdb database to your personal AFS space • Open the database • Open the table tbl_tracks • How does it differ from the Excel file? • Run the query qry_TrackList • How does this output differ from the Excel file? http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  14. Correcting Table Data • Add two bonus tracks (with MP3s) to the re-release of Tom Lehrer's album Revisited • Track 14 namedL-Y with a length of 2 minutes, 11 seconds • Track 15 namedSilent Ewith a length of 1 minute, 31 seconds • Order does not matter! • The album Lincoln by They Might Be Giants has the wrong label • Replace Elektra/Asylum with Restless Records • The artist named Natalie McMaster is entered incorrectly. Her name should be spelled Natalie MacMaster. Correct this. • Note how many changes you have to make http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  15. Spreadsheet vs. Database • How many entries had to be corrected in the database as opposed to the spreadsheet? How many tables were involved? • Run the query qry_TrackList again • How does the output compare to that of the Excel exercise? • Discuss the similarities and differences http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  16. Homework • Follow the homework for next class link on today’s classwork page or the homeworklink on the Daily Class Materials page to get the homework assignment • Read Days 1 and 3 in the textbook • We'll be skipping around a bit, so always check the Web Homework link for the correct reading assignment http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

  17. Survey on the Web • Please fill out the first day survey via the link on today’s classwork page • It helps us to gauge goals and prior knowledge, to tune course for future semesters • Possibly even some of the days after the midterm of this semester! http://www.cse.msu.edu/~cse103 U:/msu/course/cse/103

More Related