Data Unit Day Seven

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

So far the Data Portfolio has gone really well. Students are excited about their data sets and questions. Today we moved on to using these data sets to explore the questions they posed last class.

Number Crunching on the Eniac

Today I also realized I have been worrying about this too much. I was coming at this as a math major that hated statistics and absorbed as little of it as possible. I was worried about all the high end statistical analysis they need to do. Really I was making it too complicated. 

By giving them some positive experiences with data early in the unit, and steering the process of asking questions and selecting a data set they were in a position to handle the computation part of it with minimal trouble.

I have also realized there are some institutional barriers to getting this portfolio done. Some things teachers really need to think about ahead of time:

• Computer Equipment and software. Due to budget cuts we still use Office 2003. Students have had difficulty with some of the larger data sets and Excel.
• Internet filtering: Many data sets were blocked by our school filters. Also sites like Google Docs  are blocked, which is making collaboration between students difficult.
• Limited storage space on the school network makes it hard to store the datasets. 
• Many of my students do not have Internet access at home. In addition they live an hour or more away from school and staying after is not possible for many families. This is limiting their ability to collaborate outside of school. I am having to provide a lot of class time for them to write.

Bumpass Virginia - a real place

(You can see all the CS Principles documents here)

Here is the listing of what we did:

• Work with Partner: today they started looking at their data and answering their questions. Today was a half day due to Kindergarten registration so we only had 45 minutes. Several groups are having to come back to the lab to finish up.
• The prompt for the Data Portfolio rubric is:

apply computational tools and techniques to answer your questions, e.g., by finding patterns in the data, by transforming or translating the data, or by finding connections between the data and other sources of knowledge

Read More..

Data Unit Day Three

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

Today we started working with some real data sets. I want them to have some experience with a smaller data set before we start the portfolio assessment, which has them work with a data set of at least 5000 pieces of data. Were using one available from Houghton Mifflin about Crime stats. The site has several good smaller data sets that are good for practice.

Today I let them download it as a spreadsheet. I am having them start with Excel, then well try some queries on the same data using Access next class.

At this point I am not imposing questions for them to answer, I want them to try to form the questions and explore on their own. This is a bit experimental, and we may need to loop back and have them do specific queries. It will depend on how far they are able to get on their own. I think this aspect will vary year to year depending on the strengths and motivational level of your students.


Here is the listing of what we did:

• Fast Start: Discussion Board Response -->  The other day you were asked to keep track of when you and you family used data and information. What did you discover?
• An Unusual Incident Worksheet (Heres the instructions and the answer)
• Excel Tutorial (yes, we still use Office 2003)
• Crime Data Set

Read More..

Data Unit Day Six

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

Today we finally started working on the Data Portfolio. Today the focus is selecting a data set and creating the questions. My plan is next class they start really working with the data.

From the national Archives - the intent was a photo of a mine,  but found this instead  Toilet at head of stairs leading from basement in vacant house of company housing project. Industrial Collieries Corporation, Barrackville #41 Mine, Barrackville, Marion County, West Virginia., 06/13/1946 - hilarious!

They were really engaged in this today. I let them choose three people they would like to work with, and three they would not. I then assigned partners based on these requests. It was pretty funny, every student either selected them self as someone they want to work with or someone they did not want to work with. We all had a good chuckle at this.

The list of what we did is below. They really chose some interesting data sets. Many chose to start with Data.gov and search from there. Some of the topics they have chosen:

• Israel Palestine
• Traffic Fatalities as relate to Speeding
• Crime Statistics
• Government Spending in the US
• Average Income per State
• Violent Crime Rates
• Mining accidents

The mining accidents was a bit of a head-scratcher, but it has turned out to be pretty interesting.

(You can see all the CS Principles documents here)

Here is the listing of what we did:

• Fast Start:

1. Do the Partner Selection survey 
2. From the work we did before break describe the kinds of question we can answer with data? What kinds of questions can not be answered?

• Journal Response: Building your Questions - Today we are building your questions about data. With your partner brainstorm 3 areas you would like to investigate with data. The link we used last class to some data sets is below.
• Meet with teacher to discuss data set selection - we discussed:
• What is the source?
• Is it at least 5000 pieces of data?
• Do you think this data set can answer your questions? How?
• Journal Response: Develop a set of 3&5 questions that will be the focus of the investigation and submit them here. 
• Online: Submit your dataset link
• Start writing: They started on the collaborative part of the paper.
• The first part of your paper will include: (this is from the data portfolio rubric)
• Overview of your investigation: a description of the intent of the investigation and how it will be used to gain insight and knowledge;
• The set of 3 to 5 questions that you will answer.
• Explanation and justification of how the data and other sources used in your investigation (if any) are appropriate for exploring and answering the questions.
• Information about the data set(s): a description of each data set; the URL of the data set; the date on which you accessed the data; and where possible a reference to the data set from  a written work (e.g., an article, book, or blog post).
• Type these out in word and submit the file here. ALL partners must have a  copy of this file and submit it before leaving today.

Read More..

Preparing for pitch day

Preparing for Pitch Day. Im am preparing for Pitch Day, Pitch Day is when I go and pitch my idea to a school board and they ask questions and think my idea is good or not. For Pitch Day I need to have a video to show to them that shows my idea. I need to make the video about computers and Im going to talk about my way Im going to build computers. In order to be ready I still need to make a video and figure out how Im going to explain my idea. I also need to probably post a little bit more on my blog so look out for that. I may or may not need to but still look out for more posts in the future I might try to put a calendar for when they come out to so. Thats a little bit about pitch day.

Read More..

Data Unit Day Two

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

Today we are diving into data.

Coloring

The idea is to get a bit more specific and build some vocabulary around data. We also started looking at our first data sets and talking about what they could be used for.

I started by asking them what they thought the difference is between data and information. They had some great responses, including:

Data is the hard code in a computer, the numbers, the statistics.

Information is the actual wording of what we as people know. 

Data is something that has no format. Information has been converted into audio, text, or video. Data is more scientific. 

Data is raw, unorganized facts that need to be processed. Data can be something simple and seemingly random and useless until it is organized.When data is processed, organized, structured or presented in a given context so as to make it useful, it is called information. 

After they copied the notes (topics listed below) They did a coloring activity to show the difference between analog and digitized data. They blended two colors using colored pencils then took a digital picture of the color they created. They used the Paint program to zoom in and look at the individual pixels of color the camera captured.

Next we looked at some small data sets and I had them pose questions about the data. After that they completed the Exit Ticket.



Here is the listing of what we did:

• Fast Start:
• Discussion Board Entry: What do you think is the difference between data and information?
• Notes: Data 
• These covered:
• data  vs information
• connected back to the binary we did in unit 1 and that data is stored in binary
• Data compression
• Analog vs Digital
• NPR article on MP3 Compression
• Activity: color! 
• Data Sets - with a partner 
• You will hand in one sheet of paper. Grab a tablet for your group.
• Navigate to:Data Sets
• With a partner pick one of the data sets from this website...brainstorm at least five questions you could answer using this data set. 
• When done - look at the website here . Which of these are data sets? How could you gather information from these sets of data? What problems might you run into?
• Exit Ticket Day 2 
• Do you use data in your life (outside of school?) If so how?
• How about information?

Read More..

Computer Science Education Week Day 1

Happy Computer Science Education Week!

Here are a couple of videos to celebrate:

• Grace Hopper Explains a nanosecond
• CSEd Week Videos - Todays Theme: Computer Science and Entertainment

Here in the lab we are doing recruitment activities all week. Tomorrow we are inviting freshmen in to visit. The plan is to show off some student work, then have some of the Finch Robots out for folks to try using the Snap interface.

Today the Intro to Programming kids will be starting a Careers in Computer Science project and working on some animations.

We also have ice cream.

Read More..

Short day learn Caps Lock key question mark and TAB key

Today you only have a 1/2 day of school (the teachers still have to work a full day...be sure to think of us when youre out riding your bike or playing with your friends this afternoon!), and so we are going to use the shortened time to learn 3 new keys.  They are the Caps Lock key (L4), the question mark (Left shift + R4), and the TAB key (L4).

There is a vocab quiz tomorrow so please prepare yourself accordingly.

Read More..

Catch up day

Today we are going to use to catch up with whatever you dont have done.  Here are some possibilities:

Crossword puzzle 1-6
Any formatting activity that has been due during the 4th quarter (FA2 - FA8)
Wiki spaces definitions
Vocab quiz make ups (Quizzes 6 - 8)
Spring Break blog post

If you have been doing what has been asked and you have everything completed you have three choices:

Practice websites
Read a book
Homework from another class

As Ive stated before, it is important for you to get your assignments submitted as any score you receive would be much better than a zero.  For those with missing assignments youll notice that your grade dramatically improves once you turn in an assignment that had previously been scored as a zero and score points - depending on the assignment and your grade sometimes as much as one whole letter grade!

Read More..

Celebrate the International Day of teh Girl with

Some Great Computer Science Resources

I just stumbled across the Tech Girls Website, and as they point out Oct 11 is the International Day of the girl.

They have a great list of resources - very complete.

Read More..

Data Unit Day Four

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

We only had half a class today. As a part of the CS Principles Pilot we have to do pre and post surveys about the course and that ate up a lot of teaching time.

Their activity for the rest of class was to start forming questions around data.

Data is Big Idea III: Data and information facilitate the creation of knowledge. 

A. People use computer programs to process information to gain insight andknowledge.

1. Computers can be used to find patterns in, and test hypotheses about, digitally represented information.
2. Insight and knowledge can result from translating and transforming digitally represented information.

B. Computing facilitates exploration and the discovery of connections ininformation.

1. Big Data (use of large datasets) provides new opportunities and new challenges for extracting information and knowledge.
2. Scalability, of systems and analytical approaches, is an important consideration when datasets are large.
3. Metadata can increase the effective use of data or a dataset by providing additional information about various aspects of that data.

C. Computational manipulation of information requires consideration ofrepresentation, storage, security, and transmission.

1. There are trade-offs involved in the many possible ways to represent digital and non-digital information as digital data.
2. Data is stored in many formats depending on its characteristics—such as size and intended use—so that it can be manipulated computationally.

Again, be careful. Only one of the Key Concepts mentions Big Data. There is a lot of talk about the Big Data aspects of CS Principles. Yes, the students need to work with big data as a part of the portfolio, but not everything in data needs to be BIG.

(You can see all the CS Principles documents here)

We are on Srpring Break next week, so I am trying to get them ready so when we get back they can finish the Data Portfolio item.

Today I had them work with a partner with the crime data set from last class and come up with five questions they might answer with the data. 

Talk about unexpected results. I had assumed it was obvious what kinds of questions we could answer with a data set. How many times have you done this as a teacher? Made an assumption about what they knew and then were totally surprised by the results.

This is one of the major benefits of regular journaling as a part of the course. It helps you spot these underlying assumptions early and correct them.

Having them write out questions very quickly showed who was on the tight track and who needed some more direction. In general I got two types of questions.

First type of question: 

• Is the funding for the local police departments increasing or decreasing within the small cities?
• What types of violent crimes were committed?

Second type of question: 

• Does higher amounts of college education result in lower crime rate? 
• Does an increase in annual police funding relate to educational level?

See the difference between the two?

Many of the students were asking questions for more data, or information not given in the spreadsheet.

This shows that we need to talk a little bit before we start this part of the unit about what kinds of questions can and cannot be answered with data sets. The first set of questions are really more for reporters, not statisticians. Our focus here is really looking for connections and correlations between the data already collected.

And think about what would have happened had we started right into the data portfolio. That process asks them to develop questions then find an appropriate data set to answer those questions. Clearly I need to include some instruction on what types of questions are appropriate.

My original plan was to then experiment with the same data set in a database rather than a spreadsheet and compare results. I am abandoning that idea in the interest of time. At  this point they need to start working through their portfolios. Now that I know we need to go back and talk about what kinds of questions they can ask that needs to be our focus.

Next class is a half day so I will only see them for 45 minutes. we will spend the time really looking at the questions they will develop as they start on their portfolios after break.

Read More..

Data Unit Day Five

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

Today is the end of the marking period, so we only had class for 45 minutes.

We started by posting some of the questions they developed last class about the crime data set we have been looking at. I use the LinoIt website a lot for these kinds of activities. It lets them post sticky notes on a website. Some of these questions are shown above. The advantage is you can sort the sticky notes into piles.

Next I had them read through the questions and see if they could come up with two broad categories for the questions. We had to talk it through a bit, but they decided some of the questions could be answered with the data they were given, and some needed more information.

In general this is the difference between being the original researcher and being the end user of data. For the portfolio we are the end user.

For that last part of class we watched Rick Smolans talk at the Ted Youth conference earlier this year. Skip ahead to minute 11.

When we come back from break they will be starting with their partner on the data portfolio.

Read More..

Data Unit Day 8

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

Done!

Cartoon from the National Archive 1919  - Redrawing Europes Map

Today the students finished the data portfolios.

I had been thinking this had to be a paper - it is funny in teaching, we tend to fall back to that, worksheets and papers.

When I came in today and reread the requirements I found:

A collaboratively developed artifact that communicates a detailed description of your  group’s investigation, the questions, and your collective findings.  You may use any form  of digital artifact (e.g., a report, video, presentation, visualization, or combinations of  these) that allows you to best communicate your investigation and findings.  You and  your partner will each submit the same artifact.  

So much better. Some groups did Prezis, some did Power Points. Some went ahead and wrote a paper.

They finished these with enough time to their individual reflections.

An individually written document that addresses the investigation. Each group member  must write her/his own individual document. In writing the individual document you  must adhere to the Task description above and the Requirements description below in  supplying details of your investigation.  

So with the proper setup we finished it in three class days.

Read More..

Data Unit Day One

(This is a day by day of the Data: Lets do the Numbers Unit in CS Principles. The overview is here.)

The idea is to grab their attention and get them really thinking about what data means in their lives.

I started with an activity from an Equity Workshop the CSTA held during this years SIGCSE conference.

OK - real quick. Are you a member of the CSTA? If you are reading this you should be. Go ahead - its free. Ill wait.

So the activity goes like this - turn off the monitors and grab paper and a pencil. I do this as our Fast Start, so the instructions are on the board when they walk in.

Tell them you are about to show them some data and they will respond to the following:

• What is your immediate Reaction?
• What questions do you have?

I gave them five minutes to respond on paper. Then they have five minutes to discuss with their elbow partner.

Here is the data:

Blood drive at the local high school reveals 20% of the students were HIV positive. 

I picked this because it is something every high schooler will have an opinion about. We had a blood drive this week, so they had lots of questions.

Their questions were fascinating...they wanted to know where the school was. One student hypothesized that it might be in Africa where Aids is more common.

The wanted to know who collected the data. They pointed out only kids 16 and older can give blood so that might throw the results.

Several groups also asked "is it true?" while working with their partner, but none of them were willing to ask that out loud with the whole group.

The whole point is to get them to really react to data. This is in fact not a true story - I found it on snopes.com (Snopes Article).

Then we talked about WHY they assumed it was true, or were uncomfortable questioning the truth of the data. The two reasons they gave were because their teacher told them and it had a % sign there. We all do that some time.

We then watched the Ted Talk:  Why Google wont Protect you from Big Brother

To pull everything together they did a journal entry about what we covered. I asked them to:

• Reflect on what we have talked about today
• Think about:
• Why is facebook free?
• If data can be false (like our activity) what does this mean for companies collecting data about you?
• Do you own your data?

Here is the listing of what we did:

Starting on Data
Today we are setting the stage for the Data project
• Fast Start: This activity is from the CSTA equity workshop I attended at SIGCSE last weekend
• Gallery Walk - Show off you best Code in the Browser piece (from work they did while I was @ SIGCSE)
• Ted talk - Why Google wont Protect you from Big Brother
• Look at Google transparency report
• Journal response
  • Reflect on what we have talked about today
    Think about:
    Why is Facebook free?
    If data can be false (like our activity) what does this mean for companies collecting data about you?
    Do you own your data?
• Homework - Data Log
  • Between now and next class keep track of times data is being collected about you and your family
  • As a group brainstorm times where data might be collected - what to look for

Read More..

Make up day! Everything due by the end of the day today!

If you have anything missing it will need to be turned in today by the end of the day.  My suggestion is to double check all of your quiz grades and make sure you arent missing any of those; I would also suggest looking to see if you are missing the Thanksgiving blog post (if this is missing send me an email with a link to your blog).  Lastly, the crossword puzzles are probably the next easiest to complete.  I mention those because they are easy to complete and should give you some quick points.

Beyond those two assignments if you have missing formatting activities that are partially completed you could take time today to get more of it done and then hand it in at the end of the hour.  Remember...some points is better than no points!

Tomorrow and Friday we will finish our bracket challenge!  If you are in first, second, or third hours I will not be here and the sub will be guiding you through the bracket competition.

Read More..