Archive for the ‘Int 2 Information Systems (S2)’ Category

S2 Info Systems – Spreadsheets

This week the class have been learning more about another information management program – spreadsheets.

Most of the pupils have a basic understanding of spreadsheets already, but we have taken the opportunity to review some of the more advanced functions, including more complex formulae and charting.

The main task revolved around carrying out a class survey and using a spreadsheet to analyse the results. Both Jake and Gemma wrote good blog posts about the work they had done.


S2 Info Systems – Management Information Software

The class have been looking at the range of management information software available. We consider general purpose packages such as word processing, spreadsheets and email as resources which are used to share information.

This week we have been paying particular attention to word processors and spreadsheets. We watched one of the snowboard cross races at the Winter Olympics and then used this as a context for word processing a letter to Nate Holland suggesting we become his sponsor.

S2 Information Systems

This week the class have been looking at the some of the strategies which need to be considered when implementing an electronic organisational information system. Pupils need to know, and be able to give details on the following strategies:

  • Network strategy
  • Security strategy
  • Backup and Recovery strategy
  • Upgrade strategy
  • Software strategy

We split the class into 2 business and each business had to work out their own strategies.  This was a great exercise and the pupils worked really well on it.


Homework – S2 Int 2 Info Systems

Name 5 pieces of information management software and write a sentence about each


Int 2 IS Homework – Tennis Essay

Please finish your tennis player essay for Tuesday 9th Feb


The Wii Tennis Challenge part 2

Both the Wii tennis tournaments (Australian Open and Wimbledon) are now finished. Well done to Andrew M for winning both.

However, this week the hard work began…

Information Systems – Gathering Data

The first job was for each Wii Tennis match official to email the results of the matches which they had recorded to the Wii Tennis Challenge Sports Desk. As well as each match result, match official also emailed the number of serves and aces scored by each player in the match. This allowed us to gather all of the data electronically at one central point.

Information Systems – Storing Data

The pupils created a spreadsheet of the data, and saved it to the server. This allowed us to look at how information is stored

Numeracy – Percentages

Pupils totalled the number of aces and the number of serves by each player. They used this information to calculate an overall percentage ace rate for each player

e.g. aces = 4, serves = 27
ace rate = 4 / 27 x 100 = 14.81%

Each pupil then added a formula to their spreadsheet to verify that they had correctly calculated the ace rate.

PE – investigation

For homework each pupil had to find out why the tennis scoring system is as it is.


Wii Tennis Challenge Homework

Homework Exercise

  1. Finish your Wii Tennis Ace percentage calculations
  2. Describe 2 ways in which we processed our Wii Tennis Data
  3. How did we check that our percentage ace calculations were correct?

Homework for Thursday 28th Jan 2009