100 likes | 298 Views
CPSC 203 Tutorial 20. 20 Sep, 2010. Self Introduction. Xin LIU PhD student Focusing on Computer Graphics CT hour: MS 236, 3:00-4:00 pm Wednesday Good time asking for help Email: liuxin@ucalgary.ca Homepage: pages.cpsc.ucalgary.ca/~liuxin /. Overview of CPSC 203.
E N D
CPSC 203 Tutorial 20 20 Sep, 2010
Self Introduction • Xin LIU • PhD student • Focusing on Computer Graphics • CT hour: MS 236, 3:00-4:00 pmWednesday • Good time asking for help • Email: liuxin@ucalgary.ca • Homepage: pages.cpsc.ucalgary.ca/~liuxin/
Overview of CPSC 203 • A syllabus is downloadable from blackboard • Three modules • Speadsheets (MS Excel) • Lab Quiz • Take-home Assignment • Database (MS Access) • Lab Quiz • Take-home Assignment • Programming (Alice) • Take-home Assignment
Lab Quizzes • Must be done in this tutorial in the due time • There is a review session before each quiz • Exceptional situations (sickness/special events) • Must talk to Prof. JalalKawash • Enquire about scores within 3 weeks after you receive your score
Assignments • Being done in groups of two (pairs) • Find a partner, and report grouping to me by email by Wednesday • Team spirit is encouraged • Tackle bad partners • Change one after an assignment • Change one 10 days before assignment is due • Report to me • Group of 1 or 3 (exceptional cases) • Exceptional rules applied • Enquire about scores within 3 weeks after you receive your score
Using lab computers • Get your UCIT account from IT department • You can use lab computers during CT hours • You can practice at home
Excel • Interface • Office button • Toolbar • Ribbon • Column • Row • Cell • Input data • Selection • Auto-complete • Formatting
Calculations • always start with an equal sign (=) • Immediate numbers • =3+5 • Reference to a cell • =I8+I9 • Build-in functions • SUM() • MAX() • MIN() • MEDIAN() • SD()
The end • Find your partner • See you on Wednesday