DAY 1:COURSE INTRODUCTION

Harish Palakurthi

harish.palakurthi@mail.wvu.edu

January 13, 2015

1

2

ARE YOU SUREYOU’RE IN THE RIGHT ROOM?

3

YOUR INSTRUCTOR:HARISH PALAKURTHI

Contact InformationWebsite: http://cs101.wvu.edu/palakurthiE-mail: harish.palakurthi@mail.wvu.eduOffice: 210K Armstrong HallOffice Hours: Fridays from 10:00AM-12:00PM

during open lab in 219 ARM

4

ABOUT THE COURSE

• The course goal is to teach data management/analysis, problem solving and critical thinking skills.

• You’ll learn how to use Microsoft Office to solve problems in a scientific or analysis-oriented context.

• CS101 is a 4-credit hour GEC-listed course.– 2 hours in lecture (twice-weekly 50-minute lectures)– 2 hours from out-of-class work (primarily MyITLab &

Homeworks)

5

COURSE POLICIES AND SCHEDULE

• A full course schedule is available athttp://cs101.wvu.edu/schedule

• The course syllabus is available athttp://cs101.wvu.edu/instructors/palakurthi/syllabus/

• Make sure that you read and are familiar with both the schedule and syllabus. You’ll be held responsible for the information they contain.

6

WEBSITE AND E-MAIL

• The main CS101 website is at:http://cs101.wvu.edu

• Our class website is at:http://cs101.wvu.edu/palakurthi

• A lot of important info will be made available on the website and through MIX e-mail.

• It’s your responsibility to be aware of all provided information.

• If you receive an e-mail requesting a reply, please respond in a timely fashion.

7

FOLLOW ON TWITTER AND FACEBOOK

• We're @wvucs101 on Twitter and wvucs101on Facebook

• Get reminders of due dates, exams, tips and other information.

WHAT YOU NEED TO HAVE:TEXTBOOK

Exploring Microsoft Office 2013 ( Vol. 1 & 2)

• Available in eText and regular print formats

• Good for reference to material covered in class

• Ties in with MyITLab

8

WHAT YOU NEED TO HAVE:SOFTWARE

9

TEXTBOOK/MYITLAB BUNDLES

10

Electronic Bundle• eBook• MyITLab

Available at:• Pearson (Online): $98.55• Barnes & Noble: $118.65• Book Exchange: $114.70

Best choice for most students.

Print Bundle• Print Books• eBook• MyITLab

Available at:• Barnes & Noble:

$174.30• Book Exchange:

$156.40

MICROSOFT OFFICE

Acceptable Versions• Office 2013 Pro/ProPlus or

Office 365 Pro/Pro Plus/Home/ Personal/University– Include Access, Excel, Word, and PowerPoint.

• Office for Mac is not OK• All WVU students can get Office 365 Pro

Plus for free– Get it at http://it.wvu.edu/services/office365/proplus

11

12

MAC OS VIRTUAL MACHINE

• By running a virtual machine, you can use Office for Windows on a Mac.

• CS101 has a free ready-to-use virtual machine at http://cs101.wvu.edu/resources/macvm/

• Bring your Mac to Open Lab this Friday and we’ll help you get the VM installed.

13

PUBLIC COMPUTER LABS

Don’t have your own computer ?

Office 2013 is installed at:• CS101 Open Lab• ITS Computer Labs• WVU Libraries public computers

14

STORING YOUR FILES

• Keep copies of all your files in a secure place!– If others use them, you might be penalized.

• If you work in a lab or other computers:– Recommended: Get a USB Flash drive or or

use cloud storage (Google Drive, Dropbox, OneDrive)

– Don’t: E-mail your files to yourself

15

GRADES:OVERVIEWAssignment Pts Each Total PtsHomeworks 6 at 50 300Participation Projects

10 at 10(complete 10 of 12)

100

Exams 1 & 2 2 at 100 200Final Exam 150 150MyITLab Required

190 at 1.316(first 190 questions answered)

290

Total 1,000

16

GRADES:BONUS POINTSOpportunity Pts Each Total PtsMyITLab Grader Bonus Projects

2 at 25(highest scoring2 of 3 projects)

50

MyITLab Bonus 10(for answering191-200 questions)

10

Total Bonus 60

17

GRADES:GRADING SCHEME

• Grades are not curved.• You can view your grades at https://cs101.wvu.edu/tools/gradebook/

Grade Letter Point ValueA 900 or moreB 800-899C 700-799D 600-699F 599 or fewer

18

Assignments

HomeworkProjects

MyITLab

19

ASSIGNMENTS:HOMEWORK PROJECTS

• There will be 6 homework projects.– 3 on Excel, 2 on Access, and 1 Problem Solving

projects with multiple parts.

• The assignments are designed to test and build your skills with using Office for data analysis.

• 20% of the grade for each project comes from short answer data analysis questions.

• Late homeworks have a 20% per day penalty, calculated based on your final score.

20

ASSIGNMENTS:MYITLAB

• MyITLab is a computer-based training system.• It simulates Microsoft Office. You’ll be asked to

complete a variety of tasks to show your proficiency with the software.

• 5 MyITLab due dates throughout the semester. • Requires MyITLab client on computer.

– Installed in CS101 Open Lab, WVU Libraries, and OIT labs

– Can be installed on home computers

21

EXAMS

• There will be 2 regular exams plus a final.– 1 on Excel, 1 on Access, and a comprehensive

final

• The exam projects directly build on the homeworks. If you do well on the homeworks, you’ll do well on the exams. The opposite also applies.

• There will usually be a review sessions for each exam. These are a great way to prepare.

22

MYITLAB REGISTRATION

• Registration instructions are at http://cs101.wvu.edu/resources/myitlab/

• Read and follow the instructions!• If you need help, go to CS101 Open Lab.

23

MYITLAB GRADING

• You must complete at least 190 questions during semester.

• You earn bonus points for completing 191-200 questions.

• There are over 220 questions in the system. You can skip a couple questions without penalty.

• Late work is worth 50% credit.

24

IN-CLASS PARTICIPATION PROJECTS

• Hands-on projects completed during class while working in small groups.

• There will be 12 projects during the class. You need to complete at least 10 of them.– Projects won’t be announced in advance.– You won’t be able to make-up missed projects

if you’re not in class.

25

ACADEMIC INTEGRITY

• Academic integrity is very important to CS101.• It’s your responsibility to know our policy. Not

reading the syllabus is not an excuse.• We’re very good at catching cheaters. If you

cheat, you will get caught and penalized.• Penalties are severe and strictly enforced.

– 1st Time: You lose 100 points, a full letter grade.– 2nd Time: You get an F for the course.

26

HOW TO AVOID VIOLATIONS

• Don’t work with other people. Homeworks are not group projects.

• Don’t share files with others, even if they claim they just want to “look” at them.

• Don’t leave your files on a public computer or anywhere else someone could take them.

• Don’t reuse files, even blank ones, because they may contain hidden details about the person who made the original file.

27

START WITH YOUROWN BLANK FILE EVERY TIME

• Never give or take a file from anyone else.• If you did not start your assignment with a

blank, empty file that you yourself created, you have cheated.

• Do not share files with friends, even if the only thing in them is an import of the starter data for the assignment.

28

ACADEMIC INTEGRITY:POLICY ACKNOWLEDGEMENT FORM

• Before you can get credit for any of your work, you must sign the CS101 Academic Integrity Policy Acknowledgement Form.

• By signing this form, you certify that you understand CS101’s policies and will abide by them.

• If you have questions, ask before signing the form.

29

GETTING ASSISTANCE ON ASSIGNMENTS

• Open Lab (in 219ARM)• M 3:30pm-9:30pm• T/W/Th 3:30pm-7:30pm• Fri 10:00am-6:00pm

• Homework Help! Videos• Open Lab Online• Extended Open Lab (G06 Lyon Tower)

• Wed 7:30pm-9:30pm

30

OPEN LAB

• Open Lab is a place for you to get help with your CS101 homework assignments.

• Open Lab is held in 219 Armstrong Hall weekdays. Hours are at http://cs101.wvu.edu/openlab.

• Start early on your assignments. Open Lab is very busy near homework due dates.

• You need to try the assignments before asking for help in open lab.

• We do not provide assistance with completing MyITLab Lessons.

31

HOMEWORK HELP! VIDEOS

• Watch and follow along as CS101 staff complete projects similar to your actual homework assignments.

• Videos and projects are posted on our website at http://cs101.wvu.edu/resources/homework/homework-help-videos/

32

OPEN LAB ONLINE

• Early in the weeks when homework assignments are due, we will offer homework help via online chat.

• Schedule and details are at http://cs101.wvu.edu/resources/help/open-lab-online/

33

ONLINE RESOURCES

On the CS101 website, you can also find:• Find-It Guides to help with homework.• Study Guides and Review Projects to

prepare for exams.

34

ACCESSIBILITY ACCOMMODATIONS

• If you have a disability, you may be entitled to special accommodations.

• Accommodations are granted by the Office of Accessibility Services. We can’t grant accommodations without their authorization.

• We need to receive notice of authorized accommodations at least one week before we are to provide them (like for an exam).

35

THINGS TO DO:ACTIVATE MYID

• WVU MyID is used for signing into the Computers in class, to record your attendance and view grades.

• If you haven’t done so already, you need to activate your MyID.

• Instructions are at http://myid.wvu.edu.• Call OIT Help Desk at (304) 293-4444 or go

to Open Lab if you need help with MasterID.

36

NEXT CLASS…

• Loot at some basic tech stuff, research tools used etc.,